ITPub博客

环境描述： Serve端： Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production PL/SQL Release 11.2.0.3.0 - Production CORE 11.2.0.3.0 Production TNS for Linux: Version 11.2.0.3.0 - Production NLSRTL Version 11.2.0.3.0 - Production Client端: SQL*Plus: Release 10.2.0.1.0 - Production on 星期四 12月 13 10:44:26 2012 Copyright (c) 1982, 2005, Oracle. All rights reserved. 通过PL/SQL连接服务器查询时报：ora-01882错误，错误原因是Client端的time zonesID太旧导致的。

工作中需要根据Oracle某个transaction的ID查找其他的信息，如何获得transaction ID可能也是许多朋友的疑问，在存储加以说明，只需要调用一下过程就可以得到：dbms_transaction.LOCAL_TRANSACTION_IDExample:SQL> delete from isc_$clob;203 rows deletedSQL> select dbms_transaction.LOCAL_TRANSACTION_ID from dual;LOCAL_TRANSACTION_ID--------------------------------------------------------------------------------10.3.501549[@more@]

在oracle11gR2里发送邮件的时候报错：ORA-24247: 网络访问被访问控制列表 (ACL) 拒绝ORA-06512: 在 "SYS.PROCSENDEMAIL", line 730ORA-06512: 在 "SC.ISC_UTIL", line 452ORA-06512: 在 line 1这是因为Oracle 数据库 11g有一个新的解决方案：您可以将执行权限程序包授予任何人，但要控制他们可以调用的资源。例如，utl_tcp 可限制为仅调用几个 IP地址，这种机制称为访问控制列表 (ACL)。如果主机在 ACL 中，用户可以在 utl_tcp 中使用；但是仅仅拥有对 utl_tcp的执行权限是不够的。因此，恶意进程不可能取代 utl_

OCR File and Voting Disk Administration by Example - (Oracle 10g)by Jeff Hunter, Sr. Database AdministratorContentsOverviewExample ConfigurationAdministering the OCR FileView OCR Configuration InformationAdd an OCR FileRelocate an OCR FileRepair an OCR File on a Local NodeRemove an OCR FileBackup the OCR FileAutomatic OCR BackupsManual OCR ExportsRecover the OCR FileRecover OCR from Valid OCR MirrorRecover OCR from Automatically Generated Physical BackupRecover OCR from an OCR Expor

通过sqlplus 连接RAC，偶尔报：ORA-12545: Connect failed because target host or object does not exist[@more@] 原因是因为local_listener没有设置，分别在两个节点设置local_listener参数问题变可以解决：法一：alter system set LOCAL_LISTENER="(ADDRESS=(PROTOCOL=TCP)(HOST=xxxx)(PORT=1521))" scope=both sid='node1';alter system set LOCAL_LISTENER="(ADDRESS=(PROTOCOL=TCP)(HOST=xxxx)(PORT=1521))" scope=both sid='node2';法二：tnsnames.ora内加入local_listeners=(ADDRESS_LIST=(ADDRESS=(P

环境描述： 需要通过EXPDP将数据备份到远端的cifs设备上,但是在进行备份的时候，写入文件报错：;;;Export: Release 10.2.0.4.0 - 64bit Production on 星期二, 20 3月, 2012 3:30:01 Copyright (c) 2003, 2007, Oracle. All rights reserved.;;;Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bit ProductionWith the Partitioning, OLAP, Data Mining and Real Application Testing optionsORA-39097: Data Pump job encountered unexpected error -31643ORA-39065: unexpected master process ex

You Asked I am seeing that when I use the dbms_mview.refresh function to refresh a group of Materialized Views, that the view contents are deleted. I have also seen that if I set atomic_refresh to False, that Truncate should be used. In reading the description of atomic_refresh indicates whether the group of MV's is refresh together or as independent refreshes. It does not discuss 'Delete' vs 'Truncate'. My situation is that I have several MV's that are quite large and would prefer t

环境介绍：oracle11.2.0.3redhat 5.6 64biterror:Invalid Entry Size[@more@] 再将11.2.0.3的1of7 、2of7解压后安装过程中遇到：Invalid Entry Size错误，查找support后发现是md5变化导致的原因，Got "Invalid Entry Size" Error During Oracle 11.2.0.2 Install On Aix 6.1 [ID 1301113.1]SolutionOnce the Oracle Database file is downloaded from OTN ,Please check the following 1. filesize 2. md5sum or cksum value These two values need to be same as specified in the download page of the part

环境：ORACLE10.2.0.4 64BITREDHAT 5.6 64BITAGENT 11.2.0.1 64BIT打5759944补丁遇到：OPatch failed with error code 73[@more@] 因为公司内使用EM11g作为整体的数据监控平台，所以在agent端agent是11g，而DB是10g所以在opatch的时候调用的是agent的目录，最终导致安装补丁失败：[oracle@bi 5759944]$ ../opatch applyInvoking OPatch 10.2.0.4.2 Oracle Interim Patch Installer version 10.2.0.4.2Copyright (c) 2007, Oracle Corporation. All rights reserved. Oracle Home : /u01/oracle/product/10.2.0/db_1Central

错误描述：oracle 10.2.0.4 64bitredhat5.6 64bit在创建函数完成后调用直接报错：Errors in file /opt/oracle/admin/kebao/udump/kebao_ora_26334.trc:ORA-07445: exception encountered: core dump [_intel_fast_memcpy.A()+10] [SIGSEGV] [Address not mapped to object] [0x000000000] [] []SESSION会话也直接中断。[@more@]通过定义typetype bodyfunction后通过SQL调用新声明的function函数，会话直接关闭，通过查看alert文件发现报以下错误：Errors in file /opt/oracle/admin/kebao/udump/kebao_ora_26334.trc:ORA-07445: exception

在win模式下和在linux下安装AGENT程序稍微有点出入，但总的方式都是使用静默的方式来安装，在linux下只需WGET， wget https://gcem:4900/agent_download/11.1.0.1.0/linux_x64/agentDownload.linux_x64 --no-check-certificate然后再安装：./agentDownload.linux_x64 -b $ORACLE_HOME -m gcem -r 4900 -y最后再执行$AGENT_HOME/root.sh文件即可，但是在WIN下就稍微有点出入，[@more@]在win下，首先要编辑response目录下得additional_agent.rsp文件内的几个参数：因为我不使用安全更新所以对应修改的参数为：SECURITY_UPDATES_VIA_MYORACLE

[oracle@gcem alert]$ adrciADRCI: Release 11.2.0.1.0 - Production on 星期二 10月 11 15:11:08 2011Copyright (c) 1982, 2009, Oracle and/or its affiliates. All rights reserved.ADR base = "/u01/app"adrci> show alert -tail 40 -f ***********************************************************************NI cryptographic checksum mismatch error: 12599.VERSION INFORMATION:TNS for Linux: Version 11.2.0.1.0 - ProductionOracle Bequeath NT Protocol Adapter for Linux: Version 11.2.0.1.0 - ProductionT

[oracle@gcem alert]$ adrciADRCI: Release 11.2.0.1.0 - Production on 星期二 10月 11 15:11:08 2011Copyright (c) 1982, 2009, Oracle and/or its affiliates. All rights reserved.ADR base = "/u01/app"adrci> show alert -tail 40 -f ***********************************************************************NI cryptographic checksum mismatch error: 12599.VERSION INFORMATION:TNS for Linux: Version 11.2.0.1.0 - ProductionOracle Bequeath NT Protocol Adapter for Linux: Version 11.2.0.1.0 - ProductionT

环境介绍：oracle GC11G 64BITORACLE LINUX 5.6 64BITMYSQL mysql Ver 14.14 Distrib 5.5.9, for Linux (x86_64) using readline 5.1ERROR:CS 10.2<MetricColl><String> 5mysql<String> 8qqsmysql<String> 8Response<String> 8Response<String> 192011-09-16 16:30:26<String> 166em_error=#28000Access denied for user 'root'@'qqdb.domain' (using password: NO) at /u01/app/10.2.1/db_1/agent11g/sysman/admin/scripts/emx/mysql/mysql_oem.pm line 45[@more@]今天需要将mysql添加到GC的监

环境：oracle OEM GC 11GOLX 5.6 64BIT在一台host上安装好AGENT后，发现不能在“目标”页签内不能发现新加的host，其他数据库、监听一切正常。[@more@]解决方式：再新安装的HOST机器上修改： $AGENT_HOME/sysman/emd/targets.xml文件，修改前：[oracle@qqdb ~]$ cat $AGENT_HOME/sysman/emd/targets.xml<Targets AGENT_TOKEN="6160aa0c6a04a931a68ee4b23ab71e439a9e9b7f"> <Target TYPE="oracle_emd" NAME="qqdb.domain:3872" DISPLAY_NAME="qqdb.domain:3872"/>

Applies to: Enterprise Manager Grid Control - Version: 11.1.0.1 to 11.1.0.1 - Release: 11.1 to 11.1Information in this document applies to any platform.GoalThe Goal of this Document is to provide Steps to Download and Apply Recommended Patch (WDJ7) for 11.1.0.1 Grid Control Installation using Smart Update Tool or using the Offline Method.[@more@]SolutionIt is recommended to apply Patch WDJ7 on WLS home before Installing/Upgrading the Grid control to 11.1.0.1. Release. Note: Make sure that you ha

环境：GRID CENTER 10.2.0.5REDHAT 4 64BITSTAT:在进入安装时对system parameter进行检查，检查hostname不通过[@more@]今天在安装GC的时候，发现GC对于hostname有严格的限定，必须以某种格式而存在，正确的hosts文件应该包含以下两条：127.0.0.1 localhost.localdomain localhost192.168.8.93 gcem.domain gcemgcem是hostname

环境：oracle 10.2.0.1 64bitlinux 5.46bittest env.....error: 今天启动测试库直接报以下错误：[oracle@bogon ~]$ sqlplus / as sysdba SQL*Plus: Release 10.2.0.1.0 - Production on Thu Jul 14 09:57:42 2011 Copyright (c) 1982, 2005, Oracle. All rights reserved. Connected to an idle instance. SQL> startupORA-00600: internal error code, arguments: [keltnfy-ldmInit], [46], [1], [], [], [], [], [][@more@]通过DOC:336447.1,确实是一BUG，主要是因为主机名变动导致的问题，通过修改主机名为原来的问题得以解决.[ora

环境：ORACLE 10.2.0.4 64BITREDHAT 5.4 64BITWAR:ALTER SESSION SET hash_join_enabled specifies an obsolete parameterThu Jun 30 15:44:20 2011ALTER SESSION SET hash_join_enabled specifies an obsolete parameterALTER SYSTEM SET hash_join_enabled specifies an obsolete parameterThu Jun 30 15:44:30 2011ALTER SESSION SET hash_join_enabled specifies an obsolete parameterThu Jun 30 15:45:28 2011[@more@]今天在数据库巡检的时候发现alter文件里输出了许多类似于以下的信息：ALTER SESSION SET hash_join_enabled speci

环境：ORACLE10.2.0.4LINUX 5.4ERROR:Thu Jun 30 13:41:45 2011Process m000 died, see its trace fileThu Jun 30 13:41:45 2011ksvcreate: Process(m000) creation failedThu Jun 30 13:42:22 2011[@more@]今天DEV环境的数据库前台反应不能进行连接，通过查看ALTER文件发现后台报了许多：Thu Jun 30 13:41:45 2011Process m000 died, see its trace fileThu Jun 30 13:41:45 2011ksvcreate: Process(m000) creation failedThu Jun 30 13:42:22 2011metalink给出的解释是资源不足导致的问题，于是查看：select * from v$resource_limit;1