Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Connection Manager under Linux
I am trying to experiment with how to get connection manager working. I am
using Oracle 8.1.7 under Linux (Mandrake 8.1). I am doing all this on the
same computer.
Oracle is running fine. Connection manager appears to be working. I can connect to the database via sqlplus and via Oracle's Java thin client. I setup connection manager according to admin guide using netasst (BTW, netasst does not work with the JRE provided with the release).
I can connect to the database in the normal way using the following connect string (using JDBC Explorer from Borland). This says the listener on 1521 is working fine.
jdbc:oracle:thin:@bill:1521:oralin
I try to use the following connect string to get to the database via connection manager:
jdbc:oracle:thin:@bill:1630:testcm
The error is connection refused.
The error in the log file is
(EVENT=20)(RLYNO=0)(REASON=16)
I looked up the error and it say something about not have the tnsnames setup
correctly.
I have included info on:
Questions:
CMAN Status:
(STATUS=(VERSION=8.1.7.0.0)(STARTED=05-JAN-2002 12:50:36)(STATE=running))
ADMIN Status:
(STATUS=(VERSION=8.1.7.0.0)(STARTED=05-JAN-2002 12:50:34)(STATE=RUNNING))
Address List
Profile of the CMAN
MAXIMUM_RELAYS = 128 RELAY_STATISTICS = no AUTHENTICATION_LEVEL = 0 LOG_LEVEL = 4 SHOW_TNS_INFO = no ANSWER_TIMEOUT = 0 MAXIMUM_CONNECT_DATA = 1024 USE_ASYNC_CALL = yes TRACING = no TRACE_DIRECTORY = default MAX_FREELIST_BUFFERS = 0 REMOTE_ADMIN = no
Rule List
ORALIN =
(DESCRIPTION =
(ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = bill)(PORT = 1521)) ) (CONNECT_DATA = (SERVICE_NAME = oralin.bill.com) )
TESTCM =
(DESCRIPTION =
(ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = bill)(PORT = 1630)) (ADDRESS = (PROTOCOL = TCP)(HOST = bill)(PORT = 1521)) ) (SOURCE_ROUTE = yes) (CONNECT_DATA = (SERVICE_NAME = oralin.bill.com) )
INST1_HTTP =
(DESCRIPTION =
(ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = bill)(PORT = 1521)) ) (CONNECT_DATA = (SERVER = SHARED) (SERVICE_NAME = oralin.bill.com) (PRESENTATION = http://admin) )
EXTPROC_CONNECTION_DATA =
(DESCRIPTION =
(ADDRESS_LIST = (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC)) ) (CONNECT_DATA = (SID = PLSExtProc) (PRESENTATION = RO) )
(TIMESTAMP=05-JAN-2002
13:04:04)(EVENT=20)(RLYNO=0)(REASON=16)(ADDRESS=(PROTOCOL=tcp)(HOST=192.168.1.1)(PORT=33225))
Received on Sat Jan 05 2002 - 13:01:26 CST