My Oracle Support Banner

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

Last updated on MARCH 24, 2020

Applies to:

Oracle Net Services - Version 12.1.0.1 and later
Information in this document applies to any platform.

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

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Goal
Solution


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