设为首页 收藏本站

运维网

 找回密码
 立即注册
查看: 997|回复: 0

[经验分享] ORACLE 10G 配置OEM/DB CONSOLE

[复制链接]
isgood

尚未签到
发表于 2018-9-25 12:25:30 | 显示全部楼层 |阅读模式
　　下面是测试一下10g中怎么配置DB CONSOLE，EM这个东西平时用得太多了，一点不熟悉
　　测试环境：OS:SOLARIS 10,DB :10.2.0.1
　　1，EMCA创建
　　


  • $ emca -config dbcontrol db -repos create

  • STARTED EMCA at Dec 22, 2012 12:30:09 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: htz
  • 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/product/11.2.0/db_1

  • Database hostname ................ 10rac1
  • Listener port number ................ 1521
  • Database SID ................ htz
  • Email address for notifications ...............
  • Outgoing Mail (SMTP) server for notifications ...............

  • -----------------------------------------------------------------
  • Do you wish to continue? [yes(Y)/no(N)]: Y
  • Dec 22, 2012 12:31:12 PM oracle.sysman.emcp.EMConfig perform
  • INFO: This operation is being logged at /u01/app/oracle/product/11.2.0/db_1/cfgtoollogs/emca/htz/emca_2012-12-22_12-30-09-PM.log.
  • Dec 22, 2012 12:31:13 PM oracle.sysman.emcp.EMReposConfig createRepository
  • INFO: Creating the EM repository (this may take a while) ...
  • Dec 22, 2012 12:31:13 PM oracle.sysman.emcp.EMReposConfig invoke
  • SEVERE: Error creating the repository
  • Dec 22, 2012 12:31:13 PM oracle.sysman.emcp.EMReposConfig invoke
  • INFO: Refer to the log file at /u01/app/oracle/product/11.2.0/db_1/cfgtoollogs/emca/htz/emca_repos_create_.log for more details.
  • Dec 22, 2012 12:31:13 PM oracle.sysman.emcp.EMConfig perform
  • SEVERE: Error creating the repository
  • Refer to the log file at /u01/app/oracle/product/11.2.0/db_1/cfgtoollogs/emca/htz/emca_2012-12-22_12-30-09-PM.log for more details.
  • Could not complete the configuration. Refer to the log file at /u01/app/oracle/product/11.2.0/db_1/cfgtoollogs/emca/htz/emca_2012-12-22_12-30-09-PM.log for more details
　　

　　晕，报错了，数据库是新创建的，查看一下原因。
　　2，日志查看
　　


  • $ cd $ORACLE_HOME/cfgtool*/
  • $ ls
  • cfgfw                  configToolAllCommands  dbca                   emca                   netca                  oui
  • $ cd emca/htz
  • $ vi  emca_2012-12-22_12-30-09-PM.log
  • CONFIG: No value was set for the parameter SYS_PWD.
  • Dec 22, 2012 12:31:01 PM oracle.sysman.emcp.util.GeneralUtil initSQLEngine
  • CONFIG: SQLEngine connecting with SID: htz, oracleHome: /u01/app/oracle/product/11.2.0/db_1, and user:
  • Dec 22, 2012 12:31:01 PM oracle.sysman.emcp.util.GeneralUtil initSQLEngine
  • CONFIG: SQLEngine created successfully and connected
  • Dec 22, 2012 12:31:01 PM oracle.sysman.emcp.ParamsManager setFlag
  • CONFIG: Flag 'asm_db' set to false
  • Dec 22, 2012 12:31:01 PM oracle.sysman.emcp.ParamsManager setFlag
  • CONFIG: Flag 'asm_db' set to false
  • Dec 22, 2012 12:31:03 PM oracle.sysman.emcp.ParamsManager setParam
  • CONFIG: Setting param: PORT value: 1521
  • Dec 22, 2012 12:31:05 PM oracle.sysman.emcp.ParamsManager getParam
  • CONFIG: No value was set for the parameter SYS_PWD.
  • Dec 22, 2012 12:31:05 PM oracle.sysman.emcp.util.GeneralUtil initSQLEngine
  • CONFIG: SQLEngine connecting with SID: htz, oracleHome: /u01/app/oracle/product/11.2.0/db_1, and user: SYS
  • Dec 22, 2012 12:31:05 PM oracle.sysman.emcp.util.GeneralUtil initSQLEngine
  • CONFIG: SQLEngine created successfully and connected
  • "emca_2012-12-22_12-30-09-PM.log" 370 lines, 26004 characters
  •         at oracle.sysman.assistants.util.sqlEngine.SQLEngine.executeScript(SQLEngine.java:841)
  •         at oracle.sysman.assistants.util.sqlEngine.SQLPlusEngine.executeScript(SQLPlusEngine.java:265)
  •         at oracle.sysman.assistants.util.sqlEngine.SQLPlusEngine.executeScript(SQLPlusEngine.java:306)
  •         at oracle.sysman.emcp.EMReposConfig.createRepository(EMReposConfig.java:360)
  •         at oracle.sysman.emcp.EMReposConfig.invoke(EMReposConfig.java:182)
  •         at oracle.sysman.emcp.EMReposConfig.invoke(EMReposConfig.java:124)
  •         at oracle.sysman.emcp.EMConfig.perform(EMConfig.java:142)
  •         at oracle.sysman.emcp.EMConfigAssistant.invokeEMCA(EMConfigAssistant.java:479)
  •         at oracle.sysman.emcp.EMConfigAssistant.performConfiguration(EMConfigAssistant.java:1123)
  •         at oracle.sysman.emcp.EMConfigAssistant.statusMain(EMConfigAssistant.java:463)
  •         at oracle.sysman.emcp.EMConfigAssistant.main(EMConfigAssistant.java:412)
  • Dec 22, 2012 12:31:13 PM oracle.sysman.emcp.EMReposConfig invoke
  • SEVERE: Error creating the repository
  • Dec 22, 2012 12:31:13 PM oracle.sysman.emcp.EMReposConfig invoke
  • INFO: Refer to the log file at /u01/app/oracle/product/11.2.0/db_1/cfgtoollogs/emca/htz/emca_repos_create_.log for more details.
  • Dec 22, 2012 12:31:13 PM oracle.sysman.emcp.EMConfig perform
  • SEVERE: Error creating the repository
  • Refer to the log file at /u01/app/oracle/product/11.2.0/db_1/cfgtoollogs/emca/htz/emca_2012-12-22_12-30-09-PM.log for more details.
  • Dec 22, 2012 12:31:13 PM oracle.sysman.emcp.EMConfig perform
  • CONFIG: Stack Trace:
  • oracle.sysman.emcp.exception.EMConfigException: Error creating the repository
  •         at oracle.sysman.emcp.EMReposConfig.invoke(EMReposConfig.java:194)
  •         at oracle.sysman.emcp.EMReposConfig.invoke(EMReposConfig.java:124)
  •         at oracle.sysman.emcp.EMConfig.perform(EMConfig.java:142)
  •         at oracle.sysman.emcp.EMConfigAssistant.invokeEMCA(EMConfigAssistant.java:479)
  •         at oracle.sysman.emcp.EMConfigAssistant.performConfiguration(EMConfigAssistant.java:1123)
  •         at oracle.sysman.emcp.EMConfigAssistant.statusMain(EMConfigAssistant.java:463)
  •         at oracle.sysman.emcp.EMConfigAssistant.main(EMConfigAssistant.java:412)

  • 再看另一个日志

  • $ vi  emca_repos_create_2012-12-22_12-31-13-PM.log
  • "emca_repos_create_2012-12-22_12-31-13-PM.log" 21 lines, 911 characters

  • Check if repos user already exists.

  • old   6:    WHERE username=UPPER('&EM_REPOS_USER');
  • new   6:    WHERE username=UPPER('SYSMAN');
  • old   8:   IF ( '&EM_CHECK_TYPE' = 'EXISTS') THEN
  • new   8:   IF ( 'NOT_EXISTS' = 'EXISTS') THEN
  • old  11:       raise_application_error(-20000, '&EM_REPOS_USER does not exists..');
  • new  11:       raise_application_error(-20000, 'SYSMAN does not exists..');
  • old  14:   ELSIF ( '&EM_CHECK_TYPE' = 'NOT_EXISTS' ) THEN
  • new  14:   ELSIF ( 'NOT_EXISTS' = 'NOT_EXISTS' ) THEN
  • old  17:       raise_application_error(-20001, '&EM_REPOS_USER already exists..');
  • new  17:       raise_application_error(-20001, 'SYSMAN already exists..');
  • old  21:       raise_application_error(-20002, 'Invalid Check type &EM_CHECK_TYPE');
  • new  21:       raise_application_error(-20002, 'Invalid Check type NOT_EXISTS');
  • DECLARE
  • *
  • ERROR at line 1:
  • ORA-20001: SYSMAN already exists..
  • ORA-06512: at line 17

  • 报用户已经存在，原来没有创建过EM，DBCA创建数据库的时候也没有勾上。
　　

　　3，删除相关的用户
　　


  • $ sqlplus / as sysdba

  • SQL*Plus: Release 10.2.0.1.0 - Production on Sat Dec 22 12:35:14 2012

  • Copyright (c) 1982, 2005, Oracle.  All rights reserved.


  • Connected to:
  • Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production
  • With the Partitioning, OLAP and Data Mining options

  • SQL> drop user sysman cascade;

  • User dropped.

  • SQL> drop role MGMT_USER;

  • Role dropped.

  • SQL> drop user MGMT_VIEW cascade;

  • User dropped.

  • SQL> drop public synonym MGMT_TARGET_BLACKOUTS;

  • Synonym dropped.

  • SQL> drop public synonym SETEMVIEWUSERCONTEXT;

  • Synonym dropped.
　　

　　4，再次测试DB CONSOLE
　　


  • $ emca -config dbcontrol db -repos create

  • STARTED EMCA at Dec 22, 2012 12:38:06 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: htz
  • 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/product/11.2.0/db_1

  • Database hostname ................ 10rac1
  • Listener port number ................ 1521
  • Database SID ................ htz
  • Email address for notifications ...............
  • Outgoing Mail (SMTP) server for notifications ...............

  • -----------------------------------------------------------------
  • Do you wish to continue? [yes(Y)/no(N)]: Y
  • Dec 22, 2012 12:38:18 PM oracle.sysman.emcp.EMConfig perform
  • INFO: This operation is being logged at /u01/app/oracle/product/11.2.0/db_1/cfgtoollogs/emca/htz/emca_2012-12-22_12-38-06-PM.log.
  • Dec 22, 2012 12:38:18 PM oracle.sysman.emcp.EMReposConfig createRepository
  • INFO: Creating the EM repository (this may take a while) ...
  •         Dec 22, 2012 12:39:55 PM oracle.sysman.emcp.EMReposConfig invoke
  • INFO: Repository successfully created
  • Dec 22, 2012 12:39:57 PM oracle.sysman.emcp.util.DBControlUtil startOMS
  • INFO: Starting Database Control (this may take a while) ...
  • Dec 22, 2012 12:41:31 PM oracle.sysman.emcp.EMDBPostConfig performConfiguration
  • INFO: Database Control started successfully
  • Dec 22, 2012 12:41:31 PM oracle.sysman.emcp.EMDBPostConfig performConfiguration
  • INFO: >>>>>>>>>>> The Database Control URL is http://10rac1:1158/em

运维网声明 1、欢迎大家加入本站运维交流群:群②:261659950 群⑤:202807635 群⑦870801961 群⑧679858003
2、本站所有主题由该帖子作者发表，该帖子作者与运维网享有帖子相关版权
3、所有作品的著作权均归原作者享有，请您和我们一样尊重他人的著作权等合法权益。如果您对作品感到满意，请购买正版
4、禁止制作、复制、发布和传播具有反动、淫秽、色情、暴力、凶杀等内容的信息，一经发现立即删除。若您因此触犯法律，一切后果自负，我们对此不承担任何责任
5、所有资源均系网友上传或者通过网络收集，我们仅提供一个展示、介绍、观摩学习的平台，我们不对其内容的准确性、可靠性、正当性、安全性、合法性等负责，亦不承担任何法律责任
6、所有作品仅供您个人学习、研究或欣赏，不得用于商业或者其他用途，否则，一切后果均由您自己承担，我们对此不承担任何法律责任
7、如涉及侵犯版权等问题，请您及时通知我们，我们将立即采取措施予以解决
8、联系人Email：admin@iyunv.com 网址：www.yunweiku.com

所有资源均系网友上传或者通过网络收集,我们仅提供一个展示、介绍、观摩学习的平台,我们不对其承担任何法律责任,如涉及侵犯版权等问题,请您及时通知我们,我们将立即处理,联系人Email:kefu@iyunv.com,QQ:1061981298 本贴地址：https://www.yunweiku.com/thread-601823-1-1.html 上篇帖子： IMP-00017: following statement failed with ORACLE error 1 下篇帖子： oracle上安装Java库出现的问题及解决
回复

使用道具 举报

返回列表
高级模式
B Color Image Link Quote Code Smilies
您需要登录后才可以回帖 登录 | 立即注册

本版积分规则

扫码加入运维网微信交流群X

扫码加入运维网微信交流群

扫描二维码加入运维网微信交流群，最新一手资源尽在官方微信交流群！快快加入我们吧...

扫描微信二维码查看详情

客服 E-mail:iyunvcom@gmail.com

本站由青云提供云计算服务

运维网--中国最专业的运维工程师交流社区

豫ICP备20007574号-1 Copyright © 2012-2025

关于我们

发展历程

联系我们

关注我们

广告服务

广告案例

隐私条款

免责声明

用户登录

用户注册

版主守则

申请版主

手机版

金币获取

帮助中心

每日签到

Good Good

Study

Day Day

UP


客服E-mail:kefu@iyunv.com 客服QQ：1061981298


QQ群⑦：运维网交流群⑦ QQ群⑧：运维网交流群⑧ k8s群：运维网kubernetes交流群


提醒：禁止发布任何违反国家法律、法规的言论与图片等内容；本站内容均来自个人观点与网络等信息，非本站认同之观点.


本站大部分资源是网友从网上搜集分享而来，其版权均归原作者及其网站所有，我们尊重他人的合法权益，如有内容侵犯您的合法权益，请及时与我们联系进行核实删除！



合作伙伴: 青云cloud

快速回复 返回顶部 返回列表