OraFAQ Forum: Enterprise Manager » How to find Oracle Edition(i.e Enterprise/Standard)

Home » RDBMS Server » Enterprise Manager » How to find Oracle Edition(i.e Enterprise/Standard)

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

How to find Oracle Edition(i.e Enterprise/Standard) [message #68879]

Sat, 01 January 2005 18:21

khawar
Messages: 4
Registered: September 2004

Junior Member

Hi,
I want to find oracle version, edition etc, b/c when ever I give Parallel backup command or specifying multiple archive destinations (through log_archive_dest_n) it gives error.
Thanks in advance.

Report message to a moderator

Re: How to find Oracle Edition(i.e Enterprise/Standard) [message #68880 is a reply to message #68879]

Sun, 02 January 2005 22:51

Frank Naude
Messages: 4581
Registered: April 1998

Senior Member

Hi,

Look at the banner when you login with sqlplus:

SQL*Plus: Release 10.1.0.2.0 - Production on Mon Jan 3 10:52:38 2005

Copyright (c) 1982, 2004, Oracle.  All rights reserved.

Connected to:
Oracle Database 10g <b>Enterprise Edition</b> Release 10.1.0.2.0 - 64bit Production
With the Partitioning, OLAP and Data Mining options

... or execute the following query:

SQL> SELECT * FROM v$version;

BANNER
----------------------------------------------------------------
Oracle Database 10g <b>Enterprise Edition</b> Release 10.1.0.2.0 - 64bi
PL/SQL Release 10.1.0.2.0 - Production
CORE    10.1.0.2.0      Production
TNS for Solaris: Version 10.1.0.2.0 - Production
NLSRTL Version 10.1.0.2.0 - Production

Best regards.

Frank

Report message to a moderator

Previous Topic:	ORA-01422: exact fetch returns more than requested number of rows
Next Topic:	shared memory realm does not exist

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Tue Nov 26 07:32:08 CST 2024