How to fix the Issue: OCI error encountered. ORA-28860: Fatal SSL error (Package)

Ruwan Pathiranage 0 Reputation points
2023-10-09T00:10:56.73+00:00

I am trying to connect to Oracle Cloud 19c database in Integration Services Project SQL Server Data tools via MSORA (Microsoft Connector for Oracle by Attunity) using TNS service name and I am getting following error.

User's image

I am using:

MS Connector for Oracle Attunity 5.0

MS SQL server Data Tools - Visual Studio 14.0.1.162248.0

User's image

SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,467 questions
0 comments No comments
{count} votes

1 answer

Sort by: Most helpful
  1. ZoeHui-MSFT 33,626 Reputation points
    2023-10-09T01:47:17.9+00:00

    Hi @Ruwan P,

    TNS service name

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

    The connection name defined in the tnsnames.ora file

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

    To use a tnsnames.ora file, you may need to add a system environment variable to the machine running the SSIS package. The TNS_Admin environment variable specifies the location of the folder that contains the tnsnames.ora file. This will be required if you have not installed an Oracle client. To add the environment variable in Windows 10, Windows 11 or Windows Server 2022:

    1. Right-click the Start icon and select System.
    2. In the Settings window, select Advanced System Settings.
    3. On the Advanced tab of the System Properties window, select Environment Variables.
    4. In the Environment Variables window under System, select New.
    5. In the New System Variable window, enter "TNS_Admin" for the Variable name and the correct path to the folder that contains your tnsnames.ora file for the Variable value.
    6. Select OK in the New System Variable, Environment Variables, and System Properties windows.

    For more information, see the Oracle documentation.

    Oracle Connection Manager

    Regards,

    Zoe Hui


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