ORA-01436: CONNECT BY loop in user data

1)  Error in Logs: java.sql.SQLException: ORA-01436: CONNECT BY loop in user data

Run the following query to check the cycle:

select parent_key, act_key, level, connect_by_iscycle
from act
connect by NOCYCLE prior act_key=parent_key;

In case that PARENT_KEY is equal with the ACT_KEY of an organization, that data should be corrected.

Scripts for OIM Cleanup tmp cache and startup the servers

Scripts for OIM Cleanup tmp cache and startup the servers

 

 

vi cleanup.sh
#!/bin/bash
#Admin Server Cleanup
cd /opt/oracle/apps/OIM_Config/domains/OIG_Domain/servers/AdminServer
tar -cf tmp-`date +%F`.tar tmp/
tar -cf cache-`date +%F`.tar cache/
rm -rf tmp/ cache/
find /opt/oracle/apps/OIM_Config/domains/OIG_Domain/servers/AdminServer -iname "*.tar" -type f ! -newermt `date +%Y%m%d -d "20 days ago"` -delete
echo Admin Cleaned

#OIM Managed Server Cleanup
cd /opt/oracle/apps/OIM_Config/domains/OIG_Domain/servers/oim_server1
tar -cf tmp-`date +%F`.tar tmp/
tar -cf cache-`date +%F`.tar cache/
rm -rf tmp/ cache/
find /opt/oracle/apps/OIM_Config/domains/OIG_Domain/servers/oim_server1 -iname "*.tar" -type f ! -newermt `date +%Y%m%d -d "20 days ago"` -delete
echo OIM Server1 cleaned

#SOA Managed Server Cleanup
cd /opt/oracle/apps/OIM_Config/domains/OIG_Domain/servers/soa_server1
tar -cf tmp-`date +%F`.tar tmp/
tar -cf cache-`date +%F`.tar cache/
rm -rf tmp/ cache/
find /opt/oracle/apps/OIM_Config/domains/OIG_Domain/servers/soa_server1 -iname "*.tar" -type f ! -newermt `date +%Y%m%d -d "20 days ago"` -delete
echo SOA Server1 cleaned


#Re-starting NodeManager
kill -9 $(lsof -t -i:5556)
cd /opt/oracle/apps/OIM_Config/domains/OIG_Domain/bin/
nohup ./startNodeManager.sh > node.out &
echo Starting Nodemanager Now

#Starting OIM Admin Server
cd /opt/oracle/apps/OIM_Config/domains/OIG_Domain/bin/
nohup ./startWebLogic.sh > admin.out &
echo Starting OIM Admin Server Now
#IF a schema validation error happens on ADMIN server start use below:
#nohup ./startWebLogic.sh  -Dweblogic.configuration.schemaValidationEnabled=false > admin.out &