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 checkpoint?
What is blocking and how would you troubleshoot it?
What is replication? : sql server DBA
Claims and Drains are the locks used to control the concurrency between SQL processes and utilities. Referring to the above statement, what is the maximum number of concurrent Claimers for a Subsystem? Choice 1 32 Choice 2 64 Choice 3 128 Choice 4 256 Choice 5 No limit
How can we know the exact updation date of a particular database?
How to determine the service pack currently installed on SQL Server?
List out some of the requirements to setup a sql server failover cluster.? : sql server DBA
what is the use of recording information about current session?
What are the different types of indexes available in sql server? : sql server DBA
Can you tell me about your experience with the administration of COTS system..? Also, how do you set up seed data..?
which background process will run @ the time of creation of catalog database
one datafile is lost in standy side how can you recover that??
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)