EM的创建及重建

最新推荐文章于 2021-04-11 23:47:23 发布
最新推荐文章于 2021-04-11 23:47:23 发布
阅读量140 收藏
点赞数
文章标签： 数据库 操作系统 网络

[root@dg ~]# su - oracle
[oracle@dg ~]$ echo $ORACLE_UNQNAME
dg

-- 开始创建
[oracle@dg ~]$ emca -repos create

STARTED EMCA at Sep 25, 2013 12:26:50 AM
EM Configuration Assistant, Version 11.2.0.3.0 Production
Copyright (c) 2003, 2011, Oracle.  All rights reserved.

Enter the following information:
Database SID: dg
Listener port number: 1521
Password for SYS user: 
Password for SYSMAN user: 

Do you wish to continue? [yes(Y)/no(N)]: y
Sep 25, 2013 12:27:02 AM oracle.sysman.emcp.EMConfig perform
INFO: This operation is being logged at /u01/app/oracle/cfgtoollogs/emca/dg/emca_2013_09_25_00_26_50.log.
Sep 25, 2013 12:27:02 AM oracle.sysman.emcp.ParamsManager checkListenerStatusForDBControl
WARNING: ORA-12541: TNS:no listener


-- 由于监听没启动，创建失败
[oracle@dg ~]$ lsnrctl start

LSNRCTL for Linux: Version 11.2.0.3.0 - Production on 25-SEP-2013 00:27:14

Copyright (c) 1991, 2011, Oracle.  All rights reserved.

Starting /u01/app/oracle/product/11.2.0/dbhome_1/bin/tnslsnr: please wait...

TNSLSNR for Linux: Version 11.2.0.3.0 - Production
System parameter file is /u01/app/oracle/product/11.2.0/dbhome_1/network/admin/listener.ora
Log messages written to /u01/app/oracle/diag/tnslsnr/dg/listener/alert/log.xml
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=dg.localdomain)(PORT=1521)))
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1521)))

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=dg)(PORT=1521)))
STATUS of the LISTENER
------------------------
Alias                     LISTENER
Version                   TNSLSNR for Linux: Version 11.2.0.3.0 - Production
Start Date                25-SEP-2013 00:27:16
Uptime                    0 days 0 hr. 0 min. 0 sec
Trace Level               off
Security                  ON: Local OS Authentication
SNMP                      OFF
Listener Parameter File   /u01/app/oracle/product/11.2.0/dbhome_1/network/admin/listener.ora
Listener Log File         /u01/app/oracle/diag/tnslsnr/dg/listener/alert/log.xml
Listening Endpoints Summary...
  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=dg.localdomain)(PORT=1521)))
  (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1521)))
Services Summary...
Service "dg" has 1 instance(s).
  Instance "dg", status UNKNOWN, has 1 handler(s) for this service...

-- 启动监听后再次创建
[oracle@dg ~]$ emca -repos create

STARTED EMCA at Sep 25, 2013 12:27:19 AM
EM Configuration Assistant, Version 11.2.0.3.0 Production
Copyright (c) 2003, 2011, Oracle.  All rights reserved.

Enter the following information:
Database SID: dg
Listener port number: 1521
Password for SYS user: 
Password for SYSMAN user: 
Password for SYSMAN user: 

Do you wish to continue? [yes(Y)/no(N)]: y
Sep 25, 2013 12:27:30 AM oracle.sysman.emcp.EMConfig perform
INFO: This operation is being logged at /u01/app/oracle/cfgtoollogs/emca/dg/emca_2013_09_25_00_27_19.log.
Sep 25, 2013 12:27:30 AM oracle.sysman.emcp.EMReposConfig createRepository
INFO: Creating the EM repository (this may take a while) ...
Sep 25, 2013 12:35:13 AM oracle.sysman.emcp.EMReposConfig invoke
INFO: Repository successfully created
Enterprise Manager configuration completed successfully
FINISHED EMCA at Sep 25, 2013 12:35:14 AM

[oracle@dg ~]$ emctl status dbconsole
 Oracle Enterprise Manager 11g Database Control Release 11.2.0.3.0
Copyright (c) 1996, 2011 Oracle Corporation.  All rights reserved.
https://dg.localdomain:1158/em/console/aboutApplication
Oracle Enterprise Manager 11g is running.

-- 查看EM创建日志
[oracle@dg ~]$ more /u01/app/oracle/cfgtoollogs/emca/dg/emca_2013_09_25_00_27_19.log
-- 省略部分
CONFIG: Setting param: ORACLE_HOME value: /u01/app/oracle/product/11.2.0/dbhome_1
  CONFIG: No value was set for the parameter DB_UNIQUE_NAME.
Sep 25, 2013 12:27:19 AM oracle.sysman.emcp.ParamsManager getParam
CONFIG: No value was set for the parameter SID.
Sep 25, 2013 12:27:21 AM oracle.sysman.emcp.ParamsManager setParam
CONFIG: Setting param: SID value: dg
Sep 25, 2013 12:27:22 AM oracle.sysman.emcp.ParamsManager setParam
CONFIG: Setting param: PORT value: 1521
 Sep 25, 2013 12:27:25 AM oracle.sysman.emcp.ParamsManager getRepDbPort
CONFIG: Listener Port: 1521
Sep 25, 2013 12:27:25 AM oracle.sysman.emcp.util.GeneralUtil isLocalConnectionRequired
CONFIG: isLocalConnectionRequired: true
Sep 25, 2013 12:27:25 AM oracle.sysman.emcp.util.GeneralUtil initSQLEngine
CONFIG: isLocalConnectionRequired: true. Connecting to database instance locally.
Sep 25, 2013 12:27:25 AM oracle.sysman.emcp.util.GeneralUtil initSQLEngineLoacly
CONFIG: SQLEngine connecting with SID: dg, oracleHome: /u01/app/oracle/product/11.2.0/dbhome_1, and user: SYS
Sep 25, 2013 12:27:26 AM oracle.sysman.emcp.util.GeneralUtil initSQLEngineLoacly
CONFIG: SQLEngine created successfully and connected
CONFIG: ORACLE_BASE :/u01/app/oracle
Sep 25, 2013 12:27:30 AM oracle.sysman.emcp.ParamsManager setParam
CONFIG: Setting param: DB_UNIQUE_NAME value: dg
Sep 25, 2013 12:27:30 AM oracle.sysman.emcp.ParamsManager setParam
CONFIG: Setting param: SERVICE_NAME value: dg
Sep 25, 2013 12:27:30 AM oracle.sysman.emcp.ParamsManager checkListenerStatusForDBControl
CONFIG: HOST: dg.localdomain
Sep 25, 2013 12:27:30 AM oracle.sysman.emcp.ParamsManager checkListenerStatusForDBControl
CONFIG:  connectDesc : (DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=dg.localdomain)(PORT=1521)))(CONNECT_DATA=
(SERVICE_NAME=dg)))
Sep 25, 2013 12:27:30 AM oracle.sysman.emcp.util.GeneralUtil isLocalConnectionRequired
CONFIG: isLocalConnectionRequired: true
Sep 25, 2013 12:27:30 AM oracle.sysman.emcp.util.GeneralUtil initSQLEngine
CONFIG: isLocalConnectionRequired: true. Connecting to database instance locally.
Sep 25, 2013 12:27:30 AM oracle.sysman.emcp.util.GeneralUtil initSQLEngineLoacly
CONFIG: SQLEngine connecting with SID: dg, oracleHome: /u01/app/oracle/product/11.2.0/dbhome_1, and user: SYS
Sep 25, 2013 12:27:30 AM oracle.sysman.emcp.util.GeneralUtil initSQLEngineLoacly
CONFIG: SQLEngine created successfully and connected
Sep 25, 2013 12:27:30 AM oracle.sysman.emcp.EMReposConfig createRepository
CONFIG: Spooling to /u01/app/oracle/cfgtoollogs/emca/dg/emca_repos_create_2013_09_25_00_27_30.log
Sep 25, 2013 12:27:30 AM oracle.sysman.emcp.EMReposConfig createRepository
INFO: Creating the EM repository (this may take a while) ...
Sep 25, 2013 12:35:13 AM oracle.sysman.emcp.EMReposConfig invoke
INFO: Repository successfully created
Sep 25, 2013 12:35:14 AM oracle.sysman.emcp.EMConfig restoreOuiLoc
CONFIG: Restoring oracle.installer.oui_loc to /u01/app/oracle/product/11.2.0/dbhome_1/oui


-- 以下为重建EM
[oracle@dg ~]$ emca -config dbcontrol db -repos recreate

STARTED EMCA at Sep 25, 2013 12:37:37 AM
EM Configuration Assistant, Version 11.2.0.3.0 Production
Copyright (c) 2003, 2011, Oracle.  All rights reserved.

Enter the following information:
Database SID: dg
Listener port number: 1521
Listener ORACLE_HOME [ /u01/app/oracle/product/11.2.0/dbhome_1 ]:
Password for SYS user: 
Password for DBSNMP user: 
Sep 25, 2013 12:37:56 AM oracle.sysman.emcp.util.GeneralUtil initSQLEngineLoacly
WARNING: ORA-28000: the account is locked

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/product/11.2.0/dbhome_1

Local hostname ................ dg.localdomain
Listener ORACLE_HOME ................ /u01/app/oracle/product/11.2.0/dbhome_1
Listener port number ................ 1521
Database SID ................ dg
Email address for notifications ...............
Outgoing Mail (SMTP) server for notifications ...............

-----------------------------------------------------------------
----------------------------------------------------------------------
WARNING : While repository is dropped the database will be put in quiesce mode.
----------------------------------------------------------------------
Do you wish to continue? [yes(Y)/no(N)]: y
Sep 25, 2013 12:38:17 AM oracle.sysman.emcp.EMConfig perform
INFO: This operation is being logged at /u01/app/oracle/cfgtoollogs/emca/dg/emca_2013_09_25_00_37_36.log.
Sep 25, 2013 12:38:19 AM oracle.sysman.emcp.EMReposConfig invoke
INFO: Dropping the EM repository (this may take a while) ...
Sep 25, 2013 12:41:37 AM oracle.sysman.emcp.EMReposConfig invoke
INFO: Repository successfully dropped
Sep 25, 2013 12:41:38 AM oracle.sysman.emcp.EMReposConfig createRepository
INFO: Creating the EM repository (this may take a while) ...
Sep 25, 2013 12:49:52 AM oracle.sysman.emcp.EMReposConfig invoke
INFO: Repository successfully created
Sep 25, 2013 12:50:03 AM oracle.sysman.emcp.EMReposConfig uploadConfigDataToRepository
INFO: Uploading configuration data to EM repository (this may take a while) ...
Sep 25, 2013 12:51:12 AM oracle.sysman.emcp.EMReposConfig invoke
INFO: Uploaded configuration data successfully
Sep 25, 2013 12:51:16 AM oracle.sysman.emcp.util.DBControlUtil secureDBConsole
INFO: Securing Database Control (this may take a while) ...
Sep 25, 2013 12:51:36 AM oracle.sysman.emcp.util.DBControlUtil secureDBConsole
INFO: Database Control secured successfully.
Sep 25, 2013 12:51:36 AM oracle.sysman.emcp.util.DBControlUtil startOMS
INFO: Starting Database Control (this may take a while) ...
Sep 25, 2013 12:54:05 AM oracle.sysman.emcp.EMDBPostConfig performConfiguration
INFO: Database Control started successfully
Sep 25, 2013 12:54:06 AM oracle.sysman.emcp.EMDBPostConfig performConfiguration
INFO: >>>>>>>>>>> The Database Control URL is https://dg.localdomain:1158/em <<<<<<<<<<<
Sep 25, 2013 12:54:27 AM oracle.sysman.emcp.EMDBPostConfig invoke
WARNING:
************************  WARNING  ************************

Management Repository has been placed in secure mode wherein Enterprise Manager data will be encrypted.  The encryption key has been placed in the file: /u01/app/oracle/product/11.2.0/dbhome_1/dg.localdomain_dg/sysman/config/emkey.ora. Ensure this file is backed up as the encrypted data will become unusable if this file is lost.

***********************************************************
Enterprise Manager configuration completed successfully
FINISHED EMCA at Sep 25, 2013 12:54:27 AM

[oracle@dg ~]$ emctl status dbconsole
 Oracle Enterprise Manager 11g Database Control Release 11.2.0.3.0
Copyright (c) 1996, 2011 Oracle Corporation.  All rights reserved.
https://dg.localdomain:1158/em/console/aboutApplication
Oracle Enterprise Manager 11g is running.

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/429786/viewspace-776407/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/429786/viewspace-776407/

cuiwu7783
关注
oracle rac手工创建em,ORACLE 11g RAC EM手动配置
weixin_35834213的博客
04-03 523
ORACLE 11g RAC EM手动配置前一段通过静默安装方式配置了一套两个节点的11gr2 RAC，后面再配置EM却不成功，症状表现是EM配置完成后，登录页面，出现如下错误:The 主机 CPU Chart could not be generated.1.Error: Invalid BoundDataSource: no class, method or dataSource provid...
重建oracle的em
02-29
### 重建Oracle的EM（Enterprise Manager）知识点 #### 标题与描述中的核心知识点解析： **标题：“重建oracle的em”** 此标题明确指出本文档的主题是关于如何重建Oracle Enterprise Manager（简称EM）。EM是...
创建em
huoshuyinhua的专栏
04-13 629
手动创建em 之前装oracle之前已经知晓是否要使用em，手头有个库要用em 但安装时没有装。其实很简单可以看第二步，第一步删除em 1）删除下面的schema、role、synonym （在sql里以管理员身份运行） DROP public synonym SETEMVIEWUSERCONTEXT; DROP PUBLIC SYNONYM MGMT_TARGET_BLACKO
oracle手工创建 em,Oracle 10g Admin: Create EM （创建EM）
weixin_42525428的博客
04-02 128
Microsoft Windows XP [Version 5.1.2600](C) Copyright 1985-2001 Microsoft Corp.C:/Documents and Settings/Administrator>emca -repos createEMCA 开始于 2009-8-15 20:13:03EM Configuration Assistant 10.2.0....
em创建的两种方式
weixin_34101784的博客
12-07 194
em创建（两种方式1，图形dbca，当然了，前提是先创建一个监听。 2，手工命令安装em）手工命令创建em（确保数据库开启，确保监听正常并且最好是动态监听，确保system表空间够用大概1G左右），我的空间有限只给了800M，如下select file_name,tablespace_name,bytes/1024/1024 from dba_data_files wher...
最简单的create语句
u012467492的专栏
06-23 1114
附： 一个主外键关系的语句，或者用alter修改成主外键关系的语 --表tb_user create table tb_user ( id int not null, username varchar(32) not null ); --给tb_user添加主键 alter table tb_user add constraint pk_users primary key (id)
oracle 11gem配置,oracle 11g em配置出错
weixin_39864453的博客
04-07 289
本帖最后由 793135970 于 2017-3-1 15:15 编辑Mar 1, 2017 3:11:53 PM oracle.sysman.emcp.util.OUIInventoryUtil setOUILocCONFIG: Setting oracle.installer.oui_loc to /home/oracle/app/oracle/product/11.2.0/dbhome_1/...
oracle em重建
06-18
【Oracle EM重建】是指在Oracle 11g R2环境中，由于各种原因（如系统故障、硬件更换或软件升级）导致企业管理器（Enterprise Manager，简称EM）无法正常工作时，需要进行的一系列恢复操作。Oracle EM是Oracle数据库...
oracle 11g em重建报唯一约束错误解决方法
09-11
然而，有时在尝试重建EM配置时，可能会遇到一个特定的错误，即“ORA-00001: unique constraint (SYSMAN.PARAMETERS_PRIMARY_KEY) violated”。这个错误表明在尝试插入数据到SYSMAN.PARAMETERS表时违反了唯一性约束，...
oracle重建EM
08-01
这时，你需要使用EM Configuration Assistant (EMCA)来重新创建仓库（-repos recreate）和配置数据库控制（-config dbcontrol db）。在命令行中，先设置环境变量`oracle_sid`，例如`set oracle_sid=ora10g`，然后...
Oracle OEM 配置报错: No value was set for the parameter DBCONTROL_HTTP_PORT 解决方法
ijavagos
09-26 295
这几天经常与OEM 顶上，前几天刚解决一个OEM问题，今天又遇到了。 Oracle 安装OEM 报错: 无法对所有EM 相关账户解锁 解决方法 http://blog.csdn.net/tianlesoftware/article/details/6816938 原打算安装一下Oracle 11gR2. 然后升级到11.2..0.3的，结果安装最后报错。 EM 搞不定。 准备看一下EM...
oracle重建EM资料库详细步骤,EM资料库重建手动删除资料库
weixin_29007135的博客
04-11 374
由于原来的数据库已经被删除，再重做oem时需要用到监听，此时直接重做报如下错误：由于原来的数据库已经被删除，再重做oem时需要用到监听，此时直接重做报如下错误：[Oracle@localhost ~]$ emca -repos recreateJul 30, 2014 7:15:53 PM oracle.sysman.emcp.EMReposConfig dropRepositoryINFO: D...
关于emca创建EM时的DBSNMP用户与SYSMAN用户问题
还不算晕的专栏
11-18 7647
手工建库完成后，数据库中默认只有以下账户：手工建库步骤参考：http://blog.csdn.net/q947817003/article/details/16337611 SQL> show user USER is "SYSTEM" SQL> select username,account_status from dba_users; USERNAME
oracle安装报错emca,EMCA 不能正确安装或者删除EM
weixin_42520656的博客
04-04 504
Dropping EM users ...Drop EM Users. Return code = 0.Done.Dropping Repos User ... Drop Repos User. Return code =0.Done.Dropping Roles/Synonymns/Tablespaces ... Return code =0.Done.Dropping Repository f...
Oracle 创建新的数据库出现EM配置失败的解决办法
weixin_30604651的博客
07-12 2080
Oracle中在创建新的数据库时出现EM配置失败的问题 解决办法：删除原来的EM资料档案库，重新创建新的EM资料档案库并重新配置，配置成功即可解决。具体流程：windows+R打开cmd命令行，在命令行中依次输入下面的指令（注意：cmd要用管理员身份打开，指令运行时间又可能比较久，但是一定要运行完才可以执行下一条）1、emca -deconfig dbcontrol db 用于删除dbcon...
评论
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

当前余额3.43元 前往充值 >
需支付：10.00元
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付元
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明：

1.余额是钱包充值的虚拟货币，按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载，可以购买VIP、付费专栏及课程。

余额充值