Acciones preestablecidas para errores de DBMS y alertas registradas

Apéndice B

Las acciones preestablecidas para los errores y las alertas registradas del sistema de administración de bases de datos (DBMS) se describen a continuación:

La Tabla B-1 enumera los errores de DBMS para los que se ha preestablecido una acción.
La Tabla B-2 enumera las alertas registradas para las que se ha preestablecido una acción.

Tabla B-1 Acciones preestablecidas para errores de DBMS

Número de error	Acción	Estado de conexión	Nuevo estado	Mensaje
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	`SWITCH`	`*`	`*`	`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.`

Tabla B-2 Acciones preestablecidas para alertas registradas

Cadena de alerta	Acción	Estado de conexión	Nuevo estado	Mensaje
`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)`

Omitir Vínculos de navegación
Salir de la Vista de impresión
	Guía del servicio de datos de Oracle Solaris Cluster para Oracle Real Application Clusters (RAC)