ITPub博客

Problem with WMSYS.WM_CONCAT Function after Upgrading [ID 1300595.1] 修改时间 20-MAY-2011 类型 PROBLEM 状态 PUBLISHED In this Document Symptoms Cause Solution References Applies to: Workspace Manager - Version: 10.2.0.1 to 11.2.0.2 - Release: 10.2 to 11.2Information in this document applies to any platform. Symptoms In releases 10.2.0.5 and 11.2.0.2, creating a view using the WMSYS.WM_CONCAT function

http://yangtingkun.itpub.net/post/468/204487[@more@]

5.10 AIX Minimum Library RequirementsSome versions of AIX 5.3 do not have the latest runtime libraries required by Oracle GoldenGate. Please make sure the following minimums are met: xlC.aix50.rte 10.1.0.0 COMMITTED XL C/C++ Runtime for AIX 5.3 xlC.msg.en_US.rte 10.1.0.0 COMMITTED XL C/C++ Runtime xlC.rte 10.1.0.0 COMMITTED XL C/C++ RuntimeInstalled libraries can be found using the following command from a shell prompt: lslpp -l | g

Cannot Recognize Remote Mapped Drive ORA-09291 [ID 337413.1] 修改时间 30-DEC-2008 类型 PROBLEM 状态 MODERATED In this Document Symptoms Cause Solution 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 10.2.0.1

NON-RAC Database Startup Giving Error ORA-29702 [ID 433310.1] 修改时间 27-JUL-2010 类型 PROBLEM 状态 MODERATED In this Document Symptoms Cause Solution Platforms: 1-914CU; 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.

http://space.itpub.net/11517198/viewspace-606403^H不是H键的意思，是backspaceITPUB个人空间zD$yS*z5+r5F主要是当你的终端backspace有问题的时候才需要设置a/d7D
U1?0ITPUB个人空间4o8O;AJ+k在linux环境下使用sqlplus，在回删（backspace）时往往会出现 一串的乱码。出现乱码是由于oracle的sqlplus不使用gnu的readline库造成的。 解决方法有两种： 1。要使用回删键（backspace）时，同时按住ctrl键 2。设定环境变量 在bash下：$ stty erase ^?或者把 stty erase ^? 添加到.bash_profile中。 在csh下：$ stty erase ^H或者把 st

进入命令rman target / 报错如下：恢复管理器: Release 10.2.0.1.0 - Production on 星期六 6月 18 02:18:23 2011Copyright (c) 1982, 2005, Oracle. All rights reserved.RMAN-00571: ===========================================================RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============RMAN-00571: ===========================================================RMAN-00554: 内部恢复管理器程序包初始化失败RMAN-04005: 目标数据库中存在错误: ORA-12560: TNS: 协议适配器错误这是在bat脚本中运行的

ITAA红火(244298220) 10:44:15增加LVM有两种方法的，如VG有剩余可直接LVRESIZE或LVEXTENDITAA红火(244298220) 10:44:26如没有增加新的PV[@more@]

Thu Jun 16 00:25:30 2011Errors in file /u01/app/oracle/admin/orcl/bdump/orcl_ckpt_151720.trc:ORA-00206: error in writing (block 3, # blocks 1) of control fileORA-00202: control file: '/oradata/orcl/control03.ctl'ORA-27072: File I/O errorIBM AIX RISC System/6000 Error: 78: Connection timed outAdditional information: 10Additional information: 3ORA-00206: error in writing (block 3, # blocks 1) of control fileORA-00202: control file: '/oradata/orcl/control02.ctl'ORA-27072: File I/O errorIBM AIX RISC

OERR: ORA 327 log of thread , physical size less than neede [ID 18386.1] 修改时间 19-JUN-2010 类型 REFERENCE 状态 ARCHIVED Error: ORA 327 Text: log <name> of thread <num>, physical size <num> less than needed <num> -------------------------------------------------------------------------------Cause: A redo log file has shrunk in size. This is usually caused by a computer operator's

Abnormal Program Termination When Trying To Install Oracle 10gR2 On MS Windows 2008 64 Bit [ID 783296.1]How to Install Oracle 10.2.0.5 on MS Windows 7 / Windows 2008R2 [ID 1173433.1]Oracle Fail Safe Software Compatibility Matrix - 32-Bit [ID 107487.1]Certification Of MS Windows 2008 R2 For OVD 11g [ID 1149944.1Certification Information for Oracle Database on Microsoft Windows (64-bit) [ID 1307195.1]http://download.oracle.com/docs/cd/B19306_01/install.102/b15681/reqs.htmhttps://support.oracle.com

Compatibility Matrix for Export And Import Between Different Oracle Versions [Video] [ID 132904.1][@more@]

Oracle Database on Unix AIX,HP-UX,Linux,Mac OS X,Solaris,Tru64 Unix Operating Systems Installation and Configuration Requirements Quick Reference (8.0.5 to 11.2) [ID 169706.1][@more@]

本文参考了http://www.oklinux.cn/html/sql/oracle/20080717/58118.html的文章，表示感谢。1.在 /home/oracle目录下，建立startdb文件，文件内容如下：echo "begin to start oracle"lsnrctl startsqlplus / as sysdba @/home/oracle/startdbsqlecho "oracle have started"给startdb执行权限 2. /home/oracle/startdbsql.sql文件，其内容如下：startupexit3.在/etc下建立文件rc.startdb，脚本如下：su - oracle -c "/home/oracle/startdb"4.把启动信息放到/etc/inittab中，使用如下命令：mkitab "start

1.相关sh文件没有x权限2.相关sh文件中，不包含如下的信息：[oracle@leiredhat u01]$ cat job.shexport ORACLE_BASE=/u01/app/oracle export ORACLE_HOME=/u01/app/oracle/oracle/product/10.2.0/db_1PATH=/u01/app/oracle/oracle/product/10.2.0/db_1/bin:$PATHexport PATHexport ORACLE_SID=leifs/u01/app/oracle/oracle/product/10.2.0/db_1/bin/sqlplus system/aaaaaa @/u01/job.sql >> /u01/log_job.log注意：1.要求3个环境变量都要出现：ORACLE_BASE，ORACLE_HOME，ORACLE_SID2.要求使用绝对路径，不要使用相对路径或者环境变

存储过程中遇到ora-00942表或视图不存在SQL> create or replace procedure system.opt is 2 begin 3 insert into system.fga_log_view_bak( 4 SESSION_ID , 5 TSMP , 6 DB_USER , 7 OS_USER , 8 USERHOST , 9 CLIENT_ID , 10 ECONTEXT_ID , 11 EXT_NAME , 12 OBJECT_SCHEMA , 13 OBJECT_NAME , 14 POLICY_NAME , 15 SCN , 16 SQL_TEXT , 17 SQL_BIND

windows 下 asm存储，单实例，是我笔记本上的测试环境。几个月不用asm上的oracle了，现在启动不了。C:Documents and SettingsAdministrator>sc query OracleCSServiceSERVICE_NAME: OracleCSServiceTYPE : 10 WIN32_OWN_PROCESSSTATE : 2 START_PENDING(STOPPABLE, PAUSABLE, ACCEPTS_SHUTDOWN)WIN32_EXIT_CODE : 0 (0x0)SERVICE_EXIT_CODE : 0 (0x0)CHECKPOINT : 0x5b8WAIT_HINT : 0x3e8在帖子http://ms.itpub.net/redirect.php?fid=2&tid=1174616&goto=nextnewset 的提示下，解决了这个问题。D:oracleproduct10.2.0db_1BIN&g

修改时间 25-MAR-2011 类型 ANNOUNCEMENT 状态 PUBLISHED In this Document What is being announced? What do you need to do? Documentation: FAQ: Applies to: Management Pack for Oracle GoldenGate - Version: 2.0.0.0 and later [Release: 2.0 and later ]Information in this document applies to any platform. What is being announced? This includes references to documentation and the most commonly accessed Notes: What do

http://download.oracle.com/docs/cd/B19306_01/server.102/b14226/repunicode.htm#i11177Column Length Semantics for Replication Sites and Table Columns Column length semantics determine whether the length of a column is specified in bytes or in characters. You use BYTE to specify that the length is in bytes, and you use CHAR to specify that the length is in characters. CHAR length semantics is also known as codepoint length semantics. Because some character sets require more than one byte for ea

以下摘自goldengate v11.1.1 reference 第324页：Using COLMAPUse COLMAP to explicitly map source columns to target columns that have different namesor to specify default column mapping when source and target names are identical. COLMAPprovides instructions for selecting, translating, and moving column data. Do not use thisoption for tables being processed in pass-through mode by a data-pump Extract group.NOTE To create global rules for column mapping across all tables in subsequent TABLEstatements,