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 |
Which dictionary tables and/or views would you look at to diagnose a locking issue?
An automatic job running via DBMS_JOB has failed. Knowing only that "it's failed", how do you approach troubleshooting this issue?
I have my backup RMAN script called "backup_rman.sh". I am on the target database. My catalog username/password is rman/rman. My catalog db is called rman. How would you run this shell script from the o/s such that it would run as a background process?
Explain the use of setting GLOBAL_NAMES equal to TRUE.
What are the different types of upgrades that can be performed in sql server? : sql server DBA
If we issue alter database begin backup. What happens to database?
How would you extract DDL of a table without using a GUI tool?
In what script is "snap$" created? In what script is the "scott/tiger" schema created?
how can a session indicate its interest in receiving alerts?
How would you determine the time zone under which a database was operating?
what r the types of backup?
Can you take Image Backups using RMAN? . Can you use Backupsets created by RMAN with any other utility
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)