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

  • From: "Robertson Lee - lerobe" <Lee.Robertson@xxxxxxxxxx>
  • To: <Paul.Vincent@xxxxxxxxx>, "Oracle-L Freelists" <oracle-l@xxxxxxxxxxxxx>
  • Date: Tue, 11 Apr 2006 13:23:14 +0100

Never had a problem with editing that file Paul.



-----Original Message-----
From: oracle-l-bounce@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of Paul Vincent
Sent: 11 April 2006 13:20
To: Oracle-L Freelists
Subject: Manually editing the oratab file - is this OK?

We're currently running Oracle 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:


Knowing that the whole Discovery algorithm starts by extracting the SIDs
from the oratab file, I manually added a line to oratab, for one of the
database instances. And Hey Presto! That database was auto-discovered.

Now, i know that the databases on the two Solaris servers were all
created by the application vendors when they installed the corporate
apps on those servers, and that they were created manually, rather than
via DBCA. Does this mean that they omitted a step which would have made
an entry in oratab? In any case, is it an OK procedure for me to simply
manually edit the oratab file, as above, adding a line for each database
I want auto-discovering? Or are there hidden pitfalls? I've tried my
darnedest to RTFM on this one, but references to oratab are few and far
between in the Oracle documentation, so it's time for me to consult the
experts (that's you lot - I hope!).

Paul Vincent
Oracle DBA
UCE Birmingham
The information contained in this communication is confidential, is
intended only for the use of the recipient named above, and may be legally

If the reader of this message is not the intended recipient, you are
hereby notified that any dissemination, distribution or copying of this
communication is strictly prohibited.

If you have received this communication in error, please resend this
communication to the sender and delete the original message or any copy
of it from your computer system.

Thank You.

Other related posts: