OraFAQ Forum: Networking and Gateways » connecting two ORACLE Servers

Home » RDBMS Server » Networking and Gateways » connecting two ORACLE Servers

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

connecting two ORACLE Servers [message #186653]

Tue, 08 August 2006 22:04

teenu80
Messages: 4
Registered: August 2006
Location: CALI

Junior Member

Hi, I know how to create a database link between two oracle servers, but problem is that SID is same for both servers, Is there any other way to connect two servers without using only 'SID' ..here are TNSNAMES.ORA FILE i HAVE

D.w=
(DESCRIPTION=
(ADDRESS=
(PROTOCOL = TCP)
(HOST=ff.ffc.pic.com)
(PORT = 1521)
)
(CONNECT_DATA=
(SID = abc)
)
)

A.w=
(DESCRIPTION=
(ADDRESS=
(PROTOCOL=TCP)
(HOST=aa.bb.cs.com)
(PORT = 1521)
)
(CONNECT_DATA=
(SID = abc)
)

Is there any other way rather that this

Create database link a connect to username identified by password
using 'SID';

If anyone know the alternative like using SID.A.w or how I can differentiate these two SID s. Please reply soon

Thanks

Report message to a moderator

Re: connecting two ORACLE Servers [message #186658 is a reply to message #186653]

Tue, 08 August 2006 22:37

BlackSwan
Messages: 20109
Registered: January 2009

Senior Member

> but problem is that SID is same for both servers,
Why is that a problem?
I have the same SID in both Production & QA, but use different aliases.

Report message to a moderator

Re: connecting two ORACLE Servers [message #186722 is a reply to message #186653]

Wed, 09 August 2006 04:18

ramakris
Messages: 21
Registered: July 2006
Location: Delhi

Junior Member

Hi-

I am not sure why you specifying SID in you create db link command.

It should be like

Create database link <db link>
connect to <username> identified by <pwd>
using 'A.W';

You just have to specify the service name not the SID.

Thanks!
Rama.

Report message to a moderator

Re: connecting two ORACLE Servers [message #186796 is a reply to message #186722]

Wed, 09 August 2006 11:00

teenu80
Messages: 4
Registered: August 2006
Location: CALI

Junior Member

No still not working
error says
ERROR at line 1:
ORA-12154: TNS:could not resolve service name

Report message to a moderator

Re: connecting two ORACLE Servers [message #186816 is a reply to message #186653]

Wed, 09 August 2006 12:49

BlackSwan
Messages: 20109
Registered: January 2009

Senior Member

Teenu80,
my car is not working.
The Check Engine light is on.
Tell me how to fix my car.

The above is essentially what you've told us (TINU).
>Create database link a connect to username identified by password using 'SID';
Above is NOT correct.
The string between the single quote marks is the TNSNAMES alais.
You could benefit from reading the fine manuals found at
http://tahiti.oracle.com

Report message to a moderator

Re: connecting two ORACLE Servers [message #186825 is a reply to message #186816]

Wed, 09 August 2006 14:14

teenu80
Messages: 4
Registered: August 2006
Location: CALI

Junior Member

Its working now
If two databases on different servers have the same SID then this code doesn't work :

create database link <link name> connect to <userid> identified by <password> using 'SID'

otherwise it will work for sure.

To solve this problem I just copied the whole code = alais

create database link <link name> connect to <username> identified by <password> using '(DESCRIPTION =
(ADDRESS =
(PROTOCOL = TCP)
(HOST = f.f.p.com)
(PORT = 1521)
)
(CONNECT_DATA =
(SID = abc)
)
)'

This is how I solved my problem
but if you write only alais name like " using 'A.W' "
will not work.

Thanks for all to help

Report message to a moderator

Re: connecting two ORACLE Servers [message #186836 is a reply to message #186825]

Wed, 09 August 2006 15:24

teenu80
Messages: 4
Registered: August 2006
Location: CALI

Junior Member

thanks to all for help

Report message to a moderator

Re: connecting two ORACLE Servers [message #560683 is a reply to message #186836]

Mon, 16 July 2012 07:14

sivac47
Messages: 25
Registered: July 2012
Location: CHENNAI

Junior Member

Please provide your listener.ora file and tnsnames.ora file content in this forum.....

i need help...

Report message to a moderator

Re: connecting two ORACLE Servers [message #560696 is a reply to message #560683]

Mon, 16 July 2012 08:26

BlackSwan
Messages: 20109
Registered: January 2009

Senior Member

sivac47 wrote on Mon, 16 July 2012 05:14

Please provide your listener.ora file and tnsnames.ora file content in this forum.....

i need help...

why do you resurrect six year old thread?

Report message to a moderator

Re: connecting two ORACLE Servers [message #560711 is a reply to message #560696]

Mon, 16 July 2012 08:56

sivac47
Messages: 25
Registered: July 2012
Location: CHENNAI

Junior Member

Now i try the same concept..Oracle to oracle data transfer using database link in different server..

Report message to a moderator

Re: connecting two ORACLE Servers [message #560720 is a reply to message #560711]

Mon, 16 July 2012 09:09

BlackSwan
Messages: 20109
Registered: January 2009

Senior Member

>Oracle to oracle data transfer using database link
DB_LINK is always required between different instances regardless of different or same server.

Report message to a moderator

Re: connecting two ORACLE Servers [message #560722 is a reply to message #560720]

Mon, 16 July 2012 09:12

sivac47
Messages: 25
Registered: July 2012
Location: CHENNAI

Junior Member

server 1 - 10.50.20.36
server 2 - 10.50.31.91

i want to connect server 1 to server 2...

which tnsnames.ora and listener.ora file i want to modify...server 1 and server 2..

Report message to a moderator

Re: connecting two ORACLE Servers [message #560740 is a reply to message #560722]

Mon, 16 July 2012 10:27

Michel Cadot
Messages: 54236
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

Stay in your other topic for this question:
http://www.orafaq.com/forum/m/360742/102589/?msg_360742#msg_360742

This one is now locked.
Regards
Michel

Report message to a moderator

Previous Topic:	ORACLE Disconnect every 5 mins
Next Topic:	Problem in Hostnaming method

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri May 24 20:52:16 CDT 2013

Total time taken to generate the page: 0.76806 seconds