Home Discussions Questions & Answers JNDI ‘ebsDB’ Connection Failure Post-ECC Install

JNDI ‘ebsDB’ Connection Failure Post-ECC Install

Avatar photoCustomer July 22, 2023 at 1:02 pm

I am stuck on step 4 of ECC installation (‘Create EBS JNDI’). The configuration process fails with an error: `weblogic.application.ModuleException: weblogic.common.resourcepool.ResourceSystemException: Could not create connection for datasource ‘ebsDB’`. What does this indicate?

Viewing 6 reply threads
  • Author
    Replies
    • Support July 23, 2023 at 2:51 pm  

      This specific error generally points to a fundamental connectivity issue preventing the ECC Weblogic environment from establishing a database connection to the EBS instance using the defined JNDI datasource `ebsDB`. First, ensure that the EBS database host specified in the `connection.dbc` file on the ECC server is correctly configured and resolvable. You must check the `APPS_JDBC_URL` value within the `connection.dbc` file to confirm the hostname and port are correct.

    • Avatar photoCustomer July 24, 2023 at 9:14 pm  

      I verified the DBC file and the host/port look correct. What are the next steps for network troubleshooting?

    • Support July 26, 2023 at 2:00 pm  

      If the DBC file appears correct, the issue is likely network related or an authentication problem. You should perform two essential network checks from the ECC server itself: first, verify the database host is resolvable by running a `ping` command using the hostname listed in the DBC file. Second, confirm that the database port is open for connections by attempting a `telnet` command (or similar tool) from the ECC server to the EBS database host and port. If either of these tests fails, you need to address networking or firewall rules.

    • Avatar photoCustomer July 28, 2023 at 3:13 am  

      I confirmed ping and telnet connectivity successfully. However, when I try to run the JNDI creation script again, it still fails. Could recreating the DBC file help?

    • Support July 29, 2023 at 2:18 am  

      Yes, sometimes recreating the Database Connection (DBC) file resolves underlying issues, especially if the original file generation was problematic or if the EBS node details changed. To generate a new DBC file specifically for the ECC host system, you should execute the `AdminDesktop` utility on the EBS application node, specifying the fully qualified domain name of the ECC host using the `CREATE NODE_NAME` parameter. After generating the file (e.g., `EBSDB_ECC.ENGINATICS.COM.dbc`), ensure you copy this newly created file to the specified location on the ECC server, usually under the `quickInstall` directory as `connection.dbc`.

    • Avatar photoCustomer July 30, 2023 at 7:10 pm  

      We are using RAC with SCAN listeners. I heard this can cause problems for DBC files in ECC setup. Is that true?

    • Support July 31, 2023 at 7:14 am  

      That is indeed a crucial point; using SCAN listeners has been known to cause issues during ECC configuration. If your DBC file contains the SCAN entry, it is often recommended to manually replace the SCAN entry with the Virtual IP (VIP) address in the `EccConfig.properties` file and the generated `connection.dbc` file. Although the JNDI creation process attempts to read the connection string, using the VIP explicitly ensures proper resolution and connection establishment, circumventing potential issues associated with SCAN resolution in this specific ECC setup context.

Viewing 6 reply threads
  • You must be logged in to reply to this post.

Login with: