CODEWITHSUNDEEP
oracle-databaseoracle11goracle-enterprise-linux
Vishwanath gowda k
Vishwanath gowda k

Reputation: 1695

Which edition of oracle is installed

We are compiling a code which needs 32 bit oracle db to be installed. So i need to install a oracle 32 bit. We have another machine where 32 bit oracle 11g is installed and we are able to compile Succesfully.

I need to know which edition of oracle is installed there (Standard or Enterprise) so I can install the same in my machine.

Additional info: Oracle 32 bit is just a plain db. it is not installed with configuration or Listner. So i cant find out through any queries.

Upvotes: 2

Views: 364

Answers (2)

Rahul Vishwakarma
Rahul Vishwakarma

Reputation: 996

You have to query the data dictionary view PRODUCT_COMPONENT_VERSION to identify the release of Oracle Database that is currently installed.

The below query will help you.

SELECT product, version, status
FROM PRODUCT_COMPONENT_VERSION
WHERE product LIKE 'Oracle Database%';

PRODUCT                                 VERSION     STATUS
======================================  ==========  ================
Oracle Database 11g Enterprise Edition  11.2.0.3.0  64bit Production

Upvotes: 2

Exhausted
Exhausted

Reputation: 1885

If you need more information about database, you can query 

select * from v$database;

for more information refre here http://docs.oracle.com/cd/B19306_01/server.102/b14237/dynviews_1073.htm#REFRN30047

If you connect to SQL PLUS it will say which version and edition you had installed

Upvotes: 0

Related Questions