mts setup for 7.1.3/Solaris 2.4
Date: 30 Dec 1994 00:19:20 GMT
Message-ID: <GAVIN.94Dec30021920_at_durban.vector.co.za>
Hi,
I am trying to configur the mts service for Oracle 7.1.3 on Solaris 2.4 for SPARC. I have successfully completed this for 7.0.15 and 2.3 in the past, but the same approach seems to fail now. Here are the relevant bits. Any suggestions appreciated.
The problem is the same if I try IPC adapter. Basically Oracle is unable to start any dispatchers going. The alert file says the dispatcher encountered an error in sending a message to the listener. Tracing the waiting listener at startup time shows no action there at all. The trace file for the failed dispatcher is as follows:
Dump file /home/oracle/rdbms/log/ora_4062.trc
Oracle7 Server Release 7.1.3.0.0 - Production Release
With the distributed and parallel query options
PL/SQL Release 2.1.3.0.0 - Production
ORACLE_HOME = /home/oracle
ORACLE_SID = GAV
Oracle process number: 0 Unix process id: 4062 System name: SunOS Node name: durban Release: 5.4 Version: Generic_101945-13 Machine: sun4m
OPIRIP: Uncaught error 108. Error stack: ORA-00108: failed to set up dispatcher to accept connection asynchronously
That suggests that perhaps there is a parameter that I could put in sqlnet.ora or protocol.ora that tells it not to try to use connection async'ly. oerr ORA 108 says that the most likely cause is that the protocol selected does not support async connections. I saw a post today that said that async connections will come with 7.2, so perhaps it shouldn't be trying to start async?
I have trussed the oracle exectable while it tries to start a dispatcher with no great insight. It *seems* to decide to abort after an ioctl on /dev/tcp for F_GETOWN which returns EINVAL.
I'm running out of ideas. Can anybody help?
Thanks
gavin
here are the setup files
# listener.ora
TCPLISTENER=
(ADDRESS_LIST=
(ADDRESS=
(PROTOCOL=TCP)
(HOST=durban)
(PORT=2525)
)
)
STARTUP_WAIT_TIME_TCPLISTENER = 0
CONNECT_TIMEOUT_TCPLISTENER = 10
SID_LIST_TCPLISTENER=
(SID_LIST=
(SID_DESC=
(SID_NAME=GAV)
(ORACLE_HOME=/home/oracle/)
)
)
TRACE_LEVEL_LISTENER = ADMIN
# excerpt from init.ora
MTS_MAX_DISPATCHERS=5 MTS_SERVERS=2 MTS_MAX_SERVERS=5 MTS_SERVICE=GAV MTS_DISPATCHERS="TCP,1" MTS_LISTENER_ADDRESS="(ADDRESS=(PROTOCOL=TCP)(HOST=durban)(PORT=2525))" -------------------
#tnsnames.ora
GAV_tcp=
(DESCRIPTION=
(ADDRESS_LIST=
(ADDRESS=(PROTOCOL=tcp)
(HOST=durban)
(PORT=2525)
)
)
(CONNECT_DATA=
(SID=GAV)
)
)
The listener starts up fine.
--
.
/| The
/ | Vector
/ | Group ---------------------------------------
/\ |____ Gavin Maltby, Vector Durban
/ \/| | Email: gavin_at_durban.vector.co.za
\ \| | Tel: INT+ 27 31 266 9948
\ | / Fax: INT+ 27 31 266 0811
\ | / Note: I speak for myself, and not
\ | / necessarily for Vector or Sun!
\|/ --------------------------------------
" Sun Partner in South Africa
Received on Fri Dec 30 1994 - 01:19:20 CET