Forum Stats

  • 3,814,856 Users
  • 2,258,920 Discussions
  • 7,892,878 Comments

Discussions

Is BOOTDELAYMINUTES deprecated in GoldenGate 12.2.0.1.1?

BWall
BWall Member Posts: 16 Blue Ribbon
edited May 12, 2017 4:30PM in GoldenGate

I rely on this setting in the manager parameter file for my extract to ensure GG doesn't start before our transactional database (Oracle 12C) is available.

Since upgrading to GG 12.2.0.1.1, it appears this setting is no longer honored. Has anybody else experienced this? As far as I can tell it's still a valid parameter based Oracle's documentation (BOOTDELAYMINUTES). I just can't get it to work now .

Thanks!

Tagged:

Best Answer

  • BWall
    BWall Member Posts: 16 Blue Ribbon
    edited May 12, 2017 1:26PM Answer ✓

    Sorry, I neglected to mention I'm doing this on Windows Server 2008 R2.

    Your mgr report output was very helpful! It gave me a starting point where I was able to get it to work.

    Here's the original report output:

    GGSCI (biserv5) 1> view report mgr

    ***********************************************************************

                     Oracle GoldenGate Manager for Oracle

          Version 12.2.0.1.1 OGGCORE_12.2.0.1.0_PLATFORMS_151211.1401

          Windows x64 (optimized), Oracle 12c on Dec 18 2015 20:31:38

    Copyright (C) 1995, 2015, Oracle and/or its affiliates. All rights reserved.

                        Starting at 2017-05-12 09:06:18

    ***********************************************************************

    Operating System Version:

    Microsoft Windows Server 2008 R2 , on x64

    Version 6.1 (Build 7601: Service Pack 1)

    Process id: 1424

    Parameters...

    PORT 7809

    BOOTDELAYMINUTES 5

    AUTOSTART EXTRACT *

    AUTORESTART EXTRACT *, RETRIES 5, WAITMINUTES 2, RESETMINUTES 10

    PURGEOLDEXTRACTS D:\FamousBI\GoldenGate\dirdat\T000002A\ex, USECHECKPOINTS

    useridalias famousbi

    2017-05-12 09:06:19  WARNING OGG-02551  ORACLE_HOME is not set to Oracle software directory.

    Source Context :

      SourceModule            : [ggdb.ora.sess]

      SourceID                : [../gglib/ggdbora/ocisess.c]

      SourceFunction          : [OCISESS_context_def::oci_try]

      SourceLine              : [871]

      ThreadBacktrace         : [15] elements

                              : [D:\FamousBI\GoldenGate\gglog.dll([email protected]@[email protected]+0x2a76) [0x000007FEF9B7E986]]

                              : [D:\FamousBI\GoldenGate\gglog.dll([email protected]@@[email protected]@[email protected]@IZZ+0x561) [0x000007FEF9B7EFD1]]

                              : [D:\FamousBI\GoldenGate\gglog.dll([email protected]@[email protected]@[email protected]@Z+0x4e) [0x000007FEF9B1335E]]

                              : [D:\FamousBI\GoldenGate\mgr.exe(_ggTryDebugHook+0x244f3) [0x000000013F9930B3]]

                              : [D:\FamousBI\GoldenGate\mgr.exe(_ggTryDebugHook+0x25a21) [0x000000013F9945E1]]

                              : [D:\FamousBI\GoldenGate\mgr.exe(_ggTryDebugHook+0x2b0dc) [0x000000013F999C9C]]

                              : [D:\FamousBI\GoldenGate\mgr.exe(_ggTryDebugHook+0x2aaab) [0x000000013F99966B]]

                              : [D:\FamousBI\GoldenGate\mgr.exe(_ggTryDebugHook+0x1d2d7) [0x000000013F98BE97]]

                              : [D:\FamousBI\GoldenGate\mgr.exe(_ggTryDebugHook+0x1d99f) [0x000000013F98C55F]]

                              : [D:\FamousBI\GoldenGate\mgr.exe(_ggTryDebugHook+0x14477) [0x000000013F983037]]

                              : [D:\FamousBI\GoldenGate\mgr.exe(_ggTryDebugHook+0x2c8ad) [0x000000013F99B46D]]

                              : [D:\FamousBI\GoldenGate\mgr.exe(_ggTryDebugHook+0x2ee8a) [0x000000013F99DA4A]]

                              : [C:\Windows\SYSTEM32\sechost.dll(RegisterServiceCtrlHandlerExA+0x269) [0x000007FEFD38A82D]]

                              : [C:\Windows\system32\kernel32.dll(BaseThreadInitThunk+0xd) [0x00000000771C59CD]]

                              : [C:\Windows\SYSTEM32\ntdll.dll(RtlUserThreadStart+0x21) [0x00000000772FA561]]

    2017-05-12 09:06:20  ERROR   OGG-00664  OCI Error beginning session (status = 1034-ORA-01034: ORACLE not available

    ORA-27101: shared memory realm does not exist).

    2017-05-12 09:06:20  ERROR   OGG-01668  PROCESS ABENDING.

    GGSCI (biserv5) 2>

    The culprit is useridalias famousbi. When I take it out it works fine:

    GGSCI (biserv5) 1> view report mgr

    ***********************************************************************

                     Oracle GoldenGate Manager for Oracle

          Version 12.2.0.1.1 OGGCORE_12.2.0.1.0_PLATFORMS_151211.1401

          Windows x64 (optimized), Oracle 12c on Dec 18 2015 20:31:38

    Copyright (C) 1995, 2015, Oracle and/or its affiliates. All rights reserved.

                        Starting at 2017-05-12 09:47:27

    ***********************************************************************

    Operating System Version:

    Microsoft Windows Server 2008 R2 , on x64

    Version 6.1 (Build 7601: Service Pack 1)

    Process id: 1404

    Parameters...

    PORT 7809

    BOOTDELAYMINUTES 5

    AUTOSTART EXTRACT *

    AUTORESTART EXTRACT *, RETRIES 5, WAITMINUTES 2, RESETMINUTES 10

    PURGEOLDEXTRACTS D:\FamousBI\GoldenGate\dirdat\T000002A\ex, USECHECKPOINTS

    2017-05-12 09:47:28  INFO    OGG-00984  Delaying 4 minutes, 51 seconds before further processing.

    GGSCI (biserv5) 2>

    It won't harm me right now to remove useridalias famousbi, but having database login info in the mgr.prm file didn't cause this problem in 11g. And isn't this required for DDL replication (which I'm not doing right now)? I thought I read this somewhere (can't find the source now)?

    Brian

Answers

  • K.Gan
    K.Gan Member Posts: 2,750 Bronze Crown
    edited May 11, 2017 5:29PM

    Just checking. This parameter only works for Windows servers. Can you please attach the manager report file?

    Cheers

    Kee Gan

  • ORASCN
    ORASCN Member Posts: 1,868 Bronze Crown
    edited May 11, 2017 10:41PM

    Hi ,

    Use the BOOTDELAYMINUTES parameter on a Windows system to delay the activities that Manager performs when it starts, such as executing parameters. For example, BOOTDELAYMINUTES can be used to delay AUTOSTART parameters until database services are started.

    Specify BOOTDELAYMINUTES before other parameter entries. This parameter only supports Windows.

    If this parameter is deprecated in OGG 12.2, then they should have removed it or mentioned it as deprecated parameter in the OGG documentation. But this is still there in the document.

    Also, there are lot of Documentation Bugs in the Oracle GoldenGate 12.2 reference guide. Need to test this. Will test and update you on this.

    Regards,

    Veera

  • Kamal.Sharma-Oracle
    Kamal.Sharma-Oracle Member Posts: 71 Employee
    edited May 12, 2017 1:52AM

    Hi ,

    Could you please post your mgr report file. I just checked on the later version of 12.2 and the bootdelayminutes parameter seems to be working.

    GGSCI (KASHSHAR-IN) 1> view report mgr

    ***********************************************************************

                     Oracle GoldenGate Manager for Oracle

          Version 12.2.0.1.1 OGGCORE_12.2.0.1.0_PLATFORMS_151211.1401

          Windows x64 (optimized), Oracle 12c on Dec 18 2015 20:31:38

    Copyright (C) 1995, 2015, Oracle and/or its affiliates. All rights reserved.

                        Starting at 2017-05-12 11:06:15

    ***********************************************************************

    Operating System Version:

    Microsoft Windows 7 , on x64

    Version 6.1 (Build 7601: Service Pack 1)

    Process id: 3028

    Parameters...

    PORT 1287

    BOOTDELAYMINUTES 5

    AUTOSTART Extract E1

    2017-05-12 11:06:16  INFO    OGG-00984  Delaying 4 minutes, 22 seconds before further processing.

    ***********************************************************************

    **                     Run Time Messages                             **

    ***********************************************************************

    2017-05-12 11:10:41  WARNING OGG-01877  Missing explicit accessrule for server collector.

    2017-05-12 11:10:41  INFO    OGG-00960  Access granted (rule #26).

    2017-05-12 11:10:41  INFO    OGG-00983  Manager started (port 1287).

    2017-05-12 11:10:41  INFO    OGG-00967  Manager performing AUTOSTART processing.

    2017-05-12 11:10:46  INFO    OGG-00975  EXTRACT E1 starting.

    D:\app\kashshar\product\12.1.2\12c>systeminfo|find "Time:"

    System Boot Time:          5/12/2017, 11:05:39 AM

    Regards,

    Kamal.

    BWall
  • BWall
    BWall Member Posts: 16 Blue Ribbon
    edited May 12, 2017 1:26PM Answer ✓

    Sorry, I neglected to mention I'm doing this on Windows Server 2008 R2.

    Your mgr report output was very helpful! It gave me a starting point where I was able to get it to work.

    Here's the original report output:

    GGSCI (biserv5) 1> view report mgr

    ***********************************************************************

                     Oracle GoldenGate Manager for Oracle

          Version 12.2.0.1.1 OGGCORE_12.2.0.1.0_PLATFORMS_151211.1401

          Windows x64 (optimized), Oracle 12c on Dec 18 2015 20:31:38

    Copyright (C) 1995, 2015, Oracle and/or its affiliates. All rights reserved.

                        Starting at 2017-05-12 09:06:18

    ***********************************************************************

    Operating System Version:

    Microsoft Windows Server 2008 R2 , on x64

    Version 6.1 (Build 7601: Service Pack 1)

    Process id: 1424

    Parameters...

    PORT 7809

    BOOTDELAYMINUTES 5

    AUTOSTART EXTRACT *

    AUTORESTART EXTRACT *, RETRIES 5, WAITMINUTES 2, RESETMINUTES 10

    PURGEOLDEXTRACTS D:\FamousBI\GoldenGate\dirdat\T000002A\ex, USECHECKPOINTS

    useridalias famousbi

    2017-05-12 09:06:19  WARNING OGG-02551  ORACLE_HOME is not set to Oracle software directory.

    Source Context :

      SourceModule            : [ggdb.ora.sess]

      SourceID                : [../gglib/ggdbora/ocisess.c]

      SourceFunction          : [OCISESS_context_def::oci_try]

      SourceLine              : [871]

      ThreadBacktrace         : [15] elements

                              : [D:\FamousBI\GoldenGate\gglog.dll([email protected]@[email protected]+0x2a76) [0x000007FEF9B7E986]]

                              : [D:\FamousBI\GoldenGate\gglog.dll([email protected]@@[email protected]@[email protected]@IZZ+0x561) [0x000007FEF9B7EFD1]]

                              : [D:\FamousBI\GoldenGate\gglog.dll([email protected]@[email protected]@[email protected]@Z+0x4e) [0x000007FEF9B1335E]]

                              : [D:\FamousBI\GoldenGate\mgr.exe(_ggTryDebugHook+0x244f3) [0x000000013F9930B3]]

                              : [D:\FamousBI\GoldenGate\mgr.exe(_ggTryDebugHook+0x25a21) [0x000000013F9945E1]]

                              : [D:\FamousBI\GoldenGate\mgr.exe(_ggTryDebugHook+0x2b0dc) [0x000000013F999C9C]]

                              : [D:\FamousBI\GoldenGate\mgr.exe(_ggTryDebugHook+0x2aaab) [0x000000013F99966B]]

                              : [D:\FamousBI\GoldenGate\mgr.exe(_ggTryDebugHook+0x1d2d7) [0x000000013F98BE97]]

                              : [D:\FamousBI\GoldenGate\mgr.exe(_ggTryDebugHook+0x1d99f) [0x000000013F98C55F]]

                              : [D:\FamousBI\GoldenGate\mgr.exe(_ggTryDebugHook+0x14477) [0x000000013F983037]]

                              : [D:\FamousBI\GoldenGate\mgr.exe(_ggTryDebugHook+0x2c8ad) [0x000000013F99B46D]]

                              : [D:\FamousBI\GoldenGate\mgr.exe(_ggTryDebugHook+0x2ee8a) [0x000000013F99DA4A]]

                              : [C:\Windows\SYSTEM32\sechost.dll(RegisterServiceCtrlHandlerExA+0x269) [0x000007FEFD38A82D]]

                              : [C:\Windows\system32\kernel32.dll(BaseThreadInitThunk+0xd) [0x00000000771C59CD]]

                              : [C:\Windows\SYSTEM32\ntdll.dll(RtlUserThreadStart+0x21) [0x00000000772FA561]]

    2017-05-12 09:06:20  ERROR   OGG-00664  OCI Error beginning session (status = 1034-ORA-01034: ORACLE not available

    ORA-27101: shared memory realm does not exist).

    2017-05-12 09:06:20  ERROR   OGG-01668  PROCESS ABENDING.

    GGSCI (biserv5) 2>

    The culprit is useridalias famousbi. When I take it out it works fine:

    GGSCI (biserv5) 1> view report mgr

    ***********************************************************************

                     Oracle GoldenGate Manager for Oracle

          Version 12.2.0.1.1 OGGCORE_12.2.0.1.0_PLATFORMS_151211.1401

          Windows x64 (optimized), Oracle 12c on Dec 18 2015 20:31:38

    Copyright (C) 1995, 2015, Oracle and/or its affiliates. All rights reserved.

                        Starting at 2017-05-12 09:47:27

    ***********************************************************************

    Operating System Version:

    Microsoft Windows Server 2008 R2 , on x64

    Version 6.1 (Build 7601: Service Pack 1)

    Process id: 1404

    Parameters...

    PORT 7809

    BOOTDELAYMINUTES 5

    AUTOSTART EXTRACT *

    AUTORESTART EXTRACT *, RETRIES 5, WAITMINUTES 2, RESETMINUTES 10

    PURGEOLDEXTRACTS D:\FamousBI\GoldenGate\dirdat\T000002A\ex, USECHECKPOINTS

    2017-05-12 09:47:28  INFO    OGG-00984  Delaying 4 minutes, 51 seconds before further processing.

    GGSCI (biserv5) 2>

    It won't harm me right now to remove useridalias famousbi, but having database login info in the mgr.prm file didn't cause this problem in 11g. And isn't this required for DDL replication (which I'm not doing right now)? I thought I read this somewhere (can't find the source now)?

    Brian

  • ORASCN
    ORASCN Member Posts: 1,868 Bronze Crown
    edited May 12, 2017 1:56PM

    Hi Brian,

    The userid parameter in the manager process parameter file is required only when you purge the marker table (DDL replication enabled). Else this is not required.

    Regards,

    Veera

    BWall
  • Kamal.Sharma-Oracle
    Kamal.Sharma-Oracle Member Posts: 71 Employee
    edited May 12, 2017 2:02PM

    HI Brian,

    The error in the mgr report file indicates that it is unable to connect to the database. You need to check the connection details used in the useridalias famousbi.

    userid/useridalias in mgr is used for purging the ddl marker/history table.

    D:\app\kashshar\product\12.1.2\12c>ggsci

    Oracle GoldenGate Command Interpreter for Oracle

    Version 12.2.0.1.1 OGGCORE_12.2.0.1.0_PLATFORMS_151211.1401

    Windows x64 (optimized), Oracle 12c on Dec 18 2015 20:34:51

    Operating system character set identified as windows-1252.

    Copyright (C) 1995, 2015, Oracle and/or its affiliates. All rights reserved.

    GGSCI (KASHSHAR-IN) 1> view param mgr

    PORT 1287

    BOOTDELAYMINUTES 5

    AUTOSTART Extract E1

    useridalias source

    GGSCI (KASHSHAR-IN) 2> info credentialstore

    Reading from .\dircrd\:

    Default domain: OracleGoldenGate

      Alias: target

      Userid: [email protected]

      Alias: [email protected]

      Userid: [email protected]

    Alias: source

      Userid: c##source

    Other domains:

      pdborcl

    To view other domains, use INFO CREDENTIALSTORE DOMAIN <domain>

    GGSCI (KASHSHAR-IN) 3> dblogin useridalias source

    2017-05-12 23:30:52  WARNING OGG-02551  ORACLE_HOME is not set to Oracle software directory.

    Successfully logged into database CDB$ROOT.

    Regards,

    Kamal.

  • BWall
    BWall Member Posts: 16 Blue Ribbon
    edited May 12, 2017 2:13PM

    Kamal,

    Definitely worth checking, but in my case the useridalias credentials are configured correctly.

    It can't connect to the database because the database is still starting. That's why I need the BOOTDELAYMINUTES - to make sure the database is online before GoldenGate starts.

    Brian

  • BWall
    BWall Member Posts: 16 Blue Ribbon
    edited May 12, 2017 2:17PM

    Thank you Veera, that helps.

    I'll remove the useridalias line from mgr.prm for now, but will also report this as a bug in an Oracle SR. I'd like to get it fixed before we need DDL replication

    Brian

  • Kamal.Sharma-Oracle
    Kamal.Sharma-Oracle Member Posts: 71 Employee
    edited May 12, 2017 3:14PM

    Yes Brian, It looks a look a perfect candidate for a Bug as previous version did show the  wait message through OGG-00984 , whereas 12.2 tries to connect immediately.

    ***********************************************************************

                     Oracle GoldenGate Manager for Oracle

          Version 12.2.0.1.1 OGGCORE_12.2.0.1.0_PLATFORMS_151211.1401

          Windows x64 (optimized), Oracle 12c on Dec 18 2015 20:31:38

    Copyright (C) 1995, 2015, Oracle and/or its affiliates. All rights reserved.

                        Starting at 2017-05-13 00:30:48

    ***********************************************************************

    Operating System Version:

    Microsoft Windows 7 , on x64

    Version 6.1 (Build 7601: Service Pack 1)

    Process id: 2972

    Parameters...

    PORT 1287

    BOOTDELAYMINUTES 5

    AUTOSTART Extract E1

    useridalias source

    2017-05-13 00:30:53  WARNING OGG-02551  ORACLE_HOME is not set to Oracle software directory.

    +++++++++++++++

    GGSCI (KASHSHAR-IN) 2> view report mgr

    ***********************************************************************

                     Oracle GoldenGate Manager for Oracle

    Version 11.2.1.0.33 22986205 OGGCORE_11.2.1.0.0OGGBP_PLATFORMS_160502.0200

          Windows x64 (optimized), Oracle 11g on May  2 2016 03:35:24

    Copyright (C) 1995, 2016, Oracle and/or its affiliates. All rights reserved.

                        Starting at 2017-05-13 00:31:01

    ***********************************************************************

    Operating System Version:

    Microsoft Windows 7 , on x64

    Version 6.1 (Build 7601: Service Pack 1)

    Process id: 3004

    Parameters...

    PORT 9753

    BOOTDELAYMINUTES 3

    2017-05-13 00:31:02  INFO    OGG-00984  Delaying 2 minutes, 9 seconds before further processing.

    AUTOSTART REPLICAT RTEST

    userid source password source

    Regards,

    Kamal.

    BWall
This discussion has been closed.