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

database oracle plsqldeveloper authentication
Mikhail Orlov picture Mikhail Orlov · Dec 2, 2009 · Viewed 183.6k times · Source

I have a database "TEST", to which I connect at address 123.45.67.89:1521.

How do I connect to it using PL/SQL Developer?

Answer

dpbradley picture dpbradley · Dec 2, 2009

In the "database" section of the logon dialog box, enter //hostname.domain:port/database, in your case //123.45.67.89:1521/TEST - this assumes that you don't want to set up a tnsnames.ora file/entry for some reason.

Also make sure the firewall settings on your server are not blocking port 1521.

Related questions

Generate test data using Oracle PL/SQL developer

I want to test some schemas and indexes, and I was wondering if there is a functionality in PL/SQL Developer that can generate test data (so I won't have to create sequences and loops to insert data in the …

Read More
How do I list all the columns in a table?

For the various popular database systems, how do you list all the columns in a table?

Read More
How to select the nth row in a SQL database table?

I'm interested in learning some (ideally) database agnostic ways of selecting the nth row from a database table. It would also be interesting to see how this can be achieved using the native functionality of the following databases: SQL Server …

Read More