OraFAQ Forum: Networking and Gateways » Connecting two oracle database in different server

Home » RDBMS Server » Networking and Gateways » Connecting two oracle database in different server (10g and windows XP)

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

Connecting two oracle database in different server [message #560477]

Fri, 13 July 2012 08:59

sivac47
Messages: 25
Registered: July 2012
Location: CHENNAI

Junior Member

Hi friends,
I need solution for connecting two oracle database in two different server.I installed Oracle 10g XE in both system.Both system act as Server.I need to connect both server using database link concept.
Please provide information for how to use the tnsnames,ora and listener.ora file for connecting both system.
Thanks in advance for your reply?

[Edit MC: remove empty poll]

[Updated on: Mon, 16 July 2012 10:29] by Moderator

Report message to a moderator

Re: Connecting two oracle database in different server [message #560479 is a reply to message #560477]

Fri, 13 July 2012 09:10

sivac47
Messages: 25
Registered: July 2012
Location: CHENNAI

Junior Member

MY Listener.ora file is

Server 1:::

SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = D:\oraclexe\app\oracle\product\10.2.0\server\NETWORK\ADMIN)
(PROGRAM = extproc)
)
(SID_DESC =
(SID_NAME = CLRExtProc)
(ORACLE_HOME = D:\oraclexe\app\oracle\product\10.2.0\server\NETWORK\ADMIN)
(PROGRAM = extproc)
)
)

LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC_FOR_XE))
(ADDRESS = (PROTOCOL = TCP)(HOST = 10.50.20.36)(PORT = 1521))
)
)

DEFAULT_SERVICE_LISTENER = (XE)

server 2 ip address is ->10.50.20.36

when i start listener it provides error.....

----------------------------------------------------------------

LSNRCTL> START LISTENER
Starting tnslsnr: please wait...

TNSLSNR for 32-bit Windows: Version 10.2.0.1.0 - Production
System parameter file is C:\oraclexe\app\oracle\product\10.2.0\server\network\ad
min\listener.ora
Log messages written to C:\oraclexe\app\oracle\product\10.2.0\server\network\log
\listener.log
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(PIPENAME=\\.\pipe\EXTPROC_FOR
_XEipc)))
Error listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=10.50.20.36)(PORT=
1521)))
TNS-12545: Connect failed because target host or object does not exist
TNS-12560: TNS:protocol adapter error
TNS-00515: Connect failed because target host or object does not exist
32-bit Windows Error: 49: Unknown error

Listener failed to start. See the error message(s) above...

------------------------------------------------------------------

Report message to a moderator

Re: Connecting two oracle database in different server [message #560480 is a reply to message #560479]

Fri, 13 July 2012 09:37

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

>TNS-12560: TNS:protocol adapter error
common catch all error on Windows

Are both OS Services for database & listener started & now running?

Report message to a moderator

Re: Connecting two oracle database in different server [message #560482 is a reply to message #560480]

Fri, 13 July 2012 10:00

sivac47
Messages: 25
Registered: July 2012
Location: CHENNAI

Junior Member

Thanks for your reply,,,

listener not running in my server.

it shows error
------------------------------------------------------------------
LSNRCTL> START LISTENER
Starting tnslsnr: please wait...

TNSLSNR for 32-bit Windows: Version 10.2.0.1.0 - Production
System parameter file is C:\oraclexe\app\oracle\product\10.2.0\server\network\ad
min\listener.ora
Log messages written to C:\oraclexe\app\oracle\product\10.2.0\server\network\log
\listener.log
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(PIPENAME=\\.\pipe\EXTPROC_FOR
_XEipc)))
Error listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=10.50.20.36)(PORT=
1522)))
TNS-12545: Connect failed because target host or object does not exist
TNS-12560: TNS:protocol adapter error
TNS-00515: Connect failed because target host or object does not exist
32-bit Windows Error: 49: Unknown error

Listener failed to start. See the error message(s) above...

-------------------------------------------------------------------

but target system is running..

Report message to a moderator

Re: Connecting two oracle database in different server [message #560483 is a reply to message #560482]

Fri, 13 July 2012 10:09

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

Let us start with Networking Basics 101 by opening Command Window on both systems & issuing a total of 8 ping commands;
four ping commands from each system as shown below

ping <own_hostname>
ping <own_IP#>
ping <other_hostname>
ping <other_IP#>

now do the same from other system

COPY results from all 8 ping commands & PASTE all back here

Report message to a moderator

Re: Connecting two oracle database in different server [message #560484 is a reply to message #560483]

Fri, 13 July 2012 10:15

sivac47
Messages: 25
Registered: July 2012
Location: CHENNAI

Junior Member

How to find host name..Host name for oracle or windows..Please reply me

I ping both ip address in both system..

Report message to a moderator

Re: Connecting two oracle database in different server [message #560485 is a reply to message #560484]

Fri, 13 July 2012 10:26

sivac47
Messages: 25
Registered: July 2012
Location: CHENNAI

Junior Member

ping <host name > working in their own system not other system..

Report message to a moderator

Re: Connecting two oracle database in different server [message #560486 is a reply to message #560485]

Fri, 13 July 2012 10:33

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

Oracle's SQL*Net depends upon OS networking to actually work.
OS/Network is mis-configured; which has NOTHING to do with Oracle.
Contact local OS Network Administrator for assistance to resolve OS Network problem.

Report message to a moderator

Re: Connecting two oracle database in different server [message #560488 is a reply to message #560486]

Fri, 13 July 2012 10:35

sivac47
Messages: 25
Registered: July 2012
Location: CHENNAI

Junior Member

But ping <ip address > is working

Report message to a moderator

Re: Connecting two oracle database in different server [message #560489 is a reply to message #560488]

Fri, 13 July 2012 10:40

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

>But ping <ip address > is working
you do not have to convince me of anything.
If you want to have the 2 databases inter-operate with each other,
you need to get the OS & Oracle to play nice with each other.
I know from many years of experience that the 8 ping commands must work without error,
in order for SQL*Net to also operate without error.
You are free to do what ever you deem appropriate on your two systems without additional input from me.

Report message to a moderator

Re: Connecting two oracle database in different server [message #560490 is a reply to message #560489]

Fri, 13 July 2012 10:44

sivac47
Messages: 25
Registered: July 2012
Location: CHENNAI

Junior Member

okay thank you...I will configure correctly.After 8 comments working i will inform to you.......Once again thanks for your reply.

Report message to a moderator

Re: Connecting two oracle database in different server [message #560491 is a reply to message #560490]

Fri, 13 July 2012 11:11

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

Senior Member

I see the error. Go back your second post.

In the listener.ora file for your Server 1, you specify a listening address of,
(ADDRESS = (PROTOCOL = TCP)(HOST = 10.50.20.36)(PORT = 1521))

but you then say,
server 2 ip address is ->10.50.20.36

A listener can listen only on an address of the machine on which it is running. How could it listen anywhere else? That is why it fails to start. So replace that address with the address of Server 1, and all will be cool.

Report message to a moderator

Re: Connecting two oracle database in different server [message #560620 is a reply to message #560491]

Mon, 16 July 2012 02:04

sivac47
Messages: 25
Registered: July 2012
Location: CHENNAI

Junior Member

thanks for your reply John Watson
My problem is connecting two different server database.
I want to listen server 2 database from server1 that's what i put like that.
If i put my system ip then it will work..
Please correct my mistake if any wrong.
You guide me any other solution there..

Report message to a moderator

Re: Connecting two oracle database in different server [message #560621 is a reply to message #560620]

Mon, 16 July 2012 02:11

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

Senior Member

Quote:

I need to connect both server using database link concept.

So create a database link.
http://docs.oracle.com/cd/E11882_01/server.112/e25494/ds_concepts002.htm#i1007669

Report message to a moderator

Re: Connecting two oracle database in different server [message #560654 is a reply to message #560621]

Mon, 16 July 2012 03:53

sivac47
Messages: 25
Registered: July 2012
Location: CHENNAI

Junior Member

Thanks john i created database link.
create public database link server1
CONNECT TO system IDENTIFIED BY system
USING 'XE'
select * from test@server1;

it provides the following error..
---------------------------------------------------------

SQL> select * from test@server1;
select * from test@server1
*
ERROR at line 1:
ORA-12541: TNS:no listener
---------------------------------------------------------

Report message to a moderator

Re: Connecting two oracle database in different server [message #560658 is a reply to message #560654]

Mon, 16 July 2012 04:09

Michel Cadot
Messages: 68729
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

ORA-12541: TNS:no listener
 *Cause: The connection request could not be completed because the listener
 is not running.
 *Action: Ensure that the supplied destination address matches one of
 the addresses used by the listener - compare the TNSNAMES.ORA entry with
 the appropriate LISTENER.ORA file (or TNSNAV.ORA if the connection is to
 go by way of an Interchange). Start the listener on the remote machine.

Regards
Michel

Report message to a moderator

Re: Connecting two oracle database in different server [message #560681 is a reply to message #560658]

Mon, 16 July 2012 06:56

sivac47
Messages: 25
Registered: July 2012
Location: CHENNAI

Junior Member

listener is working..
My listener file is
-----------------------------------------------------
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = C\oraclexe\app\oracle\product\10.2.0\server)
(PROGRAM = extproc)
)
(SID_DESC =
(SID_NAME = CLRExtProc)
(ORACLE_HOME = C\oraclexe\app\oracle\product\10.2.0\server)
(PROGRAM = extproc)
)
)

LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC_FOR_XE))
(ADDRESS = (PROTOCOL = TCP)(HOST = 10.50.31.91)(PORT = 1521))
)
)

DEFAULT_SERVICE_LISTENER = (XE)

----------------------------------------------------
10.50.31.91 ---- my system ip
10.50.20.36 ------- is another ip i want to connect with this ip...
i think ths is wrong please correct my listener.ora file

Report message to a moderator

Re: Connecting two oracle database in different server [message #560687 is a reply to message #560681]

Mon, 16 July 2012 07:40

Michel Cadot
Messages: 68729
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

The problem is not (for the moment) in listener.ora but in the fact there is no listener listening at the address and port pointed by "server1".
Check the client tnsnames.ora
Then check the server active listener(s).

Regards
Michel

Report message to a moderator

Re: Connecting two oracle database in different server [message #560697 is a reply to message #560490]

Mon, 16 July 2012 08:29

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

sivac47 wrote on Fri, 13 July 2012 08:44

okay thank you...I will configure correctly.After 8 comments working i will inform to you.......Once again thanks for your reply.

COPY & PASTE showing 4 ping commands issued from both systems

Report message to a moderator

Re: Connecting two oracle database in different server [message #560700 is a reply to message #560687]

Mon, 16 July 2012 08:31

sivac47
Messages: 25
Registered: July 2012
Location: CHENNAI

Junior Member

server 1 tnsnames.ora

-------------------------------
XE =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 10.50.20.36)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = XE)
)
)

EXTPROC_CONNECTION_DATA =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC_FOR_XE))
)
(CONNECT_DATA =
(SID = PLSExtProc)
(PRESENTATION = RO)
)
)

ORACLR_CONNECTION_DATA =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC_FOR_XE))
)
(CONNECT_DATA =
(SID = CLRExtProc)
(PRESENTATION = RO)
)
)

------------------------------------------------------------

server 2 10.50.31.91 tnsnames.ora

-------------------------------
XE =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 10.50.31.91)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = XE)
)
)

EXTPROC_CONNECTION_DATA =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC_FOR_XE))
)
(CONNECT_DATA =
(SID = PLSExtProc)
(PRESENTATION = RO)
)
)

ORACLR_CONNECTION_DATA =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC_FOR_XE))
)
(CONNECT_DATA =
(SID = CLRExtProc)
(PRESENTATION = RO)
)
)

------------------------------------------------------------

listener for server2 is 10.50.31.91

--------------------------------------------------------------------
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = C\oraclexe\app\oracle\product\10.2.0\server)
(PROGRAM = extproc)
)
(SID_DESC =
(SID_NAME = CLRExtProc)
(ORACLE_HOME = C\oraclexe\app\oracle\product\10.2.0\server)
(PROGRAM = extproc)
)
)

LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC_FOR_XE))
(ADDRESS = (PROTOCOL = TCP)(HOST = 10.50.31.91)(PORT = 1521))
)
)

DEFAULT_SERVICE_LISTENER = (XE)

--------------------------------------------------------------------

please review this file and reply to me...

Report message to a moderator

Re: Connecting two oracle database in different server [message #560702 is a reply to message #560700]

Mon, 16 July 2012 08:34

Michel Cadot
Messages: 68729
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

Michel Cadot wrote on Mon, 16 July 2012 14:40

The problem is not (for the moment) in listener.ora but in the fact there is no listener listening at the address and port pointed by "server1".
Check the client tnsnames.ora
Then check the server active listener(s).

Regards
Michel

Report message to a moderator

Re: Connecting two oracle database in different server [message #560703 is a reply to message #560702]

Mon, 16 July 2012 08:36

Michel Cadot
Messages: 68729
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

If server in on 10.50.31.91, why the client entry points to 10.50.20.36?

Regards
Michel

Report message to a moderator

Re: Connecting two oracle database in different server [message #560710 is a reply to message #560703]

Mon, 16 July 2012 08:53

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

the two tnsnames.ora file show they can only talk to themselves.

Report message to a moderator

Re: Connecting two oracle database in different server [message #560713 is a reply to message #560710]

Mon, 16 July 2012 08:58

sivac47
Messages: 25
Registered: July 2012
Location: CHENNAI

Junior Member

@Black swan..Please correct the my issue in previous comment.Now 8 ping comments working here fien..

Report message to a moderator

Re: Connecting two oracle database in different server [message #560715 is a reply to message #560703]

Mon, 16 July 2012 09:02

sivac47
Messages: 25
Registered: July 2012
Location: CHENNAI

Junior Member

@Michel Cadot
may i change in both tnsnames.ora and listener.ora file or any one file.

Report message to a moderator

Re: Connecting two oracle database in different server [message #560721 is a reply to message #560715]

Mon, 16 July 2012 09:11

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

>@Black swan..Please correct the my issue in previous comment.Now 8 ping comments working here fien..
post COPY & PASTE proof above is true

Report message to a moderator

Re: Connecting two oracle database in different server [message #560725 is a reply to message #560721]

Mon, 16 July 2012 09:19

sivac47
Messages: 25
Registered: July 2012
Location: CHENNAI

Junior Member

@Black swan it shows error

"ERROR: ORA-12154: TNS:could not resolve the connect identifier
specified

Error Code: 12154

Query = select * from data_exchange_test@Source_con1"

Report message to a moderator

Re: Connecting two oracle database in different server [message #560726 is a reply to message #560725]

Mon, 16 July 2012 09:21

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

>@Black swan..Please correct the my issue in previous comment.Now 8 ping comments working here fien..
post COPY & PASTE proof above is true

ORA-12154 ALWAYS only occurs on SQL Client & no SQL*Net packets ever leave client system
ORA-12154 NEVER involves the listener, the database itself or anything on the DB Server.
ORA-12154 occurs when client requests a connection to some DB server system using some connection string.
The lookup operation fails because the name provided can NOT be resolved to any remote DB.
The analogous operation would be when you wanted to call somebody, but could not find their name in any phonebook.
The most frequent cause for the ORA-12154 error is when the connection alias can not be found in tnsnames.ora.
The lookup operation of the alias can be impacted by the contents of the sqlnet.ora file; specifically DOMAIN entry.
TROUBLESHOOTING GUIDE: ORA-12154 & TNS-12154 TNS:could not resolve service name [ID 114085.1]
http://edstevensdba.wordpress.com/2011/02/26/ora-12154tns-03505/

Report message to a moderator

Re: Connecting two oracle database in different server [message #560727 is a reply to message #560726]

Mon, 16 July 2012 09:41

sivac47
Messages: 25
Registered: July 2012
Location: CHENNAI

Junior Member

@Black swan..
I add below line with sqlnet.oraa file
NAMES.DIRECTORY_PATH= (ORCL)
but till it says the error
====================================
ERROR: ORA-12154: TNS:could not resolve the connect identifier
specified

Error Code: 12154

Query = select * from data_exchange_test@Source_con1

=====================================

Report message to a moderator

Re: Connecting two oracle database in different server [message #560729 is a reply to message #560727]

Mon, 16 July 2012 09:48

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

since you choose to not answer my question, now I choose to ignore your questions.

Report message to a moderator

Re: Connecting two oracle database in different server [message #560730 is a reply to message #560729]

Mon, 16 July 2012 09:50

sivac47
Messages: 25
Registered: July 2012
Location: CHENNAI

Junior Member

@black swan What you expect from me.I read whatever you given in the link i do as per youradvice .but till error not clear...

Report message to a moderator

Re: Connecting two oracle database in different server [message #560731 is a reply to message #560730]

Mon, 16 July 2012 09:55

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

>@Black swan..Please correct the my issue in previous comment.Now 8 ping comments working here fien..
post COPY & PASTE proof above is true

Report message to a moderator

Re: Connecting two oracle database in different server [message #560733 is a reply to message #560731]

Mon, 16 July 2012 10:06

sivac47
Messages: 25
Registered: July 2012
Location: CHENNAI

Junior Member

C:\Documents and Settings\sivamurugan>ping 10.50.31.91

Pinging 10.50.31.91 with 32 bytes of data:

Reply from 10.50.31.91: bytes=32 time<1ms TTL=128
Reply from 10.50.31.91: bytes=32 time<1ms TTL=128
Reply from 10.50.31.91: bytes=32 time<1ms TTL=128
Reply from 10.50.31.91: bytes=32 time<1ms TTL=128

Ping statistics for 10.50.31.91:
Packets: Sent = 4, Received = 4, Lost = 0 (0% loss),
Approximate round trip times in milli-seconds:
Minimum = 0ms, Maximum = 0ms, Average = 0ms

C:\Documents and Settings\sivamurugan>ping 10.50.20.36

Pinging 10.50.20.36 with 32 bytes of data:

Reply from 10.50.20.36: bytes=32 time<1ms TTL=127
Reply from 10.50.20.36: bytes=32 time<1ms TTL=127
Reply from 10.50.20.36: bytes=32 time<1ms TTL=127
Reply from 10.50.20.36: bytes=32 time<1ms TTL=127

Ping statistics for 10.50.20.36:
Packets: Sent = 4, Received = 4, Lost = 0 (0% loss),
Approximate round trip times in milli-seconds:
Minimum = 0ms, Maximum = 0ms, Average = 0ms

C:\Documents and Settings\sivamurugan>ping saravanan1

Pinging saravanan1 [10.50.20.36] with 32 bytes of data:

Reply from 10.50.20.36: bytes=32 time=1ms TTL=127
Reply from 10.50.20.36: bytes=32 time<1ms TTL=127
Reply from 10.50.20.36: bytes=32 time<1ms TTL=127
Reply from 10.50.20.36: bytes=32 time<1ms TTL=127

Ping statistics for 10.50.20.36:
Packets: Sent = 4, Received = 4, Lost = 0 (0% loss),
Approximate round trip times in milli-seconds:
Minimum = 0ms, Maximum = 1ms, Average = 0ms

C:\Documents and Settings\sivamurugan>ping sivamurugan

Pinging Sivamurugan [10.50.31.91] with 32 bytes of data:

Reply from 10.50.31.91: bytes=32 time<1ms TTL=128
Reply from 10.50.31.91: bytes=32 time<1ms TTL=128
Reply from 10.50.31.91: bytes=32 time<1ms TTL=128
Reply from 10.50.31.91: bytes=32 time<1ms TTL=128

Ping statistics for 10.50.31.91:
Packets: Sent = 4, Received = 4, Lost = 0 (0% loss),
Approximate round trip times in milli-seconds:
Minimum = 0ms, Maximum = 0ms, Average = 0ms

C:\Documents and Settings\sivamurugan>

C:\Documents and Settings\saravanan1>ping 10.50.31.91

Pinging 10.50.31.91 with 32 bytes of data:

Reply from 10.50.31.91: bytes=32 time<1ms TTL=128
Reply from 10.50.31.91: bytes=32 time<1ms TTL=128
Reply from 10.50.31.91: bytes=32 time<1ms TTL=128
Reply from 10.50.31.91: bytes=32 time<1ms TTL=128

Ping statistics for 10.50.31.91:
Packets: Sent = 4, Received = 4, Lost = 0 (0% loss),
Approximate round trip times in milli-seconds:
Minimum = 0ms, Maximum = 0ms, Average = 0ms

C:\Documents and Settings\saravanan1>ping 10.50.20.36

Pinging 10.50.20.36 with 32 bytes of data:

Reply from 10.50.20.36: bytes=32 time<1ms TTL=127
Reply from 10.50.20.36: bytes=32 time<1ms TTL=127
Reply from 10.50.20.36: bytes=32 time<1ms TTL=127
Reply from 10.50.20.36: bytes=32 time<1ms TTL=127

Ping statistics for 10.50.20.36:
Packets: Sent = 4, Received = 4, Lost = 0 (0% loss),
Approximate round trip times in milli-seconds:
Minimum = 0ms, Maximum = 0ms, Average = 0ms

C:\Documents and Settings\saravanan1>ping saravanan1

Pinging saravanan1 [10.50.20.36] with 32 bytes of data:

Reply from 10.50.20.36: bytes=32 time=1ms TTL=127
Reply from 10.50.20.36: bytes=32 time<1ms TTL=127
Reply from 10.50.20.36: bytes=32 time<1ms TTL=127
Reply from 10.50.20.36: bytes=32 time<1ms TTL=127

Ping statistics for 10.50.20.36:
Packets: Sent = 4, Received = 4, Lost = 0 (0% loss),
Approximate round trip times in milli-seconds:
Minimum = 0ms, Maximum = 1ms, Average = 0ms

C:\Documents and Settings\saravanan1>ping sivamurugan

Pinging saravanan1 [10.50.31.91] with 32 bytes of data:

Reply from 10.50.31.91: bytes=32 time<1ms TTL=128
Reply from 10.50.31.91: bytes=32 time<1ms TTL=128
Reply from 10.50.31.91: bytes=32 time<1ms TTL=128
Reply from 10.50.31.91: bytes=32 time<1ms TTL=128

Ping statistics for 10.50.31.91:
Packets: Sent = 4, Received = 4, Lost = 0 (0% loss),
Approximate round trip times in milli-seconds:
Minimum = 0ms, Maximum = 0ms, Average = 0ms

C:\Documents and Settings\saravanan1>

Report message to a moderator

Re: Connecting two oracle database in different server [message #560734 is a reply to message #560733]

Mon, 16 July 2012 10:15

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

from which system, saravanan1 or sivamurugan, will the connection to the other (remote) system be initiated?
Which system, saravanan1 or sivamurugan, contains the source data?
to which system, saravanan1 or sivamurugan, is recipient of target data?

Report message to a moderator

Re: Connecting two oracle database in different server [message #560735 is a reply to message #560734]

Mon, 16 July 2012 10:17

sivac47
Messages: 25
Registered: July 2012
Location: CHENNAI

Junior Member

source is sivamurugan
target is saravanan

Report message to a moderator

Re: Connecting two oracle database in different server [message #560737 is a reply to message #560735]

Mon, 16 July 2012 10:22

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

I asked THREE questions!
why do you respond with only TWO answers?
from which system, saravanan1 or sivamurugan, will the connection to the other (remote) system be initiated?

>source is sivamurugan
>target is saravanan
is the data being pushed from sivamurugan to saravanan?
is the data being pulled from sivamurugan to saravanan?

PLEASE answer ALL questions asked!

Report message to a moderator

Re: Connecting two oracle database in different server [message #560739 is a reply to message #560737]

Mon, 16 July 2012 10:25

sivac47
Messages: 25
Registered: July 2012
Location: CHENNAI

Junior Member

From sivamurugan to saravanan1 connection initiated...Pull the data from saravanan1 and push into sivamurugan...

Report message to a moderator

Re: Connecting two oracle database in different server [message #560741 is a reply to message #560737]

Mon, 16 July 2012 10:27

sivac47
Messages: 25
Registered: July 2012
Location: CHENNAI

Junior Member

sorry today i am leaving office now ..i will touch with you tomorrow..

Report message to a moderator

Re: Connecting two oracle database in different server [message #560748 is a reply to message #560741]

Mon, 16 July 2012 11:46

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

>Pull the data from saravanan1 and push into sivamurugan.
the two above are completely different actions

>Pull the data from saravanan1
Above requires a DB_LINK on sivamurugan
With a DB_LINK on sivamurugan you can either Pull the data from saravanan1 or push data to saravanan1

>push into sivamurugan.
above requires a DB_LINK on saravanan1
With a DB_LINK on saravanan1, you can either push onto sivamurugan or pull data from sivamurugan

so what problem are you really trying to solve?

Report message to a moderator

Re: Connecting two oracle database in different server [message #560783 is a reply to message #560748]

Tue, 17 July 2012 02:05

sivac47
Messages: 25
Registered: July 2012
Location: CHENNAI

Junior Member

i created database link in 2 databse..
when i run query.
select * from test@con1
it provides error.Listener does not know of service..
My question is which tnsnames.ora and listeer,ora file i am going to change.

Report message to a moderator

Pages (2): [1 2 › »]

Previous Topic:	Problem in Hostnaming method
Next Topic:	clients connections failed intermittently

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sat Jan 04 17:19:08 CST 2025