summary
Help page for creating Connection Configuration for Oracle Database.
entry
| item name | indispensable | Contents |
|---|---|---|
| Name | ✓ | Enter the name of the Connection Configuration to be used inside TROCCO. |
| memo | - | You can enter a note of Connection Configuration to be used inside TROCCO. |
| user | ✓ | Enter a user name for authentication. |
| (computer) password | ✓ | Enter the password for authentication. |
| Connection method | ✓ | Select from "Specify host name and port number" and "Use tnsnames.ora file".See Connection Methods for details. |
| CA certificate | - | You can enter a root certificate issued by a certification authority (CA). Please enter in pem file format.If you are using the TCPS protocol to secure your connection, please enter your CA certificate. |
| SSH Options | - | Select this option when connecting via SSH (using SSH tunnel). For more information, see Connecting via SSH Tunnel. |
| OJDBC Driver | - | Select the version corresponding to the database to be connected. Please refer to the Data Source - RDBMS Version Support Table for the supported versions of JDBC drivers. |
Connection method
Entry fields when "Specify host name and port number" is selected
| item name | indispensable | Contents |
|---|---|---|
| host | ✓ | Enter the host of the database to connect to. |
| destination port | ✓ | Enter the port of the database to connect to. |
| SSL communication | - | You can choose to enable or disable SSL communication. |
Entry fields when "Use tnsnames.ora file" is selected
| item name | indispensable | Contents |
|---|---|---|
ora file |
✓ | Enter the tnsnames.ora file. For more information, please refer to the official documentation. |
| wallet file | - | If you use Oracle Autonomous Database, please upload the wallet file (cwallet.sso ).When using a wallet file, specify 19c-ojdbc8.jar as the OJDBC driver. |