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

j5 Installation and Upgrade

Language
English
Product
j5
Search by Category
Installation & Upgrade
j5 Version
2019

A connection to an Oracle Database requires an installation of the Oracle Instant Client for Microsoft Windows (32bit). If the Oracle Database server (32-bit) is installed on the same machine as j5, then this will already be present. However, if the Oracle Database server is remote or 64-bit, the appropriate version of the Instant Client for Microsoft Windows (32-bit) should be downloaded, unzipped, and its location should be added to the Windows PATH environment variable.

If Oracle (64-bit) is installed, the path with the 32-bit client libraries should appear on the PATH environment variable before the path to the 64-bit Oracle client libraries.

  • Database Type: Select Oracle.

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

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

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

  • Username: Provide the user name that j5 should use to connect to the database.

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

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

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

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

  • If 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.