Welcome 微信登录

首页 / 数据库 / MySQL / Oracle Enterprise Manager Cloud Control 12c R4 安装配置

准备软件

em12.1.0.4_linux64_V45344-01.zipem12.1.0.4_linux64_V45345-01.zipem12.1.0.4_linux64_V45346-01.zip 

安装操作系统(OEL6.5)

给 OS 空间 50G 以上装完OS和CC后需要占用 30G 空间建议6G 内存最少4G  [Oracle@ newcc bin]$ cat /etc/hosts127.0.0.1  localhostlocalhost.localdomain localhost4 localhost4.localdomain4::1localhostlocalhost.localdomainlocalhost6 localhost6.localdomain6 10.1.32.229 OEL65 

安装ccdb数据库

按照gcdb 11g的环境即可[oracle@ newcc ~]$ uname -r3.8.13-16.2.1.el6uek.x86_64 [root@OEL65 ~]# rpm -q --qf"%{NAME}-%{VERSION}-%{RELEASE} (%{ARCH}) " inutils compat-libstdc++-33elfutils-libelf elfutils-libelf-devel gcc gcc-c++ glibc glibc-commonglibc-devel glibc-headers ksh libaio libaio-devel libgomp- libgcc libstdc++libstdc++-devel make numactl-devel- sysstat unixODBC unixODBC-devel compat-libcap1binutils-2.20.51.0.2-5.36.el6 (x86_64)compat-libstdc++-33-3.2.3-69.el6 (x86_64)compat-libstdc++-33-3.2.3-69.el6 (i686)elfutils-libelf-0.152-1.el6 (x86_64)elfutils-libelf-0.152-1.el6 (i686)elfutils-libelf-devel-0.152-1.el6 (x86_64)elfutils-libelf-devel-0.152-1.el6 (i686)gcc-4.4.7-4.el6 (x86_64)gcc-c++-4.4.7-4.el6 (x86_64)glibc-2.12-1.132.el6 (x86_64)glibc-2.12-1.132.el6 (i686)glibc-common-2.12-1.132.el6 (x86_64)glibc-devel-2.12-1.132.el6 (x86_64)glibc-devel-2.12-1.132.el6 (i686)glibc-headers-2.12-1.132.el6 (x86_64)ksh-20120801-10.el6 (x86_64)libaio-0.3.107-10.el6 (x86_64)libaio-0.3.107-10.el6 (i686)libaio-devel-0.3.107-10.el6 (x86_64)libaio-devel-0.3.107-10.el6 (i686)libgomp-4.4.7-4.el6 (x86_64)libgcc-4.4.7-4.el6 (x86_64)libgcc-4.4.7-4.el6 (i686)libstdc++-4.4.7-4.el6 (x86_64)libstdc++-4.4.7-4.el6 (i686)libstdc++-devel-4.4.7-4.el6 (x86_64)libstdc++-devel-4.4.7-4.el6 (i686)make-3.81-20.el6 (x86_64)numactl-devel-2.0.7-8.el6 (x86_64)sysstat-9.0.4-22.el6 (x86_64)unixODBC-2.2.14-12.el6_3 (x86_64)unixODBC-2.2.14-12.el6_3 (i686)unixODBC-devel-2.2.14-12.el6_3 (i686)unixODBC-devel-2.2.14-12.el6_3 (x86_64)compat-libcap1-1.10-1 (x86_64)[root@OEL65 ~]# #默认值/etc/sysctl.conf[root@newcc soft]#sysctl -pkernel.msgmnb = 65536kernel.msgmax = 65536fs.file-max = 6815744kernel.sem = 250 32000 100 128kernel.shmmni = 4096kernel.shmall = 1073741824kernel.shmmax = 4398046511104net.core.rmem_default = 262144net.core.rmem_max = 4194304net.core.wmem_default = 262144net.core.wmem_max = 1048576fs.aio-max-nr = 1048576net.ipv4.ip_local_port_range = 9000 65500 #默认值vi /etc/security/limits.conf oracle          soft    nproc  2047oracle          hard    nproc  16384oracle          soft    nofile 1024oracle          hard    nofile 65536  vi /etc/pam.d/loginsession    required    pam_limits.so #关闭SELINUXvi /etc/selinux/configSELINUX=disabled #关闭防火墙[root@newcc~]# service iptables stopiptables:将链设置为政策 ACCEPT:filter                    [确定]iptables:清除防火墙规则:                                [确定]iptables:正在卸载模块:                                  [确定][root@newcc~]# chkconfig iptables off  #创建组和用户groupadd oinstall默认已经有groupadd dba默认已经有groupadd opergroupadd asmadminuserdel oracle cd /home rm -rf oracleuseradd -g oinstall -G dba,oper,asmadmin oraclepasswd oracle #创建目录mkdir -p /u01/app/ora11gmkdir -p /u01/app/ora11g/productmkdir -p /u01/app/ora11g/oradatamkdir -p /u01/app/ora11g/product/11.2.0/db_1chown -R oracle:oinstall /u01chmod -R 775 /u01 #创建环境变量su – oraclevi .bash_profile export TMP=/tmpexport TMPDIR=$TMPexport ORACLE_TERM=xtermexport ORACLE_BASE=/u01/app/ora11gexport ORACLE_HOME=$ORACLE_BASE/product/11.2.0/db_1export ORACLE_GRID=$ORACLE_BASE/product/11.2.0/gridexport ORACLE_SID=ccdbexport PATH=/usr/sbin:$PATHexport PATH=$ORACLE_HOME/bin:$ORACLE_GRID/bin:$PATHexport LD_LIBRARY_PATH=$ORACLE_HOME/lib:/lib64:/usr/lib64:/usr/local/lib64:/usr/X11R6/lib64export CLASSPATH=$ORACLE_HOME/JRE:$ORACLE_HOME/jlib:$ORACLE_HOME/rdbms/jlibexport NLS_LANG="SIMPLIFIEDCHINESE_CHINA.ZHS16GBK"exportALERT=$ORACLE_BASE/diag/rdbms/$ORACLE_SID/$ORACLE_SID/tracestty erase ^Humask 022if [ $USER = "oracle" ]; then if [$SHELL = "/bin/ksh" ]; then      ulimit -p 16384      ulimit -n 65536   else      ulimit -u 16384 -n 65536           fi          fi #格式化分区fdisk -l   [root@newcc ~]#fdisk /dev/sdbn p 1 w #创建ASM disk--检查asm包安装[root@newcc ~]# rpm -qa oracleasm*oracleasm-support-2.1.8-1.el6.x86_64 rpm –vih asmlib [root@newcc ~]# /etc/init.d/oracleasmconfigureConfiguring the Oracle ASM library driver. This will configure the on-boot propertiesof the Oracle ASM librarydriver. The following questions will determine whether the driver isloaded on boot and what permissions it willhave.  The current valueswill be shown in brackets ("[]").  Hitting <ENTER> without typing ananswer will keep that current value.  Ctrl-C will abort. Default user to own the driver interface[]: oracleDefault group to own the driver interface[]: asmadminStart Oracle ASM library driver on boot(y/n) [n]: yScan for Oracle ASM disks on boot (y/n)[y]: yWriting Oracle ASM library driverconfiguration: doneInitializing the Oracle ASMLib driver:                    [  OK  ]Scanning the system for Oracle ASMLibdisks:              [  OK  ][root@newcc ~]# /etc/init.d/oracleasmcreatedisk v1 /dev/sdb1Marking disk "v1" as an ASMdisk:                          [  OK  ][root@newcc ~]# /etc/init.d/oracleasmcreatedisk v2 /dev/sdc1Marking disk "v2" as an ASMdisk:                          [  OK  ][root@newcc ~]# /etc/init.d/oracleasmlistdisksV1V2 #配置host文件[root@newcc~]# vi /etc/hosts#cc10.1.5.122      newcc.localdomain      newcc #Public10.1.32.91      ntrac1.localdomain      ntrac110.1.32.93      ntrac2.localdomain      ntrac210.1.32.95      ntrac3.localdomain      ntrac3 #Virtual10.1.32.92      ntrac1-vip.localdomain  ntrac1-vip10.1.32.94      ntrac2-vip.localdomain  ntrac2-vip10.1.32.96      ntrac3-vip.localdomain  ntrac3-vip #SCAN10.1.32.99   rac-scan.localdomain  rac-scan #Database和Grid安装    #创建ccdb数据库       

配置ccdb

redo log 修改大小100M 然后创建 4组 redo log **  根据提示修改就OKALTER SYSTEM SETprocesses=500 SCOPE=SPFILE;系统已更改。ALTER SYSTEM SETsession_cached_cursors=500 SCOPE=SPFILE;系统已更改ALTER SYSTEM SETsga_target=2G SCOPE=SPFILE; 默认要比这个大就不动ALTER SYSTEM SETpga_aggregate_target=2G SCOPE=SPFILE;ALTER SYSTEM SETjob_queue_processes=20SCOPE=SPFILE; 默认1000 要缩小ALTER SYSTEM SETopen_cursors=300 SCOPE=SPFILE; **  --Restart the instance.SHUTDOWNIMMEDIATESTARTUP   

安装Cloud Control

官方文档参考:http://docs.oracle.com/cd/E24628_01/install.121/e22624/install_em_exist_db.htm#BGBHDBCH 

创建CC安装目录

oracleuser$ mkdir-p /u01/app/oracle/oms12cr4$mkdir -p /u01/app/oracle/agent12cr4 

添加环境变量

 export LANG=zh_CNexport TMP=/tmpexport TMPDIR=$TMPexport ORACLE_TERM=xtermexportORACLE_BASE=/u01/app/ora11gexportORACLE_HOME=$ORACLE_BASE/product/11.2.0/db_1exportORACLE_GRID=$ORACLE_BASE/product/11.2.0/gridexport OMS_HOME=/u01/app/oracle/oms12cr4/omsexport AGENT_HOME=/u01/app/oracle/agent12cr4/core/12.1.0.4.0export ORACLE_SID=ccdbexport PATH=/usr/sbin:$PATHexportPATH=$ORACLE_HOME/bin:$ORACLE_GRID/bin:$PATHexportLD_LIBRARY_PATH=$ORACLE_HOME/lib:/lib64:/usr/lib64:/usr/local/lib64:/usr/X11R6/lib64exportCLASSPATH=$ORACLE_HOME/JRE:$ORACLE_HOME/jlib:$ORACLE_HOME/rdbms/jlibexport NLS_LANG="SIMPLIFIEDCHINESE_CHINA.ZHS16GBK"export ALERT=$ORACLE_BASE/diag/rdbms/$ORACLE_SID/$ORACLE_SID/tracestty erase ^Humask 022if [ $USER = "oracle"]; then if [ $SHELL = "/bin/ksh" ]; then      ulimit -p 16384      ulimit -n 65536    else      ulimit -u 16384 -n 65536            fi          fi 

启动安装CC

 --临时注释掉下面几个环境变量unset ORACLE_HOME ORACLE_BASE ORACLE_SID [oracle@newcccc]$ lsinstall  jdk libskgxn  oms  plugins Release_Notes.pdf  response  runInstaller stage  wls  WT.zip[oracle@newcccc]$ ./runInstaller     因为主机名没有加domain   如果选着高级是这样       可以选择小中大型部署   删除em之前的dbconsole是stop的[root@OEL65 112db]# su - oracle[oracle@OEL65 ~]$ export LANG=zh_EN[oracle@OEL65 ~]$ emca -deconfig dbcontrol db-repos drop EMCA 开始于 2013-12-9 21:06:52EM Configuration Assistant, 11.2.0.3.0 正式版版权所有 (c) 2003, 2011, Oracle。保留所有权利。 输入以下信息:数据库 SID: ngcdb监听程序端口号: 1521SYS 用户的口令: SYSMAN 用户的口令:  ----------------------------------------------------------------------警告: 当删除资料档案库时, 数据库将进入静默模式。----------------------------------------------------------------------是否继续? [是(Y)/否(N)]: y2013-12-9 21:07:54oracle.sysman.emcp.EMConfig perform信息: 正在将此操作记录到/u01/app/ora11g/cfgtoollogs/emca/ngcdb/emca_2013_12_09_21_06_51.log。2013-12-9 21:07:55oracle.sysman.emcp.util.DBControlUtilstopOMS信息: 正在停止 Database Control (此操作可能需要一段时间)...2013-12-9 21:07:57oracle.sysman.emcp.EMReposConfig invoke信息: 正在删除 EM 资料档案库 (此操作可能需要一段时间)...2013-12-9 21:09:22oracle.sysman.emcp.EMReposConfig invoke信息: 已成功删除资料档案库已成功完成 Enterprise Manager 的配置EMCA 结束于 2013-12-9 21:09:25[oracle@OEL65 ~]$更多详情见请继续阅读下一页的精彩内容: http://www.linuxidc.com/Linux/2016-04/130005p2.htm
  • 1
  • 2
  • 下一页
在OEL6.4上安装Oracle Database 12c[初体验]Oracle 12c中如何自动启动PDB Pluggable Database相关资讯      Oracle 12c 
  • RedHat Enterprise Linux7.0安装  (今 12:59)
  • Oracle 12C 新特性-扩展数据类型  (07月16日)
  • 在OEL6.4上安装Oracle Database   (04月10日)
  • Oracle 12C 新特性-表分区或子分区  (07月16日)
  • Oracle 12c中如何自动启动PDB   (04月10日)
  • Oracle Enterprise Linux 6.4安装  (04月10日)
本文评论 查看全部评论 (0)
表情: 姓名: 字数

<