ITPub博客

10.2.0.2 [@more@]基本 Bug5071492修复产品版本无数据问题陈述:ORA-600 [KCLPDC_17] *** 05/25/06 06:39 am *** TAR: ---- SR 5451671.992 . PROBLEM: -------- . Ct gets the following error: ORA-00600: internal error code, arguments: [kclpdc_17], [], [], [], [], . The error is not reproducible and intermittent. . DIAGNOSTIC ANALYSIS: -------------------- . WORKAROUND: ----------- none . RELATED BUGS: ------------- bug 4865820... I found that in SR 5186046.993.. . REPRODUCIBILITY: ---------------- n

朋友问起,找了点相关的资料[@more@]PURPOSE ------- This document is created for use as a guideline and checklist when manually upgrading Oracle 8, Oracle 8i or Oracle 9i to Oracle 9i. This document does not approach the upgrade of specific components. To upgrade specific database components please use the steps described in the migration guide chapter 3 page 3-25 of the Oracle 9.2 Migration guide for Oracle 9.2 and chapter 7 page 7-24 of the oracle 9.0.1 Migration guide. There it is ex

.....[@more@]1 .Database Features-CBO-Database Resource Manager-Partitioned tables-Invoker Rights2. Business Intelligence Features- Meterialized views- Scalablility- RAC

和普通Oracle database 结构基本没什么区别.只注意特殊的地方就可以了[@more@]1. The following code objects are installed in the APPS schema; - packages - procedures - Functions - Triggers - Views - Materialized views The following objects are installed in the base product schemas; - tables - Sequences - Indexes - Constraints Note: Oracle Applications Release 11i requires an Oracle database block size of 8k,No other block szie may be sued

Oracle Appliactions 11i concepts(一) - Application 基本架构(1) http://zhulch.itpub.net/post/17395/279333Oracle Appliactions 11i concepts(一) - Application 基本架构(2) http://zhulch.itpub.net/post/17395/279364Oracle Appliactions 11i concepts(二) - Application File System(1) http://zhulch.itpub.net/post/17395/279382[@more@]注意：没Applications Files 被安装到desktop client 机器上，但JAR FILES 和那些支持的资源被下载过来，还是必要的1. Oracle Applications Environment2. The DATA Directory3. DB and ORA

Oracle Appliactions 11i concepts(一) - Application 基本架构(1) http://zhulch.itpub.net/post/17395/279333Oracle Appliactions 11i concepts(一) - Application 基本架构(2) http://zhulch.itpub.net/post/17395/279364Oracle Appliactions 11i concepts(二) - Application File System(1) http://zhulch.itpub.net/post/17395/279382[@more@]Oracle Appliactions 11i concepts(一) - Application 基本架构(2) 1. Reports Server ArchitectureBrowser - > web listener -> Reprots cgi -> reports server -> reports run

近来项目中的大事已经完全做完,系统也运行正常,所以,富裕时间比较多,乘机把Oracle Applications 11i 的官方文档,再系统的阅读一遍,发现每阅读一遍,都有不同的理解!本章主要介绍Oracle Applications 11i 基本概念中 的Application 基本架构Oracle Appliactions 11i concepts(一) - Application 基本架构(1) http://zhulch.itpub.net/post/17395/279333Oracle Appliactions 11i concepts(一) - Application 基本架构(2) http://zhulch.itpub.net/post/17395/279364Oracle Appliactions 11i concepts(二) - Application File System(1) http:

...[@more@]RAC Connection Redirected To Wrong Host/IP ORA-12545 文档 ID: 注释:364855.1类型: PROBLEM 上次修订日期: 24-JUN-2006状态: 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 Net Services - Version: 9.0.1.4 to 10.2.0.3This problem can occur on any platform.SymptomsWhen we tr

收藏..转帖[@more@]什么是 screen什么是 screen 嗯，从小历史就不好，这里不谈 screen 的历史， screen 是干嘛的？依照它的在线手册（manual pages），它是个全萤幕的视窗管理员（full-screen window manager），不过别紧张，它跟 X-Window 上面的 GNome，AfterStep 等等视窗管理员一点关系也没有。 简单地说，它是个文字界面的 VT100/ANSI 终端模拟器（terminal emulation），如果你玩网络已有一段时间了，那你一定曾经在某 BBS 站注册时，会发现它要你输入你的终端机型别，通常预设就是 VT100 了，所以只要按了 enter 键就可以了，而什么

Bug 5496862[@more@]channel t2: starting piece 1 at 30-MAR-07RMAN-03009: failure of backup command on t1 channel at 03/30/2007 01:23:22ORA-00600: internal error code, arguments: [2103], [1], [0], [1], [900], [], [], []continuing other job steps, job failed will not be re-runRMAN-03009: failure of backup command on t1 channel at 03/30/2007 01:38:54ORA-00600: internal error code, arguments: [2103], [0], [0], [1], [900], [], [], []channel t1 disabled, job failed on it will be run on another channelR

收藏(转帖)[@more@] 系统页面空间 系统把物理内存作为工作空间,把交互数据和程序放到磁盘上.这些空间就是页面空间. 7.1页面空间概览 页面有4k容量,可以在物理内存和辅助存储之间传输,是虚拟内存的单位.页面空间也可以被称为交换空间.是属性类型为paging的LV. 系统安装时创建的默认页面LV是hdisk0上的hd6,也叫主页面空间. 默认的页面空间在系统安装的自定义阶段按以下标准建立: 1.页面空间不能少于16M,只能在hd6上,AIX4.2.1中不少于32M,AIX4.3以后不少于64M 2.页面空间不能多于所有磁盘空间的20%; 3,如果实际内存少于256M,交换空间是实际内

今天有个朋友问起32位数据库的SGA 限制的问题,现在整理如下，仅供参考学习之用。。重要提示，操作有风险，建议先测试再实施，[@more@]原来由于32位操作系统本身的问题，内存只能认到不到4GB，好在微软加了一个什么参数PAE，解决了这个内存限制在微软网站上看到的各个版本内存的最大扩展情况如下：Physical Memory Limits: Windows VistaThe following table specifies the limits on physical memory for Windows Vista.Version Limit in 32-bit Windows/Limit in 64-bit Windows Windows Vista Ultimate 4 GB/ 128 GBWindows Vista Enter

由于TSM 备份挂起(失败了) ,发现ALERT 里有如下的日志Wed Mar 28 09:00:00 2007MMNL absent for 28312 secs; Foregrounds taking overWed Mar 28 09:00:26 2007Thread 1 advanced to log sequence 4593Current log# 2 seq# 4593 mem# 0: /dev/rlvredo21_1gCurrent log# 2 seq# 4593 mem# 1: /dev/rlvredo22_1gWed Mar 28 09:01:18 2007在METALINK 上查找了一下,给出的结果虽然不完全相同,但还是参考一下[@more@]SQL*Plus Connection Fails With Ktsmg_update_mql(): Mmnl Absent For 1201 Secs; Foregrounds Taking Over文档 ID: 注释:340

........[@more@]New Background Processes In 10g 文档 ID: 注释:268197.1类型: HOWTO 上次修订日期: 18-JUL-2005状态: PUBLISHEDThe information in this document applies to: Oracle Server - Enterprise Edition - Version: Information in this document applies to any platform.GoalThis article provides information on some new and some pre-existing background processes in 10G which may be unfamiliar. FixBACKGROUND PROCESS INFORMATION=================================MMANSGA Background ProcessThe Automatic Sha

收藏，方便查询[@more@]http://edelivery.oracle.com/?ARU_LANG=ZHS

环境:AIX5.3+10.2.0.2 RAC[@more@]ORA-1031 ORA-600[17285] ORA-600[KGANTC_1] Debugging PL/SQL 文档 ID: 注释:335954.1类型: PROBLEM 上次修订日期: 07-DEC-2005状态: PUBLISHEDIn this Document Symptoms Cause Solution ReferencesApplies to: Oracle Server - Enterprise Edition - Version: 10.1.0.3.0This problem can occur on any platform.SymptomsDebugging PL/SQL using a 3rd party debugger (ie Oraedit) or the DBMS_DEBUG package fails with thefollowing error sequence reported in the alert log:Tue Sep 6 11:58

。。。。[@more@]下项目可以自己选择优化，开nVidia显卡显示属性中的超频工具面板 XP更好支持137GB以上大硬盘 NTFS Speed-up(为了让 ntfs 快那么一点点,牺牲部分软件相容性 + 不更新最后存取时间) 修改磁盘缓存以加速XP，请根据自己的内存情况选择使用。 不同内存容量优化 网速优化，要分不同上网类型的。 宽带的，使用下面的，去掉下面这几行的“;”号 ADSL的，使用下面的，去掉下面这几行的“;”号　 -------------------------IE类的----------------------------------　为Internet Explorer添加搜索引擎（以Microsoft Knowledge Base

环境:LINUX Oracle EBS 11.5.10.2 DB:9.2.0.6 [@more@]错误,DB 不能正常启动ORA-00600: internal error code, arguments: [2252], [1388], [3670004711], [], [], [], [], []采取方法,由于SERVER 的时间不准,变成了1999年..修改正常时间2007...再重起DB ,正常了,也没有哪个错误了

环境:AIX5.3 Oracle 10.2.0.2 [@more@]1. 对数据库做FULL BACKUP2. 停掉数据库和TNS[TEST:oradev] /oradev1/home> sqlplus "/as sysdba"SQL*Plus: Release 10.2.0.2.0 - Production on Tue Mar 13 11:48:51 2007Copyright (c) 1982, 2005, Oracle. All Rights Reserved.Connected to:Oracle Database 10g Enterprise Edition Release 10.2.0.2.0 - 64bit ProductionWith the Partitioning, OLAP and Data Mining optionsSQL> shutdown immediateDatabase closed.Database dismounted.ORACLE instance shut down.SQL

.....[@more@]1.创建测试数据库 - 从别的地方TAR 一个ORACLE APP目录过来 - Copy 过来，用oratest 用户解到需要的目录 - 定义oratest .profile 的变量 - 注销掉/etc/oraInst.loc /etc/oratab 里内容 - 修改$ORACLE_HOME/bin/netca 和DBCA 等 脚本里的原来的路径成新的路径 grep oradev1(原路径） * - 用xmanger NETCA 创建一个新的监听 - 用xmanger DBCA 创建一个TEST DB 2. 模仿要正式操作的DB - 在要正式操作的DB 上查看TABLESPACE/ 以及DBA_OBJECTS 等数量 select count(*) from dba_objects where status='VAL