Registering an Oracle Server
|Previous Index Next How To Use|
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 three methods:
•Direct (TCP/IP connection, no need for the Oracle client software)
•TNS Names (registered TNS sources at your work station)
•TNS Connection Specifier, use the Oracle Instant Client and specify the connection details.
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.
Database Workbench needs the following information for a connection:
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:
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.