Oracle Enterprise Manager installation

最新推荐文章于 2024-11-12 20:35:48 发布

sstevencao

最新推荐文章于 2024-11-12 20:35:48 发布

阅读量81

点赞数

分类专栏： Oracle 文章标签：数据库 php

本文链接：https://blog.csdn.net/sstevencao/article/details/84008846

版权

104 篇文章 0 订阅

订阅专栏

Introduction

Check the state of EM for one precise database,

  . oraenv 

  emctl status dbconsole 

If you got the following error msg,

  OC4J Configuration issue. /u01/product/10.2.0/ora1020/oc4j/j2ee/OC4J_DBConsole_srv1.example.net_dbname not found. 

then you need to create the EM repository,

If you got the following msg,

  https://srv1.example.net:1158/em/console/aboutApplication 

  Oracle Enterprise Manager 10g is not running. 

then EM is already installed, you just have to start it,

  emctl start dbconsole 

Installation

Prerequesties

Make sur you got the passwords for those schemas,

sys

  system 

  sysman 

  dbsnmp 

Hostname length

Note. this paragraph addresses this possible error,

  ORA-06502: PL/SQL: numeric or value error: character string buffer too small 

Before installing the EM repository, check your FQDN isn't to long,

  hostname --fqdn 

  . oraenv 

  sqlplus / as sysdba 

  col host_name for a40 

  select host_name, length(host_name) length from v$instance; 

If the char num for your FQDN is > 32 then you need to modify the repo creation script,

  cd $ORACLE_HOME/sysman/admin/emdrep/sql/core/latest/self_monitor 

  cp self_monitor_post_creation.sql self_monitor_post_creation.sql.dist 

  vi self_monitor_post_creation.sql 

search for,

  l_host_name 

change this line,

  l_host_name VARCHAR2(32); 

to,

  l_host_name VARCHAR2(40); 

Note. *** at two places in the script ***

Create repo

Proceed,

  . oraenv 

  emca -config dbcontrol db -repos create 

  SID: dbname 

  Listener port: 1521 

...

Note. we did -config and -repos at once. It's also possible to proceed step by step,

  #emca -repos create 

  #emca -config dbcontrol db 

Note. to wipe out the repo,

  emca -deconfig dbcontrol db -repos drop 

  #emca -config dbcontrol db -repos recreate 

Access URL

After repo creation, EM is tarted. Check its state and copy/paste the URL into your webbrowser (check name resolution...),

  emctl status dbconsole 

in example,

  https://srv1.example.net:1158/em/console/aboutApplication 

关注

专栏目录