Oracle Cloud Control 12.1.0.5部署
一、准备工作
1、配置好/etc/hosts文件中域名解析
cat /etc/hosts
2、下载安装介质,下载地址如下:
http://www.oracle.com/technetwork/oem/grid-control/downloads/linuxx8664soft-085949.html
3、调整系统内核参数
oracle软件的环境调整
4、oracle软件以及实例部署
创建oracle用户以及dbca创建一个实例作为CC的资料库。
注意下创建的实例redo日志组至少在300m,4组以上。
5、调整实例参数
dbca创建的实例(cc),调整参数
Check the CBO stats gathering job Disable the stats gathering job
1.Check the processes instance parameter value The processes instance parameter needs to be set to at least 300.
2.Check the session_cached_cursors instance parameter value. The session_cached_cursors instance parameter should be set to 300. Any value between 200 and 500, inclusive, will be accepted.
3.Check the job_queue_processes instance parameter value. The job_queue_processes instance parameter should be set to 20.
4.Check the shared_pool_size instance parameter value. The shared_pool_size instance parameter should be set to at least 600 megabytes or roughly one third of the sga_target size.
5. Check the redo log size. The size of the EM database instance should be 300 megabytes or greater. Generally, there should be 3 or more redo logs available of this size.
6. Ensure that the EM tablespace has at least one datafile set to autoextensible Add at least one datafile with the autoextend attribute to the EM tablespace
7.Check the open_cursors instance parameter value. The open_cursors instance parameter should be set between 300 and 400, inclusive.
8.Check the sga_target instance parameter value. The sga_target instance parameter should be set to at least 2 gigabytes, and roughly twice the size of the pga_aggregate_target setting.
9.Check for invalid objects in the EM repository Compile all invalid objects in the EM repository
alter system set processes= 1000 scope=spfile;
alter system set session_cached_cursors=500 scope=spfile;
alter system set shared_pool_size=650M scope=spfile;
alter system set job_queue_processes=20 scope=spfile;
alter system set open_cursors=350 scope=spfile;
alter system set sga_target=2g scope=spfile;
ALTER SYSTEM SET pga_aggregate_target=1G SCOPE=SPFILE;
6、检查CC数据库是否配置DB control
如果有的话需要通过下列命令drop 掉:
$ORACLE_HOME/bin/emca -deconfig dbcontrol db -repos drop
7、检查系统用户是否存在
sysman 和 sysman_mds、sysman_opss用户不存在,如果存在可以drop掉
8、删除资料库用户
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;
drop user CLOUD_SWLIB_USER cascade;
drop user CLOUD_ENGINE_USER cascade;
drop role MGMT_USER;
删除同义词:
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') ;
删除之后用如下语句查询一下:
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.删除对象:
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;
二、正式安装
1、解压CC的安装介质,以及创建目录
[root@ora12cc ~]# mkdir -p /m01/middleware
[root@ora12cc ~]# mkdir -p /m01/agent
[root@ora12cc /]# chown -R oracle:oinstall /m01
2、图形化安装
./runInstaller
3、安装步骤
3.1
3.2
3.3
如果有此警告信息,可yum安装包
yum install -y glibc.i686 glibc-devel.i686 glibc-static.i686
3.4
3.5
3.6保持默认
3.7此处密码为oracle123
3.8配置数据库连接信息,填入repository database的连接信息:
3.9配置sysman密码
此处为oracle123
3.10保持默认
3.11点击 Next后 再点击Install Now进入安装过程
3.12部署完毕
Use the following URL to access:
1. Enterprise Manager Cloud Control URL: https://orcldb4:7802/em
2. Admin Server URL: https://orcldb4:7102/console
The following details need to be provided during the additional OMS install:
1. Admin Server Hostname: orcldb4
2. Admin Server Port: 7102
三、访问cloud control
https://192.168.212.233:7802/em/
sysman oracle123
四、添加主机
4.1 本地主机
选择实例
解锁dbsnmp用户以及重置密码
alter user dbsnmp account unlock;
alter user dbsnmp identified by oracle;
4.2 添加agent主机
修改agent端(被监控端)主机配置文件
确保/usr/local/bin/sudo这个符号链接存在
[root@orc2 ~]# ln -s /usr/bin/sudo /usr/local/bin/sudo
[root@orc2 ~]# ls -l /etc/sudoers
-r--r----- 1 root root 3381 Nov 12 2010 /etc/sudoers
[root@orc2 ~]# cp /etc/sudoers /etc/sudoers.bak
vi /etc/sudoers 将以下三处修改
修改前:
Defaults requiretty #如果没有就手动添加
修改后:
Defaults:oracle !requiretty
修改前:
Defaults !visiblepw
修改后:
Defaults visiblepw
修改前:
##
## Allow root to run any commands anywhere
root ALL=(ALL) ALL
修改后
##
## Allow root to run any commands anywhere
root ALL=(ALL) ALL
oracle ALL=(ALL) ALL --这里加一行
以上三处修改完成后,save 文件
测试oracle 能否正常sudo
[root@orc2 ~]# su – oracle
[oracle@orc2 ~]$ sudo ls -l /root/
cc端配置agent
点击部署代理
部署完毕之后,就可以在主机搜索中发现了
五、添加数据库
六、开启以及停止CC
#!/bin/bash
export OMS_HOME=/m01/middleware/oms/bin
export AGENT_HOME=/m01/agent/core/12.1.0.5.0/bin
使用如下命令关闭OMS和Agent 服务:
$OMS/emctl stop oms -all
$AGENT/emctl stop agent
使用如下命令启动OMS和Agent 服务:
$OMS/emctl start oms
$AGENT/emctl start agent