Home » RDBMS Server » Networking and Gateways » Connecting two oracle database in different server (10g and windows XP)
Connecting two oracle database in different server [message #560477] Fri, 13 July 2012 08:59 Go to next message
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 Go to previous messageGo to next message
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...

------------------------------------------------------------------
Re: Connecting two oracle database in different server [message #560480 is a reply to message #560479] Fri, 13 July 2012 09:37 Go to previous messageGo to next message
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?
Re: Connecting two oracle database in different server [message #560482 is a reply to message #560480] Fri, 13 July 2012 10:00 Go to previous messageGo to next message
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..
Re: Connecting two oracle database in different server [message #560483 is a reply to message #560482] Fri, 13 July 2012 10:09 Go to previous messageGo to next message
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
Re: Connecting two oracle database in different server [message #560484 is a reply to message #560483] Fri, 13 July 2012 10:15 Go to previous messageGo to next message
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..
Re: Connecting two oracle database in different server [message #560485 is a reply to message #560484] Fri, 13 July 2012 10:26 Go to previous messageGo to next message
sivac47
Messages: 25
Registered: July 2012
Location: CHENNAI
Junior Member
ping <host name > working in their own system not other system..
Re: Connecting two oracle database in different server [message #560486 is a reply to message #560485] Fri, 13 July 2012 10:33 Go to previous messageGo to next message
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.
Re: Connecting two oracle database in different server [message #560488 is a reply to message #560486] Fri, 13 July 2012 10:35 Go to previous messageGo to next message
sivac47
Messages: 25
Registered: July 2012
Location: CHENNAI
Junior Member
But ping <ip address > is working
Re: Connecting two oracle database in different server [message #560489 is a reply to message #560488] Fri, 13 July 2012 10:40 Go to previous messageGo to next message
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.
Re: Connecting two oracle database in different server [message #560490 is a reply to message #560489] Fri, 13 July 2012 10:44 Go to previous messageGo to next message
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.
Re: Connecting two oracle database in different server [message #560491 is a reply to message #560490] Fri, 13 July 2012 11:11 Go to previous messageGo to next message
John Watson
Messages: 8922
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.
Re: Connecting two oracle database in different server [message #560620 is a reply to message #560491] Mon, 16 July 2012 02:04 Go to previous messageGo to next message
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..
Re: Connecting two oracle database in different server [message #560621 is a reply to message #560620] Mon, 16 July 2012 02:11 Go to previous messageGo to next message
John Watson
Messages: 8922
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
Re: Connecting two oracle database in different server [message #560654 is a reply to message #560621] Mon, 16 July 2012 03:53 Go to previous messageGo to next message
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
---------------------------------------------------------
Re: Connecting two oracle database in different server [message #560658 is a reply to message #560654] Mon, 16 July 2012 04:09 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
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
Re: Connecting two oracle database in different server [message #560681 is a reply to message #560658] Mon, 16 July 2012 06:56 Go to previous messageGo to next message
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
Re: Connecting two oracle database in different server [message #560687 is a reply to message #560681] Mon, 16 July 2012 07:40 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
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
Re: Connecting two oracle database in different server [message #560697 is a reply to message #560490] Mon, 16 July 2012 08:29 Go to previous messageGo to next message
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
Re: Connecting two oracle database in different server [message #560700 is a reply to message #560687] Mon, 16 July 2012 08:31 Go to previous messageGo to next message
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...

Re: Connecting two oracle database in different server [message #560702 is a reply to message #560700] Mon, 16 July 2012 08:34 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
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

Re: Connecting two oracle database in different server [message #560703 is a reply to message #560702] Mon, 16 July 2012 08:36 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
If server in on 10.50.31.91, why the client entry points to 10.50.20.36?

Regards
Michel
Re: Connecting two oracle database in different server [message #560710 is a reply to message #560703] Mon, 16 July 2012 08:53 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
the two tnsnames.ora file show they can only talk to themselves.
Re: Connecting two oracle database in different server [message #560713 is a reply to message #560710] Mon, 16 July 2012 08:58 Go to previous messageGo to next message
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..
Re: Connecting two oracle database in different server [message #560715 is a reply to message #560703] Mon, 16 July 2012 09:02 Go to previous messageGo to next message
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.
Re: Connecting two oracle database in different server [message #560721 is a reply to message #560715] Mon, 16 July 2012 09:11 Go to previous messageGo to next message
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
Re: Connecting two oracle database in different server [message #560725 is a reply to message #560721] Mon, 16 July 2012 09:19 Go to previous messageGo to next message
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"
Re: Connecting two oracle database in different server [message #560726 is a reply to message #560725] Mon, 16 July 2012 09:21 Go to previous messageGo to next message
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/
Re: Connecting two oracle database in different server [message #560727 is a reply to message #560726] Mon, 16 July 2012 09:41 Go to previous messageGo to next message
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

=====================================
Re: Connecting two oracle database in different server [message #560729 is a reply to message #560727] Mon, 16 July 2012 09:48 Go to previous messageGo to next message
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.
Re: Connecting two oracle database in different server [message #560730 is a reply to message #560729] Mon, 16 July 2012 09:50 Go to previous messageGo to next message
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...
Re: Connecting two oracle database in different server [message #560731 is a reply to message #560730] Mon, 16 July 2012 09:55 Go to previous messageGo to next message
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
Re: Connecting two oracle database in different server [message #560733 is a reply to message #560731] Mon, 16 July 2012 10:06 Go to previous messageGo to next message
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>
Re: Connecting two oracle database in different server [message #560734 is a reply to message #560733] Mon, 16 July 2012 10:15 Go to previous messageGo to next message
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?
Re: Connecting two oracle database in different server [message #560735 is a reply to message #560734] Mon, 16 July 2012 10:17 Go to previous messageGo to next message
sivac47
Messages: 25
Registered: July 2012
Location: CHENNAI
Junior Member
source is sivamurugan
target is saravanan
Re: Connecting two oracle database in different server [message #560737 is a reply to message #560735] Mon, 16 July 2012 10:22 Go to previous messageGo to next message
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!
Re: Connecting two oracle database in different server [message #560739 is a reply to message #560737] Mon, 16 July 2012 10:25 Go to previous messageGo to next message
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...
Re: Connecting two oracle database in different server [message #560741 is a reply to message #560737] Mon, 16 July 2012 10:27 Go to previous messageGo to next message
sivac47
Messages: 25
Registered: July 2012
Location: CHENNAI
Junior Member
sorry today i am leaving office now ..i will touch with you tomorrow..
Re: Connecting two oracle database in different server [message #560748 is a reply to message #560741] Mon, 16 July 2012 11:46 Go to previous messageGo to next message
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?
Re: Connecting two oracle database in different server [message #560783 is a reply to message #560748] Tue, 17 July 2012 02:05 Go to previous messageGo to previous message
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.
Previous Topic: Problem in Hostnaming method
Next Topic: clients connections failed intermittently
Goto Forum:
  


Current Time: Thu Mar 28 13:25:45 CDT 2024