• State Not Answered
  • Replies 1 reply
  • Subscribers 93 subscribers
  • Views 261 views
  • Users 0 members are here
Options
Related

Oracle Database Connector Error

michaela chirio
7 months ago

Hi All,

I am currently traying to create a connector for an Oracle DB. I am using version 9.1 of Identity Manager.

When I enter the parameters required for the connection, I have the following error:

[Oracle.ManagedDataAccess.Client.OracleException] ORA-01017: invalid username/password; logon denied

However, on the same server we installed DBeaver and from it we can succesfully connect to the Oracle DB. The username and password are correct since they're the same.

I use the following syntax for the data source:

(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=<IP_address>)(PORT=<port>)) (CONNECT_DATA=(SERVICE_NAME=<service_name>)))

 

Do you have any idea of why we receive the error?

Thank you

  • 0 7 months ago

    Hi, 

    Please make sure you're not using any DBA privilege. 

    Check the advanced options for the connection. In our case we have:

    DataSource, yours seems correct.

    DBA privilege: empty.

    load balancing: false

    password: <the user password>

    persis security info: false

    user ID: <the user name >

    validate connection: false.

    Finally check if your DB backend allows connection from your IP . I'm not sure if Oracle is capable of restricting the IP address a certain user is connecting from.

    HtH!