Oracle version installed

[Dulima-SP]

Environment information:
* Oracle version: 10 g
* Operating system: RHE 4

Srs ..
a problem
]
I need to know which version of Oracle is installed on my server
until there is no problem

Select all

 select * from v$version; 

Result is not expected

Select all

 
 
BANNER 
---------------------------------------------------------------- 
Oracle Database 10g Release 10.2.0.4.0 - 64bit Production 
PL/SQL Release 10.2.0.4.0 - Production 
CORE    10.2.0.4.0      Production 
TNS for Linux: Version 10.2.0.4.0 - Production 
NLSRTL Version 10.2.0.4.0 - Production 
 

Someone does idea how to get this information
I want to be if I have or and installed !!

grateful

[dr_gori]

See this link: [[0] http://en.glufke.net/oracle/viewtopic.php?t=248
Ali has a script called View.sql that shows it.
: -O

[Dulima-SP]

Came ....
grateful by the scripts ... I will use for other things ....

but did not help for my problem !!!
follows the result

Select all

BANNER 
------------------------------------------------------------------------ 
Oracle Database 10g Release 10.2.0.4.0 - 64bit Production 
PL/SQL Release 10.2.0.4.0 - Production 
CORE    10.2.0.4.0      Production 
TNS for Linux: Version 10.2.0.4.0 - Production 
NLSRTL Version 10.2.0.4.0 - Production 
 
 
'WITHTHE'||PARAMETER||'OPTION' 
----------------------------------------------------------------------------------- 
   With the Objects option 
   With the Connection multiplexing option 
   With the Connection pooling option 
   With the Database queuing option 
   With the Incremental backup and recovery option 
   With the Instead-of triggers option 
   With the Parallel load option 
   With the Proxy authentication/authorization option 
   With the Plan Stability option 
   With the Transparent Application Failover option 
   With the Sample Scan option 
   With the Java option 
   With the OLAP Window Functions option 
 
13 rows selected. 
 
 
'THE'||PARAMETER||'OPTIONISNOTINSTALLED' 
----------------------------------------------------------------------------------------------- 
   The Partitioning option is not installed 
   The Real Application Clusters option is not installed 
   The Advanced replication option is not installed 
   The Bit-mapped indexes option is not installed 
   The Parallel backup and recovery option is not installed 
   The Parallel execution option is not installed 
   The Point-in-time tablespace recovery option is not installed 
   The Fine-grained access control option is not installed 
   The Change Data Capture option is not installed 
   The Online Index Build option is not installed 
   The Coalesce Index option is not installed 
   The Managed Standby option is not installed 
   The Materialized view rewrite option is not installed 
   The Materialized view warehouse refresh option is not installed 
   The Database resource manager option is not installed 
   The Spatial option is not installed 
   The Visual Information Retrieval option is not installed 
   The Export transportable tablespaces option is not installed 
   The Fast-Start Fault Recovery option is not installed 
   The Duplexed backups option is not installed 
   The Block Media Recovery option is not installed 
   The Fine-grained Auditing option is not installed 
   The Application Role option is not installed 
   The Enterprise User Security option is not installed 
   The Oracle Data Guard option is not installed 
   The Oracle Label Security option is not installed 
   The OLAP option is not installed 
   The Table compression option is not installed 
   The Join index option is not installed 
   The Trial Recovery option is not installed 
   The Data Mining option is not installed 
   The Online Redefinition option is not installed 
   The Streams Capture option is not installed 
   The File Mapping option is not installed 
   The Block Change Tracking option is not installed 
   The Flashback Table option is not installed 
   The Flashback Database option is not installed 
   The Data Mining Scoring Engine option is not installed 
   The Transparent Data Encryption option is not installed 
   The Backup Encryption option is not installed 
   The Unused Block Compression option is not installed 
   The Oracle Database Vault option is not installed 
   The Real Application Testing option is not installed 
 

Nowhere is the script me Mostros which Oracle I have installed ....
I do not know If it is the SE or EE

there is another place that I can find what I need: ???

[pauloaleo]

If you are wanting to see if it is Standart or Enterprize, just hit SQLPLUS / SYSDBA. When it is Enterprise, Aparace right away.

[elidias7]

Good night guys.

You have three options for viewing or SQLPLus when you realize the login, which should appear in this way if the version is Enterprise:


On View V $ Version You can also identify as you will be viewed as:

Select all

BANNER 
---------------------------------------------------------------- 
Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Prod 
PL/SQL Release 10.2.0.1.0 - Production 
CORE    10.2.0.1.0      Production 
TNS for Linux: Version 10.2.0.1.0 - Production 
NLSRTL Version 10.2.0.1.0 - Production

or also within the directory. .. \ orainventory \ logs \ installations% .log ", this file contains all information related to the selected parameters in the option at the time of installation of the software, and within it you can search for the% global settings% and it will appear The installation type.

Hugs