En ocasiones puede suceder que cuando intentas apagar o bajar tu instancia de oracle, te aparecen mensajes como que ya existe un proceso de apagado. O como lo que me salió a mi recientemente…
SQL*Plus: Release 10.2.0.5.0 - Production on Fri Jun 1 08:32:37 2018
Copyright (c) 1982, 2010, Oracle. All Rights Reserved.
Connected.
SQL> shutdown immediate
ORA-24324: service handle not initialized
ORA-24323: value not allowed
ORA-01089: immediate shutdown in progress - no operations are permitted
SQL> quit
Disconnected
SQL*Plus: Release 10.2.0.5.0 - Production on Fri Jun 1 08:32:37 2018
Copyright (c) 1982, 2010, Oracle. All Rights Reserved.
Connected.
SQL> shutdown immediate
ORA-24324: service handle not initialized
ORA-24323: value not allowed
ORA-01089: immediate shutdown in progress - no operations are permitted
SQL> quit
Disconnected
SQL*Plus: Release 10.2.0.5.0 - Production on Fri Jun 1 08:32:37 2018 Copyright (c) 1982, 2010, Oracle. All Rights Reserved. Connected. SQL> shutdown immediate ORA-24324: service handle not initialized ORA-24323: value not allowed ORA-01089: immediate shutdown in progress - no operations are permitted SQL> quit Disconnected
Pues bien, ni siquiera intentando subirla de nuevo el sistema podía tomar el control de la instancia.
Revisando el archivo alert log de la instancia, encuentro en las últimas lineas , estos mensajes…
sculkget: failed to lock /oracle/app/10.2.0/db/dbs/lkinstHISTORIC exclusive
sculkget: lock held by PID: 76873
Oracle Instance Startup operation failed. Another process may be attempting to startup or shutdown this Instance.
Failed to acquire instance startup/shutdown serialization primitive
sculkget: failed to lock /oracle/app/10.2.0/db/dbs/lkinstHISTORIC exclusive
sculkget: lock held by PID: 76873
Oracle Instance Startup operation failed. Another process may be attempting to startup or shutdown this Instance.
Failed to acquire instance startup/shutdown serialization primitive
sculkget: failed to lock /oracle/app/10.2.0/db/dbs/lkinstHISTORIC exclusive
sculkget: lock held by PID: 76873
Oracle Instance Startup operation failed. Another process may be attempting to startup or shutdown this Instance.
Failed to acquire instance startup/shutdown serialization primitive
sculkget: failed to lock /oracle/app/10.2.0/db/dbs/lkinstHISTORIC exclusive
sculkget: lock held by PID: 76873
Oracle Instance Startup operation failed. Another process may be attempting to startup or shutdown this Instance.
Failed to acquire instance startup/shutdown serialization primitive
sculkget: failed to lock /oracle/app/10.2.0/db/dbs/lkinstHISTORIC exclusive sculkget: lock held by PID: 76873 Oracle Instance Startup operation failed. Another process may be attempting to startup or shutdown this Instance. Failed to acquire instance startup/shutdown serialization primitive sculkget: failed to lock /oracle/app/10.2.0/db/dbs/lkinstHISTORIC exclusive sculkget: lock held by PID: 76873 Oracle Instance Startup operation failed. Another process may be attempting to startup or shutdown this Instance. Failed to acquire instance startup/shutdown serialization primitive
Luego de un buen rato buscando en Internet, encontré con que podía ejecutar el comando shutdown abort de la forma siguiente…
SQL*Plus: Release 10.2.0.5.0 - Production on Fri Jun 1 08:43:45 2018
Copyright (c) 1982, 2010, Oracle. All Rights Reserved.
Connected.
SQL> shutdown abort
ORACLE instance shut down.
SQL> quit
Disconnected
SQL*Plus: Release 10.2.0.5.0 - Production on Fri Jun 1 08:43:45 2018
Copyright (c) 1982, 2010, Oracle. All Rights Reserved.
Connected.
SQL> shutdown abort
ORACLE instance shut down.
SQL> quit
Disconnected
SQL*Plus: Release 10.2.0.5.0 - Production on Fri Jun 1 08:43:45 2018 Copyright (c) 1982, 2010, Oracle. All Rights Reserved. Connected. SQL> shutdown abort ORACLE instance shut down. SQL> quit Disconnected
Con esto el sistema recupera el control de la instancia y ya puedo iniciarla nuevamente…
SQL*Plus: Release 10.2.0.5.0 - Production on Fri Jun 1 08:44:13 2018
Copyright (c) 1982, 2010, Oracle. All Rights Reserved.
Connected to an idle instance.
SQL> startup
ORACLE instance started.
Total System Global Area 1610612736 bytes
Fixed Size 2096632 bytes
Variable Size 1023410696 bytes
Database Buffers 570425344 bytes
Redo Buffers 14680064 bytes
Database mounted.
Database opened.
SQL> quit
Disconnected from Oracle Database 10g Release 10.2.0.5.0 - 64bit Production
SQL*Plus: Release 10.2.0.5.0 - Production on Fri Jun 1 08:44:13 2018
Copyright (c) 1982, 2010, Oracle. All Rights Reserved.
Connected to an idle instance.
SQL> startup
ORACLE instance started.
Total System Global Area 1610612736 bytes
Fixed Size 2096632 bytes
Variable Size 1023410696 bytes
Database Buffers 570425344 bytes
Redo Buffers 14680064 bytes
Database mounted.
Database opened.
SQL> quit
Disconnected from Oracle Database 10g Release 10.2.0.5.0 - 64bit Production
SQL*Plus: Release 10.2.0.5.0 - Production on Fri Jun 1 08:44:13 2018 Copyright (c) 1982, 2010, Oracle. All Rights Reserved. Connected to an idle instance. SQL> startup ORACLE instance started. Total System Global Area 1610612736 bytes Fixed Size 2096632 bytes Variable Size 1023410696 bytes Database Buffers 570425344 bytes Redo Buffers 14680064 bytes Database mounted. Database opened. SQL> quit Disconnected from Oracle Database 10g Release 10.2.0.5.0 - 64bit Production
Y eso es todo….
Sin respuestas