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 |
When a user process fails, what background process cleans up after it?
Which dictionary view(s) would you first look at to understand or get a high-level idea of a given Advanced Replication environment?
What are the different authentication modes in sql server and how can you change authentication mode? : sql server DBA
Illustrate how to determine the amount of physical CPUs a Unix Box possesses (LINUX and/or Solaris).
What the different components in replication and what is their use? : sql server DBA
Due to some maintenance being done, the sql server on a failover cluster needs to be brought down. How do you bring the sql server down? : sql server DBA
how can you generate profile of pl/sql applications to identify performance bottlenecks?
Can you redefine a table online?
What are the different sql server versions you have worked on? : sql server DBA
From the database level, how can you tell under which time zone a database is operating?
what is asm?
What is the recommended interval at which to run statspack snapshots, and why?
Oracle (3259)
SQL Server (4518)
MS Access (429)
MySQL (1402)
Postgre (483)
Sybase (267)
DB Architecture (141)
DB Administration (291)
DB Development (113)
SQL PLSQL (3330)
MongoDB (502)
IBM Informix (50)
Neo4j (82)
InfluxDB (0)
Apache CouchDB (44)
Firebird (5)
Database Management (1411)
Databases AllOther (288)