10.2.0.3 补丁安装一个错误,不知道是不是 BUG
AIX5.3ML05[@more@]安装10GR2 后,打10.2.0.3 补丁,出如下错误,由于知识测试,所以改为10.2.0.2 了INFO: Exception thrown from action: copyGroupFromJarException Name: IOException3_nameException String: I/O error while opening or reading file /tmp/OraInstall2007-11-09_01-40-45PM/temp51Exception Severity: 2INFO: *** Cancel Dialog: ***INFO: User Selected: Cancel
windows 32位的 Oracle 内存限制问题
整理了一下,收藏[@more@]windows 32位的问题 遍地都说 3G开关,开了3G开关能给oracle.exe进程的内存也就最多3GB吗?另外在微软网站找到这一段:http://www.microsoft.com/whdc/syste...PAE/PAEmem.mspxPhysical Address Extension. PAE is an Intel-provided memory address extension that enables support of up to 64 GB of physical memory for applications running on most 32-bit (IA-32) Intel Pentium Pro and later platforms. Support for PAE is provided under Windows 2000 and 32-bit versions of Windows XP and Windows
IY58275: TRUSS: 0915-015 CANNOT CREATE SUBJECT PROCESS
bug[@more@] fix is availableObtain fix for this APARAPAR statusClosed as program error.Error description ProcFS may not stop properly on system call tracing. Local fix Problem summary ProcFS may not stop properly on system call tracing. Problem conclusion Save system call number earlier, before it can be lost. Temporary fix Comments APAR informationAPAR numberIY58275Reported component nameAIX 5L POWER V5Reported component ID5765E6200Reported release520StatusCLOSED PERPENoPEHIPERNoHIPERSubmitt
WAITED TOO LONG FOR A ROW CACHE ENQUEUE LOCK!
环境: AIX5.3+hacmp5.3+oracle 10.2.0.2 RAC故障现象: - instance1 hang (sqlplus 都不能进去) - alert log 里出现:WAITED TOO LONG FOR A ROW CACHE ENQUEUE LOCK 解决过程:[@more@]环境: AIX5.3+hacmp5.3+oracle 10.2.0.2 RAC故障现象: - instance1 hang (sqlplus 都不能进去) - alert log 里出现:WAITED TOO LONG FOR A ROW CACHE ENQUEUE LOCK 解决过程:DATA COLLECTED===================Tue Oct 30 08:19:18 2007GES: Potential blocker (pid=917874) on resource TX-00320007-00028042;en
Toad 版本低不能连ORACLE 11G的问题
ITPUB上看到的,自己整理了一下[@more@]>=toad9.0版本的连接ORACLE 11G ,换成toad9.1就没有问题了toad9.1ora11g+linux5
ORACLE标准版与企业版的差别(转载)
了解一下还是很有用的[@more@]**********Orace 9i的标准版&企业版************Oracle9i数据库的企业版和标准版最主要的区别在于企业版有更强大的并行和分布式处理能力,标准版是专为开发、部署和管理部门级 Internet 应用程序而设计的数据库管理系统,是用于传统的部门级应用程序的一流数据库。而应用超出部门级标准或访问数据库的人较多时,则应当选用企业版。 标准版企业版·Jserver Enterprise Edition ·InterMedia ·Enterprise Manager ·Workflow Standard Edition ·Standard Management Pack ·Object Option ·Networking kit
R12 安装后进行的一些必要的测试内容
.............[@more@]http://testserver.test.com:8000/OA_HTML/ServletPinghttp://testserver.test.com:8000/OA_HTML/OAInfo.jsphttp://testserver.test.com:8000/OA_HTML/OA.jsp?OAFunc=OAHOMEPAGEhttp://testserver.test.com:8000/OA_HTML/AppsLocalLogin.jsphttp://testserver.test.com:8000/OA_HTML/AppsLoginhttp://testserver.test.com:8000/OA_HTML/jsp/fnd/aoljtest.jsphttp://testserver.test.com:8000/OA_HTML/jsp/fnd/aolj_setup_test.jsp?ddid=testhttp://testserver.test.com:8000/forms/frmservlet
热烈祝贺"十七"大闭幕..
热烈祝贺"十七"大闭幕..呵呵..好象和我们关系不大哈....不过,做技术的也要关注国家大事啊[@more@]
bug 5923671 and will be fixed in 11g.
....[@more@]2007-10-18 22:25:14.382: [ OCRCLI][790]proac_createnset_key:parent key=[SYSTEM], subkey=[evm.debug.pekax147.EVMD] Response message returned with failure [5]2007-10-18 22:25:14.382: [ OCRAPI][790]a_create_n_set_key: failed 52007-10-18 22:25:14.383: [ CRSOCR][790]32OCR api procr_create_n_set_key failedfor key evm.debug.pekax147.EVMD. OCR error code = 5 OCR error msg: PROC-5: Userdoes not have permission to perform a cluster registry operation on this key. Authentication error [User doe
不错的工具,prw.sh
还真不错啊[@more@]Applies to: Oracle Server - Enterprise Edition - Version: 10.2 to 10.2HP-UX ItaniumAIX5L Based Systems (64-bit)Linux ItaniumLinux x86-64Solaris Operating System (SPARC 64-bit)Linux x86HP-UX PA-RISC (64-bit)HP Tru64 UNIXPurposeProcwatcher is a tool to examine and monitor Oracle database and CRS processes at an interval. The tool will collect stack traces of these processes using Oracle tools like oradebug short_stack and OS debuggers like pstack, gdb, dbx, or ladebug.Scope and
CRS and 10g Real Application Clusters
最近EVMD 进程把我搞死了,好好研究一下这个东西..[@more@]PURPOSE-------This document is to provide additional information on CRS (Cluster Ready Services)in 10g Real Application Clusters. SCOPE & APPLICATION-------------------This document is intended for RAC Database Administrators and Oracle support enginneers. CRS and 10g REAL APPLICATION CLUSTERS------------------------------------- CRS (Cluster Ready Services) is a new feature for 10g Real Application Clustersthat provides a standard cluste
bug 5638023 害死我了,打了这个BUG,引起别的BUG
.............[@more@]bug 5638023 ,打完后,造成CREATE DB 的时候"RAWUTL不能执行" 的错误,rollback 后,create db 成功,但不能增加新的datafile ..
10g RAC: How to Clean Up After a Failed CRS Install
...........[@more@]PURPOSE-------The purpose of this document is to help DBA's and support analysts understand howto clean up a failed CRS (Cluster Ready Services) install for 10g RAC. SCOPE & APPLICATION-------------------DBA's and Support Analysts10g RAC: How to Clean Up After a Failed CRS Install--------------------------------------------------- Not cleaning up a failed CRS install can cause problems like node reboots.Follow these steps to clean up a failed CRS install:1. Run the rootdel
昨天加班又准备了一套ORACLE 10g RAC 环境
AIX5L+HACMP5.3+ORACLE 10gR2 RAC[@more@]HACMP 配置不符合10G 的安装需求,自己重新配的机器重起后GPFS 自动起不来节点2 自己经常重起...节点1 上老显示控制文件不能使用,数据库起不来.估计是HA造成的还在检查...
Not Able To Open Forms Session After Cloning.
Oracle ebs 11i[@more@]$IAS_ORACLE_HOME/Apache/Apache/conf/security.conf Applies to: Oracle Applications Technology Stack - Version: 11.5.10.2This problem can occur on any platform.SymptomsYou have completed a clone and are able to login to Self Service Applications however forms will not launch after clicking a Forms responsibility. There is no errors that appear and the Applet for forms will not launchErrors in the log file are as follows;Filename =access_log.1190332800 See ... [Fri Sep
Cannot Access Pls Pages: 'mod_security: Access denied with code 400'
帮朋友解决的Oracle EBS11I[@more@]错误现象:- 从IE方式form进不去,CGI可以进去- [Thu Oct 11 18:02:29 2007] [error] [client 10.4.105.73] mod_security: Access denied with code 400. Pattern match "!^/pls/[-a-z0-9_]+/!?[a-z](([a-z0-9_$#]){0,29})(.[a-z](([a-z0-9_$#]){0,29})){0,2}(?.*){0,1}$" at REQUEST_URI. [hostname "misp4.bj.cmcc"] [uri "/pls/BJNPRD/fnd_icx_launch.launch?resp_app=SYSADMIN&resp_key=SYSTEM_ADMINISTRATOR&secgrp_k解决:In this Document Symptoms Changes C
How to Run Statement Level/Java trace or a SQL Trace in Self Service Application
...[@more@]Statement Level/ Java Trace:1 - Remove any messages from the FND_LOG_MESSAGES table for the user running the process to be traced.To get the user id of your self service user:select user_idfrom fnd_userwhere user_name = '????'Delete all rows in the tables for this user: delete from FND_LOG_MESSAGES where user_id =� xxx���� <insert the value received in the first query>2- To set fnd logging you need to set the following FND system profiles:Log o
Tossing Bad Mupd Msg Pid In The Alert.Log
发现一个测试系统有大量的警告:Thu Sep 27 06:00:22 2007tossing bad MUPD msg pid 856294tossing bad MUPD msg pid 856294tossing bad MUPD msg pid 856294tossing bad MUPD msg pid 856294tossing bad MUPD msg pid 856294Thu Sep 27 06:09:09 2007tossing bad MUPD msg pid 856294tossing bad MUPD msg pid 856294tossing bad MUPD msg pid 856294tossing bad MUPD msg pid 856294tossing bad MUPD msg pid 856294tossing bad MUPD msg pid 856294tossing bad MUPD msg pid 856294[@more@]Applies to: Oracle Server - Enterprise Edit
在升级的时候使用VNC的小窍门
........[@more@]各位肯定在应用ERP的patch的时候,一般通过VNC操作,避免网络和本机的原因导致session断掉,而影响中断patch,一般都是用vnc这个工具,但是vnc无法粘贴 复制从本机。这里提供几个窍门1.修改vnc的终端类型,就可以粘贴复制了(默认是kde)2.由于防火墙的限制,导致某些端口无法访问,这里可以修改VNC的启动端口,到达我们访问的目的3.一般VNC登录以后,其他用户在登录相同的端口,前面的用户的session就会切换到第二位用户上,可以使用下面提供的工具,可以同时2个人操作,一个操作一个观看(很爽吧
ORA-12008 ORA-29701
环境:AIX5L+HACMP5.3+ORACLE 10GR2 RAC昨天半夜00点多,他们在做加拿大UAT测试的人给我打电话,说应用一跑就报错,帮助看一下数据库有没有问题.以下是解决过程.[@more@]故障描述:应用程序报如下错误:ORA-12008: error in materialized view refresh pathORA-29701: unable to connect to Cluster ManagerORA-06512: at "SYS.DBMS_SNAPSHOT", line 2255ORA-06512: at "SYS.DBMS_SNAPSHOT", line 2461ORA-06512: at "SYS.DBMS_SNAPSHOT", line 2430ORA-06512: at line 2故障分析:- ps -ef | grep ora_ ORACLE 进