Installing Oracle 19c on Debian 12 may seem complicated, but don’t worry, I’m here to guide you in every step. In this post, I will explain to you in a simple way how to prepare your system and make the installation of Oracle 19c in Debian 12.

Update the repositories

The first thing is to update the repositories of our virtual machine and in case we don’t have any packages we update it:

Install dependencies

The following will be to install the Oracle units in our system:

      • libaio1 * *: Provides asynchronous access to E / S.
      • Unixodbc * *: It is an ODBC controller for database connectivity.
      • Bc * *: It’s an arbitrary precision calculator.
      • Ksh * *: It’s the Korn shell for scripts.
      • Gawk * *: It’s an improved version of Awk for text and data processing.

Add oracle user

We will create the dba group and create the oracle user:

We check that we can access the oracle user:

Network configuration

We have to have a static ip set up:

We also have to have an entry in the hosts file of our private address:

Download the Oracle website installation file

Once we have checked that we can install it in our system or virtual machine we will download it from your official website.

We will quickly realize that Oracle does not support Debian as we will find the package in .rpm format this means that it is prepared to be installed in network-based distributions hat.

For us to use this package we will have to transform it to .deb for it there is a tool called alien that will convert the package to us so that we can use it.

We install the tool:

Now using wget we’ll download the Oracle meta-package:

Once downloaded we will use the alien utility to transform us, this will take approximately a step to lighten the process I have transformed it into my physical machine:

We passed it to our virtual machine using scp.

Now that we have our package transformed to .deb we install it using dpkg in our virtual machine

We’ll start the installation, it’ll take a while, so you have to be patient:

Once finished in our user’s bashrc we will add the oracle environment variables, ORACLE\ _ SID will tell us at the end of the installation, the others will depend on the directory we have put in previous steps:

Error solution

Error [FATAL] [DBT-50000] Unable to check available memory

It returns an error, it tells us that you cannot check the available memory, this error can be solved by deactivating the check of configuration parameters for it in line 164 of the → / etc / init.d / oracledb\ _ ORCLCDB-19c file

We will change it to the following (complete line 164):

\ * I highlight the content you should add, you can also replace the entire line.

Another mistake you can give us is that you can’t find netstat:

It is easily solved by installing net- tools.

# ORA-65096: unvalid username or common role

If you don’t let us create a user:

With this modification let us create users

First steps with Oracle

We will connect as administrators in the database:

The first thing we have to do is create a user, give him permissions we need and check that we can connect with the:

And we give him the permits we consider to him:

Then we try to connect with it:

With this we will have completed the basic installation of Oracle 19c on Debian 12. It is recommended that if you are using the database you be installed by a client like SQLplus or SQLdeveloped.

SQLplus installation

We download the basic SQLplus package for Linux, it’s a .zip:

We download the second SQLplus package:

We create the /opt/oracle directory:

We uncompress the zip files in the directory we just created:

We get into the directory and list the content:

And then we export the SQLplus bookstore variable and run the changes:

If we want it to be maintained we will add it to the bashrc: