OraFAQ Forum: Security » database link

Home » RDBMS Server » Security » database link

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

database link [message #197794]

Thu, 12 October 2006 14:00

sweetgeegee27
Messages: 107
Registered: June 2005

Senior Member

I have a database link to query a view created of an external source, but they keep on getting error message: a table or view does not exist. Please note that the link use to work fine in Oracle 8i but we have just migrated to 10g. THe link is as follows:

CREATE SHARED PUBLIC DATABASE LINK ASYDB_GENESIS.SIGTAS
CONNECT TO IRD_CUSTOM IDENTIFIED BY IRD_CUSTOM
AUTHENTICATED BY IRD_CUSTOM IDENTIFIED BY IRD_CUSTOM
USING 'ASYDB_GENESIS';

Can anybody tell me what may be wrong? Thanks in advance

Report message to a moderator

Re: database link [message #197797 is a reply to message #197794]

Thu, 12 October 2006 14:34

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

Senior Member
Account Moderator

Does the tnsconnect string ASYDB_GENESIS still exists?
Check tnsnames.ora. Are you using ORACLE_SID or SERVICE_NAME?

Report message to a moderator

Re: database link [message #197800 is a reply to message #197797]

Thu, 12 October 2006 14:55

sweetgeegee27
Messages: 107
Registered: June 2005

Senior Member

I am using oracle_sid

Report message to a moderator

Re: database link [message #197801 is a reply to message #197800]

Thu, 12 October 2006 14:57

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

Senior Member
Account Moderator

Did you try switching to SERVICE_NAME?

Report message to a moderator

Re: database link [message #197802 is a reply to message #197801]

Thu, 12 October 2006 15:02

sweetgeegee27
Messages: 107
Registered: June 2005

Senior Member

What would be the service_name?

Report message to a moderator

Re: database link [message #197808 is a reply to message #197801]

Thu, 12 October 2006 15:39

sweetgeegee27
Messages: 107
Registered: June 2005

Senior Member

Ok. I know that the service name is ASYDB_GENESIS. but when I test the link it returns ORA-12154: TNS:could not resolve the connect identifier specified.

Report message to a moderator

Re: database link [message #197810 is a reply to message #197808]

Thu, 12 October 2006 15:51

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

Senior Member
Account Moderator

post your tnsnames.ora (relevant contents only).
Before doing anything with database link,
first see whether you can reach the remote database from your machine/wherever the dblink was created.

sqlplus user/pass@ASYDB_GENESIS
if this works,
then the problem is with the dblink.

Report message to a moderator

Re: database link [message #198551 is a reply to message #197810]

Tue, 17 October 2006 10:19

sweetgeegee27
Messages: 107
Registered: June 2005

Senior Member

Thanks for help but I was able to fix the database link by using a different service name (apparently the current name was incorrect) and then granting the user select permission on the view used for the link.

Report message to a moderator

Previous Topic:	Oracle Password History
Next Topic:	Can I alter my own expired password from application level?

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Wed Dec 11 19:43:26 CST 2024