title: Connecting Oracle via SSIS failed due to error ORA-01019
body: <p>I have a problem with SSIS that I cannot figure it out what is wrong!</p>
  
  <p>2 days back I used Microsoft oracle connection component to connect oracle database that <strong>it was successful.</strong> </p>
  
  <p>I also tried with my Oracle Oracle connection component to connect to oracle database(odp) which <strong>this one was also successful.</strong> </p>
  
  <p>Suddenly in the evening, I face with below issue. what could be the reason. It is so funny for both Oracle and Microsoft connection component I am receiving a similar issue.</p>
  
  <p>Please take note that in the package I was working there is an oracle connection and MSSQL connection. I feel that after using MSSQL connecting this issue occur. but even when I created a new package with a single Oracle connection, I am facing the same issue again.</p>
  
  <p>Please take note that I can connect to my oracle database via SQL developer successfully.</p>
  
  <blockquote>
    <h2>TITLE: Connection Manager</h2>
    
    <p>Test connection failed because of an error in initializing provider.
    Error while trying to retrieve text for error ORA-01019</p>
    
    <p>------------------------------ BUTTONS:</p>
    
    <h2>OK</h2>
  </blockquote>
  
  <p>My system information:</p>
  
  <blockquote>
    <p>ProjectServicesPackage Extension   1.0 ProjectServicesPackage Visual
    Studio Extension Detailed Info</p>
    
    <p>SQL Server Analysis Services   14.0.1016.285 Microsoft SQL Server
    Analysis Services Designer  Version 14.0.1016.285</p>
    
    <p>SQL Server Data Tools   15.1.61801.210 Microsoft SQL Server Data Tools</p>
    
    <p>SQL Server Integration Services    Microsoft SQL Server Integration
    Services Designer Version 14.0.3002.92</p>
    
    <p>SQL Server Reporting Services   14.0.1016.285 Microsoft SQL Server
    Reporting Services Designers  Version 14.0.1016.285</p>
    
    <p>SsmsVsIntegration   1.0 Information about my package</p>
    
    <p>Visual Basic Tools   2.7.0-beta3-62715-05. Commit Hash:
    db02128e6e3c4bdfc93e6ec425ac9162b4d4fe80 Visual Basic components used
    in the IDE. Depending on your project type and settings, a different
    version of the compiler may be used.</p>
    
    <p>Visual Studio Code Debug Adapter Host Package   1.0 Interop layer for
    hosting Visual Studio Code debug adapters in Visual Studio
    my system environment variables:</p>
  </blockquote>
  
  <p><a href="https://i.stack.imgur.com/ByIYw.jpg" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/ByIYw.jpg" alt="enter image description here"></a></p>