Skip to Main Content
Forums

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Heterogenous Service - Connecting to Lotus Notes Database from oracle 10g

thopevsOct 3 2008 — edited Oct 6 2008
I am using Oracle 10g Release 2. I am trying to get the data from Lotus Notes into Oracle for the project.

1. Created ODBC DSN to Lotus Notes File System.
2. Created Listner and TNSNAMES entried. Started the Listner without any issues.
3. Created database link to using the TNSNAMES entry for Lotusnotes.
4. Able to query the system table like ALL_OBJECTS and ALL_TABLES and see the list of objects and tables in Lotus Notes.
5. When trying to query the table(other then system tabels) in lotus notes to get the data , I am getting following error.

ERROR:
ORA-02068: following severe error from LOTUSNOTES
ORA-28511: lost RPC connection to heterogeneous remote agent using
SID=(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=server)(PORT=1524)
)(CONNECT_DATA=(SID=LOTUSNOTES)))


Please help.

Thanks
Seshadri Thope
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Nov 3 2008
Added on Oct 3 2008
#heterogeneous-connectivity
4 comments
2,584 views