Install, Upgrade, Clone, Patch - EBS (MOSC)

MOSC Banner

Oracle 11g: ORA-12154 when trying to connect from SSIS to Oracle

edited Aug 19, 2021 5:44PM in Install, Upgrade, Clone, Patch - EBS (MOSC) 5 commentsAnswered
Hi all,
I'm using SSIS on Windows Server 2008 R2 Service Pack 1 (64 bit). When trying to connect SSIS against an Oracle database using the
Oracle client 11g (version 11.2.0.1.0) (both 64 and 32 bit are installed), I'm getting the infamous ORA-12154 error.

Using sqlplus, I can connect to the Oracle server (on a different (Unix) machine) without any problems.
So there shouldn't be a problem with the tnsnames.ora file.


I've seen this problem under 10g, and have read lots of tips and recommendations for Oracle 10g.
But I thought that this problem had been solved in Oracle 11g ...


Please comment, your suggestions will be highly appreciated!
Tagged:

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

EBS LCM Tags

Instructions for posting

×

1. Select a discussion category from the picklist.


2. Enter a title that clearly identifies the subject of your question.


3. In the body, insert detailed information, including Oracle product and version.


Please abide by the Oracle Community guidelines and refrain from posting any customer or personally identifiable information (PI/CI).


Cloud / Fusion customers - Our Cloud community has moved! Please go to Cloud Customer Connect .


New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center