Registering an Oracle Server

Previous  Top  Next

In order to register an Oracle server, you need to fill out the dialog below, reached via the Enterprise Manager and the Register Server button.

 

Register an Oracle Server

 

Database Workbench can connect to Oracle via two protocols:

TNS (native Oracle)
Direct (TCP/IP connection, no need for the Oracle client software)

 

On some workstations, the "direct" connection might be faster and there's no need to register an Oracle server with the TNS configuration. For the rest, both options are almost the same.

 

Note

When using the "direct" approach, you cannot browse any of the object-types in Oracle. The XMLType "datatype" is also an object-type.

 

Database Workbench needs the following information for a connection:

Alias

An user-defined alias name for the server - this is only used inside Database Workbench.

TNS Name

A TNS name as register on your local workstation.

Hostname

TCP/IP hostname for a direct connection.

Port

TCP/IP port on which your Oracle server is listening for connections.

Servicename

Instance ID for your Oracle instance.

Username

The default username for databases.

Password

The password for the username given.

 

Schema Filter

If you click OK, Database Workbench will test the connection - if this succeeds, you get the option to filter the schemas you want to see once you have established a session with your Oracle server. The checked schemas will be visible in the Database Navigator, if you're the owner of a schema, this schema will be "expanded" by default. The schema filter you are creating here is the default filter if you don't create a new filter for each "connection profile".

 

Database Workbench shows two types of schema names:

1.Schemas with objects (called Schemas in the dialog)
2.Schemas without objects (called Users in the dialog)

 

Note:

The username/password combination that you're using when registering a server will also be used to gather information about tablespaces, users etc... If you do not have access to the relevant areas in the Oracle dictionary, you will not be able to use this functionality.