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
What spfile/init.ora file parameter exists to force the CBO to make the execution path of a given statement use an index, even if the index scan may appear to be calculated as more costly?
What the different topologies in which replication can be configured? : sql server DBA
What are the steps you will take to improve performance of a poor performing query?
What are the differences in clustering in sql server 2005 and 2008 or 2008 r2? : sql server DBA
what are the benefits of flashback feature?
what is the role of dip user in our database?
What is the importance of a recovery model? : sql server DBA
how can you record information about current session?
what is a crs resource?
What is replication? : sql server DBA
Which autogrowth database setting is good? : sql server DBA
What are the different types of indexes available in sql server? : sql server DBA
what is grd?
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
how can you create a user-defined lock?