{"id":3774,"date":"2021-11-05T08:00:00","date_gmt":"2021-11-05T05:00:00","guid":{"rendered":"https:\/\/www.dataplatform.gr\/?p=3774"},"modified":"2022-07-18T00:23:44","modified_gmt":"2022-07-17T21:23:44","slug":"pos-kanoyme-mia-kainoyrgia-egkatasta","status":"publish","type":"post","link":"https:\/\/www.dataplatform.gr\/en\/pos-kanoyme-mia-kainoyrgia-egkatasta\/","title":{"rendered":"How to do a fresh installation of Oracle Database on Linux"},"content":{"rendered":"

In this article we will see step by step how to install Oracle Database 19c on Unix and more specifically on Oracle Linux \/ Red Hat. <\/p>\n\n\n\n

The prerequisites<\/h2>\n\n\n\n

To begin with we should have a graphical environment either by connecting directly to the machine, or by using a terminal that allows to bring up a graphic like mobaXterm<\/a>.<\/p>\n\n\n\n

To download the files we need to install Oracle Database, click here<\/a>.<\/p>\n\n\n\n

Then we will have to install the required libraries on our operating system. To do this we run the following:<\/p>\n\n\n\n

curl -o oracle-database-preinstall-19c-1.0-2.el8.x86_64.rpm https:\/\/yum.oracle.com\/repo\/OracleLinux\/OL8\/appstream\/x86_64\/getPackage\/oracle-database-preinstall-19c-1.0-2.el8.x86_64.rpm\n\nyum -y localinstall oracle-database-preinstall-19c-1.0-2.el8.x86_64.rpm\n<\/code><\/pre>\n\n\n\n
Then we need to go to SELINUX setting below and change the value to permissive<\/strong>:<\/p>\n\n\n\n
sudo vi \/etc\/selinux\/config\n\n\nSELINUX=permissive ##\u03b1\u03bb\u03bb\u03ac\u03b6\u03bf\u03c5\u03bc\u03b5 \u03b1\u03c5\u03c4\u03ae \u03c4\u03b7 \u03c4\u03b9\u03bc\u03ae<\/code><\/pre>\n\n\n\n
As a next step, stop and disable the firewall:<\/p>\n\n\n\n
systemctl stop firewalld\nsystemctl disable firewalld<\/code><\/pre>\n\n\n\n
If we didn't already have a user on the operating system oracle<\/em><\/strong> we should set the password for it:<\/p>\n\n\n\n
passwd oracle\n<\/code><\/pre>\n\n\n\n
Finally, we create the folder that will contain the Oracle binaries and give the Oracle user access to the root folder that will contain them and our data:<\/p>\n\n\n\n
mkdir -p \/oracle\/app\/oracle\/product\/19.3.0\/dbhome_1\n\nchown -R oracle:oinstall \/oracle\nchmod -R 775 \/oracle<\/code><\/pre>\n\n\n\n
After finishing the prerequisites, reboot the server.<\/p>\n\n\n\n
The installation<\/h2>\n\n\n\n
When the machine restarts we log in as a user oracle<\/em><\/strong>:<\/p>\n\n\n\n
su oracle<\/code><\/pre>\n\n\n\n
Go to the folder we made before that will be the Oracle binaries and unzip the Oracle Database files we downloaded:<\/p>\n\n\n\n
cd \/oracle\/app\/oracle\/product\/19.3.0\/dbhome_1\n\nunzip -oq \/home\/oracle\/Downloads\/LINUX.X64_193000_db_home.zip\n<\/code><\/pre>\n\n\n\n
Before running the setup, because in this particular case the Oracle Linux 8 version is not yet supported, in order not to have a warning message during the installation, we run the following so that it behaves as if it were version 7.6:<\/p>\n\n\n\n
export CV_ASSUME_DISTID=OEL7.6<\/code><\/pre>\n\n\n\n
Now we are ready to run the setup:<\/p>\n\n\n\n
.\/runInstaller<\/code><\/pre>\n\n\n\n
After a while the graphical environment will appear, there we will choose to install only the binaries (Set Up Software Only) and we will create a base later:<\/p>\n\n\n\n
\"\"
01<\/figcaption><\/figure>\n\n\n\n
We choose that it will be a Single Instance and not a cluster:<\/p>\n\n\n\n
\"\"
02<\/figcaption><\/figure>\n\n\n\n
We define the folder above product as Oracle Base:<\/p>\n\n\n\n
\"\"
03<\/figcaption><\/figure>\n\n\n\n
We define the user oracle <\/em><\/strong>as the administrator in all groups:<\/p>\n\n\n\n
\"\"
04<\/figcaption><\/figure>\n\n\n\n
We choose to run the scripts that are needed automatically by selecting the checkbox and adding the password of the root or sudo user:<\/p>\n\n\n\n
\"\"
05<\/figcaption><\/figure>\n\n\n\n
In the next step it will show us that it may be missing, in this particular case I have 500mb less swap memory so I choose to ignore it:<\/p>\n\n\n\n
\"\"
06<\/figcaption><\/figure>\n\n\n\n
In the last step of the installation we do a quick check that we have set the right parameters:<\/p>\n\n\n\n
\"\"
07<\/figcaption><\/figure>\n\n\n\n
After the installation is complete, for the user to have oracle <\/strong><\/em>the information with its path and environment and not having to go through it again by hand by exporting we can put it in the file bash_profile <\/em><\/strong>the profile<\/em><\/strong>.<\/p>\n\n\n\n
To do this we go to the user's home directory oracle<\/strong><\/em> and edit the corresponding file:<\/p>\n\n\n\n
cd $HOME\nvi .bash_profile\n\n\n<\/code><\/pre>\n\n\n\n
There we add the following entries:<\/p>\n\n\n\n
export ORACLE_BASE=\/oracle\/app\/oracle\nexport ORACLE_HOME=\/oracle\/app\/oracle\/product\/19.3.0\/dbhome_1\nexport ORACLE_SID=oradev1\nexport TNS_ADMIN=$ORACLE_HOME\/network\/admin\n\nexport NLS_LANG=AMERICAN_AMERICA.AL32UTF8\nexport PATH=$PATH:$ORACLE_HOME\/bin\nexport CLASSPATH=$ORACLE_HOME\/jlib:$ORACLE_HOME\/rdbms\/jlib\n\nexport LD_LIBRARY_PATH=$ORACLE_HOME\/lib:\/lib:\/usr\/lib\n<\/code><\/pre>\n\n\n\n
As ORACLE_SID <\/strong><\/em>we define the name of the instance we will connect to, which we will create in the next steps. It's just an opportunity to define it from now on, don't forget that we can have multiple instances so the one we connect to is defined by this variable:<\/p>\n\n\n\n
\"\"
08 <\/figcaption><\/figure>\n\n\n\n
To get the changes without rebooting, run the following:<\/p>\n\n\n\n
source ~\/.bash_profile<\/code><\/pre>\n\n\n\n
Creating the base<\/h2>\n\n\n\n
After we finished the installation it's time to fix it instance <\/em><\/strong>with our base.<\/p>\n\n\n\n
So to do this and start the wizard that will guide us, we run the following command as oracle <\/em><\/strong>user:<\/p>\n\n\n\n
dbca<\/code><\/pre>\n\n\n\n
After a while the following wizard will appear. There we choose Advanced configuration<\/em><\/strong>:<\/p>\n\n\n\n
\"\"
09<\/figcaption><\/figure>\n\n\n\n
In the next step we choose Oracle Single Instance database<\/em><\/strong> and General Purpose<\/strong><\/em>:<\/p>\n\n\n\n
\"\"
10<\/figcaption><\/figure>\n\n\n\n
Next we define the base name<\/strong> and name of the instance<\/strong>, in this case oradev and oradev1 respectively. We also remove the checkbox so that it is not created as a container database:<\/p>\n\n\n\n
\"\"
11<\/figcaption><\/figure>\n\n\n\n
Then we choose where we want the data files to be saved, choosing multiplex<\/strong> redo<\/strong> logs<\/strong> and<\/strong> cont<\/strong>rol<\/strong> files<\/strong><\/em> we can have a copy of each redo and control file in a separate location (for each redo log group):<\/p>\n\n\n\n
\"\"
12<\/figcaption><\/figure>\n\n\n\n
In the next tab we set the path for the Fast Recovery Area <\/strong><\/em>and its size as we also enable archiving so that we can have an online backup:<\/p>\n\n\n\n
\"\"
13<\/figcaption><\/figure>\n\n\n\n
In the next step we choose to create the listener <\/em><\/strong>to allow remote access to the base:<\/p>\n\n\n\n
\"\"
14<\/figcaption><\/figure>\n\n\n\n
On the next screen we have to define a series of tabs.<\/p>\n\n\n\n
In Memory <\/em><\/strong>define the memory that will be occupied by the instance, changing the total size of the memory will define a ratio for the SGA and PGA memory (the use of each one is detailed here<\/a>):<\/p>\n\n\n\n
\"\"
15<\/figcaption><\/figure>\n\n\n\n
In the Character sets <\/em><\/strong>select Unicode, AL16UTF16 and America American (not Greek):<\/p>\n\n\n\n
\"\"
16<\/figcaption><\/figure>\n\n\n\n
We choose Next <\/em><\/strong>and remove the option to set Enterprise Manager for monitoring:<\/p>\n\n\n\n
\"\"
17<\/figcaption><\/figure>\n\n\n\n
We do a final check that we have set the correct options:<\/p>\n\n\n\n
\"\"
18<\/figcaption><\/figure>\n\n\n\n
We choose Finish and after a while when the installation is complete we will be able to connect to our database with sqlplus<\/em><\/strong>:<\/p>\n\n\n\n
sqlplus \/ as sysdba\n\nselect status from v$instance;<\/code><\/pre>\n\n\n\n
\"\"
19<\/figcaption><\/figure>\n\n\n\n
Sources:<\/h2>\n\n\n\n