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