Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Connection Manager under Linux

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:

  1. connection manager status
  2. tnsnames.ora file
  3. connection manager log file error.

Questions:


  1. Is it even possible to do this on the same computer?
  2. Any ideas on why it does not work?
  3. 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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US