5 Replies Latest reply: Oct 15, 2013 7:47 AM by Maheswar RSS

    OGG-00664  OCI Error beginning session (status = 1017-ORA-01017)

    Pavel Goncharenko

      Hello.

       

      I'm trying to start extract, but always get an error.

      My steps are:

       

      1. Testing ORACLE_SID:

      CMD> SET ORACLE_SID
      ORACLE_SID=TEST
      
      

      2a. Testing DB Connection:

      CMD> sqlplus /nolog
      SQL> conn cuser/1
      Connected.
      
      

      2b. Testing DB Connection:

      GGSCI> dblogin userid cuser, password 1
      Successfully logged into database.
      
      

      3. Parameters:

      GGSCI> view params mgr
      PORT 7810
      GGSCI> view params odisc
      extract ODISC
      userid cuser, password 1
      exttrail C:\TEMP/dirdat/ODISoc/oc
      TABLE A.B;
      
      

      4. Starting:

      GGSCI> start extract odisc
      Sending START request to MANAGER ('gg_demo_src') ...
      EXTRACT ODISC starting
      GGSCI> status odisc
      EXTRACT ODISC: STOPPED
      
      

      5. Error log:

      ggserr.log:

      2013-10-12 09:51:20  INFO    OGG-00987  Oracle GoldenGate Command Interpreter for Oracle:  GGSCI command (Pavel_Goncharenko): start extract odisc.

      2013-10-12 09:51:20  INFO    OGG-00963  Oracle GoldenGate Manager for Oracle, mgr.prm:  Command received from GGSCI on host COMP:53751 (START EXTRACT ODISC ).

      2013-10-12 09:51:20  INFO    OGG-00975  Oracle GoldenGate Manager for Oracle, mgr.prm:  EXTRACT ODISC starting.

      2013-10-12 09:51:20  INFO    OGG-00992  Oracle GoldenGate Capture for Oracle, ODISC.prm:  EXTRACT ODISC starting.

      2013-10-12 09:51:20  INFO    OGG-03035  Oracle GoldenGate Capture for Oracle, ODISC.prm:  Operating system character set identified as windows-1251. Locale: en_US, LC_ALL:.

      2013-10-12 09:51:20  ERROR   OGG-00664  Oracle GoldenGate Capture for Oracle, ODISC.prm:  OCI Error beginning session (status = 1017-ORA-01017: неверно имя пользователя/пароль; вход в систему запрещается).

      2013-10-12 09:51:20  ERROR   OGG-01668  Oracle GoldenGate Capture for Oracle, ODISC.prm:  PROCESS ABENDING.

      odisc.rpt

      **            Running with the following parameters                  **

      2013-10-12 09:51:20  INFO    OGG-03035  Operating system character set identified as windows-1251. Locale: en_US, LC_ALL:.

      extract ODISC

      userid cuser, password *

      Source Context :

        SourceModule            : [ggdb.ora.sess]

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

        SourceFunction          : [OCISESS_context_def::oci_try]

        SourceLine              : [648]

        ThreadBacktrace         : [12] elements

                                : [c:\TEMP\gglog.dll(??1CContextItem@@UEAA@XZ+0x3272) [0x000000018010BDD2]]

                                : [c:\TEMP\gglog.dll(?_MSG_ERR_ORACLE_OCI_ERROR_WITH_DESC@@YAPEAVCMessage@@PEAVCSourceContext@@HPEBD1W4MessageDisposition@CMessageFactory@@@Z+0xdf) [0x0000000180061C9F]]

                                : [c:\TEMP\extract.exe(_ggTryDebugHook+0x82a31) [0x000000014026E131]]

                                : [c:\TEMP\extract.exe(_ggTryDebugHook+0x84e7f) [0x000000014027057F]]

                                : [c:\TEMP\extract.exe(_ggTryDebugHook+0x2673e) [0x0000000140211E3E]]

                                : [c:\TEMP\extract.exe(_ggTryDebugHook+0x63deb) [0x000000014024F4EB]]

                                : [c:\TEMP\extract.exe(_ggTryDebugHook+0x64150) [0x000000014024F850]]

                                : [c:\TEMP\extract.exe(ERCALLBACK+0x14eec) [0x00000001400AD90C]]

                                : [c:\TEMP\extract.exe(shutdownMonitoring+0x1b056) [0x00000001400E5956]]

                                : [c:\TEMP\extract.exe(CommonLexerNewSSD+0x1d840) [0x000000014042D560]]

                                : [C:\WINDOWS\system32\kernel32.dll(BaseThreadInitThunk+0xd) [0x00000000774F652D]]

                                : [C:\WINDOWS\SYSTEM32\ntdll.dll(RtlUserThreadStart+0x21) [0x000000007762C541]]

      2013-10-12 09:51:20  ERROR   OGG-00664  OCI Error beginning session (status = 1017-ORA-01017: неверно имя пользователя/пароль; вход в систему запрещается).

      2013-10-12 09:51:20  ERROR   OGG-01668  PROCESS ABENDING.

       

      6. Try to fix this via oracle support Doc ID 1298956.1:

      GGSCI> edit params mgr
      
      

      PORT 7810

      userid cuser, password 1

      GGSCI> stop mgr
      Manager process is required by other GGS processes.
      Are you sure you want to stop it (y/n)? y
      Sending STOP request to MANAGER ('gg_demo_src') ...
      Request processed.
      Manager stopped.
      GGSCI> start mgr
      Starting Manager as service ('gg_demo_src')...
      ERROR: Service stopped unexpectedly, check event log.
      
      

      mgr.rpt:

      Parameters...

      PORT 7810

      userid cuser, password 1

       

      Source Context :

        SourceModule            : [ggdb.ora.sess]

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

        SourceFunction          : [OCISESS_context_def::oci_try]

        SourceLine              : [648]

        ThreadBacktrace         : [13] elements

                                : [c:\TEMP\gglog.dll(??1CContextItem@@UEAA@XZ+0x3272) [0x000000018010BDD2]]

                                : [c:\TEMP\gglog.dll(?_MSG_ERR_ORACLE_OCI_ERROR_WITH_DESC@@YAPEAVCMessage@@PEAVCSourceContext@@HPEBD1W4MessageDisposition@CMessageFactory@@@Z+0xdf) [0x0000000180061C9F]]

                                : [c:\TEMP\mgr.exe(_ggTryDebugHook+0xf8f1) [0x000000014006DD31]]

                                : [c:\TEMP\mgr.exe(_ggTryDebugHook+0x1134e) [0x000000014006F78E]]

                                : [c:\TEMP\mgr.exe(_ggTryDebugHook+0xa4cc) [0x000000014006890C]]

                                : [c:\TEMP\mgr.exe(_ggTryDebugHook+0xd0a6) [0x000000014006B4E6]]

                                : [c:\TEMP\mgr.exe(_ggTryDebugHook+0xd3d9) [0x000000014006B819]]

                                : [c:\TEMP\mgr.exe(<ggTryDebugHook+0xd3d9) [0x000000014000838F]]

                                : [c:\TEMP\mgr.exe(<ggTryDebugHook+0xd3d9) [0x0000000140009BC1]]

                                : [c:\TEMP\mgr.exe(<ggTryDebugHook+0xd3d9) [0x000000014001503C]]

                                : [C:\WINDOWS\SYSTEM32\sechost.dll(RegisterServiceCtrlHandlerExA+0x269) [0x000007FEFEE4A82D]]

                                : [C:\WINDOWS\system32\kernel32.dll(BaseThreadInitThunk+0xd) [0x00000000774F652D]]

                                : [C:\WINDOWS\SYSTEM32\ntdll.dll(RtlUserThreadStart+0x21) [0x000000007762C541]]

      2013-10-12 10:01:19  ERROR   OGG-00664  OCI Error beginning session (status = 1017-ORA-01017: неверно имя пользователя/пароль; вход в систему запрещается).

      2013-10-12 10:01:19  ERROR   OGG-01668  PROCESS ABENDING.

      So, my problem isn't solved