PSM Update the version of SQL*Plus used for the Connection Component.

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

PAM Self-Hosted Articles
2 min read
L0 Member
No ratings

The Oracle SQL*Plus Client that is provided with Idira software is shipped for the sake of customer convenience and while this is currently the only supported version we are not tied to this version.

 

While upgrading the client is possible please note that this is not currently certified or supported. To see the supported and certified version updated please vote on this Enhancement Request; https://cyberark.my.salesforce.com/ideas/viewIdea.apexp?id=0872J000000kBge&srPos=0&srKp=087

 

Upgrading the client will require a number of steps including checking the Oracle Client-to-Oracle Database version interoperability document available, this site can be found here, https://support.oracle.com/epmos/faces/DocumentDisplay?id=207303.1

 

In order to download the client packages you will also need to create an account over with Oracle. This is currently free to create and download the client software.

Steps

1)      Download the 32 bit versions of the Basic package, SQL*Plus and ODBC for the client version you wish to use from the Oracle website; https://www.oracle.com/database/technologies/instant-client/microsoft-windows-32-downloads.html

2)      Create a new folder inside the current instantclient folder called V<Version_Number> (e.g. V12_2)

3)      Extract all the above to the new folder and copy the "psmociucb.dll" from the existing client folder to the new folder.

4)      Copy the existing Connection Component in Administration -> Options -> Connection Components and Rename the ID to a Unique Value.

5)      Update the Path for the client app from "<Drive>:\oracle\instantclient\sqlplus.exe" "{UserName}/{Password}@{Address}[:{Port}][/{Database}] [{ConnectAs}]" to "<Drive>:\oracle\instantclient\V<Version_Number>\sqlplus.exe" "{UserName}/{Password}@{Address}[:{Port}][/{Database}] [{ConnectAs}]"

6)      Update any Platforms to include the unique ID of the new connection component.

7)      Restart the PSM server or wait for the PSM settings to take effect (according to the time specified in the ConfigurationRefreshInterval under Privileged Session Management --> General Settings --> Server Settings). Default is set to 10 minutes.

Rate this article:
  • 4560 Views
  • 0 comments
  • 0 Likes
Article Dashboard
Version history
Last Updated:
‎11-05-2026 12:13 PM
Updated by: