Contents x
    Connection Configuration for Oracle Database
      • Print
      • PDF
      Contents

      Connection Configuration for Oracle Database

        • Print
        • PDF
        Article summary

        summary

        Help page for creating Connection Configuration for Oracle Database.

        entry

        item nameindispensableContents
        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 nameindispensableContents
        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 nameindispensableContents
        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.
        Was this article helpful?
        What's Next