Oracle Database 19c Installation For OAM

Oracle Database 19c Installation on OEL 8.10

Operating System Setup

1. For Automatic Setup of Operating System Packages and Parameters, Run the following command with Root user [root@oidserver ~]# dnf install -y oracle-database-preinstall-19c

If you are using RHEL8 or CentOS8, you can pick up the RPM from the OL8 repository and install it. It will pull the dependencies from your normal repositories. 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 dnf -y localinstall oracle-database-preinstall-19c-1.0-2.el8.x86_64.rpm

2. Set the password for the “oracle” user. [root@oamserver ~]# passwd oracle 3. Set secure Linux to permissive by editing the “/etc/selinux/config” file, making sure the SELINUX flag is set as follows. SELINUX=permissive 4. Once the change is complete, restart the server or run the following command. [root@oamserver ~]# setenforce Permissive 5. Once the change is complete, restart the server or run the following command. If you have the Linux firewall enabled, you will need to disable or configure it. To disable it, do the following. # systemctl stop firewalld
# systemctl disable firewalld
6. Create the directories in which the Oracle software will be installed. [root@oamserver ~]# mkdir -p /u01/app/oracle/product/19.0.0/dbhome_1 [root@oamserver ~]# chown -R oracle:oinstall /u01/app [root@oamserver ~]# chmod -R 775 /u01 7. Create an Environment Variable file for the Oracle Database on the Oracle User Home Directory

[oracle@oamserver ~]$ vi setEnv.sh # Oracle Settings export TMP=/tmp export TMPDIR=$TMP export ORACLE_HOSTNAME=oidserver.com export ORACLE_UNQNAME=OAMDB export ORACLE_BASE=/u01/app/oracle export ORACLE_HOME=$ORACLE_BASE/product/19.0.0/dbhome_1 export ORA_INVENTORY=/u01/app/oraInventory export ORACLE_SID=OAMDB export DATA_DIR=/u01/oradata export PATH=/usr/sbin:/usr/local/bin:$PATH export PATH=$ORACLE_HOME/bin:$PATH export LD_LIBRARY_PATH=$ORACLE_HOME/lib:/lib:/usr/lib export CLASSPATH=$ORACLE_HOME/jlib:$ORACLE_HOME/rdbms/jlib [oracle@oidserver ~]$

8. Unzip Software Binaries Copy the Downloaded Database 19c Zip (V982063-01.zip) file on the /u01/app/oracle/product/19.0.0/dbhome_1 Directory [oracle@oamserver ~]$ cd /u01/app/oracle/product/19.0.0/dbhome_1 [oracle@oamserver dbhome_1]$ unzip -oq V982063-01.zip

Running Database Installer

[oracle@oamserver dbhome_1]$ export DISPLAY=192.168.1.124:0.0 [oracle@oamserver dbhome_1]$ export CV_ASSUME_DISTID=OEL7.8 [oracle@oamserver dbhome_1]$ ./runInstaller Launching Oracle Database Setup Wizard… The response file for this session can be found at:  /u01/app/oracle/product/19.0.0/dbhome_1/install/response/db_2024-11-30_10-01-36PM.rsp You can find the log of this install session at:  /u01/app/oraInventory/logs/InstallActions2024-11-30_10-01-36PM/installActions2024-11-30_10-01-36PM.log

Select Single Instance Database Installation Click Next
Select Enterprise Edition Click Next
Confirm Oracle Base Location Click Next
Select Database Administration Groups Click Next
Click Next
Click Install
Installation Started
Run the Script with Root User [root@oidserver ~]# /u01/app/oracle/product/19.0.0/dbhome_1/root.sh Click OK
Click Close

Database Creation through DBCA

[oracle@oamserver ~]$ . ./setEnv.sh [oracle@oamserver ~]$ dbca
Select Advanced Configuration Click Next
Select Oracle Single Instance database Select Template Name General Purpose or TransactionProcessing Click Next
Enter Global Database name and SID Uncheck Option Create as Container database Click Next
Click Next
Click Next
Click Next
Click Next
Click Next
Click Next
We used the Same Password for all Administrative accounts. Click Next
Click Next
Verify the settings on the Installation Summary screen. To change entries, Click BACK to the pertinent screen. Once satisfied with the settings, click the Finish button to begin the installation.
Database Creation Started
Click Close

Alter Database Parameters

SQL> alter system set open_cursors=800 scope=both; SQL> alter system set processes=1000 scope=spfile; SQL> alter system set sessions=1000 scope=spfile;

Hope you found this document informative and gained valuable insights.

    About Syed Saad

    With 13 years of experience as a certified and skilled Oracle Database Administrator, I possess the expertise to handle various levels of database maintenance tasks and proficiently perform Oracle updates. Throughout my career, I have honed my analytical abilities, enabling me to swiftly diagnose and resolve issues as they arise. I excel in planning and executing special projects within time-sensitive environments, showcasing exceptional organizational and time management skills. My extensive knowledge encompasses directing, coordinating, and exercising authoritative control over all aspects of planning, organization, and successful project completions. Additionally, I have a strong aptitude for resolving customer relations matters by prioritizing understanding and effective communication. I am adept at interacting with customers, vendors, and management, ensuring seamless communication and fostering positive relationships.

    Leave a Reply