OraFAQ Forum: Networking and Gateways » Connecting to a Remote Oracle Server

Home » RDBMS Server » Networking and Gateways » Connecting to a Remote Oracle Server

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

Connecting to a Remote Oracle Server [message #66194]

Mon, 21 January 2002 20:47

Jeyakumar
Messages: 3
Registered: January 2002

Junior Member

Hi,

I have a situation like this...

An Oracle server is running in a machine. That machine is made as a webserver and can be accessed by some www.somename.com
Now i want to access this oracle from a remote place, ie, my client is in seperate domain, and internet is the only mode of communication.

Please guide me in this regard.

thanks,
Jeyakumar.C.K

Report message to a moderator

Re: Connecting to a Remote Oracle Server [message #66195 is a reply to message #66194]

Tue, 22 January 2002 04:50

Kane
Messages: 15
Registered: November 2001

Junior Member

First, get the connection descriptor parameter from the Oracle server, including db name, port number the listener is listening to.
then, use net8 to configure the client's tnsnames.ora file... If you need more help, email me back...

good luck

Report message to a moderator

Re: Connecting to a Remote Oracle Server [message #66210 is a reply to message #66194]

Wed, 30 January 2002 21:10

Rohit
Messages: 43
Registered: January 2002

Member

say if i have 2 oracle servers in a domain...
can i use dblink to connect to specified tables...
if yes pls quote me an example indicatin all the dependencies

Report message to a moderator

Re: Connecting to a Remote Oracle Server [message #66213 is a reply to message #66210]

Thu, 31 January 2002 09:36

Kane
Messages: 15
Registered: November 2001

Junior Member

First, in server A, grant create database link to user user_A.

second, log into server A as user_A and create a db link that points to server B like this:

CREATE [[SHARED]] [[PUBLIC]] DATABASE LINK dblink CONNECT TO scott IDENTIFIED BY tiger USING 'net_service_name of server B';

Then, in server A, select * from emp@dblink where ......

Keep in mind that you are connecting to server B with scott/tiger while you are in server A as user_A.

For more information, go to :http://otn.oracle.com/docs/products/oracle8i/doc_library/817_doc/server.817/a76960/ds_admin.htm#12904

Report message to a moderator

Previous Topic:	Re: Getting ORA-01034 Oracle not available error ,even though database is up
Next Topic:	TNSNAMES.ORA

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sat Nov 23 22:45:20 CST 2024