OraFAQ Forum: Server Administration » Help upgrading database

Home » RDBMS Server » Server Administration » Help upgrading database (9i version 2)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Help upgrading database [message #356734]

Sat, 01 November 2008 14:50

danny@micronet-usa.com
Messages: 1
Registered: November 2008

Junior Member

I have an Oracle 9.2.0.1.0 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 9.2.0.8.0. Used SQLplus to run the catpatch.sql on my database. If I look at version numbers with Installer it shows Database at 9.2.0.1.0. 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.

Thanks

Report message to a moderator

Re: Help upgrading database [message #356735 is a reply to message #356734]

Sat, 01 November 2008 15:33

ebrian
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".

Report message to a moderator

Previous Topic:	DBMS_JOB failure
Next Topic:	table space problem.Increasing rapidly

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Feb 27 21:10:59 CST 2025