Cloudera Community
gwatene
user rank
New Contributor
My Accepted Solutions
Show All

Re: NIFI oracle connection error after upgrade to ...

by New Contributor in Support Questions
‎11-27-2019 03:44 AM
1 Kudo
‎11-27-2019 03:44 AM
1 Kudo
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 more

NIFI oracle connection error after upgrade to orac...

by New Contributor in Support Questions
‎11-27-2019 03:36 AM
‎11-27-2019 03:36 AM
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 )   ... View more
Labels:
Contact Me
Online
Offline
Last Visited
‎04-30-2020 01:22 AM
Community Statistics
Member Since ‎08-19-2019 12:45 AM
Last Visited ‎04-30-2020 01:22 AM
Posts 3
Kudos received 1