ERP APPS의 접속통제로 조회용 유저에서
alter session set current_schema = apps ; 로 사용중인데
database link 부분에서 ora-2019 에러 발생
조회용 유저에 private database link를 생성해도 에러 발생
그래서 public database link를 생성하니 해결됨.
ORA-02019: connection description for remote database not found
[참고자료]
Cause
When an ALTER SESSION SET current_schema is executed from the current session, the dblink is
searched as the PUBLIC user, but not as the used under which the schema was changed.
Unfortunately the indicated BUG is not feasible to be fixed in 9i, so there is no patch available
and it won't be.
Solution
1. Upgrade to 10g release as the problem is fixed in this release.
2. Use a PUBLIC dblink instead of PRIVATE as an workaround.
References
Bug 5577879 - ACCESSING PRIVATE DBLINK IN VIEW AFTER 'SET CURRENT_SCHEMA' REPORTS ORA-02019