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

how can you generate profile of pl/sql applications to identify performance bottlenecks?

0 Answers   Oracle,


if monday take full backup and tuesday it was cumulative backup and wednesday we taken incremental backup, thursday some disaster happen then what type of recovery and how it will take?

1 Answers  


How would you determine the time zone under which a database was operating?

2 Answers  


Can you tell me about your experience with the administration of COTS system..? Also, how do you set up seed data..?

0 Answers  


What do the 9i dbms_standard.sql_txt() and dbms_standard.sql_text() procedures do?

0 Answers  


What are the new features in sql server 2005 when compared to sql server 2000? : sql server DBA

0 Answers  


I want to reuse a piece of code inside a stored procedure. This piece of code need to be invoked multiple times inside the procedure based on some different conditions. How to achieve this?

1 Answers  


what is difference between user managed backup and rman backup?

1 Answers   CTS,


How do you resize a data file?

2 Answers  


Which autogrowth database setting is good? : sql server DBA

0 Answers  


What are the steps you will take, if you are tasked with securing an SQL Server?

1 Answers   STC,


hi, how can i check all backups are exist to restore? I.e. i forget to take backup on one day. But now i want to check that all backups are there to restore now. I know the answer of through timestamps we know how to check. But i need any other way?

1 Answers  


Categories