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

Is it possible to update the multiple field values in a single query? If possible then write the actual query.

1 Answers   Oracle,

What background process refreshes materialized views?

2 Answers   Accenture, FLSmidth,

Why would you call update statistics? : sql server DBA

0 Answers  

Which autogrowth database setting is good? : sql server DBA

0 Answers  

How would you configure your networking files to connect to a database by the name of DSS which resides in domain icallinc.com?

1 Answers  




How can you rebuild an index?

6 Answers  

Database crashes. Corruption is found scattered among the file system neither of your doing nor of Oracle's. What database recovery options are available? Database is in archive log mode.

0 Answers   Infosys,

i have 10gp file.now i need store in database..but database have only 7gb memory only..how do u store the file ?

0 Answers   IBM,

Explain the difference between a data block, an extent and a segment.

2 Answers  

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

0 Answers   Oracle,

What the different components in replication and what is their use? : sql server DBA

0 Answers  

If we issue alter database begin backup. What happens to database?

2 Answers  

For more DB Administration Interview Questions Click Here
Categories