Network Security Internet Technology Development Database Servers Mobile Phone Android Software Apple Software Computer Software News IT Information

In addition to Weibo, there is also WeChat

Please pay attention

WeChat public account

Shulou

Upgrade the new bugORACLE ORA-07445 caused by psu

2025-04-05 Update From: SLTechnology News&Howtos shulou NAV: SLTechnology News&Howtos > Database >

Share

Shulou(Shulou.com)06/01 Report--

Recently, customers have been patching 10.2.0.5.19 PSU, running @ catbundle.sql psuapply and reporting ORA-07445:exception encountered: core dump [joet _ create_root_thread_group () + 140] [SIGSEGV] [Address not mapped to object] [0x000000008] [] [] error. Makes it impossible for the upgrade to proceed.

View the relevant documents and display only the following information:

There is no other solution but to back up the database to try the above scheme, but also encounter the above error in the logical backup. You have no choice but to use rman for backup.

According to the document 1940340.1, it may be that the application of PSU is caused by oracle buf.

Follow the steps as follows:

Create pfile='/home/oracle/pfie.ora' fromspfile;\

SQL > alter system set java_jit_enabled = FALSE;-10g is not required

SQL > alter system set "_ system_trig_enabled" = FALSE;

SQL > alter system setJOB_QUEUE_PROCESSES=0

SQL > startup restrict

SQL > @ catbundle.sql psu apply-restore parameters after running

SQL > alter system set "_ system_trig_enabled" = TRUE

SQL > alter system setJOB_QUEUE_PROCESSES=10

Restart the database.

The above scheme is for direct reference.

Refer to 1940340.1 documentation

The document information is as follows:

In this Document

Symptoms

Changes

Cause

Solution

ReferencesAPPLIES TO:

Oracle Database-Enterprise Edition-Version 11.2.0.3 to 11.2.0.3 [Release 11.2]

Information in this document applies to any platform.

SYMPTOMS

ORA-07445: exception encountered: core dump [joet_create_root_thread_group () + 145] is seen at startup.

The issue happens in CDC environments and the following statement is seen in the alert log:

-Current SQL Statement for this session (sql_id=f03bykh7st1m5)-

BEGIN

/ * NOP UNLESS A TABLE OBJECT * /

IF dictionary_obj_type = 'TABLE'

THEN

Sys.dbms_cdc_ipublish.change_table_trigger (dictionary_obj_owner,dictionary_obj_name,sysevent)

END IF

END

-PL/SQL Stack-

-PL/SQL Call Stack-

Object line object

Handle number name

0xa7dd71c0 12 package body SYS.DBMS_CDC_IPUBLISH

The error can also be seen from MMON_SLAVE with an action of: JAVAVM JIT slave action without any SQL statement referenced.

The call stack is:

Joet_create_root_th

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.

Views: 0

*The comments in the above article only represent the author's personal views and do not represent the views and positions of this website. If you have more insights, please feel free to contribute and share.

Share To

Database

Wechat

© 2024 shulou.com SLNews company. All rights reserved.

12
Report