cman / cmctl / connection manager - setup problems on 9i + Linux

From: Dave Smith <ns02gdps_at_alertit.co.uk>
Date: Fri, 8 Nov 2002 18:00:47 +0000 (UTC)
Message-ID: <qntnsuoj218obq3or8991riodeb3g6vobo@4ax.com>

Hi all,

I am having a lot of difficulty getting the Oracle "Connection Manager" (aka CMAN ) feature to work. I am using Oracle 9iR2 (9.2.0) on a Linux (RedHat 8) box. I have read all the related Oracle documentation & trawled through usenet, but am totally stuck. It's probably something really simple that I am missing!

My initial tests are being done on a single Linux box where I am running the database server, cman and the Oracle client. This should be simple, but I keep getting errors when I do "cmctl start". My eventual aim is to get a SQL connection working through a NAT firewall, but first things first!

The error message is: "TNS-04004: CMCTL: error while starting the Connection Manager Admin".

My cman.ora file looks like this:

---

cman = (ADDRESS_LIST=

           (ADDRESS=(PROTOCOL=tcp)(HOST=localhost)(PORT=1631))
       )

cman_admin = (ADDRESS=(PROTOCOL=tcp)(HOST=localhost)(PORT=1831))

cman_profile = (parameter_list=

(MAXIMUM_RELAYS=1024)
(LOG_LEVEL=4)
(TRACING=on)
(RELAY_STATISTICS=yes)
(SHOW_TNS_INFO=yes)
(USE_ASYNC_CALL=yes)
(AUTHENTICATION_LEVEL=0)
(REMOTE_ADMIN=FALSE)

               )

---

My tnsnames.ora file is like this:

---

ORCL.LOCALDOMAIN =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))     )
    (CONNECT_DATA =

      (SERVER = DEDICATED)
      (SERVICE_NAME = ORCL)

    )
  )

CMTEST.LOCALDOMAIN =
  (DESCRIPTION =
    (ADDRESS_LIST =

      (ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1630))
      (ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))

    )
    (CONNECT_DATA =
      (SERVICE_NAME = ORCL)
    )
    (SOURCE_ROUTE=yes)
  )

---

The database is running fine... I can connect to "ORCL" using sqlplus. To test connection manager I want to connect to "CMTEST", but since I can't even get the "cmctl" to run I am a bit stuck. Despite setting "log_level" to 4, only empty log files are being written, which doesn't help.

Any ideas?

Regards
Dave Received on Fri Nov 08 2002 - 12:00:47 CST