标签云
asm 恢复 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 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)
- 操作系统 (100)
- 数据库 (1,595)
- DB2 (22)
- MySQL (70)
- Oracle (1,462)
- Data Guard (49)
- EXADATA (7)
- GoldenGate (21)
- ORA-xxxxx (158)
- ORACLE 12C (72)
- ORACLE 18C (6)
- ORACLE 19C (13)
- ORACLE 21C (3)
- Oracle ASM (65)
- Oracle Bug (7)
- Oracle RAC (47)
- Oracle 安全 (6)
- Oracle 开发 (27)
- Oracle 监听 (27)
- Oracle备份恢复 (530)
- Oracle安装升级 (83)
- Oracle性能优化 (62)
- 专题索引 (5)
- 勒索恢复 (75)
- PostgreSQL (16)
- PostgreSQL恢复 (4)
- SQL Server (27)
- SQL Server恢复 (8)
- TimesTen (7)
- 达梦数据库 (2)
- 生活娱乐 (2)
- 至理名言 (11)
- 虚拟化 (2)
- VMware (2)
- 软件开发 (36)
- Asp.Net (9)
- JavaScript (12)
- PHP (2)
- 小工具 (19)
-
最近发表
- PostgreSQL部分主要字典信息
- PostgreSQL恢复系列:pg_filedump恢复字典构造
- PostgreSQL 16 源码安装
- ORA-00742 ORA-00312 恢复
- 数据库open成功后报ORA-00353 ORA-00354错误引起的一系列问题(本质ntfs文件系统异常)
- ORA-600 ktsiseginfo1故障
- ORA-00600: internal error code, arguments: [16703], [1403], [4] 原因
- 最近遇到几起ORA-600 16703故障(tab$被清空),请引起重视
- ORA-600 2662快速恢复之Patch scn工具
- TNS-12518: TNS:listener could not hand off client connection
- ora.storage无法启动报ORA-12514故障处理
- 断电引起文件scn异常数据库恢复
- ORA-16188: LOG_ARCHIVE_CONFIG settings inconsistent with previously started instance
- .[hudsonL@cock.li].mkp勒索加密数据库完美恢复
- 模拟带库实现rman远程备份
- 又一例:ORA-600 kclchkblk_4和2662故障
- Oracle误删除数据文件恢复
- Oracle 19C 备库DML重定向—DML Redirection
- ORA-01595/ORA-600 4194处理
- 从ORA-00283 ORA-16433报错开始恢复
月归档:十月 2015
dns解析导致opiodr aborting process unknown ospid (7266) as a result of ORA-609类似错误
数据库alert日志中出现大量类似opiodr aborting process unknown ospid (7266) as a result of ORA-609错误
Tue Oct 27 07:51:10 2015 opiodr aborting process unknown ospid (7266) as a result of ORA-609 Tue Oct 27 08:16:56 2015 opiodr aborting process unknown ospid (7660) as a result of ORA-609 Tue Oct 27 08:17:16 2015 opiodr aborting process unknown ospid (7666) as a result of ORA-609 Tue Oct 27 08:21:50 2015 opiodr aborting process unknown ospid (7725) as a result of ORA-609 Tue Oct 27 08:37:43 2015 opiodr aborting process unknown ospid (7940) as a result of ORA-609 Tue Oct 27 08:51:25 2015 opiodr aborting process unknown ospid (8126) as a result of ORA-609 Tue Oct 27 09:07:16 2015 opiodr aborting process unknown ospid (8359) as a result of ORA-609 Tue Oct 27 09:26:09 2015 opiodr aborting process unknown ospid (8600) as a result of ORA-609
测试tnsping
[oracle@Sql admin]$ tnsping orcl TNS Ping Utility for Linux: Version 11.2.0.1.0 - Production on 28-OCT-2015 01:40:55 Copyright (c) 1997, 2009, Oracle. All rights reserved. Used parameter files: /opt/oracle/product/11.2.0/db_1/network/admin/sqlnet.ora Used TNSNAMES adapter to resolve the alias Attempting to contact (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.2.162)(PORT = 1521)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = orcl.Sql.xifenfei.com))) OK (20120 msec) [oracle@Sql admin]$ tnsping orcl TNS Ping Utility for Linux: Version 11.2.0.1.0 - Production on 28-OCT-2015 01:42:35 Copyright (c) 1997, 2009, Oracle. All rights reserved. Used parameter files: /opt/oracle/product/11.2.0/db_1/network/admin/sqlnet.ora Used TNSNAMES adapter to resolve the alias Attempting to contact (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.2.162)(PORT = 1521)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = orcl.Sql.xifenfei.com))) OK (41600 msec)
hosts文件配置
[oracle@Sql admin]$ vi /etc/hosts 127.0.0.1 localhost localhost.localdomain localhost4 localhost4.localdomain4 192.168.2.162 Sql.xifenfei.com ::1 localhost localhost.localdomain localhost6 localhost6.localdomain6
同时测试lsnrctl start/stop/status都很慢,但是ping localhost非常快,证明问题在监听之上.search 关键字lsnrctl slow/tnsping slow关键字发现有相关文档:
Bug 8307164 : TNSPING 11G USING DNS AND NOT HOSTS FILE
Listener Startup or Connections Hang in 11g (Doc ID 803838.1)
11g: Remote Connections Take Very Long to Establish (Doc ID 856820.1)
通过这些文档,可以知道在oracle 10g中解析主机名使用gethostbyname()函数,11g中使用了使用getaddrinfo()函数.这个函数对于/etc/nsswitch.conf的调用和ethostbyname()不一样,从而出现此类问题.根据官方建议:
Linux hosts: files [NOTFOUND=continue] dns OR hosts:files/dns HPUX and Solaris ipnodes: files [NOTFOUND=continue] dns
本次解决方法
因为对于没有使用到dns服务器的数据库环境而言,没有必要配置这玩意,给自己埋雷,估计是当时安装yum之时没有清理掉
vi /etc/nsswitch.conf hosts: files nds -->hosts: files
再次测试tnsping,lsnrctl等命令,速度ok
[oracle@Sql"]$ tnsping orcl TNS Ping Utility for Linux: Version 11.2.0.1.0 - Production on 28-OCT-2015 01:58:30 Copyright (c) 1997, 2009, Oracle. All rights reserved. Used parameter files: /opt/oracle/product/11.2.0/db_1/network/admin/sqlnet.ora Used TNSNAMES adapter to resolve the alias Attempting to contact (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.2.162)(PORT = 1521)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = orcl.Sql.xifenfei.com))) OK (10 msec)
对于此类监听慢的问题,可以通过对client/server端trace进一步跟踪
TRACE_LEVEL_CLIENT = 16 TRACE_FILE_CLIENT = client/server TRACE_DIRECTORY_CLIENT = [any valid directory path] TRACE_TIMESTAMP_CLIENT = ON DIAG_ADR_ENABLED=off
Quick Reference to Patch Numbers for Database PSU, SPU(CPU), Bundle Patches and Patchsets—201507
11.2.0.1.0 |
|
Older Versions |
Raise a non-technical SR for Physical Shipment or Download URL. Refer Doc ID 1071023.1 |
Patchsets |
|
l12.1.0.2 (12.1.0.2.0 PATCH SET FOR ORACLE DATABASE SERVER) |
|
11.2.0.4 (11.2.0.4.0 PATCH SET FOR ORACLE DATABASE SERVER) |
|
11.2.0.3 (11.2.0.3.0 PATCH SET FOR ORACLE DATABASE SERVER) |
|
11.2.0.2 (11.2.0.2.0 PATCH SET FOR ORACLE DATABASE SERVER) |
|
11.1.0.7 (11.1.0.7.0 PATCH SET FOR ORACLE DATABASE SERVER) |
|
10.2.0.5 (10.2.0.5 PATCH SET FOR ORACLE DATABASE SERVER) |
|
d10.2.0.4 (10.2.0.4.0 PATCH SET FOR ORACLE DATABASE SERVER) |
|
e10.2.0.3 (10.2.0.3 PATCH SET FOR ORACLE DATABASE SERVER) |
|
10.2.0.2 (10.2.0.2 PATCH SET FOR ORACLE DATABASE SERVER) |
|
10.1.0.5 (10.1.0.5 PATCH SET FOR ORACLE DATABASE SERVER) |
|
10.1.0.4 (10.1.0.4 PATCH SET FOR ORACLE DATABASE SERVER) |
|
10.1.0.3 (10.1.0.3 PATCH SET FOR ORACLE DATABASE SERVER) |
|
9.2.0.8 (9.2.0.8 PATCH SET FOR ORACLE DATABASE SERVER) |
|
9.2.0.7 (9.2.0.7 PATCH SET FOR ORACLE DATABASE SERVER) |
|
9.2.0.6 (9.2.0.6 PATCH SET FOR ORACLE DATABASE SERVER) |
|
9.2.0.5 (ORACLE 9I DATABASE SERVER RELEASE 2 – PATCH SET 4 VERSION 9.2.0.5.0) |
|
9.2.0.4 (9.2.0.4 PATCH SET FOR ORACLE DATABASE SERVER) |
|
9.2.0.3 (9.2.0.3 PATCH SET FOR ORACLE DATABASE SERVER) |
|
9.2.0.2 (9.2.0.2 PATCH SET FOR ORACLE DATABASE SERVER) |
|
9.0.1.5 (9.0.1.5 PATCHSET) |
|
9.0.1.4 (9.0.1.4 PATCH SET FOR ORACLE DATABASE SERVER) |
|
9.0.1.3 (9.0.1.3. PATCH SET FOR ORACLE DATA SERVER) |
|
8.1.7.4 (8.1.7.4 PATCH SET FOR ORACLE DATA SERVER) |
|
8.1.7.3 (8.1.7.3 PATCH SET FOR ORACLE DATA SERVER) |
|
8.1.7.2 (8.1.7.2.1 PATCH SET FOR ORACLE DATA SERVER) |
PSU, SPU(CPU), Bundle Patches
12.1.0.2 |
|||
Description |
PSU |
GI PSU |
Bundle Patch (Windows 32bit & 64bit) |
JUL2015 |
20831110 (12.1.0.2.4) |
20996835 (12.1.0.2.4) |
21126814 (12.1.0.2.7) |
APR2015 |
20299023 (12.1.0.2.3) |
20485724 (12.1.0.2.3) |
20684004 (12.1.0.2.4) |
JAN2015 |
19769480 (12.1.0.2.2) |
19954978 (12.1.0.2.2) |
19720843 (12.1.0.2.1) |
OCT2014 |
19303936 (12.1.0.2.1) |
19392646 (12.1.0.2.1) |
N/A |
12.1.0.1 |
||||
Description |
PSU |
GI PSU |
Bundle Patch (Windows64bit) |
Bundle Patch (Windows32bit) |
JUL2015 |
20831107 (12.1.0.1.8) |
21076681 (12.1.0.1.20) |
||
APR2015 |
20299016 (12.1.0.1.7) |
20558101 (12.1.0.1.18) |
||
JAN2015 |
19769486 (12.1.0.1.6) |
20160748 (12.1.0.1.16) |
||
OCT2014 |
19121550 (12.1.0.1.5) |
19542943 (12.1.0.1.14) |
||
JUL2014 |
18522516 (12.1.0.1.4) |
19062327 (12.1.0.1.11) |
||
APR2014 |
18031528 (12.1.0.1.3) |
18448604 (12.1.0.1.7) |
||
JAN2014 |
17552800 (12.1.0.1.2) |
17735306 (12.1.0.1.2) |
17977915 (12.1.0.1.3) |
|
OCT2013 |
17027533 (12.1.0.1.1) |
17272829 (12.1.0.1.1) |
17363796 (12.1.0.1.1) |
17363795 (12.1.0.1.1) |
11.2.0.4 |
||||
Description |
PSU |
SPU(CPU) |
GI PSU |
Bundle Patch (Windows 32bit & 64bit) |
JUL2015 |
20760982 (11.2.0.4.7) |
20996923 (11.2.0.4.7) |
21469106 (11.2.0.4.18) |
|
APR2015 |
20299013 (11.2.0.4.6) |
20485808 (11.2.0.4.6) |
20544696 (11.2.0.4.15) |
|
JAN2015 |
19769489 (11.2.0.4.5) |
19955028 (11.2.0.4.5) |
20127071 (11.2.0.4.12) |
|
OCT2014 |
19121551 (11.2.0.4.4) |
19380115 (11.2.0.4.4) |
19651773 (11.2.0.4.10) |
|
JUL2014 |
18522509 (11.2.0.4.3) |
18706472 (11.2.0.4.3) |
18842982 (11.2.0.4.7) |
|
APR2014 |
18031668 (11.2.0.4.2) |
18139609 (11.2.0.4.2) |
18296644 (11.2.0.4.4) |
|
JAN2014 |
17478514 (11.2.0.4.1) |
N/A |
17987366 (11.2.0.4.1) |
11.2.0.3 |
|||||
Description |
PSU |
SPU(CPU) |
GI PSU |
Bundle Patch (Windows64bit) |
Bundle Patch (Windows32bit) |
JUL2015 |
20760997 (11.2.0.3.15) |
20996944 (11.2.0.3.15) |
|||
APR2015 |
20299017 (11.2.0.3.14) |
20485830 (11.2.0.3.14) |
|||
JAN2015 |
19769496 (11.2.0.3.13) |
19971343 (11.2.0.3.13) |
|||
OCT2014 |
19121548 (11.2.0.3.12) |
19440385 (11.2.0.3.12) |
|||
JUL2014 |
18522512 (11.2.0.3.11) |
18706488 (11.2.0.3.11) |
|||
APR2014 |
18031683 (11.2.0.3.10) |
18139678 (11.2.0.3.10) |
|||
JAN2014 |
17540582 (11.2.0.3.9) |
17735354 (11.2.0.3.9) |
|||
OCT2013 |
16902043 (11.2.0.3.8) |
17272731 (11.2.0.3.8) |
|||
JUL2013 |
16619892 (11.2.0.3.7) |
16742216 (11.2.0.3.7) |
|||
APR2013 |
16056266 (11.2.0.3.6) |
16083653 (11.2.0.3.6) |
|||
JAN2013 |
14727310 (11.2.0.3.5) |
14727347 (11.2.0.3.5) |
|||
OCT2012 |
14275605 (11.2.0.3.4) |
14275572 (11.2.0.3.4) |
|||
JUL2012 |
13923374 (11.2.0.3.3) |
13919095 (11.2.0.3.3) |
|||
APR2012 |
13696216 (11.2.0.3.2) |
13696251 (11.2.0.3.2) |
|||
JAN2012 |
13343438 (11.2.0.3.1) |
13348650 (11.2.0.3.1) |
11.2.0.2 |
|||||
Description |
PSU |
SPU(CPU) |
GI PSU |
Bundle Patch (Windows64bit) |
Bundle Patch (Windows32bit) |
aOCT2013 |
17082367 (11.2.0.2.12) |
17272753 (11.2.0.2.12) |
|||
JUL2013 |
16619893 (11.2.0.2.11) |
16742320 (11.2.0.2.11) |
|||
APR2013 |
16056267 (11.2.0.2.10) |
16166868 (11.2.0.2.10) |
|||
JAN2013 |
14727315 (11.2.0.2.9) |
14841385 (11.2.0.2.9) |
|||
OCT2012 |
14275621 (11.2.0.2.8) |
14390437 (11.2.0.2.8) |
|||
JUL2012 |
13923804 (11.2.0.2.7) |
14192201 (11.2.0.2.7) |
|||
APR2012 |
13696224 (11.2.0.2.6) |
13696242 (11.2.0.2.6) |
|||
JAN2012 |
13343424 (11.2.0.2.5) |
13653086 (11.2.0.2.5) |
|||
OCT2011 |
12827726 (11.2.0.2.4) |
12827731 (11.2.0.2.4) |
|||
JUL2011 |
12419331 (11.2.0.2.3) |
12419353 (11.2.0.2.3) |
|||
APR2011 |
11724916 (11.2.0.2.2) |
12311357 (11.2.0.2.2) |
|||
JAN2011 |
10248523 (11.2.0.2.1) |
N/A |
N/A |
11.2.0.1 |
||||
Description |
PSU |
CPU |
Bundle Patch (Windows64bit) |
Bundle Patch (Windows32bit) |
aJUL2011 |
12419378 (11.2.0.1.6) |
|||
APR2011 |
11724930 (11.2.0.1.5) |
|||
JAN2011 |
10248516 (11.2.0.1.4) |
|||
OCT2010 |
9952216 (11.2.0.1.3) |
|||
JUL2010 |
9654983 (11.2.0.1.2) |
|||
APR2010 |
9352237 (11.2.0.1.1) |
N/A |
N/A |
11.1.0.7 |
||||
Description |
PSU |
SPU(CPU) |
Bundle Patch (Windows64bit) |
Bundle Patch (Windows32bit) |
bJUL2015 |
20761024 (11.1.0.7.24) |
|||
bAPR2015 |
20299012 (11.1.0.7.23) |
|||
bJAN2015 |
19769499 (11.1.0.7.22) |
|||
bOCT2014 |
19152553 (11.1.0.7.21) |
|||
bJUL2014 |
18522513 (11.1.0.7.20) |
|||
bAPR2014 |
18031726 (11.1.0.7.19) |
|||
bJAN2014 |
17465583 (11.1.0.7.18) |
|||
bOCT2013 |
17082366 (11.1.0.7.17) |
|||
bJUL2013 |
16619896 (11.1.0.7.16) |
|||
bAPR2013 |
16056268 (11.1.0.7.15) |
|||
bJAN2013 |
14739378 (11.1.0.7.14) |
|||
bOCT2012 |
14275623 (11.1.0.7.13) |
|||
JUL2012 |
13923474 (11.1.0.7.12) |
|||
APR2012 |
13621679 (11.1.0.7.11) |
|||
JAN2012 |
13343461 (11.1.0.7.10) |
|||
OCT2011 |
12827740 (11.1.0.7.9) |
|||
JUL2011 |
12419384 (11.1.0.7.8) |
|||
APR2011 |
11724936 (11.1.0.7.7) |
|||
JAN2011 |
10248531 (11.1.0.7.6) |
|||
OCT2010 |
9952228 (11.1.0.7.5) |
|||
JUL2010 |
9654987 (11.1.0.7.4) |
|||
APR2010 |
9352179 (11.1.0.7.3) |
|||
JAN2010 |
9209238 (11.1.0.7.2) |
|||
OCT2009 |
8833297 (11.1.0.7.1) |
|||
JUL2009 |
N/A |
|||
APR2009 |
N/A |
11.1.0.6 |
|||
Description |
CPU |
Bundle Patch (Windows64bit) |
Bundle Patch (Windows32bit) |
aJUL2009 |
|||
APR2009 |
|||
JAN2009 |
|||
OCT2008 |
|||
JUL2008 |
|||
APR2008 |
10.2.0.5 |
|||||
Description |
PSU |
SPU(CPU) |
Bundle Patch (Windows64bit) |
Bundle Patch (Windows32bit) |
Bundle Patch (WindowsItanium) |
abJUL2013 |
16619894 (10.2.0.5.12) |
||||
bAPR2013 |
16056270 (10.2.0.5.11) |
||||
bJAN2013 |
14727319 (10.2.0.5.10) |
||||
bOCT2012 |
14275629 (10.2.0.5.9) |
||||
bJUL2012 |
13923855 (10.2.0.5.8) |
||||
bAPR2012 |
13632743 (10.2.0.5.7) |
||||
JAN2012 |
13343471 (10.2.0.5.6) |
N/A |
|||
bOCT2011 |
12827745 (10.2.0.5.5) |
c12914913 |
N/A |
||
JUL2011 |
12419392 (10.2.0.5.4) |
N/A |
|||
APR2011 |
11724962 (10.2.0.5.3) |
N/A |
|||
JAN2011 |
10248542 (10.2.0.5.2) |
N/A |
|||
OCT2010 |
9952230 (10.2.0.5.1) |
N/A |
10.2.0.4 |
|||||
Description |
PSU |
SPU(CPU) |
Bundle Patch (Windows32bit) |
Bundle Patch (Windows64bit) |
Bundle Patch (WindowsItanium) |
bgJUL2013 |
16619897 (10.2.0.4.17) |
16742253 |
N/A |
N/A |
N/A |
bgAPR2013 |
16056269 (10.2.0.4.16) |
16270931 |
N/A |
N/A |
N/A |
bgJAN2013 |
14736542 (10.2.0.4.15) |
14841471 |
N/A |
N/A |
N/A |
bgOCT2012 |
14275630 (10.2.0.4.14) |
14390410 |
N/A |
N/A |
N/A |
bgJUL2012 |
13923851 (10.2.0.4.13) |
14038814 |
N/A |
N/A |
N/A |
abAPR2012 |
12879933 (10.2.0.4.12) |
N/A |
|||
JAN2012 |
12879929 (10.2.0.4.11) |
N/A |
N/A |
||
bOCT2011 |
12827778 (10.2.0.4.10) |
||||
JUL2011 |
12419397 (10.2.0.4.9) |
||||
APR2011 |
11724977 (10.2.0.4.8) |
||||
JAN2011 |
10248636 (10.2.0.4.7) |
||||
OCT2010 |
9952234 (10.2.0.4.6) |
||||
JUL2010 |
9654991 (10.2.0.4.5) |
||||
APR2010 |
9352164 (10.2.0.4.4) |
||||
JAN2010 |
9119284 (10.2.0.4.3) |
||||
OCT2009 |
8833280 (10.2.0.4.2) |
||||
JUL2009 |
8576156 (10.2.0.4.1) |
||||
APR2009 |
N/A |
||||
JAN2009 |
N/A |
N/A |
|||
OCT2008 |
N/A |
N/A |
|||
JUL2008 |
N/A |
N/A |
10.2.0.3 |
||||
Description |
CPU (Unix/Linux) |
Bundle Patch (Windows32bit) |
Bundle Patch (WindowsItanium) |
Bundle Patch (Windows64bit) |
aJAN2009 |
||||
OCT2008 |
||||
JUL2008 |
||||
APR2008 |
||||
JAN2008 |
||||
OCT2007 |
||||
JUL2007 |
||||
APR2007 |
||||
JAN2007 |
10.2.0.2 |
||||
Description |
CPU (Unix/Linux) |
Bundle Patch (Windows32bit) |
Bundle Patch (Windows64bit) |
Bundle Patch (WindowsItanium) |
iJAN2009 |
N/A |
N/A |
N/A |
|
hOCT2008 |
N/A |
N/A |
N/A |
|
hJUL2008 |
N/A |
N/A |
N/A |
|
hAPR2008 |
N/A |
N/A |
N/A |
|
aJAN2008 |
N/A |
N/A |
N/A |
|
fOCT2007 |
||||
JUL2007 |
||||
APR2007 |
||||
JAN2007 |
||||
OCT2006 |
||||
JUL2006 |
||||
APR2006 |
10.2.0.1 |
||||
Description |
CPU (Unix/Linux) |
Bundle Patch (Windows32bit) |
Bundle Patch (Windows64bit) |
Bundle Patch (WindowsItanium) |
APR2007 |
N/A |
N/A |
N/A |
|
JAN2007 |
||||
OCT2006 |
||||
JUL2006 |
||||
APR2006 |
||||
JAN2006 |
10.1.0.5 |
|||
Description |
CPU (Unix/Linux) |
Bundle Patch (Windows32bit) |
Bundle Patch (WindowsItanium) |
JAN2012 |
|||
OCT2011 |
|||
JUL2011 |
|||
APR2011 |
|||
JAN2011 |
N/A |
N/A |
N/A |
OCT2010 |
|||
JUL2010 |
|||
APR2010 |
|||
JAN2010 |
|||
OCT2009 |
|||
JUL2009 |
|||
APR2009 |
|||
JAN2009 |
|||
OCT2008 |
|||
JUL2008 |
|||
APR2008 |
|||
JAN2008 |
|||
OCT2007 |
|||
JUL2007 |
|||
APR2007 |
|||
JAN2007 |
|||
OCT2006 |
|||
JUL2006 |
|||
APR2006 |
|||
JAN2006 |
10.1.0.4 |
|||
Description |
CPU (Unix/Linux) |
Bundle Patch (Windows32bit) |
Bundle Patch (WindowsItanium) |
APR2007 |
|||
JAN2007 |
|||
OCT2006 |
|||
JUL2006 |
|||
APR2006 |
|||
JAN2006 |
|||
OCT2005 |
|||
JUL2005 |
|||
APR2005 |
10.1.0.3 |
|||
Description |
CPU (Unix/Linux) |
Bundle Patch (Windows32bit) |
Bundle Patch (WindowsItanium) |
JAN2007 |
N/A |
N/A |
|
OCT2006 |
N/A |
N/A |
|
JUL2006 |
N/A |
N/A |
|
APR2006 |
N/A |
N/A |
|
JAN2006 |
|||
OCT2005 |
|||
JUL2005 |
|||
APR2005 |
|||
JAN2005 |
10.1.0.2 |
|||
Description |
CPU (Unix/Linux) |
Bundle Patch (Windows32bit) |
Bundle Patch (WindowsItanium) |
APR2005 |
|||
JUL2005 |
|||
JAN2005 |
9.2.0.8 |
|||
Description |
CPU (Unix/Linux) |
Bundle Patch (Windows32bit) |
Bundle Patch (WindowsItanium) |
JUL2010 |
|||
APR2010 |
N/A |
||
JAN2010 |
N/A |
||
OCT2009 |
|||
JUL2009 |
|||
APR2009 |
|||
JAN2009 |
|||
OCT2008 |
|||
JUL2008 |
|||
APR2008 |
|||
JAN2008 |
|||
OCT2007 |
|||
JUL2007 |
|||
APR2007 |
|||
JAN2007 |
N/A |
N/A |
N/A |
OCT2006 |
9.2.0.7 |
|||
Description |
CPU (Unix/Linux) |
Bundle Patch (Windows32bit) |
Bundle Patch (WindowsItanium) |
JUL2007 |
|||
APR2007 |
|||
JAN2007 |
|||
OCT2006 |
|||
JUL2006 |
|||
APR2006 |
|||
JAN2006 |
|||
OCT2005 |
|||
JUL2005 |
N/A |
N/A |
9.2.0.6 |
|||
Description |
CPU (Unix/Linux) |
Bundle Patch (Windows32bit) |
Bundle Patch (WindowsItanium) |
OCT2006 |
|||
JUL2006 |
|||
APR2006 |
|||
JAN2006 |
|||
OCT2005 |
|||
JUL2005 |
|||
APR2005 |
9.2.0.5 |
|||
Description |
CPU (Unix/Linux) |
Bundle Patch (Windows32bit) |
Bundle Patch (WindowsItanium) |
OCT2006 |
N/A |
N/A |
|
JUL2006 |
N/A |
N/A |
|
APR2006 |
N/A |
N/A |
|
OCT2005 |
N/A |
N/A |
|
JUL2005 |
|||
APR2005 |
|||
JAN2005 |
9.2.0.4 |
|||
Description |
CPU (Unix/Linux) |
Bundle Patch (Windows32bit) |
Bundle Patch (WindowsItanium) |
JAN2005 |
8.1.7.4 |
||
Description |
CPU (Unix/Linux) |
Bundle Patch (Windows32bit) |
JAN2007 |
||
OCT2006 |
||
JUL2006 |
||
APR2006 |
||
JAN2006 |
||
OCT2005 |
||
JUL2005 |
||
APR2005 |
||
JAN2005 |
OJVM PSU Patches
12.1.0.2 |
||||
Description |
OJVM PSU (Linux/Unix) |
OJVM BP (Windows) |
Combo OJVM + DB PSU |
Combo OJVM + GI PSU |
JUL2015 |
21068507 (12.1.0.2.4) |
21153530 (12.1.0.2.3) |
||
APR2015 |
20415564 (12.1.0.2.3) |
20391199 (12.1.0.2.2) |
||
JAN2015 |
19877336 (12.1.0.2.2) |
20225938 (12.1.0.2.1) |
||
OCT2014 (12.1.0.2.1) |
12.1.0.1 |
|||||
Description |
OJVM PSU (Linux/Unix) |
OJVM BP (Windows) |
Combo OJVM + DB PSU |
Combo OJVM + GI PSU |
Generic JDBC |
JUL2015 (12.1.0.1.4) |
Included in OJVM PSU |
||||
APR2015 (12.1.0.1.3) |
|||||
JAN2015 (12.1.0.1.2) |
|||||
OCT2014 (12.1.0.1.1) |
11.2.0.4 |
||||||
Description |
OJVM PSU (Linux/Unix) |
OJVM BP (Windows) |
Combo OJVM + DB PSU |
Combo OJVM + DB SPU |
Combo OJVM + GI PSU |
Generic JDBC |
JUL2015 (11.2.0.4.4) |
Included in OJVM PSU |
|||||
APR2015 (11.2.0.4.3) |
||||||
JAN2015 (11.2.0.4.2) |
||||||
OCT2014 (11.2.0.4.1) |
11.2.0.3 |
||||||
Description |
OJVM PSU (Linux/Unix) |
OJVM BP (Windows) |
Combo OJVM + DB PSU |
Combo OJVM + DB SPU |
Combo OJVM + GI PSU |
Generic JDBC |
JUL2015 (11.2.0.3.4) |
Included in OJVM PSU |
|||||
APR2015 (11.2.0.3.3) |
||||||
JAN2015 (11.2.0.3.2) |
||||||
OCT2014 (11.2.0.3.1) |
11.1.0.7 |
||||||
Description |
OJVM PSU (Linux/Unix) |
OJVM BP (Windows) |
Combo OJVM + DB PSU |
Combo OJVM + DB SPU |
Combo OJVM + GI PSU |
Generic JDBC |
JUL2015 (11.1.0.7.4) |
21068565 |
N/A |
Included in OJVM PSU |
|||
APR2015 (11.1.0.7.3) |
N/A |
|||||
JAN2015 (11.1.0.7.2) |
N/A |
|||||
OCT2014 (11.1.0.7.1) |
N/A |
EXP-00104: datatype (BINARY_DOUBLE) 错误
进行了一次使用exp数据迁移,客户和我说丢失了表,我觉得比较奇怪,分析日志发现EXP-00104: datatype (BINARY_DOUBLE)错误,对其单表进行导出,发现问题重现
[oracle@app73 ~]$ exp system/oracle123 file=/Data/1.dmp tables=CHF.T_XIFENFEI Export: Release 11.1.0.6.0 - Production on Wed Oct 14 23:25:31 2015 Copyright (c) 1982, 2007, Oracle. All rights reserved. Connected to: Oracle Database 11g Enterprise Edition Release 11.1.0.6.0 - 64bit Production With the Partitioning, OLAP, Data Mining and Real Application Testing options Export done in ZHS16GBK character set and AL16UTF16 NCHAR character set About to export specified tables via Conventional Path ... Current user changed to CHF . . exporting table T_XIFENFEI EXP-00104: datatype (BINARY_DOUBLE) of column NUMCOMMISSIONRATE in table CHF.T_XIFENFEI is not supported, table will not be exported
数据库版本
SQL> select * from v$version; BANNER -------------------------------------------------------------------------------- Oracle Database 11g Enterprise Edition Release 11.1.0.6.0 - 64bit Production PL/SQL Release 11.1.0.6.0 - Production CORE 11.1.0.6.0 Production TNS for Linux: Version 11.1.0.6.0 - Production NLSRTL Version 11.1.0.6.0 - Production
表结构
SQL> DESC CHF.T_XIFENFEI Name Null? Type ----------------------------------------- -------- ---------------------------- ………… NUMPRO NUMBER NUMCOMMISSIONRATE BINARY_DOUBLE NUMSEQ BINARY_DOUBLE NUMMARK NUMBER …………
解决办法,使用expdp/impdp代替exp/imp
[oracle@app73 ~]$ expdp system/manager dumpfile=exp.dmp tables=CHF.T_XIFENFEI directory=exp_dir Export: Release 11.1.0.6.0 - 64bit Production on Wednesday, 14 October, 2015 23:30:38 Copyright (c) 2003, 2007, Oracle. All rights reserved. Connected to: Oracle Database 11g Enterprise Edition Release 11.1.0.6.0 - 64bit Production With the Partitioning, OLAP, Data Mining and Real Application Testing options Starting "SYSTEM"."SYS_EXPORT_TABLE_01":system/******** dumpfile=exp.dmp tables=CHF.T_XIFENFEI directory=exp_dir Estimate in progress using BLOCKS method... Processing object type TABLE_EXPORT/TABLE/TABLE_DATA Total estimation using BLOCKS method: 959 MB Processing object type TABLE_EXPORT/TABLE/TABLE Processing object type TABLE_EXPORT/TABLE/INDEX/INDEX Processing object type TABLE_EXPORT/TABLE/CONSTRAINT/CONSTRAINT Processing object type TABLE_EXPORT/TABLE/INDEX/STATISTICS/INDEX_STATISTICS Processing object type TABLE_EXPORT/TABLE/COMMENT Processing object type TABLE_EXPORT/TABLE/STATISTICS/TABLE_STATISTICS . . exported "CHF"."T_XIFENFEI" 814.7 MB 1601202 rows Master table "SYSTEM"."SYS_EXPORT_TABLE_01" successfully loaded/unloaded ****************************************************************************** Dump file set for SYSTEM.SYS_EXPORT_TABLE_01 is: /tmp/exp.dmp Job "SYSTEM"."SYS_EXPORT_TABLE_01" successfully completed at 23:31:31 [oracle@app101-2 Data]$ impdp system/oracle dumpfile=T_XIFENFEI.dmp tables=CHF.T_XIFENFEI directory=exp_dir Import: Release 11.2.0.4.0 - Production on Wed Oct 14 23:44:35 2015 Copyright (c) 1982, 2011, Oracle and/or its affiliates. All rights reserved. Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production With the Partitioning and Data Mining options Master table "SYSTEM"."SYS_IMPORT_TABLE_01" successfully loaded/unloaded Starting "SYSTEM"."SYS_IMPORT_TABLE_01":system/******** dumpfile=T_XIFENFEI.dmp tables=CHF.T_XIFENFEI directory=exp_dir Processing object type TABLE_EXPORT/TABLE/TABLE Processing object type TABLE_EXPORT/TABLE/TABLE_DATA . . imported "CHF"."T_XIFENFEI" 814.7 MB 1601202 rows Processing object type TABLE_EXPORT/TABLE/INDEX/INDEX Processing object type TABLE_EXPORT/TABLE/CONSTRAINT/CONSTRAINT Processing object type TABLE_EXPORT/TABLE/INDEX/STATISTICS/INDEX_STATISTICS Processing object type TABLE_EXPORT/TABLE/COMMENT Processing object type TABLE_EXPORT/TABLE/STATISTICS/TABLE_STATISTICS Job "SYSTEM"."SYS_IMPORT_TABLE_01" successfully completed at Wed Oct 14 23:45:37 2015 elapsed 0 00:01:02
出现此类错误,也和自己的粗心有关系,没有仔细检查导出日志,另外该问题从10.1.0.2就有了,直到现在才发现,证明知识点欠缺.同样对于binary_float也有一样问题.
具体可以参考:Export Failed Due To EXP-104 Error, Datatype (Binary_double) Is Not Supported [ID 421591.1]