Printable View
Thankyou very much for the documentation and it helped a lot. Now i manage to restrict the user to connect to the database and now i am working to allow specific user to connect to the database but i am getting the same message when i restrict it even though permission is given to him.
If anyone know that what could be the possible mistake i am doing.
Thanks
UKDBA
I am bit confuse now because i followed all the documentation and finally the cman and cmanadmin starts running .i added the rules for cman and allow one ip address which means only that ip address can talk to the connection manager but what is happening is that i found no effect of the ip address rejection and acceptance parameter in the cman_rules. but if i remove the source_route parameter from the client then it allows the client to connect to the database and when i add this parameter then it refuses the connection.
According to my understanding that when i use the source_route then client connection should first connect to the cman and then connection manager direct it to connect to the database.but this is not happening because if i reject or accept in rule then still it is not connectiong to the database.
can moderator help me on this issue.
I also used the metalink but the are also not responding on it promptly.
UKDBA
I'm guessing that you are conneting to the database, but not via connection manager.Quote:
Originally posted by UKDBA
but if i remove the source_route parameter from the client then it allows the client to connect to the database
Yes, this is correct. See http://technet.oracle.com/docs/produ...ams.htm#454077 for confirmation.Quote:
According to my understanding that when i use the source_route then client connection should first connect to the cman and then connection manager direct it to connect to the database.
Thank you jeff for all your help. It is working fine the way i want for the moment.But without your help it seems impossible. i tried oracle support but you are much better than them.
Cheers
UKDBA