Oracle 19c Database Installation (on Linux 7.6) on VMware Workstation

#

Description

Command / Details / Screenshots

1.1

let’s create a staging directory for all oracle software

Login to server as oracle

1.2

Create a new staging directory

• What is the Staging Directory?

  • It is temporary directory to stage the software

mkdir -p /data/staging/19C

Note: If you are getting “permission denied” error when trying to create /data/staging/19C directory, be sure to login as root and execute the following before attempting to create a directory again.

1. Login as root

2. Change Permission and owner on /data  with -R (Recursive) option

   1. chmod -R 755 /data
   2. chown –R oracle:oinstall /data

3. Change user to oracle

   1. su – oracle 

2. Create Directory to stage oracle software

mkdir -p /data/staging/19C

3. and proceed to next step

1.3

Verify directory is created

ls -ld /data/staging/19C

1.4

cd /home/oracle

vi .bash_profile

Add the following content in .bash_profile file

# .bash_profile

# Get the aliases and functions
if [ -f ~/.bashrc ]; then
. ~/.bashrc
fi

# User specific environment and startup programs

# User specific environment and startup programs

export ORACLE_BASE=/data/app/oracle
export ORACLE_HOME=/data/app/oracle/product/19C/dbhome_3

export ORACLE_SID=prim

export LD_LIBRARY_PATH=\$ORACLE_HOME/lib:/lib:/usr/lib
export CLASSPATH=\$ORACLE_HOME/jlib:\$ORACLE_HOME/rdbms/jlib

PATH=$PATH:$HOME/.local/bin:$ORACLE_HOME/bin

export PATH

#

Description

Command / Details / Screenshots

1.5

Login at Oracle site.

If you do not have login, Sign up for a free account.

Login: 

https://www.oracle.com/in/database/technologies/oracle19c-linux-downloads.html

Signup @ https://profile.oracle.com/myprofile/account/create-account.jspx?

1.6

Click on icon and click on Sign-in

1.7

Provide your username (your email address) and password that you used to sign up. 

Click Sign in.

1.8

Go to download section of databases

Scroll down to section 19.3 – Enterprise Edition (also includes Standard Edition 2) Linux x86-64

 and click on See all

1.9

Click on LINUX.X64_193000_db_home.zip  

You may be prompted to accept the license

1.10

At this point, the download should start. If you are using chrome, then you can see this at the bottom of the screen.

1.11

(Winscp)

 winSCP the oracle 19c database software from your windows machine to linux machine 

——-Login to the server with your hostname and user credentials 

 Click Login

Click yes 

Drag and drop  the 19c software to our staging directory /data/staging/19C

———Linux file transferred to the staging Directory

1.12

Verify zipfile is transferred to the staging directory

cd /u99/software/12c/DB

ls -ltr

1.13

Before unzip create ORACLE_HOME directory 

Unzip the software into newly created ORACLE_HOME 

By -d flag 

mkdir -p /data/app/oracle/product/19C/dbhome_3

ls -ld /data/app/oracle/product/19C/dbhome_3

Hi

unzip LINUX.X64_193000_db_home.zip -d /data/app/oracle/product/19C/dbhome_3

Note: 

If you are getting unzip is not found, run “yum install unzip -y” as root in a new session and come back to this session and execute the command again..

1.14

Once unzip is completed, you should see screen like following → 

1.15

runInstaller (program to install oracle) resides. 

cd /data/app/oracle/product/19C/dbhome_3

1.16

Before unzip create ORACLE_HOME directory 

Unzip the software into newly created ORACLE_HOME 

By -d flag 

mkdir -p /data/app/oracle/product/19C/dbhome_3

ls -ld /data/app/oracle/product/19C/dbhome_3

unzip LINUX.X64_193000_db_home.zip -d /data/app/oracle/product/19C/dbhome_3

Note: 

If you are getting unzip is not found, run “yum install unzip -y” as root in a new session and come back to this session and execute the command again..

#

Description

Command / Details / Screenshots

2.1

Start Xming on laptop if not already started

2.2

Login to server as oracle with X-11 enabled.

whoami

2.3

enable X 11 forwarding on putty

Set x Display location to the following 

localhost:0

2.4

Change directory to ORACLE_HOME

cd /data/aoo.oracle/product/19C/dbhome_3

pwd

ls -ltrh

2.5

Execute runInstaller to begin Oracle 19c installation

./runInstaller

Press y when prompted. 

2.6

Let’s wait for few seconds…

2.7

step 1 of 9

• Select “Install database software only”

• Click [Next]

2.8

Step 2 of 9

• Select “Single instance….”

• Click [Next]

2.9

Step 3 of 9

• Select “Enterprise Edition”

• Click [Next]

2.10

Step 4 of 10

• Oracle Base → /data/app/oracle

• Software Location → /data/app/oracle/product/19C/dbhome_3

• Click [Next]

2.11

Step 5 of 10

• select all to “default groups ”

• Click [Next]

Step 6 of 10 

Root script execution configuration

We are going to run scripts manually so click Next…..

2.12

Step 8 of 10

• OUI will start performing prerequisites

Similarly, if there are any packages that you have missed earlier and OUI has detected it, install the package as root with “yum install -y” command. Be sure you login as root. Otherwise, you will get an error.

Once installed, lets try again.

And it worked this time. I was able to move forward 

2.13

Step 9 of 10

• Click [install]

• Installation will run for a few minutes.

2.14

Step 9 of 10

• Oracle Installation begins installing binaries.

2.15

Once the installation is done, OUI will ask you run the following  scripts as root.

• /data/app/oracle/product/19C/dbhome_3/root.sh

To run as root, 

• Open new putty session as root and copy paste the following:

a./data/app/oracle/product/19C/dbhome_3/root.sh

Step 10  of 10

Click [ok]

Next

Click{close}

2.16

Oracle 19c software installation done and logs are saved 

#

Description

Command / Details / Screenshots

3.1

Login to Server as oracle

(MAC Users: Make sure to do this in XQuartz)

3.2

Type “dbca” to start Database Configuration Assistance

3.3

Step 1 of 15

You will see the following window for few seconds before the Oracle Universal Installer starts. 

•  
•  
•  
•  
•  
•  
•  
•  
•  
•  
•  
•  

• Click On “Create a database”

• Click [Next]

3.4

Step 2 of 15

• Click on “Advance Configuration”

• Click [Next]

3.5

Step 3 of 15

• Keep database type to “Oracle Single Instance Database”

• Use “General Purpose” template

• Click [Next]

3.6

Step 4 of 15

• Global Database Name: 

  • TESTDB

• SID

  • TESTDB

• check “Create as container Database”

• Click [Next]

3.7

Step 5 of 15

• Select “Use the following for the database ….”

• Click [Next]

3.8

keep Select Fast Recovery Option same as Screenshot

• Click [Next]

3.9

Step 7 of 15

• Keep the listener same as screenshot

• Click [Next]

3.10

Step 8 of 15

• Keep all unselected

• Click [Next]

3.11

Step 9 of 15

• Select on “Use Automatic Shared Memory Management

  • SGA = 1102

  • PGA = 360

• [Click Next]

3.12

Step 10 of 15

• Deselect everything on EM options

• Click [Next]

3.13

Step 11 of 15

• Provide password. Password I have given is abc123. Although this kind of password is not recommended, I wanted to show you the error you will get if password is not strong.

• Click [Next]

3.14

Step 12 of 15

• Select “Create Database”

• Select “Save as database template”

  • Provide the template name as “MyFirstDBTemplate”

• Select “Generate database creation scripts”

”

3.15

Step 13 of 15

• Click on “Save Response File”

•  
•  
•  
•  
•  
•  
•  
•  
•  
•  
•  
•  
•  
•  
•  
•  
•  
•  
•  
•  
•  
•  
•  
•  
•  
•  
•  
•  
•  
•  
•  
•  

• Click on “Save” when prompted on a new window.

•  
•  
•  
•  
•  
•  
•  
•  
•  
•  
•  
•  
•  
•  
•  
•  
•  
•  
•  
•  
•  
•  
•  
•  
•  
•  
•  
•  
•  
•  
•  
•  
•  
•  

• Click [Finish]

3.16

Step 14 of 15

• Progress page will start. It will show the progress. Be patient even if it is stuck on 0%. It will complete as long as you have not made any error.

• DO NOT hit cancel. 

3.17

Step 15 of 15

• Click [Close]

3.18

Let’s verify if the instance is all good to be tested.

• Login to server as oracle

• Verify pmon process for TESTDB is working

  • ps -ef | grep pmon

• Set Oracle Environment to TESTDB

  • . oraenv → TESTDB

• Login as sys

  • sqlplus / as sysdba

• show user

• Select status from v$instance;

• Select systimestamp from dual;

• !hostname