RE: Manually editing the oratab file - is this OK?

Paul,

  As others mentioned, it's OK to update the file. You might want to investigate your startup scripts - you may or may not have any. If this box ever gets rebooted, you may have to startup the database manually.

Jay

-----Original Message-----
From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Paul Vincent Sent: Tuesday, April 11, 2006 8:20 AM
To: Oracle-L Freelists
Subject: Manually editing the oratab file - is this OK?

We're currently running Oracle 9.2.0.6 on all our servers, both Windows and Solaris.

After using OEM in stand-alone mode for some time, I've been given the task of implementing the full 3-tier architecture. So I've set up a Management Server and created a repository. I then tried to auto-discover all the nodes running Oracle database instances. It soon became apparent that all the Windows servers (on which the databases had all been created using DBCA) were running Intelligent Agent, and were discovered OK. However, our two SUN Solaris boxes didn't auto-discover, because they weren't running the Intelligent Agent. So i started IA on each server, and tried again. OEM discovered the nodes, but no databases. I soon discovered that the oratab file on each of these servers contained only a single line:

*:/opt/oracle9i:N

**DISCLAIMER
This e-mail message and any files transmitted with it are intended for the use of the individual or entity to which they are addressed and may contain information that is privileged, proprietary and confidential. If you are not the intended recipient, you may not use, copy or disclose to anyone the message or any information contained in the message. If you have received this communication in error, please notify the sender and delete this e-mail message. The contents do not represent the opinion of D&E except to the extent that it relates to their official business.

--
http://www.freelists.org/webpage/oracle-l