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

Question

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.

I am using:

MS Connector for Oracle Attunity 5.0

MS SQL server Data Tools - Visual Studio 14.0.1.162248.0

Answer 1

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.