Home » Developer & Programmer » Forms » database links (oracle 9i)
database links [message #312171] Tue, 08 April 2008 02:36 Go to next message
athar.fitfd@hotmail.com
Messages: 193
Registered: October 2007
Location: pakistan
Senior Member
hi every one , i want to use database link in my application.
i have created one, and when i query data from table, following error.
TNS-Could not resolve servce name
Re: database links [message #312208 is a reply to message #312171] Tue, 08 April 2008 03:44 Go to previous messageGo to next message
Littlefoot
Messages: 20900
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
How did you create it? Could you copy-paste your SQL*Plus session? It should look like this (if the database link is properly created and working):
SQL> create database link dbl_mike
  2  connect to mike
  3  identified by lion
  4  using 'ora10';

Database link created.

SQL> select 'x' from dual@dbl_mike;

'
-
x

SQL>

As you can see, there's no error here.
Re: database links [message #313445 is a reply to message #312208] Sat, 12 April 2008 06:13 Go to previous messageGo to next message
athar.fitfd@hotmail.com
Messages: 193
Registered: October 2007
Location: pakistan
Senior Member
Yes Dear,

I have created the link exactly the same way,
but i found that error.


Any Idea?
Re: database links [message #313474 is a reply to message #313445] Sat, 12 April 2008 15:35 Go to previous messageGo to next message
Littlefoot
Messages: 20900
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
How do relevant part of TNSNAMES.ORA and SQLNET.ORA files look like?
Re: database links [message #313996 is a reply to message #313474] Tue, 15 April 2008 07:54 Go to previous message
athar.fitfd@hotmail.com
Messages: 193
Registered: October 2007
Location: pakistan
Senior Member
i have created a service zf as i added to tnsnames.ora file

zf =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS =
(COMMUNITY = tcp.world)
(PROTOCOL = TCP)
(Host = 192.168.0.9)
(Port = 1521)
)
)
(CONNECT_DATA = (SID = zfora)
)
)
Previous Topic: Use :New & :Old qualifier in Oracle Forms 10g
Next Topic: How to Blink Record
Goto Forum:
  


Current Time: Wed Dec 07 20:45:01 CST 2016

Total time taken to generate the page: 0.08509 seconds