Connection Manager under Linux

From: Bill Bell <billb_at_deletethis.ti.com>
Date: Sat, 05 Jan 2002 14:01:26 -0500
Message-ID: <3C374D86.9030301@deletethis.ti.com>

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:

connection manager status
tnsnames.ora file
connection manager log file error.

Questions:

Is it even possible to do this on the same computer?
Any ideas on why it does not work?
Any ideas on how to tell what is wrong?

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))

CMCTL> show all

Address List

(ADDRESS=(PROTOCOL=tcp)(HOST=)(PORT=1630))

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

(RULE_LIST=)

cat tnsnames.ora
# TNSNAMES.ORA Network Configuration File: /home/oracle/network/admin/tnsnames.ora # Generated by Oracle configuration tools.

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)
     )

)

From cman_5783.log file

(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