- 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.
07-21-2025 01:47 AM
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.
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
07-21-2025 02:23 AM
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
07-21-2025 01:58 AM
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
07-21-2025 01:58 AM
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
07-21-2025 02:23 AM
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
07-21-2025 03:35 AM
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.
07-21-2025 03:38 AM
07-21-2025 03:38 AM
07-21-2025 03:51 AM
Thank you @Madat Yuzbashli
I would go this way. And i have some question as well, if you could help:
07-21-2025 04:47 AM
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.
07-21-2025 08:20 PM
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:
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.
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.
07-21-2025 08:26 PM
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
At account level you must define tnsservice name parameter , address , database field
07-21-2025 08:26 PM
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
At account level you must define tnsservice name parameter , address , database field
07-22-2025 03:26 AM
Hi @Sumit Kumar ,
Thank you. I change as you guide but still run into error:
Basically, when i use the tool directly from PSM Server. If the connection type is basic, you can choose between SID or Service name.
But when using TNS type, they are Network Alias or Connect Identifier
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
07-23-2025 01:25 AM
In that, its better to use TNS connection template and define it in paramater
07-23-2025 01:25 AM
In that, its better to use TNS connection template and define it in paramater
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!

