概述
一、准备工作
3.解压安装介质
2.从spfile创建pfile(oracle用户)
3.然后编辑pfile，修改MEMORY_TARGET的值
4.重新创建spfile
5.启动数据库
8.重启数据库
=================================================================================
注意EM 要求 repository database没有配置DB control ，如果有的话需要通过下列命令drop 掉:
export ORACLE_HOME= /u01/app/oracle/product/11.2.0
2.Prerequisite Checks会检测EM安装的前提条件，这里全部成功
3.下一步选择create a new Enterprise Manager -> Advanced
5.选择想要安装的插件，这里我们不安装额外的插件，保持默认配置点击Next:
6.配置Weblogic Server，填入Weblogic和Node Manager密码及OMS instance Base Location:
7.配置数据库连接信息，填入repository database的连接信息:
8.输入 sysman用户和Agent注册使用的密码， 安装程序会自动为你提供EM所需创建表空间数据文件的位置：
9.选择EM 12c将要使用的端口，一般默认即可，除非这些端口有其他用途:
10.点击 Next后 再点击Install Now进入安装过程:
12.进行到如下步骤的时候，消耗的时间会比较长，我的虚拟机上这一步跑了最少2个小时(个人机器，视情况而定)
解决办法：
如果不记得密码，可以在终端上登陆测试一下安装时设定的密码
14.首次登陆，会提示要接受的许可协议
#!/bin/bash
点搜索列表
先点添加提示数据库
1.先配置好/etc/hosts文件中域名解析
[root
@ora12cc ~]$ cat /etc/hosts
# Do not remove the following line, or various programs
# that require network functionality will fail.
127.0.0.1 localhost.localdomain localhost
::1 localhost6.localdomain6 localhost6
192.168.100.166 ora12cc
[root
@ora12cc ~]$
在安装EM 12c之前，我们需要做一些准备工作
1.下载安装介质，下载地址如下：
http://www.oracle.com/technetwork/oem/grid-control/downloads/linuxx8664soft-085949.html
2.创建安装em的账户,并修改环境变量，此账户也需要用来安装12c的 Repository 数据库,这里我们及创建oracle用户来安装吧
[oracle
@ora12cc ~]$ cat .bash_profile
#Oracle Settings oem
TMP=/tmp; export TMP
TMPDIR=$TMP; export TMPDIR
ORACLE_BASE=/u01/app/oracle; export ORACLE_BASE
ORACLE_HOME=$ORACLE_BASE/product/11.2.0; export ORACLE_HOME
ORACLE_SID=ora12cc; export ORACLE_SID
ORACLE_TERM=xterm; export ORACLE_TERM
export OMS_HOME=/m01/middle/oracle/oms12cr5/oms
export AGENT_HOME=/m01/agent/oracle/agent12cr5/core/12.1.0.5.0
PATH=/usr/sbin:$PATH; export PATH
PATH=$ORACLE_HOME/bin:$PATH; export PATH
LD_LIBRARY_PATH=$ORACLE_HOME/lib:/lib:/usr/lib; export LD_LIBRARY_PATH
CLASSPATH=$ORACLE_HOME/JRE:$ORACLE_HOME/jlib:$ORACLE_HOME/rdbms/jlib; export CLASSPATH
NLS_DATE_FORMAT="yyyy-mm-dd HH24:MI:SS"; export NLS_DATE_FORMAT
NLS_LANG=AMERICAN_AMERICA.ZHS16GBK;export NLS_LANG
if [ $USER = "oracle" ] || [ $USER = "grid" ]; then
if [ $SHELL = "/bin/ksh" ]; then
ulimit -p 16384
ulimit -n 65536
else
ulimit -u 16384 -n 65536
fi
umask 022
fi
创建存放解压后安装介质的目录，并上传压缩包、解压上述zip包：
su - oracle
[oracle
@ora12cc ~]$ mkdir em_tools
[oracle
@ora12cc em_tools]$ ls -rlt
total 7184520
-rw-r--r-- 1 oem oinstall 2392965180 Dec 13 02:38 em12105 linux64 Disk 1of3.zip
-rw-r--r-- 1 oem oinstall 1880746349 Dec 13 02:39 em12105 linux64 Disk 2of3.zip
-rw-r--r-- 1 oem oinstall 3076033575 Dec 13 02:41 em12105 linux64 Disk 3of3.zip
[oracle
@ora12cc em_tools]$
[oracle
@ora12cc em_tools]$ unzip em12105 linux64 Disk 1of3.zip
[oracle
@ora12cc em_tools]$ unzip em12105 linux64 Disk 2of3.zip
[oracle
@ora12cc em_tools]$ unzip em12105 linux64 Disk 3of3.zip
4. 在EM主机上安装必要的rpm 软件包以及调整/etc/sysctl.conf中的内核参数
[root@ora12cc ~]# rpm -q binutils
compat-libstdc++-33
binutils
elfutils-libelf
elfutils-libelf-devel
gcc
gcc-c++
glibc
glibc-commonglibc-devel
glibc-headers
glibc-common
ksh
libaio
libaio-devel
libgomp
libgcc
libstdc++
libstdc++-devel
make
numactl-devel
sysstat
unixODBC
unixODBC-devel
compat-libcap
rng-utils
setarch
zlib
zlib-devel
jzlib
[
root@ora12cc ~]# cat /etc/sysctl.conf
#oracle
kernel.msgmnb = 65536
kernel.msgmax = 65536
fs.file-max = 6815744
kernel.sem = 250 32000 100 128
kernel.shmmni = 4096
kernel.shmall = 1073741824
kernel.shmmax = 4398046511104
net.core.rmem_default = 262144
net.core.rmem_max = 4194304
net.core.wmem_default = 262144
net.core.wmem_max = 1048576
fs.aio-max-nr = 1048576
net.ipv4.ip_local_port_range = 9000 65500
4. 为 EM拥有者用户配置必要的ulimit 参数 , 需要修改/etc/security/limits.conf配置文件，如:
[
root@ora12cc ~]# cat /etc/security/limits.conf
#oracle
grid soft nproc 2047
grid hard nproc 16384
grid soft nofile 1024
grid hard nofile 65536
oracle soft nproc 2047
oracle hard nproc 16384
oracle soft nofile 4096
oracle hard nofile 65536
[
root@ora12cc ~]# cat /etc/pam.d/login
#oracle
session required pam_limits.so
5. 为EM 12c配置合适的repository database以存放数据
这里可以在Metalink上的Certification Matrix中找到EM 12c已认证的数据库版本,如下图所示，11.2.0.4已经通过认证
这里推荐新建一个11.2.0.4 版本的数据库作为EM Repository。(创建数据库步骤，详见其他文档)
此外作为EM Repository的数据库还必须使用EM所要求的初始化参数，这些要求包括:
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
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= 500 scope=spfile;
alter system set session_cached_cursors=500 scope=spfile;
alter system set processes= 500 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=22 scope=spfile;
alter database add logfile size 320M;
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;
alter system set job_queue_processes=22 scope=spfile;
alter database add logfile size 320M;
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;
===============================================================================
扩展：
如果修改完以上参数以后，我们启动数据库报错如下：
解决办法：
1.查看srvctl读取spfile位置(grid用户)
2.从spfile创建pfile(oracle用户)
3.然后编辑pfile，修改MEMORY_TARGET的值
4.重新创建spfile
5.启动数据库
这个错误说明共享内存小于memory_target的值，我们需要修改共享内存的值比memory_target的值稍大些
6.修改共享内存
7.重新加载共享内存
mount -o remount /dev/shm
8.重启数据库
=================================================================================
注意EM 要求 repository database没有配置DB control ，如果有的话需要通过下列命令drop 掉:
export ORACLE_HOME= /u01/app/oracle/product/11.2.0
export ORACLE_SID= oggrac1$ORACLE_HOME/bin/emca -deconfig dbcontrol db -repos drop
6.同时要求sysman 和 sysman_mds、 sysman_opss用户不存在，已创建该用户的DB 可以drop 掉:
[oracle@oggrac2 ~]$ sqlplus / as sysdba
a.删除资料库用户：
drop user SYSMAN cascade;
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;
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') ;
删除之后用如下语句查询一下：
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;
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;
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') ;
删除之后用如下语句查询一下：
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;
7.确保能够从EM 主机顺利登录到 repository 数据库 :
[
oracle@ora12cc ~]$ tnsping ora12cc:1521/ora12cc
[
oracle@ora12cc ~]$ sqlplus sys/
oracle@ora12cc:1521/ora12cc as sysdba
8. 确保网络正常
这里要求EM主机必须使用statics IP 静态IP ，否则安装会出错， 且已正确在/etc/hosts或DNS配置唯一的域名解析
9.提前设定好磁盘组的空间大小，不然到时候还要给磁盘组加磁盘，我的OMS涉及到的表空间都放到DATA磁盘组中，空间仅供参考
二、正式安装
我们开始正式通过OUI安装Oracle Enterprise Manager Cloud Control 12c(12.1)，这里要用到图形化的界面
unset ORACLE_HOME ORACLE_BASE ORACLE_SID
./runInstaller
1.如下图OUI界面顺利启动，去掉” I wish to receive security update…”，并点击Next:
./runInstaller
1.如下图OUI界面顺利启动，去掉” I wish to receive security update…”，并点击Next:
2.Prerequisite Checks会检测EM安装的前提条件，这里全部成功
3.下一步选择create a new Enterprise Manager -> Advanced
4.为Middleware Home location选定一可用的空目录，注意目录的拥有者应为oracle(EM 所有者用户)
[
root@ora12cc ~]# mkdir -p /m01/middleware
[
root@ora12cc /]# chown -R oracle:oinstall /m01
[
oracle@ora12cc m01]$ mkdir agent
5.选择想要安装的插件，这里我们不安装额外的插件，保持默认配置点击Next:
6.配置Weblogic Server，填入Weblogic和Node Manager密码及OMS instance Base Location:
7.配置数据库连接信息，填入repository database的连接信息:
8.输入 sysman用户和Agent注册使用的密码， 安装程序会自动为你提供EM所需创建表空间数据文件的位置：
9.选择EM 12c将要使用的端口，一般默认即可，除非这些端口有其他用途:
10.点击 Next后 再点击Install Now进入安装过程:
安装流程包括Copy Files、Configure、Run root scripts，总耗时在4个小时左右
11.安装过程我们可以点击viewlog来监控安装进度，安装过程是否报错
12.进行到如下步骤的时候，消耗的时间会比较长，我的虚拟机上这一步跑了最少2个小时(个人机器，视情况而定)
解决办法：
13.打开浏览器，输入地址https://hostname:7799/em(7799默认端口)访问EM Cloud Control 12c，输入sysman的身份认证
如果要是在windows下想要访问虚拟机中的IP地址，需要在windows机器的hosts文件中加上域名解析
进入到 C:WindowsSystem32driversetc
编辑hosts文件，添加如下行
如果不记得密码，可以在终端上登陆测试一下安装时设定的密码
14.首次登陆，会提示要接受的许可协议
使用如下命令停止OMS和Agent 服务:
可以写一个小脚本，如下：
#!/bin/bashexport OMS_HOME=/m01/middle/oracle/oms12cr5/oms
export AGENT_HOME=/m01/agent/oracle/agent12cr5/core/12.1.0.5.0
$OMS_HOME/bin/emctl stop oms -all$AGENT_HOME/bin/emctl stop agent使用如下命令启动OMS和Agent 服务:
export OMS_HOME=/m01/middle/oracle/oms12cr5/omsexport AGENT_HOME=/m01/agent/oracle/agent12cr5/core/12.1.0.5.0$OMS_HOME/bin/emctl start oms
$AGENT_HOME/bin/emctl start agent
15.下面我看是添加repository database
点搜索列表
先点添加提示数据库
[
oracle@ora12cc ~]$ cd $OMS_HOME/oms
[
oracle@ora12cc oms]$ pwd
/m01/middle/oracle/oms12cr5/oms/oms/bin
[
oracle@ora12cc bin]$ ./emctl status oms
Oracle Enterprise Manager Cloud Control 12c Release 5
Copyright (c) 1996, 2015 Oracle Corporation. All rights reserved.
WebTier is Up
Oracle Management Server is Up
[
oracle@ora12cc bin]$
[
oracle@ora12cc bin]$ ./emctl status oms -details
Oracle Enterprise Manager Cloud Control 12c Release 5
Copyright (c) 1996, 2015 Oracle Corporation. All rights reserved.
Enter Enterprise Manager Root (SYSMAN) Password :
Unable to connect to repository database
OMS ports, URLs and security info will not be printed
WLS Domain Information
Domain Name : GCDomain
Admin Server Host : ora12cc
Admin Server HTTPS Port: 7101
Admin Server is RUNNING
Oracle Management Server Information
Managed Server Instance Name: EMGC_OMS1
Oracle Management Server Instance Host: ora12cc
WebTier is Up
Oracle Management Server is Up
BI Publisher is not configured to run on this host.
[
oracle@ora12cc bin]$
[
oracle@ora12cc bin]$ cd $AGENT_HOME
[
oracle@ora12cc 12.1.0.5.0]$ ls
agentimage.properties agent_inst core plugins sbin
[
oracle@ora12cc 12.1.0.5.0]$ cd agent_inst/bin/
[
oracle@ora12cc bin]$ pwd
/m01/agent/oracle/agent12cr5/core/12.1.0.5.0/agent_inst/bin
[
oracle@ora12cc bin]$
[
oracle@ora12cc bin]$ ./emctl status agent
Oracle Enterprise Manager Cloud Control 12c Release 5
来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/27777188/viewspace-1875385/，如需转载，请注明出处，否则将追究法律责任。
转载于:http://blog.itpub.net/27777188/viewspace-1875385/
最后
以上就是忐忑帆布鞋为你收集整理的Oracle12c Cloud Control安装部署的全部内容，希望文章能够帮你解决Oracle12c Cloud Control安装部署所遇到的程序开发问题。
如果觉得靠谱客网站的内容还不错，欢迎将靠谱客网站推荐给程序员好友。
本图文内容来源于网友提供，作为学习参考使用，或来自网络收集整理，版权属于原作者所有。
发表评论 取消回复