Contributors,
I am a newbie in Oracle and have oracle database installed and working as expected until few days ago. One day i was getting these ugly messages when connecting via SQLplus
ERROR:
ORA-01034: ORACLE not available
ORA-27101: shared memory realm does not exist
Process ID: 0
Session ID: 0 Serial number: 0
I did some searches on this topic but haven't found solutions.
* Some suggested to check[b] environment variables ORACLE_HOME and ORACLE_SID : my ORACLE_HOME is fine, and i DO NOT have ORACLE_SID on the day i realize the problem.
I am not sure if ORACLE_SID variable is usually exist when my database was up and running. So i set ORACLE_SID yet did not help.
* Some said check if the required
services are running :
- OracleOraDb11g_home1TNSListener : RUNNING
- OracleServiceORCL : RUNNING
* Other said that they have the same problem, but everything back to normal after several hours without anything configured / changed (
miraculous)
* I tried to
restart or shut down, but no luck
* In the same thread few days ago, Vlado helped me with suggestion to acces
ADRCI and type SHOW PROBLEM also SHOW INCIDENT
but the reply is
DIA-48494: ADR home is not set, the corresponding operation cannot be done
* Other implied to check the .ora files in NETWORK\ADMIN. I will post it (
TNSNAMES.ORA, LISTENER.ORA, SQLNET.ORA) after this.
My platform and some info :
* OS : MS Windows Vista Ultimate
* Oracle Database 11g Release 1 (11.1.0.6.0) Enterprise/ Standard Edition for Microsoft Windows 32-bit
Mostly i used SQLplus and SQLdeveloper, for developing procedures/ functions/ packages in Oracle Spatial.
Also, am running it in one laptop (server and client altogether).
There is only one database in the Laptop (no other oracle database).
How to fix this ? Please kindly help me.
Many thanks in advance,
Damon