OraFAQ Forum: Networking and Gateways » ORA-02019: connection description for remote database not found

Home » RDBMS Server » Networking and Gateways » ORA-02019: connection description for remote database not found

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

ORA-02019: connection description for remote database not found [message #141587]

Tue, 11 October 2005 02:00

sanaafridi
Messages: 50
Registered: August 2005
Location: pakistan

Member

hi all

i am trying to populate a table from another db server in LAN enviorment and i use the following statement.

insert into rg_ca_category (candidate_id,st_cat_code,session_id,cate_roll_no,cand_name,f_h_name,sex,dob,id_card_no,perm_address,curr_address,perm_phone,curr_pho ne,e_mail,remarks,user_id,user_dt)
select candidate_id,st_cat_code,
session_id,cate_roll_no,cand_name,f_h_name,sex,dob,id_card_no,perm_address,curr_address,perm_phone,curr_phone,e_mail,remarks,user_id, user_dt from nust.rg_ca_category@nustdb;

but it give the following error
ORA-02019: connection description for remote database not found

now what i know about this error is that to check the tnsnames.ora file whic is i checked and quite right and it must be as i am connected to that server but then why this error message.

the other server have oracle 8.1.5 and my machine have ora 9.2

so any clue ??

regards
sana

Report message to a moderator

Re: ORA-02019: connection description for remote database not found [message #142348 is a reply to message #141587]

Fri, 14 October 2005 04:52

tarundua
Messages: 1080
Registered: June 2005
Location: India

Senior Member

Is nustdb is a database link ?

If so,What kind of database link did you created ?

Who is the owner of the database link ?

Are you running this command from the same session where this link was created ?

see this ,

Code: [Select all] [Show/ hide]

 SQL> show user;
USER is "TANU"
SQL> select * from user_db_links;

DB_LINK                                                                                                                          USERNAME       
----------------------------------------------------------------------------------------------------
HOST
----------------------------------------------------------------------------------------------------
CREATED
---------
LINK1                                                                                                                            SCOTT          
srvc_sun_us
08-SEP-05


SQL> select * from emp@link1;

     EMPNO ENAME      JOB              MGR HIREDATE         SAL       COMM     DEPTNO
---------- ---------- --------- ---------- --------- ---------- ---------- ----------
      7369 SMITH      CLERK           7902 17-DEC-80        800                    20
      7499 ALLEN      SALESMAN        7698 20-FEB-81       1600        300         30
      7521 WARD       SALESMAN        7698 22-FEB-81       1250        500         30
      7566 JONES      MANAGER         7839 02-APR-81       2975                    20
      7839 KING       PRESIDENT            17-NOV-81       5000                    10
      7844 TURNER     SALESMAN        7698 08-SEP-81       1500          0         30
      7876 ADAMS      CLERK           7788 23-MAY-87       1100                    20
      7900 JAMES      CLERK           7698 03-DEC-81        950                    30
      7902 FORD       ANALYST         7566 03-DEC-81       3000                    20
      7934 MILLER     CLERK           7782 23-JAN-82       1300                    10

10 rows selected.


 SQL> show user
USER is "SCOTT"
SQL> select * from emp@link1;
select * from emp@link1
                  *
ERROR at line 1:
ORA-02019: connection description for remote database not found

SQL> show user;
USER is "SYS"
SQL>  select * from emp@link1;
 select * from emp@link1
                   *
ERROR at line 1:
ORA-02019: connection description for remote database not found

It looks that the database link is private database link , so try to login as the user who created this dblink and then try to run this command . read more about DBLINKS from
here

regards,
tarun

Report message to a moderator

Re: ORA-02019: connection description for remote database not found [message #142527 is a reply to message #142348]

Sat, 15 October 2005 02:10

sanaafridi
Messages: 50
Registered: August 2005
Location: pakistan

Member

hi tarun

no ,nustdb is the name of database i am connecting too

and i do not create any db link so how to create db link for this scenrio

as i thought when the nustdb can connect at sql*plus so it should also took the records too

plzz just explain to me how to connect a remote databse;

thank tarun

sana

Report message to a moderator

Re: ORA-02019: connection description for remote database not found [message #142528 is a reply to message #142527]

Sat, 15 October 2005 02:18

tarundua
Messages: 1080
Registered: June 2005
Location: India

Senior Member

In your case it would be better to create a Database link to fetch the records.

This is the link for Oracle 9i

http://download-uk.oracle.com/docs/cd/B10501_01/server.920/a96521/ds_concepts.htm#12354

This is the link for Oracle 8i

http://download-west.oracle.com/docs/cd/A87860_01/doc/server.817/a76960/ds_admin.htm#12904

As you told you are accessing 8i database from 9i database so you need to create a database link on 9i database.

regards,
tarun

Report message to a moderator

Previous Topic:	SQL Plus Login issue
Next Topic:	TNS-12538: TNS:no such protocol adapter

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri May 02 09:00:18 CDT 2025