ITPub博客

[2013-10-30 15:22:55] OPatch invoked as follows: 'apply '[2013-10-30 15:22:58] Oracle 主目录 : C:OBI1Oracle_BI1 主产品清单: C:Program FilesOracleInventory 从 : n/a OPatch 版本 : 11.1.0.9.0 OUI 版本 : 11.1.0.9.0 OUI 位置 : C:OBI1Oracle_BI1oui 日志文件位置 : C:OBI1Oracle_BI1cfgtoollogso

Applies to: Business Intelligence Suite Enterprise Edition - Version 11.1.1.3.0 [1905] and laterBusiness Intelligence Server Enterprise Edition - Version 11.1.1.3.0 [1905] and laterBusiness Intelligence Reporting and Publishing Option - Version 11.1.1.3.0 [1905] and laterBusiness Intelligence Interactive Dashboard - Version 11.1.1.3.0 [1905] and laterInformation in this document applies to any platform.[@more@]SymptomsUsing a report with a column selector view results in the following message:IN

deploying an new rpd !!![@more@]Goto the weblogic EM console:Expand 'Business Intelligence' node on the left and choose Coreapplication.Now click on the Deployment tab on the right. Next, go to the Repository tab.Click on 'Lock and Edit Configuration' to enable you to change the default settings.Select the RPD you want to use:Enter ther RPD passwords and press update:Press Apply:You might see a name change:Click on Activate Changes:Click on top of the page on link „Restart to apply recent

MYSQL = (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=localhost)(PORT=1521))(CONNECT_DATA=(SID=MYSQL)) (HS=OK))CREATE DATABASE LINK mysqlCONNECT TO "my_user" IDENTIFIED BY "my_password"USING 'mysql';[@more@]Oracle MigrationGood guide to identifying differences Schema Data Objects ApplicationMySQL Migration Toolkit- Does- Tables/Views- Data- Does Not (yet)- Sequences- Stored Procedures- TriggersOracle Migration - SchemaCase Sensitive Table Names&#61

环境描述： 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

[root@node1 bin]# ./ndo2db-3x -c ../etc/ndo2db.cfgCould not bind socket: Address already in use[root@node1 bin]# 解决方式:rm /nagios/var/ndo.sock重新启，OK！[@more@]

Quickest way to get going would be to use rpm2cpio rpm2cpio package.rpm > package.cpio cpio -idumv < package.cpio That last op will create a tree containing folders and files that come with the package. You could do a dry run in /tmp and copy everything into place, or, alternatively (and might I add, at your own risk) run it in "/" so that the files are copied into the correct locations. You might also need to add any custom library paths to /etc/ld.so.[d |

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

GPFS is IBM’s high-performance parallel, scalable file system for IBM UNIX clusters capable of supporting multi-terabytes of storage within a single file system.GPFS is a shared-disk file system where every cluster node can have parallel, concurrent read/write access to the same file.It is designed to provide high-performance I/O by "striping" data across multiple disks accessed from multiple servers.GPFS provides high availability through logging and replication, and can be configure

GPFS V3.4 Concepts, Planning, and Installation GuideGA76-0413-04[@more@] When utilizing GPFS™ with Oracle, configuration and tuning considerations include: When setting up your LUNs, it is important to create the NSD such that they map one to one with a LUN that is a single RAID device. For file systems holding large Oracle databases, set the GPFS file system block size through the mmcrfs command using the -B option, to a large value: 512 KB is generally suggested. 256

环境：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

解决：ls | xargs -n 50 rm -fr lsxargs就是将ls的输出，每10个为一组(以空格为分隔符)，作为rm -rf的参数也就是说将所有文件名50个为一组，由rm -rf删除[@more@]

环境：DELL R900 RedHat linux 5.6 64bitORACLE 10GR2在系统断电重启后发现存储上的iscsi卷没有自动挂载 [@more@] 解决步骤如下：首先是查看物理卷是否已经发现：[root@appdb-test oracle]# pvs PV VG Fmt Attr PSize PFree /dev/sdc test_volum lvm2 a- 1.09T 87.93G[root@appdb-test oracle]# 通过以上可以正确发现我之前创建的PV。继续查看我们的逻辑组是否被发现：[root@appdb-test oracle]# vgs -v Finding all volume groups Finding volume group "test_volum" VG Attr

环境介绍：power desiger 12.5今天开发组的问我说，关于使用power desiger修改某个表的name后，相应的code也会自动进行更改，找了许久也没有什么地方可以设置为不自动关联的，这个自动关联的方式确实很影响我们日常的使用，有时候我们想将name改为中文，code列继续保留原来的编码，我们不可能把每个列都一一打开来改的，其实通过设置以下参数就可以达到很好的效果的：[@more@]选择工具栏的：TOOL > General Options > Dialog 将里面的Nmae to Code mirroring前面的勾选去掉就可以了。