AdminServer Start Failed With oracle.security.jps.JpsException: JPS-00027: There was an internal error: java.sql.SQLException: ORA-01017: invalid username/password; logon denied Received above error when executed the below statement:

CAUSE :

RF enabled domain has dependency on database-based Oracle Platform Security repository OPSS schema.
AdminServer startup will fall if there is issue accessing the OPSS schema.

The JDBC configuration for the OPSS schema database access is in DOMAIN_HOME/config/jdbc/opss-datasource-jdbc.xml
Sample snippet of opss-datasource-jdbc.xml
<name>opss-data-source</name>
<jdbc-driver-params>
 <url>jdbc:oracle:thin:@server1.oracle.com:1521/DBMW</url>
 <driver-name>oracle.jdbc.OracleDriver</driver-name>
 <properties>
  <property>
  <name>user</name>
   <value>PROD_OPSS</value>
  </property>
 </properties>
 <password-encrypted>{AES}…..=</password-encrypted>
</jdbc-driver-params>
<jdbc-connection-pool-params>
 <test-table-name>SQL SELECT 1 FROM DUAL</test-table-name>
</jdbc-connection-pool-params>
<jdbc-data-source-params>
  <jndi-name>jdbc/OpssDataSource</jndi-name>
  <global-transactions-protocol>None</global-transactions-protocol>
 </jdbc-data-source-params>
</jdbc-data-source>

SYMPTOMS:

Start Weblogic AdminServer failed with following error in AdminServer.log

####<May 11, 2017 9:01:55 AM EDT> <Critical> <WebLogicServer> <OAS12C> <AdminServer> <main> <<WLS Kernel>> <> <53e386ae-df5f-4f89-8098-d6bf07c74f4c-00000002> <1494507715080> <[severity-value: 4] [rid: 0] [partition-id: 0] [partition-name: DOMAIN] > <BEA-000362> <Server failed. Reason:
There are 1 nested errors:
oracle.security.jps.JpsException: JPS-00027: There was an internal error: java.sql.SQLException: ORA-01017: invalid username/password; logon denied
at oracle.security.jps.internal.config.OpssCommonStartup.start(OpssCommonStartup.java:209)
at oracle.security.jps.wls.JpsWlsStartup.start(JpsWlsStartup.java:96)
at oracle.security.jps.JpsStartup.start(JpsStartup.java:215)
at oracle.security.jps.wls.JpsDefaultService.start(JpsDefaultService.java:74)
at weblogic.server.AbstractServerService.postConstruct(AbstractServerService.java:76)
at sun.reflect.GeneratedMethodAccessor2.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:497)
at org.glassfish.hk2.utilities.reflection.ReflectionHelper.invoke(ReflectionHelper.java:1262)
at org.jvnet.hk2.internal.ClazzCreator.postConstructMe(ClazzCreator.java:332)
at org.jvnet.hk2.internal.ClazzCreator.create(ClazzCreator.java:374)
at org.jvnet.hk2.internal.SystemDescriptor.create(SystemDescriptor.java:471)
at org.glassfish.hk2.runlevel.internal.AsyncRunLevelContext.findOrCreate(AsyncRunLevelContext.java:228)
at org.glassfish.hk2.runlevel.RunLevelContext.findOrCreate(RunLevelContext.java:85)
at org.jvnet.hk2.internal.Utilities.createService(Utilities.java:2072)
at org.jvnet.hk2.internal.ServiceHandleImpl.getService(ServiceHandleImpl.java:114)
at org.jvnet.hk2.internal.ServiceHandleImpl.getService(ServiceHandleImpl.java:88)
at org.glassfish.hk2.runlevel.internal.CurrentTaskFuture$QueueRunner.oneJob(CurrentTaskFuture.java:1213)
at org.glassfish.hk2.runlevel.internal.CurrentTaskFuture$QueueRunner.run(CurrentTaskFuture.java:1144)
at weblogic.work.SelfTuningWorkManagerImpl$WorkAdapterImpl.run(SelfTuningWorkManagerImpl.java:643)
at weblogic.invocation.ComponentInvocationContextManager._runAs(ComponentInvocationContextManager.java:348)
at weblogic.invocation.ComponentInvocationContextManager.runAs(ComponentInvocationContextManager.java:333)
at weblogic.work.LivePartitionUtility.doRunWorkUnderContext(LivePartitionUtility.java:54)
at weblogic.work.PartitionUtility.runWorkUnderContext(PartitionUtility.java:41)
at weblogic.work.SelfTuningWorkManagerImpl.runWorkUnderContext(SelfTuningWorkManagerImpl.java:617)
at weblogic.work.ExecuteThread.execute(ExecuteThread.java:397)

at weblogic.work.ExecuteThread.run(ExecuteThread.java:346)
Caused by: oracle.security.jps.service.policystore.PolicyStoreConnectivityException: JPS-00027: There was an internal error: java.sql.SQLException: ORA-01017: invalid username/password; logon denied
at oracle.security.jps.internal.policystore.rdbms.JpsDBDataManager.handleDatabaseException(JpsDBDataManager.java:2146)
at oracle.security.jps.internal.policystore.rdbms.JpsDBDataManager.processJPAException(JpsDBDataManager.java:2629)
at oracle.security.jps.internal.policystore.rdbms.JpsDBDataManager.existsTable(JpsDBDataManager.java:1677)
at oracle.security.jps.internal.policystore.rdbms.JpsDBDataManager.isPrincipalAssigneeSplit(JpsDBDataManager.java:1612)

Caused by: Exception [EclipseLink-4002] (Eclipse Persistence Services – 2.6.1.v20150916-55dc7c3): org.eclipse.persistence.exceptions.DatabaseException
Internal Exception: java.sql.SQLException: ORA-01017: invalid username/password; logon denied
Error Code: 1017
at org.eclipse.persistence.exceptions.DatabaseException.sqlException(DatabaseException.java:331)
at org.eclipse.persistence.exceptions.DatabaseException.sqlException(DatabaseException.java:326)
at org.eclipse.persistence.sessions.DefaultConnector.connect(DefaultConnector.java:138)
at org.eclipse.persistence.sessions.DatasourceLogin.connectToDatasource(DatasourceLogin.java:162)
at org.eclipse.persistence.internal.sessions.DatabaseSessionImpl.setOrDetectDatasource(DatabaseSessionImpl.java:207)

at oracle.security.jps.internal.policystore.rdbms.JpsDBDataManager.existsTable(JpsDBDataManager.java:1654)
… 44 more
Caused by: java.sql.SQLException: ORA-01017: invalid username/password; logon denied
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:466)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:399)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:391)
at oracle.jdbc.driver.T4CTTIfun.processError(T4CTTIfun.java:1126)
at oracle.jdbc.driver.T4CTTIoauthenticate.processError(T4CTTIoauthenticate.java:507)
at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:546)
at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:269)
at oracle.jdbc.driver.T4CTTIoauthenticate.doOAUTH(T4CTTIoauthenticate.java:440)
at oracle.jdbc.driver.T4CTTIoauthenticate.doOAUTH(T4CTTIoauthenticate.java:1025)
at oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:682)
at oracle.jdbc.driver.PhysicalConnection.connect(PhysicalConnection.java:793)
at oracle.jdbc.driver.T4CDriverExtension.getConnection(T4CDriverExtension.java:33)
at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:614)
at java.sql.DriverManager.getConnection(DriverManager.java:664)
at java.sql.DriverManager.getConnection(DriverManager.java:208)
at org.eclipse.persistence.sessions.DefaultConnector.connect(DefaultConnector.java:98)
####<May 11, 2017 9:01:55 AM EDT> <Notice> <WebLogicServer> <OAS12C> <AdminServer> <main> <<WLS Kernel>> <> <53e386ae-df5f-4f89-8098-d6bf07c74f4c-00000002> <1494507715205> <[severity-value: 32] [rid: 0] [partition-id: 0] [partition-name: DOMAIN] > <BEA-000365> <Server state changed to FAILED.>
####<May 11, 2017 9:01:55 AM EDT> <Error> <WebLogicServer> <OAS12C> <AdminServer> <main> <<WLS Kernel>> <> <53e386ae-df5f-4f89-8098-d6bf07c74f4c-00000002> <1494507715205> <[severity-value: 8] [rid: 0] [partition-id: 0] [partition-name: DOMAIN] > <BEA-000383> <A critical service failed. The server will shut itself down.>
####<May 11, 2017 9:01:55 AM EDT> <Notice> <WebLogicServer> <OAS12C> <AdminServer> <main> <<WLS Kernel>> <> <53e386ae-df5f-4f89-8098-d6bf07c74f4c-00000002> <1494507715205> <[severity-value: 32] [rid: 0] [partition-id: 0] [partition-name: DOMAIN] > <BEA-000365> <Server state changed to FORCE_SHUTTING_DOWN.>
####<May 11, 2017 9:01:55 AM EDT> <Info> <WebLogicServer> <OAS12C> <AdminServer> <[STANDBY] ExecuteThread: ‘3’ for queue: ‘weblogic.kernel.Default (self-tuning)’> <<WLS Kernel>> <> <53e386ae-df5f-4f89-8098-d6bf07c74f4c-00000003> <1494507715205> <[severity-value: 64] [rid: 0] [partition-id: 0] [partition-name: DOMAIN] > <BEA-000236> <Stopping execute threads.>
####<May 11, 2017 9:01:55 AM EDT> <Info> <WebLogicServer> <OAS12C> <AdminServer> <main> <<WLS Kernel>> <> <53e386ae-df5f-4f89-8098-d6bf07c74f4c-00000002> <1494507715220> <[severity-value: 64] [rid: 0] [partition-id: 0] [partition-name: DOMAIN] > <BEA-000238> <Shutdown has completed.>

APPLIES TO:

Oracle WebLogic Server – Version 12.1.2.0.0 and later
Information in this document applies to any platform.

SOLUTION:

Using RCU to recreate database users only will not work because the db users and db objects are configured during instance configuration and subsequent instance configuration/usage.  If the database is lost, the database users must be recreated again using RCU and run config to create the instance again.
1. Make sure all instance processes are stopped.

2. Rename DOMAIN_HOME directory eg. from base_domain to base_domain.old
    -The old domain directory can be deleted at a later time.

3. Make a copy of beahomelist
   Window: C:beabeahomelist
   Linux :    $HOME/bea/beahomelist

4. If domain entry exist in beahomelist, remove the entry

5. Run RCU to create the database users

6. Run config.sh to create the instance

REFERENCE:

Metalink Doc ID 2265421.1
  • October 7, 2017 | 145 views
  • Comments