Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

How to configure Connection Manager to work with firewall on the 11g?

ImmunitetMay 25 2009 — edited May 25 2009
I have next structure:
client server |--- firewall ---| database server
I have installed CMAN on the client machine:
IP-adress 10.8.1.10

tnsnames.ora
DB=
  (DESCRIPTION=
    (ADDRESS=
      (PROTOCOL=tcp)
      (HOST=10.8.1.10)
      (PORT=1630))
    (CONNECT_DATA=
      (SERVICE_NAME=DB)))
cman.ora
cman=
(configuration=
  (address=(protocol=tcp)(host=hostname)(port=1630))
  (rule_list=
    (rule=
       (src=hostname)(dst=127.0.0.1)(srv=cmon)(act=accept)
       (action_list=(aut=off)(mct=120)(mit=30)(conn_stats=on))
    )
    (rule=
       (src=*)(dst=*)(srv=db)(act=accept)
       (action_list=(aut=off)(moct=0)(mct=0)(mit=0)(conn_stats=on))
    )
  )
  (parameter_list =(log_level=admin)(trace_level=admin))
)
Database server parameters:
IP-adress: 10.8.0.10

tnsnames.ora
CMAN_LISTENER=
 (DESCRIPTION=
  (ADDRESS_LIST=
   (ADDRESS=(PROTOCOL=tcp)(HOST=10.8.1.10)(PORT=1630)))
   (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = DB))
  )
alter system set remote_listener=CMAN_LISTENER scope=both;
System altered.
But when I try to connect e.g. through sqlplus from client to server I see:
C:\Documents and Settings\Administrator>sqlplus "sys@DB as sysdba"

SQL*Plus: Release 11.1.0.6.0 - Production on Mon May 25 13:58:40 2009

Copyright (c) 1982, 2007, Oracle.  All rights reserved.

Enter password:
ERROR:
ORA-12529: TNS:connect request rejected based on current filtering rules
So, how should I configure the cman.ora for work through cman_listener? Is there mistake?

P.S.
Sorry for my english.
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jun 22 2009
Added on May 25 2009
5 comments
1,537 views