Step 1: Set the SID in the dos prompt and Login to DB using sys user.
Step2: Check the parameter JOB_QUEUE_PROCESSES value in Database the value should be greater then 0.
Alter system set JOB_QUEUE_PROCESSES=1 scope=both or scope=pfile;
Step3: Execute following drop statements
drop user sysman cascade;
drop public synonym SETEMVIEWUSERCONTEXT;
drop role MGMT_USER;
drop PUBLIC SYNONYM MGMT_TARGET_BLACKOUTS;
drop user MGMT_VIEW;
Alter user DBSNMP IDENTIFIED BY DBSNMP;
NOTE:
All the dropped objects will be recreated while creating the Repository.
Step4: Unlock the DBSNMP User using the Query
Alter user DBSNMP ACCOUNT UNLOCK;
Step5: Exit SQL Prompt then execute the command
emca -config dbcontrol db -repos create
Configure the required fields properly.
Login as SYSMAN/SYSMAN
Friday, April 3, 2009
Oracle EM configuration
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment