Sign Up Login


  1. Categories >> Software >> Databases >> DB Administration
  2. Suggest New Category

How can we see the database version in os level

Question Posted / bazzu

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

Which dictionary tables and/or views would you look at to diagnose a locking issue?

2 Answers  

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

2 Answers   Zenith,

How do you resize a data file?

2 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?

1 Answers  

How do you add a data file to a tablespace?

3 Answers  

How do you trace the traffic hitting a sql server? : sql server DBA

0 Answers  

what functionality does oracle provide to secure sensitive information?

0 Answers   Oracle,

What is the difference between a TEMPORARY tablespace and a PERMANENT tablespace?

2 Answers  

how to copy(migrate) the database one server to another server without using expdp/impdp how it is possible.

4 Answers   DELL, TCS,

what is the diffrence between core dba and apps dba?

0 Answers   Cap Gemini,

1)how to Take Backup in sql server 2005 from Flash Drive

1 Answers  

Explain the use of setting GLOBAL_NAMES equal to TRUE.

1 Answers  

For more DB Administration Interview Questions Click Here
Categories