Hello,
I installed XE 18c and I have my connections with SQL Developer.
I created a connection with Pentaho PDI, but I have this error:
Error connecting to database [Localhost] :org.pentaho.di.core.exception.KettleDatabaseException:
Error occurred while trying to connect to the database
Error connecting to database: (using class oracle.jdbc.driver.OracleDriver)
ORA-01017: nom utilisateur/mot de passe non valide ; connexion refusée
org.pentaho.di.core.exception.KettleDatabaseException:
Error occurred while trying to connect to the database
Error connecting to database: (using class oracle.jdbc.driver.OracleDriver)
ORA-01017: nom utilisateur/mot de passe non valide ; connexion refusée
I add to C:\app\myuser\product\18.0.0\dbhomeXE\network\admin\sqlnet.ora this lines:
SQLNET.ALLOWED_LOGON_VERSION=8
SQLNET.ALLOWED_LOGON_VERSION_CLIENT = 8
SQLNET.ALLOWED_LOGON_VERSION_SERVER = 8
I add to C:\...\PDI\data-integration\lib this files:
ojdbc6.jar; ojdbc7.jar; ojdbc8.jar
I change my database name from XE to /XE
Always this error.