Oracle database - j5 - 30 - Installation & Upgrade - Hexagon

j5 Installation and Upgrade

Language
English
Product
j5
Search by Category
Installation & Upgrade
j5 Version
30
  • Database Type: Select Oracle.

  • Database Server: Enter the hostname or IP address of the database (the TNS Listener).

  • Database Name / SID: Enter the Oracle System ID (SID). For example, for the Oracle Database Express Edition, this is "XE".

  • Use SID as TNS Name: The SID set is an alias in a tnsnames.ora file.

    When using the Use SID as TNS Name option, set the TNS_ADMIN environment variable to the location of your tnsnames.ora file and restart the server before attempting to connect to the Oracle database. Using this option causes j5 to ignore the Database Server and Port options.

  • Username: Enter the username that j5 should use to connect to the database.

  • Password: Enter the password for the j5 database user specified above.

  • Port (optional): The TCP port of the TNS listener. If this is left blank, the default is 1521 (which is the default Oracle port).

Make sure the Oracle database user doesn’t use SYSTEM as their default tablespace. This is not supported by j5.

  • A connection to an Oracle database requires the Oracle Instant Client. The instant client is included in the j5 installation so no additional installation steps are required to connect j5 to the database.

  • ORA-6413, ORA-12154 with Oracle 10g on 64-bit Windows Installations. If your configuration is correct, but you are encountering connection errors ORA-6413 or ORA-12154, check that the Oracle Instant Client libraries installed on the j5 server are up to date. The full error message displayed will be one of the following:

    • ORA-6413: Connection not open.

    • ORA-12154: TNS: could not resolve the connect identifier specified