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 install groups to /etc/group
Adds the login name oracle, whose primary group membership is dba and secondary group membership is oinstall.
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 is not 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 does not create an oracle user if one exists.

Note: It is likely that you have create the dba and install groups and the oracle user. However, this script must still be run to create the required Oracle directory structure.

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/12.1.0
```
Note: The script places this variable into the oracle login account's .profile file.

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/SOL10/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 distribution in Download the Oracle distribution to disk.

Run the Oracle configuration script by entering the following command:

# ./configure_ora

Important: If permission to the $ORACLE_BASE directory is not 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):

Log in as oracle user.
Run the following command:
```
chmod 755 /opt/oracle
```

The following screen is displayed:

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

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

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/12.1.0 ] --> Created.
[ /opt/oracle/product/12.1.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.