HP Storage Essentials SRM July 2008 Patch for Oracle 9.2.0.8 Guide for Red Hat Linux and SUSE Linux Enterprise Servers (September 2008)

a. Login as Oracle by entering the following command:

su — oracle

b. Start the Oracle listener by entering the following command:

lsnrctl start

It may take several minutes for the Oracle listener to start.

c. Ensure that the Oracle listener is running by entering the following command:

lsnrctl status

d. After the Oracle listener starts, start SQL*Plus by entering the following command prompt:

sqlplus /nolog

e. Connect as SYSDBA by entering the following command:

connect as SYSDBA

f. Enter the following at the user-name prompt to login as user SYS:

SYS@APPIQ

SYS is the user account that owns the database and the data dictionary.

g. EnterthepasswordforuserSYS.

The default password for user SYS is the following: change_on_install

h. Enter the following to start Oracle services:

startup;

i. Enter the following to exit SQL*Plus:

exit

2. If you are not already in the <Destination_Directory> directory, navigate to it now. The

<Destination_Directory> is where you expanded the contents of the patch.

3. Oracle recommends running the runDictionaryFix.sh script to ﬁx any corruption that may

have occurred with the metadata when the patch was installed.

To run the runDictionaryFix.sh script, enter the following command:

./runDictionaryFix.sh

4. Provide the password for user SYS when prompted and press Enter.

The default password for user SYS is the following: change_on_install

SYS is the user account that owns the database and the data dictionary.

Oracle sends the output to this screen indicating its progress.

Thescriptcompletes.

(Servers with previous Oracle CPUs) Applying the Oracle July 2008 Critical Patch Update