JavaScript is required to for searching.
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
search filter icon
search icon

Información del documento

Prefacio

Instalación y configuración de HA para Oracle

A.  Propiedades de extensión de HA para Oracle

B.  Acciones preestablecidas para errores de DBMS y alertas registradas

C.  Configuraciones de ejemplo para Oracle ASM con HA para Oracle

Índice

Acciones preestablecidas para errores de DBMS y alertas registradas

A continuación se describen las acciones preestablecidas para los errores y las alertas registradas de DBMS:

Tabla 1 Acciones preestablecidas para errores de DBMS

Código de error
Acción
Estado de la conexión
Estado nuevo
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
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.

Tabla 2 Acciones preestablecidas para alertas registradas

Cadena de alerta
Acción
Estado de la conexión
Estado nuevo
Mensaje
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)