question Re: NIFI oracle connection error after upgrade to oracle 19c in Support Questions

NIFI oracle connection error after upgrade to oracle 19c

gwatene — Wed, 27 Nov 2019 13:46:48 GMT

Hello I encountered the error below on nifi after an upgrade, please help to solve it

PutSQL[id=11f8203a-164b-1df4-47b3-137747566249] Failed to process session due to java.sql.SQLException: Cannot create PoolableConnectionFactory (ORA-01034: ORACLE not available
ORA-27101: shared memory realm does not exist
Linux-x86_64 Error: 2: No such file or directory
): org.apache.nifi.processor.exception.ProcessException: java.sql.SQLException: Cannot create PoolableConnectionFactory (ORA-01034: ORACLE not available
ORA-27101: shared memory realm does not exist
Linux-x86_64 Error: 2: No such file or directory
)

Re: NIFI oracle connection error after upgrade to oracle 19c

gwatene — Wed, 27 Nov 2019 11:44:52 GMT

I simply solved this by editing my connection to as below

from - Database Connection URL -> jdbc:oracle:thin:@servername:1521/SID

to - Database Connection URL -> jdbc:oracle:thin:@servername:1521:SID

Database Connection URL -> jdbc:oracle:thin:@servername:1521:SID

Database Driver Class Name -> oracle.jdbc.driver.OracleDriver

Database User -> Username

Password -> Password

Re: NIFI oracle connection error after upgrade to oracle 19c

chad_woodhead — Mon, 06 Jan 2020 18:11:48 GMT

What version of NiFi are you running? Our source Oracle systems will be upgrading from 12c to 19c and I want to make sure our flows will still work. I'm on NiFi 1.8.0.