Non critical error ORA-48913 caught while writing to trace file
檢查某客戶資料庫alert警告日誌發現如下錯誤:
Non critical error ORA-48913 caught while writing to trace file "/u01/oracle/jzh/db/tech_st/11.1.0/admin/jzh_dpebsr12/diag/rdbms/jzh/jzh/trace/jzh_ora_9568606_owc.trc"
Error message: ORA-48913: 鍐欏靉璺熻釜鏂囦歡澶辮觸, 杈懼埌浜嗘枃浠跺ぇ灝忛檺鍒?[10485760]
Writing to the above trace file is disabled for now on...
Mon Jan 19 10:40:46 2015
20150119 10:40:46ip:192.168.217.22 WORKGROUP\jzh SQL*Plus want ddl(CREATE)SYSTEM.BDUMPDIR.
Mon Jan 19 10:46:03 2015
20150119 10:46:03 ip:192.168.58.48 VM-48 SYSTEM OraWrapper.exe want logon SYSTEM
Errors in file /u01/oracle/jzh/db/tech_st/11.1.0/admin/jzh/diag/rdbms/jzh/jzh/trace/jzh_ora_1442508.trc:
初步看應該是超過了max dump file引數的限制,trace file達到了10M,而客戶環境MAX_DUMP_FILE_SIZE引數值為2048。
mos上解釋如下:
Information in this document applies to any platform.
***Checked for relevance on 18-Aug-2014***
Non critical error ORA-48913 caught while writing to trace file "/u01/oracle/jzh/db/tech_st/11.1.0/admin/jzh_dpebsr12/diag/rdbms/jzh/jzh/trace/jzh_ora_9568606_owc.trc"
Error message: ORA-48913: 鍐欏靉璺熻釜鏂囦歡澶辮觸, 杈懼埌浜嗘枃浠跺ぇ灝忛檺鍒?[10485760]
Writing to the above trace file is disabled for now on...
Mon Jan 19 10:40:46 2015
20150119 10:40:46ip:192.168.217.22 WORKGROUP\jzh SQL*Plus want ddl(CREATE)SYSTEM.BDUMPDIR.
Mon Jan 19 10:46:03 2015
20150119 10:46:03 ip:192.168.58.48 VM-48 SYSTEM OraWrapper.exe want logon SYSTEM
Errors in file /u01/oracle/jzh/db/tech_st/11.1.0/admin/jzh/diag/rdbms/jzh/jzh/trace/jzh_ora_1442508.trc:
初步看應該是超過了max dump file引數的限制,trace file達到了10M,而客戶環境MAX_DUMP_FILE_SIZE引數值為2048。
mos上解釋如下:
APPLIES TO:
Oracle Database - Enterprise Edition - Version 11.2.0.1 and laterInformation in this document applies to any platform.
***Checked for relevance on 18-Aug-2014***
SYMPTOMS
On 11.2.0.1, encountered the following error in the alert.log:
Non critical error ORA-48913 caught while writing to trace file "/oraotcprd1/app/oracle/diag/rdbms/otcprd1/OTCPRD11/trace/OTCPRD11_ora_14925.trc"
Error message: ORA-48913: Writing into trace file failed, file size limit [10485760] reached
CAUSE
Parameter MAX_DUMP_FILE_SIZE is set too low
SOLUTION
Increase the setting for the parameter MAX_DUMP_FILE_SIZE or set it to unlimited
For additional information on this parameter, refer to
Oracle Database Reference 11g Release 2 (11.2)
MAX_DUMP_FILE_SIZE
原因是由於MAX_DUMP_FILE_SIZE太小,解決方法是增加MAX_DUMP_FILE_SIZE大小,或者設定成無限制。
來自 “ ITPUB部落格 ” ,連結:http://blog.itpub.net/10271187/viewspace-1413441/,如需轉載,請註明出處,否則將追究法律責任。
相關文章
- gpadmin-[CRITICAL]:-Error occurred: non-zero rc: 1Error
- 452 Error writing file: A file cannot be larger than the value set by ulimit.ErrorMIT
- Error message: ORA-48913Error
- 10.2.0.2 RAC DB ">>> ERROR IN KQLMBIVG SEE LCK TRACE FILEError
- ORA-01114: IO error writing block to file (block #)ErrorBloC
- ORACLE OMS啟動失敗之BEA-300040 I/O error while writing node manager statusOracleErrorWhile
- error while loading shared libraries: libodm9.so: cannot open shared object file: No such file or diErrorWhileObject
- sql_trace生成及使用tkprof檢視trace fileSQL
- oracle監聽開啟trace fileOracle
- 在 fish 終端下報錯 source: Error while reading file “xxx” 等問題ErrorWhile
- YaST2 error: (gnomesu): CRITICAL **: There are no services for 'libgnomesu' available.ASTErrorAI
- 從v$diag_info定位trace file
- ora - 100501 Non oracle errorOracleError
- error while loading shared libraries: libmysqlclient.so.16: cannot open shared object file: No suchErrorWhileIBMMySqlclientObject
- Error 15: File not found for RedhatErrorRedhat
- Process W000 died, see its trace file
- How to read Oracle 10046 trace fileOracle
- error while loading shared librariesErrorWhile
- Error 600 encountered while recovering transaction (10, 0)ErrorWhile
- opensuse13.1 安裝chrome報 error while loading shared libraries:libudev.so.0:cannot open shared object file:no file or directoryChromeErrorWhiledevObject
- oracle deadlock死鎖trace file分析之一Oracle
- HPUX Error 23 File table overflowUXError
- An error occurred while the wizard was checking the current Windows product license. Error Code: 8:ErrorWhileWindows
- The server has encountered an error while loading an applicationServerErrorWhileAPP
- 監聽器控制程式lsnrctl跟蹤trace file
- Please Check VKTM Trace File for More Details (文件 ID 1347586.1)AI
- truncate、recreate後臺程式跟蹤檔案(trace file)
- Solaris syntax error: unexpected end of fileError
- ./ggsci: error while loading shared librariesErrorWhile
- rpm: error while loading shared libraries: libgcc_s.so.1: cannot open shared object file: No such fi...ErrorWhileGCObject
- ./XXX.XX: error while loading shared libraries: libGLEW.so.2.1: cannot open shared object file: NoErrorWhileObject
- oracle deadlock死鎖trace file分析之一增補Oracle
- mysqldump: Got error: 1168 differently defined non-MyISAM LOCK TABLESMySqlGoError
- fatal error: openssl/sha.h: No such file or directoryError
- fatal error: sys/cdefs.h: No such file or directoryError
- error while loading shared libraries: libpython3.7m(2.7).so.1.0: cannot open shared object file: NErrorWhilePythonObject
- linux操作提示:“Can't open file for writing”或“operation not permitted”的解決辦法LinuxMIT
- git push fatal: HttpRequestException encountered. An error occurred while sending the requestGitHTTPExceptionErrorWhile