IOTN :: Field Book :: ORACLE

ȸ¿ø°¡ÀÔ

ORA-21780: Maximum number of object durations exceeded.

ÃÖ±æÈ£ [LIST]   2025-09-11 09:42:21, Á¶È¸ : 4 óÀ½ ¹ß»ý 2025-08-13T09:08:18.354052+09:00 ORA-21780 encountered when generating server alert SMG-4120 2025-08-13T09:13:19.026631+09:00 Errors in file /home/oracle/app/oracle/diag/rdbms/orcl/orcl/trace/orcl_mmon_219105.trc: ORA-21780: Maximum number of object durations exceeded. ORA-06512: at "SYS.DBMS_PRVT_TRACE", line 294 ORA-06512: at "SYS.DBMS_PRVT_TRACE", line 122 ORA-06512: at "SYS.DBMS_PRVT_TRACE", line 140 ORA-06512: at "SYS.DBMS_HA_ALERTS_PRVT", line 118 ORA-21780: Maximum number of object durations exceeded. ORA-06512: at "SYS.DBMS_PRVT_TRACE", line 294 ORA-06512: at "SYS.DBMS_PRVT_TRACE", line 122 ORA-06512: at "SYS.DBMS_PRVT_TRACE", line 291 ORA-06512: at "SYS.DBMS_HA_ALERTS_PRVT", line 109 ORA-06512: at line 1 2025-08-13T09:13:19.029066+09:00 Errors in file /home/oracle/app/oracle/diag/rdbms/orcl/orcl/trace/orcl_mmon_219105.trc: ORA-21780: Maximum number of object durations exceeded. ORA-06512: at "SYS.DBMS_PRVT_TRACE", line 294 ORA-06512: at "SYS.DBMS_PRVT_TRACE", line 122 ORA-06512: at "SYS.DBMS_PRVT_TRACE", line 291 ORA-06512: at "SYS.DBMS_HA_ALERTS_PRVT", line 312 ORA-21780: Maximum number of object durations exceeded. ORA-06512: at "SYS.DBMS_HA_ALERTS_PRVT", line 191 ORA-06512: at "SYS.DBMS_HA_ALERTS_PRVT", line 166 ORA-06512: at line 1 Errors in file /home/oracle/app/oracle/diag/rdbms/orcl/orcl/trace/orcl_mmon_219105.trc ORA-21780: Maximum number of object durations exceeded. SYSAUX tablespace size Áõ°¡ Trace file /home/oracle/app/oracle/diag/rdbms/orcl/orcl/trace/orcl_mmon_219105.trc Oracle Database 12c Standard Edition Release 12.2.0.1.0 - 64bit Production Build label:    RDBMS_12.2.0.1.0_LINUX.X64_170125 ORACLE_HOME:    /home/oracle/app/oracle/product/122 System name:    Linux Node name:  database Release:    3.10.0-1062.9.1.el7.x86_64 Version:    #1 SMP Fri Dec 6 15:49:49 UTC 2019 Machine:    x86_64 Instance name: orcl Redo thread mounted by this instance: 0 <none> Oracle process number: 33 Unix process pid: 219105, image: oracle@database (MMON) *** 2025-04-16T09:11:20.233945+09:00 *** SESSION ID:(124.29515) 2025-04-16T09:11:20.233994+09:00 *** CLIENT ID:() 2025-04-16T09:11:20.234001+09:00 *** SERVICE NAME:() 2025-04-16T09:11:20.234008+09:00 *** MODULE NAME:() 2025-04-16T09:11:20.234014+09:00 *** ACTION NAME:() 2025-04-16T09:11:20.234020+09:00 *** CLIENT DRIVER:() 2025-04-16T09:11:20.234026+09:00 dbkrfssm: mmon not open *** 2025-04-16T09:11:24.882000+09:00 04/16/25 09:11:24 >ERROR: exception at dbms_ha_alerts_prvt.post_instance_up308: SQLCODE -13917,ORA-13917: Posting system alert with reason_id 135 failed with code [5] [post_error] 04/16/25 09:11:24 >ERROR: exception at dbms_ha_alerts_prvt.check_ha_resources637: SQLCODE -13917,ORA-13917: Posting syst em alert with reason_id 136 failed with code [5] [post_error] 04/16/25 09:11:24 >parameter dump for dbms_ha_alerts_prvt.check_ha_resources 04/16/25 09:11:24 > - local_db_unique_name (orcl) 04/16/25 09:11:24 > - local_db_domain (==N/A==) 04/16/25 09:11:24 > - rows deleted (0) QPI: Obtaining lock SUCCESSFUL, qp_result=0 at : 16-APR-25 09.11.25.016623000 AM +09:00 QPI:  t_root is /home/oracle/app/oracle/product/122/ QPI:  t_orabase is /home/oracle/app/oracle/product/122/ QPI:  t_op_inst_path is /home/oracle/app/oracle/product/122/OPatch/ QPI:  t_op_scpt_path is /home/oracle/app/oracle/product/122/QOpatch/ QPI:  t_op_log_path is /home/oracle/app/oracle/product/122/rdbms/log/ QPI: opatch file present, opatch QPI: qopiprep.bat file present Errors in file /home/oracle/app/oracle/diag/rdbms/orcl/orcl/trace/orcl_mmon_219105.trc ORA-04045: errors during recompilation/revalidation of SYS.DBMS_HA_ALERTS_PRVT ORA-04088: error during execution of trigger 'MDSYS.SDO_GEOR_BDDL_TRIGGER' ORA-00604: error occurred at recursive SQL level 3 ORA-21780: Maximum number of object durations exceeded. *** 2025-09-12T01:47:34.377434+09:00 dbkedDefDump(): Starting a non-incident diagnostic dump (flags=0x0, level=0, mask=0x0) ----- Error Stack Dump ----- ORA-04045: errors during recompilation/revalidation of SYS.DBMS_HA_ALERTS_PRVT ORA-04088: error during execution of trigger 'MDSYS.SDO_GEOR_BDDL_TRIGGER' ORA-00604: error occurred at recursive SQL level 3 ORA-21780: Maximum number of object durations exceeded. gwm_start_catserv: error 604 when synchronizing parameters expdp ¿¡·¯ Processing object type DATABASE_EXPORT/SCHEMA/PUBLIC_SYNONYM/SYNONYM Processing object type DATABASE_EXPORT/SYSTEM_PROCOBJACT/PRE_SYSTEM_ACTIONS/PROCACT_SYSTEM ORA-39127: unexpected error from call to export_string :=SYS.DBMS_SERVER_ALERT_EXPORT.SYSTEM_INFO_EXP(0,dynconnect,'12.02.00.00.00',newblock) ORA-04063: package body "SYS.DBMS_SERVER_ALERT_EXPORT" has errors ORA-06508: PL/SQL: could not find program unit being called: "SYS.DBMS_SERVER_ALERT_EXPORT" ORA-06512: at line 1 ORA-06512: at line 1 ORA-06512: at "SYS.DBMS_METADATA", line 11063 ORA-06512: at "SYS.DBMS_SYS_ERROR", line 95 Processing object type DATABASE_EXPORT/SYSTEM_PROCOBJACT/PROCOBJ Processing object type DATABASE_EXPORT/SYSTEM_PROCOBJACT/POST_SYSTEM_ACTIONS/PROCACT_SYSTEM ORA-39127: unexpected error from call to export_string :=SYS.DBMS_SERVER_ALERT_EXPORT.SYSTEM_INFO_EXP(1,dynconnect,'12.02.00.00.00',newblock) ORA-04063: package body "SYS.DBMS_SERVER_ALERT_EXPORT" has errors ORA-06508: PL/SQL: could not find program unit being called: "SYS.DBMS_SERVER_ALERT_EXPORT" ORA-06512: at line 1 ORA-06512: at line 1 ORA-06512: at "SYS.DBMS_METADATA", line 11063 ORA-06512: at "SYS.DBMS_SYS_ERROR", line 95 Processing object type DATABASE_EXPORT/SCHEMA/PROCACT_SCHEMA Á¶Ä¡ SQL> startup upgrade SQL > @?/rdbms/admin/catproc.sql SQL > @?/rdbms/admin/utlrp.sql ORA-4063 Encountered in Alert Log When Generating Server Alert SMG-4121 (Doc ID 467721.1) ORA-4063 Encountered When Generating Server Alert SMG-4120/SMG-4121 (Doc ID 1632720.1) [ SYS@orcl> ALTER PACKAGE SYS.DBMS_SERVER_ALERT_EXPORT COMPILE BODY; Warning: Package Body altered with compilation errors. SYS@orcl> show error Errors for PACKAGE BODY SYS.DBMS_SERVER_ALERT_EXPORT: LINE/COL ERROR -------- ----------------------------------------------------------------- 15/1     PL/SQL: SQL Statement ignored 18/8     PL/SQL: ORA-00942: table or view does not exist SYS@orcl>   216.73.216.15

LIST

CategoryTroubleshootStudy BookTuningBackup and RecoveryScriptInstall and ConfigApplication ServerAdminDULToolQ/ARAC,OPStrc filePro*CSQL,PL*SQLPatchTimes TenOracle GoldenGateWebLogicExadata	Á¦¸ñ	ÀÛ¼ºÀÚ	ÀÛ¼ºÀÏ	Á¶È¸
Admin	[ °øÁö ] 😃 ================ ÇÊ¿ä ÇÒ¶§¸¸ ¿î¿µ ÇÕ´Ï´Ù. ¾ÈµÇ¸é ³ªÁß¿¡ ´Ù½Ã ¹æ¹® ÇØÁÖ¼¼¿ä~. =================== 😅	ÃÖ±æÈ£	2008/11/26	116
Admin	[ ÇÊ¿ä ÇÏ½Å°Ô ÀÖÀ¸½Ã¸é ÂÊÁö ¶Ç´Â gilho.kr@gmail.com ¸ÞÀÏ ÁÖ¼¼¿ä~ ]	ÃÖ±æÈ£	2006/07/14	137
Admin	ORA-21780: Maximum number of object durations exceeded.	ÃÖ±æÈ£	2025/09/11	4
Admin	PRVG-0282 : failed to retrieve the operating system distribution ID	ÃÖ±æÈ£	2025/09/08	7
Admin	openSUSE 15.6 Oracle 11.2 / ORA-07445 [nttaddr2bnd()+2158] / dispatchers	ÃÖ±æÈ£	2025/09/08	9
Install and Config	openSUSE 15 oracle 19c	ÃÖ±æÈ£	2025/09/08	9
Admin	PLS-00201: identifier 'DMSYS.DBMS_DM_MODEL_EXP' must be declared	ÃÖ±æÈ£	2025/09/08	4
Admin	impdp CREATE TABLE ... DEFAULT "SCOTT"."ISEQ$$_3969939".NEXTVAL	ÃÖ±æÈ£	2025/09/06	4
Admin	alter table shrink	ÃÖ±æÈ£	2025/08/27	19
Admin	ORA-15028: ASM file not dropped; currently being accessed (DBD ERROR: OCIStmtExecute)	ÃÖ±æÈ£	2025/08/27	14
Admin	12.1 Migrate a Non-Container Database (CDB) to a Pluggable Database (PDB) / cdb to pdb	ÃÖ±æÈ£	2025/08/19	14
Admin	PX Deq: Execute Reply	ÃÖ±æÈ£	2025/08/06	13
SQL,PL*SQL	GROUPING ROLLUP PARTITION BY RULES group by ceil	ÃÖ±æÈ£	2025/08/02	14

¸ñ·Ïº¸±â   ´ÙÀ½ÆäÀÌÁö

1 [2][3][4][5][6][7][8][9][10]..[163]   [´ÙÀ½ 10°³]

Copyright 1999-2025 Zeroboard / skin by ÃÖ±æÈ£(gilho.kr@gmail.com)