Connecting to Oracle RDBMS through Oracle SQL Proxy

From the native SQL client, create a new connection that connects using the Oracle Proxy.

Depending on the client being used, these steps may vary. However, the general guidance remains the same.

  • The Authentication used by the client will be the user’s personal credentials to PAM. For example, if the user logs into PAM with the account ‘john’, then they will use ‘john’ and its password to authenticate their client to the PAM Oracle Proxy.
  • The Connection details used by the client will be for the PAM Oracle Proxy, not the actual database as defined in the PAM record. The Host defined in the client will be your PAM instance (i.e. xtam.company.com), the Port defined in the client will be the PAM Oracle Proxy Port (i.e. 1522 by default) and the Service Name or SID will be the ID-CAP value from the PAM record that was created (i.e. L-1IZOAKKNTAYM0).

As an example, here is a screenshot of the configuration using the Oracle SQL Developer v20 client:

Oracle_SQL_Developer_v20.png

Using the Test option in this client, the status will return Success when the client connects successfully to the PAM Oracle Proxy.

During Connection, the user’s client will connect to the PAM Oracle Proxy that will use the PAM record to create the proxy connection to the database.

The proxy identifies the PAM record using the ID-CAP value as provided in the Service Name or SID value of the connection.