Re: missing oratab

From: gazzag <gareth_at_jamms.org>
Date: 11 Jan 2006 09:29:00 -0800
Message-ID: <1137000540.624848.161900@g14g2000cwa.googlegroups.com>

>> crikey what can i do now? I thought oratab was essential..

You can re-create one easily enough, providing you know what databases and what ORACLE_HOME's you have on that server. Typically it lives at /etc/oratab and is a simple text file.

It is used by the startup script /etc/init.d/dbstart to start (or not, as the case may be) any databases on that server.

db1:/u01/app/oracle/product/10.1.0/db_1:Y
db2:/u01/app/oracle/product/10.1.0/db_1:Y
db3:/u01/app/oracle/product/10.1.0/db_1:N

It is a colon-delimited (:) file and takes the format:

<db_name>:<oracle_home_for_that_database>:Y|N

"Y" in the last field indicates that you want that particular database to startup at system boot, "N" indicates otherwise.

HTH -g Received on Wed Jan 11 2006 - 11:29:00 CST