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
You have 4 instances running on the same UNIX box. How can you determine which shared memory and semaphores are associated with which instance?
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
What are the operating modes in which database mirroring runs? : sql server DBA
what are the performance views in an oracle rac environment?
What are the differences in clustering in sql server 2005 and 2008 or 2008 r2? : sql server DBA
Why would you use sql agent? : sql server DBA
what is logical system in sap basis
Assuming today is Monday, how would you use the DBMS_JOB package to schedule the execution of a given procedure owned by SCOTT to start Wednesday at 9AM and to run subsequently every other day at 2AM.
. 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 about your sql server dba experience? : sql server DBA
what are the benefits of flashback feature?
How would you go about verifying the network name that the local_listener is currently using?
How can you control the amount of free space in your index pages? : sql server DBA
what is asm?
How many files can a database contain in sql server?how many types of data files exists in sql server? How many of those files can exist for a single database? : sql server DBA