Ignorer les liens de navigation
Quitter l'aperu
| Guide du service de données Oracle Solaris Cluster pour Oracle Real Application Clusters Oracle Solaris Cluster 3.3 3/13 (Français)

Périmètre de la recherche:

- Ce document
- Toute la bibliothque

Annexe B

## Actions prédéfinies pour les erreurs SGBD et les alertes journalisées

Les actions prédéfinies pour les erreurs de système de gestion de base de données (SGBD) et les alertes enregistrées sont répertoriées comme suit :

- Les erreurs SGBD pour lesquelles une action est définie sont répertoriées dans le Tableau B-1.

- Les alertes journalisées pour lesquelles une action est prédéfinie sont répertoriées dans le Tableau B-2.

Tableau B-1 Actions prédéfinies pour les erreurs SGBD

Numéro d'erreur | Action | Etat de connexion | Nouvel état | 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 | `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.`

Tableau B-2 Actions prédéfinies pour les alertes journalisées

Chaîne d'alerte | Action | Etat de connexion | Nouvel état | 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)`

Copyright © 2000, 2013, Oracle et/ou ses affiliés. Tous droits réservés. Notice légale |