How to setup Oracle Connection Manager to connect to Oracle through an SSH tunnel (version 1.0)

Good luck!

1. Discover if Oracle Connection Manager is installed on the Oracle host (192.1.1.167 in this example). Look for a service named OracleOraHomeCMan, where OraHome is the name of the Oracle Home.

    If there are two Oracle Homes and two available OracleOraHomeCMan     services. Select one.

    If there are no such available services, then Oracle Connection     Manager is not installed. Launch Oracle Universal Installer.     From the "Installation Types" menu select "Custom". Install     Oracle Connection Manager.

 2. In the network\ADMIN sub-directory for the selected OraHome,

    create a cman.ora file with these contents. Substitute     hostname for the correct hostname. 1610 is the default     port for Oracle Connection Manager

        CMAN=
        (ADDRESS_LIST=
            (ADDRESS=
                (PROTOCOL=TCP)
                (HOST=hostname)
                (PORT=1610)
            )
        ) 

    Start the Oracle Connection Manager service

 3. Modify your local tnsnames.ora file. Observe that there are

    two address specifications. This is critical. Change the     following as appropriate:

• local net service name (lnsn.domain or lnsn),
• local port number (49000),
• remote ip address (192.1.1.167),
• remote port number for the Oracle listener (1521)
• remote service name (ora)

    lnsn.domain =

      (DESCRIPTION =
        (ADDRESS_LIST =
          (ADDRESS = (PROTOCOL = TCP)(HOST = 127.0.0.1)(PORT = 49000))
          (ADDRESS = (PROTOCOL = TCP)(HOST = 192.1.1.167)(PORT = 1521))
        )
        (CONNECT_DATA =
          (SERVICE_NAME = ora)
        )
        (SOURCE_ROUTE = yes)
      ) 

 4. Connect to the remote computer using SSH to create a tunnel.

    Using Cygwin SSH, this is the syntax:

        ssh -L 49000:192.1.1.167:1610 userid_at_192.1.1.167:

 5. Connect using sqlplus or any other Oracle client

    sqlplus system/manager_at_lnsn Received on Wed Mar 05 2003 - 17:05:33 CST