Tuesday, March 01, 2011

ORA-07445: [kttuser0()+293]

After imported METADATA from 10.2 to 11.2... I found "INVALID" status on objects, then used "utlrp.sql" script:
SQL> @?/rdbms/admin/utlrp.sql
< lost connection >
In alert log file:
Tue Mar 01 14:19:49 2011
SERVER COMPONENT id=UTLRP_BGN: timestamp=2011-03-01 14:19:49
Exception [type: SIGFPE, Integer divide by zero] [ADDR:0x105A9E9] [PC:0x105A9E9, kttuser0()+293] [flags: 0x0, count: 1]
Errors in file /u01/app/oracle/diag/rdbms/orcl/orcl1/trace/orcl1_ora_21584.trc (incident=57595):
ORA-07445: exception encountered: core dump [kttuser0()+293] [SIGFPE] [ADDR:0x105A9E9] [PC:0x105A9E9] [Integer divide by zero] []
Incident details in: /u01/app/oracle/diag/rdbms/orcl/orcl1/incident/incdir_57595/orcl1_ora_21584_i57595.trc
Use ADRCI or Support Workbench to package the incident.
See Note 411.1 at My Oracle Support for error and packaging details.
Tue Mar 01 14:19:54 2011
Dumping diagnostic data in directory=[cdmp_20110301141954], requested by (instance=1, osid=21584), summary=[incident=57595].
Tue Mar 01 14:19:54 2011
Sweep [inc][57595]: completed
Sweep [inc2][57595]: completed

Reviewed objects was become "INVALID" status and saw some views (INVALID) on SYS schema:
select object_type, owner, object_name from dba_objects where status='INVALID';
SYS."_ALL_REPCOLUMN_GROUP"
SYS."_ALL_REPRESOLUTION"
SYS."_ALL_REPPARAMETER_COLUMN"
SYS."_ALL_REPCONFLICT"

then recompiled objects + (views on SYS schema) by manual:
SQL> alter VIEW SYS."_ALL_REPCOLUMN_GROUP" compile;

View altered.

SQL> alter VIEW SYS."_ALL_REPRESOLUTION" compile;

View altered.

SQL> alter VIEW SYS."_ALL_REPPARAMETER_COLUMN" compile;

View altered.

SQL> alter VIEW SYS."_ALL_REPCONFLICT" compile;

View altered.
then used "utlrp.sql" again
SQL> @?/rdbms/admin/utlrp.sql
< DONE + NO ERROR >
Not see specific Idea on My Oracle Support, maybe this issue depended on "INVALID" status on SYS schema.

How do you think?

Then I still found error:
SQL> explain plan for select * from tb_hd;
explain plan for select * from tb_hd
*
ERROR at line 1:
ORA-03113: end-of-file on communication channel
Process ID: 7352
Session ID: 134 Serial number: 1537
In alert log file:
Exception [type: SIGFPE, Integer divide by zero] [ADDR:0x105A9E9] [PC:0x105A9E9, kttuser0()+293] [flags: 0x0, count: 1]
Errors in file /u01/app/oracle/diag/rdbms/orcl/orcl1/trace/orcl1_ora_7352.trc (incident=57940):
ORA-07445: exception encountered: core dump [kttuser0()+293] [SIGFPE] [ADDR:0x105A9E9] [PC:0x105A9E9] [Integer divide by zero] []
Incident details in: /u01/app/oracle/diag/rdbms/orcl/orcl1/incident/incdir_57940/orcl1_ora_7352_i57940.trc
Use ADRCI or Support Workbench to package the incident.
See Note 411.1 at My Oracle Support for error and packaging details.
Tue Mar 01 16:59:43 2011
Dumping diagnostic data in directory=[cdmp_20110301165943], requested by (instance=1, osid=7352), summary=[incident=57940].

So, investigated and found on 10.2 Database, that uses "Temporary Tablespace Groups", then on 11.2 Database - I ...
ALTER TABLESPACE TEMP TABLESPACE GROUP ...

This issue, because Temporary tablespace default was changed to "TEMP TABLESPACE GROUP" ... and no temporary tablespace in it.
Idea:
- check default temporary tablespace in Database (11.2)
- fix it.

2 comments:

Anonymous said...

Had the exact same issue, couldn't find the answer on metalink. This fixed it!! Thank you

Surachart Opun said...

sound good.

Maybe, we need to know between oracle default and something what dba changed.
:)