-
I was just asked to see what version/type of Oracle was installed on an Win NT 4.0 box. I know I can connect to the database and type Select * from v$version. But this only gives me the version number(Oracle 8i Release 8.1.6.0.0). What I would like to know is if the machine was installed with Oracle Workgroup, Oracle Personal Edition, Enterprise Edition, Oracle Client, etc. in addition to just the version number.
Thanks.
-
This appears when I log into SQL*Plus as system/manager:
Verbunden mit:
Oracle8i Enterprise Edition Release 8.1.6.0.0 - Production
With the Partitioning option
JServer Release 8.1.6.0.0 - Production
Hope that is what you are looking for.
David Knight
OCP DBA 8i, 9i, 10g
-
In any time you can execute statment:
select * from v$version;
and see something like this:
BANNER
--------------------------------------------------
Oracle8i Release 8.1.5.0.2 - Production
PL/SQL Release 8.1.5.0.0 - Production
CORE Version 8.1.3.0.0 - Production
TNS for Linux: Version 8.1.5.0.0 - Production
NLSRTL Version 3.4.0.0.0 - Production
-
dknight,
That is what I am looking for, but when I do the same thing I get:
Connected to:
Oracle8i Release 8.1.6.0.0 - Production
JServer Release 8.1.6.0.0 - Production
Based off your reply and what I get, I think it could be safe to say the machine doesn't have Enterprise Edition installed. But which edition does it have? The mystery continues.
-
There is also a table called v$option, which tells you which of the optional components you have installed.
-
Try executing your Oracle Universal Installer. There is an option that diplays all your installed SW.
Tim Hussar
-
sonofsita
http://www.ordba.net
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|