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.
- Connet to sqlplus as sys user.
- Execute the command "revoke asi_role from oesdbuser; "
- Execute the command Execute the command "drop user oesdbuser cascade; "
- Execute the command "revoke create trigger from asi_role;"
- Execute the command "revoke create sequence from asi_role;"
- Execute the command "revoke create table from asi_role;"
- Execute the command "revoke create session from asi_role;"
- Execute the command "drop tablespace ales_oracle including contents and datafiles;"
No comments:
Post a Comment