Where can I find Oratab file?

This file is either found in the /var/opt/oracle or the /etc directories. Scripts like oraenv, dbhome, dbstart and dbshut use the oratab file.

How do I edit Oratab files?

Procedure

1. Log in as oracle user.
2. Edit the /var/opt/oracle/oratab file (on Solaris) or /etc/oratab (on AIX, RHEL), and change the entry. Be sure to disable automatic startup, by specifying N in the last field: From: PV:/opt/oracle/product/11.2.0:{Y|N} To: PV:/opt/oracle/product/12.1.0:Y.

What is the first entry in your etc Oratab file?

The first element is the SID, the second indicates the Oracle Home directory for that SID, and the third indicates if the database should be started and stopped by the dbstart/dbshut commands.

What is the purpose of Oratab?

Oracle Enterprise Manager uses the oratab file to determine the name of the Oracle RAC database during service discovery and to determine whether the database is automatically started when the system restarts. Also, the information in the oratab file is used when loading environment variables with oraenv.

Where do I find the oratab file for Oracle?

On Unix or Linux, this is a very simple task. Oracle services and their ORACLE_HOMEs are listed in the oratab file, located in /etc/ on most platforms and in /var/opt/oracle/ on Solaris.

What is the path of oratab on Solaris?

What is the path of oratab on solaris? This is actually a question I google a lot and switching from environment to another, I tend to mix them up and forget. Today I googled it again and I wanted it in a place where I usually have all the answers. Thanks for contributing an answer to Database Administrators Stack Exchange!

Where do I find Oracle services on Solaris?

Oracle services and their ORACLE_HOMEs are listed in the oratab file, located in /etc/ on most platforms and in /var/opt/oracle/ on Solaris. To find what is running, we would usually use the ‘ps’ command and pipe it through grep to find and run PMON processes.

What does the y mean in the oratab file?

The above oratab file describes an Oracle instance called orcl (don’t confuse this with the database name!) that uses directory /opt/oracle/product/10.2.0/db_1 as its Oracle home. The Y indicates that this database should be started when the system boots up.