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

1 accepted solution

Accepted Solutions

L5 Sessionator

Hi,

 

Why not just use the one provided by CyberArk?

 

Refer to this documentation - https://docs.cyberark.com/pam-self-hosted/latest/en/content/pasimp/psm_oracle_sql.htm

 

Hope it helps

View solution in original post

17 REPLIES 17

L4 Transporter

You need to make sure few things

1- Applocker is configured with sql developer

2- You need to add PSMShadowUsers group on the SQL developer folder ready / write / list

3- validate Client location for SQL developer is updated at component level to point correct location as seen on PSM

 

L4 Transporter

You need to make sure few things

1- Applocker is configured with sql developer

2- You need to add PSMShadowUsers group on the SQL developer folder ready / write / list

3- validate Client location for SQL developer is updated at component level to point correct location as seen on PSM

 

L5 Sessionator

Hi,

 

Why not just use the one provided by CyberArk?

 

Refer to this documentation - https://docs.cyberark.com/pam-self-hosted/latest/en/content/pasimp/psm_oracle_sql.htm

 

Hope it helps

Thank you @Sumit Kumar​ ,

 

I am not using Applocker on my PSM. I will check other things but i prefer to go as @Madat Yuzbashli​ , should go with the one CyberArk already provided.

Smart move . I was presuming you were using the Cyberark provided other wise you need to handle 2 client parameters waitbeforecmdhides and another one which you can easily check from Toad sample. Increase the value of both parameters Sent from Outlook for iOS< aka.ms="" o0ukef="">

Smart move . I was presuming you were using the Cyberark provided other wise you need to handle 2 client parameters waitbeforecmdhides and another one which you can easily check from Toad sample. Increase the value of both parameters Sent from Outlook for iOS< aka.ms="" o0ukef="">

Thank you @Madat Yuzbashli​ 

 

I would go this way. And i have some question as well, if you could help:

  • From the document, about the account setting. i see it mentions if i define Database than i have to leave TnsServiceName empty and vice versa. But even when i leave Database empty, it still throw this error:
  • Field_Content_versions_oct20__068Vy00000gpIkIIAU.png
  • In my case, i already onboard my Oracle account successfully with PL/SQL using tnsname as address. I use SQL Developer as an alternative. So in my case, i should use TnsServiceName instead of Database when creating account right? my tnsnames file is correctly and i already define the part to that file in SQL Developer tool.
  • When creating account, it seems like address alone is not enough. I have to put the same value to TnsServiceName as well?

Hi Lucian,

 

I didn't properly understand what you mean. If you can provide test account details and the parameter values you set in connection component, we can probably brainstorm to get this working.

Hi @Madat Yuzbashli​ ,

 

Sorry for unclear questions. Let me try to explain my question again. Currently, i am confuse about inputting data when creating account. Are both of field Database and TnsServiceName mandatory? I want to use TnsServiceName but if i leave Database field empty. It would throw the error as i shared.

 

So i create an account like this:

 

Field_Content_versions_oct20__068Vy00000gywSOIAY.png 

All three fields Address, Database and TnsServiceName are the same now. Obviously, it is not correct but when fill in all three fields the session able to go a little bit farer than before, but still error.

 

Field_Content_versions_oct20__068Vy00000gzBrBIAU.pngField_Content_versions_oct20__068Vy00000gyyNjIAI.pngField_Content_versions_oct20__068Vy00000gz8VAIAY.png 

For more information, my DB account has defined and working tnsnames.ora file already. And i onboard it successfully with PL/SQL Tool. I just need to add tnsnames to the Adress field, no need Database or TnsServiceName.

If you are planning to use tnsservicename instead of Oracle SID. then please modify following as welll at connection component level. Change database identifier as --- >ServiceName instead of SID

Field_Content_versions_oct20__068Vy00000gzCdaIAE.pngField_Content_versions_oct20__068Vy00000gzCdaIAE.pngAt account level you must define tnsservice name parameter , address , database field

If you are planning to use tnsservicename instead of Oracle SID. then please modify following as welll at connection component level. Change database identifier as --- >ServiceName instead of SID

Field_Content_versions_oct20__068Vy00000gzCdaIAE.pngField_Content_versions_oct20__068Vy00000gzCdaIAE.pngAt account level you must define tnsservice name parameter , address , database field

Hi @Sumit Kumar​ ,

 

Thank you. I change as you guide but still run into error:

Field_Content_versions_oct20__068Vy00000h1DiPIAU.png 

Basically, when i use the tool directly from PSM Server. If the connection type is basic, you can choose between SID or Service name.

Field_Content_versions_oct20__068Vy00000h18h8IAA.png 

But when using TNS type, they are Network Alias or Connect Identifier

Field_Content_versions_oct20__068Vy00000h0tVHIAY.png 

So i am not sure if CyberArk support for this type of TNS connection or not.

 

Besides, If using 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 that, its better to use TNS connection template and define it in paramater

Field_Content_versions_oct20__068Vy00000hBgEdIAK.png

In that, its better to use TNS connection template and define it in paramater

Field_Content_versions_oct20__068Vy00000hBgEdIAK.png

  • 1 accepted solution
  • 446 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!