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

what is the diffrence between core dba and apps dba?

0 Answers   Cap Gemini,

How does Oracle guarantee data integrity of data changes?

1 Answers   SoftSol,

WHEN DOWN TIME WHAT CAN U DO?

1 Answers   TCS,

any body know about orawaves do they really provide placements in their unique placement program

1 Answers   TCS,

I lost one datafile i dont have backup how can you recover that???

2 Answers   HP,




Where in the Oracle directory tree structure are audit traces placed?

1 Answers  

How can you rebuild an index?

6 Answers  

What query tells you how much space a tablespace named "test" is taking up, and how much space is remaining?

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?

0 Answers  

What is RAID and what are different types of RAID configurations?

1 Answers  

I have A,B,C servers.i want to 3 servers jobs move to D server(target server)..how? note: i said that take the backup of msdb and restore to the target server..he said while restoring jobs replaced. what is the solution

0 Answers  

How do you open a cluster administrator? : sql server DBA

0 Answers  

For more DB Administration Interview Questions Click Here
Categories