question

RonMeyer-0649 avatar image
0 Votes"
RonMeyer-0649 asked Zoehui-MSFT edited

Issue with SSIS Oracle Connection Manager

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
image.png (58.6 KiB)
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

1 Answer

Zoehui-MSFT avatar image
0 Votes"
Zoehui-MSFT answered Zoehui-MSFT edited

Hi @RonMeyer-0649

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



5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.