ITPub博客

AutoConfig 介绍[@more@]1.IntroductionConfigring a new installation of Oracle Applications includes a number of stages; - Collection of information required to create the desired configuration - Storage of configuration infromation in the correct locations on the relevant machines - Creation of technology stack configuration files with the appropriate details - Starting of all required processes in the correct order 2.AutoConfig Scripts - adautocfg.sh - adconfig.sh - adconfig.pl3. AutoConfig Dire

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

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

今天有个朋友问起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

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

... .....[@more@]由于做EXPDP 的目录空间不足,ALERT 里面出现如下的2个600 错误,不知道是否是BUG Errors in file /oracle/app/oracle/admin/testdb/bdump/testdb_dw01_557302.trc:ORA-00600: internal error code, arguments: [kghstack_underflow_internal_3], [0x1118375E0], [rpi role space], [], [], [], [], []ORA-19502: write error on file "/exp_back/exp_imp/testdb.full_0703042100.dmp", blockno 3126214 (blocksize=4096)ORA-27063: number of bytes read/written is incorrectIBM AIX RISC System/6000 Error:

.....[@more@]关于10.2.0.2中使用start with connect by 报ORA-00600错误的问题 情况如下：建立视图的sql查询包括start with,connect by,然后再查询这个视图，查询也用到了start with和connect by，在9i中查询这个视图没问题，在10.2.0.1测试环境下也没有问题，就是在10.2.0.2中报如下错误ORA-00600: 内部错误代码, 参数: [kkqcbydrv:1], [], [], [], [], [], [], []解决方法:*._optimizer_connect_by_cost_based=FALSE