datapump 匯出匯入ORA-07445

darren__chan發表於2020-08-18

沒有規範整理，比較亂，僅作為筆記備忘！

Archived Log entry 52860 added for thread 1 sequence 52864 ID 0x453c1294 dest 1:

Wed Aug 12 19:27:25 2020
DM00 started with pid=628, OS id=46554, job SYS.SYS_EXPORT_SCHEMA_01
Wed Aug 12 19:27:50 2020
DM00 started with pid=438, OS id=46834, job SYS.SYS_EXPORT_SCHEMA_01
Wed Aug 12 19:27:51 2020
DW00 started with pid=529, OS id=46836, wid=1, job SYS.SYS_EXPORT_SCHEMA_01
Exception [type: SIGSEGV, Address not mapped to object] [ADDR:0x18] [PC:0x98DA0A7, hshuid()+273] [flags: 0x0, count: 1]
Errors in file /oracle/app/oracle/diag/rdbms/basedb1/BASEDB1/trace/BASEDB1_dw00_46836.trc  (incident=144634):
ORA-07445: exception encountered: core dump [hshuid()+273] [SIGSEGV] [ADDR:0x18] [PC:0x98DA0A7] [Address not mapped to object] []
Incident details in: /oracle/app/oracle/diag/rdbms/basedb1/BASEDB1/incident/incdir_144634/BASEDB1_dw00_46836_i144634.trc
Use ADRCI or Support Workbench to package the incident.
See Note 411.1 at My Oracle Support for error and packaging details.
Wed Aug 12 19:27:55 2020
Dumping diagnostic data in directory=[cdmp_20200812192755], requested by (instance=1, osid=46836 (DW00)), summary=[incident=144634].
Wed Aug 12 19:27:57 2020
Sweep [inc][144634]: completed
Sweep [inc2][144634]: completed
Wed Aug 12 19:30:42 2020
DM00 started with pid=627, OS id=48732, job SYS.SYS_EXPORT_SCHEMA_02
Wed Aug 12 19:30:54 2020
DM00 started with pid=529, OS id=48766, job SYS.SYS_EXPORT_SCHEMA_02
Wed Aug 12 19:30:55 2020
DW00 started with pid=627, OS id=48769, wid=1, job SYS.SYS_EXPORT_SCHEMA_02
Exception [type: SIGSEGV, Address not mapped to object] [ADDR:0x18] [PC:0x98DA0A7, hshuid()+273] [flags: 0x0, count: 1]
Errors in file /oracle/app/oracle/diag/rdbms/basedb1/BASEDB1/trace/BASEDB1_dw00_48769.trc  (incident=145418):
ORA-07445: exception encountered: core dump [hshuid()+273] [SIGSEGV] [ADDR:0x18] [PC:0x98DA0A7] [Address not mapped to object] []
Incident details in: /oracle/app/oracle/diag/rdbms/basedb1/BASEDB1/incident/incdir_145418/BASEDB1_dw00_48769_i145418.trc
Use ADRCI or Support Workbench to package the incident.
See Note 411.1 at My Oracle Support for error and packaging details.
Wed Aug 12 19:30:59 2020
Dumping diagnostic data in directory=[cdmp_20200812193059], requested by (instance=1, osid=48769 (DW00)), summary=[incident=145418].
Wed Aug 12 19:31:01 2020
Sweep [inc][145418]: completed
*** 2020-08-12 19:39:21.103
*** SESSION ID:(76.3245) 2020-08-12 19:39:21.103
*** CLIENT ID:() 2020-08-12 19:39:21.103
*** SERVICE NAME:(SYS$USERS) 2020-08-12 19:39:21.103
*** MODULE NAME:(SQL Developer) 2020-08-12 19:39:21.103
*** ACTION NAME:() 2020-08-12 19:39:21.103
Dump continued from file: /oracle/app/oracle/diag/rdbms/basedb1/BASEDB1/trace/BASEDB1_ora_45454.trc
ORA-07445: exception encountered: core dump [hshget1()+183] [SIGSEGV] [ADDR:0x18] [PC:0x98D9B9B] [Address not mapped to object] []
========= Dump for incident 145394 (ORA 7445 [hshget1()+183]) ========
----- Beginning of Customized Incident Dump(s) -----
Exception [type: SIGSEGV, Address not mapped to object] [ADDR:0x18] [PC:0x98D9B9B, hshget1()+183] [flags: 0x0, count: 1]
Registers:
%rax: 0x00000006072d06d0 %rbx: 0x00007fffcc6b3ea0 %rcx: 0x0000000000000000
%rdx: 0x000000009fe029e8 %rdi: 0x00000000b5f61930 %rsi: 0x00007f58d3786486
%rsp: 0x00007fffcc6b3b50 %rbp: 0x00007fffcc6b3bc0  %r8: 0x000000009fe02818
%r9: 0x0000000000000000 %r10: 0x0000000000000001 %r11: 0x000000000499bd1a
%r12: 0x0000000000000001 %r13: 0x0000000000000001 %r14: 0x00000006072d06d0
%r15: 0x0000000000000000 %rip: 0x00000000098d9b9b %efl: 0x0000000000010246
hshget1()+168 (0x98d9b8c) mov 0x8(%rdi),%r8
hshget1()+172 (0x98d9b90) mov 0x48(%r8),%rdx
hshget1()+176 (0x98d9b94) mov -0x18(%rbp),%rsi
hshget1()+180 (0x98d9b98) mov (%rdx),%rcx
> hshget1()+183 (0x98d9b9b) mov 0x18(%rcx),%edx
hshget1()+186 (0x98d9b9e) mov %rcx,-0x50(%rbp)
hshget1()+190 (0x98d9ba2) mov %rbx,%rdi
hshget1()+193 (0x98d9ba5) call 0x99055c8
hshget1()+198 (0x98d9baa) mov -0x50(%rbp),%rdx
*** 2020-08-12 19:39:21.107
dbkedDefDump(): Starting a non-incident diagnostic dump (flags=0x3, level=3, mask=0x0)
----- Current SQL Statement for this session (sql_id=gqj5gaygdbfs5) -----
SELECT dbms_transaction.local_transaction_id FROM dual
----- Call Stack Trace -----
calling              call     entry                argument values in hex
location             type     point                (? means dubious value)
-------------------- -------- -------------------- ----------------------------
skdstdst()+41        call     kgdsdst()            000000000 ? 000000000 ?
7F58D3A4E500 ? 7F58D3A4E5D8 ?
7F58D3A53080 ? 000000003 ?
ksedst1()+103        call     skdstdst()           000000000 ? 000000000 ?
7F58D3A4E500 ? 7F58D3A4E5D8 ?
7F58D3A53080 ? 000000003 ?
ksedst()+39          call     ksedst1()            000000001 ? 000000001 ?
7F58D3A4E500 ? 7F58D3A4E5D8 ?
7F58D3A53080 ? 000000003 ?
dbkedDefDump()+2746  call     ksedst()             000000001 ? 000000001 ?
7F58D3A4E500 ? 7F58D3A4E5D8 ?
7F58D3A53080 ? 000000003 ?
ksedmp()+41          call     dbkedDefDump()       000000003 ? 000000003 ?
7F58D3A4E500 ? 7F58D3A4E5D8 ?
7F58D3A53080 ? 000000003 ?

ssexhd()+2462        call     ksedmp()             000000003 ? 000000003 ?




Wed Aug 12 22:15:50 2020
DM00 started with pid=34, OS id=128122, job CBSBASESIT.SYS_IMPORT_SCHEMA_01
Wed Aug 12 22:15:50 2020
DW00 started with pid=36, OS id=128124, wid=1, job CBSBASESIT.SYS_IMPORT_SCHEMA_01
Exception [type: SIGSEGV, Address not mapped to object] [ADDR:0x0] [PC:0x37C3178, pfrins()+216] [flags: 0x0, count: 1]
Errors in file /oracle/app/oracle/diag/rdbms/basedb1/BASEDB1/trace/BASEDB1_dw00_128124.trc  (incident=140690):
ORA-07445: exception encountered: core dump [pfrins()+216] [SIGSEGV] [ADDR:0x0] [PC:0x37C3178] [Address not mapped to object] []
Incident details in: /oracle/app/oracle/diag/rdbms/basedb1/BASEDB1/incident/incdir_140690/BASEDB1_dw00_128124_i140690.trc
Use ADRCI or Support Workbench to package the incident.
See Note 411.1 at My Oracle Support for error and packaging details.
Wed Aug 12 22:15:52 2020
Dumping diagnostic data in directory=[cdmp_20200812221552], requested by (instance=1, osid=128124 (DW00)), summary=[incident=140690].
Wed Aug 12 22:15:54 2020
Sweep [inc][140690]: completed
Sweep [inc2][140690]: completed
---------------------------------------------------------------- ---------- ---------- ------------------------------ ------------------------------------------------ -------------
db file sequential read                                                   1       8247 SYS                            sqlplus@mcb01odbsit02.mcbuat.com (TNS V1-V3)     1h50ks4ncswfn
SQL> /
EVENT                                                                    P1         P2 USERNAME                       PROGRAM                                          SQL_ID
---------------------------------------------------------------- ---------- ---------- ------------------------------ ------------------------------------------------ -------------
db file sequential read                                                   1       8247 SYS                            sqlplus@mcb01odbsit02.mcbuat.com (TNS V1-V3)     1h50ks4ncswfn
select owner,segment_name,segment_type,file_id,block_id from dba_extents where file_id=1 and 8247 between block_id and block_id+blocks-1;
OWNER                          SEGMENT_NAME                                                                      SEGMENT_TYPE          FILE_ID   BLOCK_ID
------------------------------ --------------------------------------------------------------------------------- ------------------ ---------- ----------
SYS                            IDL_UB2$                                                                          TABLE                       1       8240
select /*+ index(idl_ub2$ i_idl_ub21) +*/ piece#,length,piece from idl_ub2$ where obj#=:1 and part=:2 and version=:3 order by piece#
=====================
PARSING IN CURSOR #140542381559544 len=132 dep=2 uid=0 oct=3 lid=0 tim=1597244566920482 hv=1684122946 ad='65b666d68' sqlid='39m4sx9k63ba2'
select /*+ index(idl_ub2$ i_idl_ub21) +*/ piece#,length,piece from idl_ub2$ where obj#=1310 and part=0 and version=184549376 order by piece#;
END OF STMT
PARSE #140542381559544:c=19,e=18,p=0,cr=0,cu=0,mis=0,r=0,dep=2,og=4,plh=2317816222,tim=1597244566920481
BINDS #140542381559544:
Bind#0
oacdty=02 mxl=22(22) mxlc=00 mal=00 scl=00 pre=00
oacflg=08 fl2=0001 frm=00 csi=00 siz=24 off=0
kxsbbbfp=7fd292ba68f0  bln=22  avl=03  flg=05
value=1310
Bind#1
oacdty=02 mxl=22(22) mxlc=00 mal=00 scl=00 pre=00
oacflg=08 fl2=0001 frm=00 csi=00 siz=24 off=0
kxsbbbfp=7fd292ba68c0  bln=24  avl=01  flg=05
value=0
Bind#2
oacdty=02 mxl=22(22) mxlc=00 mal=00 scl=00 pre=00
oacflg=08 fl2=0001 frm=00 csi=00 siz=24 off=0
kxsbbbfp=7fd292ba6890  bln=24  avl=06  flg=05
value=184549376
select /*+ index(idl_ub2$ i_idl_ub21) +*/ piece#,length,piece from idl_ub2$ where obj#=1310 and part=0 and version=184549376 order by piece#;
Usage: pstack <process-id>
[oracle@mcb01odbsit02 trace]$ top
top - 23:08:43 up 40 min,  2 users,  load average: 1.02, 1.03, 0.96
Tasks: 317 total,   3 running, 314 sleeping,   0 stopped,   0 zombie
%Cpu(s): 26.5 us,  1.1 sy,  0.0 ni, 72.3 id,  0.1 wa,  0.0 hi,  0.1 si,  0.0 st
KiB Mem : 65791980 total, 62304264 free,   977328 used,  2510388 buff/cache
KiB Swap: 67108860 total, 67108860 free,        0 used. 62840592 avail Mem
PID USER      PR  NI    VIRT    RES    SHR S  %CPU %MEM     TIME+ COMMAND
5462 oracle    20   0   24.3g 107544  88096 R  99.3  0.2   5:56.72 oracle
5738 oracle    20   0   24.2g  20276  17832 S   1.7  0.0   0:03.67 oracle
5774 oracle    20   0   24.2g  23464  20832 S   1.7  0.0   0:03.30 oracle
5906 oracle    20   0   24.2g  20264  17816 S   1.7  0.0   0:01.67 oracle
5908 oracle    20   0   24.2g  38464  36016 S   1.7  0.1   0:00.69 oracle
5656 oracle    20   0   24.2g  20252  17804 S   1.3  0.0   0:04.66 oracle
5791 oracle    20   0   24.2g  34288  30840 S   1.3  0.1   0:02.72 oracle
6036 oracle    20   0   24.2g  20484  18040 S   1.3  0.0   0:00.29 oracle
5414 oracle    -2   0   24.2g  13544  11388 S   0.7  0.0   0:04.04 oracle
1363 root      20   0  223620  10828   6424 S   0.3  0.0   0:01.44 snmpd
2031 gdm       20   0  721184  11308   7204 S   0.3  0.0   0:00.66 gsd-smartcard
5424 oracle    20   0   24.2g  43140  36320 S   0.3  0.1   0:00.81 oracle
1 root      20   0  193772   6908   4168 S   0.0  0.0   0:02.39 systemd
2 root      20   0       0      0      0 S   0.0  0.0   0:00.00 kthreadd
3 root      20   0       0      0      0 S   0.0  0.0   0:00.00 ksoftirqd/0
5 root       0 -20       0      0      0 S   0.0  0.0   0:00.00 kworker/0:0H
7 root      rt   0       0      0      0 S   0.0  0.0   0:00.00 migration/0
8 root      20   0       0      0      0 S   0.0  0.0   0:00.00 rcu_bh
9 root      20   0       0      0      0 R   0.0  0.0   0:00.33 rcu_sched
10 root       0 -20       0      0      0 S   0.0  0.0   0:00.00 lru-add-drain
11 root      rt   0       0      0      0 S   0.0  0.0   0:00.00 watchdog/0
12 root      rt   0       0      0      0 S   0.0  0.0   0:00.00 watchdog/1
13 root      rt   0       0      0      0 S   0.0  0.0   0:00.00 migration/1
14 root      20   0       0      0      0 S   0.0  0.0   0:00.00 ksoftirqd/1
16 root       0 -20       0      0      0 S   0.0  0.0   0:00.00 kworker/1:0H
17 root      rt   0       0      0      0 S   0.0  0.0   0:00.00 watchdog/2
18 root      rt   0       0      0      0 S   0.0  0.0   0:00.00 migration/2
19 root      20   0       0      0      0 S   0.0  0.0   0:00.00 ksoftirqd/2
21 root       0 -20       0      0      0 S   0.0  0.0   0:00.00 kworker/2:0H
22 root      rt   0       0      0      0 S   0.0  0.0   0:00.00 watchdog/3
23 root      rt   0       0      0      0 S   0.0  0.0   0:00.00 migration/3
24 root      20   0       0      0      0 S   0.0  0.0   0:00.00 ksoftirqd/3
26 root       0 -20       0      0      0 S   0.0  0.0   0:00.00 kworker/3:0H
28 root      20   0       0      0      0 S   0.0  0.0   0:00.00 kdevtmpfs
29 root       0 -20       0      0      0 S   0.0  0.0   0:00.00 netns
30 root      20   0       0      0      0 S   0.0  0.0   0:00.00 khungtaskd
31 root       0 -20       0      0      0 S   0.0  0.0   0:00.00 writeback
[oracle@mcb01odbsit02 trace]$ pstack 5462
#0  0x000000000974e238 in lxoCpChar ()
#1  0x0000000009865cc1 in kpgdcd ()
#2  0x00000000038f0db6 in pkrdi ()
#3  0x00000000038a1f04 in pkilod ()
#4  0x0000000003027f45 in kkxlod ()
#5  0x0000000001c173f0 in kqlplslod ()
#6  0x0000000009613265 in kqllod ()
#7  0x000000000982d2eb in kglobld ()
#8  0x000000000982cb58 in kglobpn ()
#9  0x00000000098231d2 in kglpim ()
#10 0x0000000009821293 in kglpin ()
#11 0x000000000981d1a5 in kglgob ()
#12 0x000000000981c75b in kgldpo0 ()
#13 0x000000000981c3f5 in kgldpo ()
#14 0x000000000981c067 in kgldon ()
#15 0x00000000038a5476 in pkls ()
#16 0x00000000037da211 in phpcas ()
#17 0x00000000038a18bf in pkiedt ()
#18 0x0000000003027f70 in kkxlod ()
#19 0x0000000001c174db in kqlplslod ()
#20 0x0000000009613265 in kqllod ()
#21 0x000000000982d2eb in kglobld ()
#22 0x000000000982cb58 in kglobpn ()
#23 0x00000000098231d2 in kglpim ()
#24 0x0000000009821293 in kglpin ()
#25 0x000000000981d1a5 in kglgob ()
#26 0x00000000030238ea in kkxloadia ()
#27 0x00000000030236a5 in kkxffc ()
#28 0x0000000001a68326 in kkmpls ()
#29 0x0000000002e2f3b7 in qcsRslvPLSQLInvoc1 ()
#30 0x0000000002e2ef3f in qcsRslvPLSQLInvoc ()
#31 0x000000000981100a in qcsRslvName ()
#32 0x000000000980b95d in qcsridn ()
#33 0x000000000980b89f in qcsraic ()
#34 0x000000000980a53f in qcspqbDescendents ()
#35 0x0000000002e258e8 in qcspqb ()
#36 0x0000000001a722a8 in kkmdrv ()
#37 0x00000000025ab712 in opiSem ()
#38 0x00000000025b15e0 in opiDeferredSem ()
#39 0x00000000025a45fa in opitca ()
#40 0x0000000001eb90a7 in kksFullTypeCheck ()
#41 0x00000000096873ce in rpiswu2 ()
#42 0x0000000001ebab90 in kksSetBindType ()
#43 0x000000000962e43d in kksfbc ()
#44 0x00000000095ac8be in opiexe ()
#45 0x00000000095a6c40 in opiall0 ()
#46 0x00000000095b6748 in opikpr ()
#47 0x00000000095a8761 in opiodr ()
#48 0x000000000968549f in rpidrus ()
#49 0x00000000097f558c in skgmstack ()
#50 0x0000000009686f90 in rpiswu2 ()
#51 0x000000000968e714 in kprball ()
#52 0x0000000001186048 in kwqmnpartition ()
#53 0x0000000001185535 in kwqmnrepar ()
#54 0x00000000019cafec in adbdrv ()
#55 0x00000000095b08c8 in opiexe ()
#56 0x0000000009733fec in opiosq0 ()
#57 0x0000000001b93b5a in kpooprx ()
#58 0x0000000001b91e5e in kpoal8 ()
#59 0x00000000095a8761 in opiodr ()
#60 0x0000000009792c53 in ttcpip ()
#61 0x00000000018510d6 in opitsk ()
#62 0x0000000001855bfd in opiino ()
#63 0x00000000095a8761 in opiodr ()
#64 0x000000000184d174 in opidrv ()
#65 0x0000000001e26e57 in sou2o ()
#66 0x0000000000a15c2d in opimai_real ()
#67 0x0000000001e2d175 in ssthrdmain ()
#68 0x0000000000a15b99 in main ()
SQL> select /*+ index(idl_ub2$ i_idl_ub21) +*/ piece#,length,piece from idl_ub2$ where obj#=1310 and part=0 and version=184549376 order by piece#;
ERROR:
ORA-00932: inconsistent datatypes: expected CHAR got UB2
no rows selected
CAUSE
The views ending or containing $ or starting with "ORA" are typically reserved for Oracle internal operations and were never meant for external or public access.
SOLUTION
Please don't utilize these views containing $ in the name.  For more information, you may reference:
Bug 173019
During Upgrade, Recompile Of Standard Package Errors With Ora-7445 [HSHUID()+512] And Ora-7445 (Doc ID 351225.1)
Bug:2602266 : ORA-7445 [HSHUID()+512] CREATING/COMPILING THE STANDARD PACKAGE
The Diana p-code (library unit) stored in idl_sb4$ has an invalid ID. Any operation to drop/
recreate the package will always instantiate this library unit.
Conditions to identify cause:
- the ORA-7445 [hshuid()+512] [SIGSEGV] [Address not mapped to object] [24] [] [] with arguments matches Bug:2602266
Truncate the idl_ tables, then run the catalog.sql and catproc.sql scripts to recreate the SYS/SYSTEM objects including STANDARD.  Then rebuild the database:
1. Take a backup of the database
2. Log into sqlplus as SYS and do the following:
SQL> truncate table idl_ub1$;
SQL> truncate table idl_char$;
SQL> truncate table idl_ub2$;
SQL> truncate table idl_sb4$;
SQL> alter system flush shared_pool;
SQL> @?/rdbms/admin/catalog
SQL> @?/rdbms/admin/catproc
以上兩個指令碼執行報錯，ORA-04023: Object SYS.STANDARD Could Not Be Validated or Authorized
SQL> @?/rdbms/admin/utlrp
正確方式，解決方法在startup upgrade下執行
4) Invalidate all PL/SQL source:
SQL> @?/rdbms/admin/utlirp
5) Restart database in restricted mode:
SQL> shutdown immediate
SQL> startup restrict
6) Run utlrp.sql to recompile all code:
SQL> @?/rdbms/admin/utlrp
7) Restart and open in normal mode:
SQL> shutdown immediate
SQL> startup
3. Drop and create the java system followed by reload of user classes
The above steps can resolve the error, however, the steps above require modification of data dictionary tables.  Therefore, Oracle recommends a rebuild of the database using a logical export / copy after performing the steps above because modification of data dictionary tables is not supported.


來自 “ ITPUB部落格 ” ，連結：http://blog.itpub.net/29863023/viewspace-2712451/，如需轉載，請註明出處，否則將追究法律責任。

相關文章