11g DBcontrol(OEM)for 2 Nodes Rac on Linux

1.准备工作

前提1:检查是否已有EM组件
set pagesize 999
col comp_name for a50
set linesize 180
select comp_id,comp_name,version,status,startup from dba_registry;
COMP_ID             COMP_NAME                               VERSION           STATUS
------------------- --------------------------------------- ------------------------------
EM                  Oracle Enterprise Manager               11.2.0.4.0        VALID
OWB                 OWB                                     11.2.0.4.0        VALID
APEX                Oracle Application Express              3.2.1.00.12       VALID
AMD                 OLAP Catalog                            11.2.0.4.0        VALID
SDO                 Spatial                                 11.2.0.4.0        VALID
ORDIM               Oracle Multimedia                       11.2.0.4.0        VALID
XDB                 Oracle XML Database                     11.2.0.4.0        VALID
CONTEXT             Oracle Text                             11.2.0.4.0        VALID
EXF                 Oracle Expression Filter                11.2.0.4.0        VALID
RUL                 Oracle Rules Manager                    11.2.0.4.0        VALID
OWM                 Oracle Workspace Manager                11.2.0.4.0        VALID
CATALOG             Oracle Database Catalog Views           11.2.0.4.0        VALID
CATPROC             Oracle Database Packages and Types      11.2.0.4.0        VALID
JAVAVM              JServer JAVA Virtual Machine            11.2.0.4.0        VALID
XML                 Oracle XDK                              11.2.0.4.0        VALID
CATJAVA             Oracle Database Java Packages           11.2.0.4.0        VALID
APS                 OLAP Analytic Workspace                 11.2.0.4.0        VALID
XOQ                 Oracle OLAP API                         11.2.0.4.0        VALID
RAC                 Oracle Real Application Clusters        11.2.0.4.0        VALID


前提2:ASM实例的remote listener 需要使用scan listener
IMPORTANT:
1. Starting with 11.2, SCAN listener configuration is mandatory when configuring Database Control in an Oracle RAC environment
    Please check the Document 1188736.1 - How to Setup SCAN Listener and Client for TAF and Load Balancing
2. Starting with 11.2 EMCA, the reconfig command uses the parameter -EM_NODE_LIST instead of -EM_SID_LIST
    Example:
    $ emca -reconfig dbcontrol -cluster -EM_NODE <node1> -EM_NODE_LIST <node1,node2,nodeN>
Reference:How to manage DB Control 11.x for RAC Database with emca (文档 ID 578011.1)

设置asm实例的remote listener:
grid@rac01 ~]$ sqlplus / as sysasm
SQL*Plus: Release 11.2.0.4.0 Production on Wed Nov 16 04:16:52 2016
Copyright (c) 1982, 2013, Oracle.  All rights reserved.

Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
With the Real Application Clusters and Automatic Storage Management options
SQL> show parameter listener
NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
listener_networks                    string
local_listener                       string       (DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=192.168.12.11)(PORT=1521))))
remote_listener                      string
SQL> alter system set remote_listener='rac-scan:1521';
System altered.
SQL> alter system register;
System altered.
SQL> show parameter remote
NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
remote_listener                      string      rac-scan:1521
remote_login_passwordfile            string      EXCLUSIVE
remote_os_authent                    boolean     FALSE
remote_os_roles                      boolean     FALSE



如果通过管理命令无法查看服务命令,则需要重建,过程如下:
1)获取cluster名
#su - grid$ cd $ORACLE_HOME/bin$ ./cemutlo -n$rac-cluster

2)或者设置好如下账号的密码
DBSNMP/SYS/SYSMAN, ASMSNMP
注:ASMSNMP如不记得密码,直接以grid用户下登录SQLPLUS / AS SYSASM方式更改即可。

3)开始重建
$emca -config dbcontrol db -repos recreate -cluster //因为原来有过em组件但无法使用,顾选择重建
STARTED EMCA at Nov 16, 2016 4:35:14 AM
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: racdb
Service name: racdb
Listener port number: 1521
Listener ORACLE_HOME [ /oracle/app/11.2/grid ]: 
Password for SYS user:  
Password for DBSNMP user:  
Password for SYSMAN user:  
Cluster name: rac-cluster
Email address for notifications (optional): 
Outgoing Mail (SMTP) server for notifications (optional): 
ASM ORACLE_HOME [ /oracle/app/11.2/grid ]: 
ASM port [ 1521 ]: 
ASM username [ ASMSNMP ]: 
ASM user password:  
-----------------------------------------------------------------
You have specified the following settings
Database ORACLE_HOME ................ /oracle/app/oracle/product/11.2.0
Database instance hostname ................ Listener ORACLE_HOME ................ /oracle/app/11.2/grid
Listener port number ................ 1521
Cluster name ................ rac-cluster
Database unique name ................ racdb
Email address for notifications ............... 
Outgoing Mail (SMTP) server for notifications ............... 
ASM ORACLE_HOME ................ /oracle/app/11.2/grid
ASM port ................ 1521
ASM user role ................ SYSDBA
ASM username ................ ASMSNMP
----------------------------------------------------------------------
WARNING : While repository is dropped the database will be put in quiesce mode.
----------------------------------------------------------------------
Do you wish to continue? [yes(Y)/no(N)]: yes
Nov 16, 2016 4:35:48 AM oracle.sysman.emcp.EMConfig perform
INFO: This operation is being logged at /oracle/app/oracle/cfgtoollogs/emca/racdb/emca_2016_11_16_04_35_14.log.
Nov 16, 2016 4:35:51 AM oracle.sysman.emcp.EMReposConfig invoke
INFO: Dropping the EM repository (this may take a while) ...
Nov 16, 2016 4:40:20 AM oracle.sysman.emcp.EMReposConfig invoke
INFO: Repository successfully dropped
Nov 16, 2016 4:40:21 AM oracle.sysman.emcp.EMReposConfig createRepository
INFO: Creating the EM repository (this may take a while) ...
Nov 16, 2016 4:50:08 AM oracle.sysman.emcp.EMReposConfig invoke
INFO: Repository successfully created
Nov 16, 2016 4:50:22 AM oracle.sysman.emcp.EMReposConfig uploadConfigDataToRepository
INFO: Uploading configuration data to EM repository (this may take a while) ...
Nov 16, 2016 4:52:03 AM oracle.sysman.emcp.EMReposConfig invoke
INFO: Uploaded configuration data successfully
Nov 16, 2016 4:52:03 AM oracle.sysman.emcp.EMDBCConfig instantiateOC4JConfigFiles
INFO: Propagating /oracle/app/oracle/product/11.2.0/oc4j/j2ee/OC4J_DBConsole_rac01_racdb to remote nodes ...
Nov 16, 2016 4:52:05 AM oracle.sysman.emcp.EMDBCConfig instantiateOC4JConfigFiles
INFO: Propagating /oracle/app/oracle/product/11.2.0/oc4j/j2ee/OC4J_DBConsole_rac02_racdb to remote nodes ...
Nov 16, 2016 4:52:09 AM oracle.sysman.emcp.EMAgentConfig deployStateDirs
INFO: Propagating /oracle/app/oracle/product/11.2.0/rac01_racdb to remote nodes ...
Nov 16, 2016 4:52:11 AM oracle.sysman.emcp.EMAgentConfig deployStateDirs
INFO: Propagating /oracle/app/oracle/product/11.2.0/rac02_racdb to remote nodes ...
Nov 16, 2016 4:52:13 AM oracle.sysman.emcp.util.DBControlUtil secureDBConsole
INFO: Securing Database Control (this may take a while) ...
Nov 16, 2016 4:52:37 AM oracle.sysman.emcp.util.DBControlUtil startOMS
INFO: Starting Database Control (this may take a while) ...
Nov 16, 2016 4:54:18 AM oracle.sysman.emcp.EMDBPostConfig performConfiguration
INFO: Database Control started successfully
Nov 16, 2016 4:54:18 AM oracle.sysman.emcp.EMDBPostConfig performConfiguration
INFO: >>>>>>>>>>> The Database Control URL is https://rac01:1158/em <<<<<<<<<<<
Nov 16, 2016 4:54:28 AM oracle.sysman.emcp.EMDBPostConfig showClusterDBCAgentMessage
INFO: 
****************  Current Configuration  ****************
 INSTANCE            NODE           DBCONTROL_UPLOAD_HOST
----------        ----------        ---------------------
racdb             rac01             rac01
racdb             rac02             rac01
Nov 16, 2016 4:54:28 AM oracle.sysman.emcp.EMDBPostConfig invoke
WARNING: 
************************  WARNING  ************************
Management Repository has been placed in secure mode wherein Enterprise Manager data will be encrypted.  The encryption key has been placed in the file: /oracle/app/oracle/product/11.2.0/rac01_racdb/sysman/config/emkey.ora. Ensure this file is backed up as the encrypted data will become unusable if this file is lost. 
***********************************************************
Enterprise Manager configuration completed successfully
FINISHED EMCA at Nov 16, 2016 4:54:29 AM

提醒:使用hostname代替IP地址访问rac的em,https://rac01:1158/em

Reference :How to manage DB Control 11.x for RAC Database with emca (文档 ID 578011.1)


如果安装过程中遇到如下问题:

WARNING: ORA-28003: password verification for the specified password failedORA-20006: Password too simple

参考:EMCA: RepManager Fails With Password Verification Error ORA-28003 (文档 ID 779098.1)



  • 0
    点赞
  • 0
    收藏
    觉得还不错? 一键收藏
  • 0
    评论
要在Linux上进行Oracle 11g的静默安装,你可以按照以下步骤进行操作: 1. 首先,确保你已经下载了适用于Linux的Oracle 11g安装程序,并将其解压到一个目录中。 2. 在解压的目录中,找到并编辑一个名为"response"的文件。这个文件将包含安装期间需要的所有配置信息。你可以根据自己的需求进行相应的修改。 3. 在"response"文件中,设置以下参数: - ORACLE_HOSTNAME:主机名 - ORACLE_UNQNAME:唯一数据库名称 - ORACLE_BASE:Oracle软件的安装目录 - ORACLE_HOME:Oracle实例的目录 - oracle.install.db.InstallEdition:安装版本(EE/SE) - oracle.install.db.OSDBA_GROUP:OSDBA组名称 - oracle.install.db.OSOPER_GROUP:OSOPER组名称 - oracle.install.db.OSBACKUPDBA_GROUP:OSBACKUPDBA组名称 - oracle.install.db.OSDGDBA_GROUP:OSDGDBA组名称 - oracle.install.db.OSKMDBA_GROUP:OSKMDBA组名称 - oracle.install.db.CLUSTER_NODES:集群节点名称(如果不是集群安装,则留空) - oracle.install.db.isRAC:是否是RAC安装(true/false) - oracle.install.db.rac.serverpoolCardinality:RAC服务器池基数(如果不是RAC安装,则留空) - oracle.install.db.config.starterdb.type:数据库类型(SI/ASM) - oracle.install.db.config.starterdb.globalDBName:全局数据库名称 - oracle.install.db.config.starterdb.SID:数据库实例SID - oracle.install.db.config.starterdb.memoryLimit:内存限制(以MB为单位) 4. 保存并关闭"response"文件。 5. 在终端中,使用root用户执行以下命令以启动静默安装: ``` ./runInstaller -silent -responseFile /path/to/response/file ``` 其中,"/path/to/response/file"是你保存的"response"文件的路径。 6. 安装程序将开始执行,并根据你在"response"文件中设置的参数进行安装。安装过程中不会显示图形界面,所有配置信息都将使用"response"文件中的值。 7. 安装完成后,你可以执行必要的配置步骤,如创建数据库、设置监听器等。 请注意,这只是一个简单的概述,具体的步骤可能会因为你的环境和需求而有所不同。在进行静默安装之前,建议先阅读相关的文档和官方指南,以确保正确配置和成功安装Oracle 11g

“相关推荐”对你有帮助么?

  • 非常没帮助
  • 没帮助
  • 一般
  • 有帮助
  • 非常有帮助
提交
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值