Configuration of Connection Manager
541486Jun 12 2007 — edited Oct 15 2007Hello!
I tried to configure a test-emvironment with the Oracle Connection Manager.
I used one client, one database server (10g) and the connection manager on another server.
The ConnectionManager is located on the server: s6702091.lva19.rzn.drv
The Database is located on: s6704023.drvbsh.rzn.drv, the service_name is: DEV.rzn.drv
This is my cman.ora:
cman =
(CONFIGURATION=
(ADDRESS=(PROTOCOL=tcp)(HOST=s6702091.lva19.rzn.drv)(PORT=1521))
(RULE_LIST=
(rule=(src=*)(dst=s6704023.drvbsh.rzn.drv)(srv=DEV.rzn.drv)(act=accept))
(rule=(src=*)(dst=s6702091.lva19.rzn.drv)(srv=cmon)(act=accept))
(rule=(src=s6702091)(dst=127.0.0.1)(srv=cmon)(act=accept))
)
(PARAMETER_LIST=
(REMOTE_ADMIN=YES)
(TRACE_LEVEL=ADMIN)
)
)
The database is well registered. I used the remote_listener functionality.
The client uses the following tnsnames.ora entry:
DEV2 =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS =
(PROTOCOL = TCP)
(HOST = s6702091.lva19.rzn.drv)
(PORT = 1521)
)
)
(CONNECT_DATA =
(Service_Name = DEV.rzn.drv)
(SERVER = DEDICATED)
)
)
When I try to connect the database through the ConnectionManager I always get the following error:
ORA-12529: TNS:connect request rejected based on current filtering rules
Where is my mistake...