I've moved a bunch of servers physically from one location to another and now I have a strange behavior on our old Oracle database.
Half of every connection attempt fails, except for applications using JDBC.
This problem have consistent behavior, after restarting the database or listener, the first non-JDBC connection fails, the second succeds, the third fails...
This is regardless of what host the connecting application is running on, what OS that host is running or application. Both sqlplus as well as our own applications developed with Pro*C fails with the same error:
ERROR:
ORA-01034: ORACLE not available
ORA-27101: shared memory realm does not exist
SVR4 Error: 2: No such file or directory
If I check listener.log, everything seems ok and setting trc_level to ADMIN for the listener (and parsing the tracefile with trcass) doesn't reveal anything.
Also, I've run truss (on Solaris) on the applications and they don't try to connect to a local database so the ORA-27101 has to originate from the database server.
The database is a 9.2.0.6 (32-bit) running on a machine with Solaris 9
Anyone have any clue on how to get a hold on whats wrong?
Edited by: roger.hakansson on Oct 28, 2009 8:59 AM
Edited by: roger.hakansson on Oct 28, 2009 9:33 AM