Discussions
Categories
- 197K All Categories
- 2.5K Data
- 546 Big Data Appliance
- 1.9K Data Science
- 450.8K Databases
- 221.9K General Database Discussions
- 3.8K Java and JavaScript in the Database
- 31 Multilingual Engine
- 552 MySQL Community Space
- 479 NoSQL Database
- 7.9K Oracle Database Express Edition (XE)
- 3.1K ORDS, SODA & JSON in the Database
- 556 SQLcl
- 4K SQL Developer Data Modeler
- 187.2K SQL & PL/SQL
- 21.4K SQL Developer
- 296.4K Development
- 17 Developer Projects
- 139 Programming Languages
- 293.1K Development Tools
- 111 DevOps
- 3.1K QA/Testing
- 646.1K Java
- 28 Java Learning Subscription
- 37K Database Connectivity
- 161 Java Community Process
- 105 Java 25
- 22.1K Java APIs
- 138.2K Java Development Tools
- 165.3K Java EE (Java Enterprise Edition)
- 19 Java Essentials
- 162 Java 8 Questions
- 86K Java Programming
- 81 Java Puzzle Ball
- 65.1K New To Java
- 1.7K Training / Learning / Certification
- 13.8K Java HotSpot Virtual Machine
- 94.3K Java SE
- 13.8K Java Security
- 205 Java User Groups
- 24 JavaScript - Nashorn
- Programs
- 475 LiveLabs
- 39 Workshops
- 10.2K Software
- 6.7K Berkeley DB Family
- 3.5K JHeadstart
- 5.7K Other Languages
- 2.3K Chinese
- 175 Deutsche Oracle Community
- 1.1K Español
- 1.9K Japanese
- 233 Portuguese
How to declare a Oracle connexion using OID ?

BobMilli
Member Posts: 8 Green Ribbon
Hello community,
We're getting rid of TNS and I was wondering how I should change my connexions declaration in the Oracle Extension for VSCode.
Thanks for your help.
Regards,
Bob
Best Answers
-
Hi Bob,
Are you using LDAP? If so, here is an excerpt from the quickstart:
- Connections using a directory server (LDAP) are now supported on all platforms (Windows, MacOS, and Linux).
- Copy the LDAP.ORA and SQLNET.ORA files that you want to use into the directory that is set as Config Files Folder in the Oracle Developer Tools for VS Code Extension Settings, or change this setting as desired. By default this location is ~/Oracle/network/admin on Linux and Mac and %USERPROFILE%\Oracle\network\admin on Windows.
- To connect to Oracle Database from a .SQL or .PL/SQL file, press F1 to open Command Palette and select Oracle:Connect from the dropdown. Then select New Connection.
- To connect from Oracle Database Explorer, click the plus sign button
- A connection dialog will open. In the Connection Type dropdown, select TNS Alias
- Make sure the TNS Admin Location field is set to the directory where your LDAP.ORA and SQLNET.ORA files are located. If not, change it.
- In the TNS Alias field, type in the database service name.
- Select the database role from the Role drop down list
- Enter the username and password
- If you are using Proxy Authentication, check the Show more options checkbox and provide the proxy username and password
- If you wish to use a different schema than the default schema associated with your username, check the Show more options checkbox and select the schema name from the Current Schema dropdown
- Provide a connection name to be used to reference this connection in Database Explorer and elsewhere
- Click the Create Connection button
-
Thanks a lot Christian !
I should have RTFM better :-)
It works like a charm.
Bob
Answers
-
Hi Bob,
Are you using LDAP? If so, here is an excerpt from the quickstart:
- Connections using a directory server (LDAP) are now supported on all platforms (Windows, MacOS, and Linux).
- Copy the LDAP.ORA and SQLNET.ORA files that you want to use into the directory that is set as Config Files Folder in the Oracle Developer Tools for VS Code Extension Settings, or change this setting as desired. By default this location is ~/Oracle/network/admin on Linux and Mac and %USERPROFILE%\Oracle\network\admin on Windows.
- To connect to Oracle Database from a .SQL or .PL/SQL file, press F1 to open Command Palette and select Oracle:Connect from the dropdown. Then select New Connection.
- To connect from Oracle Database Explorer, click the plus sign button
- A connection dialog will open. In the Connection Type dropdown, select TNS Alias
- Make sure the TNS Admin Location field is set to the directory where your LDAP.ORA and SQLNET.ORA files are located. If not, change it.
- In the TNS Alias field, type in the database service name.
- Select the database role from the Role drop down list
- Enter the username and password
- If you are using Proxy Authentication, check the Show more options checkbox and provide the proxy username and password
- If you wish to use a different schema than the default schema associated with your username, check the Show more options checkbox and select the schema name from the Current Schema dropdown
- Provide a connection name to be used to reference this connection in Database Explorer and elsewhere
- Click the Create Connection button
-
Thanks a lot Christian !
I should have RTFM better :-)
It works like a charm.
Bob
-
Glad to hear, Bob! Our Connection Dialog UI for an LDAP connection is not exactly intuitive, and we hope to change it in a coming release.