|
Hi friends.........
I am having a problem when trying to connect
through connection manger i have in my tnsnames.ora and cman.ora as given
below then use_cman = TRUE in sqlnet.ora
and my server is configured for MTS . It's on
oracle 8.1.7 in win 2k .
-------------------------
TNSNAMES.ORA
-------------------------
ABC =
(DESCRIPTION = (load_balance=on) (failover=on) (ADDRESS_LIST = ( SOURCE_ROUTE = YES ) ( ADDRESS = ( PROTOCOL = TCP )( HOST = oracle )(SERVICE = CMAN)( PORT = 1610 )) ( ADDRESS = (PROTOCOL = TCP)(HOST = oracle)(SERVICE = CMAN )( PORT = 1521)) ) ( CONNECT_DATA = ( SERVICE_NAME = oracledb ) ) ) -----------------------
CMAN.ORA
-----------------------
cman =
(ADDRESS_LIST=
( ADDRESS=( PROTOCOL=tcp ) ( HOST= oracle ) ( PORT=1630 ) ( QUEUESIZE=32 ) ) ) cman_profile = ( parameter_list= ( MAXIMUM_RELAYS=1024 ) ( LOG_LEVEL=1 ) ( TRACING=yes ) ( RELAY_STATISTICS=yes ) ( SHOW_TNS_INFO=yes ) ( USE_ASYNC_CALL=yes ) ( AUTHENTICATION_LEVEL=0 ) ( REMOTE_ADMIN=FALSE ) ) CMAN_ADMIN = (ADDRESS=(PROTOCOL=tcp)(HOST=oracle)(PORT=1650)) CMANAGER_NAME = cman But i am getting the error 12541 no
listener .Please help me in solving this
This is urgent
shibu |
