Is BOOTDELAYMINUTES deprecated in GoldenGate 12.2.0.1.1?

BWall · May 11, 2017 3:32PM

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!

BWall · May 12, 2017 1:26PM

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

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 \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

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 \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

K.Gan · 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 · 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 · 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

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.

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

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

Regards,

Kamal.

BWall · May 12, 2017 1:26PM