Using /var/opt/oracle/oratab

Digg This!     StumbleUpon     Del.icio.us

RELATED CONTENT Oracle database installation, upgrades and patches Oracle New Year's resolutions, part 2: GRC tips and customer resolutions revealed Oracle New Year's resolutions, part 1: Advice for navigating 2009 Oracle's Top 8 stories of 2008 Intermap details its Oracle database 11g upgrade Oracle OpenWorld 2008 Special Report Oracle extends Real Application Testing to 10g, 9i Third-party Oracle database tools remain an attractive option Enterprise search a key component of Oracle portal project Oracle Enterprise Manager leverages multiple environments for pharmaceutical giant Oracle 11g upgrade veteran offers step-by-step advice

RELATED GLOSSARY TERMS Terms from Whatis.com − the technology online dictionary 10g  (SearchOracle.com)

RELATED RESOURCES 2020software.com, trial software downloads for accounting software, ERP software, CRM software and business software systems Search Bitpipe.com for the latest white papers and business webcasts Whatis.com, the online computer dictionary

The oratab file located in /etc (/var/opt/oracle for Solaris) is used to identify the databases running on a server and their respective ORACLE_HOMEs. The information in this file is used by the dbhome script (which is called by running oraenv) to set your ORACLE_HOME, PATH and other variables. If you're curious about how this all works, I would recommend stepping through both the oraenv and dbhome scripts. You cannot keep listener information in this file. The listener.ora file located in $ORACLE_HOME/network/admin (unless you set $TNS_ADMIN to point elsewhere) is where you would configure your listener(s).