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 |
what is the difference between off-line back up and on-line back up in ibm db2 udb?
how will u see whether the dabase is in archive log mode or not?
Does any body has ORACLE Certification Dumps or Materials on 9i DBA, 10G DBA, Internet Application Developer, OCP 8i to 10g DBA Upgrade, Oracle 11i if any body have it, please kindly drop an email to: taruni_2k8@yahoo.com
What column differentiates the V$ views to the GV$ views and how?
Which types of backups you can take in Oracle? 2. A database is running in NOARCHIVELOG mode then which type of backups you can take? 3. Can you take partial backups if the Database is running in NOARCHIVELOG mode? 4. Can you take Online Backups if the the database is running in NOARCHIVELOG mode?
How do you increase the OS limitation for open files (LINUX and/or Solaris)?
what is the purpose of catlaog in oracle rman?
In oracle 10g export, import if we declare rows=y/n what would be the output?
What spfile/init.ora file parameter exists to force the CBO to make the execution path of a given statement use an index, even if the index scan may appear to be calculated as more costly?
what is the difference between hot backup n rman backup?
Name a tablespace automatically created when you create a database.
how can you get actual data change values from previous transactions in oracle?