<?xml version="1.0" encoding="UTF-8"?>
<rss xmlns:content="http://purl.org/rss/1.0/modules/content/" xmlns:dc="http://purl.org/dc/elements/1.1/" xmlns:rdf="http://www.w3.org/1999/02/22-rdf-syntax-ns#" xmlns:taxo="http://purl.org/rss/1.0/modules/taxonomy/" version="2.0">
  <channel>
    <title>topic Re: Oracle SQL Developer v23.1 on PSM in Privilege Cloud Discussions</title>
    <link>https://live.paloaltonetworks.com/t5/privilege-cloud-discussions/oracle-sql-developer-v23-1-on-psm/m-p/1419764#M7157</link>
    <description>&lt;P&gt;The issue was that the database users did not have certificates tied to their Oracle DB accounts, and Oracle SQL Developer v20+ mandates this for the default authentication methods. While a human use can select the options in the interface to not require a certificate, the automation has been designed to use the defaults and hence must meet this mandate.&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;The only way around this would be to create an AutoIT based custom connection component that has the logic to leverage the non-certificate based authentication methods rather than the default.&lt;/P&gt;</description>
    <pubDate>Mon, 02 Jun 2025 18:16:08 GMT</pubDate>
    <dc:creator>CyberArkAlumni</dc:creator>
    <dc:date>2025-06-02T18:16:08Z</dc:date>
    <item>
      <title>Oracle SQL Developer v23.1 on PSM</title>
      <link>https://live.paloaltonetworks.com/t5/privilege-cloud-discussions/oracle-sql-developer-v23-1-on-psm/m-p/1419759#M7152</link>
      <description>&lt;P&gt;I'm trying to get the new Oracle SQL Developer ConnectionComponent (v20.0) to work on a Privilege Cloud environment.&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;I've set the java directory via both the jdk.conf and sqldeveloper.conf files (although I suspect only the 2nd was required), I have configured the "Use Oracle Client" and TNSnames.ora file in the SQL-Developer preferences, and edited the correct tnsnames.ora in the InstantClient path.&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;Yet, somehow the sessions are not connecting. The client loads on instantiating a session, but the "Select Connection" dialog box appears behind the "Connecting" scroll-bar, yet a connection is never selected (I am assuming this connection selection is a drop-list fed by the tnsname.ora file).&lt;/P&gt;&lt;P&gt;&lt;span class="lia-inline-image-display-wrapper" image-alt="Field_Content_versions_oct20__068Vy00000WpCGBIA3.png"&gt;&lt;img src="https://live.paloaltonetworks.com/t5/image/serverpage/image-id/92335iA216B214BB21F120/image-size/large?v=v2&amp;amp;px=999" role="button" title="Field_Content_versions_oct20__068Vy00000WpCGBIA3.png" alt="Field_Content_versions_oct20__068Vy00000WpCGBIA3.png" /&gt;&lt;/span&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;The documentation alludes to a TNSSERVICENAME as a file category?&lt;/P&gt;&lt;P&gt;https://docs.cyberark.com/privilege-cloud-shared-services/latest/en/content/pasimp/psm_oracle_sql.htm?Highlight=PSM%20Oracle%20SQL%20Developer#Defineaccountsettings&lt;/P&gt;&lt;P&gt;Or the CPM component seems to allude to it as a portion of the ConnectionString?&lt;/P&gt;&lt;P&gt;https://docs.cyberark.com/privilege-cloud-shared-services/latest/en/content/pasimp/odbcplugin.htm#Addthepassword&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;Anyone have an idea on what I am missing?&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;</description>
      <pubDate>Tue, 13 May 2025 16:01:27 GMT</pubDate>
      <guid>https://live.paloaltonetworks.com/t5/privilege-cloud-discussions/oracle-sql-developer-v23-1-on-psm/m-p/1419759#M7152</guid>
      <dc:creator>CyberArkAlumni</dc:creator>
      <dc:date>2025-05-13T16:01:27Z</dc:date>
    </item>
    <item>
      <title>Re: Oracle SQL Developer v23.1 on PSM</title>
      <link>https://live.paloaltonetworks.com/t5/privilege-cloud-discussions/oracle-sql-developer-v23-1-on-psm/m-p/1419760#M7153</link>
      <description>&lt;P&gt;For additional context, after the "Select Connection" times out, the normal connection dialog loads in concurrency to a PSM "Session has been closed" error. This screen also fails to receive any connection data and does not attempt to establish a DB connection.&lt;/P&gt;&lt;P&gt;&lt;span class="lia-inline-image-display-wrapper" image-alt="Field_Content_versions_oct20__068Vy00000WpJMcIAN.png"&gt;&lt;img src="https://live.paloaltonetworks.com/t5/image/serverpage/image-id/92337iF1AF21791AC0E621/image-size/large?v=v2&amp;amp;px=999" role="button" title="Field_Content_versions_oct20__068Vy00000WpJMcIAN.png" alt="Field_Content_versions_oct20__068Vy00000WpJMcIAN.png" /&gt;&lt;/span&gt;&lt;/P&gt;</description>
      <pubDate>Tue, 13 May 2025 16:15:15 GMT</pubDate>
      <guid>https://live.paloaltonetworks.com/t5/privilege-cloud-discussions/oracle-sql-developer-v23-1-on-psm/m-p/1419760#M7153</guid>
      <dc:creator>CyberArkAlumni</dc:creator>
      <dc:date>2025-05-13T16:15:15Z</dc:date>
    </item>
    <item>
      <title>Re: Oracle SQL Developer v23.1 on PSM</title>
      <link>https://live.paloaltonetworks.com/t5/privilege-cloud-discussions/oracle-sql-developer-v23-1-on-psm/m-p/1419761#M7154</link>
      <description>&lt;P&gt;Hi @Michael Bagley​&amp;nbsp;&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;Have you allowed AppLocker policies on the PSM server include the execution of SQL Developer and its associated Java components?&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;Also please refer to the following community thread. &lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;&lt;A alt="https://community.cyberark.com/s/question/0D52J00008yCbynSAC/psm-oracle-sql-developer-connection-component" href="https://community.cyberark.com/s/question/0D52J00008yCbynSAC/psm-oracle-sql-developer-connection-component" target="_blank"&gt;https://community.cyberark.com/s/question/0D52J00008yCbynSAC/psm-oracle-sql-developer-connection-component&lt;/A&gt;&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;Hope it helps !&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;</description>
      <pubDate>Tue, 13 May 2025 22:51:02 GMT</pubDate>
      <guid>https://live.paloaltonetworks.com/t5/privilege-cloud-discussions/oracle-sql-developer-v23-1-on-psm/m-p/1419761#M7154</guid>
      <dc:creator>M.Vora780263</dc:creator>
      <dc:date>2025-05-13T22:51:02Z</dc:date>
    </item>
    <item>
      <title>Re: Oracle SQL Developer v23.1 on PSM</title>
      <link>https://live.paloaltonetworks.com/t5/privilege-cloud-discussions/oracle-sql-developer-v23-1-on-psm/m-p/1419762#M7155</link>
      <description>&lt;P&gt;Currently AppLocker is in "Audit" only mode while I test and get the ConnectionComponent working. So I am positive AppLocker is not the issue.&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;I will try the edits to the sqldeveloper.conf file as suggested in the topic you linked to, and see if any of those help.&lt;/P&gt;</description>
      <pubDate>Wed, 14 May 2025 12:04:24 GMT</pubDate>
      <guid>https://live.paloaltonetworks.com/t5/privilege-cloud-discussions/oracle-sql-developer-v23-1-on-psm/m-p/1419762#M7155</guid>
      <dc:creator>CyberArkAlumni</dc:creator>
      <dc:date>2025-05-14T12:04:24Z</dc:date>
    </item>
    <item>
      <title>Re: Oracle SQL Developer v23.1 on PSM</title>
      <link>https://live.paloaltonetworks.com/t5/privilege-cloud-discussions/oracle-sql-developer-v23-1-on-psm/m-p/1419763#M7156</link>
      <description>&lt;P&gt;Hello @Michael Bagley​&amp;nbsp;&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;Have you received an answer to your question? If so, we kindly encourage you to share it with us.&lt;/P&gt;&lt;P&gt;Your insights could be valuable to other community members in the future.&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;Thank you, Isar.&lt;/P&gt;</description>
      <pubDate>Thu, 22 May 2025 07:22:09 GMT</pubDate>
      <guid>https://live.paloaltonetworks.com/t5/privilege-cloud-discussions/oracle-sql-developer-v23-1-on-psm/m-p/1419763#M7156</guid>
      <dc:creator>CyberArkAlumni</dc:creator>
      <dc:date>2025-05-22T07:22:09Z</dc:date>
    </item>
    <item>
      <title>Re: Oracle SQL Developer v23.1 on PSM</title>
      <link>https://live.paloaltonetworks.com/t5/privilege-cloud-discussions/oracle-sql-developer-v23-1-on-psm/m-p/1419764#M7157</link>
      <description>&lt;P&gt;The issue was that the database users did not have certificates tied to their Oracle DB accounts, and Oracle SQL Developer v20+ mandates this for the default authentication methods. While a human use can select the options in the interface to not require a certificate, the automation has been designed to use the defaults and hence must meet this mandate.&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;The only way around this would be to create an AutoIT based custom connection component that has the logic to leverage the non-certificate based authentication methods rather than the default.&lt;/P&gt;</description>
      <pubDate>Mon, 02 Jun 2025 18:16:08 GMT</pubDate>
      <guid>https://live.paloaltonetworks.com/t5/privilege-cloud-discussions/oracle-sql-developer-v23-1-on-psm/m-p/1419764#M7157</guid>
      <dc:creator>CyberArkAlumni</dc:creator>
      <dc:date>2025-06-02T18:16:08Z</dc:date>
    </item>
  </channel>
</rss>

