Connection Manager 1

[Michael42]

Hello,

I have been wading through all the docs on Oracle's Connection Manager and am still not clear on this...

1. Is anyone using it on a production Oracle 9/10 system?
2. Why are you using it?
3. Does a database need to be in Shared Server mode to use it?


Thanks for sharing this,

Michael42

 

[Scunningham99]

Hi

sorry never used it but i do know it is used for the following

Session multiplexing
Access control
Protocol conversion

Session multiplexing--You can configure Oracle Connection Manager to funnel multiple client sessions through a network connection to a shared server destination.

Access control--You can use rule-based configuration to filter out certain client requests and accept others.

Protocol conversion--Oracle Connection Manager accepts connection requests in any protocol that Oracle supports.

sorry for brief info..




Sy UK

 

[slaing]

Michael -

Yes, I have Connection Manager (CMAN) running in several production environments.

In answer to your questions :

1) We have deployed it with 9i. Have never tried it with 10. With 9i it seems quite stable. The only problem we had was with JDBC connections . Then, the versions had to be exactly correct - a 9.2.0.1 CMAN wouldn't let JDBC connections through to a 9.2.0.6 database.

2) We use it on sites where we need to make SQL*Net or JDBC connections through a firewall. Think of CMAN as a relay.

It is possible to configure a shared server instance to use a fixed port. We chose to use CMAN (on a web server)since our clients didn't fancy putting their production database servers into a DMZ.

3) AFAIK, the database can be either dedicated or shared.
Again, just think of CMAN as a relay - the client PC talks to it on a fixed port and CMAN makes the 1521 + random port connection to the database.

Steve

 

[Michael42]

Steve,

Thanks for the detailed info on CM.

-Micahel42