Discussion Locked

Oracle Connection Manager usage

0 helpful
1 reply
Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

Folks,

We are exploring the use of Oracle Connection Manager (OCM) and would like to gain some real world insight from members of this forum.

Specifically -
1. What are the advantages/disadvantages of OCM ?
2. What scenarios would best describe the usage of OCM ?
3. Does OCM guarantee a higher level of database security ?

Any insight will be highly appreciated.

Thanks,
Suresh

1 reply

by sybrandb

Hi,
We have one situation where the database server for security reasons is located within a DMZ. Consequently there are three mechanisms to connect from outside the firewall
- enabling shared sockets
- Setting up shared server using a fixed port
- Using Connection Manager

Option 1 is to be avoided, as you can't shut down the listener anymore. This will disconnect everyone.
Option 2 is to be avoided as you can't make sure only users outside the DMZ are using the server
Option 3 works without problem.

The disadvantage though is that OCM doesn't communicate with an OMS outside the DMZ. We were forced to set up another OMS.

Regards
Sybrandb

This discussion is closed to new replies.