An exception-stopping process for an Oracle database.

When restarting the database, forget to shut down an application, think of it, CTRL + C, the database shutdown immediate to force stop, the application stopped again, and then shutdown immdiate, when the data error.

[Email protected]:~> sqlplus '/as sysdba '

Sql*plus:release 11.2.0.3.0 Production on Tue 3 18:07:35 2016

Copyright (c) 1982, Oracle. All rights reserved.

Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.3.0-64bit Production
With the partitioning, OLAP, Data Mining and Real application testing options

sql> shutdown immediate;
^c^c^c^c^c

^c^c^c^c

Ora-12152:tns:unable to send break message

sql> sql> sql> sql>
sql> shutdown immediate;
Ora-24324:service Handle not initialized
Ora-01041:internal error. Hostdef extension doesn ' t exist
Sql>
Sql>
Sql>
sql> shutdown immediate;
Ora-24324:service Handle not initialized
Ora-01041:internal error. Hostdef extension doesn ' t exist
Sql>
Sql>
sql> startup force;
Ora-24324:service Handle not initialized
Ora-01041:internal error. Hostdef extension doesn ' t exist
sql> shutdown immediate;
Ora-24324:service Handle not initialized
Ora-01041:internal error. Hostdef extension doesn ' t exist
Sql>

In this case, the alert log is as follows:

Additional Information:1
Additional information:32823
Tue May 03 18:05:16 2016
Errors in FILE/OPT/ORACLE/APP/ORACLE/DIAG/RDBMS/PM4H/PM4H/TRACE/PM4H_M000_21073.TRC:
Ora-51106:check failed to complete due to an error. See error below
Ora-48101:error encountered when attempting to read a file [block] [/opt/oracle/app/oracle/diag/rdbms/pm4h/pm4h/ Metadata/hm_finding.ams] [0]
Ora-48102:encountered the End-of-file when reading the file
Additional information:64840
Additional Information:1
Additional information:32823
Tue May 03 18:06:45 2016
Errors in FILE/OPT/ORACLE/APP/ORACLE/DIAG/RDBMS/PM4H/PM4H/TRACE/PM4H_M000_25185.TRC:
Ora-51106:check failed to complete due to an error. See error below
Ora-48101:error encountered when attempting to read a file [block] [/opt/oracle/app/oracle/diag/rdbms/pm4h/pm4h/ Metadata/hm_finding.ams] [0]
Ora-48102:encountered the End-of-file when reading the file
Additional information:64840
Additional Information:1
Additional information:32823
Tue May 03 18:07:25 2016
OPIDCL aborting process unknown ospid (58374) as a result of ORA-2396
Tue May 03 18:07:26 2016

***********************************************************************

Fatal NI Connect error 12547, connecting to:
(Local=no)

VERSION Information:
TNS for Linux:version 11.2.0.3.0-production
Oracle bequeath NT Protocol Adapter for Linux:version 11.2.0.3.0-production
TCP/IP NT Protocol Adapter for Linux:version 11.2.0.3.0-production
time:03-may-2016 18:07:26
Tracing not turned on.
Tns error struct:
NS Main ERR code:12547

Tns-12547:tns:lost Contact
NS Secondary Err code:12560
NT Main ERR code:0
NT Secondary Err code:0
NT OS Err code:0
OPIODR aborting process unknown ospid (29320) as a result of ORA-609
Tue May 03 18:07:29 2016
OPIDCL aborting process unknown ospid (58149) as a result of ORA-2396
Tue May 03 18:07:44 2016
Errors in FILE/OPT/ORACLE/APP/ORACLE/DIAG/RDBMS/PM4H/PM4H/TRACE/PM4H_M000_29720.TRC:
Ora-51106:check failed to complete due to an error. See error below
Ora-48101:error encountered when attempting to read a file [block] [/opt/oracle/app/oracle/diag/rdbms/pm4h/pm4h/ Metadata/hm_finding.ams] [0]
Ora-48102:encountered the End-of-file when reading the file
Additional information:64840
Additional Information:1
Additional information:32823
Tue May 03 18:08:50 2016
Errors in FILE/OPT/ORACLE/APP/ORACLE/DIAG/RDBMS/PM4H/PM4H/TRACE/PM4H_M000_31031.TRC:
Ora-51106:check failed to complete due to an error. See error below
Ora-48101:error encountered when attempting to read a file [block] [/opt/oracle/app/oracle/diag/rdbms/pm4h/pm4h/ Metadata/hm_finding.ams] [0]
Ora-48102:encountered the End-of-file when reading the file
Additional information:64840
Additional Information:1
Additional information:32823
Tue May 03 18:10:03 2016
Shutting down instance (immediate)
Stopping background process SMCO
Shutting down Instance:further logons disabled
Stopping background process QMNC
Tue May 03 18:10:05 2016
Stopping background process CJQ0
Stopping background process MMNL
Stopping background process Mmon
License High water mark = 1426
Tue May 03 18:11:17 2016
ALTER DATABASE CLOSE NORMAL
Tue May 03 18:11:21 2016
smon:disabling TX Recovery
Smon:disabling Cache Recovery
^c

Measures to be processed:

1. View Shared memory resources
Ipcs-pmb

[Email protected]:~> ipcs-pm;

------Shared Memory creator/last-op PIDs--------
Shmid owner Cpid Lpid
3145744 Oracle 14924 32669
3178513 Oracle 14924 32669
3211282 Oracle 14924 32669
3244051 Oracle 14924 32669
3276820 Oracle 14924 32669
3309589 Oracle 14924 32669
3342358 Oracle 14924 32669
3375127 Oracle 14924 32669
3407896 Oracle 14924 32669
3440665 Oracle 14924 32733

Oracle resources are in use, so resources must be released to perform the following actions:

[Email protected]:~> ipcrm-m 3145744

(here must be one stop, cannot stop more than one at a time)

2.

sql> 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
sql> startup force;
ORACLE instance started.

Total System Global area 5.1310E+10 bytes
Fixed Size 2240344 bytes
Variable Size 3.1139E+10 bytes
Database buffers 2.0133E+10 bytes
Redo buffers 36098048 bytes
Database mounted.
Database opened.

An exception-stopping process for an Oracle database.