It will look something like this:Ĥ) Copy the “SERVICE_NAME” value from that entry and head back over to Sql Developer. If you can’t find it, a quick Google search should help you out.ģ) Once you have the file open, locate the section for your database instance that you want to connect to. This is usually located in ORACLE_HOME/network/admin on Windows or $ORACLE_HOME/network/admin on Linux and Unix systems. You can check what version you have by going to Help > About in the menu bar.Ģ) Next, open up your Tnsnames Ora file. As of this writing, that’s version 17.419. If you’re looking to connect to an Oracle database using Tnsnames Ora in Sql Developer, there are a few things you’ll need to do first.ġ) Make sure you have the latest version of Sql Developer installed. How to Connect to Oracle Database Using Tnsnames Ora in Sql Developer If you can’t find it, ask your DBA for help. Usually, this file is located in ORACLE_HOME\network\admin on Windows or $ORACLE_HOME/network/admin on Linux and UNIX systems. Click the ellipsis button next to the TNSNames File field and browse to the location of your TNSnames.ora file. In the Preferences window, expand the Database node and select TNSNames.ģ. Open PL/SQL Developer and go to Tools > Preferences.Ģ. If you need to set up a TNSnames.ora file in order to connect to your Oracle database using PL/SQL Developer, here’s how to do it:ġ. How to Set Tnsnames.Ora in Pl/Sql Developer 14
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |