Home » Applications » Oracle Fusion Apps & E-Business Suite » HOW TO USE DATABASE LINK (ORACLE 9.2.0.1.0 WINDOW NT)
HOW TO USE DATABASE LINK [message #312165] Tue, 08 April 2008 02:25 Go to next message
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 #312227 is a reply to message #312165] Tue, 08 April 2008 04:33 Go to previous messageGo to next message
Littlefoot
Messages: 20892
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
How does SQLNET.ORA look like? Would it be, for example, "using 'ulinux.mysite.com'?
Re: HOW TO USE DATABASE LINK [message #316512 is a reply to message #312165] Fri, 25 April 2008 08:01 Go to previous messageGo to next message
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
Re: HOW TO USE DATABASE LINK [message #318922 is a reply to message #312165] Thu, 08 May 2008 07:58 Go to previous message
srinivasu_vasamsetti
Messages: 5
Registered: July 2006
Location: hyderabad
Junior Member

Hi,

Please can you help me the same issue. means how configure the ODBC connection to client machine widows XP is the operating system and Server in Red Hat Linux 4.

Regards,
Srinivasu.
Previous Topic: Security Rule
Next Topic: Customer Interface - How to set status of Site_use_code?
Goto Forum:
  


Current Time: Mon Dec 05 02:35:42 CST 2016

Total time taken to generate the page: 0.08216 seconds