2 Replies Latest reply: Jun 11, 2014 1:16 AM by Richa Juneja RSS

    Cannot open database "SOA" requested by the login. The login failed..

    77b48df9-7004-477f-aa54-b970e84e015f

      I am trying to start the Oracle Hyperion Services.All the servies start in running mode excpet the SOA Server says the server started in Admin mode.

      And when I look at the log it says..

      <Warning> <JDBC> <BEA-001129> <Received exception while creating connection for pool "SOALocalTxDataSource": [FMWGEN][SQLServer JDBC Driver][SQLServer]Cannot open database "SOA" requested by the login. The login failed..> 

       

      <Warning> <JDBC> <BEA-001129> <Received exception while creating connection for pool "OraSDPMDataSource": [FMWGEN][SQLServer JDBC Driver][SQLServer]Cannot open database "SOA" requested by the login. The login failed..> 

       

      <Warning> <JDBC> <BEA-001129> <Received exception while creating connection for pool "mds-soa": [FMWGEN][SQLServer JDBC Driver][SQLServer]Cannot open database "SOA" requested by the login. The login failed..> 

      <May 13, 2014 2:37:04 PM CDT> <Error> <oracle.mds> <BEA-000000> <

      oracle.mds.lcm.exception.MDSLCMException: MDS-01330: unable to load MDS configuration document 

      MDS-01329: unable to load element "persistence-config"

      MDS-01370: MetadataStore configuration for metadata-store-usage "soa-infra-store" is invalid. 

      MDS-01376: Unable to get database connection from data source "mds-soa" configured with JNDI name "jdbc/mds/MDS_LocalTxDataSource". 

      weblogic.common.resourcepool.ResourceDeadException: 0:weblogic.common.ResourceException: Could not create pool connection. The DBMS driver exception was: [FMWGEN][SQLServer JDBC Driver][SQLServer]Cannot open database "SOA" requested by the login. The login failed.

       

        at oracle.mds.internal.lcm.deploy.DeployManager.deploy(DeployManager.java:747)

        at oracle.mds.internal.lcm.deploy.DeployManager.startDeployment(DeployManager.java:211)

        at oracle.mds.internal.lcm.MDSLifecycleListenerImpl.start(MDSLifecycleListenerImpl.java:215)

        at oracle.mds.lcm.weblogic.WLLifecycleListener.preStart(WLLifecycleListener.java:77)

        at weblogic.application.internal.flow.BaseLifecycleFlow$PreStartAction.run(BaseLifecycleFlow.java:282)

        at weblogic.security.acl.internal.AuthenticatedSubject.doAs(AuthenticatedSubject.java:321)

        at weblogic.security.service.SecurityManager.runAs(SecurityManager.java:120)

        at weblogic.application.internal.flow.BaseLifecycleFlow$LifecycleListenerAction.invoke(BaseLifecycleFlow.java:199)

        at weblogic.application.internal.flow.BaseLifecycleFlow.preStart(BaseLifecycleFlow.java:62)

        at weblogic.application.internal.flow.HeadLifecycleFlow.prepare(HeadLifecycleFlow.java:284)

        at weblogic.application.internal.BaseDeployment$1.next(BaseDeployment.java:649)

        at weblogic.application.utils.StateMachineDriver.nextState(StateMachineDriver.java:52)

        at weblogic.application.internal.BaseDeployment.prepare(BaseDeployment.java:191)

        at weblogic.application.internal.EarDeployment.prepare(EarDeployment.java:59)

        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:144)

        at weblogic.management.deploy.internal.DeploymentAdapter$1.doPrepare(DeploymentAdapter.java:40)

        at weblogic.management.deploy.internal.DeploymentAdapter.prepare(DeploymentAdapter.java:191)

        at weblogic.management.deploy.internal.AppTransition$1.transitionApp(AppTransition.java:22)

        at weblogic.management.deploy.internal.ConfiguredDeployments.transitionApps(ConfiguredDeployments.java:240)

        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:181)

        at weblogic.management.deploy.internal.DeploymentServerService.start(DeploymentServerService.java:97)

        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)

      Caused By: oracle.mds.config.MDSConfigurationException: MDS-01330: unable to load MDS configuration document 

      MDS-01329: unable to load element "persistence-config"

      MDS-01370: MetadataStore configuration for metadata-store-usage "soa-infra-store" is invalid. 

      MDS-01376: Unable to get database connection from data source "mds-soa" configured with JNDI name "jdbc/mds/MDS_LocalTxDataSource". 

      weblogic.common.resourcepool.ResourceDeadException: 0:weblogic.common.ResourceException: Could not create pool connection. The DBMS driver exception was: [FMWGEN][SQLServer JDBC Driver][SQLServer]Cannot open database "SOA" requested by the login. The login failed.

       

        at oracle.mds.config.PConfig.loadFromBean(PConfig.java:1014)

        at oracle.mds.config.PConfig.<init>(PConfig.java:767)

        at oracle.mds.config.MDSConfig.loadFromBean(MDSConfig.java:1151)

        at oracle.mds.config.MDSConfig.loadFromElement(MDSConfig.java:1218)

        at oracle.mds.config.MDSConfig.<init>(MDSConfig.java:781)

        at oracle.mds.config.MDSConfig.<init>(MDSConfig.java:730)

        at oracle.mds.internal.lcm.deploy.DeployManager.deploy(DeployManager.java:529)

        at oracle.mds.internal.lcm.deploy.DeployManager.startDeployment(DeployManager.java:211)

        at oracle.mds.internal.lcm.MDSLifecycleListenerImpl.start(MDSLifecycleListenerImpl.java:215)

        at oracle.mds.lcm.weblogic.WLLifecycleListener.preStart(WLLifecycleListener.java:77)

        at weblogic.application.internal.flow.BaseLifecycleFlow$PreStartAction.run(BaseLifecycleFlow.java:282)

        at weblogic.security.acl.internal.AuthenticatedSubject.doAs(AuthenticatedSubject.java:321)

        at weblogic.security.service.SecurityManager.runAs(SecurityManager.java:120)

        at weblogic.application.internal.flow.BaseLifecycleFlow$LifecycleListenerAction.invoke(BaseLifecycleFlow.java:199)

        at weblogic.application.internal.flow.BaseLifecycleFlow.preStart(BaseLifecycleFlow.java:62)

        at weblogic.application.internal.flow.HeadLifecycleFlow.prepare(HeadLifecycleFlow.java:284)

        at weblogic.application.internal.BaseDeployment$1.next(BaseDeployment.java:649)

        at weblogic.application.utils.StateMachineDriver.nextState(StateMachineDriver.java:52)

        at weblogic.application.internal.BaseDeployment.prepare(BaseDeployment.java:191)

        at weblogic.application.internal.EarDeployment.prepare(EarDeployment.java:59)

        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:144)

        at weblogic.management.deploy.internal.DeploymentAdapter$1.doPrepare(DeploymentAdapter.java:40)

        at weblogic.management.deploy.internal.DeploymentAdapter.prepare(DeploymentAdapter.java:191)

        at weblogic.management.deploy.internal.AppTransition$1.transitionApp(AppTransition.java:22)

        at weblogic.management.deploy.internal.ConfiguredDeployments.transitionApps(ConfiguredDeployments.java:240)

        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:181)

        at weblogic.management.deploy.internal.DeploymentServerService.start(DeploymentServerService.java:97)

        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)

      Caused By: oracle.mds.exception.MDSExceptionList: MDS-01329: unable to load element "persistence-config"

      MDS-01370: MetadataStore configuration for metadata-store-usage "soa-infra-store" is invalid. 

      MDS-01376: Unable to get database connection from data source "mds-soa" configured with JNDI name "jdbc/mds/MDS_LocalTxDataSource". 

      weblogic.common.resourcepool.ResourceDeadException: 0:weblogic.common.ResourceException: Could not create pool connection. The DBMS driver exception was: [FMWGEN][SQLServer JDBC Driver][SQLServer]Cannot open database "SOA" requested by the login. The login failed.

       

        at oracle.mds.config.PConfig.loadFromBean(PConfig.java:1008)

        at oracle.mds.config.PConfig.<init>(PConfig.java:767)

        at oracle.mds.config.MDSConfig.loadFromBean(MDSConfig.java:1151)

        at oracle.mds.config.MDSConfig.loadFromElement(MDSConfig.java:1218)

        at oracle.mds.config.MDSConfig.<init>(MDSConfig.java:781)

        at oracle.mds.config.MDSConfig.<init>(MDSConfig.java:728)

        at oracle.mds.internal.lcm.deploy.DeployManager.deploy(DeployManager.java:529)

        at oracle.mds.internal.lcm.deploy.DeployManager.startDeployment(DeployManager.java:211)

        at oracle.mds.internal.lcm.MDSLifecycleListenerImpl.start(MDSLifecycleListenerImpl.java:215)

        at oracle.mds.lcm.weblogic.WLLifecycleListener.preStart(WLLifecycleListener.java:77)

        at weblogic.application.internal.flow.BaseLifecycleFlow$PreStartAction.run(BaseLifecycleFlow.java:282)

        at weblogic.security.acl.internal.AuthenticatedSubject.doAs(AuthenticatedSubject.java:321)

        at weblogic.security.service.SecurityManager.runAs(SecurityManager.java:120)

        at weblogic.application.internal.flow.BaseLifecycleFlow$LifecycleListenerAction.invoke(BaseLifecycleFlow.java:199)

        at weblogic.application.internal.flow.BaseLifecycleFlow.preStart(BaseLifecycleFlow.java:62)

        at weblogic.application.internal.flow.HeadLifecycleFlow.prepare(HeadLifecycleFlow.java:283)

        at weblogic.application.internal.BaseDeployment$1.next(BaseDeployment.java:648)

        at weblogic.application.utils.StateMachineDriver.nextState(StateMachineDriver.java:52)

        at weblogic.application.internal.BaseDeployment.prepare(BaseDeployment.java:191)

        at weblogic.application.internal.EarDeployment.prepare(EarDeployment.java:59)

        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:144)

        at weblogic.management.deploy.internal.DeploymentAdapter$1.doPrepare(DeploymentAdapter.java:39)

        at weblogic.management.deploy.internal.DeploymentAdapter.prepare(DeploymentAdapter.java:191)

        at weblogic.management.deploy.internal.AppTransition$1.transitionApp(AppTransition.java:21)

        at weblogic.management.deploy.internal.ConfiguredDeployments.transitionApps(ConfiguredDeployments.java:240)

        at weblogic.management.deploy.internal.ConfiguredDeployments.prepare(ConfiguredDeployments.java:165)

        at weblogic.management.deploy.internal.ConfiguredDeployments.deploy(ConfiguredDeployments.java:122)

        at weblogic.management.deploy.internal.DeploymentServerService.resume(DeploymentServerService.java:180)

        at weblogic.management.deploy.internal.DeploymentServerService.start(DeploymentServerService.java:96)

        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)

      <May 13, 2014 2:37:04 PM CDT> <Error> <Deployer> <BEA-149205> <Failed to initialize the application 'soa-infra' due to error oracle.mds.exception.MDSExceptionList: MDS-01329: unable to load element "persistence-config"

      MDS-01370: MetadataStore configuration for metadata-store-usage "soa-infra-store" is invalid. 

      MDS-01376: Unable to get database connection from data source "mds-soa" configured with JNDI name "jdbc/mds/MDS_LocalTxDataSource". 

      weblogic.common.resourcepool.ResourceDeadException: 0:weblogic.common.ResourceException: Could not create pool connection. The DBMS driver exception was: [FMWGEN][SQLServer JDBC Driver][SQLServer]Cannot open database "SOA" requested by the login. The login failed.

      .

      oracle.mds.exception.MDSExceptionList: MDS-01329: unable to load element "persistence-config"

      MDS-01370: MetadataStore configuration for metadata-store-usage "soa-infra-store" is invalid. 

      MDS-01376: Unable to get database connection from data source "mds-soa" configured with JNDI name "jdbc/mds/MDS_LocalTxDataSource". 

      weblogic.common.resourcepool.ResourceDeadException: 0:weblogic.common.ResourceException: Could not create pool connection. The DBMS driver exception was: [FMWGEN][SQLServer JDBC Driver][SQLServer]Cannot open database "SOA" requested by the login. The login failed.