Sun Cluster Data Service for Oracle RAC Guide for Solaris OS

Appendix B Preset Actions for DBMS Errors and Logged Alerts

Preset actions for database management system (DBMS) errors and logged alerts are listed as follows:

DBMS errors for which an action is preset are listed in Table B–1.
Logged alerts for which an action is preset are listed in Table B–2.

Table B–1 Preset Actions for DBMS Errors


Error Number	Action	Connection State	New State	Message
18	`NONE`	`co`	`di`	`Max. number of DBMS sessions exceeded`
20	`NONE`	`co`	`di`	`Max. number of DBMS processes exceeded`
28	`NONE`	`on`	`di`	`Session killed by DBA, will reconnect`
50	`RESTART`	`*`	`di`	`O/S error occurred while obtaining an enqueue. See o/s error.`
51	`NONE`	`*`	`di`	`timeout occurred while waiting for resource`
55	`NONE`	`*`	`*`	`maximum number of DML locks in DBMS exceeded`
62	`STOP`	`*`	`di`	`Need to set DML_LOCKS in init.ora file to value other than 0`
107	`RESTART`	`*`	`di`	`failed to connect to ORACLE listener process`
257	`NONE`	`*`	`di`	`archiver error. Connect internal only, until freed.`
290	`RESTART`	`*`	`di`	`Operating system archival error occurred. Check alert log.`
447	`RESTART`	`*`	`di`	`fatal error in background process`
448	`RESTART`	`*`	`di`	`normal completion of background process`
449	`RESTART`	`*`	`di`	background process `%s' unexpectedly terminated with error %s
470	`RESTART`	`*`	`di`	`Oracle background process died`
471	`RESTART`	`*`	`di`	`Oracle background process died`
472	`RESTART`	`*`	`di`	`Oracle background process died`
473	`RESTART`	`*`	`di`	`Oracle background process died`
474	`RESTART`	`*`	`di`	`SMON died, warm start required`
475	`RESTART`	`*`	`di`	`Oracle background process died`
476	`RESTART`	`*`	`di`	`Oracle background process died`
477	`RESTART`	`*`	`di`	`Oracle background process died`
480	`RESTART`	`*`	`di`	`LCK* process terminated with error`
481	`RESTART`	`*`	`di`	`LMON process terminated with error`
482	`RESTART`	`*`	`di`	`LMD* process terminated with error`
602	`RESTART`	`*`	`di`	`internal programming exception`
604	`NONE`	`on`	`di`	`Recursive error`
705	`RESTART`	`*`	`di`	`inconsistent state during start up`
942	`NONE`	`on`	`*`	`Warning - V$SYSSTAT not accessible - check grant on V_$SYSSTAT`
1001	`NONE`	`on`	`di`	`Lost connection to database`
1002	`NONE`	`on`	`*`	`Internal error in HA-DBMS Oracle`
1003	`NONE`	`on`	`di`	`Resetting database connection`
1012	`NONE`	`on`	`di`	`Not logged on`
1012	`RESTART`	`di`	`co`	`Not logged on`
1014	`NONE`	`*`	`*`	`ORACLE shutdown in progress`
1017	`STOP`	`*`	`*`	`Please correct login information in HA-DBMS Oracle database configuration`
1031	`NONE`	`on`	`*`	`Insufficient privileges to perform DBMS operations - check Oracle user privileges`
1033	`NONE`	`co`	`co`	`Oracle is in the shutdown or initialization process`
1033	`NONE`	`*`	`di`	`Oracle is in the shutdown or initialization process`
1034	`RESTART`	`co`	`co`	`Oracle is not available`
1034	`RESTART`	`di`	`co`	`Oracle is not available`
1034	`NONE`	`on`	`di`	`Oracle is not available`
1035	`RESTART`	`co`	`co`	`Access restricted - restarting database to reset`
1041	`NONE`	`on`	`di`
1041	`NONE`	`di`	`co`
1045	`NONE`	`co`	`*`	`Fault monitor user lacks CREATE SESSION privilege logon denied.`
1046	`RESTART`	`*`	`di`	`cannot acquire space to extend context area`
1050	`RESTART`	`*`	`di`	`cannot acquire space to open context area`
1053	`RESTART`	`*`	`*`	`user storage address cannot be read or written`
1054	`RESTART`	`*`	`*`	`user storage address cannot be read or written`
1075	`NONE`	`co`	`on`	`Already logged on`
1089	`NONE`	`on`	`di`	`immediate shutdown in progresss`
1089	`NONE`	`*`	`*`	`Investigate! Could be hanging!`
1090	`NONE`	`*`	`di`	`shutdown in progress - connection is not permitted`
1092	`NONE`	`*`	`di`	`ORACLE instance terminated. Disconnection forced`
1513	`RESTART`	`*`	`*`	`invalid current time returned by operating system`
1542	`NONE`	`on`	`*`	`table space is off-line - please correct!`
1552	`NONE`	`on`	`*`	`rollback segment is off-line - please correct!`
1950	`NONE`	`on`	`*`	`Insufficient privileges to perform DBMS operations - check Oracle user privileges`
2701	`STOP`	`*`	`*`	`HA-DBMS Oracle error - ORACLE_HOME did not get set!`
2703	`RESTART`	`*`	`di`
2704	`RESTART`	`*`	`di`
2709	`RESTART`	`*`	`di`
2710	`RESTART`	`*`	`di`
2719	`RESTART`	`*`	`di`
2721	`RESTART`	`*`	`*`
2726	`STOP`	`*`	`*`	`Could not locate ORACLE executables - check ORACLE_HOME setting`
2735	`RESTART`	`*`	`*`	`osnfpm: cannot create shared memory segment`
2811	`RESTART`	`*`	`*`	`Unable to attach shared memory segment`
2839	`RESTART`	`*`	`*`	`Sync of blocks to disk failed.`
2840	`RESTART`	`*`	`*`
2846	`RESTART`	`*`	`*`
2847	`RESTART`	`*`	`*`
2849	`RESTART`	`*`	`*`
2842	`RESTART`	`*`	`*`	`Client unable to fork a server - Out of memory`
3113	`RESTART`	`co`	`di`	`lost connection`
3113	`NONE`	`on`	`di`	`lost connection`
3113	`NONE`	`di`	`di`	`lost connection`
3114	`NONE`	`*`	`co`	`Not connected?`
4030	`RESTART`	`*`	`*`
4032	`RESTART`	`*`	`*`
4100	`RESTART`	`*`	`*`	`communication area cannot be allocated insufficient memory`
6108	`STOP`	`co`	`*`	`Can't connect to remote database - make sure SQL*Net server is up`
6114	`STOP`	`co`	`*`	`Can't connect to remote database - check SQL*Net configuration`
7205	`RESTART`	`*`	`di`
7206	`RESTART`	`*`	`di`
7208	`RESTART`	`*`	`di`
7210	`RESTART`	`*`	`di`
7211	`RESTART`	`*`	`di`
7212	`RESTART`	`*`	`di`
7213	`RESTART`	`*`	`di`
7214	`RESTART`	`*`	`di`
7215	`RESTART`	`*`	`di`
7216	`RESTART`	`*`	`di`
7218	`RESTART`	`*`	`di`
7219	`RESTART`	`*`	`*`	`slspool: unable to allocate spooler argument buffer.`
7223	`RESTART`	`*`	`*`	`slspool: fork error, unable to spawn spool process. - Resource limit reached`
7224	`RESTART`	`*`	`*`
7229	`RESTART`	`*`	`*`
7232	`RESTART`	`*`	`*`
7234	`RESTART`	`*`	`*`
7238	`RESTART`	`*`	`*`	`slemcl: close error.`
7250	`RESTART`	`*`	`*`
7251	`RESTART`	`*`	`*`
7252	`RESTART`	`*`	`*`
7253	`RESTART`	`*`	`*`
7258	`RESTART`	`*`	`*`
7259	`RESTART`	`*`	`*`
7263	`RESTART`	`*`	`*`
7269	`RESTART`	`*`	`*`
7279	`RESTART`	`*`	`*`
7280	`RESTART`	`*`	`*`
7296	`RESTART`	`*`	`*`
7297	`RESTART`	`*`	`*`
7306	`RESTART`	`*`	`*`
7310	`RESTART`	`*`	`*`
7315	`RESTART`	`*`	`*`
7321	`RESTART`	`*`	`*`
7322	`RESTART`	`*`	`*`
7324	`RESTART`	`*`	`*`
7325	`RESTART`	`*`	`*`
7351	`RESTART`	`*`	`*`
7361	`RESTART`	`*`	`*`
7404	`RESTART`	`*`	`*`
7414	`RESTART`	`*`	`*`
7415	`RESTART`	`*`	`*`
7417	`RESTART`	`*`	`*`
7418	`RESTART`	`*`	`*`
7419	`RESTART`	`*`	`*`
7430	`RESTART`	`*`	`*`
7455	`RESTART`	`*`	`*`
7456	`RESTART`	`*`	`*`
7466	`RESTART`	`*`	`*`
7470	`RESTART`	`*`	`*`
7475	`RESTART`	`*`	`*`
7476	`RESTART`	`*`	`*`
7477	`RESTART`	`*`	`*`
7478	`RESTART`	`*`	`*`
7479	`RESTART`	`*`	`*`
7481	`RESTART`	`*`	`*`
9706	`RESTART`	`*`	`*`
9716	`RESTART`	`*`	`*`
9718	`RESTART`	`*`	`*`
9740	`RESTART`	`*`	`*`
9748	`RESTART`	`*`	`*`
9747	`RESTART`	`*`	`*`
9749	`RESTART`	`*`	`*`
9751	`RESTART`	`*`	`*`
9755	`RESTART`	`*`	`*`
9757	`RESTART`	`*`	`*`
9756	`RESTART`	`*`	`*`
9758	`RESTART`	`*`	`*`
9761	`RESTART`	`*`	`*`
9765	`RESTART`	`*`	`*`
9779	`RESTART`	`*`	`*`
9829	`RESTART`	`*`	`*`
9831	`RESTART`	`*`	`*`
9834	`RESTART`	`*`	`*`
9836	`RESTART`	`*`	`*`
9838	`RESTART`	`*`	`*`
9837	`RESTART`	`*`	`*`
9844	`RESTART`	`*`	`*`
9845	`RESTART`	`*`	`*`
9846	`RESTART`	`*`	`*`
9847	`RESTART`	`*`	`*`
9853	`RESTART`	`*`	`*`
9854	`RESTART`	`*`	`*`
9856	`RESTART`	`*`	`*`
9874	`RESTART`	`*`	`*`
9876	`RESTART`	`*`	`*`
9877	`RESTART`	`*`	`*`
9878	`RESTART`	`*`	`*`
9879	`RESTART`	`*`	`*`
9885	`RESTART`	`*`	`*`
9888	`RESTART`	`*`	`*`
9894	`RESTART`	`*`	`*`
9909	`RESTART`	`*`	`*`
9912	`RESTART`	`*`	`*`
9913	`RESTART`	`*`	`*`
9919	`RESTART`	`*`	`*`
9943	`RESTART`	`*`	`*`
9947	`RESTART`	`*`	`*`
9948	`RESTART`	`*`	`*`
9949	`RESTART`	`*`	`*`
9950	`RESTART`	`*`	`*`
12505	`STOP`	`*`	`*`	`TNS:listener could not resolve SID given in connect descriptor.Check listener configuration file.`
12541	`STOP`	`*`	`*`	`TNS:no listener. Please verify connect_string property, listener and TNSconfiguration.`
12545	`STOP`	`*`	`*`	`Please check HA-Oracle parameters. Connect failed because target host or object does not exist`
27100	`STOP`	`*`	`*`	`Shared memory realm already exists`
99999	`RESTART`	`*`	`di`	`Monitor detected death of Oracle background processes.`

Table B–2 Preset Actions for Logged Alerts


Alert String	Action	Connection State	New State	Message
`ORA-07265`	`RESTART`	`*`	`di`	`Semaphore access problem`
`found dead multi-threaded server`	`NONE`	`*`	`*`	`Warning: Multi-threaded Oracle server process died (restarted automatically)`
`found dead dispatcher`	`NONE`	`*`	`*`	`Warning: Oracle dispatcher process died (restarted automatically)`