ITPub博客

以前,一直想买这本书,但由于某些原因,迟迟没买.请几天把这本书介绍给一个做开发的朋友了,没想到他很快决定要买,并且还"忽悠"我也买一本,于是就搭他的顺风车...原价:99元 ,通过当当花了74.9元 ,还是便宜了不少啊..呵呵[@more@]

发现 AIX 系统中要大量的" NIM thread blocked" ,在IBM 网站上查找相关的解决方案[@more@]IY38496: TS_NIM_ERROR_STUCK_ WHILE CLUSTER STARTUP/SHUTDOWN.A fix is availableObtain fix for this APARAPAR statusClosed as program error.Error description Following errpt entry was logged while start up/shutdown of cluster without any acual error. . LABEL : TS_NIM_ERROR_STUCK_ Resource Name: topsvcs Description : NIM thread blocked . Probable Causes A thread in Topology Services NIM proc

...[@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