1. Run setup.exe found in \Oracle_Install\Database\Disk1\. Use the following settings on each screen, pressing Next or Install to continue.
Oracle Installation screen
Select 'Install/Uninstall Products'
Welcome screen
File Locations screen
Path = 'c:\oracle\ora90'
Name = 'orahome90'
Available Products screen
Select 'Oracle Database 9.2.0.1.0'
Installation Types screen
Select 'Standard Edition'
Database Configuration screen
Select 'General Purpose'
Oracle Services for MTS screen
Confirm '2030'
Database Identification screen
Global Database Name = 'red.world'
(SID will set to red automatically)
Database File Location screen
Directory for Database Files = 'c or d:\oracle\oradata'
Database Character Set screen
Character set to 'AMERICAN_AMERICA.WE8ISO8859P1'
Summary screen
Click 'Install'
2. Modyfying Server Registry
Click :- Start – Run – Regedit – OK
Click :- HKEY_LOCAL_MACHINE
Click :- SOFTWARE
Click :- ORACLE
Highlight:- HOME0
Scroll down to - NLS_LANG
Double Click - NLS_LANG
Place mouse on highlighted 'value data'
Right Click – Select 'Copy' – Select – 'Cancel'
In the right-hand window highlight:- HOME1
Find - NLS_LANG
Double click - NLS_LANG
Right-click the highlighted data and select 'paste'
It should now read: AMERICAN_AMERICA.WE8ISO8859P1
Close regedit.
3. Backup Oracle Registry Key
Right-Click the 'Oracle' key in the registry
Select & Click – 'Export Registry File'
Create NEW folder 'Reg_Backup' in the Oracle folder
Filename = Oracle Server
Save and then close the Registry Editor
4. Run Services.msc & Stop the following services
OracleMTSRecoveryService
OracleOraHome90Agent
OracleOraHome90HTTPServer (may not be running but close if open)
Highlight the Service, Double Click and then select STOP. Change Startup type to Manual – Apply & OK
5. The only Services that should show a status of 'Started' should be
OracleOraHome90TNSListener
OracleServiceRED
6. TEST DATABASE CONNECTION
Open SQLPLUSW (start menu/Programs/Oracle - OraDb10g..../Application Development
USER NAME = system
PASSWORD = red$$
HOST STRING = red
Type the following commands at the SQL> prompt.
conn / as sysdba
drop public synonym XMLCONCAT;
drop function XMLCONCAT;
shutdown immediate
1. Apply Oracle server Patch Set 3 - Ver.9.2.0.4.0
Stop the following services
OracleOraHome90TNSListener
OracleServiceRED
2. Run setup.exe found in \Oracle_Install\Database\Disk3\Patch Set 3\p3095277_9204_WINNT\9204_nt_release\Disk1. Use the following settings on each screen, pressing Next or Install to continue.
Welcome Screen
File Locations Screen
Available Products Screen
Select OUI 2.2.0.18.0
Summary Screen
End of Installation Screen
Click Exit
3. Run setup.exe found in \Oracle_Install\Database\Disk3\Patch Set 3\p3095277_9204_WINNT\9204_nt_release\Disk1. Use the following settings on each screen, pressing Next or Install to continue.
Welcome Screen
About Oracle Universal Installer
The screen should display
Oracle Universal Installer
Version 2.2.0.18.0
Copyright @ 1999,2002 Oracle CORORATION All Rights Reserved
(Note: Screen display other than the above start again from 2)
Exit this screen to continue
Welcome Screen
File Locations Screen
Available Products Screen
Oracle 9iR2 Patch Set 9.2.0.4.0
Summary Screen
End of Installation Screen
Exit
Now Click Exit again & Close ALL Windows
4. Start the following Services
OracleOraHome90TNSListener
OracleServiceRED
5. Open \Oracle\Admin\Red\pfile\ and create a backup of the init.ora.######## file
6. Open the origonal INIT.ORA.######## in notepadand make the changes shown in blue in the following example
###########################################################
# THIS IS A SAMPLE OF THE REDTHORN MODIFIED INIT.ORA FILE #
# @11.1 AS REQUIRED TO INSTALL PATCH SET 3 #
###########################################################
Open SQLPLUSW (start menu/Programs/Oracle - OraDb10g..../Application Development
USER NAME = system
PASSWORD = red$$
HOST STRING = red
Type the following commands at the SQL> prompt.
alter user system identified by manager;
alter user sys identified by manager;
commit;
conn system/manager as sysdba
shutdown immediate;
create spfile from pfile='%DRIVE%:\oracle\admin\red\pfile\init.ora.########';
startup
shutdown immediate;
startup migrate
spool patch.log;
@%DRIVE%:\oracle\ora90\rdbms\admin\catpatch;
Patch Set 3 will now be applied to the system. . . This will take some time! (45 minutes or more)
On completion of 12.2 above, the system will return to the SQL> prompt. DOC> END CATPATCH.SQL */ should appear immediately above the SQL> prompt.
At the SQL> prompt type