Troubleshooting tips during Oracle Access management installation
Hi all, I like to share some troubleshooting tips during Oracle Access management installation.
Environment Details [oracle@hostname ~]$ uname -aLinux hostname 2.6.18-128.el5PAE #1 SMP Wed Dec 17 12:02:33 EST 2008 i686 i686 i386 GNU/Linux
We have installed the base version of osinfra application server (version : 101401) and then we applied osinfra patch(p7215628_101430_LINUX).
1. After the patch applied we tried to restart the osinfra services. OID and OC4J services came up smoothly but HTTP_SERVER not coming up.
Cause: Library file (Libdb.so.2) is missing under /usr/lib folder.
Solution:
Run the following command as ‘root’ user:
ln -s /usr/lib/libgdbm.so.2.0.0 /usr/lib/libdb.so.2
2. Password randomization failed for schema WKPROXY due to java.sql.SQLException: ORA-01045: user WKPROXY lacks CREATE SESSION privilege; logon denied
Retry the tool after correcting the underlying problem Specific problems could be any one of the following :
1. The OracleAS Internet Directory may be down
2. The OracleAS Metadata Repository database may be downEnd output from spawned process.———————————-
Solution:
Give a user the CREATE SESSION privilege; you can use the GRANT command. Login into sqlplus and execute following
SQL> grant create session to WKPROXY;
Grant succeeded.
SQL>
3. Osinfra application installed successfully and after we tried to start the services. OC4J and OID services not coming up.
Cause: OID unable to connect DB server.
Solution:
Verify the tnsnames.ora file values like SID, DB ip.
About the Author sarath
An Oracle Identity and Access Management professional, having working on Oracle Access Manager Single Sign-On implementations, Installation/Configuration of Identity Server, Web Pass, Web Gate, Access Gate, Policy Manager, Access Server, Policy Domains, Authentication /Authorization schemes, Single Sign-On (single and multi-domain), OIM, OVD, OID, OAAM, OIF, High Availability/Failover/ SSL deployment.