ITPub博客

............[@more@]''Sbt Error = 7011, Errno = 959'' Error When Backing Up To Tape Doc ID: Note:377512.1 Type: PROBLEM Last Revision Date: 09-JAN-2007 Status: PUBLISHED In this Document Symptoms Cause Solution References -------------------------------------------------------------------------------- Applies to: Oracle Server - Enterprise Edition - Version: 9.2 to 10.2 This problem can occur on any platform. SymptomsAllocate channel using RMAN and Tivoli TDP version 5.2 is getting RMAN-03009 OR

....[@more@]http://orafaq.com/parms/index1020.htm

...................[@more@]Re: Oracle 10.2.0.2 and TOAD brings ORA-600 by Ronald Breuer Mar 17, 2006; 05:13pm :: Rate this Message: (use ratings to moderate[?])Reply | Reply to Author | View this Message in the Context of Discussion Hello John, I guess there are a lot of problems switching the Data Dictionary from RBO to CBO. There are a lot of Hidden Parameters starting with "_optimizer" in 20.2. See: http://www.orafaq.com/parms/index1020.htm If you search in MeataLink you will fi

.............[@more@]Subject: Ora-600 [15160] Joining Dba_objects and Dba_segments Doc ID: Note:351092.1Type: PROBLEM Last Revision Date: 14-AUG-2006Status: PUBLISHEDIn this Document Symptoms Cause Solution ReferencesApplies to: Oracle Server - Enterprise Edition - Version: 10.1 to 10.2This problem can occur on any platform.SymptomsThe following internal error is reported: ORA-600 [15160] JOINING DBA_OBJECTS AND DBA_SEGMENTSCurrent SQL statement for this session is: SELECT o.owner, o.obje

...[@more@]ORA-19511: Error received from media manager layer, error text: ANS0322E (RC-72) no text available for this return code. Technote (FAQ) Problem LAN-free backups from Data Protection for Oracle fail. The first one is successful and any subsequent ones fail. Here are the full error messages generated : RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS =============== RMAN-00571: =========================================================== RMAN-03002: failure of restore command at 0

今天在自己的PC 上安装一个ORACLE 10G ,给了最少的内存,结果,在创建库最后了报了如下的错误,后来增加了部分SGA ,再安装就成功了C:Documents and Settingsibm>dbcaERROR :oracle.sysman.assistants.util.sqlEngine.SQLFatalErrorException: ORA-04031: 无法分配 540 字节的共享内存 ("shared pool","declare[@more@]

最早参考了http://www.dbanotes.net/ 中相关文件[@more@]Oracle 10g 关于 NLS 的环境变量发生了一点变化:For RDBMS 7.2.x version the variable is called ORA_NLS. For version 7.3.x the variable is called ORA_NLS32.For Oracle 8, 8i and 9 variable is called ORA_NLS33.For Oracle 10g the variable is called ORA_NLS10.ORA_NLS33 的设置值:ORA_NLS33 = $ORACLE_HOME/ocommon/nls/admin/data而 ORA_NLS10 只需要设置:ORA_NLS10 = $ORACLE_HOME/nls/data定义了 ORA_NLS10 则不需要单独定义 ORA_NLS33 等参数了。目前应该仍然是向后

10g,无论怎么该LOG_BUFFER ,都是保持14242816,估计是BUG 10g,中用了自动内存管理,在INIT.ORA 文件手动设置了LOG_BUFFER = 4194304 ,但不关是去掉哪个参数,还是加上,DB 启动以后看到的结果都是14242816..我已经提交给METALINK 了,已经3天了,他们一直在"Work in process" .感觉是BUG 的可能性很大..[@more@]Subject: The Log_buffer Cannot be Changed In 10g R2 Doc ID: Note:351857.1Type: PROBLEM Last Revision Date: 14-MAR-2006Status: MODERATEDIn this Document Symptoms Cause Solution ReferencesThis document is

..............[@more@]Subject: Alert Log Messages: Private Strand Flush Not Complete Doc ID: Note:372557.1Type: PROBLEM Last Revision Date: 07-JUN-2006Status: MODERATEDIn this Document Symptoms Cause SolutionThis document is being delivered to you via Oracle Support's Rapid Visibility (RaV) Rapid Visibility (RaV) process, and therefore has not been subject to an independent technical review.Applies to: Oracle Server - Enterprise Edition - Version: 10.2.0.2.0This problem can occur on any platf

收藏[@more@]关于Oracle10g - Private Strand Flush Not Complete今天抽空做了一下Oracle 10gR2的Data Guard测试，结果在Alert Log中发现了“Private Strand Flush Not Complete”信息，感觉有点怪。 先描述一下系统环境，1>服务器 IBM p55A上的两个LAPR# oslevel -s5300-04-00 2>数据库 Oracle 10gR2SQL> select * from v$version;BANNER----------------------------------------------------------------Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - 64biPL/SQL Release 10.2.0.1.0 - ProductionCORE 10.

今天发现ALERT.LOG 中一些莫名其妙的信息,于是发TAR 给ORACLE ,终于明白了什么原因了The meaning of alert.log entries:HS: Created new FDS class definition in server DDHS: Class id = 21, class name = ODBC10.1.0.4.0_177HS: Created new FDS class definition in server DDHS: Class id = 22, class name = ODBCHS: Created new FDS instance definition in server DDHS: Instance id = 1, instance name = DB2 (class ODBC10.1.0.4.0_177)HS: Error in server DD access for FDS capabilitiesFri Jan 26 17:00:06 2007HS: Created

.....[@more@]Connections that Used to Work in Oracle 10.1 Now Intermittently Fail with ORA-3113,ORA-3106 or ORA-3136 in 10.2 Doc ID: Note:345197.1Type: PROBLEM Last Revision Date: 20-NOV-2006Status: PUBLISHEDIn this Document Symptoms Cause SolutionApplies to: Oracle Net Services - Version: 10.2.0.1.0This problem can occur on any platform.SymptomsThe Oracle Net 10g parameters SQLNET.INBOUND_CONNECT_TIMEOUT and INBOUND_CONNECT_TIMEOUT_listenername default to 0 (indefinite) in 10.1. To address

...[@more@]Subject: Repca: Error -Sqlexception On Getting Sid And Systemname Information Doc ID: Note:388445.1Type: PROBLEM Last Revision Date: 29-JAN-2007Status: MODERATEDIn this Document Symptoms Cause Solution ReferencesThis document is being delivered to you via Oracle Support's Rapid Visibility (RaV) Rapid Visibility (RaV) process, and therefore has not been subject to an independent technical review.Applies to: Oracle Application Server 10g Enterprise Edition - Version: 10.1.2.0.2This

..................[@more@]今天在创建TABLESPACE 时,出现ORA-01144, 好在创建的最大的LV 裸设备为32G ,maximum file size = db_block_size * 4194303Cause: Specified file size is larger than maximum allowable size value.Action: Specify a smaller size.

..........[@more@]在static end to end data load时抛异常：<entry TxnId="20019281" ThreadName="Asynch Thread-10" Time="01/31/2007 00:36:58:421" Level="Exception" ParentTxnId="29822636" Service="E2E" > <msg><![CDATA[Exception in ExecProcCommand: ]]></msg> <stackTrace><![CDATA[java.sql.SQLException: ORA-01536: space quota exceeded for tablespace 'TESTTBS'ORA-06512: at "TEST.START_NET_CHANGE",

....[@more@]1 .昨天更换了PFILE ，忘了增加ARCHIVE 的部分了############################################ Archive###########################################log_archive_dest_1='LOCATION=/testarch2'log_archive_format=%t_%s_%r.dbf2.晚上备份出现如下错误sql statement: alter system archive log currentreleased channel: t1released channel: t2RMAN-00571: ===========================================================RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============RMAN-00571: ==============

.....[@more@]IBM THINKPAD快捷键（FN）用法FN+F3＝关闭屏幕FN+F4＝待机FN+F5＝无线和蓝牙开关FN+F7＝不同显示设备输出切换FN+F9＝安全删除硬件FN+F12＝休眠FN+空格＝放大（其实就是降低分辨率）FN+HOME＝提高亮度FN+END＝降低亮度FN+PgUp＝键盘灯（THINKLIGHT）

.....[@more@]14-DEC-06 05:15:35 GMTHi,There is no patch available for the bug 4483084.You need to Ignore this error, as there is absolutely no impact to the database due to this error.Thanks,Ram14-DEC-06 05:16:03 GMTEmail Update button has been pressed: Sending email to longchun.zhu@gmail.com. 15-DEC-06 06:17:59 GMT.ISSUE CLARIFICATION====================Database closed.Database dismounted.ORA-00600: internal error code, arguments: [LibraryCacheNotEmptyOnClose], [],[], [], [], [], [], []eos (end

...........[@more@]Subject:　 Direct I/O (DIO) and Concurrent I/O (CIO) on AIX 5L Doc ID:　 Note:257338.1 Type:　 BULLETIN 　Last Revision Date:　 13-SEP-2005 Status:　 PUBLISHED PURPOSE-------To discuss the use of Direct I/O (DIO) and Concurrent I/O (CIO) on AIX 5L　SCOPE & APPLICATION-------------------System Administrators managing AIX 5L that has Oracle RDBMS on top.DIRECT I/O (DIO) AND CONCURRENT I/O (CIO) on AIX------------------------------------------------If you use a Journaled Fil

.....[@more@]Starting iSQL*PlusiSQL*Plus is the Web version of SQL*Plus. Before you can connect to it with a URL, you must start the iSQL*Plus application server. To do so, enter the following at the command line:isqlplusctl start After the server is started, you can connect to iSQL*Plus with a URL such ashttp://machine_name:5560/isqlplus