Add database to tree

[David Gray]

Greetings group,

Windows Server 2003
Oracle 9i (Release2).

Ok I new to Oracle so pease don't shout ;-)

Can anyone tell me how to add databases to the tree when in Oracle
Management Server (OMS) mode as opposed to Standalone mode?


Here are the steps I've taken, please let me know if I've missed
anything obvious.


1. I've created a sample database called DG on the target machine.

2. Updated the service details in the TNSNAMES.ORA.

DG =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = ZIRCON)(PORT = 1521))
)
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = DG)
)
)

3. Checked that the OMS sevice is running.

4. I've discovered the node and it appears in the nodes list. I also
tried a refresh nodes.

5. There appears no way of adding the databases after their node has
been discovered.

I can view the database in standalone mode but not in OMS mode.

I've managed to add in some Oracle Rdb databases running on a VMS box
without error, I would like to define database links between these
databases and the Oracle 9i databases on the Windows box.

All I did for the Rdb databases was was discover the node they reside
on and they appeared in the list.

Thanks in advance,
Dave.

PS - Never posted here before, are HTML posts ok?

[Howard J. Rogers]

"David Gray" <police@spamcop.net> wrote in message
news:a2ntc050fd54faedurfs4k38fm75po51nb@4ax.com... Greetings group, Windows Server 2003 Oracle 9i (Release2). Ok I new to Oracle so pease don't shout ;-) Can anyone tell me how to add databases to the tree when in Oracle Management Server (OMS) mode as opposed to Standalone mode? Here are the steps I've taken, please let me know if I've missed anything obvious. 1. I've created a sample database called DG on the target machine. 2. Updated the service details in the TNSNAMES.ORA. DG = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = ZIRCON)(PORT = 1521)) ) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = DG) ) ) 3. Checked that the OMS sevice is running. 4. I've discovered the node and it appears in the nodes list. I also tried a refresh nodes. 5. There appears no way of adding the databases after their node has been discovered. I can view the database in standalone mode but not in OMS mode.

You need the intelligent agent to be aware of the databases before they will
be discoverable inside OEM.

The intelligent agent is not, however, intelligent. It only "discovers"
things by reading the contents of the listener.ora. That file must have a
static declaration of all instances which you want the agent to know about.
That requires an entry in the SID_LIST section of that file, along these
lines:

LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = mozart)(PORT = 1521))
)
)
)

SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(GLOBAL_DBNAME = win92.dizwell.com)
(ORACLE_HOME = c:\oracle\ora92)
(SID_NAME = win92)
)
(SID_DESC =
(GLOBAL_DBNAME = xxx.dizwell.com)
(ORACLE_HOME = c:\oracle\ora92)
(SID_NAME = xxx)
)
)

With that file sorted, stop and re-start your listener. With that done, stop
and re-start your agent. The contents of
ORACLE_HOME\network\agent\services.ora should be inspected at the point to
see if it makes reference to all the various instances you are hoping to see
in OEM. If they're listed in services.ora, OEM will be able to find them. If
not, not.
I've managed to add in some Oracle Rdb databases running on a VMS box without error, I would like to define database links between these databases and the Oracle 9i databases on the Windows box. All I did for the Rdb databases was was discover the node they reside on and they appeared in the list. Thanks in advance, Dave. PS - Never posted here before, are HTML posts ok?

HTML posts are never OK, because if you're reading them in pine or mutt they
will appear rather odd. Stick to plain text. It's safer, and it gets you a
bigger audience.

Regards
HJR

[David Gray]

Hi,

I checked the contents of listener.ora and there is an entry for the
database DG, all looks to be pretty much the same as your example.

LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0))
)
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = ZIRCON)(PORT = 1521))
)
)
)

SID_LIST_LISTENER =
(SID_LIST =
<snip entries for other databases>
(SID_DESC =
(GLOBAL_DBNAME = DG)
(ORACLE_HOME = C:\oracle\ora92)
(SID_NAME = DG)
)
)


Stopped & restarted the service OracleOrahome92TNSListener.

The c:\oracle\ora92\network\agent\services.ora file does not contain
an entry for the database DG and looks like this...

ZIRCON = (ORACLE_NODE, ZIRCON, ZIRCON, (PLATFORM=(osName=Windows
NT)(osVersion=5.2)(oracleHomes=C:\oracle\ora92)))


listener_ZIRCON = (ORACLE_LISTENER, ZIRCON, (ADDRESS_LIST = (ADDRESS =
(PROTOCOL = TCP)(HOST = ZIRCON)(PORT = 1521))(ADDRESS = (PROTOCOL =
IPC)(KEY = EXTPROC0))), (PROP=(DBS=OEMREP, OEMREP2, oms, ZIRCON)))


OEMREP = (ORACLE_DATABASE, ZIRCON, (DESCRIPTION=(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = ZIRCON)(PORT = 1521)) )
(CONNECT_DATA=(SID=OEMREP)(SERVER=DEDICATED))),
(PROP=(LSNRS=listener_ZIRCON)(ORACLE_HOME=c:\oracle\ora92)(ORACLE_SID=OEMREP)))


OEMREP2 = (ORACLE_DATABASE, ZIRCON, (DESCRIPTION=(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = ZIRCON)(PORT = 1521)) )
(CONNECT_DATA=(SID=OEMREP2)(SERVER=DEDICATED))),
(PROP=(LSNRS=listener_ZIRCON)(ORACLE_HOME=c:\oracle\ora92)(ORACLE_SID=OEMREP2)))


oms = (ORACLE_DATABASE, ZIRCON, (DESCRIPTION=(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = ZIRCON)(PORT = 1521)) )
(CONNECT_DATA=(SID=OMS)(SERVER=DEDICATED))),
(PROP=(LSNRS=listener_ZIRCON)(ORACLE_HOME=c:\oracle\ora92)(ORACLE_SID=OMS)))


ZIRCON = (ORACLE_DATABASE, ZIRCON, (DESCRIPTION=(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = ZIRCON)(PORT = 1521)) )
(CONNECT_DATA=(SID=ZIRCON)(SERVER=DEDICATED))),
(PROP=(LSNRS=listener_ZIRCON)(ORACLE_HOME=c:\oracle\ora92)(ORACLE_SID=ZIRCON)))


ZIRCON:4443 = (oracle_sysman_webserver, ZIRCON,
http://ZIRCON:4443/server-status, unavailable,
C:\oracle\ora92/Apache/Apache/conf/httpd.conf,
C:\oracle\ora92/Apache/Apache)



Is this file rebuilt from the LISTENER.ORA & TNSNAMES.ORA files when
the service starts?

Cheers,
Dave.



On Tue, 15 Jun 2004 21:40:57 +1000, "Howard J. Rogers"
<hjr@dizwell.com> wrote:
"David Gray" <police@spamcop.net> wrote in messagenews:a2ntc050fd54faedurfs4k38fm75po51nb@4ax.com... Greetings group, Windows Server 2003 Oracle 9i (Release2). Ok I new to Oracle so pease don't shout ;-) Can anyone tell me how to add databases to the tree when in Oracle Management Server (OMS) mode as opposed to Standalone mode? Here are the steps I've taken, please let me know if I've missed anything obvious. 1. I've created a sample database called DG on the target machine. 2. Updated the service details in the TNSNAMES.ORA. DG = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = ZIRCON)(PORT = 1521)) ) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = DG) ) ) 3. Checked that the OMS sevice is running. 4. I've discovered the node and it appears in the nodes list. I also tried a refresh nodes. 5. There appears no way of adding the databases after their node has been discovered. I can view the database in standalone mode but not in OMS mode.You need the intelligent agent to be aware of the databases before they willbe discoverable inside OEM.The intelligent agent is not, however, intelligent. It only "discovers"things by reading the contents of the listener.ora. That file must have astatic declaration of all instances which you want the agent to know about.That requires an entry in the SID_LIST section of that file, along theselines:LISTENER = (DESCRIPTION_LIST = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = mozart)(PORT = 1521)) ) ) )SID_LIST_LISTENER = (SID_LIST = (SID_DESC = (GLOBAL_DBNAME = win92.dizwell.com) (ORACLE_HOME = c:\oracle\ora92) (SID_NAME = win92) ) (SID_DESC = (GLOBAL_DBNAME = xxx.dizwell.com) (ORACLE_HOME = c:\oracle\ora92) (SID_NAME = xxx) ) )With that file sorted, stop and re-start your listener. With that done, stopand re-start your agent. The contents ofORACLE_HOME\network\agent\services.ora should be inspected at the point tosee if it makes reference to all the various instances you are hoping to seein OEM. If they're listed in services.ora, OEM will be able to find them. Ifnot, not. I've managed to add in some Oracle Rdb databases running on a VMS box without error, I would like to define database links between these databases and the Oracle 9i databases on the Windows box. All I did for the Rdb databases was was discover the node they reside on and they appeared in the list. Thanks in advance, Dave. PS - Never posted here before, are HTML posts ok?HTML posts are never OK, because if you're reading them in pine or mutt theywill appear rather odd. Stick to plain text. It's safer, and it gets you abigger audience.RegardsHJR

[Howard J. Rogers]

"David Gray" <police@spamcop.net> wrote in message
news:nvptc01k06dmrhtta8l6vfvm0a78lnrq12@4ax.com... Hi, I checked the contents of listener.ora and there is an entry for the database DG, all looks to be pretty much the same as your example. LISTENER = (DESCRIPTION_LIST = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0)) ) (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = ZIRCON)(PORT = 1521)) ) ) ) SID_LIST_LISTENER = (SID_LIST = <snip entries for other databases> (SID_DESC = (GLOBAL_DBNAME = DG) (ORACLE_HOME = C:\oracle\ora92) (SID_NAME = DG) ) )


Stopped & restarted the service OracleOrahome92TNSListener.

And then you stopped and re-started the agent, I hope?
The c:\oracle\ora92\network\agent\services.ora file does not contain an entry for the database DG and looks like this...

Well, it's not clear from your post whether you did or not, but you can't
expect that file to suddenly acquire new content without stopping and
starting your agent service. If you like, delete services.ora and *.q from
O_H\network\agent before trying to re-start the agent.
Is this file rebuilt from the LISTENER.ORA & TNSNAMES.ORA files when the service starts?

The tnsnames has got nothing to do with it at all. But yes, the file is
re-constructed every time the agent is re-started, by taking a fresh look at
the listener.ora's SID_LIST section.

Regards
HJR

[David Gray]

On Tue, 15 Jun 2004 23:52:45 +1000, "Howard J. Rogers"And then you stopped and re-started the agent, I hope?

Oops no, I forgot that. The database is now in the databases tree.

Is this file rebuilt from the LISTENER.ORA & TNSNAMES.ORA files when the service starts?

The tnsnames has got nothing to do with it at all. But yes, the file isre-constructed every time the agent is re-started, by taking a fresh look atthe listener.ora's SID_LIST section.RegardsHJR

Thanks again for your help.

Dave.

[Howard J. Rogers]

"David Gray" <police@spamcop.net> wrote in message
news:c40uc0l52q7dg5795l4vrgh07j99d23sr9@4ax.com... On Tue, 15 Jun 2004 23:52:45 +1000, "Howard J. Rogers"And then you stopped and re-started the agent, I hope? Oops no, I forgot that. The database is now in the databases tree.

Good! Nice to know we can get there in the end.

Regards
HJR