Oracle enterprise manager 13C 安装无法正常进行

最新推荐文章于 2025-09-18 13:09:53 发布

原创最新推荐文章于 2025-09-18 13:09:53 发布 · 799 阅读

0 ·

本内容遵循CC 4.0 BY-SA版权协议

本文记录了在安装Oracle Enterprise Manager 13c过程中遇到的问题及解决方案，包括因归档日志过多导致的空间不足错误ORA-00257，并详细介绍了如何调整归档设置和清理日志文件。

今天安装oracle enterprise managerer 13C 装到一半报了个错，卡住了。

查看日志

[root@GuoHui ~]# tail -f -n 1000 /u01/app/oracle/product/oem13.2/gc_inst/em/EMGC_OMS1/sysman/log/emctl.log

2022-08-22 18:46:35,556 [Thread-1] INFO commands.BaseCommand run.625 - <OUT>_END_
2022-08-22 18:46:35,579 [main] INFO commands.BaseCommand logAndPrint.673 - WebTier Successfully Started
2022-08-22 18:46:35,581 [main] ERROR commands.BaseCommand logAndPrint.671 - Oracle Management Server Could Not Be Started
Check EM Server log file for details: /u01/app/oracle/product/oem13.2/gc_inst/user_projects/domains/GCDomain/servers/EMGC_OMS1/logs/EMGC_OMS1.out
2022-08-22 18:46:35,581 [main] INFO commands.StartCommand startOMS.462 - startOMS finished with result: 1
2022-08-22 18:46:35,582 [main] INFO commands.BaseCommand logAndPrint.673 - Oracle Management Server is Down
2022-08-22 18:46:35,591 [main] INFO commands.BaseCommand printMessage.429 - statusOMS finished with result: 8
2022-08-22 18:46:35,593 [main] INFO ctrl_extn.EmctlCtrlExtnLoader logp.251 - Extensions found: 1
2022-08-22 18:46:35,593 [main] INFO ctrl_extn.EmctlCtrlExtnLoader logp.251 - Executing callback for extensible_sample
2022-08-22 18:46:35,593 [main] INFO ctrl_extn.EmctlCtrlExtnLoader logp.251 - jar is /u01/app/oracle/product/oem13.2/middleware/plugins/oracle.sysman.emas.oms.plugin_13.5.1.0.0/archives/jvmd/em-engines-emctl.jar; class is oracle.sysman.emctl.jvmd.JVMDEmctlStatusImpl
2022-08-22 18:46:35,605 [main] INFO ctrl_extn.EmctlCtrlExtnLoader logp.251 - Connection refused (Connection refused)
2022-08-22 18:46:35,605 [main] INFO ctrl_extn.EmctlCtrlExtnLoader logp.251 - rsp is 1 message is JVMD Engine is Down
2022-08-22 18:46:35,606 [main] INFO commands.BaseCommand printMessage.442 - extensible_sample rsp is 1 message is JVMD Engine is Down
2022-08-22 18:46:35,606 [main] INFO commands.BaseCommand logAndPrint.673 - JVMD Engine is Down
2022-08-22 18:46:35,606 [main] INFO commands.StartCommand startOMS.467 - retCode is 8

查看

[root@GuoHui ~]# tail -f /u01/app/oracle/product/oem13.2/gc_inst/user_projects/domains/GCDomain/servers/EMGC_OMS1/logs/EMGC_OMS1.out -n 500

java.sql.SQLException: ORA-00257: 归档程序错误。只有在解析完成后才以 AS SYSDBA 方式连接。

ORA-00257:archiver error解决办法

出现ORA-00257错误（空间不足错误），通过查找资料，绝大部分说这是由于归档日志太多，占用了全部的硬盘剩余空间导致的，通过简单删除日志或加大存储空间就能够解决。

(一)、oralce 11g更改归档模式、目录、日志大小

下一步，简单了。检查

SQL> select * from v$recovery_file_dest;

NAME
--------------------------------------------------------------------------------
SPACE_LIMIT SPACE_USED SPACE_RECLAIMABLE NUMBER_OF_FILES CON_ID
----------- ---------- ----------------- --------------- ----------
/u01/app/oracle/recovery_area
1.3350E+10 1.3318E+10 0 76 0

SQL> alter system set db_recovery_file_dest_size=21474836480;

System altered.

SQL> show parameter db_recovery_file_dest;

NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
db_recovery_file_dest string /u01/app/oracle/recovery_area
db_recovery_file_dest_size big integer 20G
SQL> alter database open;

Database altered.

然后 rman 全备份删除归档

[oracle@GuoHui ~]$ rman target /

Recovery Manager: Release 19.0.0.0.0 - Production on Fri Aug 26 17:18:07 2022
Version 19.3.0.0.0

connected to target database: ORCL (DBID=1639755690, not open)

RMAN> crosscheck archivelog all;
RMAN> backup database format '/home/oracle/backupdb/full_%d_%s_%p_%T' plus archivelog delete input;

[oracle@GuoHui bin]$ ./emctl start oms
Oracle Enterprise Manager Cloud Control 13c Release 5
Copyright (c) 1996, 2021 Oracle Corporation. All rights reserved.
Starting Oracle Management Server...
WebTier Successfully Started
Oracle Management Server Successfully Started
Oracle Management Server is Up
JVMD Engine is Up

标签

#oracle #数据库