OraFAQ Forum: Networking and Gateways » Need some help about using oracle connection manager

Home » RDBMS Server » Networking and Gateways » Need some help about using oracle connection manager (oracle database 9.2.0.4 )

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Need some help about using oracle connection manager [message #534197]

Sun, 04 December 2011 04:38

emergingdba
Messages: 13
Registered: April 2011
Location: bangalore

Junior Member

I was trying to connect to a remote database from my client machine. Client machine runs a jsp code to connect to the database and execute a query. I have got oracle jdbc on my machine but still unable to connect to the database.

When checked in google, i found that oracle connection manager has to be used to connect to the database from jdbc if the web server and database reside on different physical servers. But could'nt gather any further information regarding download and installation.

I do not have oracle connection manager on my system. I read in internet that it is shipped along with oracle 11g software. But i am not sure if that was the case in earlier version as well.

My question is where should i install oracle connection manager? (on database server or client machine) and is it possible to download and install only the connection manager as a stand alone so that i can connect to database from application?

Report message to a moderator

Re: Need some help about using oracle connection manager [message #534199 is a reply to message #534197]

Sun, 04 December 2011 06:21

John Watson
Messages: 8960
Registered: January 2010
Location: Global Village

Senior Member

I have had to do this when running Java applets downloaded from a web listener: the applet can talk only to the web listener machine. So to fool it into talking to a database on a different machine, you go through an Oracle Connection manager on the web listener machine which routes the connection onward to the datbase server. Is this, or something similiar, what you want to do?
If so, no problem: the Connection Manager is shipped with all releases. I do not know what the licensing implications are.

Report message to a moderator

Re: Need some help about using oracle connection manager [message #534200 is a reply to message #534199]

Sun, 04 December 2011 06:30

emergingdba
Messages: 13
Registered: April 2011
Location: bangalore

Junior Member

Hi John,

Thanks a lot. This is very similar what i wanted. Is connection manager shipped with oracle client as well?. If so, how do i install connection manager if i have already installed client. Even if i have to uninstall and re-install client what should i take care off while installing client so that connection manager gets installed?

Report message to a moderator

Re: Need some help about using oracle connection manager [message #534201 is a reply to message #534200]

Sun, 04 December 2011 07:03

John Watson
Messages: 8960
Registered: January 2010
Location: Global Village

Senior Member

It is shipped with the server, not the client. Take the "cusotom" install option. As for configuring it, talk to your DBA: he'll know all about it.

Report message to a moderator

Previous Topic:	unable to connect to db from client
Next Topic:	where can i download the oracle gateway for sql server

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Wed Dec 04 03:06:07 CST 2024