6 Replies Latest reply: Aug 11, 2014 7:39 AM by ORASCN RSS

    Oracle golden gate issues

    2729122

      Hi,

       

      I installed golden gate in my system. I am able to start the manager using start manager command

       

      But i am not able to execute any command.

       

      When i am trying the

       

      dblogin userid gguser, password gguser

       

      i am getting the error: invalid command.

       

      Same error i am getting when i am using command

       

      versions

       

      And when i am using ADD extract command it is showing "Invalid parameters specified for ADD extract".

       

      Command used is ADD EXTRACT load, SOURCEISTABLE

       

      My oracle golden gate version is

      Oracle Golden Gate command interpreter

      Version 11.2.1.0.5_PLATFORMS_130117.1330

      Window x64 <optimized>

        • 1. Re: Oracle golden gate issues
          ORASCN

          Hi,

           

          Could you please paste the exact spool file here? Whether have you created a user "gguser" in database?

           

          Regards,

          Veera

          • 2. Re: Oracle golden gate issues
            2729122

            gguser was created by me in the database.

             

            spool was not enabled.

            • 3. Re: Oracle golden gate issues
              ORASCN

              Hi,

               

              Check if there is any spell mistake. also check the syntax correctly.

              What is the database you are using? is it Oracle or Sql server?

              Have you downloaded the correct version of the GoldenGate software?

               

              Error: Invalid Command clearly states that there is some mistake in the syntax or command. Please retry the same and paste the full result here so that we get the reason for the error in a precise manner.

               

              Are you trying these commands in GGSCI prompt? in windows, we have go to the patch where the Oracle GoldenGate is installed and issue the command ggsci.exe to go into the GGSCI prompt.

               

              Veera...

              • 4. Re: Oracle golden gate issues
                2729122

                Here are the commands i have used


                GGSCI (tvmatp236757d) 4> ADD EXTRACT load, SOURCEISTABLE
                ERROR: Invalid parameter specified for ADD EXTRACT.


                GGSCI (tvmatp236757d) 5> dblogin userid ggadmin,password ggadmin
                ERROR: Invalid command.

                 

                 

                GGSCI (tvmatp236757d) 6> versions

                ERROR: Invalid command.

                 

                GGSCI (tvmatp236757d) 8> info manager

                Manager is running (IP port tvmatp236757d.7809).

                 

                 

                I am using oracle version. Please find the details

                 

                SQL> select * from v$version
                  2  ;

                BANNER
                --------------------------------------------------------------------------------

                Oracle Database 11g Enterprise Edition Release 11.1.0.6.0 - Production
                PL/SQL Release 11.1.0.6.0 - Production
                CORE    11.1.0.6.0      Production
                TNS for 32-bit Windows: Version 11.1.0.6.0 - Production
                NLSRTL Version 11.1.0.6.0 - Production

                SQL>

                 

                My oracle golden gate version is

                Oracle Golden Gate command interpreter

                Version 11.2.1.0.5_PLATFORMS_130117.1330

                Window x64 <optimized>

                 

                 

                command is issued in ggsci prompt

                • 5. Re: Oracle golden gate issues
                  Kgronau-Oracle

                  Regarding your command:

                  ADD EXTRACT load, SOURCEISTABLE

                  => ggsci thinks  load is a command for extract not the name of your extract. So please rename your initial load process "load".


                  example - you have:

                  GGSCI 2> add extract load, sourceistable

                  ERROR: Invalid parameter specified for ADD EXTRACT.

                   

                  now name your initial load xxx instead of load and it works:

                  GGSCI 3> add extract xxx, sourceistable

                  EXTRACT added.

                  • 6. Re: Oracle golden gate issues
                    ORASCN

                    Hi,

                     

                    Thanks for the output.

                     

                    From the output I think, you have installed 64Bit of Windows version, and the oracle version is 32bit. Kindly check that.

                     

                    Do you have multiple databases created in the server? If so, please set the environmental variable and then login to the ggsci prompt and issue the command.

                     

                    set ORACLE_SID=dbname

                    set ORACLE_HOME=oracle_home

                    ggsci.exe

                    dblogin userid <gguser_name>, password <gguser_pwd>

                    add extract load, sourceistable

                     

                    Veera...