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

Due to some maintenance being done, the sql server on a failover cluster needs to be brought down. How do you bring the sql server down? : sql server DBA

0 Answers  

Q. How to set ORACLE_HOME to my oracle software directory. Hi Friend I am installing oracle 10g Express Edition on Linux Fedora Core 6. Installation is success but when i run #sqlplus I getting command not found error. Then I have search sqlplus .i.e # find / -name sqlplus /usr/lib/oracle/xe/app/oracle/product/10.2.0/server/bin/sqlplus /usr/lib/oracle/xe/app/oracle/product/10.2.0/server/sqlplus These above output from find i have doubt which is correct path of sqlplus. So doubtfully i have set path 1st one.i.e # PATH=$PATH:/usr/lib/oracle/xe/app/oracle/product/10.2.0/server/bin Then I have run #sqlplus but still i have problem following Error 6 initializing SQL*Plus Message file sp1<lang>.msb not found SP2-0750: You may need to set ORACLE_HOME to your Oracle software directory How overcome this please answer m???

1 Answers  

what is a crs resource?

0 Answers   Oracle,

what is rebuild index??

2 Answers   IBM, Sapient,

What is checkpoint?

3 Answers   Accenture,

When a user process fails, what background process cleans up after it?

1 Answers  

who owns the operating system files created by the utl_file package?

0 Answers   Oracle,

What does coalescing a tablespace do?

1 Answers  

You're getting high "busy buffer waits" - how can you find what's causing it?

1 Answers  

Oracle client is not able to connect to Oracle server although tnsnames.ora file has valid enteries. Oracle error message is “ cannot resolve net service name”. Mention any three reasons.

0 Answers  

Explain the concept of the DUAL table.

3 Answers  

Give two methods you could use to determine what DDL changes have been made.

2 Answers  

For more DB Administration Interview Questions Click Here
Categories