Configuring Oracle connection manager - error when starting OCM

From: Krishna <krishna.setwin@xxxxxxxxx>
To: oracle-l@xxxxxxxxxxxxx
Date: Tue, 3 Aug 2010 12:53:15 -0500
 Hi List members,


I am trying to set up oracle connection manager.

this is the route I have to configure ::  weblogic server --> proxy server
--> db server
weblogic server shd talk to db server through proxy server ONLY.

I have installed OCM on proxyserver. The  cman.ora & tnsnames.ora of proxy
server are below.

-------------------------------------------------

cman1 =
(configuration=
    (address=(protocol=tcp)(host=<proxy server IP>)(port=1521))
    (parameter_list =
        (aso_authentication_filter=off)
        (connection_statistics=yes)
        (log_directory=/app/oracle/product/10.2.0/db_1/network/log)
        (log_level=off)
        (max_connections=256)
        (idle_timeout=0)
        (inbound_connect_timeout=0)
        (session_timeout=0)
        (outbound_connect_timeout=0)
        (max_gateway_processes=8)
        (min_gateway_processes=2)
        (remote_admin=YES)
        (trace_directory=/app/oracle/product/10.2.0/db_1/network/log)
        (trace_level=off)
        (trace_timestamp=off)
        (trace_filelen=1000)
        (trace_fileno=1)
        (max_cmctl_sessions=4)
        (event_group=init_and_term,memory_ops)
    )
    (rule_list=
        (rule=
            (src=<proxy server IP>)(dst=<database server IP>)(srv=<sid of
db>)(act=accept)
            (action_list=(aut=ON)(mct=120)(mit=30)(conn_stats=on))
        )
    )
)

-------------------------------------------------------------

DVQMDB01 =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(Host = db server ip)(Port = 1521))
    )
    (CONNECT_DATA =
      (SID = dvqmdb01)
    )
    (HS = OK)
  )

CMAN9 =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = proxy server ip)(PORT = 1521)
      (ADDRESS = (PROTOCOL = TCP)(HOST = db server IP)(Port = 1521))
    )
    (CONNECT_DATA =
      (SERVICE_NAME = dvqmdb01)
    )
    (SOURCE_ROUTE = YES)
  )

------------------------------------------------------------


on db server: i have configured
ALTER SYSTEM SET REMOTE_LISTENER='cman_listener'

listener.ora file -- i added:

cman_listener =
  (DESCRIPTION_LIST =
    (DESCRIPTION =
      (ADDRESS = (PROTOCOL = TCP)(HOST = <proxy server ip>)(PORT = 1521))
    )
    (DESCRIPTION =
      (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC))
    )
  )


------------------------
I have used this document.
http://download.oracle.com/docs/cd/B19306_01/network.102/b14212/cman.htm#i489603


I am executing the below stmts from proxy server , where OCM is configured.

I am getting this error:

CMCTL> adminster
NL-00853: undefined command "adminster".  Try "help"
CMCTL> administer
Current instance CMAN_proxyserver is not yet started
Connections refer to (ADDRESS=(PROTOCOL=TCP)(HOST=<proxy
hostname>)(PORT=1521)).
The command completed successfully.
CMCTL:CMAN_proxyserver> start
TNS-04012: Unable to start Oracle Connection Manager instance.
can i please know did I do any configuration error?? any syntax errors??

Regards
Krishna
Configuring Oracle connection manager - error when starting OCM

Other related posts:
