How Parameter USE_SID_AS_SERVICE Works in CMAN. (Doc ID 2626684.1)

Last updated on JULY 20, 2024

Applies to:

Goal

Connecting to Database server using SID in tnsnames.ora Client End VIA Cman

How We achieve this:

===============================

1) (USE_SID_AS_SERVICE=on)--Was used in cman.ora

cman1 =
(configuration=
(address=(protocol=tcp)(host=x.x.x.x)(port=1522))
(parameter_list =
(aso_authentication_filter=off)
(connection_statistics=yes)
(log_directory=C:\)
(log_level=SUPPORT)
(max_connections=100)
(idle_timeout=0)
(inbound_connect_timeout=0)
(session_timeout=0)
(outbound_connect_timeout=0)
(max_gateway_processes=2)
(min_gateway_processes=1)
(remote_admin=on)
(trace_directory=C:\)
(trace_level=support)
(trace_timestamp=off)
(trace_filelen=1000)
(trace_fileno=1)
(max_cmctl_sessions=4)
(USE_SID_AS_SERVICE=on)##########################Add Here!
)
(rule_list=
(rule=
(src=*)(dst=*)(srv=*)(act=accept)
(action_list=(aut=off)(moct=0)(mct=0)(mit=0)(conn_stats=on))
)
)
)

However,Connecting to DB via Cman : Below Error

SQL> connect c##hv11514@(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=xyz.hv.com)(PORT=1692))(CONNECT_DATA=(SID = ysh)))
ERROR:
ORA-12505: TNS:listener does not currently know of SID given in connect

Solution

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.