How Parameter USE_SID_AS_SERVICE Works in CMAN.
(Doc ID 2626684.1)
Last updated on JULY 20, 2024
Applies to:
Oracle Net Services - Version 12.1.0.1 and laterInformation 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 |