12c

【Database 12c】手动创建CDB Container Database容器数据库

2013/02/08 by admin Leave a Comment

手动建库几乎是每个DBA都需要掌握的技能，而Database 12c中手动创建Container Database容器数据库的过程是如何的呢？

目前12c创建容器数据库Container Database和普通Database存在一点点小的区别，需要指定enable pluggable database，已创建的数据库目前无法转换为容器数据库。

创建必要的目录

mkdir -p /stage/oradata
mkdir -p /stage/fr
mkdir -p /u01/app/oracle/admin/MACLEANCDB/adump

我们创建实例初始化文件，并创建DB:

1、 INIT.ORA

##############################################################################
# Copyright (c) 1991, 2001, 2002 by Oracle Corporation
##############################################################################

###########################################
# 
###########################################
_enable_pluggable_database=true

###########################################
# Cache and I/O
###########################################
db_block_size=8192

###########################################
# Cursors and Library Cache
###########################################
open_cursors=300

###########################################
# Database Identification
###########################################
db_domain=""
db_name="MACLEANC"

###########################################
# File Configuration
###########################################
db_create_file_dest="/stage/oradata"
db_recovery_file_dest="/stage/fr"
db_recovery_file_dest_size=5061476352

###########################################
# Miscellaneous
###########################################
compatible=12.0.0.0.0
db_unique_name="MACLEANCDB"
diagnostic_dest=/u01/app/oracle

###########################################
# Network Registration
###########################################
#local_listener=LISTENER_MACLEANCDB

###########################################
# Processes and Sessions
###########################################
processes=300

###########################################
# SGA Memory
###########################################
sga_target=1022361600

###########################################
# Security and Auditing
###########################################
audit_file_dest="/u01/app/oracle/admin/MACLEANCDB/adump"
audit_trail=db
remote_login_passwordfile=EXCLUSIVE

###########################################
# Shared Server
###########################################
dispatchers="(PROTOCOL=TCP) (SERVICE=MACLEANCDBXDB)"

###########################################
# Sort, Hash Joins, Bitmap Indexes
###########################################
pga_aggregate_target=340787200

###########################################
# System Managed Undo and Rollback Segments
###########################################
undo_tablespace=UNDOTBS1

2、创建密码文件

oracle@localhost:~$ /u01/app/oracle/product/12.1.0/dbhome_1/bin/orapwd file=/u01/app/oracle/product/12.1.0/dbhome_1/dbs/orapwMACLEANCDB force=y extended=y

Enter password for SYS:

3、正式创建DB

oracle@localhost:~$ export ORACLE_SID=MACLEANCDB
oracle@localhost:~$ sqlplus / as sysdba

SQL> startup nomount pfile='init.ora';
ORACLE instance started.

Total System Global Area 1018830848 bytes
Fixed Size                  2268040 bytes
Variable Size             268436600 bytes
Database Buffers          742391808 bytes
Redo Buffers                5734400 bytes

CREATE DATABASE "MACLEANC"
MAXINSTANCES 8
MAXLOGHISTORY 1
MAXLOGFILES 16
MAXLOGMEMBERS 3
MAXDATAFILES 1024
DATAFILE SIZE 700M AUTOEXTEND ON NEXT  10240K MAXSIZE UNLIMITED
EXTENT MANAGEMENT LOCAL
SYSAUX DATAFILE SIZE 550M AUTOEXTEND ON NEXT  10240K MAXSIZE UNLIMITED
SMALLFILE DEFAULT TEMPORARY TABLESPACE TEMP TEMPFILE SIZE 20M AUTOEXTEND ON NEXT  640K MAXSIZE UNLIMITED
SMALLFILE UNDO TABLESPACE "UNDOTBS1" DATAFILE  SIZE 200M AUTOEXTEND ON NEXT  5120K MAXSIZE UNLIMITED
CHARACTER SET AL32UTF8
NATIONAL CHARACTER SET UTF8
LOGFILE GROUP 1  SIZE 51200K,
GROUP 2  SIZE 51200K,
GROUP 3  SIZE 51200K
USER SYS IDENTIFIED BY "oracle" USER SYSTEM IDENTIFIED BY "oracle"
enable pluggable database;

Database created.

set linesize 2048;
column ctl_files NEW_VALUE ctl_files;
select concat('control_files=''', concat(replace(value, ', ', ''','''), '''')) ctl_files from v$parameter where name ='control_files';
host echo &ctl_files >> /u01/app/oracle/admin/MACLEANCDB/scripts/init.ora;
spool off

将控制文件信息写入到中==》 echo &ctl_files >> /u01/app/oracle/admin/MACLEANCDB/scripts/init.ora;

4、创建默认使用的USERS表空间

SQL> CREATE SMALLFILE TABLESPACE "USERS" LOGGING  DATAFILE  SIZE 5M AUTOEXTEND ON NEXT  1280K MAXSIZE UNLIMITED  EXTENT MANAGEMENT LOCAL SEGMENT SPACE MANAGEMENT  AUTO;

Tablespace created.

SQL> ALTER DATABASE DEFAULT TABLESPACE "USERS";

Database altered.

5、执行必要的数据字典创建脚本

alter session set "_oracle_script"=true;
alter pluggable database pdb$seed close;
alter pluggable database pdb$seed open;
host perl /u01/app/oracle/product/12.1.0/dbhome_1/rdbms/admin/catcon.pl -l /u01/app/oracle/admin/MACLEANCDB/scripts -b catalog /u01/ap
p/oracle/product/12.1.0/dbhome_1/rdbms/admin/catalog.sql;
host perl /u01/app/oracle/product/12.1.0/dbhome_1/rdbms/admin/catcon.pl -l /u01/app/oracle/admin/MACLEANCDB/scripts -b catblock /u01/a
pp/oracle/product/12.1.0/dbhome_1/rdbms/admin/catblock.sql;
host perl /u01/app/oracle/product/12.1.0/dbhome_1/rdbms/admin/catcon.pl -l /u01/app/oracle/admin/MACLEANCDB/scripts -b catproc /u01/ap
p/oracle/product/12.1.0/dbhome_1/rdbms/admin/catproc.sql;
host perl /u01/app/oracle/product/12.1.0/dbhome_1/rdbms/admin/catcon.pl -l /u01/app/oracle/admin/MACLEANCDB/scripts -b catoctk /u01/ap
p/oracle/product/12.1.0/dbhome_1/rdbms/admin/catoctk.sql;
host perl /u01/app/oracle/product/12.1.0/dbhome_1/rdbms/admin/catcon.pl -l /u01/app/oracle/admin/MACLEANCDB/scripts -b owminst /u01/ap
p/oracle/product/12.1.0/dbhome_1/rdbms/admin/owminst.plb;
host perl /u01/app/oracle/product/12.1.0/dbhome_1/rdbms/admin/catcon.pl -l /u01/app/oracle/admin/MACLEANCDB/scripts -b pupbld -u SYSTE
M/&&systemPassword /u01/app/oracle/product/12.1.0/dbhome_1/sqlplus/admin/pupbld.sql;
connect "SYSTEM"/"&&systemPassword"
set echo on
spool /u01/app/oracle/admin/MACLEANCDB/scripts/sqlPlusHelp.log append
host perl /u01/app/oracle/product/12.1.0/dbhome_1/rdbms/admin/catcon.pl -l /u01/app/oracle/admin/MACLEANCDB/scripts -b hlpbld -u SYSTE
M/&&systemPassword -a 1  /u01/app/oracle/product/12.1.0/dbhome_1/sqlplus/admin/help/hlpbld.sql 1helpus.sql;
@/u01/app/oracle/product/12.1.0/dbhome_1/sqlplus/admin/help/hlpbld.sql helpus.sql;

6、创建一个PDB

cp init.ora  /u01/app/oracle/product/12.1.0/dbhome_1/dbs/initMACLEANCDB.ora 

startup force;

CREATE PLUGGABLE DATABASE MACLEANCDB ADMIN USER MACadmin IDENTIFIED BY oracle
 FILE_NAME_CONVERT=(
  '/stage/oradata/MACLEANCDB/DC36ED41771D435CE0430100007FA00B/datafile/o1_mf_system_8rns0lxf_.dbf', '/stage/oradata/PDB1/datafile/system01.clone',
  '/stage/oradata/MACLEANCDB/DC36ED41771D435CE0430100007FA00B/datafile/o1_mf_sysaux_8rns13dk_.dbf', '/stage/oradata/PDB1/datafile/sysaux1.dbf.clone',
  '/stage/oradata/MACLEANCDB/DC36ED41771D435CE0430100007FA00B/datafile/o1_mf_temp_8rns1d89_.tmp', '/stage/oradata/PDB1/datafile/temp1.tmp.clone'
  )
 STORAGE UNLIMITED;

Filed Under: Oracle, Oracle 12c新特性 Tagged With: 12c, CDB, PDB

将在版本11.2之后废弃或不再支持的特性

2012/10/26 by admin 1 Comment

12c是Oracle未来最重量级的数据库产品，每个新版本的到来都会带来吐故纳新，例如9i的sqlplusw、10g的isqlplus均在其后续版本中废弃；12c中将被废弃或不支持的特性，例如:Database Control DBconsole、OCFS on Windows、CSSCAN、CSALTER、cursor_sharing = ‘SIMILAR’、Oracle Net Connection Pooling feature。为了照顾旧应用的兼容性，看来在12c中暂时不会彻底废掉RBO。

更多信息可以参考以下NOTE:

Deprecated and Desupported Features after Oracle Database 11.2:

Document 1484775.1 Database Control To Be Desupported in DB Releases after 11.2
Document 1392280.1 Desupport of Oracle Cluster File System (OCFS) on Windows with Oracle DB 12
Document 1175293.1 Obsolescence Notice: Oracle COM Automation
Document 1175303.1 Obsolescence Notice: Oracle Objects for OLE
Document 1175297.1 Obsolescence Notice: Oracle Counters for Windows Performance Monitor
Document 1418321.1 CSSCAN and CSALTER To Be Desupported After DB 11.2
Document 1169017.1 Deprecating the cursor_sharing = ‘SIMILAR’ setting
Document 1469466.1: Deprecation of Oracle Net Connection Pooling feature in Oracle Database 11g Release 2

Filed Under: Oracle, Oracle 12c新特性 Tagged With: 12c, Deprecated

12c分页查询特性FETCH FIRST ROWS,OFFSET ROWS FETCH NEXT ROW LIMIT Clause子句

2012/08/10 by admin 1 Comment

Database 12c的FETCH FIRST ROWS特性可以简化老版本中ROW_NUM()或ROWNUM的分页排序写法，大幅节约开发花在分页查询语句上的时间。

row-limiting子句用以限制某个查询返回的行数

可以通过FETCH FIRST/NEXT关键字指定返回结果的行数
可以通过PERCENT关键字指定返回结果的行数比例
可以通过OFFSET关键字指定返回从结果集中的某一行之后行数

12c row-limiting子句对于排序数据限制返回行今后会广泛使用(MySQL上早就有的特性，MySQL开发该特性可能是特别考虑到对于网站分页查询的简化)，也可以被称作Top-N查询。

示意图：

我们这里来对比老的ROWNUM写法等价的FETCH ROWS写法的实际性能对比：

create table larget tablespace users as select rownum t1, rpad('M',99,'A') t2, rpad('M',99,'A') t3, rpad('M',99,'A') t4 from dual connect by level<=99999;

SQL> create index pk_ind on larget(t1) tablespace users;

Index created.

select llv.* from 
(
select rownum rn, ll.* from
(select /*+ index( larget pk_ind */ *  from larget where t1 is not null order by t1 ) ll
where rownum<=20) llv 
where 
llv.rn>=1;

20 rows selected.

Execution Plan
----------------------------------------------------------
Plan hash value: 3843929721

-----------------------------------------------------------------------------------------
| Id  | Operation                      | Name   | Rows  | Bytes | Cost (%CPU)| Time     |
-----------------------------------------------------------------------------------------
|   0 | SELECT STATEMENT               |        |    20 |  3580 |     3   (0)| 00:00:01 |
|*  1 |  VIEW                          |        |    20 |  3580 |     3   (0)| 00:00:01 |
|*  2 |   COUNT STOPKEY                |        |       |       |            |          |
|   3 |    VIEW                        |        |    20 |  3320 |     3   (0)| 00:00:01 |
|   4 |     TABLE ACCESS BY INDEX ROWID| LARGET | 99999 |    29M|     3   (0)| 00:00:01 |
|*  5 |      INDEX FULL SCAN           | PK_IND |    20 |       |     2   (0)| 00:00:01 |
-----------------------------------------------------------------------------------------

Predicate Information (identified by operation id):
---------------------------------------------------

   1 - filter("LLV"."RN">=1)
   2 - filter(ROWNUM<=20)
   5 - filter("T1" IS NOT NULL)

Statistics
----------------------------------------------------------
          1  recursive calls
          0  db block gets
          7  consistent gets
          0  physical reads
          0  redo size
       1841  bytes sent via SQL*Net to client
        554  bytes received via SQL*Net from client
          3  SQL*Net roundtrips to/from client
          0  sorts (memory)
          0  sorts (disk)
         20  rows processed

SQL> select * from larget where t1 is not null order by t1 fetch first 20 rows only;

20 rows selected.

Execution Plan
----------------------------------------------------------
Plan hash value: 3254405084

----------------------------------------------------------------------------------------
| Id  | Operation                     | Name   | Rows  | Bytes | Cost (%CPU)| Time     |
----------------------------------------------------------------------------------------
|   0 | SELECT STATEMENT              |        | 99999 |    18M|  4573   (1)| 00:00:01 |
|*  1 |  VIEW                         |        | 99999 |    18M|  4573   (1)| 00:00:01 |
|*  2 |   WINDOW NOSORT STOPKEY       |        | 99999 |    29M|  4573   (1)| 00:00:01 |
|   3 |    TABLE ACCESS BY INDEX ROWID| LARGET | 99999 |    29M|  4573   (1)| 00:00:01 |
|*  4 |     INDEX FULL SCAN           | PK_IND | 99999 |       |   224   (1)| 00:00:01 |
----------------------------------------------------------------------------------------

Predicate Information (identified by operation id):
---------------------------------------------------

   1 - filter("from$_subquery$_003"."rowlimit_$$_rownumber"<=20)
   2 - filter(ROW_NUMBER() OVER ( ORDER BY "LARGET"."T1")<=20)
   4 - filter("T1" IS NOT NULL)

Statistics
----------------------------------------------------------
          1  recursive calls
          0  db block gets
          7  consistent gets
          0  physical reads
          0  redo size
       1717  bytes sent via SQL*Net to client
        554  bytes received via SQL*Net from client
          3  SQL*Net roundtrips to/from client
          0  sorts (memory)
          0  sorts (disk)
         20  rows processed

select llv.* from 
(
select rownum rn, ll.* from
(select /*+ index( larget pk_ind */ *  from larget where t1 is not null order by t1 ) ll
where rownum<=20000) llv 
where 
llv.rn>=18000;		 

2001 rows selected.

Execution Plan
----------------------------------------------------------
Plan hash value: 3843929721

-----------------------------------------------------------------------------------------
| Id  | Operation                      | Name   | Rows  | Bytes | Cost (%CPU)| Time     |
-----------------------------------------------------------------------------------------
|   0 | SELECT STATEMENT               |        | 20000 |  3496K|   916   (0)| 00:00:01 |
|*  1 |  VIEW                          |        | 20000 |  3496K|   916   (0)| 00:00:01 |
|*  2 |   COUNT STOPKEY                |        |       |       |            |          |
|   3 |    VIEW                        |        | 20000 |  3242K|   916   (0)| 00:00:01 |
|   4 |     TABLE ACCESS BY INDEX ROWID| LARGET | 99999 |    29M|   916   (0)| 00:00:01 |
|*  5 |      INDEX FULL SCAN           | PK_IND | 20000 |       |    46   (0)| 00:00:01 |
-----------------------------------------------------------------------------------------

Predicate Information (identified by operation id):
---------------------------------------------------

   1 - filter("LLV"."RN">=18000)
   2 - filter(ROWNUM<=20000)
   5 - filter("T1" IS NOT NULL)

Statistics
----------------------------------------------------------
          1  recursive calls
          0  db block gets
       1177  consistent gets
        904  physical reads
          0  redo size
      56804  bytes sent via SQL*Net to client
       2006  bytes received via SQL*Net from client
        135  SQL*Net roundtrips to/from client
          0  sorts (memory)
          0  sorts (disk)
       2001  rows processed

select * from larget where t1 is not null order by t1  OFFSET 17999 ROWS FETCH NEXT 2001 ROWS ONLY;

        T1

----------

     18001

	 Execution Plan
----------------------------------------------------------
Plan hash value: 3254405084

----------------------------------------------------------------------------------------
| Id  | Operation                     | Name   | Rows  | Bytes | Cost (%CPU)| Time     |
----------------------------------------------------------------------------------------
|   0 | SELECT STATEMENT              |        | 99999 |    18M|  4573   (1)| 00:00:01 |
|*  1 |  VIEW                         |        | 99999 |    18M|  4573   (1)| 00:00:01 |
|*  2 |   WINDOW NOSORT STOPKEY       |        | 99999 |    29M|  4573   (1)| 00:00:01 |
|   3 |    TABLE ACCESS BY INDEX ROWID| LARGET | 99999 |    29M|  4573   (1)| 00:00:01 |
|*  4 |     INDEX FULL SCAN           | PK_IND | 99999 |       |   224   (1)| 00:00:01 |
----------------------------------------------------------------------------------------

Predicate Information (identified by operation id):
---------------------------------------------------

   1 - filter("from$_subquery$_003"."rowlimit_$$_rownumber"<=CASE  WHEN
              (17999>=0) THEN 17999 ELSE 0 END +2001 AND
              "from$_subquery$_003"."rowlimit_$$_rownumber">17999)
   2 - filter(ROW_NUMBER() OVER ( ORDER BY "LARGET"."T1")<=CASE  WHEN
              (17999>=0) THEN 17999 ELSE 0 END +2001)
   4 - filter("T1" IS NOT NULL)

Statistics
----------------------------------------------------------
          0  recursive calls
          0  db block gets
       1177  consistent gets
          0  physical reads
          0  redo size
      46757  bytes sent via SQL*Net to client
       2006  bytes received via SQL*Net from client
        135  SQL*Net roundtrips to/from client
          0  sorts (memory)
          0  sorts (disk)
       2001  rows processed

不仅可以指定fetch的rows数目，还可以指定返回的行比例，但是这一般会引起真正的INDEX FULL SCAN 

SQL> select * from larget where t1 is not null order by t1 fetch first 1 percent rows only;

1000 rows selected.

Execution Plan
----------------------------------------------------------
Plan hash value: 978863371

----------------------------------------------------------------------------------------
| Id  | Operation                     | Name   | Rows  | Bytes | Cost (%CPU)| Time     |
----------------------------------------------------------------------------------------
|   0 | SELECT STATEMENT              |        | 99999 |    19M|  4573   (1)| 00:00:01 |
|*  1 |  VIEW                         |        | 99999 |    19M|  4573   (1)| 00:00:01 |
|   2 |   WINDOW BUFFER               |        | 99999 |    29M|  4573   (1)| 00:00:01 |
|   3 |    TABLE ACCESS BY INDEX ROWID| LARGET | 99999 |    29M|  4573   (1)| 00:00:01 |
|*  4 |     INDEX FULL SCAN           | PK_IND | 99999 |       |   224   (1)| 00:00:01 |
----------------------------------------------------------------------------------------

Predicate Information (identified by operation id):
---------------------------------------------------

   1 - filter("from$_subquery$_003"."rowlimit_$$_rownumber"<=CEIL("from$_subquer
              y$_003"."rowlimit_$$_total"*1/100))
   4 - filter("T1" IS NOT NULL)

Statistics
----------------------------------------------------------
          1  recursive calls
          0  db block gets
       4571  consistent gets
       3656  physical reads
          0  redo size
      22863  bytes sent via SQL*Net to client
       1269  bytes received via SQL*Net from client
         68  SQL*Net roundtrips to/from client
          1  sorts (memory)
          0  sorts (disk)
       1000  rows processed

SQL>

从以上的2个演示对比，可以看到2种写法实际消耗逻辑读数目是类似的；即12c 中FETCH FIRST ROWS,OFFSET ROWS FETCH NEXT的写法在实际性能上并不比传统的rownum写法来的效率低。但是可以看到CBO在评估fetch rows执行计划的成本时其 TABLE ACCESS BY INDEX ROWID成本要比rownum写法高出不少，这似乎是由于不同的基数计算导致的。

Filed Under: Oracle 12c新特性 Tagged With: 12c, fetch rows

【12c新特性】dbms_stats report_gather_auto_stats统计信息报告特性

2012/04/05 by admin Leave a Comment

版本12c中引入了dbms_stats 的一系列report_* 函数，用以在收集统计信息前向用户汇报预备将执行的统计对象和统计情况。

例如report_gather_auto_stats

function report_gather_auto_stats (
detail_level varchar2 default ‘TYPICAL’,
format varchar2 default ‘TEXT’)
return clob;
—
— This procedure runs auto stats gathering job in reporting mode. That is,
— stats are not actually collected, but all the objects that will be
— affected when auto stats gathering is invoked are reported.
— The detail level for the report is defined by the detail_level
— input parameter. Please see the comments for report_single_stats_operation
— on possible values for detail_level and format.

具体使用：

SQL> variable c clob;
SQL> exec :c:=dbms_stats.report_gather_auto_stats();

PL/SQL procedure successfully completed.

SQL> set long 999

SQL> print :c;

Filed Under: Oracle, Oracle 12c新特性 Tagged With: 12c

12c新特性

2012/01/05 by admin Leave a Comment

以下是Maclean.Liu 所编写或收集的Oracle 12c新特性的文章汇总列表：

Oracle 12c coming soon?
Oracle Enterprise Manager 12c 新特性:实时Real-Time Addm
Oracle Database 12c(12.1) Beta已经开始内部测试
 Oracle发布Oracle Enterprise Manager 12c
Oracle Enterprise Manager Cloud Control 12c(12.1) OMS&Agent安装图文指南
 快速部署Enterprise Manager Cloud Control 12c(12.1) Agent
在OEL 5上快速部署Enterprise Manager Cloud Control 12c(12.1)
Dream features in Oracle Database 12g?
Gain Total Cloud Control with Oracle Enterprise Manager 12c
Enterprise Manager Cloud Control 12c DSS Demos

Filed Under: Oracle, Oracle 12c新特性 Tagged With: 12.1, 12c, 12c release, Oracle 12c新特性

Oracle Enterprise Manager Cloud Control 12c(12.1) OMS&Agent安装图文指南

2011/10/20 by admin Leave a Comment

第一次用百度文库的文档分享功能。

Filed Under: Oracle, Oracle 12c新特性 Tagged With: 12.1, 12c, agent, Cloud Control, EM, installation, oms

Oracle Enterprise Manager 12c 新特性:实时Real-Time Addm

2011/10/19 by admin 6 Comments

在Oracle Enterprise Manager 12c中引入了Real-Time addm的新特性。 DBA可以直接从EM界面上启动实时ADDM(Automatic Database Diagnostic Monitor )信息收集，也叫做Emergency ADDM。

“Emergency ADDM adds performance diagnostics for databases suffering from severe performance problems. Real-time ADDM. You can connect to the database and investigate what is going on when you cannot connect to the database because it is hanging on“

登录EM 12c后Target -> Database -> 选择指定的数据库 -> Performance -> Real-Time Addm:

进入”Real-Time ADDM”后点选start按钮，第一次使用会出现”Required PL/SQL package not installed. Use the link below to deploy the package. The error message from the server is:Package dbsnmp.prvt_eaddm is not found” 的错误:

使用Real-Time Addm要求预安装dbsnmp.prvt_eaddm包，点选下方的PL/SQL Package Deployment链接，进入Package Deployment页面，选择合适的身份认证，并install。

进入Job Run: DATABASE MANAGEMENT PL/SQL DEPLOYMENT JOB页面等待作业完成。

以测试为目的登录数据库并运行以下消耗CPU的SQL语句(不要用在生产库！):

 select count(1) from obj$,obj$,obj$;

回到”Real-Time ADDM”页面再次点击start , 等待一段时间后会自动stop，如下图:

Real-Time Addm有所发现，这里的Number of finding =1 ,点击Findings 可以看到Prority、Performance Impact、Finding Details等信息:

当出现服务进程hang的情况，例如进程因”enq: TM contention” 队列锁而长久等待，则可以从hang data栏获取hang analysis Final Blocker 和 blocking session的信息，找出阻塞的源头:

上图中列出了Blocker chains ，一定程度上可以替代hanganalyze dump。

statistics栏给出了实例的一些属性和近期的系统度量system metrics:

Real-Time Addm可以帮助我们快速定位性能和挂起hang问题，而且给出初步的分析，这要比我们使用脚本一步步查来的快捷多了。

Filed Under: Oracle, Oracle 12c新特性, Oracle SQL性能调优 Tagged With: 12.1, 12c, ADDM, EM, new features

快速部署Enterprise Manager Cloud Control 12c(12.1) Agent

2011/10/18 by admin 4 Comments

在<OEL 5上快速部署Enterprise Manager Cloud Control 12c(12.1)>中我介绍了如何安装配置Oracle Enterprise Manager Cloud Control 12c(12.1) Server ，我们知道光有EM Server而不部署Agent是无法发挥其管理特性的。

接下来我们会再次通过实践了解Em 12c(12.1)中部署Agent代理程序的过程，整个过程和10g/11g Grid Control中的Deploy Agent有较大的区别。

这里我们要注意一点，OMS 12c(12.1) 只能和12.1 的Agent 代理程序配合工作，而不能使用之前任何版本的Agent。“Enterprise Manager Cloud Control can communicate only with Oracle Management Agent 12c and not with any other earlier release of the Management Agent. You can not configure your exising Agents to communicate with Enterprise Manager 12c OMS.”

系统和软件包要求

推荐在Oracle Enterprise Linux 5.7或6.1上安装EM 12c的agent ，可以从edelivery.oracle.com 下载到这2款操作系统的安装介质。

以下演示中的主机均采用Oracle Enterprise Linux 5.7 操作系统。

以下表格列出了在Oracle Linux 6或5.x上安装EM 12c agent ，所要求预装的操作系统软件包，这些软件包可以直接从OS安装DVD介质中找到:

Platform	32-Bit Packages for 32-Bit Platform	64-Bit Packages for 64-Bit Platform
Oracle Linux 6	make-3.81 binutils-2.17.50.0.6 gcc-4.1.1 libstdc++ 4.1.1	make-3.81 binutils-2.17.50.0.6 gcc -4.1.1 libstdc++ -4.1.1
Oracle Linux 5.xRed Hat Enterprise Linux 5.x	make-3.81 binutils-2.17.50.0.6 gcc-4.1.1 libstdc++-4.1.1	Oracle Linux 5.6Red Hat Enterprise Linux 5.6 make-3.81 binutils-2.17.50.0.6 gcc -4.1.1 libaio-0.3.106 glibc-common-2.3.4 libstdc++ -4.1.1 setarch-1.6 sysstat-5.0.5 rng-utils-2 Oracle Linux 5.3 and 5.4 Red Hat Enterprise Linux 5.3 and 5.4 make-3.81 binutils-2.17.50.0.6 gcc -4.1.1 libstdc++ -4.1.1

Platform

32-Bit Packages for 32-Bit Platform

64-Bit Packages for 64-Bit Platform

Oracle Linux 6

make-3.81
binutils-2.17.50.0.6
gcc-4.1.1
libstdc++ 4.1.1

make-3.81
binutils-2.17.50.0.6
gcc -4.1.1
libstdc++ -4.1.1

Oracle Linux 5.xRed Hat Enterprise Linux 5.x

make-3.81
binutils-2.17.50.0.6
gcc-4.1.1
libstdc++-4.1.1

Oracle Linux 5.6Red Hat Enterprise Linux 5.6

make-3.81
binutils-2.17.50.0.6
gcc -4.1.1
libaio-0.3.106
glibc-common-2.3.4
libstdc++ -4.1.1
setarch-1.6
sysstat-5.0.5
rng-utils-2

Oracle Linux 5.3 and 5.4

Red Hat Enterprise Linux 5.3 and 5.4

make-3.81
binutils-2.17.50.0.6
gcc -4.1.1
libstdc++ -4.1.1

准备工作

1. 12c 部署agent 要求在创建必要的credential profile，该credential profile将包含能够从OMS server ssh到目标节点target node的用户身份认证，且要求该用户能够在target node上以sudo执行root用户的权限。

这里我们以oracle用户为例，我们将以目标节点上的oracle用户身份创建credential profile，首先我们要确保oracle用户能够以sudo 执行root用户的权限，这需要用到/etc/sudoers配置文件:

!确保/usr/local/bin/sudo 这个符号链接存在

[root@vrh2 ~]# ln -s /usr/bin/sudo /usr/local/bin/sudo

[root@vrh2 m01]# ls -l /etc/sudoers
-r--r----- 1 root root 3407 Oct 18 19:30 /etc/sudoers

[root@vrh2 m01]# cp /etc/sudoers /etc/sudoers.bak 

打开/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@vrh2 m01]# su  - oracle

[oracle@vrh2 ~]$ ls -l /root
ls: /root: Permission denied

[oracle@vrh2 ~]$ sudo ls -l /root

[sudo] password for oracle:
total 88
-rw------- 1 root root  1832 Aug 11 05:26 anaconda-ks.cfg
drwxr-xr-x 2 root root  4096 Aug 10 21:31 Desktop
-rw-r--r-- 1 root root 56307 Aug 11 05:26 install.log
-rw-r--r-- 1 root root  4136 Aug 11 05:26 install.log.syslog

2. 在目标节点上创建必要的目录 :

[root@vrh2 m01]# mkdir /m01

[root@vrh2 m01]# chown oracle:oinstall /m01

3. 确保OMS server 和target server 间的通信畅通，如没有使用dns 服务，那么不要忘记将host/ip 信息写入到/etc/hosts文件中，如果漏掉这部将报target node can not be reached 错误

正式安装

首先再次以sysman身份登录EM https console，如https://192.168.1.169:7799/em。

点击右上角的setup-> Add Target -> Add Targets Manually

进入Add Targets Manually页面，选择” Add Host Target” ，并点击Add Host …按钮:

在”add Target – Host and Platform “页面使用默认的”session name”即可，点选”+Add”按钮填入主机名和平台信息:

注意这里推荐填入规范的hostname，如”vrh2.oracle.com”，注意主机名不能带下划线 “_”，若Platform下拉列表中没有你要的平台那么说明在该平台上还没有12.1 的agent可用。

输入完成后点击Next进入”Add Target – Installation Details ” 页面，点中deployment details 出现下来菜单选择Fresh Agent install ，并填入installation base directory 等目录信息。

接着在Named confidential 点击蓝色的”+” 图形按钮，会跳出 create new Named confidential 的窗口，填入之前配好的oracle用户的信息:

完成后点击Ok,回到原”Add Target – Installation Details “界面，确认并点击Next:

进入Review页面，确认信息正确并点击Deploy Agent:

完成后会进入Agent Deployment summary 页面，这里存在三个阶段：

Initialization — 拷贝agent介质到目标服务器
Remote Prerequisite Check — 检测目标服务器的安装先决条件
Agent Deployment –具体的Installation Agent 、Secure Agent 和执行root.sh

若一开始没有正确配置用户的sudo ，则可能在Remote Prerequisite Check阶段出现检测警告，例如下图:

如果一切顺利，以上三个阶段完成后Agent即在运作了:

Agent Deployment 的日志存放在 $OMS_HOME/sysman/prov/agentpush/$date目录下，也可以从EM的网页界面上找到这些日志的具体位置。

之后点击Target -> host可以看到新加入的主机:

之后点击Target -> Database -> add 添加数据库配置信息:

在host栏填入新增加的目标服务器，并点击continue:

EM 会自动找出目标服务器上已有的数据库, 点击Configure 填入dbsnmp用户的密码后保存并Continue:

之后点击Target -> database 就可以看到新增的数据库了:

点击数据库名 -> 点击Performance -> Performance Home后可以看到新的12c 的性能总览图:

Filed Under: Oracle, Oracle 12c新特性 Tagged With: 12.1, 12c, agent, Cloud Control, EM, enterprise manager

在OEL 5上快速部署Enterprise Manager Cloud Control 12c(12.1)

2011/10/16 by admin 10 Comments

在OOW 2011期间甲骨文发布了新一代的企业管理器Enterprise Manager Cloud Control 12c,这里我们来介绍如何在Oracle Enterprise Linux 5上快速部署EM 12c和其Agent。

硬件要求

安装Enterprise Manager Cloud Control 12c的硬件要求如下表，推荐至少有4GB内存

	Small	Medium	Large
	(1 OMS, <=1000 targets, <100 agents)	(2 OMSes for <=10,000 targets and <1000 agents)	(> 2 OMSes, >=10,000 targets, >=1000 agents)
CPU Cores/Host	2	4	8
RAM	4 GB	6 GB	8 GB
RAM with ADP^{Foot 1}, JVMD^{Foot 2}	6GB	10 GB	14 GB
Oracle WebLogic Server JVM Heap Size^{Foot 3}	512 MB	1 GB	2 GB
Hard Disk Space	7 GB	7 GB	7 GB
Hard Disk Space with ADP, JVMD	10 GB	12 GB	14 GB

^{Footnote 1}ADP Manager is Application Dependency and Performance

^{Footnote 2}JVMD is JVM Diagnostics

^{Footnote 3}Default heap size is 512 MB. For higher heap size, set the size manually.

系统和软件包要求

推荐在Oracle Enterprise Linux 5.7或6.1上安装EM 12c ，可以从edelivery.oracle.com 下载到这2款操作系统的安装介质。

以下演示中的主机均采用Oracle Enterprise Linux 5.7 操作系统。

以下表格列出了在Oracle Linux 6或5.x上安装EM 12c ，所要求预装的操作系统软件包，这些软件包可以直接从OS安装DVD介质中找到:

Platform	32-Bit Packages for 32-Bit Platform	64-Bit Packages for 64-Bit Platform
Oracle Linux 6	make-3.81 binutils-2.17.50.0.6 gcc-4.1.1 libaio-0.3.106 glibc-common-2.3.4 compat-libstdc++296 libstdc++ 4.1.1 libstdc++devel 4.1.0 sysstat-5.0 compat-db 4.1.25	make-3.81 binutils-2.17.50.0.6 gcc -4.1.1 libaio-0.3.106 glibc-common-2.3.4 libstdc++ -4.1.1 sysstat-5.0.5 In addition, install the 32-bit version as well as the 64-bit version of glibc-devel-2.5-49.
Oracle Linux 5.xRed Hat Enterprise Linux 5.x	make-3.81 binutils-2.17.50.0.6 gcc-4.1.1 libaio-0.3.106 glibc-common-2.3.4 compat-libstdc++296-2.96 libstdc++ 4.1.1 libstdc++devel-4.1.0 setarch-1.6 sysstat-5.0.5 compat-db 4.1.25 rng_utils-2.0	make-3.81 binutils-2.17.50.0.6 gcc -4.1.1 libaio-0.3.106 glibc-common-2.3.4 libstdc++ -4.1.1 setarch-1.6 sysstat-5.0.5 rng-utils-2.0 In addition, install the 32-bit version as well as the 64-bit version of glibc-devel-2.5-49.

Platform

32-Bit Packages for 32-Bit Platform

64-Bit Packages for 64-Bit Platform

Oracle Linux 6

make-3.81
binutils-2.17.50.0.6
gcc-4.1.1
libaio-0.3.106
glibc-common-2.3.4
compat-libstdc++296
libstdc++ 4.1.1
libstdc++devel 4.1.0
sysstat-5.0
compat-db 4.1.25

make-3.81
binutils-2.17.50.0.6
gcc -4.1.1
libaio-0.3.106
glibc-common-2.3.4
libstdc++ -4.1.1
sysstat-5.0.5

In addition, install the 32-bit version as well as the 64-bit version of glibc-devel-2.5-49.

Oracle Linux 5.xRed Hat Enterprise Linux 5.x

make-3.81
binutils-2.17.50.0.6
gcc-4.1.1
libaio-0.3.106
glibc-common-2.3.4
compat-libstdc++296-2.96
libstdc++ 4.1.1
libstdc++devel-4.1.0
setarch-1.6
sysstat-5.0.5
compat-db 4.1.25
rng_utils-2.0

make-3.81
binutils-2.17.50.0.6
gcc -4.1.1
libaio-0.3.106
glibc-common-2.3.4
libstdc++ -4.1.1
setarch-1.6
sysstat-5.0.5
rng-utils-2.0

In addition, install the 32-bit version as well as the 64-bit version of glibc-devel-2.5-49.

准备工作

在正式部署EM 12c 之前我们需要完成一系列的准备工作，包括：

1. 下载EM 12c(12.1) 安装介质

EM 12.1的安装介质可以从Oracle技术网络OTN上找到其下载页面，64位软件的具体下载地址:

介质包括 disk1和disk2 2个接近3GB的zip压缩包，其中em12_linux64_disk1of2.zip包含了主要的EM binary，而em12_linux64_disk2of2.zip包含了为EM扩展的插件，如支持Exadata、IBM DB2的插件等。

2. 在安装EM的Host上创建EM软件的拥有者OS账号

这里我创建oem用户来执行后续的安装操作:

groupadd -g 800 oinstall
useradd -g oinstall oem

3. 解压安装介质

创建存放解压后安装介质的目录并解压上述zip包：

su - oem
[oem@vrh5 tmp]$ mkdir em_cloud
[oem@vrh5 tmp]$ cd em_cloud/

[oem@vrh5 em_cloud]$ unzip ../V28375-01.zip
[oem@vrh5 em_cloud]$ unzip ../V28376-01.zip

4. 在EM主机上安装必要的rpm 软件包以及调整/etc/sysctl.conf中的内核参数，该步骤可以通过oracle-validated工具代劳，详见<Understand Oracle Validated Configurations>

5. 为 EM拥有者用户配置必要的ulimit 参数 , 需要修改/etc/security/limits.conf配置文件，如:

[root@vrh5 ~]# tail -10 /etc/security/limits.conf
#ftp             hard    nproc           0
#@student        -       maxlogins       4

# End of file

oem soft nofile 4096
oem hard nofile 4096

6. 为EM 12c配置合适的repository database以存放数据

这里可以在Metalink上的Certification Matrix中找到EM 12c已认证的数据库版本,如下图所示 11.2.0.2和11.2.0.3 均已通过该认证:

这里推荐新建一个11.2.0.2 版本的数据库作为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

可以通过以下命令满足上述的参数要求，当然参数的值还可以适当放大:

  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;

注意EM 要求 repository database没有配置DB control ，如果有的话需要通过下列命令drop 掉:

export ORACLE_HOME= $YOUR_ORACLE_HOME
export ORACLE_SID= $Repository_SID

$ORACLE_HOME/bin/emca -deconfig dbcontrol db -repos drop

同时要求sysman 和 sysman_mds、 sysman_opss用户不存在，已创建该用户的DB 可以drop 掉:

SQL> select * from v$version;

BANNER
--------------------------------------------------------------------------------
Oracle Database 11g Enterprise Edition Release 11.2.0.2.0 - 64bit Production
PL/SQL Release 11.2.0.2.0 - Production
CORE    11.2.0.2.0      Production
TNS for Linux: Version 11.2.0.2.0 - Production
NLSRTL Version 11.2.0.2.0 - Production

SQL> select * from global_name;

GLOBAL_NAME
--------------------------------------------------------------------------------
www.askmac.cn & www.askmac.cn

drop user sysman cascade;
drop user sysman_mds cascade;
drop user sysman_opss cascade;
drop user sysman_apm cascade;
drop user sysman_ro cascade;
drop user mgmt_view cascade;

@?/rdbms/admin/catsnmp

7. 确保能够从EM 主机顺利登录到 repository 数据库 :

[oem@vrh5 tmp]$ tnsping vrh4:1521/SBDB

TNS Ping Utility for Linux: Version 11.2.0.2.0 - Production on 16-OCT-2011 21:18:24

Copyright (c) 1997, 2010, Oracle.  All rights reserved.

Used parameter files:

Used HOSTNAME adapter to resolve the alias
Attempting to contact (DESCRIPTION=(CONNECT_DATA=(SERVICE_NAME=SBDB))(ADDRESS=(PROTOCOL=TCP)
(HOST=192.168.1.167)(PORT=1521)))
OK (0 msec)

[oem@vrh5 tmp]$ sqlplus  sys/maclean@vrh4:1521/SBDB  as sysdba

SQL*Plus: Release 11.2.0.2.0 Production on Sun Oct 16 21:18:54 2011

Copyright (c) 1982, 2010, Oracle.  All rights reserved.

Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.2.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options

SQL>

8. 确保网络正常

这里要求EM主机必须使用statics IP 静态IP ，否则安装会出错，且已正确在/etc/hosts或DNS配置唯一的域名解析

正式安装

我们开始正式通过OUI安装Oracle Enterprise Manager Cloud Control 12c(12.1)，这里要用到图形化的界面，确保DISPLAY环境变量正确或者使用Xmanager之类的软件:

(oem)$ unset ORACLE_HOME ORACLE_BASE ORACLE_SID
(oem)$ export DISPLAY=:0
(oem)$ cd /tmp/em_cloud/

注意这里若你的EM Host拥有多个host name ,那么要使用ORACLE_HOSTNAME参数指定规范的host name 

如/etc/hosts 中的信息为： 192.168.1.8 vrh5 vrh5.oracle.com 

那么要选用vrh5.oracle.com 这个hostname 

如果host name 中带"_"符号 可能导致安装失败

(oem)$ ./runInstaller ORACLE_HOSTNAME=vrh5.oracle.com

Starting Oracle Universal Installer…

如下图OUI界面顺利启动，勾销” I wish to receive security update…”，并点击Next:

Prerequisite Checks会检测EM安装的前提条件，这里因为物理内存不足(要求3g)而出现Warning，点击Next忽略该警告

点击Yes,忽略该问题

若检测顺利，则如下图:

下一步选择create a new Enterprise Manager -> Simple ，为Middleware Home location选定一可用的空目录，注意目录的拥有者应为oem(EM 所有者用户)

选择想要安装的插件，这里我们不安装额外的插件，保持默认配置点击Next:

选择暂时不安装Exalogic Elastic Cloud Infrastructure插件, Install Later:

配置Weblogic Server，填入Weblogic和Node Manager密码及OMS instance Base Location:

配置数据库连接信息，填入repository database的连接信息:

输入 sysman用户和Agent注册使用的密码，安装程序会自动为你提供EM所需创建表空间数据文件的位置：

选择EM 12c将要使用的端口，一般默认即可，除非这些端口有其他用途:

点击 Next后再点击Install Now进入安装过程:

安装流程包括Copy Files、Configure Plugins Prerequisites Check、Repository Configuration、MDS Schema Configuration、OMS Configuration、Plugins Deployment and Configuration 、 Start Oracle Management Service、 Oracle Configuration Manager Repeater、Agent Configuration Assistant 、Run root scripts，总耗时在1个小时左右。

在此过程中推荐监控安装进程的日志，这些日志的位置如下:

例如:

/m01/midd/oms/sysman/log/schemamanager/m_$date/m_$date.CREATE/em_repos_config.log
/m01/midd/oms/sysman/log/schemamanager/m_$date/m_$date.CREATE/emschema.log
/m01/midd/oms/cfgtoollogs/cfgfw/oracle.sysman.top.oms_*.log
/m01/midd/oms/cfgtoollogs/omsca/*.log

em_repos_config.log记录了em repository的配置日志，在此安装过程中可能遇到如下错误:

INFO: oracle.sysman.top.oms:__________________________DUMPING PARAMETERS
INFO: oracle.sysman.top.oms:OracleHome: /m01/midd/oms
INFO: oracle.sysman.top.oms:Connect String: (DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)
(HOST=vrh4.oracle.com)(PORT=1588)))(CONNECT_DATA=(SID=SBDB)))
INFO: oracle.sysman.top.oms:SYS User: SYS
INFO: oracle.sysman.top.oms:________________________________________________________________________
INFO: oracle.sysman.top.oms:MDS Schema Creation status: RUNNING
SEVERE: oracle.sysman.top.oms:MDS Schema Creation is failed
INFO: oracle.sysman.top.oms:_______________________________________________________________________
INFO: oracle.sysman.top.oms:Starting opss Schema Creation.
INFO: oracle.sysman.top.oms:OPSS Component is already created
INFO: oracle.sysman.top.oms:_______________________________________________________________________
INFO: oracle.sysman.top.oms:Starting APM Schema Creation.
INFO: oracle.sysman.top.oms:APM Component is already created
INFO: oracle.sysman.top.oms:The plug-in MDS Schema Configuration has failed its perform method
INFO: oracle.sysman.top.oms:About to execute plug-in MDS Schema Configuration
INFO: oracle.sysman.top.oms:The plug-in MDS Schema Configuration is running

SEVERE: oracle.sysman.top.oms:MDS Schema Creation is failed 创建失败是由bug引起的

遇到该错误后，手动登录到数据库并执行以下create user命令:

 create user SYSMAN_MDS identified by sysman_mds;

创建该SYSMAN_MDS用户后，回到安装界面并点击retry按钮，安装会继续下去。

OMS和Agent配置过程中的日志如下:

INFO: oracle.sysman.top.oms:The plug-in OMS Configuration is running
INFO: oracle.sysman.top.oms:Internal PlugIn Class: oracle.sysman.oms.OMSConfiguration
INFO: oracle.sysman.top.oms:Classpath = /m01/midd/oms/sysman/jlib/omsConfig.jar:
INFO: oracle.sysman.top.oms:BaseConfiguration:invoke:Starting BaseConfiguration
invoke method on an aggregate=oracle.sysman.top.oms for Action=configuration in step=5:microstep=0
INFO: oracle.sysman.top.oms:Fetcing ports from teh static ports file: /m01/midd/.gcinstall_temp/staticports.ini
INFO: oracle.sysman.top.oms:COMMAND: /m01/midd/oms/bin/omsca NEW -RESPONSE_FILE
/m01/midd/oms/omscarespfile -lock_console -lock_upload -CONFIGURE_REPEATER true -nostart
INFO: oracle.sysman.top.oms:
 Check the OMS Configuration Assistant logs at: /m01/midd/oms/cfgtoollogs/omsca

INFO: oracle.sysman.top.oms:Oracle Enterprise Manager 11g Release 1 Grid Control
INFO: oracle.sysman.top.oms:Copyright (c) 2009, 2010, Oracle. All rights reserved.
INFO: oracle.sysman.top.oms:
INFO: oracle.sysman.top.oms:Enter Admin Server user password:
Enter Admin Server user password:Doing pre requisite checks ......
INFO: oracle.sysman.top.oms:Pre requisite checks completed successfully
INFO: oracle.sysman.top.oms:
INFO: oracle.sysman.top.oms:Doing infrastructure setup ......
INFO: oracle.sysman.top.oms:Infrastructure setup of EM completed successfully.
INFO: oracle.sysman.top.oms:
INFO: oracle.sysman.top.oms:Doing pre deployment operations ......
INFO: oracle.sysman.top.oms:Pre deployment of EM completed successfully.
INFO: oracle.sysman.top.oms:
INFO: oracle.sysman.top.oms:Deploying EM ......
INFO: oracle.sysman.top.oms:Deployment of EM completed successfully.
INFO: oracle.sysman.top.oms:
INFO: oracle.sysman.top.oms:Configuring webtier ......
INFO: oracle.sysman.top.oms:Configuring webTier completed successfully.
INFO: oracle.sysman.top.oms:
INFO: oracle.sysman.top.oms:Securing OMS ......
INFO: oracle.sysman.top.oms:EM Key is secured and is backed up at /m01/midd/oms/sysman/config/emkey.ora
INFO: oracle.sysman.top.oms:Adapter created successfully: emgc_USER
INFO: oracle.sysman.top.oms:Adapter created successfully: emgc_GROUP
INFO: oracle.sysman.top.oms:Post "Deploy and Repos Setup" operations completed successfully.
INFO: oracle.sysman.top.oms:
INFO: oracle.sysman.top.oms:Performing Post deploy operations ....
INFO: oracle.sysman.top.oms:Software Library OMS shared storage is not configured, skipping metadata registration
INFO: oracle.sysman.top.oms:Post deploy operations completed successfully.
INFO: oracle.sysman.top.oms:
INFO: oracle.sysman.top.oms:EM configuration completed successfully.
INFO: oracle.sysman.top.oms:EM URL is:https://vrh5.oracle.com:7799/em
INFO: oracle.sysman.top.oms:
INFO: oracle.sysman.top.oms:/m01/midd/oms/install/ocm/ocmInstance.txt (No such file or directory)
INFO: oracle.sysman.top.oms:Command for doing Self Update registration:
/m01/midd/oms/bin/emctl register oms metadata -service SelfUpdateEntityInstance
-file /m01/midd/oms/install/selfUpdate/agent_software_manifest.xml -core
INFO: oracle.sysman.top.oms:Oracle Enterprise Manager Cloud Control 12c Release 12.1.0.1.0
INFO: oracle.sysman.top.oms:Copyright (c) 1996, 2011 Oracle Corporation.  All rights reserved.
INFO: oracle.sysman.top.oms:SYSMAN password:
SYSMAN password:
Metadata registration successful
INFO: oracle.sysman.top.oms:Agent software entity instance registration to Self Update is successful.
INFO: oracle.sysman.top.oms:
 Check the OMS Configuration Assistant logs at: /m01/midd/oms/cfgtoollogs/omsca

INFO: oracle.sysman.top.oms:The plug-in OMS Configuration has successfully been performed
INFO: oracle.sysman.top.oms:About to execute plug-in Plugins Deployment and Configuration
INFO: oracle.sysman.top.oms:The plug-in Plugins Deployment and Configuration is running
INFO: oracle.sysman.top.oms:Internal PlugIn Class: oracle.sysman.oms.PluginCA
INFO: oracle.sysman.top.oms:Classpath = /m01/midd/oms/sysman/jlib/omsConfig.jar
INFO: oracle.sysman.top.oms:BaseConfiguration:invoke:Starting BaseConfiguration
invoke method on an aggregate=oracle.sysman.top.oms for Action=configuration in step=6:microstep=0
INFO: oracle.sysman.top.oms:Fetcing ports from teh static ports file: /m01/midd/.gcinstall_temp/staticports.ini
INFO: oracle.sysman.top.oms:COMMAND: /m01/midd/oms/bin/pluginca
-oracleHome /m01/midd/oms -middlewareHome /m01/midd -action  deploy
-plugins oracle.sysman.db=12.1.0.1.0,oracle.sysman.xa=12.1.0.1.0,
oracle.sysman.emas=12.1.0.1.0,oracle.sysman.mos=12.1.0.1.0,
INFO: oracle.sysman.top.oms:pluginca - Plugin Configuration Tool
INFO: oracle.sysman.top.oms:Oracle Enterprise Manager 12c Release 1 Grid Control
INFO: oracle.sysman.top.oms:Copyright (c) 1996, 2011 Oracle Corporation. All rights reserved.
INFO: oracle.sysman.top.oms:Log file:
/m01/midd/oms/cfgtoollogs/pluginca/plugin_deployment_2011-10-17_08-10-26/configplugin_deploy_2011-10-17_08-10-26.log
INFO: oracle.sysman.top.oms:Trace file:
/m01/midd/oms/cfgtoollogs/pluginca/plugin_deployment_2011-10-17_08-10-26/configplugin_deploy_2011-10-17_08-10-26.trc
INFO: oracle.sysman.top.oms:Initializing PluginCA.
INFO: oracle.sysman.top.oms:Starting Deployment
INFO: oracle.sysman.top.oms:Invoking pre deploy callbacks.
INFO: oracle.sysman.top.oms:OMS state could be found. It is down
INFO: oracle.sysman.top.oms:Performing Midtier deconfig
INFO: oracle.sysman.top.oms:Performing Midtier config
INFO: oracle.sysman.top.oms:Performing Midtier update oh prop
INFO: oracle.sysman.top.oms:Performing Opss config
INFO: oracle.sysman.top.oms:Performing Post metadata registration
INFO: oracle.sysman.top.oms:Performing Post config module
INFO: oracle.sysman.top.oms:Invoking post deploy callbacks.
INFO: oracle.sysman.top.oms:Completed Deployment
INFO: oracle.sysman.top.oms:Checking file
/m01/midd/oms/sysman/install/undeployed_pluginswith name 12.1.0.1.0_oracle.sysman.vt_2000_0.opar
INFO: oracle.sysman.top.oms:Checking file
/m01/midd/oms/sysman/install/undeployed_pluginswith name 12.1.0.1.0_oracle.em.ssad_2000_0.opar
INFO: oracle.sysman.top.oms:Checking file
/m01/midd/oms/sysman/install/undeployed_pluginswith name 12.1.0.1.0_oracle.sysman.empa_2000_0.opar
INFO: oracle.sysman.top.oms:Checking file
/m01/midd/oms/sysman/install/undeployed_pluginswith name 12.1.0.1.0_oracle.em.sidb_2000_0.opar
INFO: oracle.sysman.top.oms:Checking file
/m01/midd/oms/sysman/install/undeployed_pluginswith name 12.1.0.1.0_oracle.sysman.emct_2000_0.opar
INFO: oracle.sysman.top.oms:Checking file
/m01/midd/oms/sysman/install/undeployed_pluginswith name 12.1.0.1.0_oracle.em.soee_2000_0.opar
INFO: oracle.sysman.top.oms:Checking file
/m01/midd/oms/sysman/install/undeployed_pluginswith name 12.1.0.1.0_oracle.sysman.ssa_2000_0.opar
INFO: oracle.sysman.top.oms:Checking file
/m01/midd/oms/sysman/install/undeployed_pluginswith name 12.1.0.1.0_oracle.sysman.emfa_2000_0.opar
INFO: oracle.sysman.top.oms:The plug-in Plugins Deployment and Configuration has successfully been performed
INFO: oracle.sysman.top.oms:About to execute plug-in Start Oracle Management Service
INFO: oracle.sysman.top.oms:The plug-in Start Oracle Management Service is running
INFO: oracle.sysman.top.oms:Internal PlugIn Class: oracle.sysman.oms.StartOMS
INFO: oracle.sysman.top.oms:Classpath = /m01/midd/oms/sysman/jlib/omsConfig.jar:
INFO: oracle.sysman.top.oms:BaseConfiguration:invoke:Starting BaseConfiguration
invoke method on an aggregate=oracle.sysman.top.oms for Action=configuration in step=9:microstep=0
INFO: oracle.sysman.top.oms:Fetcing ports from teh static ports file:
/m01/midd/.gcinstall_temp/staticports.ini
INFO: oracle.sysman.top.oms:Starting OMS ...
INFO: oracle.sysman.top.oms:Executing command: /m01/midd/oms/bin/emctl start oms
INFO: oracle.sysman.top.oms:Oracle Enterprise Manager Cloud Control 12c Release 12.1.0.1.0
INFO: oracle.sysman.top.oms:Copyright (c) 1996, 2011 Oracle Corporation.  All rights reserved.
INFO: oracle.sysman.top.oms:Starting WebTier...
INFO: oracle.sysman.top.oms:WebTier Successfully Started
INFO: oracle.sysman.top.oms:Starting Oracle Management Server...
INFO: oracle.sysman.top.oms:Oracle Management Server Successfully Started
INFO: oracle.sysman.top.oms:Oracle Management Server is Up
INFO: oracle.sysman.top.oms:Starting of OMS is successful.
INFO: oracle.sysman.top.oms:The plug-in Start Oracle Management Service has successfully been performed

OMS和Agent成功配置和启动后，会要求用户执行allroot.sh脚本

# /home/oem/oraInventory/orainstRoot.sh
Changing permissions of /home/oem/oraInventory
Adding read,write permissions for group,Removing read,write,execute permissions for world.
Changing groupname of /home/oem/oraInventory to oinstall.
The execution of the script is complete

 /m01/midd/oms/allroot.sh 

Starting to execute allroot.sh ......... 

Starting to execute /m01/midd/oms/root.sh ......
Running Oracle 11g root.sh script...

The following environment variables are set as:
    ORACLE_OWNER= oem
    ORACLE_HOME=  /m01/midd/oms

Enter the full pathname of the local bin directory: [/usr/local/bin]: 

   Copying dbhome to /usr/local/bin ...
   Copying oraenv to /usr/local/bin ...

   Copying coraenv to /usr/local/bin ...

Creating /etc/oratab file...

Entries will be added to the /etc/oratab file as needed by
Database Configuration Assistant when a database is created
Finished running generic part of root.sh script.
Now product-specific root actions will be performed.
/etc exist

Creating /etc/oragchomelist file...
/m01/midd/oms
Finished execution of  /m01/midd/oms/root.sh ......

Starting to execute /m01/midd/agent/core/12.1.0.1.0/root.sh ......
Finished product-specific root actions.
/etc exist
Finished execution of  /m01/midd/agent/core/12.1.0.1.0/root.sh ......

打开浏览器，输入地址https://hostname:7799/em(7799默认端口)访问EM Cloud Control 12c，输入sysman的身份认证

Accept License Agreement

首次登陆EM 会显示一个OverView页面：

使用如下命令停止OMS和Agent 服务:

#!/bin/bash
export OMS_HOME=/m01/midd/oms
export AGENT_HOME=/m01/midd/agent/core/12.1.0.1.0

$OMS_HOME/bin/emctl stop oms -all
$AGENT_HOME/bin/emctl stop agent

如
[oem@vrh5 ~]$ $OMS_HOME/bin/emctl stop oms -all
Oracle Enterprise Manager Cloud Control 12c Release 12.1.0.1.0  
Copyright (c) 1996, 2011 Oracle Corporation.  All rights reserved.
Stopping WebTier...
WebTier Successfully Stopped
Stopping Oracle Management Server...
Oracle Management Server Successfully Stopped
AdminServer Successfully Stopped
Oracle Management Server is Down
[oem@vrh5 ~]$ $AGENT_HOME/bin/emctl stop agent
Oracle Enterprise Manager 12c Cloud Control 12.1.0.1.0  
Copyright (c) 1996, 2011 Oracle Corporation.  All rights reserved.
Stopping agent ..... stopped.

使用如下命令启动OMS和Agent 服务:

#!/bin/bash
export OMS_HOME=/m01/midd/oms
export AGENT_HOME=/m01/midd/agent/core/12.1.0.1.0

$OMS_HOME/bin/emctl start oms

$AGENT_HOME/bin/emctl start agent

如
[oem@vrh5 ~]$ $OMS_HOME/bin/emctl start oms
Oracle Enterprise Manager Cloud Control 12c Release 12.1.0.1.0  
Copyright (c) 1996, 2011 Oracle Corporation.  All rights reserved.
Starting WebTier...
WebTier Successfully Started
Starting Oracle Management Server...
Oracle Management Server Successfully Started
Oracle Management Server is Up

[oem@vrh5 ~]$ $AGENT_HOME/bin/emctl start agent
Oracle Enterprise Manager 12c Cloud Control 12.1.0.1.0  
Copyright (c) 1996, 2011 Oracle Corporation.  All rights reserved.
Starting agent ............................. started.

Filed Under: Oracle, Oracle 12c新特性 Tagged With: 12.1, 12c, EM, enterprise manager, installation