Erro ORA-07445

[alvesbru 0]

Preciso de ajuda:

 

Na aplicação ocorre o erro ( Fim do arquivo no canal de comunicação) ou Erro ao conectar com o servidor. Preciso saber o que pode gerar o erro.

 

Analisando o em tenho um alerta:

 

ORA-07445: exception encountered: core dump [opidsa()+386] [sIGSEGV] [Address not mapped to object] [0x000000000] [] []

 

 

Portando peguei os ultimos registros do alert.log

 

Thu Jan 28 00:07:15 2010

Incremental checkpoint up to RBA [0x3445.1723.0], current log tail at RBA [0x3446.239b.0]

Thu Jan 28 00:14:47 2010

Completed checkpoint up to RBA [0x3446.2.10], SCN: 295020733

Thu Jan 28 00:37:48 2010

Incremental checkpoint up to RBA [0x3446.24ca.0], current log tail at RBA [0x3446.2ce7.0]

Thu Jan 28 01:07:51 2010

Incremental checkpoint up to RBA [0x3446.2cf3.0], current log tail at RBA [0x3446.458f.0]

Thu Jan 28 01:38:04 2010

Incremental checkpoint up to RBA [0x3446.45a5.0], current log tail at RBA [0x3446.50eb.0]

Thu Jan 28 02:08:05 2010

Incremental checkpoint up to RBA [0x3446.510e.0], current log tail at RBA [0x3446.67ab.0]

Thu Jan 28 02:38:07 2010

Incremental checkpoint up to RBA [0x3446.67ad.0], current log tail at RBA [0x3446.72da.0]

Thu Jan 28 03:08:08 2010

Incremental checkpoint up to RBA [0x3446.7309.0], current log tail at RBA [0x3446.88b4.0]

Thu Jan 28 03:38:10 2010

Incremental checkpoint up to RBA [0x3446.88d7.0], current log tail at RBA [0x3446.932d.0]

Thu Jan 28 04:08:12 2010

Incremental checkpoint up to RBA [0x3446.9354.0], current log tail at RBA [0x3446.aa91.0]

Thu Jan 28 04:38:13 2010

Incremental checkpoint up to RBA [0x3446.ab0e.0], current log tail at RBA [0x3446.b55a.0]

Thu Jan 28 05:08:15 2010

Incremental checkpoint up to RBA [0x3446.b60d.0], current log tail at RBA [0x3446.cb31.0]

Thu Jan 28 05:38:16 2010

Incremental checkpoint up to RBA [0x3446.cb78.0], current log tail at RBA [0x3446.d6d9.0]

Thu Jan 28 06:08:42 2010

Incremental checkpoint up to RBA [0x3446.d6e9.0], current log tail at RBA [0x3446.fdb8.0]

Thu Jan 28 06:38:43 2010

Incremental checkpoint up to RBA [0x3446.fdba.0], current log tail at RBA [0x3446.130c5.0]

Thu Jan 28 07:08:45 2010

Incremental checkpoint up to RBA [0x3446.13269.0], current log tail at RBA [0x3446.16da0.0]

Thu Jan 28 07:38:46 2010

Incremental checkpoint up to RBA [0x3446.16f91.0], current log tail at RBA [0x3446.1a32b.0]

Thu Jan 28 08:08:48 2010

Incremental checkpoint up to RBA [0x3446.1a3b5.0], current log tail at RBA [0x3446.21c60.0]

Thu Jan 28 08:12:49 2010

Beginning log switch checkpoint up to RBA [0x3447.2.10], SCN: 295084667

Thread 1 advanced to log sequence 13383

Current log# 3 seq# 13383 mem# 0: /oracle/oradata/cm/redo03a.log

Current log# 3 seq# 13383 mem# 1: /u01/oracle/oradata/cm/redo03b.log

Thu Jan 28 08:23:08 2010

Beginning log switch checkpoint up to RBA [0x3448.2.10], SCN: 295163242

Thread 1 advanced to log sequence 13384

Current log# 4 seq# 13384 mem# 0: /oracle/oradata/cm/redo04a.log

Current log# 4 seq# 13384 mem# 1: /u01/oracle/oradata/cm/redo04b.log

Thu Jan 28 08:38:54 2010

Incremental checkpoint up to RBA [0x3446.21c62.0], current log tail at RBA [0x3448.254d5.0]

Thu Jan 28 08:42:55 2010

Completed checkpoint up to RBA [0x3447.2.10], SCN: 295084667

Thu Jan 28 08:53:14 2010

Completed checkpoint up to RBA [0x3448.2.10], SCN: 295163242

Thu Jan 28 09:08:55 2010

Incremental checkpoint up to RBA [0x3448.254dc.0], current log tail at RBA [0x3448.2f47b.0]

Thu Jan 28 09:14:32 2010

Beginning log switch checkpoint up to RBA [0x3449.2.10], SCN: 295232574

Thread 1 advanced to log sequence 13385

Current log# 5 seq# 13385 mem# 0: /oracle/oradata/cm/redo05a.log

Current log# 5 seq# 13385 mem# 1: /u01/oracle/oradata/cm/redo05b.log

Thu Jan 28 09:38:57 2010

Incremental checkpoint up to RBA [0x3448.2f493.0], current log tail at RBA [0x3449.dc02.0]

Thu Jan 28 09:44:36 2010

Completed checkpoint up to RBA [0x3449.2.10], SCN: 295232574

Thu Jan 28 10:08:58 2010

Incremental checkpoint up to RBA [0x3449.dc08.0], current log tail at RBA [0x3449.23648.0]

Thu Jan 28 10:11:05 2010

Beginning log switch checkpoint up to RBA [0x344a.2.10], SCN: 295270569

Thread 1 advanced to log sequence 13386

Current log# 7 seq# 13386 mem# 0: /oracle/oradata/cm/redo07a.log

Current log# 7 seq# 13386 mem# 1: /u01/oracle/oradata/cm/redo07b.log

Thu Jan 28 10:21:05 2010

Beginning log switch checkpoint up to RBA [0x344b.2.10], SCN: 295345852

Thread 1 advanced to log sequence 13387

Current log# 6 seq# 13387 mem# 0: /oracle/oradata/cm/redo06a.log

Current log# 6 seq# 13387 mem# 1: /u01/oracle/oradata/cm/redo06b.log

Thu Jan 28 10:32:28 2010

Beginning log switch checkpoint up to RBA [0x344c.2.10], SCN: 295404733

Thread 1 advanced to log sequence 13388

Current log# 8 seq# 13388 mem# 0: /oracle/oradata/cm/redo08a.log

Current log# 8 seq# 13388 mem# 1: /u01/oracle/oradata/cm/redo08b.log

Thu Jan 28 10:39:01 2010

Incremental checkpoint up to RBA [0x3449.2365a.0], current log tail at RBA [0x344c.2037b.0]

Thu Jan 28 10:41:11 2010

Completed checkpoint up to RBA [0x344a.2.10], SCN: 295270569

Thu Jan 28 10:42:36 2010

Beginning log switch checkpoint up to RBA [0x344d.2.10], SCN: 295481408

Thread 1 advanced to log sequence 13389

Current log# 10 seq# 13389 mem# 0: /oracle/oradata/cm/redo10a.log

Current log# 10 seq# 13389 mem# 1: /u01/oracle/oradata/cm/redo10b.log

Thu Jan 28 10:51:12 2010

Completed checkpoint up to RBA [0x344b.2.10], SCN: 295345852

Thu Jan 28 10:52:02 2010

Beginning log switch checkpoint up to RBA [0x344e.2.10], SCN: 295553297

Thread 1 advanced to log sequence 13390

Current log# 9 seq# 13390 mem# 0: /oracle/oradata/cm/redo09a.log

Current log# 9 seq# 13390 mem# 1: /u01/oracle/oradata/cm/redo09b.log

Thu Jan 28 11:01:38 2010

Beginning log switch checkpoint up to RBA [0x344f.2.10], SCN: 295627571

Thread 1 advanced to log sequence 13391

Current log# 11 seq# 13391 mem# 0: /oracle/oradata/cm/redo11a.log

Current log# 11 seq# 13391 mem# 1: /u01/oracle/oradata/cm/redo11b.log

Thu Jan 28 11:02:37 2010

Completed checkpoint up to RBA [0x344c.2.10], SCN: 295404733

Thu Jan 28 11:08:40 2010

Beginning log switch checkpoint up to RBA [0x3450.2.10], SCN: 295673060

Thread 1 advanced to log sequence 13392

Current log# 12 seq# 13392 mem# 0: /oracle/oradata/cm/redo12a.log

Current log# 12 seq# 13392 mem# 1: /u01/oracle/oradata/cm/redo12b.log

Thu Jan 28 11:09:06 2010

Incremental checkpoint up to RBA [0x344c.204fe.0], current log tail at RBA [0x3450.38e9.0]

Thu Jan 28 11:12:43 2010

Completed checkpoint up to RBA [0x344d.2.10], SCN: 295481408

Thu Jan 28 11:15:03 2010

Beginning log switch checkpoint up to RBA [0x3451.2.10], SCN: 295717017

Thread 1 advanced to log sequence 13393

Current log# 1 seq# 13393 mem# 0: /oracle/oradata/cm/redo01a.log

Current log# 1 seq# 13393 mem# 1: /u01/oracle/oradata/cm/redo01b.log

Thu Jan 28 11:20:02 2010

Beginning log switch checkpoint up to RBA [0x3452.2.10], SCN: 295750548

Thread 1 advanced to log sequence 13394

Current log# 2 seq# 13394 mem# 0: /oracle/oradata/cm/redo02a.log

Current log# 2 seq# 13394 mem# 1: /u01/oracle/oradata/cm/redo02b.log

Thu Jan 28 11:22:08 2010

Completed checkpoint up to RBA [0x344e.2.10], SCN: 295553297

Thu Jan 28 11:25:35 2010

Beginning log switch checkpoint up to RBA [0x3453.2.10], SCN: 295790340

Thread 1 advanced to log sequence 13395

Current log# 3 seq# 13395 mem# 0: /oracle/oradata/cm/redo03a.log

Current log# 3 seq# 13395 mem# 1: /u01/oracle/oradata/cm/redo03b.log

Thu Jan 28 11:31:15 2010

Beginning log switch checkpoint up to RBA [0x3454.2.10], SCN: 295827602

Thread 1 advanced to log sequence 13396

Current log# 4 seq# 13396 mem# 0: /oracle/oradata/cm/redo04a.log

Current log# 4 seq# 13396 mem# 1: /u01/oracle/oradata/cm/redo04b.log

Thu Jan 28 11:31:48 2010

Completed checkpoint up to RBA [0x344f.2.10], SCN: 295627571

Thu Jan 28 11:38:48 2010

Completed checkpoint up to RBA [0x3450.2.10], SCN: 295673060

Thu Jan 28 11:39:12 2010

Incremental checkpoint up to RBA [0x3450.3dd2.0], current log tail at RBA [0x3454.27cf7.0]

Thu Jan 28 11:41:20 2010

Beginning log switch checkpoint up to RBA [0x3455.2.10], SCN: 295901772

Thread 1 advanced to log sequence 13397

Current log# 5 seq# 13397 mem# 0: /oracle/oradata/cm/redo05a.log

Current log# 5 seq# 13397 mem# 1: /u01/oracle/oradata/cm/redo05b.log

Thu Jan 28 11:45:09 2010

Completed checkpoint up to RBA [0x3451.2.10], SCN: 295717017

Thu Jan 28 11:50:12 2010

Completed checkpoint up to RBA [0x3452.2.10], SCN: 295750548

Thu Jan 28 11:51:29 2010

Beginning log switch checkpoint up to RBA [0x3456.2.10], SCN: 295978080

Thread 1 advanced to log sequence 13398

Current log# 7 seq# 13398 mem# 0: /oracle/oradata/cm/redo07a.log

Current log# 7 seq# 13398 mem# 1: /u01/oracle/oradata/cm/redo07b.log

Thu Jan 28 11:55:38 2010

Completed checkpoint up to RBA [0x3453.2.10], SCN: 295790340

Thu Jan 28 12:01:23 2010

Completed checkpoint up to RBA [0x3454.2.10], SCN: 295827602

Thu Jan 28 12:01:36 2010

Beginning log switch checkpoint up to RBA [0x3457.2.10], SCN: 296052518

Thread 1 advanced to log sequence 13399

Current log# 6 seq# 13399 mem# 0: /oracle/oradata/cm/redo06a.log

Current log# 6 seq# 13399 mem# 1: /u01/oracle/oradata/cm/redo06b.log

Thu Jan 28 12:09:18 2010

Incremental checkpoint up to RBA [0x3454.282b0.0], current log tail at RBA [0x3457.26317.0]

Thu Jan 28 12:11:27 2010

Completed checkpoint up to RBA [0x3455.2.10], SCN: 295901772

Thu Jan 28 12:11:40 2010

Beginning log switch checkpoint up to RBA [0x3458.2.10], SCN: 296128592

Thread 1 advanced to log sequence 13400

Current log# 8 seq# 13400 mem# 0: /oracle/oradata/cm/redo08a.log

Current log# 8 seq# 13400 mem# 1: /u01/oracle/oradata/cm/redo08b.log

Thu Jan 28 12:21:19 2010

The value (30) of MAXTRANS parameter ignored.

kupprdp: master process DM00 started with pid=41, OS id=7908

to execute - SYS.KUPM$MCP.MAIN('BACKUP_DMPDIA', 'BACKUPDUMP', 'KUPC$C_1_20100128122120', 'KUPC$S_1_20100128122120', 0);

kupprdp: worker process DW01 started with worker id=1, pid=43, OS id=7916

to execute - SYS.KUPW$WORKER.MAIN('BACKUP_DMPDIA', 'BACKUPDUMP');

Thu Jan 28 12:21:34 2010

Completed checkpoint up to RBA [0x3456.2.10], SCN: 295978080

Thu Jan 28 12:22:10 2010

Beginning log switch checkpoint up to RBA [0x3459.2.10], SCN: 296169771

Thread 1 advanced to log sequence 13401

Current log# 10 seq# 13401 mem# 0: /oracle/oradata/cm/redo10a.log

Current log# 10 seq# 13401 mem# 1: /u01/oracle/oradata/cm/redo10b.log

Thu Jan 28 12:22:54 2010

Beginning log switch checkpoint up to RBA [0x345a.2.10], SCN: 296170377

Thread 1 advanced to log sequence 13402

Current log# 9 seq# 13402 mem# 0: /oracle/oradata/cm/redo09a.log

Current log# 9 seq# 13402 mem# 1: /u01/oracle/oradata/cm/redo09b.log

Thu Jan 28 12:23:55 2010

Beginning log switch checkpoint up to RBA [0x345b.2.10], SCN: 296171847

Thread 1 advanced to log sequence 13403

Current log# 11 seq# 13403 mem# 0: /oracle/oradata/cm/redo11a.log

Current log# 11 seq# 13403 mem# 1: /u01/oracle/oradata/cm/redo11b.log

Thu Jan 28 12:24:54 2010

Beginning log switch checkpoint up to RBA [0x345c.2.10], SCN: 296173367

Thread 1 advanced to log sequence 13404

Current log# 12 seq# 13404 mem# 0: /oracle/oradata/cm/redo12a.log

Current log# 12 seq# 13404 mem# 1: /u01/oracle/oradata/cm/redo12b.log

Thu Jan 28 12:25:52 2010

Beginning log switch checkpoint up to RBA [0x345d.2.10], SCN: 296174822

Thread 1 advanced to log sequence 13405

Current log# 1 seq# 13405 mem# 0: /oracle/oradata/cm/redo01a.log

Current log# 1 seq# 13405 mem# 1: /u01/oracle/oradata/cm/redo01b.log

Thu Jan 28 12:26:52 2010

Beginning log switch checkpoint up to RBA [0x345e.2.10], SCN: 296176131

Thread 1 advanced to log sequence 13406

Current log# 2 seq# 13406 mem# 0: /oracle/oradata/cm/redo02a.log

Current log# 2 seq# 13406 mem# 1: /u01/oracle/oradata/cm/redo02b.log

Thu Jan 28 12:27:51 2010

Beginning log switch checkpoint up to RBA [0x345f.2.10], SCN: 296177384

Thread 1 advanced to log sequence 13407

Current log# 3 seq# 13407 mem# 0: /oracle/oradata/cm/redo03a.log

Current log# 3 seq# 13407 mem# 1: /u01/oracle/oradata/cm/redo03b.log

Thu Jan 28 12:28:52 2010

Beginning log switch checkpoint up to RBA [0x3460.2.10], SCN: 296178671

Thread 1 advanced to log sequence 13408

Current log# 4 seq# 13408 mem# 0: /oracle/oradata/cm/redo04a.log

Current log# 4 seq# 13408 mem# 1: /u01/oracle/oradata/cm/redo04b.log

Thu Jan 28 12:30:05 2010

Completed checkpoint up to RBA [0x3457.2.10], SCN: 296052518

Thu Jan 28 12:30:08 2010

Beginning log switch checkpoint up to RBA [0x3461.2.10], SCN: 296180003

Thread 1 advanced to log sequence 13409

Current log# 5 seq# 13409 mem# 0: /oracle/oradata/cm/redo05a.log

Current log# 5 seq# 13409 mem# 1: /u01/oracle/oradata/cm/redo05b.log

Thu Jan 28 12:34:00 2010

Completed checkpoint up to RBA [0x3458.2.10], SCN: 296128592

Thu Jan 28 12:34:04 2010

Beginning log switch checkpoint up to RBA [0x3462.2.10], SCN: 296182292

Thread 1 advanced to log sequence 13410

Current log# 7 seq# 13410 mem# 0: /oracle/oradata/cm/redo07a.log

Current log# 7 seq# 13410 mem# 1: /u01/oracle/oradata/cm/redo07b.log

Thu Jan 28 12:35:05 2010

Completed checkpoint up to RBA [0x3459.2.10], SCN: 296169771

Thu Jan 28 12:35:11 2010

Beginning log switch checkpoint up to RBA [0x3463.2.10], SCN: 296183666

Thread 1 advanced to log sequence 13411

Current log# 6 seq# 13411 mem# 0: /oracle/oradata/cm/redo06a.log

Current log# 6 seq# 13411 mem# 1: /u01/oracle/oradata/cm/redo06b.log

Thu Jan 28 12:40:06 2010

Incremental checkpoint up to RBA [0x3459.72a8.0], current log tail at RBA [0x3463.40e2.0]

Thu Jan 28 12:52:03 2010

Errors in file /oracle/admin/cm/udump/cm_ora_15145.trc:

ORA-07445: exception encountered: core dump [opidsa()+386] [sIGSEGV] [Address not mapped to object] [0x000000000] [] []

Thu Jan 28 12:52:13 2010

Errors in file /oracle/admin/cm/udump/cm_ora_15227.trc:

ORA-07445: exception encountered: core dump [opidsa()+386] [sIGSEGV] [Address not mapped to object] [0x000000000] [] []

Thu Jan 28 12:53:11 2010

Errors in file /oracle/admin/cm/udump/cm_ora_15351.trc:

ORA-07445: exception encountered: core dump [opidsa()+386] [sIGSEGV] [Address not mapped to object] [0x000000000] [] []

Thu Jan 28 12:54:46 2010

Completed checkpoint up to RBA [0x345a.2.10], SCN: 296170377

Thu Jan 28 12:55:04 2010

Errors in file /oracle/admin/cm/udump/cm_ora_15630.trc:

ORA-07445: exception encountered: core dump [opidsa()+386] [sIGSEGV] [Address not mapped to object] [0x000000000] [] []

Thu Jan 28 12:55:48 2010

Completed checkpoint up to RBA [0x345b.2.10], SCN: 296171847

Thu Jan 28 12:56:46 2010

Completed checkpoint up to RBA [0x345c.2.10], SCN: 296173367

Thu Jan 28 12:57:46 2010

Completed checkpoint up to RBA [0x345d.2.10], SCN: 296174822

Thu Jan 28 12:58:14 2010

Errors in file /oracle/admin/cm/udump/cm_ora_16456.trc:

ORA-07445: exception encountered: core dump [opidsa()+386] [sIGSEGV] [Address not mapped to object] [0x000000000] [] []

Thu Jan 28 12:58:46 2010

Completed checkpoint up to RBA [0x345e.2.10], SCN: 296176131

Thu Jan 28 12:59:07 2010

Errors in file /oracle/admin/cm/udump/cm_ora_16584.trc:

ORA-07445: exception encountered: core dump [opidsa()+386] [sIGSEGV] [Address not mapped to object] [0x000000000] [] []

Thu Jan 28 12:59:41 2010

Errors in file /oracle/admin/cm/udump/cm_ora_16876.trc:

ORA-07445: exception encountered: core dump [opidsa()+386] [sIGSEGV] [Address not mapped to object] [0x000000000] [] []

Thu Jan 28 12:59:44 2010

Completed checkpoint up to RBA [0x345f.2.10], SCN: 296177384

Thu Jan 28 13:00:45 2010

Completed checkpoint up to RBA [0x3460.2.10], SCN: 296178671

Thu Jan 28 13:01:02 2010

Errors in file /oracle/admin/cm/udump/cm_ora_17092.trc:

ORA-07445: exception encountered: core dump [opidsa()+386] [sIGSEGV] [Address not mapped to object] [0x000000000] [] []

Thu Jan 28 13:01:58 2010

Completed checkpoint up to RBA [0x3461.2.10], SCN: 296180003

Thu Jan 28 13:05:58 2010

Completed checkpoint up to RBA [0x3462.2.10], SCN: 296182292

Thu Jan 28 13:07:04 2010

Completed checkpoint up to RBA [0x3463.2.10], SCN: 296183666

Thu Jan 28 13:11:11 2010

Incremental checkpoint up to RBA [0x3463.41dd.0], current log tail at RBA [0x3463.1f206.0]

Thu Jan 28 13:14:48 2010

Errors in file /oracle/admin/cm/udump/cm_ora_21972.trc:

ORA-07445: exception encountered: core dump [opidsa()+386] [sIGSEGV] [Address not mapped to object] [0x000000000] [] []

Thu Jan 28 13:16:48 2010

Errors in file /oracle/admin/cm/udump/cm_ora_22513.trc:

ORA-07445: exception encountered: core dump [opidsa()+386] [sIGSEGV] [Address not mapped to object] [0x000000000] [] []

Thu Jan 28 13:18:14 2010

Errors in file /oracle/admin/cm/udump/cm_ora_22897.trc:

ORA-07445: exception encountered: core dump [opidsa()+386] [sIGSEGV] [Address not mapped to object] [0x000000000] [] []

Thu Jan 28 13:19:25 2010

Errors in file /oracle/admin/cm/udump/cm_ora_23056.trc:

ORA-07445: exception encountered: core dump [opidsa()+386] [sIGSEGV] [Address not mapped to object] [0x000000000] [] []

Thu Jan 28 13:20:14 2010

Errors in file /oracle/admin/cm/udump/cm_ora_23159.trc:

ORA-07445: exception encountered: core dump [opidsa()+386] [sIGSEGV] [Address not mapped to object] [0x000000000] [] []

Thu Jan 28 13:22:56 2010

[Motta 645]

Em que condições ocorre o erro ?

 

Uma vez tomei um erro destes e era um erro numa das triggers disparadas num update.

[alphamek 2]

Olá,

 

Erros ORA-7445 é igual aos ORA-600, são erros internos do Oracle provocados por um processo onde o kernel não o tratou, como se fosse uma exception no PL/SQL, problemas de hardware ou arquivos do banco de dados. São muitas variaveis.

 

Mas para melhorar, posta o contéudo desse arquivo:

 

/oracle/admin/cm/udump/cm_ora_23056.trc

 

E vamos saber o que pode estar provocando isso.

 

Isso está com cara que está com problemas no banco de dados, precisamente no momento do CHECKPOINT, porém, precisa de mais analise.

 

Abraços,

[alvesbru 0]

Olá,

 

Erros ORA-7445 é igual aos ORA-600, são erros internos do Oracle provocados por um processo onde o kernel não o tratou, como se fosse uma exception no PL/SQL, problemas de hardware ou arquivos do banco de dados. São muitas variaveis.

 

Mas para melhorar, posta o contéudo desse arquivo:

 

/oracle/admin/cm/udump/cm_ora_23056.trc

 

E vamos saber o que pode estar provocando isso.

 

Isso está com cara que está com problemas no banco de dados, precisamente no momento do CHECKPOINT, porém, precisa de mais analise.

 

Abraços,

 

O erro ocorre em um aplicação que atualiza tabelas do ERP, engraçado que o ERP continua funcionando perfeitamente, apenas este aplicativo que não funciona mais. A solução no momento é parar o banco e reinicia-lo.

 

Alphamek, vou pegar o conteudo do trace referido no seu post.

 

Grato,

 

Bruno.