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

发布于:2023-01-04 ⋅ 阅读:(402) ⋅ 点赞:(0)

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


网站公告

今日签到

点亮在社区的每一天
去签到