Home » RDBMS Server » Server Administration » Oracle 8.1.7 Patches
Oracle 8.1.7 Patches [message #56662] Tue, 15 April 2003 08:27 Go to next message
S.A
Messages: 4
Registered: October 2002
Junior Member
Hi all,

Can anyone tell me how to determine the patch level of an Oracle Server Installation?

Regards,

Suraj
Re: Oracle 8.1.7 Patches [message #56663 is a reply to message #56662] Tue, 15 April 2003 09:30 Go to previous messageGo to next message
psmyth
Messages: 81
Registered: October 2002
Member
select * from v$version;

have fun!
Re: Oracle 8.1.7 Patches [message #56688 is a reply to message #56662] Wed, 16 April 2003 15:30 Go to previous message
Trifon Anguelov
Messages: 514
Registered: June 2002
Senior Member
Start the Universal Installer and se the "Installed Products" . For each product you can see the exact patch level.

The v$version command will show you just the

SQL> select * from v$version;

BANNER
-------------------------------------------------------------
Oracle8i Enterprise Edition Release 8.1.7.2.1 - Production
PL/SQL Release 8.1.7.2.0 - Production
CORE 8.1.7.2.1 Production
TNS for 32-bit Windows: Version 8.1.7.2.0 - Production
NLSRTL Version 3.4.1.0.0 - Production

Not all the products are listed there.

Hope that helps,

clio_usa
OCP - DBA

Visit our Web site

Previous Topic: Who can explain this transaction for me? Thanks
Next Topic: how to monitor the table changes (Newbie)
Goto Forum:
  


Current Time: Fri Sep 20 09:37:21 CDT 2024