Install 10.2.0.1 Makefile \'$ORACLE_HOME/sysman/lib/ins_emdb.mk\'-957982.1-rongshiyuan-ITPUB博客StartFragmentInstall Of 10.2.0.1 On SLES 11 X86-64: Error In Invoking Target 'Collector' Of Makefile '$ORACLE_HOME/sysman/lib/ins_emdb.mk' [ID 957982.1]In this Document  Symptoms Cause Solution References Applies to:Oracle Server – Enterprise Edition – Version 10.2.0.1 to 10.2.0.1 [Release 10.2]SUSE \ UnitedLinux x86-64Linux x86-64***Checked for relevance on 23-Nov-2012*** Symptoms The installation process of 10.2.0.1 RDBMS software on SLES 11 x86_64 ...继续阅读 (55)

MDATA v408_1,此版本修复了在unload 含有lob字段表的时候，unload提示有错误信息。下载地址:http://pan.baidu.com/s/1pL8CQ19 ...继续阅读 (16)

手工删除归档后 如何crosscheck RAC 单节点的归档StartFragmentRMAN使用crosscheck archivelog all注意;RAC环境当归档目录在本地的情况下，在一个节点crosscheck archivelog all会把另外一个节点的日志验证failed，然后delete expired archivelog all 则会将RMAN中这些日志的信息清除导致备份的时候不会备份这些日志，却不报错。而实际情况是这些归档是存在的。RMAN>  crosscheck archivelog all;RMAN> delete expired archivelog all; 会把另一节点实际存在的归档标识为无效并删除 可以使用：RMAN> CROSSCHECK ARCHIVELOG like '/arch1/%'; 只检查单节点的归档这样就不会误删除 另一节点的归档。EndFragment ...继续阅读 (22)

MDATA v4.0.8下载地址:http://pan.baidu.com/s/1qWZaJWo使用时，请先到 www.dataunload.net 注册用户，将论坛用户名和特征码(feature code)发到我们邮箱，我们会把license及时推送给你。Email:feigigi@qq.com,564439763@qq.comcase:[oracle@12c mdata]$ ./mdata.shMDATA for oracle 9I,10G,11G,12C release 4.0.8(@)copyright LUDATOU,HC all rights reserved.Web:www.ludatou.com,www.hcdba.comEmail:feigigi@qq.com,564439763@qq.comQQ group:66809572loading default config…….This  license will expire on Jun-17-2016load config file 'config.txt' successfulloading default asm disk file ……start loading default control file … ...继续阅读 (58)

SQL> set long 999999999SQL> select dbms_flashback.get_system_change_number from dual;GET_SYSTEM_CHANGE_NUMBER————————              1.4843E+13SQL>set numw 15 SQL> /GET_SYSTEM_CHANGE_NUMBER————————          14842696548490 ...继续阅读 (20)

数据库安装An unexpected error has been detected by HotSpot Virtual Machine[oracle@rac1 database]$ ./runInstallerStarting Oracle Universal Installer…Checking Temp space: must be greater than 120 MB.   Actual 14636 MB    PassedChecking swap space: must be greater than 150 MB.   Actual 15998 MB    PassedChecking monitor: must be configured to display at least 256 colors.    Actual 16777216    PassedPreparing to launch Oracle Universal Installer from /tmp/OraInstall2013-05-13_01-59-34PM. Please wait …[oracle@rac ...继续阅读 (13)

ORA-00600 [2662] , 怎么计算 adjust SCN 通常我们对于ORA-600 [2662]错误的解决是通过10015 ADJUST_SCN事件来增进current SCN以达到比数据文件中最大的SCN还要大的目的，这样才可能启动数据库。如下例子中报错信息如下：ORA-00600: internal error code, arguments: [2662], [0], [547743994], [0], [898092653], [8388617], [], []这个报错参数的含义在metalink中如此描述的：Arg [a] Current SCN WRAPArg [b] Current SCN BASEArg [c] dependent SCN WRAP为了存储更大的SCN值，当SCN BASE到足够大并开始重置的时候，SCN WRAP将加1。Arg [d] dependent SCN BASEArg [e] Where present this is the DBA where the dependent SCN came from.也就是Arg [d] 的值是从哪个block中找到的，通常是一个data block address。通过这几个参数根据一定的规则可以计算出我们需要的level。计算规则如下：1.Arg [c] *4得出一个数值，假 ...继续阅读 (6)

 MDATA 4.0.7 发布，修复了asm读取的bug,并提供特征码注册，特征码类似如下:R4CJ355T 启动mdata，会有如下提示信息，Web:www.ludatou.com,www.hcdba.comEmail:feigigi@qq.com,564439763@qq.comQQ group:66809572loading default config…….The license is invalid,please check license is valid in mdata.key,feature code:R4CJ355TMDATA has expired,please contact ludatou or hc!提供特征码到我或ludatou的邮箱，我们会把注册码回复到您的邮箱。最后请将注册码更新在安装目录的mdata.key里面即可使用。MDATA 4.0.7 下载地址:http://pan.baidu.com/s/1ntUcPtv ...继续阅读 (24)

下载了mysql-advanced-5.7.9-winx64.zip，在win7 x64安装，解压到D:\mysql5.7.9 目录:解压后如下: D:\mysql5.7.9 的目录2015/11/19  23:15    <DIR>          .2015/11/19  23:15    <DIR>          ..2015/11/19  22:56    <DIR>          bin2015/11/20  00:59    <DIR>          data2015/11/19  22:56    <DIR>          docs2015/11/19  22:56    <DIR>         &nbs ...继续阅读 (174)

最近遇到一客户，数据库存储出问题，redo出问题，很多时候使用隐含参数_ALLOW_RESETLOGS_CORRUPTION后resetlogs打开数据库,我们可能会由于SCN不一致而遭遇到ORA-00600 2662号错误。错误现象:数据库版本10.2.0.1Sun Dec 11 18:02:25 2005 Errors in file /opt/oracle/admin/conner/udump/conner_ora_13349.trc:ORA-00600: internal error code, arguments: [2662], [0], [547743994], [0], [898092653], [8388617], [], []Sun Dec 11 18:02:27 2005 Errors in file /opt/oracle/admin/conner/udump/conner_ora_13349.trc:ORA-00600: internal error code, arguments: [2662], [0], [547743994], [0], [898092653], [8388617], [], []Sun Dec 11 18:02:27 2005 Error 600 happened during db open, shutting down dat ...继续阅读 (18)

故障现象:应用报告入库慢，处理步骤:1.检查数据库等待事件，发现全表扫描比较多；2.检查此事件对应的SQL,发现都是在Insert同一张表；3.检查此表的segment，发现此表是个分区表，此表总数据量才5W条，居然一个分区就占用了200M空间，而且此表没有大字段； 分析来看，表上肯定碎片多，和应用确认也是，他们经常delete.这里也就清晰了解决方法，可以对表move，或重建表，将数据导入，是表空间更紧凑。我这里采用的是简单的move来实现:alter table  t_alarm_state move partition T_ALARM_STATE1 move tablespace users;alter table  t_alarm_state move partition T_ALARM_STATE2 move tablespace users;alter table  t_alarm_state move partition T_ALARM_STATE3 move tablespace users;alter table  t_alarm_state move partition T_ALARM_STATE4 move tablespace users;alter table  t_alarm_state mov ...继续阅读 (52)

exp 导出的文件太大，imp导入某几张表时，会有很长的时间在定位表位置，看着为假死(hang)情况。在我遇到的情况:dmp 文件有450G,大概等了50分钟才开始执行导入table显示。nohup imp system/sys  fromuser=UCR_GZ touser=UCR_GZ file=/backup/recover/TG_CDR_01.dmp log=/backup/recover/TG_CDR_01.log commit=y feedback=10000 ignore=y buffer=1024000000 &Import: Release 10.2.0.1.0 – Production on Tue Oct 13 22:10:22 2015Copyright (c) 1982, 2005, Oracle.  All rights reserved.Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 – 64bit ProductionWith the Partitioning, OLAP and Data Mining optionsExport file created by EXPORT:V10. ...继续阅读 (16)

环境介绍:11g, linux 11.2.0.11. 检查数据库alert日志；Thu Aug 27 10:28:12 2015ALTER DATABASE OPENErrors in file /oracle/diag/rdbms/testoa/testoa/trace/testoa_dbw0_6392.trc:ORA-01157: cannot identify/lock data file 3 – see DBWR trace fileORA-01110: data file 3: '/oracle/oradata/testoa/undotbs01.dbf'ORA-27037: unable to obtain file statusLinux-x86_64 Error: 2: No such file or directoryAdditional information: 3Errors in file /oracle/diag/rdbms/testoa/testoa/trace/testoa_ora_6418.trc:ORA-01157: cannot identify/lock data file 3 – see DBWR trace fileORA-01110: data file 3: '/oracle/oradata/testoa/undo ...继续阅读 (34)

启动监听程序出现错误 TNS:permission denied1、启动[oracle@test admin]$ lsnrctl startLSNRCTL for Linux: Version 10.2.0.1.0 – Production on 16-JUL-2009 17:40:44Copyright (c) 1991, 2005, Oracle. All rights reserved.Starting /u01/app/oracle/product/10.2.0/db_1/bin/tnslsnr: please wait…TNSLSNR for Linux: Version 10.2.0.1.0 – ProductionSystem parameter file is /u01/app/oracle/product/10.2.0/db_1/network/admin/listener.oraLog messages written to /u01/app/oracle/product/10.2.0/db_1/network/log/listener.logListening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=test)(PORT=1521)))Error listening on: ...继续阅读 (44)

WRH$_ACTIVE_SESSION_HISTORY Does Not Get Purged Based Upon the Retention Policy (文档 ID 387914.1)转到底部class=km before in this document markerIn this Document Symptoms Cause Solution Community Discussions References This document is being delivered to you via Oracle Support's Rapid Visibility (RaV) process and therefore has not been subject to an independent technical review.class=km before applies toApplies to:Oracle Database – Enterprise Edition – Version 10.2.0.1 and laterInformation in this document applies to any platform.***Checked for relevance on 25-Apr-2014*** SymptomsAWR tab ...继续阅读 (42)

环境: aix 6.1 oracle 10.2.0.4故障现象:数据库遭遇600[ktecgeb-2],open一会自动宕掉。alert日志如下:SMON encountered 8 out of maximum 100 non-fatal internal errors.Tue Jul 21 14:31:32 2015Errors in file /oracle/app/admin/gzzhjs/bdump/gzzhjs_smon_7406000.trc:ORA-00600: internal error code, arguments: [ktecgeb-2], [603979776], [0], [], [], [], [], []Tue Jul 21 14:31:35 2015Errors in file /oracle/app/admin/gzzhjs/bdump/gzzhjs_pmon_20971898.trc:ORA-00474: SMON process terminated with errorTue Jul 21 14:31:35 2015PMON: terminating instance due to error 474Instance terminated by PMON, pid = 20971898解决办法:Ora-00600: Internal Er ...继续阅读 (16)

9876 文档 ID… Applying Patch or Patchset Fails with 'xlC: not found' on File 'genoccish' (文档 ID 558292.1)转到底部In this Document Symptoms Changes Cause Solution References This document is being delivered to you via Oracle Support's Rapid Visibility (RaV) process and therefore has not been subject to an independent technical review. Applies to:Oracle Server – Enterprise Edition – Version: 9.2.0.1 to 11.1.0.6 – Release: 9.2 to 11.1IBM AIX on POWER Systems (64-bit)AIX5L Based Systems (64-bit)This problem will affect 9.2, 10.2 and 11g when applying any one off pat ...继续阅读 (93)

在AIX中安装Oracle时出现OUI 10038提示错误 OUI-10038:You do not have the necessary permissions to write to the inventory at /neworacle/product/oralnventory.Please make sure that you have the appropriate permissions to perform the installation. 我们只要将/etc/oraInst.loc这个文件修改成实际目录或删除它。再运行安装程序就可以了 ...继续阅读 (73)

在使用IMPDP导入部分用户的数据时,在导入工作的最后阶段遇到了ORA-39083错误,错误描述如下(job未导入):一. 问题描述……ORA-39083: Object type REFRESH_GROUP failed to create with error:ORA-23421: job number 141 is not a job in the job queueFailing sql is:BEGIN dbms_refresh.make('"VAS"."MVIEW_VAS_SP_DIALTEST"',list=>null,next_date=>null,interval=>null,implicit_destroy=>TRUE,lax=>FALSE,job=>141,rollback_seg=>NULL,push_deferred_rpc=>TRUE,refresh_after_errors=>FALSE,purge_option => 1,parallelism => 0,heap_size => 0);dbms_refresh.add(name=>'"VAS"."MVIEW_VAS_SP_DIALTEST"',list=>'"VAS"."MVIEW_VAS_SP_DIALTEST"',siteid=>0,expoJob "SYSTEM"."S ...继续阅读 (262)

数据库版本为11.2.0.1 ，遇到导入报错:impdp时发生job stopped due to fatal error检查alert日志，发现如下错误:Sun Jun 21 15:48:44 2015Exception [type: SIGSEGV, Address not mapped to object] [ADDR:0x10] [PC:0x643F8F4, kupfuDecompress()+2088] [flags: 0x0, count: 1]Errors in file /opt/oracle/diag/rdbms/orcl/orcl/trace/orcl_dw00_28637.trc (incident=32769):ORA-07445: exception encountered: core dump [kupfuDecompress()+2088] [SIGSEGV] [ADDR:0x10] [PC:0x643F8F4] [Address not mapped to object] []Incident details in: /opt/oracle/diag/rdbms/orcl/orcl/incident/incdir_32769/orcl_dw00_28637_i32769.trc查看metalik，发现如下bug：Bug 9395500 Dump [ ...继续阅读 (250)

DECLAREsqlStr VARCHAR2(2000); –拼写sqlflag int; –判断是否存在col_name VARCHAR2(100); –字段名字tab_name VARCHAR2(100); –表名col_type VARCHAR2(100); –表名operator_str VARCHAR2(100) := '=';FindUser VARCHAR2(50) := 'HC'; –要查找的用户FindValues VARCHAR2(50) := '陈'; –**要查找的值Findtype1 VARCHAR2(50) := 'VARCHAR2'; –要查找的值类型 数字类型特殊处理Findtype2 VARCHAR2(50) := 'CHAR'; –要查找的值类型Findtype3 VARCHAR2(50) := 'VARCHAR'; –要查找的值类型isLike boolean := true; –是否模糊查找cursor cur is –定义游标select *from all_tab_columns awhere a.OWN ...继续阅读 (25)

asmca创建磁盘时发现不了磁盘，11.2.0.3却正常。磁盘属性这些都正常。# bootinfo -s hdisk101048576磁盘大小为1T。检查metalink，发现11.2.0.2有如下bug：SQL> create diskgroup datadg external redundancy disk '/dev/rhdisk26';create diskgroup datadg external redundancy disk '/dev/rhdisk26'*ERROR at line 1:ORA-15018: diskgroup cannot be createdORA-15099: disk '/dev/rhdisk26' is larger than maximum size of 2097152 MBs# bootinfo -s hdisk101048576bug :Bug 10072750 AIX: ASM sees 1 TB disks as larger than their actual size (ORA-15099)This note gives a brief overview of bug 10072750.The content was last updated on: 28-JUN-2013Clickherefor details of ea ...继续阅读 (46)

deferred_segment_creation 延迟段创建是11.2的新特性， 当创建一个 空表或者空分区时，实际的表段table segment被延迟到第一行数据插入的时候。该功能通过DEFERRED_SEGMENT_CREATION参数启用，默认为TRUE.由DEFERRED_SEGMENT_CREATION启用的新的空间分配方式的优势在于：若系统安装后存在大量空表，而这些空表将从不会加载任何数据；假设一个空表占用64k(db_block_size=8,一个extent)的空间，则若存在一万张这样的空表就要消耗625M的空间当应用程序初次安装需要创建大量空表时，因为延迟了数据段创建的过程，所以可以节约大量时间当向这些空表或者空分区插入第一行数据时，对应的表、LOb字段和索引的segment段会被创建。—-下面说说重点，批量让空表可以导出：select 'alter table '||A.OWNER||'.'||a.TABLE_NAME||' allocate extent(size 1m);'from dba_tables awhere a.segment_created = 'NO'AND A.OWNER NOT IN ('SYS','DBSNMP','WMSYS','APPQOSSYS','CTXSYS','MDSYS','OLAPSYS','SYSMAN' ...继续阅读 (31)

Applies to:Oracle Database – Enterprise Edition – Version 9.2.0.1 and laterInformation in this document applies to any platform.SymptomsThis document provides the various queries that can be used to monitor Undo space usage.The Undo Space once allocated wont be deallocated to the OS, by default. But the space can be reused by other transactions once the UNDO_RETENION (or TUNED_UNDORETENTION period) is met.CauseNoneSolution1. To check the current size of the Undo tablespace:select sum(a.bytes) as undo_size from v$datafile a, v$tablespace b, dba_tablespaces c where c.contents = 'undo ...继续阅读 (15)

在使用ctas表时，源表的默认表的default属性和约束都不会传递:CTAS中只能够将表的列的结构、列名、数据类型、可选的行记录、单独创建的非空索引才能够传递到新表中，其他的都不包括。千万注意了…… ...继续阅读 (28)

RMAN脚本的开始一段内容如下：#!/bin/kshexport LANG=en_USBACKUP_DATE=`date +%d`RMAN_LOG_FILE=${0}.outTODAY=`date`USER=`id|cut -d "(" -f2|cut -d")" -f1`echo"—————–$TODAY——————-">$RMAN_LOG_FILEORACLE_HOME=/u01/app/oracle/11.2.0/db_1export ORACLE_HOMERMAN=$ORACLE_HOME/bin/rmanexport RMAN错误提示的第二行也只是一个大概范围，我们这里报错，是因为$RMAN_LOG_FILE变量来自shell变量$0，使用了相对路径，而有些版本rman不支持相对路径，因此执行时报错。解决方法是给$RMAN_LOG_FILE予绝对路径：将：RMAN_LOG_FILE=${0}.out修改成：RMAN_LOG_FILE=`pwd`/${0}.out再次执行就ok了。 ...继续阅读 (9)

现象:pl/sql 8,pl/sql 10都遇到了上述问题，处理办法:把PL/SQL版本提高到11.0，故障解决，pl sql developer真是坑爹哟。还得装11g client哟，别忘了。不然要报错。这个案例也提醒我们要用就用最新的，^_^ ...继续阅读 (73)

Assuming Following Scenario'sScenario 1 :- Database was shutdown immediate. Startup gives redo log corruption .Since database was shutdown immediate. All files are in synch and donot need recovery. In this case you can do the following :-SQL>Startup mount ;SQL>recover database using backup controlfile until cancel ;Type cancel ;SQL>Alter database open resetlogs ;The resetlogs would reset the sequence number and recreate the redo logsScenario 2 :- Inactive redo log group has got Corrrupt . Redo log not multiplexedSQL>Select * from v$log ;Find the status of the groupIf its Inactive . So you c ...继续阅读 (20)