RE: Which Oracle Edition am I running

  • From: "Randy Johnson" <randyjo@xxxxxxxxxxxxx>
  • To: <oracle-l@xxxxxxxxxxxxx>
  • Date: Thu, 28 Jun 2007 07:23:21 -0500

Try this:

        select * from PRODUCT_COMPONENT_VERSION;

 


 

-----Original Message-----
From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx]
On Behalf Of Neil Overend
Sent: Thursday, June 28, 2007 4:19 AM
To: oracle-l@xxxxxxxxxxxxx
Subject: Re : Which Oracle Edition am I running

How do I tell what Edition (Standard,Enterprise) I've got installed
(8.1.7.0.0 on Win2K)

Just had a disk array disembowel itself on an old box running 8.1.7 on
Win2k. Managed to recover it to another box with a fresh install of Oracle
8.1.7.0.0 Standard Edition. When I initially started it up (with original
init.ora) it complained that Managed Standby was not available (due to
log_archive_dest_1 being set). Anyway, fixed that and everything now works.

But it makes me think that we had Enterprise Edition installed If this was
the case is there any way of confirming it and is there any problem with
running the database with Standard Edition software given that was
originally Enterprise. Oracle starts up OK, no errors in log It's a very
simple system, just a bit bucket for an application.

Alert log say this (in both cases)

ORACLE V8.1.7.0.0 - Production vsnsta=0
vsnsql=e vsnxtr=3
Windows 2000 Version 5.0 Service Pack 2, CPU type 586 Starting up ORACLE
RDBMS Version: 8.1.7.0.0.

I have access to the old ORACLE_HOME but the data disks are dead.

Neil
--
//www.freelists.org/webpage/oracle-l


No virus found in this incoming message.
Checked by AVG Free Edition. 
Version: 7.5.476 / Virus Database: 269.9.10/873 - Release Date: 6/26/2007
11:54 PM
 

No virus found in this outgoing message.
Checked by AVG Free Edition. 
Version: 7.5.476 / Virus Database: 269.9.10/873 - Release Date: 6/26/2007
11:54 PM
 

--
//www.freelists.org/webpage/oracle-l


Other related posts: