Oracle 19c : Manually Install Oracle Database Software and setup listener for Single Instance

+++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
Oracle 19c : Manually Install Oracle Database Software, setup listener and Create an empty Container Database for Single Instance
+++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
Assumption:

You already created all the required OS users (example: oracle), group (oinstall) directories (example: $ORACLE_BASE, $ORACLE_HOME)

Step 1: Download Oracle Software from edelivery

Step 2: Unzip Software to the Oracle_HOME directory
unzip V981623-01.zip -d /u01/app/oracle/product/19.2.0/db100

Step 3: Create a response file by copying the response file from the response file directory

oracle@racdb01.localdomain:/u01/app/oracle/product/19.2.0/db100/install/response
$ cp db_install.rsp /home/oracle/19cEE_SoftOnly.rsp

Step4: modify response file in a text editor with necessary changes 

Step5: start the installer in silent with response file 

$ cd /u01/app/oracle/product/19.2.0/db100
$ ./runInstaller -silent -responseFile /home/oracle/19cEE_SoftOnly.rsp -noconfig -ignorePre
Launching Oracle Database Setup Wizard...

The response file for this session can be found at:
 /u01/app/oracle/product/19.2.0/db100/install/response/db_2019-02-21_09-55-47PM.rsp

You can find the log of this install session at:
 /u01/app/oraInventory/logs/InstallActions2019-02-21_09-55-47PM/installActions2019-02-21_09-55-47PM.log

As a root user, execute the following script(s):
        1. /u01/app/oracle/product/19.2.0/db100/root.sh

Execute /u01/app/oracle/product/19.2.0/db100/root.sh on the following nodes:
[racdb01]

Successfully Setup Software.


Step 6: Run root script

$ su - root
Password:
Last login: Thu Feb 21 21:59:02 AEDT 2019 from 192.168.56.11 on pts/3
[root@racdb01 ~]# /u01/app/oracle/product/19.2.0/db100/root.sh
Check /u01/app/oracle/product/19.2.0/db100/install/root_racdb01.localdomain_2019-02-21_22-10-45-968492814.log for the output of root script
[root@racdb01 ~]# cat /u01/app/oracle/product/19.2.0/db100/install/root_racdb01.localdomain_2019-02-21_22-10-45-968492814.log
Performing root user operation.

The following environment variables are set as:
    ORACLE_OWNER= oracle
    ORACLE_HOME=  /u01/app/oracle/product/19.2.0/db100
   Copying dbhome to /usr/local/bin ...
   Copying oraenv to /usr/local/bin ...
   Copying coraenv to /usr/local/bin ...

Entries will be added to the /etc/oratab file as needed by
Database Configuration Assistant when a database is created
Finished running generic part of root script.
Now product-specific root actions will be performed.
Oracle Trace File Analyzer (TFA) is available at : /u01/app/oracle/product/19.2.0/db100/bin/tfactl


Step 7: Validate the software installation 



Configure Listener

Step 1: Create a response file by copying the response file from the response file directory

$ cd $ORACLE_HOME/assistants/netca
$ cp netca.rsp /home/oracle/silent-19clsnr-config.rsp
$ chmod u+x silent-19clsnr-config.rsp

Step 2: modify response file in a text editor with necessary changes 

$ cat silent-19clsnr-config.rsp
[GENERAL]
RESPONSEFILE_VERSION="19.0"
CREATE_TYPE="CUSTOM"
[oracle.net.ca]
INSTALLED_COMPONENTS={"server","net8","javavm"}
INSTALL_TYPE=""typical""
LISTENER_NUMBER=1
LISTENER_NAMES={"LISTENER"}
LISTENER_PROTOCOLS={"TCP;1523"}
LISTENER_START=""LISTENER""
NAMING_METHODS={"TNSNAMES","ONAMES","HOSTNAME"}
NSN_NUMBER=1
NSN_NAMES={"EXTPROC_CONNECTION_DATA"}
NSN_SERVICE={"PLSExtProc"}
NSN_PROTOCOLS={"TCP;HOSTNAME;1523"}

Step 3: start the installer in silent with response file 

$ORACLE_HOME/bin/netca -silent -responseFile /home/oracle/silent-19clsnr-config.rsp


Step 4: Check listener status

$/home/oracle$ lsnrctl status

 


=================
CREATE DATABASE
=================


Step 1: Create a response file by copying the response file from the response file directory

$ cd $ORACLE_HOME/assistants/dbca
$ cp dbca.rsp /home/oracle/dbca19cSI.rsp
$ chmod u+x dbca19cSI.rsp

Step 2: modify response file in a text editor with necessary changes 

Step 3: Execute dbca in silent with response file
$ dbca -silent -createDatabase -responseFile /home/oracle/dbca19cSI.rsp


Check the defined log file -
Validate database - 

Comments

Popular posts from this blog

Oracle DataGuard – How to resize Redo Log and Standby Redo Log

Exadata - Smart Scan Testing

Exadata Flash Cache - Management