Sun Cluster Data Service for Oracle Guide for Solaris OS
只搜寻这本书
查看这本书:
以 PDF 格式下载本书 (603 KB)

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:

  • DBMS errors for which an action is preset are listed in Table 1.

  • Logged alerts for which an action is preset are listed in Table 2.

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)