Non critical error ORA-48913 caught while writing to trace file
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
- ORACLE OMS啟動失敗之BEA-300040 I/O error while writing node manager statusOracleErrorWhile
- 在 fish 終端下報錯 source: Error while reading file “xxx” 等問題ErrorWhile
- ./XXX.XX: error while loading shared libraries: libGLEW.so.2.1: cannot open shared object file: NoErrorWhileObject
- 從v$diag_info定位trace file
- rpm: error while loading shared libraries: libgcc_s.so.1: cannot open shared object file: No such fi...ErrorWhileGCObject
- error while loading shared libraries: libpython3.7m(2.7).so.1.0: cannot open shared object file: NErrorWhilePythonObject
- Trace file的命名規則和存放路徑
- Solaris syntax error: unexpected end of fileError
- Archery 平臺執行DDL error:Threads_connected exceeds its critical thresholdErrorthread
- error while loading shared libraries: libclntsh.so.10.1ErrorWhile
- Binary XML file line #2: Error inflatingXMLError
- psql: error: could not connect to server: No such file or directorySQLErrorServer
- Dynamics CRM CRM Reporting Error: Error occurred while fetching the data extension的解決方法ErrorWhile
- ggsci: error while loading shared libraries: libnnz11.soErrorWhile
- error while loading shared libraries: libgconf-2.so.4:ErrorWhileGC
- MySQL 啟動報錯 error while loading shared librariesMySqlErrorWhile
- mongod: error while loading shared libraries: libstdc++.so.6GoErrorWhileC++
- 使用mybatis報錯:Error setting non null for parameter #4 with JdbcType TIMESTAMPMyBatisErrorNullJDBC
- Writing on important detailsImportAI
- Narrative writing revision
- fatal error: libmemcached/memcached.h: No such file or directoryErrorIBM
- fatal error: openssl/sha.h: No such file or directoryError
- fatal error: sys/cdefs.h: No such file or directoryError
- error: #error This file requires compiler and library support for the ISO C++ 2011 standard.ErrorUICompileC++
- git push fatal: HttpRequestException encountered. An error occurred while sending the requestGitHTTPExceptionErrorWhile
- An error occurred while updating the entries. See the inner exception for details.ErrorWhileExceptionAI
- Narrative writing about a person
- Preparation for MCM/ICM Writing
- Qt開發,報錯:Error while building/deploying project untitled (kit: ....)QTErrorWhileUIProject
- 故障解決:error while loading shared libraries: libncurses.so.5ErrorWhile
- 解決報錯 cuDNN error: CUDNN_STATUS_NOT_SUPPORTED. This error may appear if you passed in a non-contiguous input.DNNErrorAPP
- python,開發錯誤一:SyntaxError: Non-UTF-8 code starting with '\xca' in filePythonError
- org.postgresql.util.PSQLException: An I/O error occurred while sending to the backend.SQLExceptionErrorWhile
- error while loading shared libraries: libgsl.so.27: cannot open shared objectErrorWhileObject
- Error while loading shared libraries: libreadline.so.7: cannot open shared objecErrorWhileOBJ
- 解決 Error: ENOSPC: System limit for number of file watchers reachedErrorMIT
- error: pathspec ‘myupstream‘ did not match any file(s) known to gitErrorGit
- ERROR 1290:The MySQL server is running with the --secure-file-priv optionErrorMySqlServer