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 do you recover a datafile that has not been physically been backed up since its creation and has been deleted. Provide syntax example.
what is grd?
How can we see the database version in os level
Explain the difference between a hot backup and a cold backup and the benefits associated with each?
How do you trace the traffic hitting a sql server? : sql server DBA
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
How would you force a log switch?
why Datapump is faster than traditional export and import
What does coalescing a tablespace do?
When a user process fails, what background process cleans up after it?
If you're unsure in which script a sys or system-owned object is created, but you know it's in a script from a specific directory, what UNIX command from that directory structure can you run to find your answer?
What are the new features in sql server 2005 when compared to sql server 2000? : sql server DBA
Oracle (3259)
SQL Server (4518)
MS Access (429)
MySQL (1402)
Postgre (483)
Sybase (267)
DB Architecture (141)
DB Administration (291)
DB Development (113)
SQL PLSQL (3330)
MongoDB (502)
IBM Informix (50)
Neo4j (82)
InfluxDB (0)
Apache CouchDB (44)
Firebird (5)
Database Management (1411)
Databases AllOther (288)