Drop sysman manually
· Step 1. Check and drop the existing OEM dbconsole repository if exist. SQL Select username from dba_users where username='SYSMAN'; USERNAME SYSMAN. The sysman user exists now drop the repository. · Step 1: Drop AQ related objects in the SYSMAN schema Logon SQLPLUS as user SYS SQL exec DBMS_www.doorway.ru_QUEUE_TABLE Step 2: Drop the DB Control Repository ObjectsEstimated Reading Time: 1 min. · EXECUTE IMMEDIATE 'DROP SYNONYM '||www.doorway.ru||'.'||www.doorway.ru; END IF; END LOOP; END; Drop role mgmt_user and users mgmt_view, sysman with cascade option. Once users are dropped we can disable restricted session. This will lift an instance from restricted mode to normal. DROP ROLE mgmt_user; DROP user mgmt_view cascade;.
Manually drop and create Oracle Enterprise Manager 11g repos DROP user sysman cascade; ALTER SYSTEM DISABLE RESTRICTED SESSION; Make sure SYSMAN is dropped successfully. select username, account_status, created from dba_users where username in ('SYSMAN');. 4. Change the Windows hostname by navigating: Start Control Panel System (classic view) from the random assignment of VMWare Fusion. 5. Reboot the machine to set the networking. Unlock the SYSMAN account because it ensures that emca can drop it and all dependencies. Then, drop the em configuration with the following commands. SQL DROP USER sysman CASCADE; SQL ALTER SYSTEM DISABLE RESTRICTED SESSION; Note: The above will completely delete the DB Control repository from the database; under certain circumstances (e.g. you want to recreate the repository later on) the following statements may be sufficient to remove the repository.
EXECUTE IMMEDIATE 'DROP SYNONYM '||www.doorway.ru||'.'||www.doorway.ru; END IF; END LOOP; END; Drop role mgmt_user and users mgmt_view, sysman with cascade option. Once users are dropped we can disable restricted session. This will lift an instance from restricted mode to normal. DROP ROLE mgmt_user; DROP user mgmt_view cascade;. The followed to drop, create, de config and re create emca for 11G R2 single instance or RAC. I have tried./bin/emca -config dbcontrol db -repos drop to drop enterprise manager repository objects, but it got hung at some point. Finally, I have tried the manual drop option which is very simple and you are almost sure that it will work!. Step 1: Drop AQ related objects in the SYSMAN schema Logon SQLPLUS as user SYS SQL exec DBMS_www.doorway.ru_QUEUE_TABLE Step 2: Drop the DB Control Repository Objects.
0コメント