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 ?

migrated from stackoverflow.com Sep 13 '18 at 19:08

This question came from our site for professional and enthusiast programmers.

  • 1
    Sounds like ASM or a related service might not be running? – Alex Poole Sep 13 '18 at 16:33
  • how should I check for ASM ? – Chandu Sep 13 '18 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 '18 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 '18 at 23:30
  • Also, check your cluster status with crsctl check crs – vegatripy Sep 17 '18 at 15:44
0

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

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

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