Installing and Running Oracle for the VPNSC: MPLS Solution Software

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

   a. Enter su at the command line.

   b. Then enter the superuser password.

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

set shmsys:shminfo_shmmax=4294967295
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 the root user.

   a. Enter su at the command line.

   b. Then enter the superuser password.

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/orainst/oratab.sh

Step 25   Log out from the root user:

Enter exit at the command line.

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   Update the listener.ora file as follows:

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

   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 12   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:

SVRMGR>connect internal
SVRMGR>startup
SVRMGR>quit

Step 13   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 14   Now stop and restart the Net8.0.5.0 listener process:

lsnrctl stop
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
temporary tablespace TEMP;
grant connect to ipmgr;
grant resource to ipmgr;
quit;

Step 3   Update the tnsnames.ora file as follows:

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

   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   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