-
加我微信
加我QQ
标签云
asm恢复 bbed bootstrap$ dul In Memory kcbzib_kcrsds_1 kccpb_sanity_check_2 kfed MySQL恢复 ORA-00312 ORA-00607 ORA-00704 ORA-01110 ORA-01555 ORA-01578 ORA-08103 ORA-600 2131 ORA-600 2662 ORA-600 2663 ORA-600 3020 ORA-600 4000 ORA-600 4137 ORA-600 4193 ORA-600 4194 ORA-600 16703 ORA-600 kcbzib_kcrsds_1 ORA-600 KCLCHKBLK_4 ORA-15042 ORA-15196 ORACLE 12C oracle dul ORACLE PATCH Oracle Recovery Tools oracle加密恢复 oracle勒索 oracle勒索恢复 oracle异常恢复 Oracle 恢复 ORACLE恢复 ORACLE数据库恢复 oracle 比特币 OSD-04016 YOUR FILES ARE ENCRYPTED 勒索恢复 比特币加密文章分类
- Others (2)
- 中间件 (2)
- WebLogic (2)
- 操作系统 (102)
- 数据库 (1,670)
- DB2 (22)
- MySQL (73)
- Oracle (1,532)
- Data Guard (52)
- EXADATA (8)
- GoldenGate (21)
- ORA-xxxxx (159)
- ORACLE 12C (72)
- ORACLE 18C (6)
- ORACLE 19C (14)
- ORACLE 21C (3)
- Oracle 23ai (7)
- Oracle ASM (65)
- Oracle Bug (8)
- Oracle RAC (52)
- Oracle 安全 (6)
- Oracle 开发 (28)
- Oracle 监听 (28)
- Oracle备份恢复 (560)
- Oracle安装升级 (91)
- Oracle性能优化 (62)
- 专题索引 (5)
- 勒索恢复 (78)
- PostgreSQL (18)
- PostgreSQL恢复 (6)
- SQL Server (27)
- SQL Server恢复 (8)
- TimesTen (7)
- 达梦数据库 (2)
- 生活娱乐 (2)
- 至理名言 (11)
- 虚拟化 (2)
- VMware (2)
- 软件开发 (37)
- Asp.Net (9)
- JavaScript (12)
- PHP (2)
- 小工具 (20)
-
最近发表
- ORA-600 krse_arc_complete.4
- Oracle 19c 202410补丁（RUs+OJVM）
- ntfs MFT损坏(ntfs文件系统故障)导致oracle异常恢复
- .mkp扩展名oracle数据文件加密恢复
- 清空redo,导致ORA-27048: skgfifi: file header information is invalid
- A_H_README_TO_RECOVER勒索恢复
- 通过alert日志分析客户自行对一个数据库恢复的来龙去脉和点评
- ORA-12514: TNS: 监听进程不能解析在连接描述符中给出的SERVICE_NAME
- ORA-01092 ORA-00604 ORA-01558故障处理
- ORA-65088: database open should be retried
- Oracle 19c异常恢复—ORA-01209/ORA-65088
- ORA-600 16703故障再现
- 数据库启动报ORA-27102 OSD-00026 O/S-Error: (OS 1455)
- .[metro777@cock.li].Elbie勒索病毒加密数据库恢复
- 应用连接错误,初始化mysql数据库恢复
- RAC默认服务配置优先节点
- Oracle 19c RAC 替换私网操作
- 监听报TNS-12541 TNS-12560 TNS-00511错误
- drop tablespace xxx including contents恢复
- Linux 8 修改网卡名称
标签归档：ORA-07445 joxchrcnv
数据库升级报ORA-07445 joxchrcnv
朋友在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动态库丢失
由于软件升级不正常,导致数据库升级出现该问题,在升级软件过程中,一定检查升级软件和升级结果