[prblades]

Hello there

I'm trying to start the intelligent agent service up and I get this message: "Could not start the OracleOraHome92Agent service on Local Computer.
The service did not return an error. This could be an internal Windows error or an internal service error. If the problem persists, contact your system administrator."

My nmiconf.log says "DBSNMP for 32-bit Windows: release 9.2.0.0.0 - Production on 15-JUN-04 12:14:49
Discovering services on adam configured on host addresses {adam 68.189.29.31}
Warning : Skipping OracleOraHome92TNSListener : Could not find corresponding listener definition in {F:\oracle9\ora92\network\admin\listener.ora}
Warning : No Listener found for SID ORACLE81. ORACLE81 will be skipped"

Here's my listener.ora.. let me know if you see something obvious:

# LISTENER.ORA Network Configuration File: F:\oracle9\ora92\network\admin\listener.ora
# Generated by Oracle configuration tools.

LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC2))
)
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = adam)(PORT = 1521))
)
)
)

SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME=PLSExtProc)
(ORACLE_HOME = F:\oracle9\ora92)
(PROGRAM = extproc)
)
(SID_DESC =
(GLOBAL_DBNAME=oracle9.dbdomain.com)
(ORACLE_HOME=F:\oracle9\ora92)
(SID_NAME=oracle9)
)
)

I don't know what to do.. I'm running windows 2k Pro. I installed the SNMP service and that didn't work. Thanks for your help

Adam

[joebednarz]

Normally, I would put the following:

(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC2))
)
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = adam)(PORT = 1521))
)

like this:

(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC2))
(ADDRESS = (PROTOCOL = TCP)(HOST = adam)(PORT = 1521))
)

Don't know that this will fix your problem... are you SURE this is the listener.ora being used? For instance, the error returned by the lsnrctl program indicates it can't find a listener for sid ORACLE81 while in your listener.ora you pasted, the only sid listed is ORACLE9... do you have the environment variable TNS_ADMIN set? If so, wherever this variable is pointing to is where oracle products will look for set up files such as listener.ora and tnsnames.ora

Hope this helps!

JoeB

[joebednarz]

Whoops... forgot to fully read your question...

looks like in your $ORACLE_HOME/network/agent directory you need to do some clean up. Namely, go through and delete the *.q and services.ora files. Then restart the agent and see what happens.

[prblades]

Hello there -- thank you for your reply

I cleaned up my agent directory fixed my listener.ora exactly the way you posted it and made sure there were no extra parentheses. I added TNS_ADMIN as a environment variable with this path: F:\oracle9\ora92\network\admin Hopefully I did that part right. Started up the agent and it's a no go. Is there some command I need to put in a file for the listener to autodiscover services? This is what's in my nmiconf.log:


DBSNMP for 32-bit Windows: release 9.2.0.0.0 - Production on 15-JUN-04 14:47:59
Discovering services on adam configured on host addresses {adam 68.189.29.31}
Warning : Skipping OracleOraHome92TNSListener : Could not find corresponding listener definition in {F:\oracle9\ora92\network\admin\listener.ora}
Warning : No Listener found for SID ORACLE81. ORACLE81 will be skipped

Here is my OracleOraHome92Agent.nohup file:

--------------------------- 06/15/2004 2:47p -------------------------
-----------------------------------------------------------------
Service name is OracleOraHome92Agent
Failed while initializing Collection Service
Error initializing subsystems
Agent exited on 06/15/2004 2:48p with return value 55
Could not start agent. Initialization failure
Agent startup failed. Check F:\oracle9\ora92\network\log\OracleOraHome92Agent. nohup for details


Here is my tnsnames.ora:

# TNSNAMES.ORA Network Configuration File: F:\oracle9\ora92\network\admin\tnsnames.ora
# Generated by Oracle configuration tools.

ORACLE9 =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = adam)(PORT = 1521))
)
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME=oracle9.dbdomain.com)
)
)

INST1_HTTP =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = adam)(PORT = 1521))
)
(CONNECT_DATA =
(SERVER = SHARED)
(SERVICE_NAME=oracle9.dbdomain.com)
(PRESENTATION=http://admin)
)
)

EXTPROC_CONNECTION_DATA =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC2))
)
(CONNECT_DATA =
(SID = PLSExtProc)
(PRESENTATION = RO)
)
)

Here is my sqlnet.ora :

# SQLNET.ORA Network Configuration File: F:\oracle9\ora92\network\admin\sqlnet.ora
# Generated by Oracle configuration tools.

SQLNET.AUTHENTICATION_SERVICES= (NTS)

NAMES.DIRECTORY_PATH= (TNSNAMES, ONAMES, HOSTNAME)

[prblades]

There was a conflict with another service on my computer. I have Oracle 8i and 9i installed on the same computer and I turned off the OracleOraHome81DataGatherer service and the 9i Intelligent Agent started up with no problems.

[joebednarz]

Very cool! Glad it is working for you.

[MountainMitch]

Hi,

Just wanted to let you know that I just found this forum today by web search and the clean-up of the $ORACLE_HOME/network/agent directory got my Intelligent Agent working again as well!

Thanks!
MM