跳过导航链接
退出打印视图
| 适用于 Oracle 的 Oracle Solaris Cluster 数据服务指南

搜索范围:

- 本文档
- 整个文档库

## DBMS 错误和已记录警报的预设操作

下面列出 DBMS 错误和已记录警报的预设操作：

- 表 1 中列出 DBMS 错误的预设操作。

- 表 2 中列出已记录警报的预设操作。

表 1 DBMS 错误的预设操作

错误编号 | 操作 | 连接状态 | 新状态 | 消息
--- | --- | --- | --- | ---
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 | `SWITCH` | `*` | `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 | `SWITCH` | `*` | `di` | `Operating system archival error occurred. Check alert log.`
447 | `SWITCH` | `*` | `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 | `SWITCH` | `*` | `di` | `Oracle background process died`
471 | `SWITCH` | `*` | `di` | `Oracle background process died`
472 | `SWITCH` | `*` | `di` | `Oracle background process died`
473 | `SWITCH` | `*` | `di` | `Oracle background process died`
474 | `RESTART` | `*` | `di` | `SMON died, warm start required`
475 | `SWITCH` | `*` | `di` | `Oracle background process died`
476 | `SWITCH` | `*` | `di` | `Oracle background process died`
477 | `SWITCH` | `*` | `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 | `SWITCH` | `*` | `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 | `SWITCH` | `*` | `*` | `user storage address cannot be read or written`
1054 | `SWITCH` | `*` | `*` | `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 | `SWITCH` | `*` | `*` | `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 | `SWITCH` | `*` | `*` | `Unable to attach shared memory segment`
2839 | `SWITCH` | `*` | `*` | `Sync of blocks to disk failed.`
2840 | `SWITCH` | `*` | `*` |
2846 | `SWITCH` | `*` | `*` |
2847 | `SWITCH` | `*` | `*` |
2849 | `SWITCH` | `*` | `*` |
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 | `SWITCH` | `*` | `di` |
7206 | `SWITCH` | `*` | `di` |
7208 | `SWITCH` | `*` | `di` |
7210 | `SWITCH` | `*` | `di` |
7211 | `SWITCH` | `*` | `di` |
7212 | `SWITCH` | `*` | `di` |
7213 | `SWITCH` | `*` | `di` |
7214 | `SWITCH` | `*` | `di` |
7215 | `SWITCH` | `*` | `di` |
7216 | `SWITCH` | `*` | `di` |
7218 | `SWITCH` | `*` | `di` |
7219 | `RESTART` | `*` | `*` | `slspool: unable to allocate spooler argument buffer.`
7223 | `RESTART` | `*` | `*` | `slspool: fork error, unable to spawn spool process. - Resource limit reached`
7224 | `SWITCH` | `*` | `*` |
7229 | `SWITCH` | `*` | `*` |
7232 | `SWITCH` | `*` | `*` |
7234 | `SWITCH` | `*` | `*` |
7238 | `SWITCH` | `*` | `*` | `slemcl: close error.`
7250 | `RESTART` | `*` | `*` |
7251 | `RESTART` | `*` | `*` |
7252 | `RESTART` | `*` | `*` |
7253 | `RESTART` | `*` | `*` |
7258 | `RESTART` | `*` | `*` |
7259 | `RESTART` | `*` | `*` |
7263 | `SWITCH` | `*` | `*` |
7269 | `SWITCH` | `*` | `*` |
7279 | `SWITCH` | `*` | `*` |
7280 | `RESTART` | `*` | `*` |
7296 | `SWITCH` | `*` | `*` |
7297 | `SWITCH` | `*` | `*` |
7306 | `RESTART` | `*` | `*` |
7310 | `SWITCH` | `*` | `*` |
7315 | `SWITCH` | `*` | `*` |
7321 | `SWITCH` | `*` | `*` |
7322 | `SWITCH` | `*` | `*` |
7324 | `RESTART` | `*` | `*` |
7325 | `RESTART` | `*` | `*` |
7351 | `SWITCH` | `*` | `*` |
7361 | `RESTART` | `*` | `*` |
7404 | `SWITCH` | `*` | `*` |
7414 | `RESTART` | `*` | `*` |
7415 | `RESTART` | `*` | `*` |
7417 | `SWITCH` | `*` | `*` |
7418 | `SWITCH` | `*` | `*` |
7419 | `SWITCH` | `*` | `*` |
7430 | `SWITCH` | `*` | `*` |
7455 | `SWITCH` | `*` | `*` |
7456 | `SWITCH` | `*` | `*` |
7466 | `SWITCH` | `*` | `*` |
7470 | `SWITCH` | `*` | `*` |
7475 | `SWITCH` | `*` | `*` |
7476 | `SWITCH` | `*` | `*` |
7477 | `SWITCH` | `*` | `*` |
7478 | `SWITCH` | `*` | `*` |
7479 | `SWITCH` | `*` | `*` |
7481 | `SWITCH` | `*` | `*` |
9706 | `SWITCH` | `*` | `*` |
9716 | `SWITCH` | `*` | `*` |
9718 | `RESTART` | `*` | `*` |
9740 | `SWITCH` | `*` | `*` |
9748 | `SWITCH` | `*` | `*` |
9747 | `RESTART` | `*` | `*` |
9749 | `RESTART` | `*` | `*` |
9751 | `RESTART` | `*` | `*` |
9755 | `RESTART` | `*` | `*` |
9757 | `RESTART` | `*` | `*` |
9756 | `SWITCH` | `*` | `*` |
9758 | `SWITCH` | `*` | `*` |
9761 | `RESTART` | `*` | `*` |
9765 | `RESTART` | `*` | `*` |
9779 | `RESTART` | `*` | `*` |
9829 | `RESTART` | `*` | `*` |
9831 | `SWITCH` | `*` | `*` |
9834 | `SWITCH` | `*` | `*` |
9836 | `SWITCH` | `*` | `*` |
9838 | `SWITCH` | `*` | `*` |
9837 | `RESTART` | `*` | `*` |
9844 | `RESTART` | `*` | `*` |
9845 | `RESTART` | `*` | `*` |
9846 | `RESTART` | `*` | `*` |
9847 | `RESTART` | `*` | `*` |
9853 | `SWITCH` | `*` | `*` |
9854 | `SWITCH` | `*` | `*` |
9856 | `RESTART` | `*` | `*` |
9874 | `SWITCH` | `*` | `*` |
9876 | `SWITCH` | `*` | `*` |
9877 | `RESTART` | `*` | `*` |
9878 | `RESTART` | `*` | `*` |
9879 | `RESTART` | `*` | `*` |
9885 | `RESTART` | `*` | `*` |
9888 | `RESTART` | `*` | `*` |
9894 | `RESTART` | `*` | `*` |
9909 | `RESTART` | `*` | `*` |
9912 | `RESTART` | `*` | `*` |
9913 | `RESTART` | `*` | `*` |
9919 | `SWITCH` | `*` | `*` |
9943 | `RESTART` | `*` | `*` |
9947 | `RESTART` | `*` | `*` |
9948 | `SWITCH` | `*` | `*` |
9949 | `SWITCH` | `*` | `*` |
9950 | `SWITCH` | `*` | `*` |
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`
98765 | `STOP` | `*` | `*` | `Database role queried from database does not match the Oracle Solaris Cluster resource's dataguard role configuration.`
99999 | `RESTART` | `*` | `di` | `Monitor detected death of Oracle background processes.`

表 2 已记录警报的预设操作

警报字符串 | 操作 | 连接状态 | 新状态 | 消息
--- | --- | --- | --- | ---
`ORA-07265` | `SWITCH` | `*` | `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)`

版权所有 © 2000, 2010, Oracle 和/或其附属公司。 保留所有权利。 法律声明 |