How to set MTS ?

From: <eduardo_at_autofax.com.br>
Date: Wed, 06 Jan 1999 20:07:34 GMT
Message-ID: <770fq5$3jq$1@nnrp1.dejanews.com>

Hello,

We are using Oracle 8.0.3 on Netware 4.11 and it's working fine, but We can't set the database for MTS.

When we configure to MTS with TCP/IP, the database doesn't mount. With SPX, the database mount, but alert.log register errors.

Settings:
------------- SPX/IPX
. ALERT.LOG

  starting up 2 shared server(s) ...
  starting up 1 dispatcher(s) for network protocol '(ADDRESS=(PARTIAL=YES) (PROTOCOL=SPX))'...
Wed Jan 6 17:45:02 1999 -
  dispatcher 'D000' encountered error registering for events

. An trace file was created:

Wed Jan 6 17:45:02 1999 -
network error encountered stering for events OPIRIP: Uncaught error 108. Error stack: ORA-00108: failed to set up dispatcher to accept connection asynchronously

. INIT.ORA

MTS_DISPATCHERS="spx,1"
MTS_MAX_DISPATCHERS=5
MTS_SERVERS=2
MTS_MAX_SERVERS=5
MTS_SERVICE=ORCMTS
MTS_LISTENER_ADDRESS="(ADDRESS = (PROTOCOL = spx)(service = orcl_lsnr_spx))"

. LISTENER.ORA

LISTENER =
(ADDRESS_LIST =

     (ADDRESS =
       (PROTOCOL = IPC)
       (KEY = ORCL_LSNR_IPC)
     )
     (ADDRESS =
       (PROTOCOL = SPX)
       (SERVICE = ORCL_LSNR_SPX)
     )
     (ADDRESS =
       (PROTOCOL = TCP)
       (HOST = 10.10.200.5)
       (PORT = 1521)
     )

)

TCP/IP
. ALERT.LOG
no messages, the database didn't mount

. MESSAGE ON CONSOLE: SVRMGR> startup pfile=db:oranw803\database\init.ora
ORA-00602: internal programming exception ORA-00101: invalid specification for system parameter MTS_DISPATCHERS ORA-00102: network protocol (ADDRESS=(PARTIAL=YES)(PROTOCOL=tcp)) cannot be used by dispatchers SVRMGR>

. INIT.ORA

MTS_DISPATCHERS="tcp,1"
MTS_MAX_DISPATCHERS=5
MTS_SERVERS=2
MTS_MAX_SERVERS=5
MTS_SERVICE=ORCMTS
MTS_LISTENER_ADDRESS="(ADDRESS=(PROTOCOL=tcp)(host=10.10.200.5)(port=1521))"

. LISTENER.ORA

the same as above...

Does anybody knows what's wrong?

If anybody know anything, please write.

Thank You,
Eduardo Piovesam

-----------== Posted via Deja News, The Discussion Network ==---------- http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own Received on Wed Jan 06 1999 - 14:07:34 CST