Database Software

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!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

ETL tool cannot extract from database with Advanced Security

316797Aug 1 2002

Attempting to use the Informatica ETL tool to connect to an Oracle 8.1.7.4 database with Advanced Security. Informatica can connect and successfully extract a very small amount of data (< 100 rows), but with data volumes any greater than that, it just hangs.

If the tnsnames.ora file on the Informatica Server is modified to use the TCP protocal (versus TCPS) and port 1521 (instead of port 6252) then it works fine.

So far, Informatica tech support has been unable to help. Is there some configuration parameter that may need to be modified on the Oracle side?

Locked Post

New comments cannot be posted to this locked post.

Locked on Aug 29 2002

Added on Aug 1 2002

#database-security, #database-security-general

0 comments

330 views