Issue: we are unable to open the database after applying the patch. So
even tried to open the database by roll backing the patch in FTCDPCH1. When we
try to startup the database we are facing the below errors. The below error
message in alert log files is pointing to the memory/NFS related issues on
these boxes.
Getting the below error while starting the database:
SQL> startup
ORACLE instance started.
Total System Global Area
1073741824 bytes
Fixed
Size
2089336 bytes
Variable
Size
427822728 bytes
Database
Buffers 629145600 bytes
Redo
Buffers
14684160 bytes
ORA-01102: cannot mount database in EXCLUSIVE mode
Found below errors in the alertlog:
sculkget: failed to lock /ftcdpch1/app/db/10.2.0//dbs/lkFTCDPCH1
exclusive
sculkget: lock held by PID: 8
Thu May 17 03:46:09 2012
ORA-09968: unable to lock file
Linux-x86_64 Error: 11: Resource temporarily unavailable
Additional information: 8
Thu May 17 03:46:09 2012
ORA-1102 signalled during: ALTER
DATABASE MOUNT...
Thu May 17 03:46:48 2012
Cause: it was due to some NFS memory locks at OS level.
Resolution: Informed to UNIX team to reboot the server and then the issue resolved..
No comments:
Post a Comment