How can we see the database version in os level

Answers were Sorted based on User's Feedback



How can we see the database version in os level..

Answer / suman

]$echo $ORACLE_HOME

Is This Answer Correct ?    12 Yes 1 No

How can we see the database version in os level..

Answer / kittu

]$ $ORACLE_HOME/OPatch/optach lsinventory -all

the above statement will display total oracle software locations

Is This Answer Correct ?    9 Yes 3 No

How can we see the database version in os level..

Answer / nagesh yadav

$ORACLE_HOME/oui
more oraparam.ini
OUI_VERSION=10.2.0.4.0

Is This Answer Correct ?    6 Yes 2 No

How can we see the database version in os level..

Answer / james alalade

sqlplus -v

Is This Answer Correct ?    1 Yes 0 No

How can we see the database version in os level..

Answer / vivek

Run sqlplus command and check.

$sqlplus username/password@connection string

Is This Answer Correct ?    0 Yes 0 No

How can we see the database version in os level..

Answer / suman

$echo $ORACLE_HOME

Is This Answer Correct ?    2 Yes 3 No

Post New Answer

More DB Administration Interview Questions

what is the difference between off-line back up and on-line back up in ibm db2 udb?

2 Answers   Zenith,


how will u see whether the dabase is in archive log mode or not?

2 Answers   CSC,


Does any body has ORACLE Certification Dumps or Materials on 9i DBA, 10G DBA, Internet Application Developer, OCP 8i to 10g DBA Upgrade, Oracle 11i if any body have it, please kindly drop an email to: taruni_2k8@yahoo.com

0 Answers   Oracle,


What column differentiates the V$ views to the GV$ views and how?

3 Answers  


Which types of backups you can take in Oracle? 2. A database is running in NOARCHIVELOG mode then which type of backups you can take? 3. Can you take partial backups if the Database is running in NOARCHIVELOG mode? 4. Can you take Online Backups if the the database is running in NOARCHIVELOG mode?

11 Answers  






How do you increase the OS limitation for open files (LINUX and/or Solaris)?

1 Answers  


what is the purpose of catlaog in oracle rman?

2 Answers   Value Labs,


In oracle 10g export, import if we declare rows=y/n what would be the output?

0 Answers   Value Labs,


What spfile/init.ora file parameter exists to force the CBO to make the execution path of a given statement use an index, even if the index scan may appear to be calculated as more costly?

0 Answers  


what is the difference between hot backup n rman backup?

1 Answers   Value Labs,


Name a tablespace automatically created when you create a database.

5 Answers  


how can you get actual data change values from previous transactions in oracle?

0 Answers   Oracle,


Categories