- 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.
10-13-2024 06:53 AM
Hello CyberArk community!
I am trying to create a connection to Oracle Database 19c. I have downloaded the Oracle 1918 platform and the sqldeveloper connector from the marketplace. The platform is associated with the default SQL plus, Toad, and sqldeveloper that I downloaded.
I installed and moved the sqldeveloper.exe file manually to the PSM\Components folder and added it to the allowed applications in the PSMConfigureAppLocker file.
But when I try to connect, the RDP client windows just disappears with no error messages showing up. Can someone please tell me what's the log file that I can review to see what's wrong there?
Regarding the SQL plus, when I try to connect with it, it gives this error:
Can someone please help, why is this happening? How can this be fixed?
I would really appreciate any help, I don't have any experience with CyberArk, that's why I am struggling with all of it's connection process.
10-13-2024 10:45 AM
You can use this CyberArk doc as a reference to set up Oracle access through SQLPlus: https://docs.cyberark.com/pam-self-hosted/14.2/en/content/pasimp/psm_sqlplus.htm?tocpath=Administrator%7CComponents%7CPrivileged%20Session%20Manager%7CPSM%20Connectors%7CDatabases%7C_____2
You can use this CyberArk doc as a reference for AppLocker: https://docs.cyberark.com/pam-self-hosted/latest/en/content/pas%20inst/configure_applocker.htm
I think those 2 docs should answer most questions and also fill in the gaps. I hope this helps!
10-13-2024 09:51 AM
It looks like the AppLocker could be blocking the execution. You may want to check the configuration in the connection component, it's trying to run sqlplus.exe in the path you see in the error. You either need to confirm that sqlplus.exe exists in that path and then whitelist this path in AppLocker and run the Configure AppLocker ps1 script.
Or alternatively, if you've placed the executable in the PSM\Components folder, then update the connection component to point to it through the PVWA and ensure you've whitelisted the correct path
10-13-2024 09:58 AM
10-13-2024 10:45 AM
You can use this CyberArk doc as a reference to set up Oracle access through SQLPlus: https://docs.cyberark.com/pam-self-hosted/14.2/en/content/pasimp/psm_sqlplus.htm?tocpath=Administrator%7CComponents%7CPrivileged%20Session%20Manager%7CPSM%20Connectors%7CDatabases%7C_____2
You can use this CyberArk doc as a reference for AppLocker: https://docs.cyberark.com/pam-self-hosted/latest/en/content/pas%20inst/configure_applocker.htm
I think those 2 docs should answer most questions and also fill in the gaps. I hope this helps!
10-13-2024 10:28 PM
I got it! I was able to configure the connection through the SQLPlus, I figured out the lines that I need to remove to uncomment, and it solved the problem. Thank you very much for your help!
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!

