General
cancel
Showing results for 
Search instead for 
Did you mean: 

Update Oracle using Patches ,does this setup must be performed?

SOLVED
Go to solution
xiongye_2
Occasional Advisor

Update Oracle using Patches ,does this setup must be performed?

The ninth step is :
9 Invoke SQL*Plus (sqlplus), connect as internal and run the following SQL scripts with event 10520 set. NOTE: This event is not intended for regular database operation and MUST be turned off as indicated below:

ALTER SESSION SET EVENTS '10520 TRACE NAME CONTEXT FOREVER, LEVEL 10';
?/rdbms/admin/catalog.sql
?/rdbms/admin/catproc.sql
?/rdbms/admin/catrep.sql (This only needs to be run if you are using symmetric/advanced replication. This is not necessary for sites using dblinks and read-only snapshots if symmetric/advanced replication is not installed)
CONNECT / AS SYSDBA;
update obj$ set status=5 where type#=29 and owner#!=0;
commit;

Thanks !!!
xysco
2 REPLIES
Andreas D. Skjervold
Honored Contributor
Solution

Re: Update Oracle using Patches ,does this setup must be performed?

Hi

Yes!
The catalog and catproc scipts recreates the Data Dictionary and the PL/SQL procs.
Repcat can be skipped if your not using Replication.

Andreas
Only by ignoring what everyone think is important, can you be aware of what everyone ignores!
Aashish Raj
Valued Contributor

Re: Update Oracle using Patches ,does this setup must be performed?

The event setting is required for debugging information in case of any problem/error.

Also do not forget to set following init.ora parameter before running catalog.sql and catproc.sql

_system_trig_enabled=false .