OraFAQ Forum: Forms » database links

Home » Developer & Programmer » Forms » database links (oracle 9i)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

database links [message #312171]

Tue, 08 April 2008 02:36

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

Report message to a moderator

Re: database links [message #312208 is a reply to message #312171]

Tue, 08 April 2008 03:44

Littlefoot
Messages: 21823
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.

Report message to a moderator

Re: database links [message #313445 is a reply to message #312208]

Sat, 12 April 2008 06:13

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?

Report message to a moderator

Re: database links [message #313474 is a reply to message #313445]

Sat, 12 April 2008 15:35

Littlefoot
Messages: 21823
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

How do relevant part of TNSNAMES.ORA and SQLNET.ORA files look like?

Report message to a moderator

Re: database links [message #313996 is a reply to message #313474]

Tue, 15 April 2008 07:54

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)
)
)

Report message to a moderator

Previous Topic:	Use :New & :Old qualifier in Oracle Forms 10g
Next Topic:	How to Blink Record

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Tue Mar 11 12:53:54 CDT 2025