Urgent !!!!!!!!!!! DB_LINK ?????

[mrvajrala]

I have a job running through DBMS_JOBS ,which talks to remote database from MYDB.
It failed to run with the follwoing eror:

ORA-12012: error on auto execute of job 444
ORA-01005: null password given; logon denied
ORA-02063: preceding line from MYDB
ORA-06512: at "CLEAN.PKG_SYNC", line 365
ORA-06512: at "CLEAN.PKG_SYNC", line 489
ORA-06512: at line 1

I know that this job will run by the SNP process and looks for username/password for DBLINK .

Here is the DDL for the DBLINK which was already there

Create Database Link MYREMOTEDB.MYCOMPANY.COM
connect to PXY_REFRESH
Identified by PXY_REFRESH
using ''
/

And I also queried DBA_DB_LINKS...and i found the follwoing
OWNER : CLEAN
DB_LINK : MYREMOTEDB.MYCOMPANY.COM
USERNAME : PXY_REFRESH
HOST : NULL

CAn anybody knows what to do inorder to run this job thru.. DBMS_JOB and automatically.. ???

This is one kinda urgent ???
Your reply will be very much appreciated ..

[mrvajrala]

Big Guys ,
Pl give me some suggestions to solve this problem..

thanks,
Madhu

[mike73]

Several things you might want to check:

1. make sure your global_name=false instead of true, you can change this value by typing

ALTER SYSTEM SET GLOBAL_NAME=FALSE this only change temporary, if you want to change permenantly you have to edit your init.ora

2. make sure the TNS of the database you want to connect to is in the TNs names of the database you are on.

let us know if you still have problem

[mrvajrala]

DB_LINK is Ok , I could be able to excecute it manually.

Only thing is when SNP process tries to create a session for the scheduled process , it will look into dictionary , and it is failing to resolve the user id and password.

But I do have private DB LINK owned by Oracle ( but the username is CLEAN , in dba_db_links) ... which is having userid and password. And i have scheduled this job in a schema called CLEAN. Then I am getting the above errors.

Now u have any idea , why i am getting these errors, am i doing anything wrong ????