Kettle connection failure solution for Oracle database reporting ora-12505

Kettle was used due to the Informatica bug.

I used it for the first time today. I found it to know the master of kettle.ProgramStartup method: run data-integration \ spoon. bat.

After the startup, it is found that the database cannot be connected when the database is configured, and an error is always reported. So I checked the driver and found that kettle does not contain the Oracle driver by default. So I put the oracle JDBC driver ojdbc5.jar/ojdbc6.jar to the kettle directory data-integration \ libext \ JDBC, and logged on to the database with the PL/SQL account to confirm that the account is correct. Restart kettle configuration or report an error.

Org. pentaho. Di. Core. Exception. kettledatabaseexception: Error occured while trying to connect to the databaseerror connecting to database: (using class oracle. JDBC. Driver. oracledriver)

After searching on the internet, we found that kettle used the database name "sid_name" instead of "SERVICE_NAME" of PL/SQL, So we connected the database using PL/SQL:

Select instance_name from V $ instance;

We found that this name and the "SERVICE_NAME" I wrote are only case sensitive.

Enter this name in kettle's "Database Name" and the test will be OK. It turns out that.