Home > Oracle > Drop sysman user in 11gr2

Drop sysman user in 11gr2

If your listener is running under a cluster alias  instead of the hostname then you need to use

ORACLE_HOME/sysman/admin/emdrep/bin/RepManager host 1521 SID -action drop

instead of emca -deconfig dbcontrol db -repos drop

oracle@paramount:/home/oracle > $ORACLE_HOME/sysman/admin/emdrep/bin/RepManager topgun_dbset2.xxx-group.com 1521 dbapbr -action drop
Enter SYS user's password :
Enter repository user name : SYSMAN
Getting temporary tablespace from database...
Found temporary tablespace: TEMP
Checking SYS Credentials ... rem error switch
rem error switch
Dropping the repository..
Checking for Repos User ... Exists.
Repos User exists..
Clearing EM Contexts ... OK.
Dropping EM users ...
Dropping Repos User ... Done.
Dropping Roles/Synonymns/Tablespaces ... Done.
Dropped Repository Successfully.

Categories: Oracle
  1. No comments yet.
  1. No trackbacks yet.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )


Connecting to %s

%d bloggers like this: