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:
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.