0

My application is running on Oracle Database which hosts 3 database instances. All of sudden one of my database instance is not running. when connected through sysdba it says "connected to idle instance". Here are the activities performed

Oracle version:Release 11.2.0.4.0

  1. sudo su - oracle
  2. export ORACLE_SID=testdev1
  3. sqlplus / AS SYSDBA

Connected to an idle instance.

  1. shutdown immediate

ORA-01034: ORACLE not available

ORA-27101: shared memory realm does not exist Linux-x86_64 Error: 2: No such file or directory

  1. startup

ORA-01078: failure in processing system parameters

ORA-01565: error in identifying file '+DATADG/testdev1/spfiltestdev1.ora'

ORA-17503: ksfdopn:2 Failed to open file +DATADG/testdev1/spfiletestdev1.ora

ORA-29701: unable to connect to Cluster Synchronization Service

can anyone help me what is the issue ?

Improve this question
6
  • 1
    Sounds like ASM or a related service might not be running?
    – Alex Poole
    Sep 13, 2018 at 16:33
  • how should I check for ASM ?
    – Chandu
    Sep 13, 2018 at 17:34
  • 'ps -ef |grep -i ASM' also 'ps -ef|grep pmon' and see if an ASM instance is listed. Also 'set ORACLE_SID=+ASM' then 'sqlplus / as sysasm'
    – EdStevens
    Sep 13, 2018 at 19:13
  • I usually use source /usr/local/bin/oraenv before sqlplus. This will add all of the other environmental variables that might be needed.
    – Michael Kutz
    Sep 13, 2018 at 23:30
  • Also, check your cluster status with crsctl check crs
    – vegatripy
    Sep 17, 2018 at 15:44

1 Answer 1

Reset to default
0

unfortunately my database ASM service is not running. I restarted and everything worked. thanks all for your help

Improve this answer

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge that you have read and understand our privacy policy and code of conduct.

Not the answer you're looking for? Browse other questions tagged or ask your own question.