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

今天安装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

Copyright (c) 1982, 2019, Oracle and/or its affiliates.  All rights reserved.

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