-
加我公众号(orasos)
加我微信(17813235971)
加我QQ(107644445)
标签云
asm恢复 bbed bootstrap$ dul kcbzib_kcrsds_1 kccpb_sanity_check_2 kcratr_nab_less_than_odr kgegpa MySQL恢复 ORA-00312 ORA-00704 ORA-00742 ORA-01110 ORA-01200 ORA-01555 ORA-01578 ORA-01595 ORA-600 2662 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-600 kdsgrp1 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)
- 操作系统 (110)
- 数据库 (1,821)
- DB2 (22)
- MySQL (80)
- Oracle (1,651)
- Data Guard (53)
- EXADATA (8)
- GoldenGate (24)
- ORA-xxxxx (168)
- ORACLE 12C (72)
- ORACLE 18C (6)
- ORACLE 19C (15)
- ORACLE 21C (3)
- Oracle 23ai (8)
- Oracle ASM (69)
- Oracle Bug (8)
- Oracle RAC (54)
- Oracle 安全 (6)
- Oracle 开发 (28)
- Oracle 监听 (29)
- Oracle备份恢复 (620)
- Oracle安装升级 (102)
- Oracle性能优化 (62)
- 专题索引 (5)
- 勒索恢复 (86)
- PostgreSQL (36)
- pdu工具 (7)
- PostgreSQL恢复 (13)
- SQL Server (34)
- SQL Server恢复 (14)
- TimesTen (7)
- 达梦数据库 (3)
- 达梦恢复 (1)
- 生活娱乐 (2)
- 至理名言 (11)
- 虚拟化 (2)
- VMware (2)
- 软件开发 (45)
- Asp.Net (9)
- JavaScript (12)
- PHP (2)
- 小工具 (28)
-
最近发表
- Patch_SCN快速解决ORA-600 2663故障
- 在生产环境错误执行dd命令破坏asm磁盘故障恢复
- obet实现对数据文件坏块检测功能
- oracle linux 8.10注意pmlogger导致空间被大量占用
- obet快速修改scn/resetlogs恢复数据库(缺少归档,ORA-00308）
- 使用DBMS_PDB.RECOVER抢救单个pdb
- aix环境写入大文件设置combehin提高效率
- 记录一次国产数据库被rm -rf /*删除的救援过程
- 数据库启动报 maximum number of processes () exceeded分析
- ORA-600 [ksunfy : too few sessions]
- 由于数据块scn大于数据库scn导致ORA-600 kcbzib_kcrsds_1错误
- ORA-600 ktbair2: illegal inheritance恢复
- 一键恢复ORA-00704 ORA-00702故障—202512
- PostgreSQL查询一个表相关的所有oid
- PostgreSQL oid文件替换实现数据访问
- 模拟sql server故障备份完成恢复实现数据0丢失
- sql server 事务日志备份异常恢复案例
- win平台挂起Oracle数据库启动进程
- linux异常磁盘lvm恢复操作演示
- open数据库报ora-600 kdsgrp1故障处理
标签归档：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动态库丢失
由于软件升级不正常,导致数据库升级出现该问题,在升级软件过程中,一定检查升级软件和升级结果
