Explain the difference between $ORACLE_HOME and $ORACLE_BASE.

Answer Posted / 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



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

In which dictionary table or view would you look to determine at which time a snapshot or MVIEW last successfully refreshed?

2235


when does an alert gets signaled?

584


What is transparent data encryption? : sql server DBA

566


How can you tell how much space is left on a given file system and how much space each of the file system's subdirectories take-up?

2037


how can you communicate with operating system files from oracle?

565






What is the default port no on which sql server listens? : sql server DBA

564


when we login sql editor using username and password then it says this error "could not resolve service name" then what can we do at client side.( here thing is tnsnames.ora file is ok till yesterday and worked well, but now it giving error.

1239


What are the different authentication modes in sql server and how can you change authentication mode? : sql server DBA

559


. 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?

1986


List out some of the requirements to setup a sql server failover cluster.? : sql server DBA

711


What is a correlated sub-query? : sql server DBA

585


what is the use of ocr?

602


how can you initialize log miner?

583


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

3811


Database crashes. Corruption is found scattered among the file system neither of your doing nor of Oracle's. What database recovery options are available? Database is in archive log mode.

1755