How can we see the database version in os level

Answer Posted / suman

$echo $ORACLE_HOME

Is This Answer Correct ?    2 Yes 3 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Can you tell me about your experience with the administration of COTS system..? Also, how do you set up seed data..?

1742


how can you find out if a table can be redefined?

593


how can you initialize log miner?

574


what is ora 24313?what is the procedure to exclude that error?

2100


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

578






How to craeate the New Database Schema in Oracle and mysql? Please tell me with Example?

1898


You have 4 instances running on the same UNIX box. How can you determine which shared memory and semaphores are associated with which instance?

3936


Illustrate how to determine the amount of physical CPUs a Unix Box possesses (LINUX and/or Solaris).

1491


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.

1748


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

609


What the different types of replication and why are they used? : sql server DBA

557


Explain about your sql server dba experience? : sql server DBA

545


Provide an example of a shell script which logs into SQLPLUS as SYS, determines the current date, changes the date format to include minutes & seconds, issues a drop table command, displays the date again, and finally exits.

1500


how can you enable flashback feature?

532


Assuming today is Monday, how would you use the DBMS_JOB package to schedule the execution of a given procedure owned by SCOTT to start Wednesday at 9AM and to run subsequently every other day at 2AM.

1697