SQL> select * from smt008@sprint.world;select * from smt008@sprint.world *ERROR at line 1:ORA-28545: error diagnosed by Net8 when connecting to an agentUnable to retrieve text of NETWORK/NCR message 65535ORA-02063: preceding 2 lines from SPRINT.WOR

If the link was working before , quickly check and verify the following :

1.Confirm whether the dblink password on the remote database wasnt changed.
2.Check whether the table you are trying to query exists on the remote database.
you can "desc remote_table@dblink"
3.If the password was changed , recreate the link using the new password.

Recreate the Oracle database link with the proper username and password. Note that the username and password must be in double quotes.

Example:

create public database link ODBC connect to "sa" identified by "pencil" using 'hsodbc'.


Rgds

FSN

Getting Away with Oracle SOX 404 Audits

Hi There

I have to admit that this paper :"Project Lockdown" by Arup Nanda is the best to prepare for any SOX audit http://www.oracle.com/technetwork/articles/project-lockdown-133916.pdf Read it and enjoy .