-
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...?
-
I think you need to create public database link then create public synonym
-
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
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|