Skip Ribbon Commands
Skip to main content
Navigate Up
Sign In

Quick Launch

Average Rating:

facebook Twitter
Email
Print Bookmark Alert me when this article is updated

Feedback

ERROR: "java command not found" while running JDBC test utility in Informatica Server machine
Problem Description

While running JDBC test utility, provided with Informatica, using 'testforjdbc.sh' script from '$INFA_HOME/tools/debugtools/jdbctest' location, execution failed with the following error message, after providing the connection details:

 

 

[infagcs@vento testforjdbc]$ ./testforjdbc.sh 

bash: ./testforjdbc.sh: Permission denied 

[infagcs@vento testforjdbc]$ ./testforjdbc.sh 

./testforjdbc.sh: line 78: java: command not found 

Cause

Encountered issue is due to absence of 'JAVA_HOME' environment variable setting and hence, '$JAVA_HOME/bin' location in the 'PATH' environment variable setting.

Solution

 

Perform the following steps to resolve the encountered issue:

 

  1. Login to Informatica Server machine.
  2. Once logged in, set the JAVA_HOME environment variable to Java folder in the Informatica Home, as below: 

bash

export set JAVA_HOME=$INFA_HOME/java/jre #Substitute $INFA_HOME variable with absolute location to the folder, where Informatica is installed.

export set PATH=$JAVA_HOME/bin:$PATH 

If the INFA_HOME is at location '/products/informatica/102' location, then run the following commands for setting JAVA_HOME:

 

export set JAVA_HOME=/products/informatica/102/java/jre

export set PATH=$JAVA_HOME/bin:$PATH 

    3. Once set, navigate to '$INFA_HOME/tools/debugtools/jdbctest' folder.

    4. Run the following commands to provide, execute permissions on the script, if not present already for the logged in user:

 

chmod ugo+x testforjdbc.sh

 

   5. Once permissions are provided, re-run the utility to test the JDBC connection and it should complete successfully.

More Information
Applies To
Product: Data Engineering Integration(Big Data Management); Data Quality; Enterprise Data Preparation
Problem Type: Configuration; Connectivity
User Type: Administrator; Developer
Project Phase: Implement; Configure
Product Version: Informatica 10.0; Informatica 10.1; Informatica 10.1.1; Informatica 10.2; Informatica 10.2.1; Informatica 10.2.1 Service Pack 1; Informatica 10.2.2; HotFix; Informatica 10.4
Database:
Operating System: Linux
Other Software:

Reference
Attachments
Last Modified Date:3/31/2020 4:31 AMID:527820
People who viewed this also viewed

Feedback

Did this KB document help you?



What can we do to improve this information (2000 or fewer characters)