Sun Cluster Data Service for Oracle Guide for Solaris OS

Appendix B Preset Actions for Database Management System (DBMS) Errors and Logged Alerts

Preset actions for DBMS errors and logged alerts are listed as follows:

Table 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 

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 

STOP

*

*

Please check HA-Oracle parameters. Connect failed because target host or object does not exist

27100 

STOP

*

*

Shared memory realm already exists

Table 2 Preset Actions for Logged Alerts

Alert String 

Action 

Connection State 

New State 

Message 

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)