RAC config OEM

最新推荐文章于 2021-04-10 18:04:42 发布

原创最新推荐文章于 2021-04-10 18:04:42 发布 · 648 阅读

0 ·

CC 4.0 BY-SA版权

本文记录了使用Oracle EM Configuration Assistant (EMCA)进行EM仓库的创建与删除过程。涉及数据库唯一名称、监听端口等配置信息，并展示了具体操作步骤及警告信息。

Cemutlo -n

check cluster name for RAC.

Database SID: ^C[oracle@3ichatdb01 ~]$
[oracle@3ichatdb01 ~]$ emca -deconfig dbcontrol db -repos drop -cluster

STARTED EMCA at Apr 7, 2015 4:12:57 PM
EM Configuration Assistant, Version 11.2.0.3.0 Production
Copyright (c) 2003, 2011, Oracle.  All rights reserved.

Enter the following information:
Database unique name: thichat
Service name: thichat
Listener port number: 1526
Listener ORACLE_HOME [ /oracle/grid ]:
Password for SYS user:
Password for SYSMAN user:
Password for SYSMAN user: ----------------------------------------------------------------------
WARNING : While repository is dropped the database will be put in quiesce mode.
----------------------------------------------------------------------
Do you wish to continue? [yes(Y)/no(N)]: y
Apr 7, 2015 4:13:21 PM oracle.sysman.emcp.EMConfig perform
INFO: This operation is being logged at /oracle/oracle/cfgtoollogs/emca/thichat/emca_2015_04_07_16_12_57.log.
Apr 7, 2015 4:13:23 PM oracle.sysman.emcp.EMDBPreConfig performDeconfiguration
WARNING: EM is not configured for this database. No EM-specific actions can be performed. Some of the possible reasons may be:
 1) EM is configured with different hostname then physical host. Set environment variable ORACLE_HOSTNAME=<hostname> and re-run EMCA script
 2) ORACLE_HOSTNAME is set. Unset it and re-run EMCA script
Apr 7, 2015 4:13:23 PM oracle.sysman.emcp.EMReposConfig invoke
INFO: Dropping the EM repository (this may take a while) ...
Apr 7, 2015 4:16:21 PM oracle.sysman.emcp.EMReposConfig invoke
INFO: Repository successfully dropped
Enterprise Manager configuration completed successfully
FINISHED EMCA at Apr 7, 2015 4:16:22 PM

















[oracle@3ichatdb01 ~]$ emca -config dbcontrol db -repos create -cluster

STARTED EMCA at Apr 7, 2015 4:05:44 PM
EM Configuration Assistant, Version 11.2.0.3.0 Production
Copyright (c) 2003, 2011, Oracle.  All rights reserved.

Enter the following information:
Database unique name: thichat
Service name: thichat
Listener port number: 1526
Listener ORACLE_HOME [ /oracle/grid ]:
Password for SYS user:
Password for DBSNMP user:
Password for SYSMAN user:
Password for SYSMAN user: Cluster name: thichat
Email address for notifications (optional):
Outgoing Mail (SMTP) server for notifications (optional): 172.25.14.141
ASM ORACLE_HOME [ /oracle/grid ]:
ASM port [ 1526 ]:
ASM username [ ASMSNMP ]:
ASM user password:
-----------------------------------------------------------------

You have specified the following settings

Database ORACLE_HOME ................ /oracle/oracle/product/11.2.0/dbhome_1

Database instance hostname ................ Listener ORACLE_HOME ...............                                  . /oracle/grid
Listener port number ................ 1526
Cluster name ................ thichat
Database unique name ................ thichat
Email address for notifications ...............
Outgoing Mail (SMTP) server for notifications ............... 172.25.14.141
ASM ORACLE_HOME ................ /oracle/grid
ASM port ................ 1526
ASM user role ................ SYSDBA
ASM username ................ ASMSNMP

-----------------------------------------------------------------
Do you wish to continue? [yes(Y)/no(N)]: y
Apr 7, 2015 4:06:54 PM oracle.sysman.emcp.EMConfig perform
INFO: This operation is being logged at /oracle/oracle/cfgtoollogs/emca/thichat/                                  emca_2015_04_07_16_05_44.log.
Apr 7, 2015 4:06:58 PM oracle.sysman.emcp.EMReposConfig createRepository
INFO: Creating the EM repository (this may take a while) ...
Apr 7, 2015 4:10:27 PM oracle.sysman.emcp.EMReposConfig createRepository
WARNING: ORA-00955: name is already used by an existing object