RE: Which Oracle Edition am I running

Try this:

        select * from PRODUCT_COMPONENT_VERSION;    

-----Original Message-----

From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Neil Overend
Sent: Thursday, June 28, 2007 4:19 AM
To: oracle-l_at_freelists.org
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
--

http://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  

--

http://www.freelists.org/webpage/oracle-l Received on Thu Jun 28 2007 - 07:23:21 CDT