oracle db link won't work

[Anon]

Hi,
I am using this syntax to create a db link:

create database link HAILEY.WORLD
CONNECT TO HAILEY IDENTIFIED BY HAILEY
USING 'HAILEY'

My TNSNAMES.ORA file has an entry with an alias of Hailey.World.

When trying to use my database link within Oracle, I get the error "Couldn't resolve service name".

How can I fix this?? Seems like all of the pieces are there...

Thank you!

[mayank_gupta123]

Hello,

when you give the name of the link, you do not have to put service name in that.

I think if you will try the following it should work!!

Create database link Hailey_link connect to <username> identified by <password> using <Alias>

Before this first try to connect to the primary database by the following!

sqlplus <username>/<password>@<ORACLE_SID>

In case it still not working you can check the privileges.

You should have the followign priveleges!!
create session
create database link
create public database link

Try it, if it does not work, please let me know.

Best of luck

mayank