WLS AdminServer Startup Failed with ORA-00942 (Oracle Access Manager Domain) (Doc ID 2180643.1)

Last updated on MARCH 08, 2017

Applies to:

Oracle Access Manager - Version 11.1.2.2.0 and later
Information in this document applies to any platform.

Symptoms

OAM Domain AdminServer Startup Failed with ORA-00942

At this time, weblogic console log displayed the following message.

 $ ./startWebLogic.sh

CLASSPATH=/opt/app/work/share/oam/patch_wls1036/profiles/default/sys_manifest_classpath/weblogic_patch.jar:/opt/app/work/share/oam/patch_ocp371/profiles/default/sys_manifest_classpath/weblogic_patch.jar:/usr/java/jdk1.7.0_80/lib/tools.jar:/opt/app/work/share/oam/wlserver_10.3/server/lib/weblogic_sp.jar:/opt/app/work/share/oam/wlserver_10.3/server/lib/weblogic.jar:/opt/app/work/share/oam/modules/features/weblogic.server.modules_10.3.6.0.jar:/opt/app/work/share/oam/wlserver_10.3/server/lib/webservices.jar:/opt/app/work/share/oam/modules/org.apache.ant_1.7.1/lib/ant-all.jar:/opt/app/work/share/oam/modules/net.sf.antcontrib_1.1.0.0_1-0b2/lib/ant-contrib.jar::/opt/app/work/share/oam/oracle_common/modules/oracle.jrf_11.1.1/jrf-wlstman.jar:/opt/app/work/share/oam/oracle_common/common/wlst/lib/adf-share-mbeans-wlst.jar:/opt/app/work/share/oam/oracle_common/common/wlst/lib/adfscripting.jar:/opt/app/work/share/oam/oracle_common/common/wlst/lib/mdswlst.jar:/opt/app/work/share/oam/oracle_common/common/wlst/resources/auditwlst.jar:/opt/app/work/share/oam/oracle_common/common/wlst/resources/igfwlsthelp.jar:/opt/app/work/share/oam/oracle_common/common/wlst/resources/jps-wls-trustprovider.jar:/opt/app/work/share/oam/oracle_common/common/wlst/resources/jps-wlst.jar:/opt/app/work/share/oam/oracle_common/common/wlst/resources/jrf-wlst.jar:/opt/app/work/share/oam/oracle_common/common/wlst/resources/oamAuthnProvider.jar:/opt/app/work/share/oam/oracle_common/common/wlst/resources/oamap_help.jar:/opt/app/work/share/oam/oracle_common/common/wlst/resources/ossoiap.jar:/opt/app/work/share/oam/oracle_common/common/wlst/resources/ossoiap_help.jar:/opt/app/work/share/oam/oracle_common/common/wlst/resources/ovdwlsthelp.jar:/opt/app/work/share/oam/oracle_common/common/wlst/resources/sslconfigwlst.jar:/opt/app/work/share/oam/oracle_common/common/wlst/resources/wsm-wlst.jar:/opt/app/work/share/oam/utils/config/10.3/config-launch.jar::/opt/app/work/share/oam/wlserver_10.3/common/derby/lib/derbynet.jar:/opt/app/work/share/oam/wlserver_10.3/common/derby/lib/derbyclient.jar:/opt/app/work/share/oam/wlserver_10.3/common/derby/lib/derbytools.jar::

Initializing WebLogic Scripting Tool (WLST) ...

Welcome to WebLogic Server Administration Scripting Shell

Type help() for help on available commands

Info: Data source is: opss-DBDS
INFO: Found persistence provider "org.eclipse.persistence.jpa.PersistenceProvider". OpenJPA will not be used.
WLS ManagedService is not up running. Fall back to use system properties for configuration.
Info: Diagnostics data was saved to the credential store.
Info: Validate operation has completed successfully.
.
.
JAVA Memory arguments: -Xms256m -Xmx512m  -XX:MaxPermSize=512m
.
WLS Start Mode=Production
.
CLASSPATH=/opt/app/work/share/oam/oracle_common/modules/oracle.jdbc_11.1.1/ojdbc6dms.jar::/opt/app/work/share/oam/Oracle_OAM1/oam/server/policy/sts-policies.jar:/opt/app/work/share/oam/patch_wls1036/profiles/default/sys_manifest_classpath/weblogic_patch.jar:/opt/app/work/share/oam/patch_ocp371/profiles/default/sys_manifest_classpath/weblogic_patch.jar:/usr/java/jdk1.7.0_80/lib/tools.jar:/opt/app/work/share/oam/wlserver_10.3/server/lib/weblogic_sp.jar:/opt/app/work/share/oam/wlserver_10.3/server/lib/weblogic.jar:/opt/app/work/share/oam/modules/features/weblogic.server.modules_10.3.6.0.jar:/opt/app/work/share/oam/wlserver_10.3/server/lib/webservices.jar:/opt/app/work/share/oam/modules/org.apache.ant_1.7.1/lib/ant-all.jar:/opt/app/work/share/oam/modules/net.sf.antcontrib_1.1.0.0_1-0b2/lib/ant-contrib.jar:/opt/app/work/share/oam/Oracle_OAM1/oam/agent/modules/oracle.oam.wlsagent_11.1.1/oam-wlsagent.jar:/opt/app/work/share/oam/oracle_common/modules/oracle.jrf_11.1.1/jrf.jar:/opt/app/work/share/oam/wlserver_10.3/common/derby/lib/derbyclient.jar:/opt/app/work/share/oam/wlserver_10.3/server/lib/xqrl.jar
.
PATH=/opt/app/work/share/oam/wlserver_10.3/server/bin:/opt/app/work/share/oam/modules/org.apache.ant_1.7.1/bin:/usr/java/jdk1.7.0_80/jre/bin:/usr/java/jdk1.7.0_80/bin:/opt/app/work/share/db/12.1.0/dbhome_1/bin:/usr/lib64/qt-3.3/bin:/usr/local/bin:/bin:/usr/bin:/usr/local/sbin:/usr/sbin:/sbin:/sbin:/usr/sbin:/usr/local/sbin
.
***************************************************
*  To start WebLogic Server, use a username and   *
*  password assigned to an admin-level user.  For *
*  server administration, use the WebLogic Server *
*  console at http://hostname:port/console        *
***************************************************
starting weblogic with Java version:
java version "1.7.0_80"
Java(TM) SE Runtime Environment (build 1.7.0_80-b15)
Java HotSpot(TM) 64-Bit Server VM (build 24.80-b11, mixed mode)
Starting WLS with line:
/usr/java/jdk1.7.0_80/bin/java -server   -Xms256m -Xmx512m  -XX:MaxPermSize=512m -Dweblogic.Name=AdminServer -Djava.security.policy=/opt/app/work/share/oam/wlserver_10.3/server/lib/weblogic.policy  -Dweblogic.ProductionModeEnabled=true   -da -Dplatform.home=/opt/app/work/share/oam/wlserver_10.3 -Dwls.home=/opt/app/work/share/oam/wlserver_10.3/server -Dweblogic.home=/opt/app/work/share/oam/wlserver_10.3/server  -Dcommon.components.home=/opt/app/work/share/oam/oracle_common -Djrf.version=11.1.1 -Dorg.apache.commons.logging.Log=org.apache.commons.logging.impl.Jdk14Logger -Ddomain.home=/opt/app/work/share/oam/user_projects/domains/oam_domain -Djrockit.optfile=/opt/app/work/share/oam/oracle_common/modules/oracle.jrf_11.1.1/jrocket_optfile.txt -Doracle.server.config.dir=/opt/app/work/share/oam/user_projects/domains/oam_domain/config/fmwconfig/servers/AdminServer -Doracle.domain.config.dir=/opt/app/work/share/oam/user_projects/domains/oam_domain/config/fmwconfig  -Digf.arisidbeans.carmlloc=/opt/app/work/share/oam/user_projects/domains/oam_domain/config/fmwconfig/carml  -Digf.arisidstack.home=/opt/app/work/share/oam/user_projects/domains/oam_domain/config/fmwconfig/arisidprovider -Doracle.security.jps.config=/opt/app/work/share/oam/user_projects/domains/oam_domain/config/fmwconfig/jps-config.xml -Doracle.deployed.app.dir=/opt/app/work/share/oam/user_projects/domains/oam_domain/servers/AdminServer/tmp/_WL_user -Doracle.deployed.app.ext=/- -Dweblogic.alternateTypesDirectory=/opt/app/work/share/oam/Oracle_OAM1/oam/agent/modules/oracle.oam.wlsagent_11.1.1,/opt/app/work/share/oam/oracle_common/modules/oracle.ossoiap_11.1.1,/opt/app/work/share/oam/oracle_common/modules/oracle.oamprovider_11.1.1,/opt/app/work/share/oam/oracle_common/modules/oracle.jps_11.1.1 -Djava.protocol.handler.pkgs=oracle.mds.net.protocol  -Dweblogic.jdbc.remoteEnabled=false  -Doracle.idm.ipf.home=/opt/app/work/share/oam/Oracle_OAM1//modules/oracle.idm.ipf_11.1.2  -DCONFIG_DS=jdbc/oamds -DCONFIG_HISTORY=true -Doam.oes.new=true -DOAM_POLICY_FILE=/opt/app/work/share/oam/user_projects/domains/oam_domain/config/fmwconfig/oam-policy.xml -DOAM_CONFIG_FILE=/opt/app/work/share/oam/user_projects/domains/oam_domain/config/fmwconfig/oam-config.xml -DOAM_ORACLE_HOME=/opt/app/work/share/oam/Oracle_OAM1/oam -Doracle.security.am.SERVER_INSTNCE_NAME=AdminServer -Does.jars.home=/opt/app/work/share/oam/Oracle_OAM1/oam/server/lib/oes-d8 -Does.integration.path=/opt/app/work/share/oam/Oracle_OAM1/oam/server/lib/oeslib/oes-integration.jar -Does.enabled=true  -Djavax.xml.soap.SOAPConnectionFactory=weblogic.wsee.saaj.SOAPConnectionFactoryImpl -Djavax.xml.soap.MessageFactory=oracle.j2ee.ws.saaj.soap.MessageFactoryImpl -Djavax.xml.soap.SOAPFactory=oracle.j2ee.ws.saaj.soap.SOAPFactoryImpl  -Dweblogic.management.discover=true  -Dwlw.iterativeDev=false -Dwlw.testConsole=false -Dwlw.logErrorsToConsole=false -Dweblogic.ext.dirs=/opt/app/work/share/oam/patch_wls1036/profiles/default/sysext_manifest_classpath:/opt/app/work/share/oam/patch_ocp371/profiles/default/sysext_manifest_classpath  weblogic.Server
<Sep 5, 2016 6:16:51 PM JST> <Info> <Security> <BEA-090905> <Disabling CryptoJ JCE Provider self-integrity check for better startup performance. To enable this check, specify -Dweblogic.security.allowCryptoJDefaultJCEVerification=true>
<Sep 5, 2016 6:16:51 PM JST> <Info> <Security> <BEA-090906> <Changing the default Random Number Generator in RSA CryptoJ from ECDRBG to FIPS186PRNG. To disable this change, specify -Dweblogic.security.allowCryptoJDefaultPRNG=true>
<Sep 5, 2016 6:16:51 PM JST> <Info> <WebLogicServer> <BEA-000377> <Starting WebLogic Server with Java HotSpot(TM) 64-Bit Server VM Version 24.80-b11 from Oracle Corporation>
<Sep 5, 2016 6:16:52 PM JST> <Info> <Management> <BEA-141107> <Version: WebLogic Server 10.3.6.0  Tue Nov 15 08:52:36 PST 2011 1441050 >
<Sep 5, 2016 6:16:54 PM JST> <Info> <Security> <BEA-090065> <Getting boot identity from user.>
Enter username to boot WebLogic server:weblogic
Enter password to boot WebLogic server:
<Sep 5, 2016 6:17:06 PM JST> <Notice> <WebLogicServer> <BEA-000365> <Server state changed to STARTING>
<Sep 5, 2016 6:17:06 PM JST> <Info> <WorkManager> <BEA-002900> <Initializing self-tuning thread pool>
<Sep 5, 2016 6:17:06 PM JST> <Notice> <Log Management> <BEA-170019> <The server log file /opt/app/work/share/oam/user_projects/domains/oam_domain/servers/AdminServer/logs/AdminServer.log is opened. All server side log events will be written to this file.>
INFO: Found persistence provider "org.eclipse.persistence.jpa.PersistenceProvider". OpenJPA will not be used.
INFO: Found persistence provider "org.eclipse.persistence.jpa.PersistenceProvider". OpenJPA will not be used.
Sep 05, 2016 6:17:14 PM oracle.security.jps.az.internal.runtime.pd.register.PDPRegister run
INFO: PDP registration succeeded.
Sep 05, 2016 6:17:15 PM oracle.security.am.common.aaaclient.ObAAAServiceClient sendMessage
SEVERE: Failed to communicate with any of configured Access Server, ensure that it is up and running.
<Sep 5, 2016 6:17:17 PM JST> <Warning> <Security> <BEA-090076> <A failure occurred attempting to load LDIF for provider Authorizer from file /opt/app/work/share/oam/wlserver_10.3/server/lib/XACMLAuthorizerInit.ldift.>
<Sep 5, 2016 6:17:17 PM JST> <Error> <Security> <BEA-090870> <The realm "myrealm" failed to be loaded: weblogic.security.service.SecurityServiceException: com.bea.common.engine.ServiceInitializationException: weblogic.security.spi.ProviderInitializationException: A failure occurred attempting to load LDIF for provider Authorizer from file /opt/app/work/share/oam/wlserver_10.3/server/lib/XACMLAuthorizerInit.ldift..
weblogic.security.service.SecurityServiceException: com.bea.common.engine.ServiceInitializationException: weblogic.security.spi.ProviderInitializationException: A failure occurred attempting to load LDIF for provider Authorizer from file /opt/app/work/share/oam/wlserver_10.3/server/lib/XACMLAuthorizerInit.ldift.
        at weblogic.security.service.CommonSecurityServiceManagerDelegateImpl.initializeRealm(CommonSecurityServiceManagerDelegateImpl.java:466)
        at weblogic.security.service.CommonSecurityServiceManagerDelegateImpl.loadRealm(CommonSecurityServiceManagerDelegateImpl.java:841)
        at weblogic.security.service.CommonSecurityServiceManagerDelegateImpl.initializeRealms(CommonSecurityServiceManagerDelegateImpl.java:870)
        at weblogic.security.service.CommonSecurityServiceManagerDelegateImpl.initialize(CommonSecurityServiceManagerDelegateImpl.java:1032)
        at weblogic.security.service.SecurityServiceManager.initialize(SecurityServiceManager.java:873)
        Truncated. see log file for complete stacktrace
Caused By: com.bea.common.engine.ServiceInitializationException: weblogic.security.spi.ProviderInitializationException: A failure occurred attempting to load LDIF for provider Authorizer from file /opt/app/work/share/oam/wlserver_10.3/server/lib/XACMLAuthorizerInit.ldift.
        at com.bea.common.engine.internal.ServiceEngineImpl.findOrStartService(ServiceEngineImpl.java:365)
        at com.bea.common.engine.internal.ServiceEngineImpl.findOrStartService(ServiceEngineImpl.java:315)
        at com.bea.common.engine.internal.ServiceEngineImpl.lookupService(ServiceEngineImpl.java:257)
        at com.bea.common.engine.internal.ServicesImpl.getService(ServicesImpl.java:72)
        at weblogic.security.service.CSSWLSDelegateImpl.getService(CSSWLSDelegateImpl.java:155)
        Truncated. see log file for complete stacktrace
Caused By: weblogic.security.spi.ProviderInitializationException: A failure occurred attempting to load LDIF for provider Authorizer from file /opt/app/work/share/oam/wlserver_10.3/server/lib/XACMLAuthorizerInit.ldift.
        at com.bea.common.store.bootstrap.internal.BootStrapServiceImpl.loadFullLDIFTemplate(BootStrapServiceImpl.java:910)
        at com.bea.common.store.bootstrap.internal.BootStrapServiceImpl.loadLDIFTemplate(BootStrapServiceImpl.java:688)
        at com.bea.common.store.bootstrap.internal.BootStrapServiceImpl.loadLDIFXACMLAuthorizerTemplate(BootStrapServiceImpl.java:176)
        at com.bea.common.store.bootstrap.internal.BootStrapServiceImpl.loadLDIFXACMLAuthorizerTemplate(BootStrapServiceImpl.java:160)
        at com.bea.common.security.internal.service.BootStrapServiceImpl.loadLDIFXACMLAuthorizerTemplate(BootStrapServiceImpl.java:106)
        Truncated. see log file for complete stacktrace
Caused By: <openjpa-1.1.1-SNAPSHOT-r422266:1172209 fatal store error> kodo.jdo.FatalDataStoreException: The transaction has been rolled back.  See the nested exceptions for details on the errors that occurred.
        at org.apache.openjpa.kernel.BrokerImpl.newFlushException(BrokerImpl.java:2170)
        at org.apache.openjpa.kernel.BrokerImpl.flush(BrokerImpl.java:2017)
        at org.apache.openjpa.kernel.BrokerImpl.flushSafe(BrokerImpl.java:1915)
        at org.apache.openjpa.kernel.BrokerImpl.beforeCompletion(BrokerImpl.java:1833)
        at org.apache.openjpa.kernel.LocalManagedRuntime.commit(LocalManagedRuntime.java:81)
        Truncated. see log file for complete stacktrace
Caused By: <openjpa-1.1.1-SNAPSHOT-r422266:1172209 nonfatal store error> kodo.jdo.DataStoreException: ORA-00942: table or view does not exist
 {prepstmnt 1761247975 INSERT INTO BEAXACMLAP (DOMN, REALMN, TYPEN, CN, XVER, CTS, WCN, WCI, WXF, XD, XS, MTS) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) [params=(String) oam_domain, (String) myrealm, (String) Policies, (String) urn:bea:xacml:2.0:entitlement:resource:type@E@Fmbean@G, (String) 1.0, (null) null, (null) null, (null) null, (Blob) oracle.sql.BLOB@2edaed3d, (InputStream) java.io.ByteArrayInputStream@270d57d3, (String) 3, (Timestamp) 2016-09-05 18:17:17.026] [reused=0]} [code=942, state=42000]
FailedObject: com.bea.common.security.store.data.XACMLAuthorizationPolicy@11986f57
        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:72)
        at kodo.jdbc.kernel.BatchingPreparedStatementManager.flushInternal(BatchingPreparedStatementManager.java:214)
        Truncated. see log file for complete stacktrace
Caused By: org.apache.openjpa.lib.jdbc.ReportingSQLException: ORA-00942: table or view does not exist
 {prepstmnt 1761247975 INSERT INTO BEAXACMLAP (DOMN, REALMN, TYPEN, CN, XVER, CTS, WCN, WCI, WXF, XD, XS, MTS) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) [params=(String) oam_domain, (String) myrealm, (String) Policies, (String) urn:bea:xacml:2.0:entitlement:resource:type@E@Fmbean@G, (String) 1.0, (null) null, (null) null, (null) null, (Blob) oracle.sql.BLOB@2edaed3d, (InputStream) java.io.ByteArrayInputStream@270d57d3, (String) 3, (Timestamp) 2016-09-05 18:17:17.026] [reused=0]} [code=942, state=42000]
        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.executeUpdate(LoggingConnectionDecorator.java:866)
        at org.apache.openjpa.lib.jdbc.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:269)
        at org.apache.openjpa.jdbc.kernel.JDBCStoreManager$CancelPreparedStatement.executeUpdate(JDBCStoreManager.java:1453)
        Truncated. see log file for complete stacktrace
>
<Sep 5, 2016 6:17:17 PM JST> <Notice> <Security> <BEA-090082> <Security initializing using security realm myrealm.>
<Sep 5, 2016 6:17:17 PM JST> <Critical> <WebLogicServer> <BEA-000362> <Server failed. Reason:

There are 1 nested errors:

weblogic.security.service.SecurityServiceRuntimeException: [Security:090399]Security Services Unavailable
        at weblogic.security.service.CommonSecurityServiceManagerDelegateImpl.doBootAuthorization(CommonSecurityServiceManagerDelegateImpl.java:917)
        at weblogic.security.service.CommonSecurityServiceManagerDelegateImpl.initialize(CommonSecurityServiceManagerDelegateImpl.java:1054)
        at weblogic.security.service.SecurityServiceManager.initialize(SecurityServiceManager.java:873)
        at weblogic.security.SecurityService.start(SecurityService.java:141)
        at weblogic.t3.srvr.SubsystemRequest.run(SubsystemRequest.java:64)
        at weblogic.work.ExecuteThread.execute(ExecuteThread.java:256)
        at weblogic.work.ExecuteThread.run(ExecuteThread.java:221)

>
<Sep 5, 2016 6:17:17 PM JST> <Notice> <WebLogicServer> <BEA-000365> <Server state changed to FAILED>
<Sep 5, 2016 6:17:17 PM JST> <Error> <WebLogicServer> <BEA-000383> <A critical service failed. The server will shut itself down>
<Sep 5, 2016 6:17:17 PM JST> <Notice> <WebLogicServer> <BEA-000365> <Server state changed to FORCE_SHUTTING_DOWN>

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms