Installing and Running Oracle for the MPLS VPN Solution Software

Step 2 Log in to the Cisco IP Manager workstation as the root user.

Step 3 Append the following instructions to the /etc/system file:

set shmsys:shminfo_shmmax=8388608
set shmsys:shminfo_shmmin=1
set shmsys:shminfo_shmmni=100
set shmsys:shminfo_shmseg=10
set semsys:seminfo_semmns=200
set semsys:seminfo_semmni=70
set semsys:seminfo_semmsl=100

These values tune the kernel so that Oracle can use shared memory.

Step 4 Save the changes.

Step 5 To activate the kernel changes, restart the CIPM workstation.

Step 6 Log in to the Cisco IP Manager workstation as the root user.

Step 7 Run the Admin Tool to create a group and a user for Oracle access.

admintool

The Admin Tool Users window is displayed.

Step 8 From the Users window, choose Browse > Groups.

The Groups window is displayed.

Step 9 From the Groups window, choose Edit > Add.

The Add Groups window appears.

Step 10 Enter the following values, then click OK.

Group Name	dba
Group ID	any unique number

Step 11 From the Groups window, choose Browse > Users.

The Users window appears.

Step 12 From the Users window, choose Edit > Add.

The Add User window appears.

Step 13 Enter the following values, then click OK.

User Name	oracle8
User ID	any unique number
Primary Group	dba
Login Shell	C
Password	Normal password: oracle8
Home Directory	/opt/oracle/product/8.0.5

Step 14 To exit from the Admin Tool, choose File > Exit.

Step 15 Set the ownership for the Oracle directory:

chown -R oracle8:dba /opt/oracle

Step 16 Log in as user oracle8.

Step 17 Open the Oracle .cshrc file and add the following settings to the file:

setenv ORACLE_BASE /opt/oracle/product
setenv ORACLE_HOME /opt/oracle/product/8.0.5
setenv ORACLE_SID CIPM
setenv ORACLE_PATH 
	$ORACLE_HOME/bin:/bin:/usr/bin:/usr/ccs/bin
setenv LD_LIBRARY_PATH 
	$ORACLE_HOME/lib:/usr/openwin/lib:/usr/dt/lib:/usr/lib
setenv PATH .:$ORACLE_PATH

ORACLE_SID specifies the value of the system identifier (SID) for the database instance you create with the Oracle installation utility.

Step 18 Save the .cshrc file and source it.

source .cshrc

Step 19 Insert the Oracle 8.0.5 CD-ROM into the Cisco IP Manager workstation's local CD-ROM drive.

Step 20 Go to the Oracle 8.0.5 installation directory:

cd /cdrom/oracle805/orainst

Step 21 Execute the following set environment commands:

setenv TERM vt100
setenv ORACLE_TERM vt100

Step 22 Log in as root.

Step 23 Set the Oracle owner environment variable to oracle8 by entering the following command:

ORACLE_OWNER=oracle8;export ORACLE_OWNER;
 

Step 24 Run the following command:

sh /cdrom/oracle805/oratab.sh
 

Step 25 Log out from the root user.

Step 26 Log in as the oracle8 user and run the Oracle installation (in Text mode).

./orainst

Step 27 At the initial screen, select Default Install, then press Enter.

The next two screens are informational.

Step 28 Press Enter twice.

The Installation Activity Choice screen is displayed.

Step 29 Select the default option, Install, Upgrade, or De-Install Software, then press Enter.

The Installation Options screen is displayed.

Step 30 Select Install New Product---Create DB Objects, then press Enter.

The Environment Variables screen is displayed.

Step 31 Check all the environment variable settings. If all the environment variables are set correctly, press Enter.

The defaults for the environment variable settings are as follows:

ORACLE_BASE=/opt/oracle/product
ORACLE_HOME=/opt/oracle/product/8.0.5
ORACLE_SID=CIPM
 

The next screen displays the Oracle installation defaults. Press Enter.

The Software Asset Manager screen is displayed. Use the down-arrow key to move through the options. Press the Space bar to select a component.

• Net8.0.5.0.0

• Oracle Unix Installer 4.0.3.0.0

• ORACLE8 Enterprise (RDBMS) 8.0.5.0.0

• SQL*Plus 8.0.5.0.0

Step 33 When finished, press i to indicate the selected components are to be installed.

The Default Database Startup Using Prebuilt Datafiles screen is displayed.

Step 34 Press Enter.

The Database Mount Points screen is displayed. This screen includes three mount point fields.

Step 35 Type the following pathname in all three fields, then press Enter.

/opt/oracle/product/8.0.5

The Legato Storage Manager (LSM) Question screen is displayed.

Step 36 Press n for No.

The Oracle installation process begins; the installation takes 15 to 30 minutes.

Step 37 When the Installer Actions Completed screen appears, press Enter.

Step 38 Exit the Oracle installation.

a. Go to the /var/opt/oracle directory.

b. Open the oratab file with a text editor.

c. This file consists of a single line:

CIPM:/opt/oracle/product/8.0.5:Y

d. If the last character in the line is not "Y," change it to "Y."

e. Save the file and exit from the text editor.

Step 2 Execute the following commands at the UNIX prompt:

su root
#	cd /opt/oracle/product/8.0.5/orainst
#	/usr/bin/sh
#	chmod a+x root.sh
#	./root.sh

Step 3 In response to the prompt, "Are these settings correct?" select Y for Yes.

Step 4 Enter the full pathname of the local binary directory:

/usr/bin

Step 5 When prompted, "Do you want to continue?" select Y for Yes.

Step 6 If you receive a message that the Oracle owner's "ulimit" should be raised, disregard the message.

Step 7 Exit the root shell.

Step 8 Make sure you are now operating as user oracle8.

Step 9 Execute the following commands at the UNIX prompt:

cd $ORACLE_HOME
source .cshrc
cd /opt/oracle/product/8.0.5/otrace/admin
rm *.dat

Step 10 Check to make sure Oracle is running:

ps -ef | grep ora_

You should see the following Oracle processes running:

ora_pmon_CIPM
ora_dbw0_CIPM
ora_lgwr_CIPM
ora_ckpt_CIPM
ora_smon_CIPM
ora_reco_CIPM

Step 11 If there are no running processes, start Oracle.

After Oracle installs, typically Oracle is running. But if you need to start up the database manually, enter the following commands to start the Oracle server manager:

a. Enter the following at the UNIX prompt:

svrmgrl

b. Start the Oracle server by entering the following commands at the SVRMGR> prompt:

connect internal
startup
quit

Step 12 Check to make sure the Oracle listener is running:

ps -ef | grep lsnr

You should see the following processes running:

/opt/oracle/product/8.0.5/bin/tnslsnr LISTENER -inherit

Step 13 If the Net8.0.5.0 listener process is not running, start it as follows:

lsnrctl start

mkdir /opt/oracle/product/8.0.5/data

Step 2 Use the Oracle Server Manager utility to create the Cisco IP Manager database table within Oracle.

a. Enter the following command at the UNIX prompt:

svrmgrl

b. Create the Cisco IP Manager database table and ipmgr user account by entering the following commands at the SVRMGR> prompt:

connect internal
create tablespace CIPM_DAT
datafile `/opt/oracle/product/8.0.5/data/ CIPM_DAT_01.dbf'
size 200M autoextend on next 50M maxsize unlimited;
create user ipmgr identified by ipmgr default tablespace CIPM_DAT;
grant connect to ipmgr;
grant resource to ipmgr;
quit;

Step 3 Update the tnsnames.ora file as follows:

a. Go to /opt/oracle/product/8.0.5/network/admin.

b. Open the tnsnames.ora file with a text editor.

c. Delete the following lines from the file:

extproc_connection_data =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = IPC) (KEY= CIPM) )
(CONNECT_DATA = (SID = extproc) )

d. Save the file and exit from the text editor.

Step 4 Update the listener.ora file as follows:

a. Go to /opt/oracle/product/8.0.5/network/admin.

b. Open the listener.ora file.

c. Delete the following lines in the file:

(SID_DESC=
(SIC_NAME=extproc)
(ORACLE_HOME=/opt/oracle/product/8.0.5)
(PROGRAM=extproc)

)

d. Save the file and exit from the text editor.

Step 5 Test the Oracle database connection for the CIPM user by issuing the following commands:

a. Enter the following command at the UNIX prompt:

svrmgrl

b. At the SVRMGR> prompt, test the connection between the CIPM user and Oracle's system identifier for the Oracle user :

connect ipmgr/ipmgr@CIPM

If the connection is good, the utility should return this message: Connected.

c. Exit the Oracle Server Manager utility:

quit