Running the Oracle server configuration script

In this step, you set up the Oracle environment by using the script that is provided with the Tivoli® Netcool® Performance Manager DataMart files on the Tivoli Netcool Performance Manager distribution.

About this task

This script automatically creates the following configuration:

Adds the dba and oinstall groups to /etc/group
Adds the login name oracle, whose primary group membership is oinstall and secondary group membership is dba.
Note: You must use the same Oracle username across all instances of Oracle Client and Server throughout your Tivoli Netcool Performance Manager system.
Creates the Oracle directory structure
Creates startup and shutdown scripts for Oracle server processes

Note:

If the oracle user isn’t created, the script creates this user for you, and ORACLE_BASE is set as the user home directory. If you would prefer to use a different home directory for the oracle user, create the oracle user before you run the script. The script doesn’t create an oracle user if one exists.

To configure the Oracle installation environment by using the script:

Procedure

As root, set the ORACLE_BASE and ORACLE_HOME environment variables.

For example:

# export ORACLE_BASE=/opt/oracle/
# export ORACLE_HOME=/opt/oracle/product/18.0.0

To check that the variable is set correctly, enter the following command:
```
# env | grep ORA
```

Change to the following directory:

systems:

# cd <DIST_DIR>/proviso/SOLARIS/DataBase/SOL<version_num>/oracle/instance

systems:

 # cd <DIST_DIR>/proviso/AIX/DataBase/AIX<version_num>/oracle/instance

systems:

# cd <DIST_DIR>/proviso/RHEL/DataBase/RHEL<version_num>/oracle/instance

where:

<DIST_DIR> is the directory on the hard disk drive where you copied the contents of the Tivoli Netcool Performance Manager 1.4.5 distribution.

Run the Oracle configuration script by entering the following command:

# ./configure_ora

The following screen is displayed:

Note: In the following display prompt, the operating system (OS) labels according to your system setup.

--------------------------------------------------
Setting the Oracle environment
<Current Date>
--------------------------------------------------
OS ........... : [ Linux 6.7.18-194.el5 #1 SMP Tue Mar 16 21:52:39 EDT 2019 ]
Host ......... : [ <Hostname> ]
Logname ...... : [ root ]
ORACLE_BASE .. : [ /opt/oracle ]
ORACLE_HOME .. : [ /opt/oracle/product/18.0.0 ]

DBA group ................. : [ dba ]
OUI inventory group ....... : [ oinstall ]
Oracle software owner ..... : [ oracle ]
 
Configure Oracle release .. : [ 18.0.0 ]
 
Menu :
   1. Modify Oracle software owner.
   2. Next supported release.
   3. Check environment.
   0. Exit
 
Choice :

Important: If permission to the $ORACLE_BASE directory isn’t granted, the install database step fails during deployment. During Oracle installation, the /opt/oracle folder that is created by configure_ora script has no permission that is granted to any other users. Therefore, after you run the configure_ora script, assign the following permission to the $ORACLE_BASE directory (for example, /opt/oracle):

On a new command prompt, log in as oracle user.
Run the following command:
```
$ chmod 755 /opt/oracle
```

Type 3 at the Choice prompt and press Enter.

The script creates the dba and oinstall groups and the ORACLE_BASE directory, unless they exist:

Checking environment...
Checking for group [ dba ] --> Created.
Checking for group [ oinstall ] --> Created.
Checking ORACLE_BASE
** WARNING
** ORACLE_BASE directory does not exist.
** [ /opt/oracle ]
**
** Create it ? (n/y) y

Type y and press Enter.

The script creates the /opt/oracle directory and continues as follows:

Checking for user [ oracle ]
** WARNING
** User [ oracle ] does not exist.
**
** Create it locally ? (n/y) y

Type y and press Enter.

The script creates the oracle user and continues as follows:

--> Created.
Checking for oracle directory tree :
[ /opt/oracle/product ] --> Created.
[ /opt/oracle/product/18.0.0 ] --> Created.
[ /opt/oracle/product/18.0.0/dbs ] --> Created.
[ /opt/oracle/admin ] --> Created.
[ /opt/oracle/admin/skeleton ] --> Created.
[ /opt/oracle/admin/skeleton/lib ] --> Ok.
[ /opt/oracle/admin/skeleton/lib/libpvmextc.so ] --> Created.
[ /opt/oracle/admin/skeleton/lib/libmultiTask.so ] --> Created.
[ /opt/oracle/admin/skeleton/lib/libcmu.so ] --> Created.
[ /opt/oracle/admin/skeleton/bin ] --> Ok.
[ /opt/oracle/admin/skeleton/bin/snmptrap ] --> Created.
[ /opt/oracle/local ] --> Created.
Checking for oracle .profile file --> Created.
Checking for dbora file --> Created.
/etc/rc0.d/K10dbora link --> Created.
/etc/rc1.d/K10dbora link --> Created.
/etc/rc2.d/S99dbora link --> Created.
Checking for dbora configuration files :
/var/opt/oracle/oratab --> Created.
/var/opt/oracle/lsnrtab --> Created.
Press Enter to continue...

Press the Enter key to continue.
The main screen is refreshed.
Type 0 and press Enter to exit the script.
Note: You must set a password for the oracle login name.