Other Oracle database topics - 9i OMS restrictions

Author

9i OMS restrictions

Tarby777

2005-09-22, 7:23 am

- Oracle 9i 9.0 / Win XP Pro -

Hi all,

I've created an OMS/repository database (OEMREP) on my laptop, and I
can connect to the OMS when I log into Enterprise Manager. I'm able to
administer several databases on a Unix box in this way. However, I
don't seem able to administer a database on my laptop (not the OEMREP
database) - Enterprise Manager doesn't find it when I run either the
discover node or refresh node routines.

When I run Enterprise Manager in standalone mode, there's no problem;
the database shows up in the tree and I can administer it. It's only
when connected to the OMS that Enterprise Manager doesn't see the
database.

Is there some kind of restriction in OMS that won't let Enterprise
Manager administer databases that are on the same box as the OMS
database?

TIA
Nick

sybrandb@yahoo.com

2005-09-22, 7:23 am

There is not.
You need to be more specific as to what 'doesn't find it' means.
There must be something in your listener.ora and tnsnames.ora
precluding from Oracle Intelligent Agent to generate correct snmp_*.ora
and services.ora. Does your Intelligent Agent actually run at all?

--
Sybrand Bakker
Senior Oracle DBA

Tarby777

2005-09-22, 7:23 am

Hi Sybrand,

By "does not find it", I mean that running the "discover node" routine
in OEM does not add the database to the tree (whereas, if I run the
same routine and choose the Unix box as the node rather than choosing
the laptop as the node, the databases on the Unix box ARE added to the
tree).

The Agent *is* running on the laptop; the Control Panel service has a
status of "started", and the "ping Agent" utility in OEM returns the
status "successful".

I don't have a LISTENER.ORA file on the laptop, although the listener
is running, I do have a LISTENER.LOG and I can TNSPING the database.
LSNRCTL STATUS returns this:

LSNRCTL for 32-bit Windows: Version 9.0.1.1.1 - Production on
22-SEP-2005 13:09:34
Copyright (c) 1991, 2001, Oracle Corporation. All rights reserved.
Connecting to (ADDRESS=(PROTOCOL=t
cp)(PORT=1521))
STATUS of the LISTENER
------------------------
Alias LISTENER
Version TNSLSNR for 32-bit Windows: Version 9.0.1.1.1
- Production
Start Date 22-SEP-2005 11:34:14
Uptime 0 days 1 hr. 35 min. 21 sec
Trace Level off
Security OFF
SNMP OFF
Listener Log File C:\oracle\ora90\netw
ork\log\listener.log
Listening Endpoints Summary...

(DESCRIPTION=(ADDRES
S=(PROTOCOL=tcp)(HOS
T=GBA-NICKW-XP.gba.mentorg.com)(PORT=1521)))

(DESCRIPTION=(ADDRES
S=(PROTOCOL=tcps)(HO
ST=137.202.205. 127)(PORT=2482))(PRE
SENTATION=GIOP)(SESS
ION=RAW))

(DESCRIPTION=(ADDRES
S=(PROTOCOL=tcp)(HOS
T=137.202.205. 127)(PORT=2481))(PRE
SENTATION=GIOP)(SESS
ION=RAW))

(DESCRIPTION=(ADDRES
S=(PROTOCOL=tcps)(HO
ST=137.202.205. 127)(PORT=9090))(PRE
SENTATION=http:// admin)(SESSION=RAW))

(DESCRIPTION=(ADDRES
S=(PROTOCOL=tcp)(HOS
T=137.202.205. 127)(PORT=8080))(PRE
SENTATION=http:// admin)(SESSION=RAW))

Services Summary...
Service "MODOSE" has 1 instance(s).
Instance "OEMREP", status READY, has 1 handler(s) for this service...
Service "OEMREP.gba.mentorg.com" has 1 instance(s).
Instance "OEMREP", status READY, has 3 handler(s) for this service...
Service "testbed" has 1 instance(s).
Instance "testbed", status READY, has 2 handler(s) for this
service...
The command completed successfully

The entry for the database in TNSNAMES.ORA looks like this:

TESTBED =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = testbed)
)
)

TIA
Nick

Sybrand Bakker

2005-09-22, 8:23 pm

On 22 Sep 2005 05:17:14 -0700, "Tarby777"
< nick_williamson@ment
org.com> wrote:

>I don't have a LISTENER.ORA file on the laptop,

Then this is your problem.

OEM requires a listener listening for a SID, as opposed to a
service_name.
You need to create listener.ora, make sure there is a
sid_list_listener section where the connect_data bit reads
connect_data=(sid=(t
estbed))
and bounce the listener and the agent.

Right now your services.ora (in OH\network\admin), snmp_ro.ora and
snmp_rw.ora (both in OH\network\agent) are not correct.
You may need to delete all *.q files in OH\network\agent

--
Sybrand Bakker, Senior Oracle DBA

Jim Smith

2005-09-22, 8:23 pm

In message <1127386375.043667.42060@g14g2000cwa.googlegroups.com>,
Tarby777 < nick_williamson@ment
org.com> writes
>- Oracle 9i 9.0 / Win XP Pro -
>
>Hi all,
>
>I've created an OMS/repository database (OEMREP) on my laptop, and I
>can connect to the OMS when I log into Enterprise Manager. I'm able to
>administer several databases on a Unix box in this way. However, I
>don't seem able to administer a database on my laptop (not the OEMREP
>database) - Enterprise Manager doesn't find it when I run either the
>discover node or refresh node routines.
>
>When I run Enterprise Manager in standalone mode, there's no problem;
>the database shows up in the tree and I can administer it. It's only
>when connected to the OMS that Enterprise Manager doesn't see the
>database.
>
>Is there some kind of restriction in OMS that won't let Enterprise
>Manager administer databases that are on the same box as the OMS
>database?

Some versions of the 9i agent won't find the instance unless it is in
listener.ora (as opposed to self-registering).

Try adding the local database to your listener.ora and restarting both
agent and listener.
--
Jim Smith
Because of their persistent net abuse, I ignore mail from
these domains (among others) .yahoo.com .hotmail.com .kr .cn .tw
For an explanation see <http://www.jimsmith.demon.co.uk/spam>

Sponsored Links