Troubleshoot Oracle SQL Developer Account Onboarding.

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

Troubleshoot Oracle SQL Developer Account Onboarding.

L3 Networker

Hi everyone,

 

I am trying to onboard DB account over CyberArk and using Oracle SQL Developer tool. I have create Connection Component, Platform and account. But when i trying to access the account, the rdp windows just show up and and then sign-out and close right away.

 

Field_Content_versions_oct20__068Vy00000goCM0IAM.png 

Before creating account, on the PSM Server, i already check to run SQL Developer from CMD with parameters successfully.

 

I have check the PSMTrace logs and it seems like it pass the parameters correctly:

[21/07/2025 | 15:27:11.855575] | {pid= 5672} | {tid= 3784} | class CPSMSessionState * | PSM\PSMServer\PSMSessionState.cpp(57) | :: | PSMSR731I [b7db1894-942e-4709-bff7-fd4c985a3714] Setting session phase in session state object. Previous value: [1], New value: [2] [21/07/2025 | 15:27:11.856117] | {pid= 5672} | {tid= 3784} | class CPSMConnectionClientBase * | PSM\PSMServer\PSMConnectionClientBase.cpp(422) | :: | PSMSR1488I [b7db1894-942e-4709-bff7-fd4c985a3714] start PSMComponentsFolder dynamic resolve for cmdline Irrelevant [21/07/2025 | 15:27:11.856172] | {pid= 5672} | {tid= 3784} | class CPSMConnectionClientBase * | PSM\PSMServer\PSMConnectionClientBase.cpp(395) | :: | PSMSR332I [b7db1894-942e-4709-bff7-fd4c985a3714] Successfully parsed command line: "C:\oracle\sqldeveloper\sqldeveloper.exe" [21/07/2025 | 15:27:11.856231] | {pid= 5672} | {tid= 3784} | class CPSMConnectionClientBase * | PSM\PSMServer\PSMConnectionClientBase.cpp(422) | :: | PSMSR1488I [b7db1894-942e-4709-bff7-fd4c985a3714] start PSMComponentsFolder dynamic resolve for cmdline Irrelevant [21/07/2025 | 15:27:11.856294] | {pid= 5672} | {tid= 3784} | class CPSMConnectionClientBase * | PSM\PSMServer\PSMConnectionClientBase.cpp(395) | :: | PSMSR332I [b7db1894-942e-4709-bff7-fd4c985a3714] Successfully parsed command line: -myCLIconnection="DB_Username/*@db.domain.org:1521/DB_APP_DEFAULT.SERVICENAME.ORG" [21/07/2025 | 15:27:11.856346] | {pid= 5672} | {tid= 3784} | class CPSMConnectionClientBase * | PSM\PSMServer\PSMConnectionClientBase.cpp(422) | :: | PSMSR1488I [b7db1894-942e-4709-bff7-fd4c985a3714] start PSMComponentsFolder dynamic resolve for cmdline Irrelevant [21/07/2025 | 15:27:11.856405] | {pid= 5672} | {tid= 3784} | class CPSMConnectionClientBase * | PSM\PSMServer\PSMConnectionClientBase.cpp(395) | :: | PSMSR332I [b7db1894-942e-4709-bff7-fd4c985a3714] Successfully parsed command line: -myCLIconnection="DB_Username/*@db.domain.org:1521/DB_APP_DEFAULT.SERVICENAME.ORG" [21/07/2025 | 15:27:11.856442] | {pid= 5672} | {tid= 3784} | class CPSMConnectionClientBase * | PSM\PSMServer\PSMConnectionClientBase.cpp(502) | :: | PSMSR341I [b7db1894-942e-4709-bff7-fd4c985a3714] Finished parsing the ClientApp parameter. Executable: ["C:\oracle\sqldeveloper\sqldeveloper.exe"] Parameters: [-myCLIconnection="DB_Username/*@db.domain.org:1521/DB_APP_DEFAULT.SERVICENAME.ORG"] [21/07/2025 | 15:27:11.858470] | {pid= 5672} | {tid= 3784} | class CPSMSessionProcessBase * | PSM\PSMServer\PSMSessionProcessBase.cpp(257) | :: | PSMSR066I [b7db1894-942e-4709-bff7-fd4c985a3714] Component execution - Duplicating process token [21/07/2025 | 15:27:11.858571] | {pid= 5672} | {tid= 3784} | class CPSMSessionProcessBase * | PSM\PSMServer\PSMSessionProcessBase.cpp(263) | :: | PSMSR067I [b7db1894-942e-4709-bff7-fd4c985a3714] Component execution - Update process token with session Id [21/07/2025 | 15:27:11.858615] | {pid= 5672} | {tid= 3784} | class CPSMSessionProcessBase * | PSM\PSMServer\PSMSessionProcessBase.cpp(270) | :: | PSMSR068I [b7db1894-942e-4709-bff7-fd4c985a3714] Component execution - Creating process "C:\oracle\sqldeveloper\sqldeveloper.exe"

Nothing special in C:\Program Files (x86)\CyberArk\PSM\Logs\Components or PSMConsole.log.

 

There is no other log or error message for me to check now. Please help me suggest where should i looking for error logs to identify what is the issue.

 

I am using Oracle SQL Developer version 24. and adding the Extension Connection Helper to be able to run from CMD

 

sqldeveloper -myCLIconnection=user/password@host:port/service

17 REPLIES 17

Thank @Sumit Kumar​ , I will try with that. What about the Basic connection Type, i not quite clear what to put into the Database field, cause that field not even exists when using tool directly on PSM Server

In database field - you can put the hostname/DNS of the oracle database

In database field - you can put the hostname/DNS of the oracle database

  • 443 Views
  • 17 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!