| Database link is not working (merged by CM) [message #443379] |
Mon, 15 February 2010 06:59  |
ranvijaidba
Messages: 71
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 #443518 is a reply to message #443412] |
Tue, 16 February 2010 02:09  |
ranvijaidba
Messages: 71
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.
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
