ITPub博客

很多套的系统TSM备份都失败了.[@more@]RMAN-00571: =========================================================== RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS =============== RMAN-00571: =========================================================== RMAN-03009: failure of backup command on t2 channel at 11/26/2007 22:43:38 ORA-19502: write error on file "qqj223uq_1_1", blockno 4741121 (blocksize=512) ORA-27030: skgfwrt: sbtwrite2 returned error ORA-19511: Error received from media ma

.............[@more@]打算大概从以下几个方面进行深入的探讨:1.网络2.Server (硬件)3.操作系统4.DB5.Application6.User 等几个方面

再次遭遇这个BUG, 看来需要抽时间把PATCH打上了ORA-00600: internal error code, arguments: [17281], [1001], [0x7000002BBEB7530], [], [], [], [], []ORA-01001: invalid cursorThu Nov 22 05:49:25 2007[@more@]http://zhulch.itpub.net/post/17395/289800

.........[@more@]Connected to Oracle Database 10g Enterprise Edition Release 10.2.0.2.0 Connected as testSQL> SQL> select se.username,se.sid,su.extents,su.blocks*to_number(rtrim(p.value)) as Space,tablespace,segtype,sql_text from v$sort_usage su,v$parameter p,v$session se,v$sql s 2 where p.name='db_block_size' and su.session_addr=se.saddr and s.hash_value=su.sqlhash and s.address=su.sqladdr order by se.username,se.sid;USERNAME SID EXTENTS SPACE TABLES

最近2 天一直听SAP CRM 的KT的讲课.[@more@]虽然到现在为止对SAP 的了解的还是一知半解的,但还是感觉有点用处,并不自觉的和ORACLE EBS 的进行一些对比. 总体看来SAP的架构和ORACLE EBS很是相似的,估计别的大型的ERP 也是大同小异. 对于SAP BASIS的干的事和ORACLE APPS DBA 也是基本上一样,每天监控的内容也是很相似.. 但可能有一点不同,一般SAP 的BASIS 不做数据库DBA 的事,而ORACLE APPS DBA 往往也同时做着数据库的DBA的事.

在APPLY 5496862 出现一些类似的错误,解决方法如下:[@more@]Applies to: Oracle Server - Enterprise Edition - Version: 10.2.0.2.0This problem can occur on any platform.SymptomsYou are trying to install an Interim/One-off Patch on AIX platform.You are encountering WARNINGs in the relinking stage of the Patch Apply.~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~<example, when applying OCT CPU 2006 to Oracle DB 10.2.0.2 on AIX>......Running make for target ioracleApplySession adding

...........[@more@]Applies to: Oracle Server - Enterprise Edition - Version: 9.2.0.1 to 10.2.0.3AIX5L Based Systems (64-bit)Symptoms-- Problem Statement:Whila applying the one-off patches , at the relinking phase the following error and warningsoccurs :ld: 0711-317 ERROR: Undefined symbol: .ha_em_receive_response_2ld: 0711-317 ERROR: Undefined symbol: .ha_em_restart_session_2ld: 0711-317 ERROR: Undefined symbol: .ha_em_start_session_2ld: 0711-317 ERROR: Undefined symbol: .ha_em_send_command_2ld:

.............[@more@]Oracle 10g data guard 实验记录环境： OS：AIX5.3ML05 DB: Oracle 10.2.0.2命名规则 Host Database Type DB_UNIQUE_NAME TNS Alias test192 Primary zhulch zhulch_test192 test148 Physical Standby naonao naonao_test148 1.创建源数据库 - 安装SW - 创建监听和数据库2.确认 主数据库的归档模式SQL> archive log listDatabase log mode Archive ModeAutomat

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

整理了一下,收藏[@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

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

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

ITPUB上看到的,自己整理了一下[@more@]>=toad9.0版本的连接ORACLE 11G ,换成toad9.1就没有问题了toad9.1ora11g+linux5

了解一下还是很有用的[@more@]**********Orace 9i的标准版＆企业版************Oracle9i数据库的企业版和标准版最主要的区别在于企业版有更强大的并行和分布式处理能力，标准版是专为开发、部署和管理部门级 Internet 应用程序而设计的数据库管理系统，是用于传统的部门级应用程序的一流数据库。而应用超出部门级标准或访问数据库的人较多时，则应当选用企业版。 标准版企业版·Jserver Enterprise Edition ·InterMedia ·Enterprise Manager ·Workflow Standard Edition ·Standard Management Pack ·Object Option ·Networking kit

.............[@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@]自己写的文章,拿出来让别人品论,以前写的基本上没有不好的言辞的评论,但这篇文章却引发了一些很极端的评论,当然这些不好的语言,是让人不舒服的,但也给自己提醒一下,以后写东西,一定要注意,注意,再注意,千万不要被有些人看出一点点的问题..写东西本身也很辛苦了,但别人看东西更是挑剔.

热烈祝贺"十七"大闭幕..呵呵..好象和我们关系不大哈....不过,做技术的也要关注国家大事啊[@more@]

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

还真不错啊[@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

最近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