January 26, 2005

Upgrade Note for oracle 9.2.0.6

1. Delete sys stats if necessary and recreate after upgrade finishing

DBMS_STATS.DELETE_SCHEMA_STATS('SYS');
DBMS_STATS.GATHER_SCHEMA_STATS('SYS');

2. Set pool size to at least 150M

ALTER SYSTEM SET SHARED_POOL_SIZE='150M' SCOPE=spfile;
ALTER SYSTEM SET JAVA_POOL_SIZE='150M' SCOPE=spfile;

If java pool is not used, set it to 0 after finished upgrading

3. Not sure if you just upgrade the client, should you run it ?

Oracle Recovery Manager catalog, enter the following command:

$ rman catalog username/password@alias
RMAN> UPGRADE CATALOG;


- No comments Not publicly viewable


Add a comment

You are not allowed to comment on this entry as it has restricted commenting permissions.

Search this blog

Search Warwick Blogs

 

Tags

Most recent comments

  • Oracle 11g is the clear leader in this area. Oracle has invested heavily into self–tuning capabiliti… by shaane on this entry
  • All the features are very nice.I like Repair Advisors the most.Oracle 10G introduced some of the dat… by lucy on this entry
  • "logical standby failed to re–start, I am also getting the same error. I have search on internet and… by anemia on this entry
  • Thanks for the nice information because from last three days i am stuck on this problem…. by robot vacuum on this entry
  • So what happen City speed dating when you tried this coding once in your PC.. Please tell me so i am… by John Bergeron on this entry
Not signed in
Sign in

Powered by BlogBuilder
© MMXXII