oracle fun
We couldn’t connect via the listener to a database with the following error:
ORA-01034: ORACLE not available
ORA-27101: shared memory realm does not exist
Linux-x86_64 Error: 2: No such file or directory
It was not the client environment, but it turned out that something is not ok with the listener.ora. (Although it didn’t report any errors at start-up.) The funny thing is that above 10g you don’t need to have a listener.ora file, so we deleted it, started again the listener, and voilà, clients can connect.
(y)
