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; “
- 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;”
Now, you can re-run the DB config tool safely.