5 Replies Latest reply: Dec 17, 2012 3:35 AM by SamTrashers RSS

    Dataguard administration with Cloud Control 12cr2


      there is a dataguard configuration that is working fine with DGMGRL.

      but, the Cloud Control 12cr2 is unable to
      - perform switchover
      -configure/deconfigure FAST START FAILOVER

      i always get

      Session Information Unavailable

      Enterprise Manager is unable to proceed. The most likely cause of this is that database session information could not be retrieved or that EM was unable to process a user-invoked bookmark. Press OK to continue.

      the emoms.log shows :

      2012-12-12 09:20:44,467 [EMUI_09_20_44_/console/database/dataguard] ERROR em.dataguard onEvent.1889 - java.lang.NullPointerException
      at oracle.sysman.db.dg.DataguardController.displayConnectPage(DataguardController.java:3298)
      at oracle.sysman.db.dg.DataguardController.onEvent(DataguardController.java:1436)
      at oracle.sysman.db.adm.BaseController.handleEvent(BaseController.java:1234)
      at oracle.sysman.db.dg.DataguardController.handleEvent(DataguardController.java:1188)
      at oracle.sysman.emSDK.svlt.PageHandler.handleRequest(PageHandler.java:584)
      at oracle.sysman.db.adm.RootController.handleRequest(RootController.java:248)
      at oracle.sysman.db.adm.BaseController.handleRequest(BaseController.java:1108)
      at oracle.sysman.emSDK.svlt.EMServlet.myDoGet(EMServlet.java:758)
      at oracle.sysman.emSDK.svlt.EMServlet.doGet(EMServlet.java:336)
      at oracle.sysman.eml.app.Console.doGet(Console.java:337)
      at javax.servlet.http.HttpServlet.service(HttpServlet.java:707)
      at javax.servlet.http.HttpServlet.service(HttpServlet.java:820)
      at weblogic.servlet.internal.StubSecurityHelper$ServletServiceAction.run(StubSecurityHelper.java:227)
      at weblogic.servlet.internal.StubSecurityHelper.invokeServlet(StubSecurityHelper.java:125)
      at weblogic.servlet.internal.ServletStubImpl.execute(ServletStubImpl.java:300)
      at weblogic.servlet.internal.TailFilter.doFilter(TailFilter.java:26)
      at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:56)
      at oracle.sysman.eml.app.ConsoleFilter.doFilter(ConsoleFilter.java:368)
      at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:56)
      at oracle.sysman.eml.app.EMTargetAuthFilter.doFilter(EMTargetAuthFilter.java:375)
      at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:56)
      at oracle.sysman.eml.app.EMRepLoginFilter.doFilter(EMRepLoginFilter.java:675)
      at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:56)
      at oracle.sysman.emas.fwk.MASConnectionFilter.doFilter(MASConnectionFilter.java:41)
      at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:56)
      at oracle.sysman.eml.app.BrowserVersionFilter.doFilter(BrowserVersionFilter.java:122)
      at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:56)
      at oracle.sysman.emSDK.svlt.EMRedirectFilter.doFilter(EMRedirectFilter.java:102)
      at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:56)
      at oracle.adf.library.webapp.LibraryFilter.doFilter(LibraryFilter.java:179)
      at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:56)
      at oracle.sysman.eml.app.ContextInitFilter.doFilter(ContextInitFilter.java:550)
      at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:56)
      at oracle.adfinternal.view.faces.caching.filter.AdfFacesCachingFilter.doFilter(AdfFacesCachingFilter.java:137)
      at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:56)
      at oracle.sysman.eml.app.EMSecurityFilter.doFilter(EMSecurityFilter.java:66)
      at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:56)
      at oracle.sysman.core.app.exception.EMRuntimeExceptionFilter.doFilter(EMRuntimeExceptionFilter.java:81)
      at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:56)
      at oracle.security.jps.ee.http.JpsAbsFilter$1.run(JpsAbsFilter.java:119)
      at java.security.AccessController.doPrivileged(Native Method)
      at oracle.security.jps.util.JpsSubject.doAsPrivileged(JpsSubject.java:315)
      at oracle.security.jps.ee.util.JpsPlatformUtil.runJaasMode(JpsPlatformUtil.java:442)
      at oracle.security.jps.ee.http.JpsAbsFilter.runJaasMode(JpsAbsFilter.java:103)
      at oracle.security.jps.ee.http.JpsAbsFilter.doFilter(JpsAbsFilter.java:171)
      at oracle.security.jps.ee.http.JpsFilter.doFilter(JpsFilter.java:71)
      at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:56)
      at oracle.dms.servlet.DMSServletFilter.doFilter(DMSServletFilter.java:139)
      at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:56)
      at weblogic.servlet.internal.RequestEventsFilter.doFilter(RequestEventsFilter.java:27)
      at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:56)
      at weblogic.servlet.internal.WebAppServletContext$ServletInvocationAction.wrapRun(WebAppServletContext.java:3715)
      at weblogic.servlet.internal.WebAppServletContext$ServletInvocationAction.run(WebAppServletContext.java:3681)
      at weblogic.security.acl.internal.AuthenticatedSubject.doAs(AuthenticatedSubject.java:321)
      at weblogic.security.service.SecurityManager.runAs(SecurityManager.java:120)
      at weblogic.servlet.internal.WebAppServletContext.securedExecute(WebAppServletContext.java:2277)
      at weblogic.servlet.internal.WebAppServletContext.execute(WebAppServletContext.java:2183)
      at weblogic.servlet.internal.ServletRequestImpl.run(ServletRequestImpl.java:1454)
      at weblogic.work.ExecuteThread.execute(ExecuteThread.java:209)
      at weblogic.work.ExecuteThread.run(ExecuteThread.java:178)

      2012-12-12 09:20:44,582 [EMUI_09_20_44_/console/database/dataguard] WARN em.dataguard handleEvent.1147 - DataguardController.handleEvent: invalid target or null connection for : editConfirmUpgrade
      2012-12-12 09:20:44,624 [EMUI_09_20_44_/console/database/dataguard] WARN em.dataguard getMetricData.1587 - ConfigBean.getMetricData: SQLException: ORA-01830: Le modèle du format de date se termine avant la conversion de la chaîne d'entrée entière
      ORA-06512: à ligne 58

      Any idea ?
        • 1. Re: Dataguard administration with Cloud Control 12cr2
          Hello Sam,

          Please provide a little more information.

          When you select the Availability --> Data Guard Administration. Does the page display everything correctly for the Data Guard setup?
          When you run the 'Verify Data Guard Setup' what results do you get?

          Also , please confirm that you have setup the correct credentials for your Host and Databases.

          When you do a show configuration; in dgmgrl (is the status success?)

          Jan S.
          • 2. Re: Dataguard administration with Cloud Control 12cr2
            Hi jstem,

            thank you for your help

            The initial status of the DATAGUARD is SUCCESS, and all is working fine with the BROKER.

            The"Availability"=>"Dataguard Administration" page is correct, all the indications are right, except :
            - Estimate Failover Time : Not available

            Here is the output of 'Verify Data Guard Setup'
            Connected to instance srv-bdd02:PHOENIX
            Starting alert log monitor...
            Updating Data Guard link on database homepage...
            Skipping verification of fast-start failover static services check.

            Data Protection Settings:
            Protection mode : Maximum Availability
            Redo Transport Mode settings:
            PHNXFIN: SYNC
            PHNXENT: SYNC

            Checking standby redo log files.....OK

            Checking Data Guard status
            PHNXFIN : Normal
            PHNXENT : Normal

            Checking inconsistent properties

            Checking agent status
            WARNING: No credentials available for target. srv-bdd01
            Attempting agent ping ... OK

            WARNING: No credentials available for target. srv-bdd02
            Attempting agent ping ... OK

            Checking applied log on PHNXENT...OK

            Processing completed.

            Yes, i've already investigated about credentials ...
            ALL the credentials are OK for hosts, instance, agent, .... don't know where to add more credentials ....
            • 3. Re: Dataguard administration with Cloud Control 12cr2
              Hello Sam,

              Just an odd question, the default monitoring user when you add a database target is DBSNMP. Can you confirm that your monitoring user for both primary and standby is * SYS*.
              The simple reason I ask is because to get this above information you can simply do, but you cannot switchover:
              #> dgmgrl
              #> connect /
              #> show configuration;
              #> switchover to PHNXENT;  
                     --> this should throw an error such as:  
                          DGM-17017: unable to determine configuration status       
              Assuming the above, check the data guard logs. There must be a trace of the agent connecting and retrieving this information. If this is 11gR2, then the log is at the same place as you alert_log --> DIAG/rdbms ...../trace/..

              I'm assuming this is a full out PRODUCTION setup already and thus just switchover back and forth is not possible and stop the standby and starting it, canceling log apply etc is not possible either?

              I'm also assuming that you can see the standby database on the Administration page? But if you cannot switchover (button disabled) there must something else if its not the credentials and nothing is showing in the logs.

              Jan S.
              • 4. Re: Dataguard administration with Cloud Control 12cr2
                Hi Jan,
                yes, i do not use dbsnmp, but SYS user
                I've already made such a confgiuration With 10gr2 database ans Grid Control (all was working fine)

                All the buttons like "Switchover" or "failover" are available (they are not disabled)

                The problem is not an error during switchover, i think that Cloud Control is hanging before doing anything, because after the error, i come back to the welcome page (i do not come back to the "dataguard administration page"

                with the broker only, everything is allright
                - switchover
                - failover
                - fast start failover
                - automatic reinstate
                - start/stop observer
                - real time apply
                - ...

                by the messages, it seems that cloud control cannot find the credentials for host srv-db01 and srv-bd02, but the credentials are set (or i need more credentials, but i don't know where ...)

                this platform is not yet in production (i'm justing building it) so i can do all required test ...
                • 5. Re: Dataguard administration with Cloud Control 12cr2
                  there is a news ... it works fine with FIREFOX !

                  ... the problem i face seems to be an interaction between Cloud Control and IE9 !