Thursday, January 7, 2010

Uninstall ALES Schema or Re-running DB Config tool



          As we know that it is pretty straight forward to create the ALES schema using DB Config tool. I am writing here something which is not documented anywhere as to how to re-run the DB config tool if wrong values are specified for oes username or password etc.,
               Here are the steps to be followed to revert and re-run the DB config tool. This assumes that the user created is oesdbuser while running the dbconfig tool.

  1. Connet to sqlplus as sys user.
  2. Execute the command "revoke asi_role from oesdbuser; "
  3. Execute the command Execute the command "drop user oesdbuser cascade; "
  4. Execute the command "revoke create trigger from asi_role;"
  5. Execute the command "revoke create sequence from asi_role;"
  6. Execute the command "revoke create table from asi_role;"
  7. Execute the command "revoke create session from asi_role;"
  8. Execute the command "drop tablespace ales_oracle including contents and datafiles;" 
Now, you can re-run the DB config tool safely.

No comments:

Post a Comment