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)

connect as SYSDBA

d. Enter the following at the user-name p rompt to login as user SYS:

SYS@APPIQ

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

e. EnterthepasswordforuserSYS.

The default password for user SYS is the following: change_on_install

IMPORTA N T:

If you mistakenly type one or more special characters, including slashes, when entering

the password for SYS, you may see messages that are not pertinent for entering an

incorrect password.

Here are two examples:

SP2-0641: "SHOW ERRORS" requires connection to server

SP2-0640: Not connected

Enter valu

e for owa_file_var:

A message rese

mbling the following:

<Results, message not pertinent to the problem>

Enter SYS

Password:

ERROR:

ORA-12154: TNS:could not resolve service name

In the ﬁrst case, you may need to press CTRL-C to exit to the SQL prompt. Enter exit

to return to the command prompt.

When you see the command prompt, run runDictionaryFix.sh again and enter

the correct password for SYS.

f. Enter the following command to stop the O racle services:

shutdown immediate;

g. To leave SQL*Plus, enter the following:

exit

7. You must stop the Oracle listener before you can install the O racle July 2008 critical patch update.

Enter the following to stop the Oracle listener:

lsnrctl stop APPIQ

If the Oracle listener is password protected, you must do the following to stop the Oracle listener:

a. Enter the following to ﬁnd the process ID for the Oracle listener:

ps -ef | grep listener

b. Enter the following to abruptly stop the listener process:

kill —9 <process ID>

where <process ID> is the process ID for the Oracle listener

Installing the patch

To install the Oracle July 2008 critical patch update:

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