Use the Database Connection Properties dialog box to create or customize a database connection.
Direct mode does not require an Oracle Client to be installed on your workstation. dbForge Fusion for Oracle talks to the Oracle server directly, no third party libraries are required.
You can connect to a multi-threaded server using Direct mode. The server must be configured to use a specific port and TTC protocol. This can help you avoid firewall conflicts.
Direct mode advantages:
Direct mode restrictions:
You can return to a connection via an TNS at any time if restrictions above become critical for you.
The TNS connection type is an appropriate option in any of the following circumstances:
A TNS connection uses an alias entry from a tnsnames.ora file. dbForge Fusion for Oracle uses only one tnsnames.ora file. You may have more than one on your local machine or want to use the tnsnames.ora file on a remote machine, so note that dbForge Fusion for Oracle looks sequentially for the tnsnames.ora file in the following locations:
On Windows systems, if a tnsnames .ora file exists but dbForge Fusion for Oracle isn’t using it, create a TNS_ADMIN environment variable via Control Panel -> System -> Advanced -> Environment Variables, specifying the file’s location as the variable’s value.
dbForge Fusion for Oracle uses connection via an TNS by default.
With OS authentication, Oracle Database uses a database user’s OS login credentials to authenticate that user. The user doesn’t provide a username or password to access the database, and Oracle Database doesn’t store and manage the account password. Local OS authentication can be used when the client and the database server are on the same machine. Remote OS authentication is possible but is not considered secure.