现在的位置: 首页 > 综合 > 正文

使用OEM,SQL*Plus,iSQL*Plus 管理Oracle实例

2013年08月27日 ⁄ 综合 ⁄ 共 4593字 ⁄ 字号 评论关闭

--==========================================

--使用OEM,SQL*Plus,iSQL*Plus 管理Oracle实例

--==========================================

/*

一、管理组件

    Oracle 10g数据库管理包含三个组件,本文主要介绍Database Control,SQL*PlusiSQL*Plus

       Database instance(数据库实例)  -->系统使用的后台进程

       Listener (监听器)              -->监听客户端连接到数据库

       Management interfance

           Database Control           -->OEM

          Management agent (when using Grid Control)  --网格管理

二、使用OEM管理Oracle        

    1.关于OEMOracle i开始就随软件提供企业管理器(OEM

        g中,oracledbca建库过程中会出现四个用户:sys,system,dbsnap,sysman

       (--dbsnap 用户用于OEM智能代理管理工作,sysman用户则是OEM的管理员帐号)

       如果在dbca建库过程中没有选择安装OEM,则没有dbsnapsysman用户,如果在dbca建库时选择启用database control管理数据库,

       则需要在数据库中建立一个sysmanschema,用于保存OEM的一些数据,这个就是OEM的资料档案库(repository),在G版本中,

       这个库存储在sysaux表空间中

      

    2.OEM的启动和关闭

    启动:emctl start dbconsole   启动后用浏览器http://IP:1158/em   来登陆OEM,进行图形化操作数据库

       关闭:emctl stop dbconsole

       状态:emctl status dbconsole                     */

       --下面演示EM启动到停止的过程

       [oracle@robinson scripts]$ emctl start dbconsole  --启动

        TZ set to PRC

        Oracle Enterprise Manager 10g Database Control Release 10.2.0.1.0 

        Copyright (c) 1996, 2005 Oracle Corporation.  All rights reserved.

        http://robinson.com:1158/em/console/aboutApplication

        Starting Oracle Enterprise Manager 10g Database Control ...................... started.

        ------------------------------------------------------------------

        Logs are generated in directory /u01/app/oracle/10g/robinson.com_orcl/sysman/log

        [oracle@robinson scripts]$ emctl status dbconsole    --查看状态

        TZ set to PRC

        Oracle Enterprise Manager 10g Database Control Release 10.2.0.1.0 

        Copyright (c) 1996, 2005 Oracle Corporation.  All rights reserved.

        http://robinson.com:1158/em/console/aboutApplication

        Oracle Enterprise Manager 10g is running.

        ------------------------------------------------------------------

        Logs are generated in directory /u01/app/oracle/10g/robinson.com_orcl/sysman/log

        [oracle@robinson scripts]$ emctl stop dbconsole      --停止

        TZ set to PRC

        Oracle Enterprise Manager 10g Database Control Release 10.2.0.1.0 

        Copyright (c) 1996, 2005 Oracle Corporation.  All rights reserved.

        http://robinson.com:1158/em/console/aboutApplication

        Stopping Oracle Enterprise Manager 10g Database Control ...

        ...  Stopped.

        /*

       

    3.重建OEM

    由于EM需要J2EE环境支持,正常创建后,在$ORACLE_HOME目录下将会建立一个

    类似$ORACLE_HOME/oc4j/j2ee/OC4J_DBConsole_<hostname>_<sid>的目录,如果此目录不存在,则EM将无法启动。

    另外,如果服务器修改过主机名等信息,导致OEM可能无法启动,此时需要重新配置EM   

        使用emca命令来重建EM档案库,关于emca的用户,使用emca -h 来查看详细说明 */

      

       [oracle@robinson scripts]$ emca -config dbcontrol db -repos recreate

 

       STARTED EMCA at Apr 21, 2010 3:09:04 PM

       EM Configuration Assistant, Version 10.2.0.1.0 Production

       Copyright (c) 2003, 2005, Oracle.  All rights reserved.

 

       Enter the following information:

       Database SID: orcl

       Database Control is already configured for the database orcl

       You have chosen to configure Database Control for managing the database orcl

       This will remove the existing configuration and the default settings and perform a fresh configuration

       Do you wish to continue? [yes(Y)/no(N)]: y

       Listener port number: 1521

       Password for SYS user: 

       Password for DBSNMP user: 

       Password for SYSMAN user: 

       Email address for notifications (optional):

       Outgoing Mail (SMTP) server for notifications (optional):

       -----------------------------------------------------------------

 

       You have specified the following settings

 

       Database ORACLE_HOME ................ /u01/app/oracle/10g

 

       Database hostname ................ robinson.com

       Listener port number ................ 1521

       Database SID ................ orcl

       Email address for notifications ...............

       Outgoing Mail (SMTP) server for notifications ...............

 

       -----------------------------------------------------------------

       Do you wish to continue? [yes(Y)/no(N)]: y

       Apr 21, 2010 3:09:24 PM oracle.sysman.emcp.EMConfig perform

       INFO: This operation is being logged at /u01/app/oracle/10g/cfgtoollogs/emca/orcl/emca_2010-04-21_03-09-04-PM.log.

       Apr 21, 2010 3:09:25 PM oracle.sysman.emcp.util.DBControlUtil stopOMS

       INFO: Stopping Database Control (this may take a while) ...

       Apr 21, 2010 3:09:32 PM oracle.sysman.emcp.EMReposConfig dropRepository

       INFO: Dropping the EM repository (this may take a while) ...

       Apr 21, 2010 3:11:41 PM oracle.sysman.emcp.EMReposConfig invoke

       INFO: Repository successfully dropped

       Apr 21, 2010 3:11:41 PM oracle.sysman.emcp.EMReposConfig createRepository

       INFO: Creating the EM repository (this may take a while) ...

       Apr 21, 2010 3:16:01 PM oracle.sysman.emcp.EMReposConfig invoke

       INFO: Repository successfully created

       Apr 21, 2010 3:16:08 PM oracle.sysm

抱歉!评论已关闭.