ITPub博客

...[@more@]环境： AIX5.3+10gRAC故障描述：- 在alert.log 中发现ORA-1652: unable to extend temp segment by 128 in tablespace TEMP- 通过Enterprice Console 观察 node1 : temp tablespace 使用率 1%node2: temp tablespace 使用率 99%解决过程：- 首先对在Enterprice Console 观察结果，感觉不理解，为什么同一个TEMP 表空间在不同的节点上看到不同的结果- 1. SQL>select TABLESPACE_NAME,TOTAL_EXTENTS,USED_EXTENTS,FREE_EXTENTS from V$SORT_SEGMENT;NODE1:TABLESPACE_NAME TOTAL_EXTENTS USED_EXTENTS FREE_EXTENTSTEMP 509 2

......[@more@]安装步骤1. 笔记本电脑 （WINDOWS 平台）2. 安装Vmware Workstation3. 在Vmware Workstation 安装Linux 放到USB 硬盘里 (安装方法,可以参照我以前写的文档4. Clone 系统到新安装的LINUX 系统中(CLONE 方法可以参照我以前的写的)很简单，也很方便啊，一个USB 硬盘全搞顶了。。哈

读书笔记[@more@]Among other things, a control file contains information such as:The database nameThe timestamp of database creationThe names and locations of associated datafiles and redo log filesTablespace informationDatafile offline rangesThe log historyArchived log informationBackup set and backup piece informationBackup datafile and redo log informationDatafile copy informationThe current log sequence numberCheckpoint information

读书笔记[@more@]Administrative User Accounts Provided by Oracle DatabaseUsernamePasswordDescriptionSee AlsoCTXSYSCTXSYSThe Oracle Text accountOracle Text ReferenceDBSNMPDBSNMPThe account used by the Management Agent component of Oracle Enterprise Manager to monitor and manage the databaseOracle Enterprise Manager Grid Control Installation and Basic ConfigurationMDDATAMDDATAThe schema used by Oracle Spatial for storing Geocoder and router dataOracle Spatial User's Guide and ReferenceMDSYSMDSYSThe

............[@more@]Oracle Universal Installer (OUI)The Oracle Universal Installer installs your Oracle software and options. It can automatically launch the Database Configuration Assistant to install a database.Database Configuration Assistant (DBCA)The Database Configuration Assistant creates a database from templates that are supplied by Oracle, or you can create your own. It enables you to copy a preconfigured seed database, thus saving the time and effort of generating and customizing a da

......[@more@]ORA-01031: 权限不足 数据库版本：oracle817sql>conn system/manage as sysdbasql>grant select on user1.table1 to user2;提示：ORA-01031: 权限不足System 虽然是dba，但不是表的 owner所以用ｕｓｅｒ１的身份登陆 授权成功

近来项目中的大事已经完全做完,系统也运行正常,所以,富裕时间比较多,乘机把Oracle Applications 11i 的官方文档,再系统的阅读一遍,发现每阅读一遍,都有不同的理解!Oracle Appliactions 11i concepts 总汇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/27

.......[@more@] MRC is supported by the following Oracle E-Business Suite products - Oracle Assets - Oracle Cash Management - Oracle Cost Management - Oracle General Ledger - Oracle Global Accounting Engine - Oracle Payables - Oracle Receivables - Oracle Purchasing - Oracle Projets Note:MRC can be used even if the Multi-Org Architecture is not implemented

..[@more@]Set of BooksOperating UnitMulti-Org Partitioned objects Tables that contain Multi-Org data can be identified by the suffix"_ALL" in the table name ,These tables include a column called ORG_ID,which partitions Multi-Org data by organization. Converting to Multi-Org AD Administration

..[@more@]1.Languages and Character Sets on the Database Tier By default Rapid Install creats a production database with the US7ASCII character set,And a vision demo database with the UTF8 character set2.Languages and Character sets on the Application Tier By default ,Rapid Install Creates the application tier file system for a production instance with the US7ASCII character set,and the file system for a vision demo instance with the UTF8 character set.3.Character Sets on the Desktop Tier

............[@more@]Introduction - Stategies - Latency - Satellite Links - Wireless LANs

Security[@more@]Introduction - Authentication - Authorization - Audit Trail - Network Security - Oracle user Management - Security Strategies

Load Balancing[@more@]Oracle Appliactions 11i concepts(十) - Load Balancing(1) 1.Introduction Load balancing areas include: - Domain Name server(DNS) - HTTP Server - JServ Layer - Forms Server - Concurrent Processing Layer - Database Layer

................[@more@]1. Instroduction - Patching Hints and Tips - Maintenance Mode - Shared APPL_TOP and Shared Application Tier File System - Staged APPL_TOP - NOLOGGING in the Applications Database - Distributed AD - Disaster Recovery best practices 2. Patching Hints and Tips 以下几中方法，可以使DOWNTIME 最到最少： - Schedule periodic downtime for application of the latest maintenance packs or family packs - Keep AD up-to-date - Keep your test system current with your production

Authentication and Integration没什么可看的,和技术关系不大..[@more@]Oracle Appliactions 11i concepts(八) - Authentication and Integration(1) 1. Oracle9i Application server (9iAS)2. Oracle Application Server 10g3. Oracle Portal 4. Oracle Discoverer5. Enterprise -Wide Single Sign-On

Oracle Applications Manager[@more@]1. Introduction OAM 可以帮助做如下事情 - Configure and administer your system - Diagnose and correct problems - Manage patches - Monitor and tune performance - Monitor system security 2. GSM Generic Service Management

....[@more@]Oracle Appliactions 11i concepts(六) - Cloning(1) 1. Introduction Cloning can also be used to migrate an Applications system from any paltform to any UNIX platform,such as Linux,Using the PLATFORM MIGRATION Utility.Clone 详细方法请以前写的CLONE 的文档

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