ITPub博客

查metalink解决，在此记录一下metalink真是个好东西，不过，要花钱的 ^_^On 12.0.6 in Production:When you are attempting to use the WIP Mass Load program,the following error occurs.ERRORCannot read value for profile option RPM_CONC_PROCESS_ID in routine &ROUTINE.STEPSThe issue can be reproduced at will with the following steps:1. Release the Planned Order from Planning Workbench2. WIP mass Load program completes with Error messageCannot read value for profile option RPM_CONC_PROCESS_ID in routine

INBOUND_CONNECT_TIMEOUT_<listener_name> parameter in the listener.ora file.SQLNET.INBOUND_CONNECT_TIMEOUT=60 [@more@]

APP-FND-00565: APP_EXPORT.DUMP_DATA 中导出失败. PL/SQL错误: ORA-01693: max # extends(240000)已在lob 段APPLSYS.SYS_LOB0000038402C00004$$中达到ORA-06512: 在"APPS.FND_GFM", line 597ORA-06512: 在"APPS.FND_GFM", line 621. OLE 错误:无SQL> select owner,segment_name,segment_type,tablespace_name,extents,max_extents 2 from dba_segments 3 where segment_name='SYS_LOB0000038402C00004$$';SQL> select owner,table_name,column_name,segment_name 2 from dba_lobs 3 where segment_

ORA-01116: error in opening database file 4ORA-01110: data file 4: '/applis/oracle/prd/data_top/system04.dbf'ORA-27041:unable to open fileLinux Error:24, Too many open files2009-08-06日美高系统出错APP-FND-01564:SUBMIT:others 中出现 oracle 错误 -1116原因:由于ORA-01116:error in opening database file 398ORA-01110:data file 398:'/d05/proddata/arch/a_archive01.dbf'ORA-27041:unable to open fileLinux Error:24:Too many open files Additional information:3,SUBMIT:others 失败.出货错误时执行的 SQL语名为:&am

Set the profile option FND: NATIVE CLIENT ENCODING to the appropriate language and then the correct font will be visible.[@more@]

此错误反复出现:Wed Sep 9 22:00:03 2009Errors in file /d01/proddb/10.2.0/admin/PROD_melcoproddb/bdump/prod_j001_12246.trc:ORA-12012: error on auto execute of job 388947ORA-20000: ORA-20000: Content of the tablespace specified is not permanent or tablespace name is invalidORA-06512: at "SYS.PRVT_ADVISOR", line 1624ORA-06512: at "SYS.DBMS_ADVISOR", line 186ORA-06512: at "SYS.DBMS_SPACE", line 1344ORA-06512: at "SYS.DBMS_SPACE", line 1560查metalink,提sr,oracl

今天一大早例行数据库检查,在Rock的aler.log日志里发现以下问题:Mon Sep 14 22:02:11 2009Hex dump of (file 11, block 41091) in trace file /oracle/oraprod/proddb/10.2.0/admin/PROD_prod/udump/prod_ora_17341.trcCorrupt block relative dba: 0x02c0a083 (file 11, block 41091)Fractured block found during backing up datafileData in bad block: type: 6 format: 2 rdba: 0x02c0a083 last change scn: 0x056d.2b6d3f2c seq: 0x8 flg: 0x04 spare1: 0x0 spare2: 0x0 spare3: 0x0 consistency value in tail: 0xe88b0601 check va

今天一早检查alert.log,发现以下错误:Process J000 died, see its trace fileMon Sep 7 16:26:07 2009kkjcre1p: unable to spawn jobq slave process Mon Sep 7 16:26:07 2009Errors in file /d01/proddb/10.2.0/admin/PROD_melcoproddb/bdump/prod_cjq0_27156.trc:Process J000 died, see its trace fileMon Sep 7 16:26:13 2009kkjcre1p: unable to spawn jobq slave process Mon Sep 7 16:26:13 2009Errors in file /d01/proddb/10.2.0/admin/PROD_melcoproddb/bdump/prod_cjq0_27156.trc:Mon Sep 7 16:26:44 2009Process J000 di

[orademo@r12demo DEMO_r12demo]$ lsnrctlLSNRCTL for Linux: Version 11.1.0.7.0 - Production on 07-SEP-2009 15:36:14Copyright (c) 1991, 2008, Oracle. All rights reserved.Welcome to LSNRCTL, type "help" for information.LSNRCTL> statusConnecting to (ADDRESS=(PROTOCOL=tcp)(HOST=)(PORT=1521))STATUS of the LISTENER------------------------Alias DEMOVersion TNSLSNR for Linux: Version 11.1.0.7.0 - ProductionStart Date 07-SEP-2009 15:29:55Up

转自:http://fhtt0606.itpub.net/post/14578/477049 oracle support说这并不是一个bug，是一个问题，呵呵，bug和问题，都是你的错，oracle！工 作中将某个用户失效之后，有可能又需要重新将用户重新启用，在更改了用户的失效时间之后，所有的职责都不见了，琢磨了好一阵子用户相关的表，基本能够确定 问题是由于有效截止日期并没有同步导致，但是由于有可能需要手动update标准表，风险相当大，为此提了一个sr，support给我来了个owc，多 番操作之后得出解决方法如下：1. Go into the responsibility: System Administrator.2. Na

转自:http://fhtt0606.itpub.net/category/14578/52534select count(bug_number) from apps.ad_bugs;bug_number 对应 patch号ad_applied_patchesad_applied_patches是你自己adpatch打的那些，但是安装的时候已经包含的patch,这个表不会记录，所以如果要查询某个patch是否已经applied，还是ad_bugs[@more@]