Forum Stats

  • 3,769,800 Users
  • 2,253,023 Discussions
  • 7,875,209 Comments

Discussions

Can we have multiple GGSCHEMA in GLOBALS?

Mayuresh Deshmukh
Mayuresh Deshmukh Member Posts: 6 Red Ribbon

Can we have multiple GGSCHEMA in GLOBALS? Suppose I already have GGSCHEMA as c##gguser in my GLOBALS file & as part of the new requirement, we need to replicate sequences. So we need to add another username as GGSCHEMA for specific PDB in GLOBALS file. How can we achieve it?

Please clarify.

Answers

  • ORASCN
    ORASCN Member Posts: 1,825 Gold Trophy

    Hi Mayuresh,

    We can use only one schema "GGSCHEMA".

    So we need to add another username as GGSCHEMA for specific PDB in GLOBALS file. How can we achieve it?

    Could you please explain more on the above point? Why do you need another schema for sequences?


    Regards,

    Veera

  • ORASCN
    ORASCN Member Posts: 1,825 Gold Trophy

    FYI,

    [[email protected] ogg123]$ ./ggsci

    Oracle GoldenGate Command Interpreter for Oracle

    Version 12.3.0.1.4 OGGCORE_12.3.0.1.0_PLATFORMS_180415.0359_FBO

    Linux, x64, 64bit (optimized), Oracle 12c on Apr 16 2018 00:53:30

    Operating system character set identified as UTF-8.

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


    2021-03-10 12:28:57 WARNING OGG-10173 (GLOBALS) line 4: Parsing error, parameter [ggschema] cannot be specified multiple times.


    GGSCI (ogg19c-2.localdomain) 1> info all

    Program   Status   Group    Lag at Chkpt Time Since Chkpt

    MANAGER   RUNNING

    EXTRACT   STOPPED   INEXT    00:00:00   1609:31:53

    REPLICAT  STOPPED   REP1    00:00:00   00:06:43

    REPLICAT  STOPPED   REP2    00:00:00   720:07:17



    GGSCI (ogg19c-2.localdomain) 2> view param ./GLOBALS


    CHECKPOINTTABLE ggadmin.ggchkpt

    GGSCHEMA GGADMIN

    GGSCHEMA GGADMIN1


    You can notice a warning above immediately after ./ggsci

    multiple GGSCHEMA will not work..


    Regards,

    Veera