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
In which dictionary table or view would you look to determine at which time a snapshot or MVIEW last successfully refreshed?
when does an alert gets signaled?
What is transparent data encryption? : sql server DBA
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?
how can you communicate with operating system files from oracle?
What is the default port no on which sql server listens? : sql server DBA
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.
What are the different authentication modes in sql server and how can you change authentication mode? : sql server DBA
. 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?
List out some of the requirements to setup a sql server failover cluster.? : sql server DBA
What is a correlated sub-query? : sql server DBA
what is the use of ocr?
how can you initialize log miner?
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
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.