-
Hi,
Recently I changed my DB to have MTS and I did the following changes. Now whenevr I start Intelligent agent, I am getting the warning "No Listener found for SID ORCL. ORCL will be skipped"
initORCL.ora:
------------------
db_name = "dbacct"
instance_name = ORCL
service_names = dbacct.dev05.intacct.com
....
....
#mts_dispatchers = "(PROTOCOL=TCP)(DISPATCHERS=3)"
MTS_DISPATCHERS=
"(ADDRESS=(PROTOCOL=TCP)(HOST=localhost)(PORT=1521))(DISPATCHERS=2)"
MTS_DISPATCHERS=
"(ADDRESS=(PROTOCOL=TCP)(HOST=localhost)(PORT=1522))(DISPATCHERS=1)"
mts_servers = 1
Listener.ora
-------------
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC))
)
)
)
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(GLOBAL_DBNAME=dbacct.dev05.intacct.com)
(ORACLE_HOME = /oracle/product/8.1.6)
(SID_NAME = ORCL)
)
(SID_DESC =
(ORACLE_HOME = /oracle/product/8.1.6)
(SID_NAME = STBY)
)
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = /oracle/product/8.1.6)
(PROGRAM = extproc)
)
)
Lsnrctl Status output:
----------------------
lsnrctl status
LSNRCTL for Linux: Version 8.1.6.0.0 - Production on 25-JAN-2001 18:15:21
(c) Copyright 1998, 1999, Oracle Corporation. All rights reserved.
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC)))
STATUS of the LISTENER
------------------------
Alias LISTENER
Version TNSLSNR for Linux: Version 8.1.6.0.0 - Production
Start Date 25-JAN-2001 17:39:18
Uptime 0 days 0 hr. 36 min. 2 sec
Trace Level off
Security OFF
SNMP OFF
Listener Parameter File /oracle/product/8.1.6/network/admin/listener.ora
Listener Log File /oracle/product/8.1.6/network/log/listener.log
Services Summary...
PLSExtProc has 1 service handler(s)
STBY has 1 service handler(s)
ORCL has 1 service handler(s)
The command completed successfully
Tnsnames.ora:
------------
DEV05 =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = dbacct.dev05.intacct.com)
)
)
What am I doing wrong here?. why the "lsnrctl status" doesn't show the dispatchers?. How do I get the Intelligent agent start working with the MTS configuration?
If I connect using "DEV05", I see the connection established as "SHARED"
-
Could you check the parameters for MAX_DISPATCHERS. Seems service name is missing thats registered with Listener.
Give parameter service=ORCL and try.
http://www-wnt.gsi.de/oragsidoc/doc_...h198.htm#64057
-
But, I specify "SERVICE_NAMES" parameter in the init.ora. Oracle doc says "If no value is specified for SERVICE, the service names specified with the SERVICE_NAMES parameter are used".
Anyway, I vl do some more research. Mean time, if any of u can get me some document on how u configure intelligent agent with MTS running, I would greatly appreciate it.
