再建 oracle em

原创 2011年01月08日 12:37:00

先 看一下:oracle_home:

 

echo $ORACLE_HOSTNAME
hgpsfesvc

 

在看一下hostname

 

echo $hostname
hgpsfe01

 

看刚才报错:是configuration, 触发问题,所以考虑 修改/etc/hosts

 

vi /etc/hosts

43.82.201.176 hgpsfesvc  hgpsfe_svc

 

在这个ip 后 的hostname 中再加上 hgpsfe01

 

43.82.201.176 hgpsfesvc hgpsfe01 hgpsfe_svc

 

发现 还是配置有问题。

 

再想: 加上 127.0.0.1

 

127.0.0.1 hgpsfesvc hgpsfe01 hgpsfe_svc

报存后,再 建:


oracle@hgpsfe01:/oracle$ export ORACLE_HOSTNAME=hgpsfe01
oracle@hgpsfe01:/oracle$ emca -config dbcontrol db -repos recreate                               

STARTED EMCA at Jan 7, 2011 5:49:46 PM
EM Configuration Assistant, Version 11.2.0.0.2 Production
Copyright (c) 2003, 2005, Oracle.  All rights reserved.

Enter the following information:
Database SID: sfe
Listener port number: 1521
Listener ORACLE_HOME [ /oracle/app/oracle/product/11g/db ]:
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 ................ /oracle/app/oracle/product/11g/db

Local hostname ................ hgpsfe01
Listener ORACLE_HOME ................ /oracle/app/oracle/product/11g/db
Listener port number ................ 1521
Database SID ................ sfe
Email address for notifications ...............
Outgoing Mail (SMTP) server for notifications ...............

-----------------------------------------------------------------
Do you wish to continue? [yes(Y)/no(N)]: Y
Jan 7, 2011 5:50:18 PM oracle.sysman.emcp.EMConfig perform
INFO: This operation is being logged at /oracle/app/oracle/cfgtoollogs/emca/sfe/emca_2011_01_07_17_49_46.log.
Jan 7, 2011 5:50:20 PM oracle.sysman.emcp.EMReposConfig invoke
INFO: Dropping the EM repository (this may take a while) ...
Jan 7, 2011 5:53:10 PM oracle.sysman.emcp.EMReposConfig invoke
INFO: Repository successfully dropped
Jan 7, 2011 5:53:10 PM oracle.sysman.emcp.EMReposConfig createRepository
INFO: Creating the EM repository (this may take a while) ...
Jan 7, 2011 6:03:14 PM oracle.sysman.emcp.EMReposConfig invoke
INFO: Repository successfully created
Jan 7, 2011 6:03:19 PM oracle.sysman.emcp.EMReposConfig uploadConfigDataToRepository
INFO: Uploading configuration data to EM repository (this may take a while) ...
Jan 7, 2011 6:04:48 PM oracle.sysman.emcp.EMReposConfig invoke
INFO: Uploaded configuration data successfully
Jan 7, 2011 6:04:52 PM oracle.sysman.emcp.util.DBControlUtil configureSoftwareLib
INFO: Software library configured successfully.
Jan 7, 2011 6:04:52 PM oracle.sysman.emcp.EMDBPostConfig configureSoftwareLibrary
INFO: Deploying Provisioning archives ...
Jan 7, 2011 6:05:37 PM oracle.sysman.emcp.EMDBPostConfig configureSoftwareLibrary
INFO: Provisioning archives deployed successfully.
Jan 7, 2011 6:05:37 PM oracle.sysman.emcp.util.DBControlUtil secureDBConsole
INFO: Securing Database Control (this may take a while) ...
Jan 7, 2011 6:06:57 PM oracle.sysman.emcp.util.PlatformInterface executeCommand
WARNING: Error executing /oracle/app/oracle/product/11g/db/bin/emctl secure dbconsole -host hgpsfe01 -sid sfe
Jan 7, 2011 6:06:57 PM oracle.sysman.emcp.EMDBPostConfig performConfiguration
WARNING: Error securing Database control.
Jan 7, 2011 6:06:57 PM oracle.sysman.emcp.EMDBPostConfig setWarnMsg
INFO: Error securing Database Control, Database Control has been brought up in non-secure mode. To secure the Database Control execute the following command(s):
 
 1) Set the environment variable ORACLE_SID to sfe
 2) /oracle/app/oracle/product/11g/db/bin/emctl stop dbconsole
 3) /oracle/app/oracle/product/11g/db/bin/emctl config emkey -repos -sysman_pwd < Password for SYSMAN user > 
 4) /oracle/app/oracle/product/11g/db/bin/emctl secure dbconsole -sysman_pwd < Password for SYSMAN user > 
 5) /oracle/app/oracle/product/11g/db/bin/emctl start dbconsole
 
 To secure Em Key, run /oracle/app/oracle/product/11g/db/bin/emctl config emkey -remove_from_repos -sysman_pwd < Password for SYSMAN user >
Jan 7, 2011 6:06:57 PM oracle.sysman.emcp.util.DBControlUtil startOMS
INFO: Starting Database Control (this may take a while) ...
Jan 7, 2011 6:08:22 PM oracle.sysman.emcp.EMDBPostConfig performConfiguration
INFO: Database Control started successfully
Jan 7, 2011 6:08:22 PM oracle.sysman.emcp.EMDBPostConfig performConfiguration
INFO: >>>>>>>>>>> The Database Control URL is http://hgpsfe01:1158/em <<<<<<<<<<<


Error securing Database Control, Database Control has been brought up in non-secure mode. To secure the Database Control execute the following command(s):
 
 1) Set the environment variable ORACLE_SID to sfe
 2) /oracle/app/oracle/product/11g/db/bin/emctl stop dbconsole
 3) /oracle/app/oracle/product/11g/db/bin/emctl config emkey -repos -sysman_pwd < Password for SYSMAN user > 
 4) /oracle/app/oracle/product/11g/db/bin/emctl secure dbconsole -sysman_pwd < Password for SYSMAN user > 
 5) /oracle/app/oracle/product/11g/db/bin/emctl start dbconsole
 
 To secure Em Key, run /oracle/app/oracle/product/11g/db/bin/emctl config emkey -remove_from_repos -sysman_pwd < Password for SYSMAN user >
 
 ----
 
 装好之后测试,:https://43.82.201.176:1158/em 打不开。

 

看一下监听:


 root@hgpsfe01:/# netstat -an | grep 1158
tcp        0      0  *.1158                 *.*                    LISTEN
tcp4       0      0  43.82.201.176.44872    43.82.201.176.1158     TIME_WAIT

 

发现是开的,

 后来去 同事看看:用:http://....(不是安全模式)可以打开

http://43.82.201.176:1158/em 成功。

oracle11g重装数据库后em无法访问的解决过程

windows 7 64位环境下在装oracle11g的时候,我把oracle软件和数据库一同在安装过程中给全装上了,后面由于某些需要把数据库删了,然后重新创建一个数据库,这时候发现em登录不了,报“...
  • VagueCoder
  • VagueCoder
  • 2014年07月07日 19:11
  • 1629

启动oracle em命令及操作

启动监听器            [oracle@oracle ~]$ lsnrctl start             启动数据库                  ...
  • chun8416
  • chun8416
  • 2016年06月07日 20:35
  • 2376

Oracle RAC EM工具日常管理

检查em集群配置: emca -displayConfig dbcontrol -cluster  启动em: emctl start dbconsole   关闭em: emctl stop...
  • wdnq1022
  • wdnq1022
  • 2015年12月09日 22:38
  • 592

oracle零碎要点---oracle em的web访问地址忘了

可以查看“D:\oracle\product\10.2.0\db_1\install”下的readme.txt,里面有说明
  • lidew521
  • lidew521
  • 2013年01月20日 22:25
  • 2298

利用 Oracle EM 企业管理器 进行oracle SQL的优化(自动生成索引)

应用情景 项目中有大量的SQL,尤其是涉及到统计报表时,表关联比较多,当初开发建表时也没搞好索引关联的,上线后发现查询很低。Oracle自带的EM控制台带有自动优化功能,能给出优化方案,本人主要利用...
  • binyao02123202
  • binyao02123202
  • 2014年02月17日 07:21
  • 4737

Oracle 11g EM删除重建的方法

虚拟机里的Oracle 11g好长时间没用了,突然打开之后发现EM无法访问了,之前知道EM可以重建,于是也不查找原因了,直接使大招 …… emca -deconfig dbcontrol db -re...
  • mycdsnstudy
  • mycdsnstudy
  • 2015年09月20日 21:20
  • 6133

linux中oracle数据库|监听|EM的开启和关闭shell脚本

linux和win下的oracle不同、开机后不能直接使用 经过一段时间摸索、终于大体摸清了linux下oracle的数据库启动流程 所以自己动手写了几个shell脚本、省的每次都要输一堆命令来启...
  • Listener_ri
  • Listener_ri
  • 2015年04月18日 00:57
  • 1741

Oracle Em的端口规则

今天实验了一下 Oracle Em的端口,规则如下: 第一个实例默认端口是1158, 第二个实例是5500,因为5500,已经被抢占了。 后面依次是5501,5502..........
  • huang_xw
  • huang_xw
  • 2013年10月13日 11:13
  • 4739

oracle EM 监控邮件提醒

   一、配置系统参数   1、查看自动任务相关参数,是否有值。   SQL> show parameter job_queue_processes;   NAME     ...
  • zhengwei125
  • zhengwei125
  • 2015年06月16日 17:18
  • 1230

Oracle EM 备份

环境:windows+oracle10g使用EM备份数据库->维护->调度备份设置备份策略与目标后 输入主机身份证明:用户名,密码出现如下错误....错误 - 以用户 liuxin 的身份连接 主机 ...
  • ligaoyang
  • ligaoyang
  • 2011年06月03日 13:51
  • 1911
内容举报
返回顶部
收藏助手
不良信息举报
您举报文章:再建 oracle em
举报原因:
原因补充:

(最多只允许输入30个字)