Support Questions
Find answers, ask questions, and share your expertise
Announcements
Alert: Welcome to the Unified Cloudera Community. Former HCC members be sure to read and learn how to activate your account here.

NIFI oracle connection error after upgrade to oracle 19c

Solved Go to solution
Highlighted

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

Accepted Solutions

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

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

2 REPLIES 2

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

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

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

New Contributor

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.

Don't have an account?
Coming from Hortonworks? Activate your account here