Home » RDBMS Server » Enterprise Manager » How to find Oracle Edition(i.e Enterprise/Standard)
How to find Oracle Edition(i.e Enterprise/Standard) [message #68879] Sat, 01 January 2005 18:21 Go to next message
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.
Re: How to find Oracle Edition(i.e Enterprise/Standard) [message #68880 is a reply to message #68879] Sun, 02 January 2005 22:51 Go to previous message
Frank Naude
Messages: 4571
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
Previous Topic: ORA-01422: exact fetch returns more than requested number of rows
Next Topic: shared memory realm does not exist
Goto Forum:
  


Current Time: Wed May 18 18:19:53 CDT 2022