Oracle Enterprise Manager installation

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 ***

Ref. davidalejomarcos.wordpress.com/category/grid-control/

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