準(zhǔn)備軟件
jdk-7u67-linux-x64.tar.gz
em12.1.0.4_linux64_V45344-01.zip
em12.1.0.4_linux64_V45345-01.zip
em12.1.0.4_linux64_V45346-01.zip
操作系統(tǒng)配置
給 OS 空間 50G 以上裝完OS和CC后需要占用 30G 空間建議6G 內(nèi)存最少4G
1.安裝jdk
下載jdk-7u67-linux-x64.tar.gz并加壓縮重命名為jdk1.7抄邀,放到/usr目錄下面
vim /etc/profile
export JAVA_HOME=/usr/jdk1.7
export CLASSPATH=.:$JAVA_HOME/jre/lib/rt.jar:$JAVA_HOME/lib/dt.jar:$JAVA_HOME/lib/tools.jar
export PATH=$PATH:$JAVA_HOME/bin
source /etc/profile
2.安裝oracle 11.2.0.4
具體安裝步驟省略环础,本文檔主要介紹cloud control安裝
要求 repository database沒(méi)有配置DB control 柱锹,
如果有的話需要通過(guò)下列命令drop 掉:
export ORACLE_HOME= /u01/app/oracle/product/11.2.0/db_1
export ORACLE_SID= orcl
$ORACLE_HOME/bin/emca -deconfig dbcontrol db -repos drop
同時(shí)要求sysman 和 sysman_mds、 sysman_opss用戶不存在框冀,已創(chuàng)建該用戶的DB 可以drop 掉:
[oracle@xxx]$ sqlplus / as sysdba
a.刪除資料庫(kù)用戶:
drop user SYSMAN cascade;
drop user SYSMAN_MDS cascade;
drop user MGMT_VIEW cascade;
drop user SYSMAN_RO cascade;
drop user SYSMAN_OPSS cascade;
drop user SYSMAN_APM cascade;
drop user SYSMAN_BIP cascade;
drop user CLOUD_SWLIB_USER cascade;
drop user CLOUD_ENGINE_USER cascade;
drop role MGMT_USER;
b.刪除同義詞:
select 'drop '|| decode(owner,'PUBLIC',owner||' synonym '||synonym_name, ' synonym '||owner||'.'||synonym_name) ||';' from dba_synonyms where table_owner in ('SYSMAN', 'SYSMAN_MDS', 'MGMT_VIEW', 'SYSMAN_BIPLATFORM', 'SYSMAN_APM', 'SYSMAN_OPSS', 'SYSMAN_RO') ;
刪除之后用如下語(yǔ)句查詢一下:
SQL> select owner,synonym_name from dba_synonyms where table_owner in ('SYSMAN', 'SYSMAN_MDS','MGMT_VIEW','SYSMAN_BIP','SYSMAN_APM','SYSMAN_OPSS','SYSMAN_RO') ;
c.刪除表空間;
select 'drop tablespace '||tablespace_name||' including contents and datafiles;' from dba_tablespaces where tablespace_name like 'MGMT%';
d.刪除對(duì)象:
delete from SCHEMA_VERSION_REGISTRY where COMP_NAME='Metadata Services';
delete from SCHEMA_VERSION_REGISTRY where COMP_NAME='Authorization Policy Manager';
delete from SCHEMA_VERSION_REGISTRY where COMP_NAME='Oracle Platform Security Services';
commit;
確保能夠從EM 主機(jī)順利登錄到 repository 數(shù)據(jù)庫(kù) :
[oracle@xxx]$ tnsping standby
[oracle@xxx]$ sqlplus sys/system@standby as sysdba
3.安裝cloud control
解壓縮安裝軟件,執(zhí)行./runInstaller
創(chuàng)建Middleware和agent安裝目錄敏簿,在oracle用戶下創(chuàng)建
mkdir /u01/app/agent
mkdir /u01/app/Middleware
點(diǎn)擊next
輸入第二步安裝的數(shù)據(jù)庫(kù)對(duì)應(yīng)信息明也,可以選擇SMALL、MEDIUM惯裕、LARGE對(duì)應(yīng)小温数、中、大型蜻势。
如果數(shù)據(jù)庫(kù)之前配置了dbcontrol撑刺,使用如下命令將其刪除:
emca -deconfig dbcontrol db -repos drop -SYS_PWD -SYSMAN_PWD
忽略該錯(cuò)誤
Sysman用戶登陸
點(diǎn)擊我將在以后處理
點(diǎn)擊我接受
4.配置監(jiān)控oracle
4.1首先添加主機(jī)
設(shè)置->添加目標(biāo)->手動(dòng)添加目標(biāo)->添加主機(jī)
192.168.56.201機(jī)器上創(chuàng)建目錄/u01/app/oracle/agent12c
點(diǎn)擊命名的身份證明右邊的?號(hào),并行執(zhí)行如下命令賦予oracle sudo權(quán)限握玛。
vim /etc/sudoers
root ALL=(ALL) ALL
oracle ALL=(root) NOPASSWORD:ALL
點(diǎn)擊部署代理
點(diǎn)擊繼續(xù)所有主機(jī)
2.添加數(shù)據(jù)庫(kù)
設(shè)置->添加目標(biāo)->手動(dòng)添加目標(biāo)
點(diǎn)擊下一步
點(diǎn)擊保存
效果如下: