SP2-0157: unable to CONNECT to ORACLE after 3 attempts, exiting SQL*Plus
ORA-01034: ORACLE not available
ORA-27101: shared memory realm does not exist
Linux-x86_64 Error: 2: No such file or directory
Process ID: 0
Session ID: 0 Serial number: 0
Oracle_home, oracle_sid, tnsnames.ora,listerner.ora...all have same sid and oracle home..so no issues
It is not like my database is completely down.it is working fine but...it goes down by throughing above exception in between and again we have to login as sysdba and bring the database up.
Request you provide some suggestion on this.
Thanks a lot in advance.
My database details:
x86_64 x86_64 x86_64 GNU/Linux -64 bit
Oracle 11.2.0 version