Call (800) 766-1884 for Oracle support & training
Free Oracle Tips

Oracle Consulting Support
Oracle Upgrades
Use New Oracle Features
Oracle Replication Support
Oracle Training
Remote Oracle DBA
System Documentation
Oracle Tips
Oracle Performance

Free Oracle Tips



BC Oracle tuning

Oracle training

Oracle support

Remote Oracle




EnterpriseDB: PostgreSQL
Oracle Tips by Burleson

Adding servers for EnterpriseDB and PostgreSQL differ only in the drop down chosen (Figure 5.12).  The Port will usually vary between databases.  The parameters you enter create a JDBC connection to that database.

Figure 5.12: Configure EnterpriseDB Server Connection

When configuring a PostgreSQL database, you select the PostgreSQL server type but all other information is the same.

The Nickname field is the name you will see, and choose, in the navigator pane.  You may want to use a nickname that will let you know which machine, DB type and user is connecting.

The Host may be a named host or an IP address.  If you are connecting to a database on the localhost, you may use localhost as the name.

The Port is the port where the database is listening for connections.  EnterpriseDB listens to 5444 by default and PostgreSQL listens to 5432 by default. 

The Initial DB is the database that you will connect to upon logon.  EnterpriseDB and PostgreSQL differ from Oracle in that, what Oracle would call a local database, EnterpriseDB and PostgreSQL call a cluster.  In Oracle terms, the most closely connected term would be the schema that you want to connect to.

Finally, you enter the user name and password of the user to which you wish to connect.

Figure 5.13 shows a fully populated PostgreSQL 8.2 connection.

Figure 5.13: PostgreSQL 8.2 Server Connection


An Oracle connection looks much like an EnterpriseDB connection but instead of an Initial DB, you need to enter a service name.  This is the service associated in the Oracle TNS listener file. 

This is a JDBC connection and as such, you do not need a local Oracle client installed.  You do need to know the server-level service name of the database though.

Oracle defaults to port 1521 but many administrators change that port for security reasons.

All of the other parameters are the same.  Figure 5.14 provides an example of an Oracle server connection.

Figure 5.14: Oracle Server Connection

If you have errors connecting to the Oracle server, you may want to install the Oracle client and get that working first.  If you have a working client, then you know the problem is not client side.


This is an excerpt from the book "EnterpriseDB: The Definitive Reference" by Rampant TechPress.


Oracle performance tuning software 

Oracle performance tuning book


Oracle performance Tuning 10g reference poster
Oracle training in Linux commands
Oracle training Excel
Oracle training & performance tuning books



Copyright © 1996 -  2014 by Burleson. All rights reserved.

Oracle® is the registered trademark of Oracle Corporation. 

Hit Counter