Configuring Oracle connection manager - error when starting OCM

From: Krishna <krishna.setwin_at_gmail.com>
Date: Tue, 3 Aug 2010 12:53:15 -0500
Message-ID: <AANLkTintEBCs_VNkAcc3E8rvi3Gd+xqYJ49qKHksKVs6_at_mail.gmail.com>

 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

--
http://www.freelists.org/webpage/oracle-l

Received on Tue Aug 03 2010 - 12:53:15 CDT