ORACLE11gR2 RAC EM 安装步骤

ORACLE RAC EM 安装步骤


Oracle环境：

版本：Oracle 11gR2 RAC （Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production）

Rac节点信息：

主机名    ?SID    SERVICE_NAME
rac1    racdb1    racdb
rac2    racdb2    racdb
Host文件：

cat /etc/hosts


安装过程：

1、创建asmsnmp用户：

su - grid
 
sqlplus / as sysasm
 
create user asmsnmp identified by 123456;
 
grant sysdba to asmsnmp;
2、ASM实例注册于listener_scan1：

alter system set remote_listener=‘racscan:1521‘ scope=both sid=‘*‘;
 
alter system register;


测试方法 登陆oracle用户执行：
 sqlplus asmsnmp/oracle@9.6.1.152:1521/+ASM as sysdba



3、查看cluster name：

/u01/app/11.2.0/grid/bin/cemutlo -n
4、重归EM：

su - oracle
 
emca -config dbcontrol db -repos recreate -cluster
配置过程如下：?

[[email?protected] ~]$ ?emca -config dbcontrol db -repos recreate -cluster

STARTED EMCA at Sep 29,2018 5:40:04 PM
EM Configuration Assistant,Version 11.2.0.0.2 Production
Copyright (c) 2003,2005,Oracle. ?All rights reserved.

Enter the following information:
Database unique name: racdb
Service name: racdb
Listener port number: 1521
Listener ORACLE_HOME [ /u01/app/11.2.0/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 [ /u01/app/11.2.0/grid ]:?
ASM port [ 1521 ]:?
ASM username [ ASMSNMP ]:?
ASM user password: ?
-----------------------------------------------------------------

You have specified the following settings

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

Database instance hostname ................ rac1
Listener ORACLE_HOME ................ /u01/app/11.2.0/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 ................ /u01/app/11.2.0/grid
ASM port ................ 1521
ASM user role ................ SYSDBA
ASM username ................ ASMSNMP

-----------------------------------------------------------------
Do you wish to continue? [yes(Y)/no(N)]: y
Sep 29,2018 5:41:06 PM oracle.sysman.emcp.EMConfig perform
INFO: This operation is being logged at /u01/app/oracle/cfgtoollogs/emca/racdb/emca_2018_09_29_17_40_04.log.
Sep 29,2018 5:41:09 PM oracle.sysman.emcp.EMReposConfig invoke
INFO: Dropping the EM repository (this may take a while) ...
Sep 29,2018 5:45:29 PM oracle.sysman.emcp.EMReposConfig invoke
INFO: Repository successfully dropped
Sep 29,2018 5:45:30 PM oracle.sysman.emcp.EMReposConfig createRepository
INFO: Creating the EM repository (this may take a while) ...
Sep 29,2018 5:53:53 PM oracle.sysman.emcp.EMReposConfig invoke
INFO: Repository successfully created
Sep 29,2018 5:53:59 PM oracle.sysman.emcp.EMReposConfig uploadConfigDataToRepository
INFO: Uploading configuration data to EM repository (this may take a while) ...
Sep 29,2018 5:55:00 PM oracle.sysman.emcp.EMReposConfig invoke
INFO: Uploaded configuration data successfully
Sep 29,2018 5:55:01 PM oracle.sysman.emcp.EMDBCConfig instantiateOC4JConfigFiles
INFO: Propagating /u01/app/oracle/product/11.2.0/dbhome_1/oc4j/j2ee/OC4J_DBConsole_rac1_racdb to remote nodes ...
Sep 29,2018 5:55:03 PM oracle.sysman.emcp.EMDBCConfig instantiateOC4JConfigFiles
INFO: Propagating /u01/app/oracle/product/11.2.0/dbhome_1/oc4j/j2ee/OC4J_DBConsole_rac2_racdb to remote nodes ...
Sep 29,2018 5:55:09 PM oracle.sysman.emcp.EMAgentConfig deployStateDirs
INFO: Propagating /u01/app/oracle/product/11.2.0/dbhome_1/rac1_racdb to remote nodes ...
Sep 29,2018 5:55:11 PM oracle.sysman.emcp.EMAgentConfig deployStateDirs
INFO: Propagating /u01/app/oracle/product/11.2.0/dbhome_1/rac2_racdb to remote nodes ...
Sep 29,2018 5:55:13 PM oracle.sysman.emcp.EMDBPostConfig configureSoftwareLibrary
INFO: ?Location /u01/app/oracle/product/11.2.0/dbhome_1/EMStagePatches_racdb is not shared. Software library could not be configured. Provisioning archives will not be deployed. Please configure it manually.?
Sep 29,2018 5:55:13 PM oracle.sysman.emcp.util.DBControlUtil secureDBConsole
INFO: Securing Database Control (this may take a while) ...
Sep 29,2018 5:55:32 PM oracle.sysman.emcp.util.DBControlUtil startOMS
INFO: Starting Database Control (this may take a while) ...
Sep 29,2018 5:58:24 PM oracle.sysman.emcp.EMDBPostConfig performConfiguration
INFO: Database Control started successfully
Sep 29,2018 5:58:25 PM oracle.sysman.emcp.EMDBPostConfig performConfiguration
INFO: >>>>>>>>>>> The Database Control URL is https://rac1:1158/em <<<<<<<<<<<
Sep 29,2018 5:58:32 PM oracle.sysman.emcp.EMDBPostConfig showClusterDBCAgentMessage
INFO:?
**************** ?Current Configuration ?****************
?INSTANCE ? ? ? ? ? ?NODE ? ? ? ? ? DBCONTROL_UPLOAD_HOST
---------- ? ? ? ?---------- ? ? ? ?---------------------

racdb ? ? ? ? ? ? rac1 ? ? ? ? ? ? ?rac1
racdb ? ? ? ? ? ? rac2 ? ? ? ? ? ? ?rac1


Sep 29,2018 5:58:32 PM 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: /u01/app/oracle/product/11.2.0/dbhome_1/rac1_racdb/sysman/config/emkey.ora. ? Please 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 Sep 29,2018 5:58:33 PM

5、启动EM：?

分别在两个节点的oracle用户下运行：

[[email?protected] ~]$ emctl start dbconsole
Oracle Enterprise Manager 11g Database Control Release 11.2.0.1.0?
Copyright (c) 1996,2009 Oracle Corporation. ?All rights reserved.
https://rac1:1158/em/console/aboutApplication
Starting Oracle Enterprise Manager 11g Database Control .............. started.?
------------------------------------------------------------------
Logs are generated in directory /u01/app/oracle/product/11.2.0/dbhome_1/rac1_racdb/sysman/log?
?

[[email?protected] ~]$ emctl start dbconsole
Oracle Enterprise Manager 11g Database Control Release 11.2.0.1.0?
Copyright (c) 1996,2009 Oracle Corporation. ?All rights reserved.
https://rac1:1158/em/console/aboutApplication
Starting Oracle Enterprise Manager 11g Database Control .......... started.?
------------------------------------------------------------------
Logs are generated in directory /u01/app/oracle/product/11.2.0/dbhome_1/rac2_racdb/sysman/log?

6、在IE浏览器中打开地址：https://racscan:1158/em ，登录即可

===================================================================================================================================================


遇到的问题

SQL> create user asmsnmp identified by oracle;
create user asmsnmp identified by oracle
                                  *
ERROR at line 1:
ORA-15306: ASM password file update failed on at least one node



解决方法

Creating ASMSNMP User reports ORA-15306: ASM Password File Update Failed On At Least One Node. (Doc ID 1137504.1)

In this Document
  Symptoms
  Cause
  Solution


Applies to:
Oracle Server - Enterprise Edition - Version: 11.1.0.7 and later   [Release: 11.1 and later ]
Information in this document applies to any platform.
Symptoms
Creating the ASMSNMP user on 11.2 ASM RAC reports the next error:


SQL> create user asmsnmp identified by test01;
create user asmsnmp identified by test01
*
ERROR at line 1:
ORA-15306: ASM password file update failed on at least one node

Cause
The ORA-15306 error demonstrates that the ASM password file is missing in one or several node(s) or it is corrupt.
Solution
1) Remove all the ASM password files from each node:

rm Grid Oracle Home/dbs/orapw+ASM1
rm Grid Oracle Home/dbs/orapw+ASM2
.
.
rm Grid Oracle Home/dbs/orapw+ASM<..n>


2) Create ASM password file manually on the first node as the OS user which owns the Grid Infrastructure:


$> orapwd file=‘orapw+ASM1‘ entries=5 password=<here your password>


3) Copy the password file to all nodes with the correct ASM instance name:


scp orapw+ASM1 to remote node : Grid Oracle Home/dbs/orapw+ASM2
scp orapw+ASM1 to remote node : Grid Oracle Home/dbs/orapw+ASM3
.
.
scp orapw+ASM1 to remote node : Grid Oracle Home/dbs/orapw+ASM<..n>


4) Add the ASMSNMP user in ASM instance,and grant sysdba privilege to it:



SQL> create user asmsnmp identified by <password>;


SQL> grant sysdba to asmsnmp;

5) Verify the ASMSNMP user was created:


SQL> select * from v$pwfile_users;

USERNAME SYSDB SYSOP SYSAS
------------------------------ ----- ----- -----
SYS TRUE TRUE TRUE
ASMSNMP TRUE FALSE FALSE



===========================================================================================


自我安装日志如下：

节点1
$ orapwd file=‘orapw+ASM1‘ entries=5 password=oracle

节点2
$ orapwd file=‘orapw+ASM2‘ entries=5 password=oracle



====================================================================================



$ emca -config dbcontrol db -repos recreate -cluster

STARTED EMCA at Oct 10,2019 2:50:13 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: boss
Service name: boss
Listener port number: 1521
Listener ORACLE_HOME [ /u01/app/11.2/grid ]: 
Password for SYS user:  
Password for DBSNMP user:  
Password for SYSMAN user:  
Cluster name: boss-cluster
Email address for notifications (optional): 
Outgoing Mail (SMTP) server for notifications (optional): 
ASM ORACLE_HOME [ /u01/app/11.2/grid ]: 
ASM port [ 1521 ]: 
ASM username [ ASMSNMP ]: 
ASM user password:  
Oct 10,2019 2:51:32 PM oracle.sysman.emcp.util.GeneralUtil initSQLEngineRemotely
WARNING: Error during db connection : ORA-12514: TNS:listener does not currently know of service requested in connect descriptor

-----------------------------------------------------------------

You have specified the following settings

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

Database instance hostname ................ Listener ORACLE_HOME ................ /u01/app/11.2/grid
Listener port number ................ 1521
Cluster name ................ boss-cluster
Database unique name ................ boss
Email address for notifications ............... 
Outgoing Mail (SMTP) server for notifications ............... 
ASM ORACLE_HOME ................ /u01/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)]: y
Oct 10,2019 2:51:48 PM oracle.sysman.emcp.EMConfig perform
INFO: This operation is being logged at /u01/app/oracle/cfgtoollogs/emca/boss/emca_2019_10_10_14_50_13.log.
Oct 10,2019 2:51:55 PM oracle.sysman.emcp.EMReposConfig invoke
INFO: Dropping the EM repository (this may take a while) ...
Oct 10,2019 2:54:00 PM oracle.sysman.emcp.EMReposConfig invoke
INFO: Repository successfully dropped
Oct 10,2019 2:54:02 PM oracle.sysman.emcp.EMReposConfig createRepository
INFO: Creating the EM repository (this may take a while) ...


Oct 10,2019 3:03:07 PM oracle.sysman.emcp.EMReposConfig invoke
INFO: Repository successfully created
Oct 10,2019 3:03:14 PM oracle.sysman.emcp.EMReposConfig uploadConfigDataToRepository
INFO: Uploading configuration data to EM repository (this may take a while) ...
Oct 10,2019 3:05:13 PM oracle.sysman.emcp.EMReposConfig invoke
INFO: Uploaded configuration data successfully
Oct 10,2019 3:05:14 PM oracle.sysman.emcp.EMDBCConfig instantiateOC4JConfigFiles
INFO: Propagating /u01/app/oracle/product/11.2.0/dbhome_1/oc4j/j2ee/OC4J_DBConsole_node1_boss to remote nodes ...
Oct 10,2019 3:05:16 PM oracle.sysman.emcp.EMDBCConfig instantiateOC4JConfigFiles
INFO: Propagating /u01/app/oracle/product/11.2.0/dbhome_1/oc4j/j2ee/OC4J_DBConsole_node2_boss to remote nodes ...
Oct 10,2019 3:05:21 PM oracle.sysman.emcp.EMAgentConfig deployStateDirs
INFO: Propagating /u01/app/oracle/product/11.2.0/dbhome_1/node1_boss to remote nodes ...
Oct 10,2019 3:05:23 PM oracle.sysman.emcp.EMAgentConfig deployStateDirs
INFO: Propagating /u01/app/oracle/product/11.2.0/dbhome_1/node2_boss to remote nodes ...
Oct 10,2019 3:05:26 PM oracle.sysman.emcp.util.DBControlUtil secureDBConsole
INFO: Securing Database Control (this may take a while) ...
Oct 10,2019 3:06:08 PM oracle.sysman.emcp.util.DBControlUtil startOMS
INFO: Starting Database Control (this may take a while) ...
Oct 10,2019 3:07:15 PM oracle.sysman.emcp.EMDBPostConfig performConfiguration
INFO: Database Control started successfully
Oct 10,2019 3:07:15 PM oracle.sysman.emcp.EMDBPostConfig performConfiguration
INFO: >>>>>>>>>>> The Database Control URL is https://node1:1158/em <<<<<<<<<<<
Oct 10,2019 3:07:20 PM oracle.sysman.emcp.EMDBPostConfig showClusterDBCAgentMessage
INFO: 
****************  Current Configuration  ****************
 INSTANCE            NODE           DBCONTROL_UPLOAD_HOST
----------        ----------        ---------------------

boss              node1              node1
boss              node2              node1


Oct 10,2019 3:07:20 PM 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: /u01/app/oracle/product/11.2.0/dbhome_1/node1_boss/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 Oct 10,2019 3:07:20 PM
$ 
$ 
$ 

（编辑：宁德站长网）

【声明】本站内容均来自网络，其相关言论仅代表作者个人观点，不代表本站立场。若无意侵犯到您的权利，请及时与联系站长删除相关内容!