Find hung transactions in Database

Find hung transactions in Database during two phase commit

Database: Oracle
Version: 11g

When using two phase commit involved in an application feature, to find out the hung transactions in Oracle database following query can be used:
select * from dba_2pc_pending;

This should display the list of hung transactions with all the particular details including the calling client/user and other details.

Reset SVN (Subversion) account information in JDeveloper

Once the account info (username, password or repository url) is set in JDeveloper, SVN (subversion) plugin its hard to change any of these using jDeveloper.

Here is how these can be changed:

1. Save your data and close JDeveloper
2. Find the repositories.xml file, normally it is located in user's home directory and in following subdirectory: 
     .jdeveloper/system11.1.1.6.38.61.92/o.jdeveloper.subversion
3. Rename the file repositories.xml to repositories.xml.bak
4. Open JDeveloper and try to checkout a file, it will ask you to enter the account information again.
5. Enter the updated account info, test access and you are done!

Find out if database sessions are locked

To Check if there is any database session locked

SELECT s1.username || '@' || s1.machine
    || ' ( SID=' || s1.sid || ' )  is blocking '
    || s2.username || '@' || s2.machine || ' ( SID=' || s2.sid || ' ) ' AS blocking_status
    FROM v$lock l1, v$session s1, v$lock l2, v$session s2
    WHERE s1.sid=l1.sid AND s2.sid=l2.sid
    AND l1.BLOCK=1 AND l2.request > 0
    AND l1.id1 = l2.id1
    AND l2.id2 = l2.id2 ;

select * from v$lock
select * from v$session

Display the session count, max sessions, highwater etc.
select sessions_max, sessions_current, sessions_highwater from v$license;

Oracle sample queries

Sample Oracle queries run on 11g (and 10g comparisons)

Query to display stored procedures:
select OBJECT_NAME from user_procedures
select OBJECT_NAME from user_objects where object_type = 'PROCEDURE'
both returns list of stored procedures
"select OBJECT_NAME from user_procedures" returns the stored procedures and triggers as well for Oracle 11g while
"select OBJECT_NAME from user_objects where object_type = 'PROCEDURE'" returns list of stored procedures only

select * from user_sequences
select * from user_objects where object_type = 'SEQUENCE'

select * from user_tables
select * from user_objects where object_type = 'TABLE'

select * from user_triggers
select * from user_objects where object_type = 'TRIGGER'

select * from user_indexes in 10g returns the LOB as well
select * from user_objects where object_type = 'INDEX'

Display all the roles, previleges, tables
select * from user_tab_privs order by grantee, table_name

Display all the synonyms for the table owner
SELECT * FROM all_synonyms where table_owner = 'XYZ' order by owner, synonym_name;

Select from a table and concat two or more columns
SELECT column1_name || ' # ' || column2_name  as column_both FROM table_name

Grant Privileges on tables/sequences to a role
grant select/insert/update/delete on [Schema].[Table/Sequence] to [Role_Name];

Create public synonyms for table, views, sequences

Create public synonyms for table, views, sequences for the schema XYZSchema


declare
  CURSOR xcur is
    select object_name, object_type from all_objects
where object_type IN ('TABLE', 'VIEW', 'SEQUENCE')
and owner = 'XYZSchema'
     ;

    xdat xcur%ROWTYPE;

begin
  for xdat in xcur loop
    begin
      execute immediate 'create or replace public synonym '|| xdat.object_name || ' for XYZSchema.'||xdat.object_name;
    exception when others
     then null;
    end;
   end loop;
 end;
/

ORA-00600 weblogic.security.spi.ResourceCreationException

While starting the server for portal application in 10.3.2 version it throw ORA-00600 errors:

####<9-Oct-2011 12:38:18 PM PST> <[ACTIVE] ExecuteThread: '0' for queue: 'weblogic.kernel.Default (self-tuning)'> <> <> <> <1318354698189>
####<9-Oct-2011 12:38:18 PM PST> <[ACTIVE] ExecuteThread: '0' for queue: 'weblogic.kernel.Default (self-tuning)'> <> <> <> <1318354698191> , application=consoleapp, contextPath=/console, uri=/.
weblogic.security.service.ResourceCreationException: weblogic.security.spi.ResourceCreationException: [Security:090310]Failed to create resource
        at com.bea.common.security.internal.service.PolicyDeploymentServiceImpl$DeploymentHandlerImpl.deployPolicy(PolicyDeploymentServiceImpl.java:173)
        at weblogic.security.service.WLSPolicyDeploymentServiceWrapper$DeploymentHandlerImpl.deployPolicy(WLSPolicyDeploymentServiceWrapper.java:85)
        at weblogic.security.service.AuthorizationManager$HandlerAdaptor.deployPolicy(AuthorizationManager.java:707)
        at weblogic.security.service.AuthorizationManager.deployPolicy(AuthorizationManager.java:511)
        at weblogic.servlet.security.internal.ResourceConstraint.deploy(ResourceConstraint.java:108)
        at weblogic.servlet.security.internal.WebAppSecurityWLS.deployPolicies(WebAppSecurityWLS.java:253)
        at weblogic.servlet.security.internal.WebAppSecurity.registerSecurityConstraints(WebAppSecurity.java:140)
        at weblogic.servlet.internal.WebAppServletContext.prepareFromDescriptors(WebAppServletContext.java:1201)
        at weblogic.servlet.internal.WebAppServletContext.prepare(WebAppServletContext.java:1132)
        at weblogic.servlet.internal.HttpServer.doPostContextInit(HttpServer.java:449)
        at weblogic.servlet.internal.HttpServer.loadWebApp(HttpServer.java:424)
        at weblogic.servlet.internal.WebAppModule.registerWebApp(WebAppModule.java:924)
        at weblogic.servlet.internal.WebAppModule.prepare(WebAppModule.java:356)
        at weblogic.application.internal.flow.ScopedModuleDriver.prepare(ScopedModuleDriver.java:180)
        at weblogic.application.internal.flow.ModuleListenerInvoker.prepare(ModuleListenerInvoker.java:199)
        at weblogic.application.internal.flow.DeploymentCallbackFlow$1.next(DeploymentCallbackFlow.java:392)
        at weblogic.application.utils.StateMachineDriver.nextState(StateMachineDriver.java:83)
        at weblogic.application.internal.flow.DeploymentCallbackFlow.prepare(DeploymentCallbackFlow.java:59)
        at weblogic.application.internal.flow.DeploymentCallbackFlow.prepare(DeploymentCallbackFlow.java:45)
        at weblogic.application.internal.BaseDeployment$1.next(BaseDeployment.java:1223)
        at weblogic.application.utils.StateMachineDriver.nextState(StateMachineDriver.java:83)
        at weblogic.application.internal.BaseDeployment.prepare(BaseDeployment.java:367)
        at weblogic.application.internal.EarDeployment.prepare(EarDeployment.java:54)
        at weblogic.application.internal.DeploymentStateChecker.prepare(DeploymentStateChecker.java:154)
        at weblogic.deploy.internal.targetserver.AppContainerInvoker.prepare(AppContainerInvoker.java:60)
        at weblogic.deploy.internal.targetserver.AppDeployment.prepare(AppDeployment.java:141)
        at weblogic.management.deploy.internal.DeploymentAdapter$1.doPrepare(DeploymentAdapter.java:40)
        at weblogic.management.deploy.internal.DeploymentAdapter.prepare(DeploymentAdapter.java:187)
        at weblogic.management.deploy.internal.AppTransition$1.transitionApp(AppTransition.java:22)
        at weblogic.management.deploy.internal.ConfiguredDeployments.transitionApps(ConfiguredDeployments.java:233)
        at weblogic.management.deploy.internal.ConfiguredDeployments.prepare(ConfiguredDeployments.java:166)
        at weblogic.management.deploy.internal.ConfiguredDeployments.deploy(ConfiguredDeployments.java:122)
        at weblogic.management.deploy.internal.DeploymentServerService.resume(DeploymentServerService.java:174)
        at weblogic.management.deploy.internal.DeploymentServerService.start(DeploymentServerService.java:90)
        at weblogic.t3.srvr.SubsystemRequest.run(SubsystemRequest.java:64)
        at weblogic.work.ExecuteThread.execute(ExecuteThread.java:201)
        at weblogic.work.ExecuteThread.run(ExecuteThread.java:173)


Caused By: weblogic.security.spi.ResourceCreationException: [Security:090310]Failed to create resource
        at weblogic.security.providers.xacml.DeployableAuthorizationProviderV2Helper.deployPolicy(DeployableAuthorizationProviderV2Helper.java:115)
        at weblogic.security.providers.xacml.DeployableAuthorizationProviderV2Helper.deployPolicy(DeployableAuthorizationProviderV2Helper.java:166)
        at weblogic.security.providers.xacml.authorization.XACMLAuthorizationProviderImpl.deployPolicy(XACMLAuthorizationProviderImpl.java:281)
        at com.bea.common.security.internal.legacy.service.PolicyDeployerProviderImpl$V2Adapter$DeploymentHandlerImpl.deployPolicy(PolicyDeployerProviderImpl.java:84)
        at com.bea.common.security.internal.service.PolicyDeploymentServiceImpl$DeploymentHandlerImpl.deployPolicy(PolicyDeploymentServiceImpl.java:166)
        at weblogic.security.service.WLSPolicyDeploymentServiceWrapper$DeploymentHandlerImpl.deployPolicy(WLSPolicyDeploymentServiceWrapper.java:85)
        at weblogic.security.service.AuthorizationManager$HandlerAdaptor.deployPolicy(AuthorizationManager.java:708)
        at weblogic.security.service.AuthorizationManager.deployPolicy(AuthorizationManager.java:512)
        at weblogic.servlet.security.internal.ResourceConstraint.deploy(ResourceConstraint.java:108)
        at weblogic.servlet.security.internal.WebAppSecurityWLS.deployPolicies(WebAppSecurityWLS.java:253)
        at weblogic.servlet.security.internal.WebAppSecurity.registerSecurityConstraints(WebAppSecurity.java:140)
        at weblogic.servlet.internal.WebAppServletContext.prepareFromDescriptors(WebAppServletContext.java:1201)
        at weblogic.servlet.internal.WebAppServletContext.prepare(WebAppServletContext.java:1132)
        at weblogic.servlet.internal.HttpServer.doPostContextInit(HttpServer.java:449)
        at weblogic.servlet.internal.HttpServer.loadWebApp(HttpServer.java:424)
        at weblogic.servlet.internal.WebAppModule.registerWebApp(WebAppModule.java:924)
        at weblogic.servlet.internal.WebAppModule.prepare(WebAppModule.java:356)
        at weblogic.application.internal.flow.ScopedModuleDriver.prepare(ScopedModuleDriver.java:180)
        at weblogic.application.internal.flow.ModuleListenerInvoker.prepare(ModuleListenerInvoker.java:199)
        at weblogic.application.internal.flow.DeploymentCallbackFlow$1.next(DeploymentCallbackFlow.java:392)
        at weblogic.application.utils.StateMachineDriver.nextState(StateMachineDriver.java:83)
        at weblogic.application.internal.flow.DeploymentCallbackFlow.prepare(DeploymentCallbackFlow.java:59)
        at weblogic.application.internal.flow.DeploymentCallbackFlow.prepare(DeploymentCallbackFlow.java:45)
        at weblogic.application.internal.BaseDeployment$1.next(BaseDeployment.java:1223)
        at weblogic.application.utils.StateMachineDriver.nextState(StateMachineDriver.java:83)
        at weblogic.application.internal.BaseDeployment.prepare(BaseDeployment.java:367)
        at weblogic.application.internal.EarDeployment.prepare(EarDeployment.java:54)
        at weblogic.application.internal.DeploymentStateChecker.prepare(DeploymentStateChecker.java:154)
        at weblogic.deploy.internal.targetserver.AppContainerInvoker.prepare(AppContainerInvoker.java:60)
        at weblogic.deploy.internal.targetserver.AppDeployment.prepare(AppDeployment.java:141)
        at weblogic.management.deploy.internal.DeploymentAdapter$1.doPrepare(DeploymentAdapter.java:40)
        at weblogic.management.deploy.internal.DeploymentAdapter.prepare(DeploymentAdapter.java:187)
        at weblogic.management.deploy.internal.AppTransition$1.transitionApp(AppTransition.java:22)
        at weblogic.management.deploy.internal.ConfiguredDeployments.transitionApps(ConfiguredDeployments.java:233)
        at weblogic.management.deploy.internal.ConfiguredDeployments.prepare(ConfiguredDeployments.java:166)
        at weblogic.management.deploy.internal.ConfiguredDeployments.deploy(ConfiguredDeployments.java:122)
        at weblogic.management.deploy.internal.DeploymentServerService.resume(DeploymentServerService.java:174)
        at weblogic.management.deploy.internal.DeploymentServerService.start(DeploymentServerService.java:90)
        at weblogic.t3.srvr.SubsystemRequest.run(SubsystemRequest.java:64)
        at weblogic.work.ExecuteThread.execute(ExecuteThread.java:201)
        at weblogic.work.ExecuteThread.run(ExecuteThread.java:173)


Caused By: weblogic.management.utils.CreateException:
        at com.bea.security.providers.xacml.entitlement.PolicyManager.setPolicy(PolicyManager.java:241)
        at com.bea.security.providers.xacml.entitlement.PolicyManager.setPolicy(PolicyManager.java:165)
        at weblogic.security.providers.xacml.DeployableAuthorizationProviderV2Helper.deployPolicy(DeployableAuthorizationProviderV2Helper.java:108)
        at weblogic.security.providers.xacml.DeployableAuthorizationProviderV2Helper.deployPolicy(DeployableAuthorizationProviderV2Helper.java:168)
        at weblogic.security.providers.xacml.authorization.XACMLAuthorizationProviderImpl.deployPolicy(XACMLAuthorizationProviderImpl.java:282)
        at com.bea.common.security.internal.legacy.service.PolicyDeployerProviderImpl$V2Adapter$DeploymentHandlerImpl.deployPolicy(PolicyDeployerProviderImpl.java:85)
        at com.bea.common.security.internal.service.PolicyDeploymentServiceImpl$DeploymentHandlerImpl.deployPolicy(PolicyDeploymentServiceImpl.java:166)
        at weblogic.security.service.WLSPolicyDeploymentServiceWrapper$DeploymentHandlerImpl.deployPolicy(WLSPolicyDeploymentServiceWrapper.java:85)
        at weblogic.security.service.AuthorizationManager$HandlerAdaptor.deployPolicy(AuthorizationManager.java:708)
        at weblogic.security.service.AuthorizationManager.deployPolicy(AuthorizationManager.java:512)
        at weblogic.servlet.security.internal.ResourceConstraint.deploy(ResourceConstraint.java:108)
        at weblogic.servlet.security.internal.WebAppSecurityWLS.deployPolicies(WebAppSecurityWLS.java:253)
        at weblogic.servlet.security.internal.WebAppSecurity.registerSecurityConstraints(WebAppSecurity.java:140)
        at weblogic.servlet.internal.WebAppServletContext.prepareFromDescriptors(WebAppServletContext.java:1201)
        at weblogic.servlet.internal.WebAppServletContext.prepare(WebAppServletContext.java:1132)
        at weblogic.servlet.internal.HttpServer.doPostContextInit(HttpServer.java:449)
        at weblogic.servlet.internal.HttpServer.loadWebApp(HttpServer.java:424)
        at weblogic.servlet.internal.WebAppModule.registerWebApp(WebAppModule.java:924)
        at weblogic.servlet.internal.WebAppModule.prepare(WebAppModule.java:356)
        at weblogic.application.internal.flow.ScopedModuleDriver.prepare(ScopedModuleDriver.java:180)
        at weblogic.application.internal.flow.ModuleListenerInvoker.prepare(ModuleListenerInvoker.java:199)
        at weblogic.application.internal.flow.DeploymentCallbackFlow$1.next(DeploymentCallbackFlow.java:392)
        at weblogic.application.utils.StateMachineDriver.nextState(StateMachineDriver.java:83)
        at weblogic.application.internal.flow.DeploymentCallbackFlow.prepare(DeploymentCallbackFlow.java:59)
        at weblogic.application.internal.flow.DeploymentCallbackFlow.prepare(DeploymentCallbackFlow.java:45)
        at weblogic.application.internal.BaseDeployment$1.next(BaseDeployment.java:1223)
        at weblogic.application.utils.StateMachineDriver.nextState(StateMachineDriver.java:83)
        at weblogic.application.internal.BaseDeployment.prepare(BaseDeployment.java:367)
        at weblogic.application.internal.EarDeployment.prepare(EarDeployment.java:54)
        at weblogic.application.internal.DeploymentStateChecker.prepare(DeploymentStateChecker.java:154)
        at weblogic.deploy.internal.targetserver.AppContainerInvoker.prepare(AppContainerInvoker.java:60)
        at weblogic.deploy.internal.targetserver.AppDeployment.prepare(AppDeployment.java:141)
        at weblogic.management.deploy.internal.DeploymentAdapter$1.doPrepare(DeploymentAdapter.java:40)
        at weblogic.management.deploy.internal.DeploymentAdapter.prepare(DeploymentAdapter.java:187)
        at weblogic.management.deploy.internal.AppTransition$1.transitionApp(AppTransition.java:22)
        at weblogic.management.deploy.internal.ConfiguredDeployments.transitionApps(ConfiguredDeployments.java:233)
        at weblogic.management.deploy.internal.ConfiguredDeployments.prepare(ConfiguredDeployments.java:166)
        at weblogic.management.deploy.internal.ConfiguredDeployments.deploy(ConfiguredDeployments.java:122)
        at weblogic.management.deploy.internal.DeploymentServerService.resume(DeploymentServerService.java:174)
        at weblogic.management.deploy.internal.DeploymentServerService.start(DeploymentServerService.java:90)
        at weblogic.t3.srvr.SubsystemRequest.run(SubsystemRequest.java:64)
        at weblogic.work.ExecuteThread.execute(ExecuteThread.java:201)
        at weblogic.work.ExecuteThread.run(ExecuteThread.java:173)


Caused By: com.bea.security.xacml.PolicyStoreException: kodo.jdo.DataStoreException: ORA-00600: internal error code, arguments: [qsmoAlterPlans:2], [], [], [], [], [], [], [], [], [], [], []
 {prepstmnt 529911478 SELECT t0.DOMN, t0.REALMN, t0.TYPEN, t0.CN, t0.XVER, t0.MTS, t0.CTS, t0.WCN, t0.WCI, t0.WXF, t0.XD, t0.XS FROM BEAXACMLAP t0 WHERE (t0.DOMN = ? AND t0.REALMN = ? AND t0.TYPEN = ? AND t0.CN = ? AND t0.XVER = ?) [params=(String) ptl03_admin, (String) myrealm, (String) Policies, (String) urn:bea:xacml:2.0:entitlement:resource:type@E@Furl@G@M@Oapplication@..., (String) 1.0] [reused=0]} [code=600, state=60000]
        at com.bea.security.providers.xacml.store.BasePolicyStore.setPolicy(BasePolicyStore.java:673)
        at com.bea.security.providers.xacml.store.BasePolicyStore.setPolicy(BasePolicyStore.java:613)
        at com.bea.security.providers.xacml.entitlement.PolicyManager.setPolicy(PolicyManager.java:222)
        at com.bea.security.providers.xacml.entitlement.PolicyManager.setPolicy(PolicyManager.java:166)
        at weblogic.security.providers.xacml.DeployableAuthorizationProviderV2Helper.deployPolicy(DeployableAuthorizationProviderV2Helper.java:110)
        at weblogic.security.providers.xacml.DeployableAuthorizationProviderV2Helper.deployPolicy(DeployableAuthorizationProviderV2Helper.java:168)
        at weblogic.security.providers.xacml.authorization.XACMLAuthorizationProviderImpl.deployPolicy(XACMLAuthorizationProviderImpl.java:282)
        at com.bea.common.security.internal.legacy.service.PolicyDeployerProviderImpl$V2Adapter$DeploymentHandlerImpl.deployPolicy(PolicyDeployerProviderImpl.java:85)
        at com.bea.common.security.internal.service.PolicyDeploymentServiceImpl$DeploymentHandlerImpl.deployPolicy(PolicyDeploymentServiceImpl.java:166)
        at weblogic.security.service.WLSPolicyDeploymentServiceWrapper$DeploymentHandlerImpl.deployPolicy(WLSPolicyDeploymentServiceWrapper.java:85)
        at weblogic.security.service.AuthorizationManager$HandlerAdaptor.deployPolicy(AuthorizationManager.java:708)
        at weblogic.security.service.AuthorizationManager.deployPolicy(AuthorizationManager.java:512)
        at weblogic.servlet.security.internal.ResourceConstraint.deploy(ResourceConstraint.java:108)
        at weblogic.servlet.security.internal.WebAppSecurityWLS.deployPolicies(WebAppSecurityWLS.java:253)
        at weblogic.servlet.security.internal.WebAppSecurity.registerSecurityConstraints(WebAppSecurity.java:140)
        at weblogic.servlet.internal.WebAppServletContext.prepareFromDescriptors(WebAppServletContext.java:1201)
        at weblogic.servlet.internal.WebAppServletContext.prepare(WebAppServletContext.java:1132)
        at weblogic.servlet.internal.HttpServer.doPostContextInit(HttpServer.java:449)
        at weblogic.servlet.internal.HttpServer.loadWebApp(HttpServer.java:424)
        at weblogic.servlet.internal.WebAppModule.registerWebApp(WebAppModule.java:924)
        at weblogic.servlet.internal.WebAppModule.prepare(WebAppModule.java:356)
        at weblogic.application.internal.flow.ScopedModuleDriver.prepare(ScopedModuleDriver.java:180)
        at weblogic.application.internal.flow.ModuleListenerInvoker.prepare(ModuleListenerInvoker.java:199)
        at weblogic.application.internal.flow.DeploymentCallbackFlow$1.next(DeploymentCallbackFlow.java:392)
        at weblogic.application.utils.StateMachineDriver.nextState(StateMachineDriver.java:83)
        at weblogic.application.internal.flow.DeploymentCallbackFlow.prepare(DeploymentCallbackFlow.java:59)
        at weblogic.application.internal.flow.DeploymentCallbackFlow.prepare(DeploymentCallbackFlow.java:45)
        at weblogic.application.internal.BaseDeployment$1.next(BaseDeployment.java:1223)
        at weblogic.application.utils.StateMachineDriver.nextState(StateMachineDriver.java:83)
        at weblogic.application.internal.BaseDeployment.prepare(BaseDeployment.java:367)
        at weblogic.application.internal.EarDeployment.prepare(EarDeployment.java:54)
        at weblogic.application.internal.DeploymentStateChecker.prepare(DeploymentStateChecker.java:154)
        at weblogic.deploy.internal.targetserver.AppContainerInvoker.prepare(AppContainerInvoker.java:60)
        at weblogic.deploy.internal.targetserver.AppDeployment.prepare(AppDeployment.java:141)
        at weblogic.management.deploy.internal.DeploymentAdapter$1.doPrepare(DeploymentAdapter.java:40)
        at weblogic.management.deploy.internal.DeploymentAdapter.prepare(DeploymentAdapter.java:187)
        at weblogic.management.deploy.internal.AppTransition$1.transitionApp(AppTransition.java:22)
        at weblogic.management.deploy.internal.ConfiguredDeployments.transitionApps(ConfiguredDeployments.java:233)
        at weblogic.management.deploy.internal.ConfiguredDeployments.prepare(ConfiguredDeployments.java:166)
        at weblogic.management.deploy.internal.ConfiguredDeployments.deploy(ConfiguredDeployments.java:122)
        at weblogic.management.deploy.internal.DeploymentServerService.resume(DeploymentServerService.java:174)
        at weblogic.management.deploy.internal.DeploymentServerService.start(DeploymentServerService.java:90)
        at weblogic.t3.srvr.SubsystemRequest.run(SubsystemRequest.java:64)
        at weblogic.work.ExecuteThread.execute(ExecuteThread.java:201)
        at weblogic.work.ExecuteThread.run(ExecuteThread.java:173)


Caused By: kodo.jdo.DataStoreException: ORA-00600: internal error code, arguments: [qsmoAlterPlans:2], [], [], [], [], [], [], [], [], [], [], []
 {prepstmnt 529911478 SELECT t0.DOMN, t0.REALMN, t0.TYPEN, t0.CN, t0.XVER, t0.MTS, t0.CTS, t0.WCN, t0.WCI, t0.WXF, t0.XD, t0.XS FROM BEAXACMLAP t0 WHERE (t0.DOMN = ? AND t0.REALMN = ? AND t0.TYPEN = ? AND t0.CN = ? AND t0.XVER = ?) [params=(String) ptl03_admin, (String) myrealm, (String) Policies, (String) urn:bea:xacml:2.0:entitlement:resource:type@E@Furl@G@M@Oapplication@..., (String) 1.0] [reused=0]} [code=600, state=60000]
        at org.apache.openjpa.jdbc.sql.DBDictionary.narrow(DBDictionary.java:4207)
        at org.apache.openjpa.jdbc.sql.DBDictionary.newStoreException(DBDictionary.java:4171)
        at org.apache.openjpa.jdbc.sql.SQLExceptions.getStore(SQLExceptions.java:102)
        at org.apache.openjpa.jdbc.sql.SQLExceptions.getStore(SQLExceptions.java:88)
        at org.apache.openjpa.jdbc.sql.SQLExceptions.getStore(SQLExceptions.java:64)
        at org.apache.openjpa.jdbc.kernel.SelectResultObjectProvider.handleCheckedException(SelectResultObjectProvider.java:155)
        at org.apache.openjpa.lib.rop.EagerResultList.(EagerResultList.java:40)
        at org.apache.openjpa.kernel.QueryImpl.toResult(QueryImpl.java:1222)
        at org.apache.openjpa.kernel.QueryImpl.execute(QueryImpl.java:989)
        at org.apache.openjpa.kernel.QueryImpl.execute(QueryImpl.java:847)
        at org.apache.openjpa.kernel.QueryImpl.execute(QueryImpl.java:778)
        at kodo.kernel.KodoQuery.execute(KodoQuery.java:47)
        at org.apache.openjpa.kernel.DelegatingQuery.execute(DelegatingQuery.java:525)
        at kodo.jdo.QueryImpl.executeWithMap(QueryImpl.java:133)
        at com.bea.common.security.store.data.TopId.getObject(TopId.java:129)
        at com.bea.security.providers.xacml.store.BasePolicyStore.getObjectById(BasePolicyStore.java:260)
        at com.bea.security.providers.xacml.store.BasePolicyStore.getObjectById(BasePolicyStore.java:255)
        at com.bea.security.providers.xacml.store.BasePolicyStore.setPolicy(BasePolicyStore.java:666)
        at com.bea.security.providers.xacml.store.BasePolicyStore.setPolicy(BasePolicyStore.java:612)
        at com.bea.security.providers.xacml.entitlement.PolicyManager.setPolicy(PolicyManager.java:222)
        at com.bea.security.providers.xacml.entitlement.PolicyManager.setPolicy(PolicyManager.java:165)
        at weblogic.security.providers.xacml.DeployableAuthorizationProviderV2Helper.deployPolicy(DeployableAuthorizationProviderV2Helper.java:108)
        at weblogic.security.providers.xacml.DeployableAuthorizationProviderV2Helper.deployPolicy(DeployableAuthorizationProviderV2Helper.java:166)
        at weblogic.security.providers.xacml.authorization.XACMLAuthorizationProviderImpl.deployPolicy(XACMLAuthorizationProviderImpl.java:281)
        at com.bea.common.security.internal.legacy.service.PolicyDeployerProviderImpl$V2Adapter$DeploymentHandlerImpl.deployPolicy(PolicyDeployerProviderImpl.java:84)
        at com.bea.common.security.internal.service.PolicyDeploymentServiceImpl$DeploymentHandlerImpl.deployPolicy(PolicyDeploymentServiceImpl.java:166)
        at weblogic.security.service.WLSPolicyDeploymentServiceWrapper$DeploymentHandlerImpl.deployPolicy(WLSPolicyDeploymentServiceWrapper.java:85)
        at weblogic.security.service.AuthorizationManager$HandlerAdaptor.deployPolicy(AuthorizationManager.java:707)
        at weblogic.security.service.AuthorizationManager.deployPolicy(AuthorizationManager.java:511)
        at weblogic.servlet.security.internal.ResourceConstraint.deploy(ResourceConstraint.java:108)
        at weblogic.servlet.security.internal.WebAppSecurityWLS.deployPolicies(WebAppSecurityWLS.java:253)
        at weblogic.servlet.security.internal.WebAppSecurity.registerSecurityConstraints(WebAppSecurity.java:140)
        at weblogic.servlet.internal.WebAppServletContext.prepareFromDescriptors(WebAppServletContext.java:1199)
        at weblogic.servlet.internal.WebAppServletContext.prepare(WebAppServletContext.java:1131)
        at weblogic.servlet.internal.HttpServer.doPostContextInit(HttpServer.java:449)
        at weblogic.servlet.internal.HttpServer.loadWebApp(HttpServer.java:424)
        at weblogic.servlet.internal.WebAppModule.registerWebApp(WebAppModule.java:924)
        at weblogic.servlet.internal.WebAppModule.prepare(WebAppModule.java:356)
        at weblogic.application.internal.flow.ScopedModuleDriver.prepare(ScopedModuleDriver.java:176)
        at weblogic.application.internal.flow.ModuleListenerInvoker.prepare(ModuleListenerInvoker.java:199)
        at weblogic.application.internal.flow.DeploymentCallbackFlow$1.next(DeploymentCallbackFlow.java:391)
        at weblogic.application.utils.StateMachineDriver.nextState(StateMachineDriver.java:83)
        at weblogic.application.internal.flow.DeploymentCallbackFlow.prepare(DeploymentCallbackFlow.java:59)
        at weblogic.application.internal.flow.DeploymentCallbackFlow.prepare(DeploymentCallbackFlow.java:43)
        at weblogic.application.internal.BaseDeployment$1.next(BaseDeployment.java:1221)
        at weblogic.application.utils.StateMachineDriver.nextState(StateMachineDriver.java:83)
        at weblogic.application.internal.BaseDeployment.prepare(BaseDeployment.java:367)
        at weblogic.application.internal.EarDeployment.prepare(EarDeployment.java:54)
        at weblogic.application.internal.DeploymentStateChecker.prepare(DeploymentStateChecker.java:154)
        at weblogic.deploy.internal.targetserver.AppContainerInvoker.prepare(AppContainerInvoker.java:60)
        at weblogic.deploy.internal.targetserver.AppDeployment.prepare(AppDeployment.java:141)
        at weblogic.management.deploy.internal.DeploymentAdapter$1.doPrepare(DeploymentAdapter.java:39)
        at weblogic.management.deploy.internal.DeploymentAdapter.prepare(DeploymentAdapter.java:187)


Caused By: org.apache.openjpa.lib.jdbc.ReportingSQLException: ORA-00600: internal error code, arguments: [qsmoAlterPlans:2], [], [], [], [], [], [], [], [], [], [], []
 {prepstmnt 529911478 SELECT t0.DOMN, t0.REALMN, t0.TYPEN, t0.CN, t0.XVER, t0.MTS, t0.CTS, t0.WCN, t0.WCI, t0.WXF, t0.XD, t0.XS FROM BEAXACMLAP t0 WHERE (t0.DOMN = ? AND t0.REALMN = ? AND t0.TYPEN = ? AND t0.CN = ? AND t0.XVER = ?) [params=(String) ptl03_admin, (String) myrealm, (String) Policies, (String) urn:bea:xacml:2.0:entitlement:resource:type@E@Furl@G@M@Oapplication@..., (String) 1.0] [reused=0]} [code=600, state=60000]
        at org.apache.openjpa.lib.jdbc.LoggingConnectionDecorator.wrap(LoggingConnectionDecorator.java:192)
        at org.apache.openjpa.lib.jdbc.LoggingConnectionDecorator.access$700(LoggingConnectionDecorator.java:57)
        at org.apache.openjpa.lib.jdbc.LoggingConnectionDecorator$LoggingConnection$LoggingPreparedStatement.executeQuery(LoggingConnectionDecorator.java:852)
        at org.apache.openjpa.lib.jdbc.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:262)
        at org.apache.openjpa.jdbc.kernel.JDBCStoreManager$CancelPreparedStatement.executeQuery(JDBCStoreManager.java:1407)
        at org.apache.openjpa.lib.jdbc.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:252)
        at org.apache.openjpa.jdbc.sql.SelectImpl.executeQuery(SelectImpl.java:452)
        at org.apache.openjpa.jdbc.sql.SelectImpl.execute(SelectImpl.java:363)
        at kodo.jdbc.sql.KodoSelectImpl.execute(KodoSelectImpl.java:28)
        at org.apache.openjpa.jdbc.sql.SelectImpl.execute(SelectImpl.java:331)
        at org.apache.openjpa.jdbc.sql.LogicalUnion$UnionSelect.execute(LogicalUnion.java:407)
        at org.apache.openjpa.jdbc.sql.LogicalUnion.execute(LogicalUnion.java:218)
        at kodo.jdbc.sql.TrueUnion.execute(TrueUnion.java:169)
        at org.apache.openjpa.jdbc.sql.LogicalUnion.execute(LogicalUnion.java:208)
        at org.apache.openjpa.jdbc.kernel.SelectResultObjectProvider.open(SelectResultObjectProvider.java:94)
        at org.apache.openjpa.lib.rop.EagerResultList.(EagerResultList.java:34)
        at org.apache.openjpa.kernel.QueryImpl.toResult(QueryImpl.java:1222)
        at org.apache.openjpa.kernel.QueryImpl.execute(QueryImpl.java:989)
        at org.apache.openjpa.kernel.QueryImpl.execute(QueryImpl.java:847)
        at org.apache.openjpa.kernel.QueryImpl.execute(QueryImpl.java:778)
        at kodo.kernel.KodoQuery.execute(KodoQuery.java:47)
        at org.apache.openjpa.kernel.DelegatingQuery.execute(DelegatingQuery.java:525)
        at kodo.jdo.QueryImpl.executeWithMap(QueryImpl.java:133)
        at com.bea.common.security.store.data.TopId.getObject(TopId.java:129)
        at com.bea.security.providers.xacml.store.BasePolicyStore.getObjectById(BasePolicyStore.java:260)
        at com.bea.security.providers.xacml.store.BasePolicyStore.getObjectById(BasePolicyStore.java:255)
        at com.bea.security.providers.xacml.store.BasePolicyStore.setPolicy(BasePolicyStore.java:666)
        at com.bea.security.providers.xacml.store.BasePolicyStore.setPolicy(BasePolicyStore.java:612)
        at com.bea.security.providers.xacml.entitlement.PolicyManager.setPolicy(PolicyManager.java:222)
        at com.bea.security.providers.xacml.entitlement.PolicyManager.setPolicy(PolicyManager.java:165)
        at weblogic.security.providers.xacml.DeployableAuthorizationProviderV2Helper.deployPolicy(DeployableAuthorizationProviderV2Helper.java:108)
        at weblogic.security.providers.xacml.DeployableAuthorizationProviderV2Helper.deployPolicy(DeployableAuthorizationProviderV2Helper.java:166)
        at weblogic.security.providers.xacml.authorization.XACMLAuthorizationProviderImpl.deployPolicy(XACMLAuthorizationProviderImpl.java:281)
        at com.bea.common.security.internal.legacy.service.PolicyDeployerProviderImpl$V2Adapter$DeploymentHandlerImpl.deployPolicy(PolicyDeployerProviderImpl.java:84)
        at com.bea.common.security.internal.service.PolicyDeploymentServiceImpl$DeploymentHandlerImpl.deployPolicy(PolicyDeploymentServiceImpl.java:166)
        at weblogic.security.service.WLSPolicyDeploymentServiceWrapper$DeploymentHandlerImpl.deployPolicy(WLSPolicyDeploymentServiceWrapper.java:85)
        at weblogic.security.service.AuthorizationManager$HandlerAdaptor.deployPolicy(AuthorizationManager.java:707)
        at weblogic.security.service.AuthorizationManager.deployPolicy(AuthorizationManager.java:511)
        at weblogic.servlet.security.internal.ResourceConstraint.deploy(ResourceConstraint.java:108)
        at weblogic.servlet.security.internal.WebAppSecurityWLS.deployPolicies(WebAppSecurityWLS.java:253)
        at weblogic.servlet.security.internal.WebAppSecurity.registerSecurityConstraints(WebAppSecurity.java:140)
        at weblogic.servlet.internal.WebAppServletContext.prepareFromDescriptors(WebAppServletContext.java:1199)
        at weblogic.servlet.internal.WebAppServletContext.prepare(WebAppServletContext.java:1131)
        at weblogic.servlet.internal.HttpServer.doPostContextInit(HttpServer.java:449)
        at weblogic.servlet.internal.HttpServer.loadWebApp(HttpServer.java:424)
        at weblogic.servlet.internal.WebAppModule.registerWebApp(WebAppModule.java:924)
        at weblogic.servlet.internal.WebAppModule.prepare(WebAppModule.java:356)
        at weblogic.application.internal.flow.ScopedModuleDriver.prepare(ScopedModuleDriver.java:176)
        at weblogic.application.internal.flow.ModuleListenerInvoker.prepare(ModuleListenerInvoker.java:199)
        at weblogic.application.internal.flow.DeploymentCallbackFlow$1.next(DeploymentCallbackFlow.java:391)
        at weblogic.application.utils.StateMachineDriver.nextState(StateMachineDriver.java:83)
        at weblogic.application.internal.flow.DeploymentCallbackFlow.prepare(DeploymentCallbackFlow.java:59)
        at weblogic.application.internal.flow.DeploymentCallbackFlow.prepare(DeploymentCallbackFlow.java:43)

Possible solution:
The oracle driver shipped with Weblogic Portal 10.3.2 is causing this problem. Updating the driver to latest version as of writing this, fixes this problem.
Version shipped with Weblogic Portal 10.3.2 is 11.1.0.7.0
Version tested to fix this problem is 11.2.0.3.0 (or 11.2.0.2.0, not tested)

A small java program can be written to reproduce this ORA-00600 Error as well.