How can we see the database version in os level

Categories >> Software >> Databases >> DB Administration
Suggest New Category

Question Posted / bazzu

6 Answers
13376 Views
Oracle, I also Faced
E-Mail Answers

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 command would you use to create a backup control file?

2 Answers

Explain how you would restore a database using RMAN to Point in Time?

1 Answers

by issuing "alter tablespace begin backup;" what happens to tablespace?

5 Answers CSC, Logica CMG,

A table is classified as a parent table and you want to drop and re-create it. How would you do this without affecting the children tables?

0 Answers

Query processing is slow(eg select query)how will u solve that

3 Answers TCS,

How can we know the exact updation date of a particular database?

2 Answers Satyam,

If you're unsure in which script a sys or system-owned object is created, but you know it's in a script from a specific directory, what UNIX command from that directory structure can you run to find your answer?

1 Answers

You have found corruption in a tablespace that contains static tables that are part of a database that is in NOARCHIVE log mode. How would you restore the tablespace without losing new data in the other tablespaces?

0 Answers

What authentication modes does sql server support? : sql server DBA

0 Answers

Define the SGA and: How you would configure SGA for a mid-sized OLTP environment? What is involved in tuning the SGA?

0 Answers

how do see how much space is used and free in a tablespace

2 Answers Genpact,

What is the difference between LMT & DLT?

1 Answers CTS,

For more DB Administration Interview Questions Click Here