Home » RDBMS Server » Networking and Gateways » Add rule to oracle connection manager (Oracle database EE, 11.2.0.4, Linux Rehd Hat 6)
Add rule to oracle connection manager [message #610078] Mon, 17 March 2014 07:40 Go to next message
Malakay79
Messages: 41
Registered: September 2007
Member
I need to add a rule in my oracle connection manager.



Now I do not use rule:

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




I can add this rule:

(rule_list=
(rule=
(src=*)(dst=dbxx-int.dbc.xxx.it)(srv=service_name1_ext)(act=accept)
(src=*)(dst=dbxx-int.dbc.xxx.it)(srv=service_name2_ext)(act=accept)
(action_list=(aut=off)(moct=0)(mct=0)(mit=0)(conn_stats=on))
)
)
)


Since my two service_name end with ext can I use a single rule like this:


I can add a rule like this:

(rule_list=
(rule=
(src=*)(dst=dbxx-int.dbc.xxx.it)(srv=*_ext)(act=accept)
(action_list=(aut=off)(moct=0)(mct=0)(mit=0)(conn_stats=on))
)
)
)



--moderator update: redacted some information, at OP's request. jw.

[Updated on: Tue, 18 March 2014 07:47] by Moderator

Report message to a moderator

Re: Add rule to oracle connection manager [message #610200 is a reply to message #610078] Tue, 18 March 2014 07:25 Go to previous messageGo to next message
Malakay79
Messages: 41
Registered: September 2007
Member
Is this rule correct:

(rule_list=
(rule=
(src=*)(dst=dbxx-int.dbc.xxx.it)(srv=*_ext)(act=accept)
(action_list=(aut=off)(moct=0)(mct=0)(mit=0)(conn_stats=on))
)
)
)


I can't stop the cman and just try.

[Updated on: Tue, 18 March 2014 07:25]

Report message to a moderator

Re: Add rule to oracle connection manager [message #610211 is a reply to message #610200] Tue, 18 March 2014 08:41 Go to previous message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
>I can't stop the cman and just try.
are you saying that you do not have a Test/Dev environment that replicates Production?
Previous Topic: Method of Heterogeneous of Communication between Oracle to SQL Server.
Next Topic: Configuring Oracle gateway for MS SQL Server
Goto Forum:
  


Current Time: Thu Mar 28 04:18:15 CDT 2024