How can we see the database version in os level
Answers were Sorted based on User's Feedback
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 |
Answer / nagesh yadav
$ORACLE_HOME/oui
more oraparam.ini
OUI_VERSION=10.2.0.4.0
Is This Answer Correct ? | 6 Yes | 2 No |
Answer / vivek
Run sqlplus command and check.
$sqlplus username/password@connection string
Is This Answer Correct ? | 0 Yes | 0 No |
how can you generate profile of pl/sql applications to identify performance bottlenecks?
if monday take full backup and tuesday it was cumulative backup and wednesday we taken incremental backup, thursday some disaster happen then what type of recovery and how it will take?
How would you determine the time zone under which a database was operating?
Can you tell me about your experience with the administration of COTS system..? Also, how do you set up seed data..?
What do the 9i dbms_standard.sql_txt() and dbms_standard.sql_text() procedures do?
What are the new features in sql server 2005 when compared to sql server 2000? : sql server DBA
I want to reuse a piece of code inside a stored procedure. This piece of code need to be invoked multiple times inside the procedure based on some different conditions. How to achieve this?
what is difference between user managed backup and rman backup?
How do you resize a data file?
Which autogrowth database setting is good? : sql server DBA
What are the steps you will take, if you are tasked with securing an SQL Server?
hi, how can i check all backups are exist to restore? I.e. i forget to take backup on one day. But now i want to check that all backups are there to restore now. I know the answer of through timestamps we know how to check. But i need any other way?