After patch_weblogic.sh, while updating theOES Policies error

After patch_weblogic.sh,

while updating OES policies, i stuck with an error:

According to post installation steps of Patch 12790893

 [java] Exception in thread "Main Thread" java.sql.SQLException: Listener refused the connection with the following error:
     [java] ORA-12514, TNS:listener does not currently know of service requested in connect descriptor
     [java]
     [java]     at oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:419)
     [java]     at oracle.jdbc.driver.PhysicalConnection.(PhysicalConnection.java:538)
     [java]     at oracle.jdbc.driver.T4CConnection.(T4CConnection.java:228)
     [java]     at oracle.jdbc.driver.T4CDriverExtension.getConnection(T4CDriverExtension.java:32)
     [java]     at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:521)
     [java]     at java.sql.DriverManager.getConnection(DriverManager.java:582)
     [java]     at java.sql.DriverManager.getConnection(DriverManager.java:185)
     [java]     at oracle.iam.authzpolicydefn.loader.PolicyLoader.getDbConn(PolicyLoader.java:437)
     [java]     at oracle.iam.authzpolicydefn.loader.PolicyLoader.loadPolicies(PolicyLoader.java:84)
     [java]     at oracle.iam.authzpolicydefn.loader.PolicyLoader.main(PolicyLoader.java:201)
     [java] Caused by: oracle.net.ns.NetException: Listener refused the connection with the following error:
     [java] ORA-12514, TNS:listener does not currently know of service requested in connect descriptor
     [java]
     [java]     at oracle.net.ns.NSProtocol.connect(NSProtocol.java:394)
     [java]     at oracle.jdbc.driver.T4CConnection.connect(T4CConnection.java:1056)
     [java]     at oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:308)
     [java]     ... 9 more

BUILD FAILED
/stagefusion/FMW/iam/server/setup/deploy-files/setup.xml:98: The following error occurred while executing this line:
/stagefusion/FMW/iam/server/seed_data/seed-rcu-data.xml:135: Java returned: 1

correct the entry insteadfroom


/stagefusion/FMW/modules/org.apache.ant_1.7.1/bin/ant -f setup.xml upgrade-oes-ootb-policies -DoperationsDB.user=XXX -DOIM.DBPassword=XXX -DoperationsDB.driver=oracle.jdbc.xa.client.OracleXADataSource -DoperationsDB.host=fusionapp -DoperationsDB.port=1521 -DoperationsDB.SID=(SID) -Dpolicy.dir=/stagefusion/FMW/iam/temp -Dupdate.flag=true -Dweblogic.server.dir=/stagefusion/FMW/wlserver_10.3

 to
 
/stagefusion/FMW/modules/org.apache.ant_1.7.1/bin/ant -f setup.xml upgrade-oes-ootb-policies -DoperationsDB.user=XXX -DOIM.DBPassword=XXX -DoperationsDB.driver=oracle.jdbc.xa.client.OracleXADataSource -DoperationsDB.host=fusionapp -DoperationsDB.port=1521 -DoperationsDB.serviceName=(Sid.Domain.name) -Dpolicy.dir=/stagefusion/FMW/iam/temp -Dupdate.flag=true -Dweblogic.server.dir=/stagefusion/FMW/wlserver_10.3

It should complete without error:

upgrade-oes-ootb-policies:
    [input] skipping input as property OIM.DBPassword has already been set.

upgrade-oes-ootb-policies:
     [echo]  ----> UPDATING OUT OF THE BOX OES POLICIES
     [java] [EL Info]: 2012-09-06 10:44:21.649--ServerSession(140431094)--EclipseLink, version: Eclipse Persistence Services - 1.1.0.r3634
     [java] [EL Info]: 2012-09-06 10:44:23.224--ServerSession(140431094)--file:/stagefusion/FMW/iam/modules/oracle.oes_11.1.1/jps-internal.jar-JpsDBDataManager login successful
     [echo] ----> SEEDING COMPLETE LOG FILE
     [echo] ----> LOG FILE : /stagefusion/FMW/iam/temp/log

BUILD SUCCESSFUL
Total time: 21 seconds
 
 Cheers!!!

SEVERE: OIM Authenticator [user weblogic soft locked]

When trying to configure OIM, we found the error at the Admin server log, that

[2012-09-05T10:09:15.851+05:30] [AdminServer] [ERROR] [] [OIM Authenticator] [tid: [ACTIVE].ExecuteThread: '1' for queue: 'weblogic.kernel.Default (self-tuning)'] [userId: weblogic] [ecid: 670d968dbdc0c587:6b822dff:13991dc167d:-8000-00000000000009a6,0] User weblogic soft locked
[2012-09-05T10:14:15.934+05:30] [AdminServer] [ERROR] [] [OIM Authenticator] [tid: ExecuteThread: '3' for queue: 'weblogic.socket.Muxer'] [userId: ] [ecid: 670d968dbdc0c587:6b822dff:13991dc167d:-8000-000000000000002a,0] User weblogic soft locked
[2012-09-05T10:14:15.949+05:30] [AdminServer] [ERROR] [] [OIM Authenticator] [tid: ExecuteThread: '2' for queue: 'weblogic.socket.Muxer'] [userId: ] [ecid: 670d968dbdc0c587:6b822dff:13991dc167d:-8000-000000000000000f,0] User weblogic soft locked
[2012-09-05T10:14:15.961+05:30] [AdminServer] [ERROR] [] [OIM Authenticator] [tid: [ACTIVE].ExecuteThread: '1' for queue: 'weblogic.kernel.Default (self-tuning)'] [userId: weblogic] [ecid: 670d968dbdc0c587:6b822dff:13991dc167d:-8000-00000000000009b5,0] User weblogic soft locked
[2012-09-05T10:17:47.549+05:30] [AdminServer] [ERROR] [] [OIM Authenticator] [tid: [ACTIVE].ExecuteThread: '1' for queue: 'weblogic.kernel.Default (self-tuning)'] [userId: ] [ecid: 670d968dbdc0c587:6b822dff:13991dc167d:-8000-00000000000009d2,0] [APP: consoleapp] User weblogic soft locked


Fix:

Stop all the servers including Adminserver.

Connect with OIM Schema to the database in my case it was DEV1_OIM

query usr table

and you can find the USR_LAST_NAME (WEBLOGIC) is locked.

Manually update the column

like

update DEV1_OIM.usr set USR_LOCKED=0 where USR_LAST_NAME='WEBLOGIC'

update DEV1_OIM.usr set  USR_LOGIN_ATTEMPTS_CTR=0 where USR_LAST_NAME='WEBLOGIC'

update DEV1_OIM.usr set USR_LOCKED_ON = null where USR_LAST_NAME='WEBLOGIC'

And restart Admin server.

Cheers!!!