database - How to connect to remote Oracle DB with PL/SQL Developer? -

I have a database "test" for which I am connected at address 123.45.67.8 9/1521.

How do I connect it using PL / SQL Developer?

I would recommend creating a TNSNAMES.ORA file. From your Oracle client install directory, navigate to \ Admin \ You already have a file called TNSNAMES.ORA, if it needs to be edited, then create it using your preferred text editor.

Next, just add an entry like this:

  MYDB = (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP) (HOST = 123.45.67.89) (Port = 1521 ) (CONNECT_DATA = (SID = test) (server = defined)))  

You can change MYDB for your choice, it is the identifier that applications receive information from the database Will use to find it with TNSNAMES.

Finally, login with MYDB as your database in PL / SQL Developer. It should automatically get the connection string in TNSNAMES.ORA.

If that does not work, then help-> hit - after that click on the "I" icon in the upper-hide corner. The fourth tab is the "TNS name" tab, check to confirm that it is loading the appropriate TNSNAMES.ORA file. If it is not, you may have more than one Oracle installation on your computer, and you will need to use it which is in use.