-
I have set my init.ora to the following....
mts_dispatchers = "(PROTOCOL=TCP)(PRE=oracle.aurora.server.SGiopServer)(DISPATCHERS=5)"
mts_servers=5
mts_max_servers=100
I've also changed the listener.ora file to .....
# LISTENER.ORA Network Configuration File: /n01/app/oracle/product/8.1.6/network/admin/listener.ora
# Generated by Oracle configuration tools.
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC))
)
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = iggy)(PORT = 1521))
)
)
(DESCRIPTION =
(PROTOCOL_STACK =
(PRESENTATION = GIOP)
(SESSION = RAW)
)
(ADDRESS = (PROTOCOL = TCP)(HOST = iggy)(PORT = 2481))
)
)
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = /n01/app/oracle/product/8.1.6)
(PROGRAM = extproc)
)
(SID_DESC =
(GLOBAL_DBNAME = iggy.fundshub.com)
(ORACLE_HOME = /n01/app/oracle/product/8.1.6)
(SID_NAME = iggy)
)
(SID_DESC =
(GLOBAL_DBNAME = catl.fundshub.com)
(ORACLE_HOME = /n01/app/oracle/product/8.1.6)
(SID_NAME = catl)
)
)
However when i check the services on lsnrctl, I don't get any dispatcher info.....
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC)))
Services Summary...
PLSExtProc has 1 service handler(s)
DEDICATED SERVER established:0 refused:0
LOCAL SERVER
catl has 1 service handler(s)
DEDICATED SERVER established:0 refused:0
LOCAL SERVER
iggy has 1 service handler(s)
DEDICATED SERVER established:11 refused:0
LOCAL SERVER
The command completed successfully
I've looked in v$dispatcher and there are 5 there, listening on ports 36700,36701,36702,36703,36704.....
Why don't i get any information about the dispatchers when i query the listener services?????
-
After setting things did you get to bounce your instances and listener?
It looks like your database is still in the dedicated server mode and not in mts mode. that is the reason why you notice the dedicated server information and not the MTS information.
Sam
-
What kind of Oracle server are you runing? Standard or Enterprise edition?
I've noticed in Oracle 8.1.6 Standard Edition on NT that SERVICES command in lsnrctl displays only dedicated servers, while shared servers are not displayed although the MTS is correctly configured and works as it should. I think this is a bug in Standard edition....
-
I'm using the Enterprise Edition 8.1.6.1.0 64 bit on slaris 2.7 64 bit.
I've stopped restarted database and listener.
The only thing I can think of is that this machine is on the other side of a firewall and the mts ports aren't allowing data through. I believe you can hard code the ports for the dispatcher? Is this true...?
-
Yes, you can "fix" the port the dispatcher uses to connect user to the database over a shered server. The following is the entry we use to allow connections on fixed port through firewall using MTS:
mts_dispatchers = "(address=(PARTIAL=TRUE)(PROTOCOL=TCP)(HOST=my_host)(PORT=2000))"
HTH,
