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.
After registering, you will be asked if you want to run the Server Side Objects Wizard.
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 data type 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.