Issue with SSIS Oracle Connection Manager

Ron Meyer 1 Reputation point
2021-09-12T20:10:34.47+00:00

I've verified I can connect to a local Oracle database (via Oracle's SQLDeveloper). My tsnnames.ora is

tnsnames.ora Network Configuration File: C:\app\RonM\product\18.0.0\dbhomeXE\NETWORK\ADMIN\tnsnames.ora

Generated by Oracle configuration tools.

XE =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = Dell20190320.home)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = XE)
)
)

LISTENER_XE =
(ADDRESS = (PROTOCOL = TCP)(HOST = Dell20190320.home)(PORT = 1521))

ORACLR_CONNECTION_DATA =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
)
(CONNECT_DATA =
(SID = CLRExtProc)
(PRESENTATION = RO)
)
)

and my Oracle Connection Manager shows

131307-image.png

Not sure what I'm missing?

Thanks

SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,460 questions
0 comments

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. ZoeHui-MSFT 33,296 Reputation points
    2021-09-13T02:14:12.023+00:00

    Hi @Ron Meyer ，

    To use Oracle Connection Manager in SSIS, here is an official documentation to refer.

    It mentioned the TNS service name.

    Input the name of the Oracle database you work with. The TNS service name could be:

    The connect descriptor name defined in the tnsnames.ora file that located in the admin folder of the Oracle client.

    EzConnect format: [//]host[:port][/service_name]

    See oracle-connector-is-not-working.html if it helps which has a similar issue.

    Regards，

    Zoe

    If the answer is helpful, please click "Accept Answer" and upvote it.

    Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.
    Hot issues October

    0 comments