![]() ![]() If you want to use a different schema than the default schema associated with your username, select it from the Current Schema dropdown.If you are using Proxy Authentication, check the Show more options checkbox and provide the proxy username and password. ![]() (If you are new to Oracle Autonomous Database, use username ADMIN) Select Non-Administrator from the Role drop down list.Select the alias name you wish to connect to, for example mydb_high, from the TNS Alias dropdown list.Make sure the Wallet File Location field is set to the directory where you unzipped your credentials files.Make sure the TNS Admin Location field is set to the directory where you unzipped your credentials files.In the Connection Type dropdown, select TNS Alias PL/SQL file, press F1 to open Command Palette and select Oracle:Connect from the dropdown By default this location is ~/Oracle/network/admin on Linux and Mac and %USERPROFILE%\Oracle\network\admin on Windows. Unzip the credentials files into the directory that is set as Config Files Folder in the Oracle Developer Tools for VS Code Extension Settings.Alternatively, obtain the credentials file from your administrator. Obtain your Client Credentials File: Go to the Administration Console for your Oracle Autonomous Database and click Download Client Credentials.Provide a connection name to be used to reference this connection in Database Explorer and elsewhere.If using a TNS Alias, enter a connect string with this format: User Id=myuser Data Source=mytnsalias Proxy User Id=myproxyuser Proxy Password=myproxypass.In the Connection String field, enter a string with this format if providing the hostname, port and service name explicitly: User Id=myuser Data Source=dbhostname:1521/DBSERVICENAME Proxy User Id=myproxyuser Proxy Password=myproxypass.In the Connection Type dropdown, select ODP.NET Connect String To connect from Oracle Database Explorer, click the plus sign button.PL/SQL file, press F1 to open Command Palette and select Oracle:Connect from the dropdown But in this release you will need to use an "ODP.NET connection string". We plan to make this a lot easier in the next release by giving Proxy Authentication it's own section in the connection dialog. 1.7K Training / Learning / Certification.165.3K Java EE (Java Enterprise Edition).7.9K Oracle Database Express Edition (XE).3.8K Java and JavaScript in the Database.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |