OraFAQ Forum: Networking and Gateways » dblink and dbms

Home » RDBMS Server » Networking and Gateways » dblink and dbms_job problem

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

dblink and dbms_job problem [message #67278]

Mon, 29 March 2004 20:36

amonw
Messages: 3
Registered: March 2004

Junior Member

Hi, everyone:

I put something like

"insert into temp(a) select sum(a) from temp@remote;

�commit;"

in my dbms_job.

everything was�fine until the remote server updated to rac mode.

Now,if I run the job manually, it works. But when it started automatically,it raised an exception:ORA-12154:TNS:could not resolve service name.

I've been working on this for a few days, and I can't figure it out.

Any help would be deeply appreciated .

Report message to a moderator

Re: dblink and dbms_job problem [message #67279 is a reply to message #67278]

Tue, 30 March 2004 05:58

Mahesh Rajendran
Messages: 10708
Registered: March 2002
Location: oracleDocoVille

Senior Member
Account Moderator

are u using a RAC compliant TNS entry for the database link in tnsnames.ora?

Report message to a moderator

Re: dblink and dbms_job problem [message #67281 is a reply to message #67279]

Tue, 30 March 2004 15:54

amonw
Messages: 3
Registered: March 2004

Junior Member

I think so. Because I can manully run the job correctly.
The TNS entry is as following:

rac1=
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = x.x.x.x)(PORT = 1521))
)
(CONNECT_DATA =
(SID = rac1)
)
)

Report message to a moderator

Re: dblink and dbms_job problem [message #67305 is a reply to message #67281]

Fri, 16 April 2004 05:58

devman
Messages: 3
Registered: April 2004

Junior Member

same issue here, let me know if you find a resolution

Report message to a moderator

Re: dblink and dbms_job problem Resolution [message #67306 is a reply to message #67278]

Fri, 16 April 2004 10:59

devman
Messages: 3
Registered: April 2004

Junior Member

Finally figured this one out after some help from my DBA. In the DB links from the calling database, the full connection string had to be specified in the DB link to the remote DB, the host name alone was not enough.

Hope this helps someone else!

Report message to a moderator

Re: dblink and dbms_job problem [message #67307 is a reply to message #67278]

Fri, 16 April 2004 11:00

devman
Messages: 3
Registered: April 2004

Junior Member

Finally figured out the problem. When utilizing the DB link to connect to the remote database the full connection string had to be specified in the DB link, not just the host name. Works!

Report message to a moderator

Re: dblink and dbms_job problem Resolution [message #67315 is a reply to message #67306]

Mon, 26 April 2004 17:09

amonw
Messages: 3
Registered: March 2004

Junior Member

What do you mean by "full connection string"?
Could you give me an example?
Thanks in advance.

Report message to a moderator

Previous Topic:	Remote DB Connection error
Next Topic:	how to connect access with d2k forms

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sat May 03 01:29:13 CDT 2025