Home » RDBMS Server » Server Administration » how to find out edition of oracle 10G instance ?
how to find out edition of oracle 10G instance ? [message #325339] Thu, 05 June 2008 17:44 Go to next message
jren
Messages: 13
Registered: May 2008
Junior Member
when i check:

select * from v$instance

it's only show me the version is 10.2.0.1.0, but how do i find out the edition ? Thx.
Re: how to find out edition of oracle 10G instance ? [message #325341 is a reply to message #325339] Thu, 05 June 2008 18:16 Go to previous messageGo to next message
Barbara Boehmer
Messages: 8620
Registered: November 2002
Location: California, USA
Senior Member
SCOTT@orcl_11g> select * from v$version;

BANNER
--------------------------------------------------------------------------------
Oracle Database 11g Enterprise Edition Release 11.1.0.6.0 - Production
PL/SQL Release 11.1.0.6.0 - Production
CORE 11.1.0.6.0 Production
TNS for 32-bit Windows: Version 11.1.0.6.0 - Production
NLSRTL Version 11.1.0.6.0 - Production

SCOTT@orcl_11g>
Re: how to find out edition of oracle 10G instance ? [message #325344 is a reply to message #325339] Thu, 05 June 2008 20:10 Go to previous messageGo to next message
jren
Messages: 13
Registered: May 2008
Junior Member
Thx, exactly what i want.
Re: how to find out edition of oracle 10G instance ? [message #328709 is a reply to message #325344] Sun, 22 June 2008 00:32 Go to previous messageGo to next message
ora110
Messages: 42
Registered: September 2007
Location: China
Member

Yes.
select * from v$version is right.
Re: how to find out edition of oracle 10G instance ? [message #328724 is a reply to message #328709] Sun, 22 June 2008 06:49 Go to previous message
ebrian
Messages: 2794
Registered: April 2006
Senior Member
Thanks for confirming one of the Senior Moderator's answers almost 3 weeks after she replied.
Previous Topic: logminer issue
Next Topic: database not open
Goto Forum:
  


Current Time: Fri Dec 02 12:11:58 CST 2016

Total time taken to generate the page: 0.07692 seconds