Home » RDBMS Server » Networking and Gateways » ORA-02019: connection description (Oracle ,10.2.0.2.0,Unix)
ORA-02019: connection description [message #511311] Sat, 11 June 2011 04:40 Go to next message
Database admin
Messages: 365
Registered: September 2006
Location: india
Senior Member

Hi,

I created database link from bala1 database of bala user with the following command.

CREATE DATABASE LINK maddy CONNECT TO P10 IDENTIFIED BY secret554
USING 'MADDY.WORLD';

my aim is to create a dblink to access 'maddy' database objects from bala1 database.

I gave select * from v$database@MADDY.WORLD in bala user and it throwed error.

ORA-02019: connection description for remote database not found


Thanks
Re: ORA-02019: connection description [message #511314 is a reply to message #511311] Sat, 11 June 2011 08:57 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
It would be helpful if you followed Posting Guidelines - http://www.orafaq.com/forum/t/88153/0/
Re: ORA-02019: connection description [message #511316 is a reply to message #511311] Sat, 11 June 2011 09:14 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Use SQL*Plus and copy and paste your session, the WHOLE session.

Before, Please read OraFAQ Forum Guide and How to use [code] tags and make your code easier to read.
Make sure that lines of code do not exceed 80 characters when you format.
Indent the code, use code tags and align the columns in result.
Use the "Preview Message" button to verify.
Also always post your Oracle version, with 4 decimals.

Regards
Michel
Re: ORA-02019: connection description [message #511343 is a reply to message #511316] Sun, 12 June 2011 00:27 Go to previous messageGo to next message
Database admin
Messages: 365
Registered: September 2006
Location: india
Senior Member


Guys,

I was able to fix this db link problem. If you want i could explain the issue with solution.


Thanks
Re: ORA-02019: connection description [message #511345 is a reply to message #511343] Sun, 12 June 2011 01:31 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Yes, and you should not have to ask it, this is part of good behaviour and forum guide to post the solution and explainations about the problem.

Regards
Michel
Re: ORA-02019: connection description [message #511346 is a reply to message #511345] Sun, 12 June 2011 02:02 Go to previous message
Database admin
Messages: 365
Registered: September 2006
Location: india
Senior Member

Yeah..

I was told to create a db link from 'Bala' user to access 'P10' user objects of maddy database.

Find the below details
---------------------
local database - bala1
remote database -- maddy
username -bala
pwd -bala

Since Bala user does not have privilege to create db link.So i created db link
from another user 'Drum' which has create db link privilege using below command.

i created db link using below command in 'Drum' user of bala1 database.So now, only
'Drum' user can access another database objects.

CREATE DATABASE LINK maddy CONNECT TO P10 IDENTIFIED BY secret554
USING 'MADDY.WORLD';

This command got created successfully with private db link, which is not
developer requirement.Because developer wanted to access db link from 'bala' user.

Also without knowing the meaning of private and public synonym, i logged in
as bala user and gave the below query to access remote database but it returned with error.

select * from v$database@MADDY.WORLD
ORA-02019: connection description for remote database not found.

Then what i did was, i logged in as Drum user , dropped the private db link which i created ,
then created the pubic db link and thus it allowed me to access remote database
from bala user as well.

If you create public db link , any user of local db can access remote objects.

If you create private db link, only the user where you created db link can access.

Pls let me know if somebody could not understand this.


Thanks


[Updated on: Sun, 12 June 2011 02:22]

Report message to a moderator

Previous Topic: Two Oracle Installs 10G and 11G
Next Topic: TNS-12535 TNS:operation timed out
Goto Forum:
  


Current Time: Thu Mar 28 14:24:06 CDT 2024