I don't believe that dba_registry was available in 8i so normally I'd
select from v$version. That returns the software version though. You
ought to have license records really!
On 6/28/07, Neil Overend <neiloverend_at_gmail.com> wrote:
> 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
>
>
>
--
Niall Litchfield
Oracle DBA
http://www.orawin.info
--
http://www.freelists.org/webpage/oracle-l
Received on Thu Jun 28 2007 - 06:48:15 CDT
