Explain the difference between $ORACLE_HOME and $ORACLE_BASE.
Answers were Sorted based on User's Feedback
Answer / guest
ORACLE_BASE is the root directory for oracle. ORACLE_HOME
located beneath the ORACLE_BASE and is the place oracle
products reside.
Regards
Abhinav Phadnis
| Is This Answer Correct ? | 22 Yes | 0 No |
Answer / shiva
$ORACLE_BASE: TOP OF ORACLE DIRECTORY
eg: u01/app/oracle
$ORACLE_HOME : WHERE THE ORACLE IS INSTALLED IN OUR SYSTEM
eg: $ORACLE_BASE/PRODUCT/RELEASED_VERSION
| Is This Answer Correct ? | 5 Yes | 4 No |
What is dcl? : sql server DBA
An automatic job running via DBMS_JOB has failed. Knowing only that "it's failed", how do you approach troubleshooting this issue?
I got an error SQL1042C. An unexpected system error occurred. Explanation: A system error occurred. One possible reason for this error is that the database manager is not installed correctly or the environment is not set up correctly. On OS/2, while trying to start the database manager, a very common reason for this error is a corrupted NET.ACC file. The command cannot be processed. The tables and views would not be opened. What is the way to open the dataase? pls help me
Define the SGA and: How you would configure SGA for a mid-sized OLTP environment? What is involved in tuning the SGA?
what is rebuild index??
when does an alert gets signaled?
What questions might be they ask in managerial round in capgemini.
When setting replication, can you have distributor on sql server 2005, publisher on sql server 2008? : sql server DBA
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?
What are the different types of database compression introduced in sql server 2008? : sql server DBA
how can you generate profile of pl/sql applications to identify performance bottlenecks?
what is the last version,the release date of that version and fix pack of ibm db2 udb?
Oracle (3253)
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)