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

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  

You create a private database link <link name> and upon connection, fails with: ORA-2085: <Link name> connects to <fully qualified remote db name>. What is the problem? How would you go about resolving this error?

0 Answers  

what is grd?

0 Answers   Oracle,

Give two examples of how you might determine the structure of the table DEPT.

2 Answers  

How do you tell what your machine name is and what is its IP address?

4 Answers  




What is the importance of a recovery model? : sql server DBA

0 Answers  

Give two examples of referential integrity constraints.

2 Answers  

What are the operating modes in which database mirroring runs? : sql server DBA

0 Answers  

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

1 Answers  

I have my backup RMAN script called "backup_rman.sh". I am on the target database. My catalog username/password is rman/rman. My catalog db is called rman. How would you run this shell script from the o/s such that it would run as a background process?

1 Answers  

Which dictionary view(s) would you first look at to understand or get a high-level idea of a given Advanced Replication environment?

0 Answers  

Explain what partitioning is and what its benefit is.

2 Answers  

For more DB Administration Interview Questions Click Here
Categories