- 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.
03-12-2020 04:04 AM
I have SQL developer used by the Oracle team via PSM with no issues. I am on-boarding Sybase team as well and they also want to use SQL Developer. There's jtdc.jar file which I have add in the SQL Developer Preferences to enable the sybase tab for connections to Sybase databases. But after adding the jar file, the Sybase tab is only visible to me. No other user including PSM Shadow users are able to see that tab.
Has anyone faced this issue before?
03-27-2020 05:00 AM
Ok, it turned out that if you're doing any changes in the configuration in SQL developer, it will save it for that particular user only in the
C:\Users\<userid>\AppData\Roaming\SQL Developer so that's why the Sybase tab was not visible to all the users.
after identifying the above, I was able to tweak my AutoIt code, to copy the required configuration to the PSMShadowUser profile when connecting for the first time and it worked.
03-12-2020 05:27 AM
Could you check the file access permission of jtdc.jar?
03-12-2020 05:59 AM
Permissions are okay. Its not just the PSM Shadow Users , but other users who have same privileges as mine, are not able to see the Sybase tab, unless they add the jtdc.jar file in their session which is very strange to me.
03-27-2020 05:00 AM
Ok, it turned out that if you're doing any changes in the configuration in SQL developer, it will save it for that particular user only in the
C:\Users\<userid>\AppData\Roaming\SQL Developer so that's why the Sybase tab was not visible to all the users.
after identifying the above, I was able to tweak my AutoIt code, to copy the required configuration to the PSMShadowUser profile when connecting for the first time and it worked.
04-29-2020 09:40 AM
Hello @Ratul Gandhi
when I launch my connect for the PSM-Oracle Developer it does not populate credentials but give me this:
"NO TNS entries found in ….TNS_ADMIN=c:\oracle\instantclient…"
And I have to manually connected to the db I want
Is this normal or I missing something
Thanks.
04-29-2020 10:27 AM
@Tesi Iloh In the SQL Developer tool, what "Connection Type" are you choosing?
This link might help you: https://stackoverflow.com/questions/47928570/where-to-find-tnsnames-ora-in-sql-developer
04-29-2020 11:56 AM
Thanks for your quick responds, I use "PSM-SQLPlus" connection.
Thanks
04-29-2020 12:03 PM
Sorry connection type is "Basic"
04-29-2020 12:12 PM
sorry can you please confirm - you're having issues in SQL Plus or SQL Developer?
04-29-2020 12:22 PM
PSM SQL Developer.
when launch connect from PVWA credential is not populating automatically
04-29-2020 12:40 PM
And this is the version am using "sqldeveloper-19.2.1.247.2212-x64"
Thanks.
04-29-2020 11:47 PM
I think as long as you have all the information required for the connection, it should not ask you TNS file.
Are you supplying all the details in the connection prompt like - username, password, hostname, Servicename or SID?
And are you using the PSM plugin from the marketplace or have you developed on your own?
Also, when you open the SQLDeveloper from inside the PSM server do you still get the same error while connecting?
04-30-2020 06:20 AM
I use your script, modified two or three things
There is no PSM Developer plugin in the market place
When I launch sqldeveloper.exe directly from the server same issue, which is expected
Thanks
04-30-2020 01:42 PM
I guess you should check with your Database team about the error.
04-30-2020 02:45 PM
Thanks but I was curious to see what fix your own.
I see other thread here that ran into the same problem.
Regards
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!

