Support Questions
Find answers, ask questions, and share your expertise

NIFI oracle connection error after upgrade to oracle 19c

New Contributor

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
)

 

1 ACCEPTED SOLUTION

New Contributor

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

View solution in original post

2 REPLIES 2

New Contributor

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

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.

Take a Tour of the Community
Don't have an account?
Your experience may be limited. Sign in to explore more.