Database Patching issues and resolutions that I have experienced

These are some of the issues I have experienced when patching Oracle databases. Issue A You have stopped the databases,ASM and listener but when you run the opatch auto you may see the following in the log: If you look in the log, it shows : The details are: Check what process is locking the file : a) Solution It’s the listener, stop it and rerun the patch apply, In some cases it could be different file locking the patching, you can follow the same process to identify the lock and stop/shutdown the process that is locking the patching. Issue B Once all the patching has been completed, you try to start the ASM you get the ORA-29701: unable to connect to Cluster Synchronization Service: If you do a crsctl stat res -t, you can see the cssd is offline. b) Solution Start the ASM using 'srvctl start asm'  
Posted in Blog Tagged with: , ,

Affiliations

Engagements

  • Oracle OpenWorld 2014
  • Gartner BI Summit 9/3/15-10/3/15
  • UKOUG Business Analytics SIG 12/3/15
  • UKOUG Conference 7/12/15-9/12/15
  • Oracle Ireland Conference 2016 3/3/16-4/3/16
  • UKOUG Systems 2016 12/5/16
  • Oracle OpenWorld 2016
  • POUG 2016 7/10/16
  • DOAG 2016 15/11/16
  • UKOUG 2016 5/12/16

Videos

Posts

  • 2017 (8)
  • 2016 (22)
  • 2015 (22)
  • 2014 (8)
  • 2013 (2)