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

From: Dave Smith <ns02gdps_at_alertit.co.uk>
Date: Fri, 15 Nov 2002 14:40:16 +0000 (UTC)
Message-ID: <ov0atugvtshnotegammefdrgje6663st4o@4ax.com>

Thanks Sybrand.

I made a few minor changes & now it works fine. Just in case anybody else ever needs to do this too, I'll post my install steps & config. files here...

1. Install the "connection manager" software (cmctl, cmadmin etc) from your Oracle media, as it is not installed by default.
2. Create the following cman.ora file in $ORACLE_HOME/network/admin...

   ---

cman = (ADDRESS_LIST=

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

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

cman_profile = (parameter_list=

(MAXIMUM_RELAYS=1024)
(LOG_LEVEL=16)
(TRACING=off)
(RELAY_STATISTICS=yes)
(SHOW_TNS_INFO=yes)
(USE_ASYNC_CALL=yes)
(AUTHENTICATION_LEVEL=0)
(REMOTE_ADMIN=FALSE)

               )

---

3. Open up your firewall to allow access to port 1630 & forward this traffic to the database (and cman) server.

4. On a remote machine, with the oracle client software installed, create the following tnsname.ora file...

---

CMAN_TEST.WORLD =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = www.yourdomain.net)(PORT = 1630))

      (ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))     )
    (CONNECT_DATA =
      (SERVICE_NAME = ORCL)
    )
    (SOURCE_ROUTE=yes)
  )

---

5. Now on the remote PC try "tnsping cman_test.world". If that works then try "sqlplus username_at_cman_test" and you should be able to log in.

Note: for added security, you can restrict which hosts can connect using the "cman_rules" parameter in the cman.ora file.

TTFN Received on Fri Nov 15 2002 - 08:40:16 CST