3.1执行安装命令
在其中一个节点上的oracle账号下执行,我这里是在节点1上执行的
[root@rac01 /]# su - oracle
Last login: Thu Dec 17 03:34:11 EST 2020 on pts/0
[oracle@rac01 ~]$ emca -config dbcontrol db -repos create -cluster
[oracle@rac01 ~]$ emca -config dbcontrol db -repos create -cluster
STARTED EMCA at Dec 17, 2020 4:20:49 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: slnngk Service name: slnngk Listener port number: 1521 Listener ORACLE_HOME [ /u01/grid/grid_home/11.2.0.4 ]: 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/grid/grid_home/11.2.0.4 ]: ASM port [ 1521 ]: ASM username [ ASMSNMP ]: ASM user password: -----------------------------------------------------------------
You have specified the following settings
Database ORACLE_HOME ................ /u01/oracle/app/product/11.2.0/db_1
Database instance hostname ................ Listener ORACLE_HOME ................ /u01/grid/grid_home/11.2.0.4 Listener port number ................ 1521 Cluster name ................ rac-cluster Database unique name ................ slnngk Email address for notifications ............... Outgoing Mail (SMTP) server for notifications ............... ASM ORACLE_HOME ................ /u01/grid/grid_home/11.2.0.4 ASM port ................ 1521 ASM user role ................ SYSDBA ASM username ................ ASMSNMP
----------------------------------------------------------------- Do you wish to continue? [yes(Y)/no(N)]: y Dec 17, 2020 4:21:37 AM oracle.sysman.emcp.EMConfig perform INFO: This operation is being logged at /u01/oracle/app/cfgtoollogs/emca/slnngk/emca_2020_12_17_04_20_49.log. Dec 17, 2020 4:21:39 AM oracle.sysman.emcp.EMReposConfig createRepository INFO: Creating the EM repository (this may take a while) ... Dec 17, 2020 4:28:55 AM oracle.sysman.emcp.EMReposConfig invoke INFO: Repository successfully created Dec 17, 2020 4:29:03 AM oracle.sysman.emcp.EMReposConfig uploadConfigDataToRepository INFO: Uploading configuration data to EM repository (this may take a while) ... Dec 17, 2020 4:30:01 AM oracle.sysman.emcp.EMReposConfig invoke INFO: Uploaded configuration data successfully Dec 17, 2020 4:30:01 AM oracle.sysman.emcp.EMDBCConfig instantiateOC4JConfigFiles INFO: Propagating /u01/oracle/app/product/11.2.0/db_1/oc4j/j2ee/OC4J_DBConsole_rac01_slnngk to remote nodes ... Dec 17, 2020 4:30:03 AM oracle.sysman.emcp.EMDBCConfig instantiateOC4JConfigFiles INFO: Propagating /u01/oracle/app/product/11.2.0/db_1/oc4j/j2ee/OC4J_DBConsole_rac02_slnngk to remote nodes ... Dec 17, 2020 4:30:09 AM oracle.sysman.emcp.EMAgentConfig deployStateDirs INFO: Propagating /u01/oracle/app/product/11.2.0/db_1/rac01_slnngk to remote nodes ... Dec 17, 2020 4:30:10 AM oracle.sysman.emcp.EMAgentConfig deployStateDirs INFO: Propagating /u01/oracle/app/product/11.2.0/db_1/rac02_slnngk to remote nodes ... Dec 17, 2020 4:30:12 AM oracle.sysman.emcp.util.DBControlUtil secureDBConsole INFO: Securing Database Control (this may take a while) ... Dec 17, 2020 4:30:36 AM oracle.sysman.emcp.util.DBControlUtil startOMS INFO: Starting Database Control (this may take a while) ... Dec 17, 2020 4:33:21 AM oracle.sysman.emcp.EMDBPostConfig performConfiguration INFO: Database Control started successfully Dec 17, 2020 4:33:21 AM oracle.sysman.emcp.EMDBPostConfig performConfiguration INFO: >>>>>>>>>>> The Database Control URL is https://rac01:1158/em <<<<<<<<<<< Dec 17, 2020 4:34:00 AM oracle.sysman.emcp.EMDBPostConfig showClusterDBCAgentMessage INFO: **************** Current Configuration **************** INSTANCE NODE DBCONTROL_UPLOAD_HOST ---------- ---------- ---------------------
slnngk rac01 rac01 slnngk rac02 rac01
Dec 17, 2020 4:34:00 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: /u01/oracle/app/product/11.2.0/db_1/rac01_slnngk/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 Dec 17, 2020 4:34:00 AM
|
这里的Cluster name: rac-cluster
可以通过如下命令获取:
[grid@rac01 admin]$ cemutlo -n
rac-cluster
3.登陆
根据安装提示进行登陆
https://rac01:1158/em
客户端我们换成具体的ip进行访问
节点1上的三个ip都可以访问
https://节点1公共ip:1158/em
https://节点1vip:1158/em
下面这里我们是通过scan-ip进行访问的
3.2遇到的问题
问题1:
WARNING: Error during db connection : ORA-12514: TNS:listener does not currently know of service requested in connect descriptor
解决办法:
在节点1上的grid账号登陆asm实例修改remote_listener参数
[grid@rac01 admin]$ sqlplus /nolog
SQL*Plus: Release 11.2.0.4.0 Production on Thu Dec 17 04:02:36 2020
Copyright (c) 1982, 2013, Oracle. All rights reserved.
SQL> connect / as sysasm
Connected.
alter system set remote_listener='rac-scan:1521' scope=both sid='*';
SQL> set linesize 1000;
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
问题2:
将已经锁住的账号进行解锁
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
Dec 17, 2020 4:13:47 AM oracle.sysman.emcp.EMConfig perform
INFO: This operation is being logged at /u01/oracle/app/cfgtoollogs/emca/slnngk/emca_2020_12_17_04_13_24.log.
Dec 17, 2020 4:13:49 AM oracle.sysman.emcp.util.GeneralUtil initSQLEngineRemotely
WARNING: Error during db connection : ORA-28000: the account is locked
Dec 17, 2020 4:13:55 AM oracle.sysman.emcp.util.GeneralUtil initSQLEngineRemotely
WARNING: ORA-28000: the account is locked
解决办法:
Alter User sysman Account Unlock
问题3:
不知道为什么我安装好rac是没有配置em的,安装的时候提示已经安装,需要进行删除处理
Dec 17, 2020 3:53:03 AM oracle.sysman.emcp.DatabaseChecks performReposChecks
SEVERE: Dbcontrol Repository already exists. Fix the error(s) and run EM Configuration Assistant again in standalone mode.
解决办法:
$ emca -deconfig dbcontrol db -repos drop -cluster
cluster name获取
[grid@rac01 admin]$ cemutlo -n
rac-cluster
-- The End --