Nethence Newdoc Olddoc Lab Your IP BBDock  

Warning: those guides are mostly obsolete, please have a look at the new documentation.


Oracle Enterprise Manager installation
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: //
Oracle Enterprise Manager 10g is not running.
then EM is already installed, you just have to start it,
emctl start dbconsole
Make sur you got the passwords for those schemas,
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,
change this line,
l_host_name VARCHAR2(32);
l_host_name VARCHAR2(40);
Note. *** at two places in the script ***
Create repo
. 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: //

(obsolete, see the new doc)