This discussion is archived
6 Replies Latest reply: Nov 4, 2011 4:06 AM by Roger Ford RSS

Could not login to admin page of SES 11g

845707 Newbie
Currently Being Moderated
Hi

I could not login to admin page of SES. I see the following error message in the log


Caused By: oracle.mds.exception.MDSExceptionList: MDS-01329: unable to load element "persistence-config"
MDS-01370: MetadataStore configuration for metadata-store-usage "OWSM_TargetRepos" is invalid.
MDS-00922: The ConnectionManager "oracle.mds.internal.persistence.db.JNDIConnectionManagerImpl" cannot be instantiated.
weblogic.common.resourcepool.ResourceDeadException: 0:weblogic.common.ResourceException: Could not create pool connection. The DBMS driver exception was: ORA-28001: the password has expired


     at oracle.mds.config.PConfig.loadFromBean(PConfig.java:689)
     at oracle.mds.config.PConfig.<init>(PConfig.java:504)
     at oracle.mds.config.MDSConfig.loadFromBean(MDSConfig.java:692)
     at oracle.mds.config.MDSConfig.loadFromElement(MDSConfig.java:749)
     at oracle.mds.config.MDSConfig.<init>(MDSConfig.java:407)
     at oracle.mds.core.MDSInstance.getMDSConfigFromDocument(MDSInstance.java:2007)
     at oracle.mds.core.MDSInstance.createMDSInstanceWithCustomizedConfig(MDSInstance.java:1169)
     at oracle.mds.core.MDSInstance.getOrCreateInstance(MDSInstance.java:569)
     at oracle.adf.share.config.ADFMDSConfig.createMDSInstanceFromelement(ADFMDSConfig.java:243)
     at oracle.adf.share.config.MDSConfigFactory.createApplication(MDSConfigFactory.java:121)
     at oracle.adf.share.config.ADFConfigFactory.findOrCreateADFConfig(ADFConfigFactory.java:159)
     at oracle.adf.share.config.ADFConfigFactory.findOrCreateADFConfig(ADFConfigFactory.java:78)
     at oracle.adf.share.config.ADFConfigFactory.findOrCreateADFConfig(ADFConfigFactory.java:56)
     at oracle.adf.share.ADFContext.getADFConfigEx(ADFContext.java:691)
     at oracle.adf.share.ADFContext.getADFConfig(ADFContext.java:675)
     at oracle.adf.share.config.ADFContextMDSConfigHelperImpl.getMDSInstance(ADFContextMDSConfigHelperImpl.java:274)
     at oracle.adf.share.ADFContext.getMDSInstanceAsObject(ADFContext.java:1203)
     at oracle.wsm.mds.MDSAccessor.getMDSInstance(MDSAccessor.java:1597)
     at oracle.wsm.mds.MDSAccessor.getMDSSession(MDSAccessor.java:1617)
     at oracle.wsm.mds.MDSAccessor.getLatestMOCopy(MDSAccessor.java:1521)
     at oracle.wsm.mds.MDSAccessor.getMetadataObjectAsMO(MDSAccessor.java:1631)
     at oracle.wsm.mds.MDSAccessor.getStoreLastUpdatedDate(MDSAccessor.java:682)
     at oracle.wsm.policymanager.impl.UpdateService.seed(UpdateService.java:1777)
     at oracle.wsm.policymanager.impl.UpdateService.<init>(UpdateService.java:222)
     at oracle.wsm.policymanager.impl.QueryService.seed(QueryService.java:2438)
     at oracle.wsm.policymanager.impl.QueryService.<init>(QueryService.java:210)
     at oracle.wsm.policymanager.ejb.impl.QueryService.<init>(QueryService.java:48)
     at oracle.wsm.policymanager.ejb.impl.QueryService_5hd9i2_Impl.<init>(QueryService_5hd9i2_Impl.java:45)
     at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
     at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:39)
     at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:27)
     at java.lang.reflect.Constructor.newInstance(Constructor.java:513)
     at java.lang.Class.newInstance0(Class.java:355)
     at java.lang.Class.newInstance(Class.java:308)
     at com.bea.core.repackaged.springframework.jee.spi.EjbComponentCreatorBrokerImpl.getBean(EjbComponentCreatorBrokerImpl.java:69)
     at weblogic.ejb.container.injection.EjbComponentCreatorImpl.getBean(EjbComponentCreatorImpl.java:68)
     at weblogic.ejb.container.manager.BaseEJBManager.createNewBeanInstance(BaseEJBManager.java:216)
     at weblogic.ejb.container.manager.BaseEJBManager.allocateBean(BaseEJBManager.java:233)
     at weblogic.ejb.container.manager.StatelessManager.createBean(StatelessManager.java:303)
     at weblogic.ejb.container.pool.StatelessSessionPool.createBean(StatelessSessionPool.java:201)
     at weblogic.ejb.container.pool.StatelessSessionPool.getBean(StatelessSessionPool.java:127)
     at weblogic.ejb.container.manager.StatelessManager.preInvoke(StatelessManager.java:148)
     at weblogic.ejb.container.internal.BaseRemoteObject.preInvoke(BaseRemoteObject.java:227)
     at weblogic.ejb.container.internal.StatelessRemoteObject.preInvoke(StatelessRemoteObject.java:52)
     at oracle.wsm.policymanager.ejb.impl.QueryService_5hd9i2_IStringQueryServiceRemoteImpl.getStoreTimestampAsDate(QueryService_5hd9i2_IStringQueryServiceRemoteImpl.java:1861)
     at oracle.wsm.policymanager.ejb.impl.QueryService_5hd9i2_IStringQueryServiceRemoteImpl_WLSkel.invoke(Unknown Source)
     at weblogic.rmi.internal.ServerRequest.sendReceive(ServerRequest.java:174)
     at weblogic.rmi.cluster.ClusterableRemoteRef.invoke(ClusterableRemoteRef.java:345)
     at weblogic.rmi.cluster.ClusterableRemoteRef.invoke(ClusterableRemoteRef.java:259)
     at oracle.wsm.policymanager.ejb.impl.QueryService_5hd9i2_IStringQueryServiceRemoteImpl_1032_WLStub.getStoreTimestampAsDate(Unknown Source)
     at oracle.wsm.policymanager.client.QueryServiceDelegate.getStoreTimestamp(QueryServiceDelegate.java:1278)
     at oracle.wsm.policymanager.util.PolicyManagerStartup.main(PolicyManagerStartup.java:52)
     at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
     at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
     at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
     at java.lang.reflect.Method.invoke(Method.java:597)
     at weblogic.management.deploy.classdeployment.ClassDeploymentManager.invokeMain(ClassDeploymentManager.java:353)
     at weblogic.management.deploy.classdeployment.ClassDeploymentManager.invokeClass(ClassDeploymentManager.java:263)
     at weblogic.management.deploy.classdeployment.ClassDeploymentManager.access$000(ClassDeploymentManager.java:54)
     at weblogic.management.deploy.classdeployment.ClassDeploymentManager$1.run(ClassDeploymentManager.java:205)
     at weblogic.security.acl.internal.AuthenticatedSubject.doAs(AuthenticatedSubject.java:321)
     at weblogic.security.service.SecurityManager.runAs(SecurityManager.java:121)
     at weblogic.management.deploy.classdeployment.ClassDeploymentManager.invokeClassDeployment(ClassDeploymentManager.java:198)
     at weblogic.management.deploy.classdeployment.ClassDeploymentManager.invokeClassDeployments(ClassDeploymentManager.java:177)
     at weblogic.management.deploy.classdeployment.ClassDeploymentManager.runStartupsAfterAppActivation(ClassDeploymentManager.java:158)
     at weblogic.management.deploy.classdeployment.StartupClassPrelistenService.start(StartupClassPrelistenService.java:13)
     at weblogic.t3.srvr.SubsystemRequest.run(SubsystemRequest.java:64)
     at weblogic.work.SelfTuningWorkManagerImpl$WorkAdapterImpl.run(SelfTuningWorkManagerImpl.java:516)
     at weblogic.work.ExecuteThread.execute(ExecuteThread.java:201)
     at weblogic.work.ExecuteThread.run(ExecuteThread.java:173)



I tried to reset the eqsys password using the following commands (as suggested in support.oracle.com) but no luck.


1. Launch SQL*Plus, connect as SYS user.

SQL> connect sys/<sesadmin_password> as sysdba

2. Reset EQSYS password (set the original EQSYS password).

SQL> alter user eqsys identified by password1;


Any help is greatly appreciated.

Thanks,
Kirankanth
  • 1. Re: Could not login to admin page of SES 11g
    Roger Ford Expert
    Currently Being Moderated
    This is (unpublished) bug 9625180.

    As well as resetting the EQSYS password, which you have done, you need to reset the EQ_TEST password.

    Launch SQL*Plus, connect as EQSYS user, and run next SQL.

    SQL> exec eq_adm.use_instance('eq_inst')

    PL/SQL procedure successfully completed.

    SQL> REM Change EQ_TEST password manually. Here, we are changing the password to magic1 as an example.

    SQL> alter user eq_test identified by magic1;

    User altered.

    SQL> REM Register the password in the backend.

    SQL> exec eq_crw.set_sysinfo('PASSWORD','magic1');

    SQL> quit


    Now open the WebLogic console. This is on the same port as SES - so if your SES URL is http://www.myserver.com:7777/search/query then the WebLogic console is at http://www.myserver.com:7777/console

    If there is a "Lock and Edit" button in the top left, click it.

    In "Domain Structure" at the left pane, navigate to:

    base_domain -> Services -> JDBC -> Data Sources (click this one)

    You can see "Summary of JDBC Data Sources" in your right pane. Click "EnterpriseSearchDS". "Settings for EnterpriseSearchDS" is presented.

    Click "connection pool" tab. Click "Lock & Edit" button located at the upper left. Then, all the parameters are unlocked.

    Enter "Password" and "Confirm Password" field (with "magic1" or your equivalent) Click "Save" button.

    Click "Activate Changes" button.

    If you have any trouble with this post here or contact support.
  • 2. Re: Could not login to admin page of SES 11g
    845707 Newbie
    Currently Being Moderated
    Hi Roger,

    Thanks for your immediate response.I executed the commands you mentioned to rest eq_test password. But still I get the same error message.

    The problem is only with the admin page. My search page works fine.

    Also I would like to add that I see the following message when executing the searchctl startall command

    Service "extproc_agent_1521" has 1 instance(s).
    Instance "extproc_agent_1521", status UNKNOWN, has 1 handler(s) for this service...
    Service "ses" has 1 instance(s).
    Instance "ses", status UNKNOWN, has 1 handler(s) for this service...
    The command completed successfully

    and there is one more error message in the log along with the one I mentioned before

    oracle.net.ns.NetException: Listener refused the connection with the following error:
    ORA-12514, TNS:listener does not currently know of service requested in connect descriptor
  • 3. Re: Could not login to admin page of SES 11g
    Roger Ford Expert
    Currently Being Moderated
    Are you still seeing the error:

    "The DBMS driver exception was: ORA-28001: the password has expired" ?

    As for the TNS error, that doesn't sound related. Can you do the following:

    Restart the TNS listener by doing:

    lsnrctl stop
    lsnrctl start

    Then re-register the database

    sqlplus sys/<ses password>
    alter system register
    quit

    Then type "lsnrctl status" and post the output here (I would recommend anatomizing any servernames or IP addresses)

    Next, please list the value of the "connect string" for the database connection from your weblogic console (see previous message for details)
  • 4. Re: Could not login to admin page of SES 11g
    845707 Newbie
    Currently Being Moderated
    Yes, I still see that error. Along with that there is one more exception:

    java.sql.SQLException: Listener refused the connection with the following error:
    ORA-12514, TNS:listener does not currently know of service requested in connect descriptor






    Output of lsnrctl status after executing the commands:



    LSNRCTL for Linux: Version 11.1.0.7.0 - Production on 08-MAR-2011 14:01:21

    Copyright (c) 1991, 2008, Oracle. All rights reserved.

    Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=<servername>)(PORT=1522)))
    STATUS of the LISTENER
    ------------------------
    Alias LISTENER
    Version TNSLSNR for Linux: Version 11.1.0.7.0 - Production
    Start Date 08-MAR-2011 13:59:45
    Uptime 0 days 0 hr. 1 min. 36 sec
    Trace Level off
    Security ON: Local OS Authentication
    SNMP OFF
    Listener Parameter File /u02/oraweb/oracle/product_demo/11.1.2.0.0/ses/seshome/network/admin/listener.ora
    Listener Log File /u02/oraweb/oracle/product_demo/11.1.2.0.0/ses/seshome/log/diag/tnslsnr/<server>/listener/alert/log.xml
    Listening Endpoints Summary...
    (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=<servername>)(PORT=1522)))
    (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1522)))
    Services Summary...
    Service "extproc_agent_1521" has 1 instance(s).
    Instance "extproc_agent_1521", status UNKNOWN, has 1 handler(s) for this service...
    Service "ses" has 1 instance(s).
    Instance "ses", status UNKNOWN, has 1 handler(s) for this service...
    The command completed successfully





    Connect string for the database connection for EnterpriseSearchDS:

    jdbc:oracle:thin:@(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=<server>)(PORT=1522))(CONNECT_DATA=(SERVER=DEDICATED)(SID=ses)))



    and for mds-owsm
    jdbc:oracle:thin:@<server>:1521/dvols07

    According to the message(details in my previous post) error seems to be something related to MDS configuration.

    Thanks,
    Kirankanth
  • 5. Re: Could not login to admin page of SES 11g
    user602471 Newbie
    Currently Being Moderated
    I wonder what happened with this thread. Am also not being able to not login to admin page of SES 11g
  • 6. Re: Could not login to admin page of SES 11g
    Roger Ford Expert
    Currently Being Moderated
    What errors are you seeing? Is there anything useful in the wls log file?

    ($ORACLE_HOME/search/base_domain/servers/AdminServer/logs/AdminServer_yyyy_MM_dd_hh_mm.log)

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points