朋友在aix平台数据库10.2.0.3升级到10.2.0.5过程中,运行catupgrd.sql脚本,遭遇ORA-07445 joxchrcnv错误
--catupgrd.sql前台报错
Table altered.
Table altered.
BEGIN
*
ERROR at line 1:
ORA-03113: end-of-file on communication channel
ERROR:
ORA-03114: not connected to ORACLE
--trace文件报错
*** 2018-08-09 14:41:29.742
ksedmp: internal or fatal error
ORA-07445: exception encountered: core dump [joxchrcnv+00a8]
[SIGSEGV] [Address not mapped to object] [0x500000040] [] []
Current SQL statement for this session:
REVOKE all ON SYS.hs_bulk_seq FROM PUBLIC
----- PL/SQL Call Stack -----
object line object
handle number name
7000000e9942b80 2 anonymous block
----- Call Stack Trace -----
calling call entry argument values in hex
location type point (? means dubious value)
-------------------- -------- -------------------- ----------------------------
ksedst+001c bl ksedst1 000000000 ? 000000001 ?
ksedmp+0290 bl ksedst 104C1FC50 ?
ssexhd+03e0 bl ksedmp 300001D15 ?
0000441C ? 00000000
joxcdtu+0088 bl joxchrcnv 11019B760 ? 7000000E2CEBC70 ?
FFFFFFFFFFE82A0 ?
7000000E37EFDC8 ? 000000000 ?
000000000 ? 000000002 ?
7000000E1A8B250 ?
joxcnas+007c bl joxcdtu 110008BE0 ? 7000000E5FD3670 ?
FFFFFFFFFFE71C0 ?
4642408300000004 ?
104BAF6F0 ? 7000000E6BE6B48 ?
joxsnm_+0020 bl joxcnas 7000000E5FD4E30 ? 000000001 ?
000000000 ? 7000000E2CEB8D0 ?
7000000E991C6E0 ? 11019B760 ?
FFFFFFFFFFE82E0 ?
joxsnm+0010 bl 03754C58
kkdlJavasnmAltName+ bl 01FC3B1C
0048
qcdlgbo+0908 bl _ptrgl
qcdlgob+0560 bl qcdlgbo FFFFFFFFFFEF8C0 ? 11019B760 ?
11057B380 ? 7000000E2CEC960 ?
000000000 ? 104DA95B0 ?
700000010017FA0 ? 400000000 ?
qcsfgob+0220 bl qcdlgob FFFFFFFFFFE8B20 ? 1058251F8 ?
FFFFFFFFFFE9000 ? 000000001 ?
00000000B ? 000000000 ?
0000000C7 ?
qcsprfro+04a4 bl qcsfgob 1104300C0 ? 000000000 ?
1100C1848 ? 11019B760 ?
qcsprfro_tree+0454 bl qcsprfro 000000000 ? 000000000 ?
FFFFFFFFFFE8DE8 ? 000000000 ?
qcsprfro_tree+0258 bl qcsprfro_tree 000000001 ? 000000000 ?
FFFFFFFFFFE8DA0 ? 11057B380 ?
7000000E1ACA8F8 ? 000000000 ?
qcspafq+0068 bl qcsprfro_tree 11058DEA0 ? FFFFFFFFFFE9040 ?
FFFFFFFFFFE8E50 ?
4822208200000010 ?
10277AD14 ? 110118F58 ?
qcspqbDescendents+0 bl qcspafq 000000000 ? 110008BE0 ?
3a0 FFFFFFFFFFEFF70 ?
qcspqb+00ac bl qcspqbDescendents 10008CC20 ? 000000000 ?
7000000E2CEC638 ?
kkmdrv+003c bl qcspqb FFFFFFFFFFE9080 ?
88832081E9999F10 ?
FFFFFFFFFFE9080 ?
opiSem+1450 bl kkmdrv 000000000 ? 000001068 ?
11019E058 ? 11058DA68 ?
opiprs+01ac bl opiSem FFFFFFFFFFEFF70 ? 110502A18 ?
00000002A ? 000000001 ?
kksParseChildCursor bl opiprs 10008CC20 ? 000000000 ?
+0640 104C29C50 ? 07FFFFFF8 ?
000000FE8 ? 000000001 ?
rpiswu2+0368 bl _ptrgl
kksLoadChild+20cc bl rpiswu2 7000000EAA86FE0 ? 000000000 ?
000000000 ? 000000000 ?
000000000 ? 000000000 ?
000000000 ? 000000000 ?
kxsGetRuntimeLock+0 bl kksLoadChild 11019B760 ? 7000000E9AE5520 ?
89c 7000000E38176D8 ?
kksfbc+2830 bl kxsGetRuntimeLock 11019B760 ? 11057B380 ?
FFFFFFFFFFF18D8 ? 000000000 ?
000000000 ?
kkspsc0+1570 bl kksfbc 11057B380 ? 3FFFF2858 ?
108E381B6C0 ? 110502A18 ?
00000002A ? 000000000 ?
000000000 ? 000000000 ?
kksParseCursor+00d4 bl kkspsc0 110431A68 ? 110502A18 ?
00000002A ? 310231CF0 ?
610431A68 ?
222000000000000A ?
000000000 ?
opiosq0+0b40 bl 01FC69A4
opipls+0638 bl opiosq0 3EA6B0DF8 ? 110008BE0 ?
110118F58 ?
22200000EAADBE88 ?
000000000 ?
opiodr+0b2c bl _ptrgl
rpidrus+01dc bl opiodr 6600000000 ? 6E2D017E0 ?
FFFFFFFFFFF6C80 ? AFFFF5CD0 ?
skgmstack+00c8 bl _ptrgl
rpidru+0088 bl skgmstack 7000000E37EFB20 ?
FFFFFFFFFFF5C30 ?
FFFFFFFFFFF6080 ?
26214040000010F0 ?
100417334 ?
rpiswu2+0368 bl _ptrgl
rpidrv+097c bl rpiswu2 7000000EAA86FE0 ? 11019B760 ?
FFFFFFFFFFF6400 ? 000000004 ?
7000000E37EFB50 ? 0E9942BE0 ?
7000000E9942BF0 ? 000000000 ?
psddr0+02dc bl 01FC6E18
psdnal+01d0 bl psddr0 A00000000 ? 6600000000 ?
FFFFFFFFFFF6C80 ?
3100000000 ?
pevm_EXIM+0120 bl _ptrgl
pfrinstr_EXIM+0034 bl pevm_EXIM 1105BD288 ? 000000000 ?
pfrrun_no_tool+005c bl _ptrgl
pfrrun+1064 bl pfrrun_no_tool 5800000000 ? 110231CF0 ?
FFFFFFFFFFF6FA0 ?
plsql_run+06e8 bl pfrrun 110449078 ?
peicnt+0244 bl plsql_run 110449078 ? 1000000000418 ?
000000000 ?
kkxexe+0250 bl peicnt FFFFFFFFFFF82D8 ? 110449078 ?
opiexe+3024 bl kkxexe 1104DAEC8 ?
kpoal8+0ef0 bl opiexe FFFFFFFFFFFB954 ? 1103AA798 ?
FFFFFFFFFFF9AF0 ?
opiodr+0b2c bl _ptrgl
ttcpip+1020 bl _ptrgl
opitsk+117c bl 01FC6888
opiino+09d0 bl opitsk 1EFFFFD920 ? 000000000 ?
opiodr+0b2c bl _ptrgl
opidrv+04a4 bl opiodr 3C102A7758 ? 404C72B18 ?
FFFFFFFFFFFF8E0 ? 0102A7750 ?
sou2o+0090 bl opidrv 3C02A288DC ? 400000010 ?
FFFFFFFFFFFF8E0 ?
opimai_real+01bc bl 01FC30F4
main+0098 bl opimai_real 000000000 ? 000000000 ?
__start+0098 bl main 000000000 ? 000000000 ?
--------------------- Binary Stack Dump ---------------------
根据Catupgrd.sql Fails with ORA-3113/ORA-7445 During Grant Select On ALL_JOBS to Public with Grant Option (Doc ID 419309.1)文档,处理建议
1. Make sure LD_LIBRARY_PATH or LIBPATH is set correctly:
AIX
====
export LIBPATH=$ORACLE_HOME/lib:$LIBPATH
HP-UX
=====
export LD_LIBRARY_PATH=$ORACLE_HOME/lib
export SHLIB_PATH=$ORACLE_HOME/lib32
HP Tru-64
========
export LD_LIBRARY_PATH=$ORACLE_HOME/lib
SUN Sparc Solaris-64Bit
==================
export LD_LIBRARY_PATH_64=$ORACLE_HOME/lib
export LD_LIBRARY_PATH=$ORACLE_HOME/lib32
SUN Sparc Solaris-32Bit
==================
export LD_LIBRARY_PATH=$ORACLE_HOME/lib
Linux
=====
export LD_LIBRARY_PATH=$ORACLE_HOME/lib
2. Make sure ORA_NLS parameter is set correctly. See the following notes for assistance:
Note 77442.1 (ORA_NLS32, ORA_NLS33, ORA_NLS10) Environment Variables explained.
3. Make sure Listener is also started with the correct environment variables if you were doing
remote connection from client through sqlnet rather than local connection to database.
4. Shutdown the database and rerun the upgrade:
SQL> SHUTDOWN IMMEDIATE
SQL> STARTUP UPGRADE
SQL> SPOOL patch.log
SQL> @?/rdbms/admin/catupgrd.sql
5. If the above failed then it might be due to the libjox *.a file is not replaced during upgrade or install.
检查该环境发现libjox动态库丢失
由于软件升级不正常,导致数据库升级出现该问题,在升级软件过程中,一定检查升级软件和升级结果