Hello All,

I am trying to use connection manager(10.2.0.3) to manage connections to by db(rac) server (10.2.0.2).

CMAN.ORA
===========
CMAN_myjpswolictra01 =
(configuration=

# Listening address of the cman
(address=(protocol=tcp)(host=3.246.102.66)(port=1521))

# Configuration parameters of this CMAN
(parameter_list =

# Log files would be created in the directory specified here
#(log_directory=D:\oracle\product\10.2.0\db_1\NETWORK\log)

# Logging would be in done at this level
# Valid values: OFF | USER | ADMIN | SUPPORT
(log_level=admin)

# Trace files would be created in the directory specified here
(trace_directory=D:\oracle\product\10.2.0\db_1\NETWORK\trace)

# Trace done at this level
# Valid values: OFF | USER | ADMIN | SUPPORT
(trace_level=admin)

(rule_list=
(rule=
(src=*)(dst=*)(srv=*)(act=accept)
(action_list=(aut=off)(moct=0)(mct=0)(mit=0)(conn_stats=on))
)
)



LISTENER.ORA
=============

SID_LIST_CMAN_myjpswolictra01 =
(SID_LIST =
(SID_DESC=
(GLOBAL_DBNAME=shcl1.r4.com)
(SID_NAME=shcl1)
)
)


CMAN_myjpswolictra01 =
(ADDRESS_LIST=
(ADDRESS=(PROTOCOL=tcp)(HOST=myjpswolictra01.R4.Com)(PORT=1521))
)


TNSNAMES.ORA
============
TR.R4.COM =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 3.246.102.66)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = TRECS.r4.com)
)
)


As the documentation 10gR2 has said that i will have to make an entry in the remote_listener init parameter in the db.

alter system set remote_listener='(DESCRIPTION =(ADDRESS_LIST= (ADDRESS=(PROTOCOL=TCP)(HOST=3.208.169.193)(PORT=1521)) (ADDRESS =(PROTOCOL=TCP)(HOST=3.246.102.66)(PORT=1521)) ) )' scope=both;

3.246.102.66=> the cman server
3.208.169.193=> rac node2


But lsnrctl service shows
C:\Documents and Settings\eFinadmin>lsnrctl service

LSNRCTL for 32-bit Windows: Version 10.2.0.3.0 - Production on 22-AUG-2007 14:22:24

Copyright (c) 1991, 2006, Oracle. All rights reserved.

Connecting to (ADDRESS=(PROTOCOL=tcp)(HOST=)(PORT=1521))
Services Summary...
Proxy service "cmgw" has 1 instance(s).
Instance "cman", status READY, has 2 handler(s) for this service...
Handler(s):
"cmgw001" established:0 refused:0 current:0 max:512 state:ready

(ADDRESS=(PROTOCOL=tcp)(HOST=127.0.0.1)(PORT=1297))
"cmgw000" established:0 refused:0 current:0 max:512 state:ready

(ADDRESS=(PROTOCOL=tcp)(HOST=127.0.0.1)(PORT=1296))
Service "cmon" has 1 instance(s).
Instance "cman", status READY, has 1 handler(s) for this service...
Handler(s):
"cmon" established:0 refused:0 current:0 max:4 state:ready

(ADDRESS=(PROTOCOL=tcp)(HOST=127.0.0.1)(PORT=1286))
The command completed successfully



There are no details of that shows the db has registered with this listener.


C:\Documents and Settings\eFinadmin>sqlplus trecs@TR.R4.COM

SQL*Plus: Release 10.2.0.3.0 - Production on Wed Aug 22 14:26:23 2007

Copyright (c) 1982, 2006, Oracle. All Rights Reserved.

Enter password:
ERROR:
ORA-12514: TNS:listener does not currently know of service requested in connect
descriptor


Does somebody have any idea, where i have gone wrong ??

Any help would be much appreciated.

Regards,
John