HOW TO USE DATABASE LINK [message #312165] |
Tue, 08 April 2008 02:25  |
sanjayverma_022
Messages: 1 Registered: April 2008 Location: Indore
|
Junior Member |
|
|
HI !
I try to access data from another database. my first database user/password/hoststring is oltptest/oltptest@ulinux and database name is inbot another database user/password/hoststring is hr/hr@unix and database name is 'nbot'. I try to access data of one table from oltptest to hr.
For this I created Database link with following script in hr user
CREATE DATABASE LINK TEST
CONNECT TO OLTPTEST IDENTIFIED BY OLTPTEST
USING 'ULINUX'
not i run following script
select * from holidays@test
but error occured
ERROR at line 1:
ORA-12154: TNS:could not resolve service name
I m working on client machine and i have configure both host string on my system
can anyone tell me whts wrong with that.
thx in advance
[Updated on: Tue, 08 April 2008 02:31] Report message to a moderator
|
|
|
|
Re: HOW TO USE DATABASE LINK [message #316512 is a reply to message #312165] |
Fri, 25 April 2008 08:01   |
alit
Messages: 1 Registered: April 2008
|
Junior Member |
|
|
Hi,
1.Are you able to ping bot from ibot machine.
2.Also check tnsping ulinux
3.check portnumbers in tnsnames.ora of your client machine
4.Check sqlnames.ora in server
Regards,
alit
www.alsuminfotech.com
|
|
|
|