Home » RDBMS Server » Networking and Gateways » Database link is not working (merged by CM) (10.2.0.3 Windows XP)
Database link is not working (merged by CM) [message #443379] Mon, 15 February 2010 06:59 Go to next message
ranvijaidba
Messages: 66
Registered: May 2008
Location: Bangalore
Member
Database version:10.2.0.3
Operating System:Microsoft Windows XP

I have two database TEST and TEST2 on same windows machine. In TEST database i have created one database link that access one schema in other TEST2 database.

but when i passed select command to access object in TEST2 through Database link it is hanging indefinitely.

command that i have used to create Database link:

create database link scott connect to scott identified by tiger using 'TEST2'

This is sqlnet.ora Entry:

SQLNET.AUTHENTICATION_SERVICES = (NTS)
NAMES.DIRECTORY_PATH= (TNSNAMES)


TNSNAMES.ORA entry:

TEST2 =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = SSIPL-LAPTP-052)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = test2)
)
)
TEST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = SSIPL-LAPTP-052)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = test)

SQL> SELECT * FROM user_db_links;

DB_LINK USERNAME PASSWORD HOST CREATED
--------------- ------------------------------ ------------------------------ --------------- ---------
SCOTT.SKILLNETI SCOTT TEST2 15-FEB-10
NC.COM


Please tell me how to resolve this issue.Thanks.



Re: Database link is not working (merged by CM) [message #443412 is a reply to message #443379] Mon, 15 February 2010 09:53 Go to previous messageGo to next message
babuknb
Messages: 1725
Registered: December 2005
Location: NJ
Senior Member


Please execute the below query from test database & post here

select * from dual@test2

Re: Database link is not working (merged by CM) [message #443518 is a reply to message #443412] Tue, 16 February 2010 02:09 Go to previous messageGo to next message
ranvijaidba
Messages: 66
Registered: May 2008
Location: Bangalore
Member
when i am trying the same thing one day before to access table via Database link it is hanging but today when i am trying the query that you have given it is working and Database link is working fine.

I don't know why it is not working previously.

Thanks for your prompt reply.

Re: Database link is not working (merged by CM) [message #443666 is a reply to message #443518] Tue, 16 February 2010 21:50 Go to previous message
ramoradba
Messages: 2452
Registered: January 2009
Location: AndhraPradesh,Hyderabad,I...
Senior Member
Thanks for the feedback.
So many possible reasons are there for hanging The DB.
Depends on the way you are executing(we don`t know how/what you are executing throgh DB link.)

sriram Smile
Previous Topic: Ora-12546 Tns Permission Failed
Next Topic: ORA-12560 Protocol Adapter error
Goto Forum:
  


Current Time: Wed Aug 20 15:28:51 CDT 2014

Total time taken to generate the page: 0.08491 seconds