Nethence Documentation Lab Webmail Your IP BBDock  


Those documents are obsolete, please use the Nethence Documentation instead.

HomeUnixWindowsOracleObsoleteHardwareDIYMechanicsScriptsConfigsPrivate

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. http://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
 

Last update: Feb 17, 2010