Skip to Main Content

Oracle Developer Tools for VS Code

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Unable to connect via basic connection type

Tim PlößerNov 2 2022

Hi,
have described the issue on the comment section of the VSC extension, in short:
When I use the basic connection type, enter the complete connection string most of the time I am unable to create a connection to the DB and get an ORA-12154 error. According to our DBA the connection request does never reach the server. Most as in on a few occasions I was able to create a connection, however I was never able to pinpoint the reason why it did work or most of the times didn't (was first thinking it might be an VPN issue but the behavior is the same when I am on premise).
Connection with the same connection strings as used in the basic connection work for example via python and sqlalchemy or directly via SQL Developer
When using the TNS Alias connection type and pointing to the corresponding tnsnames.ora file the connection works without any issues.
Since most of our DBs end up in the tnsnames.ora file eventually it is not that big of deal for me but it is an issue for us if servers are not yet in the ora file.
Few informations about the versions I am currently using:
Oracle Developer Tools for VS Code Version 21.5.0
.Net Install Tool for Extensions Authors 1.6.0
VS Code Version 1.72.2

Comments

Processing

Post Details

Added on Nov 2 2022
8 comments
842 views