DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: ORA-02019: connection description for remote database not found?"

  1. #1
    Join Date
    Mar 2001
    Posts
    36
    Hi,

    Problem:
    Database error text........: "ORA-02019: connection description for remote database not found?"

    We have Database link between two database QA1 and ATSQ.

    QA1
    RDBMS Version: 7.3.3
    OS: IBM/AIX RISC System/6000: Version 2.3.4.0.0

    ATSQ:
    RDBMS Version: 8.0.5
    OS: IBM/AIX RISC System/6000: Version 2.3.4.0.0

    We created database link between QA1 to ATSQ. and then we created Public synonym for some of the table for ATSQ.
    When access table from SQL prompt It works fine.

    SQL> CONN SAPR3/@QA1
    Connected.

    SQL> SELECT COUNT(*) FROM AT_TERM@QA1ATSQ;

    COUNT(*)
    ---------
    241

    1 row selected.

    SQL> SELECT COUNT(*) FROM AT_TERM;

    COUNT(*)
    ---------
    241

    1 row selected.

    Here AT_TERM is public synonym for AT_TERM@QA1ATSQ Link.
    A problem is that when SAP program access this table it gives error "ORA-02019".

    Also same program access data from ATSD thru DV1. (DV1 has link to ATSD.)
    This link is working fine. but program unable to UPDATE data of ATSD.

    Can anybody help...?

  2. #2
    Join Date
    Mar 2002
    Posts
    48
    I think you need to create public database link then create public synonym

  3. #3
    Join Date
    Mar 2001
    Posts
    36
    I was created public Database Link as well as Public synonym and I am able to access ATSQ Data from QA1 from any of the user at SQL Prompt. but I am not able access thru SAP Program.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Click Here to Expand Forum to Full Width