Problem with connecting to Oracle database.

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

Problem with connecting to Oracle database.

L4 Transporter

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:

Field_Content_versions_oct20__068Ht00000VfFfKIAV.pngCan 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.

1 accepted solution

Accepted Solutions

L6 Presenter

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!

View solution in original post

4 REPLIES 4

L6 Presenter

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

Thanks for the reply TPandey, I do have the sqlplus in the path that I see in the error, but how do I whitelist it in the AppLocker configuration file? Скачайте Outlook для iOS< aka.ms="" o0ukef="">

L6 Presenter

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!

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!

  • 1 accepted solution
  • 342 Views
  • 4 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!