How to determine the Edition for Oracle 9i

#1

Hi All--

I have a machine running 9.2.0.6.0 on Windows 2003. I would like to
confirm whether it is Standard or Enterprise Edition that is
installed. I have tried

select banner from v$version

The output is:

Oracle9i Release 9.2.0.6.0 - Production
PL/SQL Release 9.2.0.6.0 - Production
CORE 9.2.0.6.0 Production
TNS for 32-bit Windows: Version 9.2.0.6.0 - Production
NLSRTL Version 9.2.0.6.0 - Production

I've also tried

select product, version from product_component_version;

but it does not indicate Standard or Enterprise.

If anyone knows how to determine the edition that is running that
would be great.

thank you.

#2

On Aug 6, 1:29*pm, jeff... (AT) yahoo (DOT) com wrote:

Quote:

Hi All--

I have a machine running 9.2.0.6.0 on Windows 2003. *I would like to
confirm whether it is Standard or Enterprise Edition that is
installed. *I have tried

select banner from v$version

The output is:

Oracle9i Release 9.2.0.6.0 - Production
PL/SQL Release 9.2.0.6.0 - Production
CORE * *9.2.0.6.0 * * * Production
TNS for 32-bit Windows: Version 9.2.0.6.0 - Production
NLSRTL Version 9.2.0.6.0 - Production

I've also tried

select product, version from product_component_version;

but it does not indicate Standard or Enterprise.

If anyone knows how to determine the edition that is running that
would be great.

thank you.

You're running Standard. Enterprise would be explicitly listed:

SQL> select banner
2 from v$version;

BANNER
----------------------------------------------------------------
Oracle9i Enterprise Edition Release 9.2.0.8.0 - 64bit Production
PL/SQL Release 9.2.0.8.0 - Production
CORE 9.2.0.8.0 Production
TNS for Solaris: Version 9.2.0.8.0 - Production
NLSRTL Version 9.2.0.8.0 - Production

David Fitzjarrell

#3

On Aug 6, 1:29*pm, jeff... (AT) yahoo (DOT) com wrote:

Quote:

Hi All--

I have a machine running 9.2.0.6.0 on Windows 2003. *I would like to
confirm whether it is Standard or Enterprise Edition that is
installed. *I have tried

select banner from v$version

The output is:

Oracle9i Release 9.2.0.6.0 - Production
PL/SQL Release 9.2.0.6.0 - Production
CORE * *9.2.0.6.0 * * * Production
TNS for 32-bit Windows: Version 9.2.0.6.0 - Production
NLSRTL Version 9.2.0.6.0 - Production

I've also tried

select product, version from product_component_version;

but it does not indicate Standard or Enterprise.

If anyone knows how to determine the edition that is running that
would be great.

thank you.

You're running Standard. Enterprise would be explicitly listed:

SQL> select banner
2 from v$version;

BANNER
----------------------------------------------------------------
Oracle9i Enterprise Edition Release 9.2.0.8.0 - 64bit Production
PL/SQL Release 9.2.0.8.0 - Production
CORE 9.2.0.8.0 Production
TNS for Solaris: Version 9.2.0.8.0 - Production
NLSRTL Version 9.2.0.8.0 - Production

David Fitzjarrell

#4

On Aug 6, 1:29*pm, jeff... (AT) yahoo (DOT) com wrote:

Quote:

Hi All--

I have a machine running 9.2.0.6.0 on Windows 2003. *I would like to
confirm whether it is Standard or Enterprise Edition that is
installed. *I have tried

select banner from v$version

The output is:

Oracle9i Release 9.2.0.6.0 - Production
PL/SQL Release 9.2.0.6.0 - Production
CORE * *9.2.0.6.0 * * * Production
TNS for 32-bit Windows: Version 9.2.0.6.0 - Production
NLSRTL Version 9.2.0.6.0 - Production

I've also tried

select product, version from product_component_version;

but it does not indicate Standard or Enterprise.

If anyone knows how to determine the edition that is running that
would be great.

thank you.

You're running Standard. Enterprise would be explicitly listed:

SQL> select banner
2 from v$version;

BANNER
----------------------------------------------------------------
Oracle9i Enterprise Edition Release 9.2.0.8.0 - 64bit Production
PL/SQL Release 9.2.0.8.0 - Production
CORE 9.2.0.8.0 Production
TNS for Solaris: Version 9.2.0.8.0 - Production
NLSRTL Version 9.2.0.8.0 - Production

David Fitzjarrell

#5

On Aug 6, 1:29*pm, jeff... (AT) yahoo (DOT) com wrote:

Quote:

Hi All--

I have a machine running 9.2.0.6.0 on Windows 2003. *I would like to
confirm whether it is Standard or Enterprise Edition that is
installed. *I have tried

select banner from v$version

The output is:

Oracle9i Release 9.2.0.6.0 - Production
PL/SQL Release 9.2.0.6.0 - Production
CORE * *9.2.0.6.0 * * * Production
TNS for 32-bit Windows: Version 9.2.0.6.0 - Production
NLSRTL Version 9.2.0.6.0 - Production

I've also tried

select product, version from product_component_version;

but it does not indicate Standard or Enterprise.

If anyone knows how to determine the edition that is running that
would be great.

thank you.

You're running Standard. Enterprise would be explicitly listed:

SQL> select banner
2 from v$version;

BANNER
----------------------------------------------------------------
Oracle9i Enterprise Edition Release 9.2.0.8.0 - 64bit Production
PL/SQL Release 9.2.0.8.0 - Production
CORE 9.2.0.8.0 Production
TNS for Solaris: Version 9.2.0.8.0 - Production
NLSRTL Version 9.2.0.8.0 - Production

David Fitzjarrell

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

How to determine the Edition for Oracle 9i

comp.databases.oracle.misc comp.databases.oracle.misc

How to determine the Edition for Oracle 9i - 08-06-2008 , 01:29 PM

Re: How to determine the Edition for Oracle 9i - 08-06-2008 , 02:23 PM

Re: How to determine the Edition for Oracle 9i - 08-06-2008 , 02:23 PM

Re: How to determine the Edition for Oracle 9i - 08-06-2008 , 02:23 PM

Re: How to determine the Edition for Oracle 9i - 08-06-2008 , 02:23 PM