OraFAQ Forum: Server Administration » ORA-02019 (database link)

Home » RDBMS Server » Server Administration » ORA-02019 (database link)

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

ORA-02019 (database link) [message #61167]

Thu, 01 April 2004 19:38

K.Sateeshkumar
Messages: 16
Registered: March 2004

Junior Member

I want to establish a database link between the databases
Target DB Version : 7.3.4
Source DB Version : 8.1.7

I created a Database link with the following syntax
create database link linkname connect to
remoteusername identified by
remoteuserpasswork using
connection String;

the database link was created successfully and Cheked out in user_db_links.

when I am trying to access data from remote database using db link i am getting the error message ora-02019.

how to over come this problem and what are the pre requisits for creating a database link.

can u pl help out me immediately.

Report message to a moderator

Re: ORA-02019 (database link) [message #61173 is a reply to message #61167]

Fri, 02 April 2004 01:12

Kishor Bhalwankar
Messages: 33
Registered: February 2003

Member

it seems that your connection string is not proper or either listener is not running.

Also try global_names=true parameter in init.ora

Report message to a moderator

Re: ORA-02019 (database link) [message #61176 is a reply to message #61167]

Fri, 02 April 2004 05:34

Thiru
Messages: 1089
Registered: May 2002

Senior Member

Make sure you are able to connect to the remote database from your local database server using 'connectionString' which should be defined in your Server's tnsnames.ora.

-Thiru

Report message to a moderator

Previous Topic:	Need to know how to query from Data Dict. to find out table name and col. name wich contain the give
Next Topic:	9i rdbms installation on server with 8i rdbms already installed

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Sep 27 12:15:50 CDT 2024