New Oracle Connection
The tool's connection method is consistent with Navicat, PL/SQL Developer, and other database tools. If you have other database tools installed, you can refer to their database connection information for filling in.
Note:
The tool directory should not contain non-ansi characters, or else the connection may fail.
Avoid using superusers like SYSDBA or SYSTEM for connection. Imported tables will be under the connected user.
Server Name: Enter the server address where the Oracle database is installed.
For a local database connection, you can enter LOCALHOST, 127.0.0.1, or your computer's IP address.
For a remote database connection, enter the server's IP address.
Port: Enter the Oracle port number. The default port number is 1521. If you used a custom port number during installation, please enter that instead.
Service Name/SID: Enter the service name or SID.
Username: Enter the username that is allowed to connect to the Oracle database and has the necessary permissions to use the tool (e.g., for CRUD operations).
Password: Enter the corresponding password for the username provided. If the connection fails, double-check that the password is correct.
Step 1: Fill in the necessary connection information and click "Test Connection".
Step 2: After a successful connection prompt, provide a connection name and click "OK". Common Issues:
- DPI-1047: Cannot locate a 64-bit Oracle Client library
The tool directory should not contain non-ansi characters. Move the tool to a directory with English characters and try again.