In addition to Weibo, there is also WeChat
Please pay attention
WeChat public account
Shulou
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.
Continue with the installation of the previous hadoop.First, install zookooper1. Decompress zookoope
"Every 5-10 years, there's a rare product, a really special, very unusual product that's the most un
© 2024 shulou.com SLNews company. All rights reserved.