| 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 .
|
|
|
|
|
|
| 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)
)
)
|
|
|
|
|
|
| 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!
|
|
|
|
| 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!
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
