NIFI oracle connection error after upgrade to oracle 19c

[#1]

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
)

[#2 · Accepted solution]

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

[#3]

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.