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 |
Explain materialized views and how they are used.
Provide an example of a shell script which logs into SQLPLUS as SYS, determines the current date, changes the date format to include minutes & seconds, issues a drop table command, displays the date again, and finally exits.
Illustrate how to determine the amount of physical CPUs a Unix Box possesses (LINUX and/or Solaris).
Name two files used for network connection to a database.
how can you process messages in order asynchronously?
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 is the difference between dropping a database and taking a database offline? : sql server DBA
How to craeate the New Database Schema in Oracle and mysql? Please tell me with Example?
How does Oracle guarantee data integrity of data changes?
What are the commands you'd issue to show the explain plan for "select * from dual"?
what are the performance views in an oracle rac environment?
Which dictionary view(s) would you first look at to understand or get a high-level idea of a given Advanced Replication environment?