This discussion is archived
5 Replies Latest reply: Dec 17, 2012 1:35 AM by SamTrashers RSS

Dataguard administration with Cloud Control 12cr2

SamTrashers Newbie
Currently Being Moderated
Hi,

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
    jstem1177 Explorer
    Currently Being Moderated
    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
    SamTrashers Newbie
    Currently Being Moderated
    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'
    Initializing
    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
    jstem1177 Explorer
    Currently Being Moderated
    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
    SamTrashers Newbie
    Currently Being Moderated
    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
    SamTrashers Newbie
    Currently Being Moderated
    there is a news ... it works fine with FIREFOX !

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

Legend

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