Tuesday 2 December 2014

ORACLE 10.2.0.1 to 10.2.0.4 PSU apply


1.Method
Fresh Oralce Software Installed (not create any database) then after apply patch.

2.Method

 -- backup

Shutdown all Oracle Windows services

Install 10.2.0.4 patchset (run setup)

RUN > setup > set home path (dbhome_2 )

Startup all Oracle Windows services

NOTE:- When the the database not created then normaly upgrade patch,
       But when the database exist then be carefully updated patch
       see following steps:-

from CMD prompt: sqlplus /nolog

from SQL prompt: connect sys/sys@db as sysdba

after connect:
idel instance show
shutdown immediate
after shutdown:
startup upgrade
after startup:

@ D:\oracle\product\10.2.0\db_1\rdbms\admin\catupgrd.sql

start listener

startdb
 check location spfile;
after script finishes (it could take a while)

No comments: