- Access exclusive content
- Connect with peers
- Share your expertise
- Find support resources
Our community just got stronger! Explore new identity security resources, connect with experts, and discover more ways to learn and collaborate.
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.
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.