Search code examples
oracleora-01034ora-27101

I am able to connect to my schema via Oracle SQL Developer but not via JDBC

I am trying to connect to a schema on Oracle 11g on remote server via JDBC and I am getting following error while I am able to successfully connect through Oracle SQL Developer. I used the same JDBC code to connect many others schema which was always successful.

Jun 20, 2018 11:29:21 AM util.DBConnect getConnection
INFO: Driver loaded
Jun 20, 2018 11:29:24 AM util.DBConnect getConnection
SEVERE: java.sql.SQLRecoverableException: ORA-01034: ORACLE not available
ORA-27101: shared memory realm does not exist
Linux-x86_64 Error: 2: No such file or directory
Solution

  • Adding fully qualified sid name (XYZ01.abc.companydomain.com) in the url worked for me like following.

    my_connection_name.oracle.url = jdbc:oracle:thin:@dummyHostName.companydomain.net:1521/XYZ01.abc.companydomain.com