Instance Name & database version question?

[owenyuen]

Hi all:
How can I identify the instance name? Also, is anyway I can find out the version of the database?

 

[stefanhei]

Hi.
The v$instance - view provides the information you need.

Stefan

 

[alexhu]

select * from v$version;

Alex

 

[cliousa]

Every time you startup SQL*Plus (svrmgrl) the version and the edition of the db are displayed. Something like that:

$ sqlplus /nolog

SQL*Plus: Release 9.0.1.3.0 - Production on Wed Mar 12 10:06:54 2003

(c) Copyright 2001 Oracle Corporation. All rights reserved.

SQL>


Or you can lookup from OUI the version of each installed product. For the instance name:

SQL>select instance_name from v$instance;



Hope that helps,

clio_usa - OCP DBA
------------------

http://www.dbaclick.com

 

[owenyuen]

Thanks All:

Best Regards
Owen