Step to
Reconfig Oracle Enterprise Manager (10.2.0.4)
Solution
1 (Drop and Recreate EM)
Step 1)
Manual Drop Repository
1.1)
Login to Unix Server
UNIX>
su – oracle
1.2)
Set ORACLE_SID
UNIX> export ORACLE_SID=<Your SID>
1.3) Login
to database
UNIX> sqlplus / as sysdba
1.4) Check
dbname is correct ? (must be same as <Your SID>)
SQL> select name from v$database;
1.5) Run
script below this step not put database to quiesce mode
(Reference Oracle
Doc id : 278100.1)
|
DECLARE
CURSOR c1 IS
SELECT owner ,
synonym_name name
FROM dba_synonyms
WHERE table_owner =
'SYSMAN';
BEGIN
FOR r 1 IN c1 LOOP
IF r1.owner = 'PU
BLIC' THEN
EXECUTE IMMEDIATE
'DROP PUB LIC SYNONYM '||r1.name;
ELSE
EXEC UTE IMMEDIATE
'DROP SYNONYM '||r1.owner||'.'||r1.name;
END IF;
END LOO P;
END;
/
DROP USER mgmt_view
CASCADE;
DROP ROLE mgmt_user;
DROP USER sysman CASCADE;
|
1.6) Delete folder that contain old EM file (If it
existing)
UNIX> cd $ORACLE_HOME
UNIX>
rm –rf <hostname>_<sid>
UNIX>
cd $ORACLE_HOME/oc4j/j2ee
UNIX>
rm –rf OC4J_DBConsole_<hostname>_<sid>
***Be careful do
not remove OC4J_DBConsole please specify host and sid
Step 2) Create EM
2.1) Check
Parameter ORACLE_HOSTNAME
UNIX>
echo $ORACLE_HOSTNAME
(If have any value at this parameter need unset, run step below)
UNIX>
unset ORACLE_HOSTNAME
2.2)
Check ORACLE_HOME
UNIX> echo $ORACLE_HOME
2.3)
Check database instance port
UNIX> ps –ef|grep lsnr
UNIX> lsnrctl status <Your listener name>
2.4)
Check ORACLE_SID
UNIX> echo $ORACLE_SID
2.4)
Create new EM
UNIX> emca -config dbcontrol db -repos create -SID <Your SID>
-PORT <Your db port> -ORACLE_HOME <Your oracle home>
***This step
need old SYS,DBSNMP password and new SYSMAN password
Option
1) Stop oracle EM
UNIX> emctl stop dbconsole
Option
2) Check emagent process need to kill if it avaliable
UNIX> ps –ef|grep emagent
Option
3) Kill oracle em console by using script in patch 8350262 (patch can apply all
platform)
Step 3)
Verify oracle EM Status to confirm it is running
UNIX>
emctl status dbconsole
***Remark : Oracle version 10g status may be show as not running.
Step 4)
Open web browser and test login
https://<Your IP Address>:<Your
port>/em/console/aboutApplication
====== If solution 1 not work with you
Solution 2 (Edit sysman library)
Step 1)
Stop oracle EM
UNIX> emctl stop dbconsole
Step
2) Check emagent process need to kill if it avaliable
UNIX>
ps –ef|grep emagent
Step
3) Make a copy of $ORACLE_HOME/sysman/lib/env_sysman.mk file
UNIX> cd $ORACLE_HOME/sysman/lib
UNIX>
cp –p env_sysman.mk BAK_env_sysman.mk
Step
4) Edit the script $ORACLE_HOME/sysman/lib/env_sysman.mk file
4.1) Search for the section having
"MK_EMDW_LIBNMEMSO_SHLIB"
4.2)
Replace the line
$(LIBNMEM) $(LIBNMER) \
with
$(LIBNMEM) $(LIBNMER) $(LIBNMO) \
Step
5) Perform the following relink
UNIX> cd $ORACLE_HOME/sysman/lib
UNIX>
make -f ins_sysman.mk agent
***This will not affect the other database components as only the
agent is being relinked.
(Reference Oracle Doc id : 437417.1)
Step
6) Follow all step on solution 1
====== If solution 1 and 2 not work with
you ======
Solution 3 (Apply interim patch)
Step 1)
Stop oracle EM
UNIX> emctl stop dbconsole
Step
2) Check emagent process need to kill if it avaliable
UNIX>
ps –ef|grep emagent
Step
3) To patch sysman library by opatch number 8350262 (patch can apply all
platform)
Patch
Installation Steps
3.1)
Shutdown EM DB Console using the following command
UNIX>
$ORACLE_HOME/bin/emctl
stop dbconsole
3.2)
Set your current directory to the directory where the patch is located
UNIX>
cd
<PATCH_TOP>/8350262
3.3)
Apply patch
UNIX>
$ORACLE_HOME/OPatch/opatch
apply
3.4) Verify patch that apply to your
db_home
UNIX> $ORACLE_HOME/OPatch/opatch
lsinventory
Step 4)
Follow all step on solution 1
