Re-install ALES Schema
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.
About the Author Mahendra
I am engulfed in Oracle Identity & Access Management domain. I have expertise on providing the optimized solutions for user provisioning, web access management, Single Sign-On and federation capabilities etc., I am also well versed with complex integrations within Identity Management and other product domains. I have expertise on building demos and implementation experience on products Oracle Access Manager, Oracle Adaptive Access Manager, Oracle Entitlement Server, Oracle Virtual Directory, Oracle Internet Directory etc., Look @ my blog: http://talkidentity.blogspot.com