Install and Startup of Oracle DB

Mat David
7 min readSep 26, 2021

Install the Database Infrastructure (Oracle Stack)

Link https://www.oracle.com/middleware/technologies/fusionmiddleware-downloads.html,
Download software : LINUX.X64_193000_db_home.zip.

The following prerequisite Installs has to complete based on your OS. The OS version I used :
uname -a
Linux oracleiam.db.com 4.14.35–1902.3.2.el7uek.x86_64 #2 SMP Tue Jul 30 03:59:02 GMT 2019 x86_64 x86_64 x86_64 GNU/Linux

cat /etc/hosts
127.0.0.1 localhost localhost.localdomain localhost4 localhost4.localdomain4
::1 localhost localhost.localdomain localhost6 localhost6.localdomain6
<your VM ipaddress> oracleiam.db.com

sudo yum install xorg-x11-server-Xorg xorg-x11-xauth xorg-x11-apps -y
sudo yum install -y oracle-database-preinstall-19c
sudo yum install xorg-x11-utils -y

Modify your bash profile to match that shown below based on your environment.

vi /home/oracle/.bash_profile
export TMP=/tmp
export TMPDIR=$TMP
export ORACLE_HOSTNAME=oracleiam.db.com
export ORACLE_UNQNAME=orcl
#iamdb1
export ORACLE_BASE=/u01/app/oracle
export ORACLE_HOME=$ORACLE_BASE/product/19.3.0/dbhome_1
export ORA_INVENTORY=/u01/app/oraInventory
export ORACLE_SID=orcl
#iamdb1
export PDB_NAME=iampdb1
export DATA_DIR=/u02/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
#export PATH

mv LINUX.X64_193000_db_home.zip stage/
cd stage/
unzip -oq /home/oracle/stage/LINUX.X64_193000_db_home.zip
./runInstaller

Click Next

Choose Enterprise Edition and click Next on the Step 3 of the DB install screen.

Choose the path for the oracle base. Click Next.

Choose path for the Inventory directory. Choose Oracle as the Group Name.

On step 5, check the group names from the OraInventory Group.

On the step 6 group privileges, choose as shown. Click Next

On step 7, choose the Automatically run scripts and click Next.

On step 8 if the prerequisite screen, make sure all are a pass. If you see any errors, fix those before proceeding. Ignore the warnings.

On the step 9 of the DB install screen, you can save the response to a file for future reference and then click the Install button.

Wait for the Install to complete.

When the pop up to execute the script shows, in a new terminal execute the scripts as root. Once executed successfully. Click on the OK button.

Step 11 should show that the execution was successful. Click on the close button on the Finish screen.

We will configure the database with the help of the next few screens. Execute the dbconfig.sh as shown from your install step.

Choose Create a database and click Next.

On the step 2 of Create a database, choose Advanced Configuration & click Next.

On the Create a database screen, choose Single Instance Database, choose General Purpose or Transaction processing and click Next.

On the step 4 of the config screen, choose as shown below or customise to you need. For the purposes of Lab, don’t choose PDB, uncheck the Create a Container database . Click Next.

Choose File System for database storage option type, enable the Oracle Managed File (OMF).
Click Next on the Storage Option and Fast Recovery Option screens.

Set the Recovery files storage type drop-down list to File System.
Browse to Fast Recovery Area field, and select the database files recovery location.
From the Fast Recovery Area size drop-down list, select the size of the database files recovery area.

Enable the Enable archiving checkbox, and then click Next.

On the NetWork Configuration screen, Enter the Listener name :LISTENER. Leave the default port (1521) and Click Next.Click Next on the Storage Option and Fast Recovery Option screens. On the NetWork Configuration screen, Enter the Listener name :LISTENER. Leave the default port (1521) if not enter it and Click Next.

For database vault, leave the Configure Oracle Vault disabled.

On the configuration options Sizing, set the processes sizing to 1024. From the Character set tab, select Use Unicode (AL32UTF8) as the character set.

Click next on the optional Management options.

On screen 11, enter the password for SYS, Sysadmin and PBAdmin. For development purposes, enter the same password. Enable the option button Use the same administrative password for all accounts and enter and confirm the administrative password, and then click Next.

On the Creation option, choose the Create database option.

Click Next , check the summary page (no edits required ) and Click Finish and installation progresses.

On the Finish screen click close to complete the install.

Repository Creation Utility

We will use the RCU utility to create the repository for OAM install and configuration. Execute the script.

On step 1 of the RCU, screen click Next.

On step 2, choose Create Repository option as shown.

On step 3 enter your choice of Host Name, leave the port 1521. Choose the service name that was created when the DB was installed. Enter sys as username and Role as SYSDBA. Choose a password easy to remember for the purposes of the lab.

Click the Next button on Step 3.

The RCU checks for prerequisites, if all are successful, then it moves to step 4.

On step 4, choose Oracle Access Manager (Oracle Identity Manager is not required for the Access Manager lab). Some of the Mandatory components cannot be deselected (*) . Note the prefix and click Next.

The pop up below shows the progress of different components being installed. Once it is complete click on the ok button. Then Click Next.

On Step 5, choose an easy to remember password for the schema. Click Next.

Step 6 should create those schema and table space. On the popup, click OK once the execution is successful. Click Next.

Click OK on the pop up to create table space and click Next.

You have successfully created the table spaces and ready to install the Access Manager component.

Start the DB listener with the command.

lsnrctl start

LSNRCTL for Linux: Version 19.0.0.0.0 — Production on 25-SEP-2021 12:48:27
Copyright © 1991, 2019, Oracle. All rights reserved.
Starting /u01/app/oracle/product/19.3.0/dbhome_1/bin/tnslsnr: please wait…
TNSLSNR for Linux: Version 19.0.0.0.0 — Production
Log messages written to /u01/app/oracle/diag/tnslsnr/oracleiam/listener/alert/log.xml
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=oracleiam.db.com)(PORT=1521)))
Connecting to (ADDRESS=(PROTOCOL=tcp)(HOST=)(PORT=1521))
STATUS of the LISTENER
- — — — — — — — — — — -
Alias LISTENER
Version TNSLSNR for Linux: Version 19.0.0.0.0 — Production
Start Date 25-SEP-2021 12:48:27
Uptime 0 days 0 hr. 0 min. 1 sec
Trace Level off
Security ON: Local OS Authentication
SNMP OFFListener Log File /u01/app/oracle/diag/tnslsnr/oracleiam/listener/alert/log.xml
Listening Endpoints Summary…
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=oracleiam.db.com)(PORT=1521)))
The listener supports no services
The command completed successfully

sqlplus / as sysdba
SQL*Plus: Release 19.0.0.0.0 — Production on Sat Sep 25 12:49:35 2021
Version 19.3.0.0.0
Copyright © 1982, 2019, Oracle. All rights reserved.
Connected to an idle instance.
SQL> startup
ORACLE instance started.
Total System Global Area 5335153640 bytes
Fixed Size 8907752 bytes
Variable Size 939524096 bytes
Database Buffers 4378853376 bytes
Redo Buffers 7868416 bytes
Database mounted.
Database opened.

--

--

Mat David

I am an Identity & Access Management Consultant. My tech. writing interests are IAM (Forgerock, Oracle,Auth0,OKTA ). https://iamsolution.ca; info@iamsolution.ca