Oracle 12c Study之--Enterprise Manager Cloud Control Install

ゞ浴缸里的玫瑰 2022-09-26 00:25 143阅读 0赞

**Oracle 12c Study之--Enterprise Manager Cloud Control Install**

**系统环境：RedHat EL6.4(64)**

**Oracle：   Oracle 11.2.0.3.0**

**EMCC:      VER 12.1.0.1**

**目标： 安装Oracle 12c Enterprise Manager Cloud Control**

*Enterprise Manager Cloud Control is system management software that delivers centralized monitoring, administration, and life cycle management functionality for the complete IT infrastructure, including systems running Oracle and non-Oracle technologies.*

## Enterprise Manager Cloud Control Architecture ##

Enterprise Manager Cloud Control includes the following components:

*  Oracle Management Agent
 *  Oracle Management Service
 *  Oracle Management Repository
 *  Oracle Management Plug-Ins
 *  Enterprise Manager Cloud Control Console

[Figure 1-2][] shows a sample Enterprise Manager Cloud Control

architecture and illustrates how these

core components fit into the architecture.

Figure 1-2 Enterprise Manager Cloud Control Architecture

![Center][]

**1、数据库版本**

***17:37:23 SYS@ prod>select \* from v$version;***  
BANNER  
\--------------------------------------------------------------------------------  
**Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production**  
PL/SQL Release 11.2.0.3.0 - Production  
CORE    11.2.0.3.0      Production  
TNS for Linux: Version 11.2.0.3.0 - Production  
NLSRTL Version 11.2.0.3.0 - Production

**2、启动数据库listener**  
\[oracle@rh64 ~\]$ lsnrctl status  
LSNRCTL for Linux: Version 11.2.0.3.0 - Production on 02-SEP-2016 15:02:23  
Copyright (c) 1991, 2011, Oracle.  All rights reserved.  
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=rh64)(PORT=1521)))  
STATUS of the LISTENER  
\------------------------  
Alias                     LISTENER  
Version                   TNSLSNR for Linux: Version 11.2.0.3.0 - Production  
Start Date                02-SEP-2016 15:02:11  
Uptime                    0 days 0 hr. 0 min. 11 sec  
Trace Level               off  
Security                  ON: Local OS Authentication  
SNMP                      OFF  
Listener Parameter File   /u01/app/oracle/product/11.2.0/db\_1/network/admin/listener.ora  
Listener Log File         /u01/app/oracle/diag/tnslsnr/rh64/listener/alert/log.xml  
Listening Endpoints Summary...  
  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=rh64)(PORT=1521)))  
  (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1521)))  
Services Summary...  
Service "prod" has 1 instance(s).  
  Instance "prod", status READY, has 1 handler(s) for this service...  
Service "prodXDB" has 1 instance(s).  
  Instance "prod", status READY, has 1 handler(s) for this service...  
The command completed successfully

**3、卸载资料库上的DB control并删除相关的用户**  
**\[oracle@rh64 ~\]$ emca -deconfig dbcontrol db -repos drop**  
STARTED EMCA at Sep 2, 2016 3:02:29 PM  
EM Configuration Assistant, Version 11.2.0.3.0 Production  
Copyright (c) 2003, 2011, Oracle.  All rights reserved.  
Enter the following information:  
Database SID: prod  
Listener port number: 1521  
Password for SYS user:    
Password for SYSMAN user:    
\----------------------------------------------------------------------  
WARNING : While repository is dropped the database will be put in quiesce mode.  
\----------------------------------------------------------------------  
Do you wish to continue? \[yes(Y)/no(N)\]: Y  
Sep 2, 2016 3:02:42 PM oracle.sysman.emcp.EMConfig perform  
INFO: This operation is being logged at /u01/app/oracle/cfgtoollogs/emca/prod/emca\_2016\_09\_02\_15\_02\_29.log.  
Sep 2, 2016 3:02:42 PM oracle.sysman.emcp.EMDBPreConfig performDeconfiguration  
WARNING: EM is not configured for this database. No EM-specific actions can be performed. Some of the possible reasons may be:   
 1) EM is configured with different hostname then physical host. Set environment variable ORACLE\_HOSTNAME=<hostname> and re-run EMCA script   
 2) ORACLE\_HOSTNAME is set. Unset it and re-run EMCA script  
Sep 2, 2016 3:02:42 PM oracle.sysman.emcp.EMReposConfig invoke  
INFO: Dropping the EM repository (this may take a while) ...  
Sep 2, 2016 3:04:32 PM oracle.sysman.emcp.EMReposConfig invoke  
INFO: Repository successfully dropped  
Enterprise Manager configuration completed successfully  
FINISHED EMCA at Sep 2, 2016 3:04:32 PM  
  
**13:07:43 SYS@ prod>drop user sysman cascade;**  
User dropped.  
  
**14:32:31 SYS@ prod>drop user mgmt\_view cascade;**  
User dropped.  
  
  
**4、配置repository db参数**  
  
  
**14:48:02 SYS@ prod>alter system set processes=500 scope=spfile;**  
System altered.  
  
**14:48:30 SYS@ prod>alter system set session\_cached\_cursors=500 scope=spfile;**  
System altered.  
  
**14:49:59 SYS@ prod>alter system set shared\_pool\_size=500m scope=spfile;**  
System altered.  
  
**14:50:26 SYS@ prod>alter system set job\_queue\_processes=22 scope=spfile;**  
System altered.  
  
  
**14:51:23 SYS@ prod>show parameter cursor**  
  
NAME                                 TYPE        VALUE  
\------------------------------------ ----------- ------------------------------  
cursor\_bind\_capture\_destination      string      memory+disk  
cursor\_sharing                       string      EXACT  
cursor\_space\_for\_time                boolean     FALSE  
open\_cursors                         integer     300  
session\_cached\_cursors               integer     50

**14:51:29 SYS@ prod>show parameter pga**  
NAME                                 TYPE        VALUE  
\------------------------------------ ----------- ------------------------------  
pga\_aggregate\_target                 big integer 0

**14:51:45 SYS@ prod>alter system set pga\_aggregate\_target=500m scope=spfile;**  
System altered.  
  
**调整redo log files size：  
14:55:50 SYS@ prod>alter database add logfile  
14:55:59   2  '/u01/app/oracle/oradata/prod/redo04a.log' size 300m;**  
Database altered.  
  
**14:56:34 SYS@ prod>alter database add logfile  
14:56:41   2  '/u01/app/oracle/oradata/prod/redo05a.log' size 300m;**  
Database altered.  
  
**14:57:01 SYS@ prod>alter database add logfile  
14:57:05   2  '/u01/app/oracle/oradata/prod/redo06a.log' size 300m;**  
Database altered.  
  
  
**14:58:42 SYS@ prod>select group\#,sequence\#,status ,bytes from v$log；**  
  
    GROUP\#  SEQUENCE\# STATUS                BYTES  
\---------- ---------- ---------------- ----------  
         4          7 CURRENT           314572800  
         5          5 INACTIVE          314572800  
         6          6 INACTIVE          314572800  
           
**5、安装EMCC软件  **

**\[root@rh64 soft\]\# cd Disk1/  
\[root@rh64 Disk1\]\# ls -l**  
total 1739904  
drwxr-xr-x 8 root root       4096 Feb 12  2012 install  
drwxr-xr-x 4 root root       4096 Feb 12  2012 jdk  
drwxrwxr-x 4 root root       4096 Feb 12  2012 libskgxn  
drwxr-xr-x 4 root root       4096 Feb 11  2012 oms  
drwxr-xr-x 2 root root       4096 Feb 12  2012 plugins  
\-rwxrwxr-x 1 root root      99523 Feb 22  2012 Release\_Notes.pdf  
drwxr-xr-x 2 root root       4096 Feb 12  2012 response  
\-rwxr-xr-x 1 root root       5136 Feb 10  2010 runInstaller  
drwxr-xr-x 9 root root       4096 Feb 12  2012 stage  
drwxr-xr-x 2 root root       4096 Feb 12  2012 wls  
\-rwxr-xr-x 1 root root 1781511210 Feb 11  2012 WT.zip

\[oracle@rh64 Disk1\]$ ./runInstaller ORACLE\_HOSTNAME=rh64.enmo.com  
![Center 1][]

![Center 2][]

![Center 3][]

![Center 4][]、

![Center 5][]

![Center 6][]

![Center 7][]

![Center 8][]

![Center 9][]

**在安装过程中需要关闭自动统计的任务：**

**15:22:24 SYS@ prod>begin  
15:22:28   2  dbms\_auto\_task\_admin.disable(  
15:22:42   3  client\_name=>'auto optimizer stats collection',  
15:23:08   4  operation=>null,  
15:23:18   5  window\_name=>null);  
15:23:28   6  end;  
15:23:29   7  /**  
  
PL/SQL procedure successfully completed.  
  
**15:24:31 SYS@ prod>select client\_name,status from dba\_autotask\_client where client\_name like 'auto optim%';**  
  
CLIENT\_NAME                                                      STATUS  
\---------------------------------------------------------------- --------  
auto optimizer stats collection                                  DISABLED  
  
**6、安装完成运行allroot.sh脚本**  
\[root@rh64 Disk1\]\# /u01/app/oracle/Middleware/oms/allroot.sh   
  
Starting to execute allroot.sh .........   
Starting to execute /u01/app/oracle/Middleware/oms/root.sh ......  
Running Oracle 11g root.sh script...  
The following environment variables are set as:  
    ORACLE\_OWNER= oracle  
    ORACLE\_HOME=  /u01/app/oracle/Middleware/oms  
Enter the full pathname of the local bin directory: \[/usr/local/bin\]:   
The file "dbhome" already exists in /usr/local/bin.  Overwrite it? (y/n)   
\[n\]: y  
   Copying dbhome to /usr/local/bin ...  
The file "oraenv" already exists in /usr/local/bin.  Overwrite it? (y/n)   
\[n\]: y  
   Copying oraenv to /usr/local/bin ...  
The file "coraenv" already exists in /usr/local/bin.  Overwrite it? (y/n)   
\[n\]: y  
   Copying coraenv to /usr/local/bin ...  
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...  
/u01/app/oracle/Middleware/oms  
Finished execution of  /u01/app/oracle/Middleware/oms/root.sh ......  
  
Starting to execute /u01/app/oracle/Middleware/agent/core/12.1.0.1.0/root.sh ......  
Finished product-specific root actions.  
/etc exist  
Finished execution of  /u01/app/oracle/Middleware/agent/core/12.1.0.1.0/root.sh ......  
  
**7、启动EMCC Server服务**  
**\[oracle@rh64 ~\]$ /u01/app/oracle/Middleware/oms/bin/emctl start oms**  
Oracle Enterprise Manager Cloud Control 12c Release 12.1.0.1.0    
Copyright (c) 1996, 2012 Oracle Corporation.  All rights reserved.  
Starting WebTier...  
WebTier Successfully Started  
Starting Oracle Management Server...  
Oracle Management Server Already Started  
Oracle Management Server is Up  
\[oracle@rh64 bin\]$ pwd  
/u01/app/oracle/Middleware/agent/core/12.1.0.1.0/bin  
\[oracle@rh64 bin\]$ ./emctl start agent  
Oracle Enterprise Manager 12c Cloud Control 12.1.0.1.0    
Copyright (c) 1996, 2012 Oracle Corporation.  All rights reserved.  
Agent is already running  
  
启动中的错误提示：  
\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*  
Fatal NI connect error 12537, connecting to:  
 (LOCAL=NO)  
  VERSION INFORMATION:  
        TNS for Linux: Version 11.2.0.3.0 - Production  
        Oracle Bequeath NT Protocol Adapter for Linux: Version 11.2.0.3.0 - Production  
        TCP/IP NT Protocol Adapter for Linux: Version 11.2.0.3.0 - Production  
  Time: 02-SEP-2016 19:15:17  
  Tracing not turned on.  
  Tns error struct:  
    ns main err code: 12537  
      
TNS-12537: TNS:connection closed  
    ns secondary err code: 12560  
    nt main err code: 0  
    nt secondary err code: 0  
    nt OS err code: 0  
opiodr aborting process unknown ospid (3350) as a result of ORA-609  
Fri Sep 02 19:32:19 2016  
  
\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*  
Fatal NI connect error 12537, connecting to:  
 (LOCAL=NO)  
  VERSION INFORMATION:  
        TNS for Linux: Version 11.2.0.3.0 - Production  
        Oracle Bequeath NT Protocol Adapter for Linux: Version 11.2.0.3.0 - Production  
        TCP/IP NT Protocol Adapter for Linux: Version 11.2.0.3.0 - Production  
  Time: 02-SEP-2016 19:32:20  
  Tracing not turned on.  
  Tns error struct:  
    ns main err code: 12537  
      
TNS-12537: TNS:connection closed  
    ns secondary err code: 12560  
    nt main err code: 0  
    nt secondary err code: 0  
    nt OS err code: 0  
opiodr aborting process unknown ospid (6029) as a result of ORA-609  
Fri Sep 02 19:34:05 2016  
  
\[root@rh64 ~\]\# cat /etc/resolv.conf   
\# Generated by NetworkManager  
\#search enmo.com  
  
\# No nameservers found; try putting DNS servers into your  
\# ifcfg files in /etc/sysconfig/network-scripts like so:  
\#  
\# DNS1=xxx.xxx.xxx.xxx  
\# DNS2=xxx.xxx.xxx.xxx  
\# DOMAIN=lab.foo.com bar.foo.com  
\[root@rh64 ~\]\#   
  
关闭/etc/resolv.conf,禁止DNS的查找  
\[root@rh64 ~\]\# mv  /etc/resolv.conf /etc/resolv.conf.bk

**8、安装完成通过console访问**

**登录User：   sysman**

**Password： sys man password**

**![Center 10][]**

![Center 11][]

**-----Agent 安装后续中...**

[Figure 1-2]: http://docs.oracle.com/html/E22624_12/overview.htm#CJAEFEID
[Center]: /images/20220717/bf366559ed274b83a2514538abddbfc1.png
[Center 1]: /images/20220717/dda69b6a143c45d7a34335f0f6b21500.png
[Center 2]: /images/20220717/e3eb767184a443f18fd7703dcdfd2d5e.png
[Center 3]: /images/20220717/1f761f2dd65a4fae843c4dbf7407477f.png
[Center 4]: /images/20220717/9153174e33244be09877f91c7d821936.png
[Center 5]: /images/20220717/63567e956f294f9f93e0afc6390fe134.png
[Center 6]: /images/20220717/ec1d4c6221994d039ef706855f09254d.png
[Center 7]: /images/20220717/712e312034734fe6944850027a76cb13.png
[Center 8]: /images/20220717/463b83dd75874a8fa1956fc0cc252601.png
[Center 9]: /images/20220717/521469e102e4437fb20f142839e5873d.png
[Center 10]: /images/20220717/754ee9dc95b143dd96cb853a67dfb5c4.png
[Center 11]: /images/20220717/1126cc5841ac48e296de09ed1cade228.png