Members Members   Search Search   Help Help   Register Register   Login Login   Home Home
Home » RDBMS Server » Server Administration » Connecting to another Oracle Server (Oracle 9i)
Connecting to another Oracle Server [message #318195] Tue, 06 May 2008 01:32 Go to next message
monasingh
Messages: 172
Registered: May 2006
Location: Mumbai
Senior Member
Hi,
I have to create a procedure where I have do some inserts from a table present on database on another oracle server, where the database servername might change at times.
I do not have to use dblink as that would be static and in my case the service name might change at some intervals.

I am thinking of passing the ip address of that server.
Please suggest a way as how and what to pass in the procedure to do the same and if I pass the IP address then how to fetch the table from ip address.

Any suggestion would be highly appreciated.

Thanks in advance,
Mona Singh
Report message to a moderator
Re: Connecting to another Oracle Server [message #318206 is a reply to message #318195 ] Tue, 06 May 2008 02:03 Go to previous messageGo to next message
Michel Cadot
Messages: 15244
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Whatever change behind the scene, entry name in tnsnames.ora should not. It is the logical level.
In the opposite IP may change, this is why DNS is made for, to hide IP change with a name.
In the same way, tnsnames.ora is made to hide any change on database location or access path, server, port, connect data and so on.
Your database link should be created on tnsnames.ora entry name and so can always access the database.
If tnsnames.ora entry names change then there is a flaw in the name you named them.

Regards
Michel

[Updated on: Tue, 06 May 2008 02:04]

Report message to a moderator
Re: Connecting to another Oracle Server [message #318214 is a reply to message #318206 ] Tue, 06 May 2008 02:15 Go to previous messageGo to next message
monasingh
Messages: 172
Registered: May 2006
Location: Mumbai
Senior Member
I have to pass the service name as a parameter in the procedure where I have to access a table of the remote database name.

I am new to it, Kindly guide me as how to do this as I do not have to use dblink as I said service name might change.

Thanks for your answer,
Mona
Report message to a moderator
Re: Connecting to another Oracle Server [message #318239 is a reply to message #318214 ] Tue, 06 May 2008 03:25 Go to previous message
Michel Cadot
Messages: 15244
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Anyway you can't access remote database inside a procedure without a db link.

Regards
Michel
Report message to a moderator
Previous Topic:USER_CONSTRAINTS Vs USER_INDEXS
Next Topic:killed session still in v$session but not in v$process
Goto Forum:
  

[ Syndicate this forum (XML) ] [ ]

Current Time: Sat May 17 05:50:39 CDT 2008

Total time taken to generate the page: 0.00830 seconds
.:: Forum Home :: Site Home :: Wiki Home :: Contact :: Privacy ::.