Preparing the Software
Em12.1.0.4_linux64_v45344-01.zip
Em12.1.0.4_linux64_v45345-01.zip
Em12.1.0.4_linux64_v45346-01.zip
Installing the Operating system (OEL6.5)
30G space required to load OS and CC over 50G OS space recommended 6G memory min 4G
[Email protected] NEWCC bin]$ cat/etc/hosts
127.0.0.1 Localhostlocalhost.localdomain Localhost4 Localhost4.localdomain4
:: 1localhostlocalhost.localdomainlocalhost6 localhost6.localdomain6
10.1.32.229 OEL65
Installing the CCDB Database
According to GCDB 11g environment can be
[Email protected] NEWCC ~]$ uname-r
3.8.13-16.2.1.el6uek.x86_64
[[email protected] ~]# rpm-q--qf '%{name}-%{version}-%{release} (%{arch}) \ n ' \binutils 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-libcap1
Binutils-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)
[Email protected] ~]#
#默认值
/etc/sysctl.conf
[[email protected] soft] #sysctl-P
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
#默认值
Vi/etc/security/limits.conf
Oracle Soft Nproc 2047
Oracle Hard Nproc 16384
Oracle Soft Nofile 1024
Oracle Hard Nofile 65536
Vi/etc/pam.d/login
Session Required Pam_limits.so
#关闭SELINUX
Vi/etc/selinux/config
Selinux=disabled
#关闭防火墙
[[Email protected]~]# service iptables stop
Iptables: Set the chain to policy accept:filter [OK]
Iptables: Clear Firewall rule: [OK]
Iptables: Uninstalling module: [OK]
[[Email protected]~]# chkconfig iptables off
#创建组和用户
Groupadd Oinstall Default already has
Groupadd DBA by default already has
Groupadd Oper
Groupadd Asmadmin
Userdel Oracle
Cd/home RM-RF Oracle
USERADD-G oinstall-g Dba,oper,asmadmin Oracle
passwd Oracle
#创建目录
Mkdir-p/u01/app/ora11g
Mkdir-p/u01/app/ora11g/product
Mkdir-p/u01/app/ora11g/oradata
Mkdir-p/u01/app/ora11g/product/11.2.0/db_1
Chown-r oracle:oinstall/u01
Chmod-r 775/u01
#创建环境变量
Su–oracle
VI. bash_profile
Export Tmp=/tmp
Export tmpdir= $TMP
Export Oracle_term=xterm
Export oracle_base=/u01/app/ora11g
Export Oracle_home= $ORACLE _base/product/11.2.0/db_1
Export oracle_grid= $ORACLE _base/product/11.2.0/grid
Export ORACLE_SID=CCDB
Export Path=/usr/sbin: $PATH
Export path= $ORACLE _home/bin: $ORACLE _grid/bin: $PATH
Export Ld_library_path= $ORACLE _home/lib:/lib64:/usr/lib64:/usr/local/lib64:/usr/x11r6/lib64
Export classpath= $ORACLE _home/jre: $ORACLE _home/jlib: $ORACLE _home/rdbms/jlib
Export nls_lang= "Simplifiedchinese_china. ZHS16GBK "
exportalert= $ORACLE _base/diag/rdbms/$ORACLE _sid/$ORACLE _sid/trace
Stty Erase ^h
Umask 022
if [$USER = "Oracle"]; Then
if [$SHELL = "/bin/ksh"]; Then
Ulimit-p 16384
Ulimit-n 65536
Else
Ulimit-u 16384-n 65536
Fi
Fi
#格式化分区
Fdisk-l
[Email protected] ~]#
Fdisk/dev/sdb
N P 1 W
#创建ASM disk
--Check ASM package Installation
[Email protected] ~]# Rpm-qa oracleasm*
Oracleasm-support-2.1.8-1.el6.x86_64
RPM–VIH Asmlib
[Email protected] ~]#/etc/init.d/oracleasmconfigure
Configuring the Oracle ASM Library driver.
This would configure the On-boot propertiesof the Oracle ASM Library
Driver. The following questions would determine whether the driver is
Loaded on boot and what permissions it willhave. The current values
Would be shown in brackets (' [] '). Hitting <ENTER> without typing an
Answer would keep that current value. Ctrl-c'll abort.
Default user to own the driver interface[]: Oracle
Default Group to own the driver interface[]: asmadmin
Start Oracle ASM Library driver on Boot (y/n) [n]: Y
Scan for Oracle ASM disks on Boot (y/n) [y]: Y
Writing Oracle ASM Library Driverconfiguration:done
Initializing the Oracle asmlib driver: [OK]
Scanning the system for Oracle asmlibdisks: [OK]
[Email protected] ~]#/etc/init.d/oracleasmcreatedisk V1/DEV/SDB1
Marking disk "V1" as an asmdisk: [OK]
[Email protected] ~]#/etc/init.d/oracleasmcreatedisk V2/DEV/SDC1
Marking Disk "V2" as an asmdisk: [OK]
[Email protected] ~]#/etc/init.d/oracleasmlistdisks
V1
V2
#配置host文件
[[Email protected]~]# vi/etc/hosts
#cc
10.1.5.122 Newcc.localdomain NEWCC
#Public
10.1.32.91 Ntrac1.localdomain Ntrac1
10.1.32.93 Ntrac2.localdomain NTRAC2
10.1.32.95 Ntrac3.localdomain NTRAC3
#Virtual
10.1.32.92 Ntrac1-vip.localdomain NTRAC1-VIP
10.1.32.94 Ntrac2-vip.localdomain NTRAC2-VIP
10.1.32.96 Ntrac3-vip.localdomain NTRAC3-VIP
#SCAN
10.1.32.99 Rac-scan.localdomain Rac-scan
#Database和Grid安装
#创建ccdb数据库
Configure CCDB
Redo Log Modify Size 100M then create 4 groups of redo log
* * Follow the prompts to modify the OK
ALTER SYSTEM setprocesses=500 Scope=spfile;
The system has changed.
ALTER SYSTEM setsession_cached_cursors=500 Scope=spfile;
System has changed
ALTER SYSTEM setsga_target=2g Scope=spfile; The default is bigger than this.
ALTER SYSTEM setpga_aggregate_target=2g Scope=spfile;
ALTER SYSTEM Setjob_queue_processes=20scope=spfile; Default 1000 to zoom Out
ALTER SYSTEM setopen_cursors=300 Scope=spfile;
**
--restart the instance.
Shutdownimmediate
STARTUP
Install Cloud Control
Official documentation Reference:
Http://docs.oracle.com/cd/E24628_01/install.121/e22624/install_em_exist_db.htm#BGBHDBCH
Create a CC installation directory
Oracleuser
$ mkdir-p/U01/APP/ORACLE/OMS12CR4
$mkdir-P/U01/APP/ORACLE/AGENT12CR4
Adding environment variables
Export LANG=ZH_CN
Export Tmp=/tmp
Export tmpdir= $TMP
Export Oracle_term=xterm
exportoracle_base=/u01/app/ora11g
Exportoracle_home= $ORACLE _base/product/11.2.0/db_1
Exportoracle_grid= $ORACLE _base/product/11.2.0/grid
Export Oms_home=/u01/app/oracle/oms12cr4/oms
Export agent_home=/u01/app/oracle/agent12cr4/core/12.1.0.4.0
Export ORACLE_SID=CCDB
Export Path=/usr/sbin: $PATH
Exportpath= $ORACLE _home/bin: $ORACLE _grid/bin: $PATH
Exportld_library_path= $ORACLE _home/lib:/lib64:/usr/lib64:/usr/local/lib64:/usr/x11r6/lib64
Exportclasspath= $ORACLE _home/jre: $ORACLE _home/jlib: $ORACLE _home/rdbms/jlib
Export nls_lang= "Simplifiedchinese_china. ZHS16GBK "
Export alert= $ORACLE _base/diag/rdbms/$ORACLE _sid/$ORACLE _sid/trace
Stty Erase ^h
Umask 022
if [$USER = "Oracle"]; Then
if [$SHELL = "/bin/ksh"]; Then
Ulimit-p 16384
Ulimit-n 65536
Else
Ulimit-u 16384-n 65536
Fi
Fi
Launch the installation cc
--Temporarily comment out the following environment variables
unset oracle_home oracle_base Oracle_sid
[Email protected]]$ ls
Install JDK libskgxn OMS Plugins release_notes.pdf response Runinstaller stage WLS Wt.zip
[Email protected]]$./runinstaller
Because the hostname does not add domain
If you choose advanced, that's it.
You can choose a small medium-sized deployment
Remove em before the dbconsole is stop
[Email protected] 112db]# su-oracle
[Email protected] ~]$ export lang=zh_en
[Email protected] ~]$ emca-deconfig dbcontrol db-repos Drop
EMCA started on 2013-12-9 21:06:52
EM Configuration Assistant, 11.2.0.3.0 official version
Copyright (c) 2003, +, Oracle. All rights reserved.
Enter the following information:
Database sid:ngcdb
Listener Port number: 1521
SYS User's password:
Sysman User's password:
----------------------------------------------------------------------
Warning: When you delete a repository, the database enters silent mode.
----------------------------------------------------------------------
Do you want to continue? [Yes (Y)/No (N)]: Y
2013-12-9 21:07:54oracle.sysman.emcp.emconfig Perform
Info: This operation is being logged to/u01/app/ora11g/cfgtoollogs/emca/ngcdb/emca_2013_12_09_21_06_51.log.
2013-12-9 21:07:55oracle.sysman.emcp.util.dbcontrolutilstopoms
Info: Stopping Database Control (This operation may take some time) ...
2013-12-9 21:07:57oracle.sysman.emcp.emreposconfig Invoke
Info: Removing the EM Data archive (this may take some time) ...
2013-12-9 21:09:22oracle.sysman.emcp.emreposconfig Invoke
Info: The repository was deleted successfully
Configuration of Enterprise Manager completed successfully
EMCA ended on 2013-12-9 21:09:25
[Email protected] ~]$
Alert Delete em
Mon Dec 09 21:08:01 2013
XDB installed.
XDB initialized.
Mon Dec 09 21:08:02 2013
Stopping background process CJQ0
Mon Dec 09 21:08:02 2013
ALTER SYSTEM SET job_queue_processes=0scope=both sid= ' * ';
Warning:drop_queue_table:No evaluationfor the queue Table:sysman. Mgmt_task_qtable
Warning:drop_queue_table:No evaluationfor the queue Table:sysman. Mgmt_notify_input_qtable
Warning:drop_queue_table:No evaluationfor the queue Table:sysman. Mgmt_paf_msg_qtable_1
Warning:drop_queue_table:No evaluationfor the queue Table:sysman. Mgmt_paf_msg_qtable_2
Mon Dec 09 21:08:28 2013
Thread 1 advanced to log Sequence 9 (lgwrswitch)
Current log# 3 seq# 9 mem# 0:+data/ngcdb/onlinelog/group_3.263.833729183
Current log# 3 seq# 9 mem# 1: +fra/ngcdb/onlinelog/group_3.259.833729183
Mon Dec 09 21:08:29 2013
Archived Log Entry 4 added for thread 1sequence 8 ID 0x9c38e516 dest 1:
Mon Dec 09 21:08:48 2013
Thread 1 advanced to log sequence (Lgwrswitch)
ALTER SYSTEM SET job_queue_processes=20 scope=bothsid= ' * ';
Manual Write +data
The simple installation method interface is as follows:
[Email protected] ~]# export LANG=ZH_CN
[Email protected] ~]#/u01/app/oracle/oms12cr3/oms/allroot.sh
Starting to execute allroot.sh .....
Starting to execute/u01/app/oracle/oms12cr3/oms/root.sh ...
Running Oracle 11g root.sh script ...
The following environment variables is SETAs:
Oracle_owner= Oracle
Oracle_home=/u01/app/oracle/oms12cr3/oms
Enter the full pathname of the local bindirectory: [/usr/local/bin]:
The file "Dbhome" already existsin/usr/local/bin. Overwrite it? (y/n)
[n]: Y
Copying dbhome To/usr/local/bin ...
The file "Oraenv" already existsin/usr/local/bin. Overwrite it? (y/n)
[n]: Y
Copying oraenv To/usr/local/bin ...
The file "Coraenv" already existsin/usr/local/bin. Overwrite it? (y/n)
[n]: Y
Copying coraenv To/usr/local/bin ...
Entries'll be added to the/etc/oratabfile as needed by
Database Configuration Assistant when Adatabase is created
Finished running generic part of Root.shscript.
Now product-specific root actions would beperformed.
/etc exist
Creating/etc/oragchomelist file ...
/u01/app/oracle/oms12cr3/oms
Finished execution of/u01/app/oracle/oms12cr3/oms/root.sh ...
Starting to execute/u01/app/oracle/agent12cr3/core/12.1.0.3.0/root.sh ...
Finished product-specific root actions.
/etc exist
Finished execution of/u01/app/oracle/agent12cr3/core/12.1.0.3.0/root.sh ...
[Email protected] ~]#
https://10.1.5.122:7802/em/
Sysman
Install subsequent operations cc related commands
#!/bin/bash
Exportoracle_home=/u01/app/oracle/product/11.2.0.3/db_1
Exportoms_home=/u01/app/oracle/oms12cr3/oms
exportagent_home=/u01/app/oracle/agent12cr3/core/12.1.0.3.0
# Start Everything
$ORACLE _home/bin/dbstart$oracle_home
$OMS _home/bin/emctlstart OMS
$AGENT _home/bin/emctlstart AGENT
#!/bin/bash
Exportoracle_home=/u01/app/oracle/product/11.2.0.3/db_1
Exportoms_home=/u01/app/oracle/oms12cr3/oms
exportagent_home=/u01/app/oracle/agent12cr3/core/12.1.0.3.0
# Stop Everything
$OMS _home/bin/emctlstop Oms-all
$AGENT _home/bin/emctlstop AGENT
$ORACLE _home/bin/dbshut$oracle_home
Oracle Enterprise Manager Cloud Control 12c R4 installation configuration