oracle RAC
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檔案:
安裝過程:
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;
3、檢視cluster name:
/u01/app/11.2.0/grid/bin/cemutlo -n
4、重歸EM:
su - oracle
emca -config dbcontrol db -repos recreate -cluster
配置過程如下:
[oracle@rac1 ~]$ 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 <<<<<<<<<<<
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使用者下執行:
[oracle@rac1 ~]$ emctl start dbconsole
Oracle Enterprise Manager 11g Database Control Release 11.2.0.1.0
Copyright (c) 1996, 2009 Oracle Corporation. All rights reserved.
/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
[oracle@rac2 ~]$ emctl start dbconsole
Oracle Enterprise Manager 11g Database Control Release 11.2.0.1.0
Copyright (c) 1996, 2009 Oracle Corporation. All rights reserved.
/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瀏覽器中開啟地址: ,登入即可
點贊 2
收藏
分享
白晝ron 部落格專家
釋出了167 篇原創文章 · 獲贊 145 · 訪問量 104萬+
他的留言板
關注
展開閱讀
————————————————
版權宣告:本文為CSDN博主「白晝ron」的原創文章,遵循 CC 4.0 BY-SA 版權協議,轉載請附上原文出處連結及本宣告。
原文連結:https://blog.csdn.net/xiezuoyong/article/details/82905151
來自 “ ITPUB部落格 ” ,連結:http://blog.itpub.net/69949806/viewspace-2671047/,如需轉載,請註明出處,否則將追究法律責任。
相關文章
- Oracle RAC Cache Fusion 系列十七:Oracle RAC DRMOracle
- Oracle 11.2 DataGuard RAC To RAC搭建Oracle
- Oracle RAC CacheFusion 系列十五:Oracle RAC CRServer Part TwoOracleServer
- ORACLE RAC clusterwareOracle
- Oracle RAC Cache Fusion系列十八:Oracle RAC Statisticsand Wait EventsOracleAI
- Oracle RAC Cache Fusion 系列十四:Oracle RAC CR Server Part OneOracleServer
- Oracle RAC Cache Fusion 系列十:Oracle RAC Enqueues And Lock Part 1OracleENQ
- 【RAC】Oracle RAC如何修改心跳網路Oracle
- Oracle RAC Wait EventsOracleAI
- oracle rac 增加磁碟Oracle
- 【RAC】Oracle rac 如何修改公網及vipOracle
- Oracle RAC Cache Fusion 系列九:Oracle RAC 分散式資源管理(二)Oracle分散式
- Oracle RAC Cache Fusion 系列八:Oracle RAC 分散式資源管理(一)Oracle分散式
- Oracle RAC+DG搭建Oracle
- Oracle RAC更新補丁Oracle
- Oracle RAC新增節點Oracle
- 4.2.1.12 規劃 Oracle RACOracle
- Oracle RAC自啟動Oracle
- Networker備份oracle racOracle
- Oracle:RAC 程式簡介Oracle
- G003-ORACLE-INS-RAC-01 ORACLE 19C RAC Ins ON OEL 7.8Oracle
- 【BUILD_ORACLE】Oracle 19c RAC搭建(六)建立RAC資料庫UIOracle資料庫
- Oracle RAC一鍵部署004(RAC引數校驗)Oracle
- 【RAC】Oracle RAC上線測試場景介紹Oracle
- Oracle RAC序列效能測試Oracle
- oracle RAC手動配置互信Oracle
- Oracle:Oracle RAC 11.2.0.4 升級為 19cOracle
- 【RAC】Oracle rac修改IP地址及埠號命令參考Oracle
- oracle rac 核心引數詳解Oracle
- Oracle RAC修改public, VIP, SCAN IPOracle
- Oracle 12.2 RAC on Linux Best Practice DocumentationOracleLinux
- Centos7.2_Oracle12.1.0.2_RAC_installCentOSOracle
- oracle rac 11.2.0.3 升級到11.2.0.4Oracle
- Oracle RAC一鍵部署大綱Oracle
- Oracle RAC簡介與要點Oracle
- about oracle10g rac(轉)Oracle
- Oracle rac時間不同步Oracle
- ORACLE19C RAC+DGOracle