Home » RDBMS Server » Server Administration » Help upgrading database (9i version 2)
Help upgrading database [message #356734] Sat, 01 November 2008 14:50 Go to next message
Messages: 1
Registered: November 2008
Junior Member
I have an Oracle installation running. Never update from orginal cd install. Moving to a new server and want to do a proper install and update. Installed from 9i CD on Server 2003. Imported my database. Ran the patch set Used SQLplus to run the catpatch.sql on my database. If I look at version numbers with Installer it shows Database at How do I know if my Oracle install is fully patched and up to date? I'm not an Oracle person, just inheritaed the server.

Re: Help upgrading database [message #356735 is a reply to message #356734] Sat, 01 November 2008 15:33 Go to previous message
Messages: 2794
Registered: April 2006
Senior Member
Check the status and version of the components in DBA_REGISTRY.

SQL> SELECT comp_name, version, status
         FROM dba_registry;

The installer "should" show the patch listed in the "Installed Products".
Previous Topic: DBMS_JOB failure
Next Topic: table space problem.Increasing rapidly
Goto Forum:

Current Time: Sat Jul 22 06:12:56 CDT 2017

Total time taken to generate the page: 0.24793 seconds