Configuring Oracle connection manager - error when starting OCM
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.
(address=(protocol=tcp)(host=<proxy server IP>)(port=1521)) (parameter_list =
(src=<proxy server IP>)(dst=<database server IP>)(srv=<sid of db>)(act=accept)
(ADDRESS = (PROTOCOL = TCP)(Host = db server ip)(Port = 1521)) )
(SID = dvqmdb01)
(HS = OK)
(ADDRESS = (PROTOCOL = TCP)(HOST = proxy server ip)(PORT = 1521) (ADDRESS = (PROTOCOL = TCP)(HOST = db server IP)(Port = 1521)))
(SERVICE_NAME = dvqmdb01)
(SOURCE_ROUTE = YES)
on db server: i have configured
ALTER SYSTEM SET REMOTE_LISTENER='cman_listener'
listener.ora file -- i added:
(ADDRESS = (PROTOCOL = TCP)(HOST = <proxy server ip>)(PORT = 1521)) )
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC)) )
I have used this document.
I am executing the below stmts from proxy server , where OCM is configured.
I am getting this error:
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.
TNS-04012: Unable to start Oracle Connection Manager instance. can i please know did I do any configuration error?? any syntax errors??