Oracle Database Vaulted credentials configuration connection using Oracle SQL developer

cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
Announcements

Welcome Idira to LIVEcommunity!

Our community just got stronger! Explore new identity security resources, connect with experts, and discover more ways to learn and collaborate.

Meet Idira

Oracle Database Vaulted credentials configuration connection using Oracle SQL developer

L2 Linker

Trying Oracle DB connection via SIA connection guidance. downloaded oracle wallet and updated tns.ora file

getting the following error when doing Test connection

Status : Failure -Test failed: ORA-17002: I/O error: Connection reset, connect lapse 18 ms., Authentication lapse 0 ms.

https://docs.oracle.com/error-help/db/ora-17002/

 

Anybody tested this connection successfully?

5 REPLIES 5

L7 Applicator

Hi @Sriram Kothuri​ 

 

It appears to be a connectivity problem to me. The error message indicates that there could be a problem with firewall rules or proxy, or SSL handshake.

 

In order to confirm whether the target database is reachable from the Connector machine,

 

  • Please try to ping and telnet the Oracle database server's hostname/IP address on ports 1521 and 2484.
  • If the ping / telnet is not successful then the firewall settings might not be allowing connectivity between the Connector machine on the required ports.
  • Also please check Ensure your application or client is looking for the tnsnames.ora file in the correct location. This is often defined by the TNS_ADMIN environment variable.
  • Please validate that the hostname in your tnsnames.ora matches the FQDN that the Connector is trying to connect
  • Please consult with your Oracle database team and request them to confirm if the listener is running and listening on the expected port 2484.

 

Hope it helps!

 

Thanks Malhar

  1. Connection string generated in SIA connection guidance

TCPSTEST_TCPS =

    (DESCRIPTION =

    (ADDRESS = (PROTOCOL = TCPS)(HOST = amer.oracle.cyberark.cloud)(PORT = 2484))

    (SECURITY=(MY_WALLET_DIRECTORY=C:\Users\s.koth\Oracle_wallet))

    (CONNECT_DATA =

    (SERVER = DEDICATED)

    (SERVICE_NAME = [email protected]@TCPSTEST_TCPS$amercold.com)

     ))

  1. No firewall issues, tested connection to amer.oracle.cyberark.cloud PORT = 2484
  2. TCPS (SSL) DB connection to host name and port 2484 works fine
  3. above tests indicate port 2484 is listening on cyberark.cloud and db host.

 

L7 Applicator

Hi @Sriram Kothuri​ 

 

Based on your further analysis, it now seems that it’s a SSL/TLS handshake failure.

 

Have you checked whether correct trusted certificate for amer.oracle.cyberark.cloud is configured in the wallet ?

 

Try downloading the wallet again.

 

Are you using SQL Developer, SQL*Plus, or another tool? Please ensure that it's picking up the correct TNS_ADMIN environment variable or is explicitly configured to use tnsnames.ora and  sqlnet.ora files.

 

Also validate that SERVICE_NAME is configured correctly.

 

Hope it helps !

Hello Malhar,

 

We are trying to use Oracle DB as well via SIA and when I download Oracle Wallet and then TNSNames.ora file, I tried to use it in sqldeveloper but got SSL/TLS handshake failure error.

 

I have tried to download the wallet again but same issue. How to configure the wallet to use the trusted certificate which I have downloaded from Connection Guidance page?

 

We don't have port 2484 open to the DB from the connector box, neither does the DB listens on port 2484.

 

Can you please guide on what needs to be configured for this to work? Also do I need to configure TNS_Admin env variable?

L2 Linker

@Singh Gary​  We have the same situation, none of the dB instances on site use port 2484. I appreciate the comms to <customer>.oracle.cyberark.cloud need to be on 2484, but comms to the actual dBs need to be on 1521 or any other custom port defined by the customer.

I'm looking forward to seeing the solution for this.

  • 572 Views
  • 5 replies
  • 0 Likes
Like what you see?

Show your appreciation!

Click Like if a post is helpful to you or if you just want to show your support.

Click Accept as Solution to acknowledge that the answer to your question has been provided.

The button appears next to the replies on topics you’ve started. The member who gave the solution and all future visitors to this topic will appreciate it!

These simple actions take just seconds of your time, but go a long way in showing appreciation for community members and the LIVEcommunity as a whole!

The LIVEcommunity thanks you for your participation!