ogg打补丁后发现抽取进程abend报错
2023-06-27 16:45:07 ERROR OGG-00303 Extract failed to login to the database as user c##oggadmin specified in
the MININGUSER parameter because of error Error while trying to retrieve text for error ORA-01804.
2023-06-27 16:45:07 ERROR OGG-01668 PROCESS ABENDING.
原因分析：
打补丁时设置了ogg的ORACLE_HOME=/ogg/19c但是打完之后没有还原ogg启动的ORACLE_HOME变量，就启动了mgr，ext，pum等进程，这个值应该是oracle database的ORACLE_HOME=/u01/app/oracle/product/19.3.0/db_1
处理办法：
停止该服务器上ogg所有进程，stop mgr,stop e1,stop p1
重启启动start mgr start e1 start p1即可
详细操作过程如下：
[root@ora02 ~]# su - oracle
Last login: Tue Jun 27 13:19:39 CST 2023 on pts/0
[oracle@ora02 ~]$ cd /ogg/19c
[oracle@ora02 19c]$ ./ggsci
Oracle GoldenGate Command Interpreter for Oracle
Version 19.1.0.0.4 OGGCORE_19.1.0.0.0_PLATFORMS_191017.1054_FBO
Linux, x64, 64bit (optimized), Oracle 19c on Oct 17 2019 21:16:29
Operating system character set identified as UTF-8.
Copyright (C) 1995, 2019, Oracle and/or its affiliates. All rights reserved.
GGSCI (ora02) 1> info all
Program Status Group Lag at Chkpt Time Since Chkpt
MANAGER RUNNING
EXTRACT STOPPED C1 00:00:00 43:15:01
EXTRACT STOPPED D1 00:00:00 43:14:58
EXTRACT RUNNING E1 00:00:00 00:00:07
EXTRACT RUNNING P1 00:00:00 00:00:04
GGSCI (ora02) 2> 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 ...
Request processed.
Manager stopped.
GGSCI (ora02) 3> stop *
EXTRACT C1 is already stopped.
EXTRACT D1 is already stopped.
Sending STOP request to EXTRACT E1 ...
Request processed.
Sending STOP request to EXTRACT P1 ...
Request processed.
GGSCI (ora02) 4> info all
Program Status Group Lag at Chkpt Time Since Chkpt
MANAGER STOPPED
EXTRACT STOPPED C1 00:00:00 44:07:33
EXTRACT STOPPED D1 00:00:00 44:07:30
EXTRACT RUNNING E1 00:00:00 00:00:02
EXTRACT STOPPED P1 00:00:00 00:00:02
GGSCI (ora02) 5> exit
[oracle@ora02 19c]$ ./ggsci
Oracle GoldenGate Command Interpreter for Oracle
Version 19.1.0.0.4 OGGCORE_19.1.0.0.0_PLATFORMS_191017.1054_FBO
Linux, x64, 64bit (optimized), Oracle 19c on Oct 17 2019 21:16:29
Operating system character set identified as UTF-8.
Copyright (C) 1995, 2019, Oracle and/or its affiliates. All rights reserved.
GGSCI (ora02) 2> info all
Program Status Group Lag at Chkpt Time Since Chkpt
MANAGER STOPPED
EXTRACT STOPPED C1 00:00:00 44:07:43
EXTRACT STOPPED D1 00:00:00 44:07:41
EXTRACT STOPPED E1 00:00:00 00:00:13
EXTRACT STOPPED P1 00:00:00 00:00:12
GGSCI (ora02) 3> exit
[oracle@ora02 19c]$ pwd
/ogg/19c
[oracle@ora02 19c]$ ps -ef|grep ogg
oracle 7117 4441 0 16:20 pts/0 00:00:00 grep --color=auto ogg
[oracle@ora02 19c]$ ps -ef|grep gg
oracle 7123 4441 0 16:20 pts/0 00:00:00 grep --color=auto gg
[oracle@ora02 19c]$ exit
logout
c[root@ora02 ~]# chown -R oracle:oinstall /soft
[root@ora02 ~]# su - oracle
Last login: Tue Jun 27 15:27:51 CST 2023 on pts/0
[oracle@ora02 ~]$ cd /soft
[oracle@ora02 soft]$ ls
33803476 p33803476_190000_Linux-x86-64.zip p6880880_190000_Linux-x86-64-12.2.0.1.36.zip
nohup.out p35326279_19100230422_Linux-x86-64-ogg.zip PatchSearch.xml
[oracle@ora02 soft]$ ll
total 3065864
drwxr-x--- 8 oracle oinstall 4096 Apr 7 2022 33803476
-rw------- 1 oracle oinstall 1617142 Jun 25 17:15 nohup.out
-rw-r--r-- 1 oracle oinstall 2832388023 Jul 14 2022 p33803476_190000_Linux-x86-64.zip
-rw-r--r-- 1 oracle oinstall 179493730 Jun 27 16:17 p35326279_19100230422_Linux-x86-64-ogg.zip
-rw-r--r-- 1 oracle oinstall 124347218 Mar 15 22:48 p6880880_190000_Linux-x86-64-12.2.0.1.36.zip
-rw-rw-r-- 1 oracle oinstall 1581224 Apr 20 2022 PatchSearch.xml
[oracle@ora02 soft]$ unzip p35326279_19100230422_Linux-x86-64-ogg.zip
Archive: p35326279_19100230422_Linux-x86-64-ogg.zip
creating: 35326279/
creating: 35326279/etc/
creating: 35326279/etc/config/
inflating: 35326279/etc/config/inventory.xml
......
inflating: oracle-goldengate-release-notes_19.1.0.0230422.pdf
[oracle@ora02 soft]$ pwd
/soft
[oracle@ora02 soft]$ export ORACLE_HOME=/ogg/19c
[oracle@ora02 soft]$ $ORACLE_HOME/OPatch/opatch lspatches
There are no Interim patches installed in this Oracle Home "/ogg/19c".
OPatch succeeded.
[oracle@ora02 soft]$ $ORACLE_HOME/OPatch/opatch version
OPatch Version: 12.2.0.1.18
OPatch succeeded.
替换opatch新版本
[oracle@ora02 soft]$ cd /ogg/19c
[oracle@ora02 19c]$ mv OPatch/ OPatch.bak
[oracle@ora02 19c]$ ll /soft
total 3066468
drwxr-x--- 8 oracle oinstall 4096 Apr 7 2022 33803476
drwxr-xr-x 4 oracle oinstall 30 Apr 28 00:58 35326279
-rw------- 1 oracle oinstall 1617142 Jun 25 17:15 nohup.out
-rw-r--r-- 1 oracle oinstall 1414 Apr 29 02:35 OGG-19.1.0.0-README.TXT
-rw-r--r-- 1 oracle oinstall 602164 May 9 22:30 oracle-goldengate-release-notes_19.1.0.0230422.pdf
-rw-r--r-- 1 oracle oinstall 2832388023 Jul 14 2022 p33803476_190000_Linux-x86-64.zip
-rw-r--r-- 1 oracle oinstall 179493730 Jun 27 16:17 p35326279_19100230422_Linux-x86-64-ogg.zip
-rw-r--r-- 1 oracle oinstall 124347218 Mar 15 22:48 p6880880_190000_Linux-x86-64-12.2.0.1.36.zip
-rw-rw-r-- 1 oracle oinstall 1581224 Apr 20 2022 PatchSearch.xml
-rw-r--r-- 1 oracle oinstall 4510 May 10 04:35 README_ora19c.txt
[oracle@ora02 19c]$ $ORACLE_HOME/OPatch/opatch version
OPatch Version: 12.2.0.1.36
OPatch succeeded.
[oracle@ora02 19c]$ pwd
/ogg/19c
[oracle@ora02 19c]$ cd /soft/35326279/
[oracle@ora02 35326279]$
[oracle@ora02 35326279]$ ll
total 8
drwxr-x--- 3 oracle oinstall 20 Apr 28 00:58 etc
drwxr-x--- 8 oracle oinstall 4096 Apr 28 00:58 files
[oracle@ora02 35326279]$ $ORACLE_HOME/OPatch/opatch apply
Oracle Interim Patch Installer version 12.2.0.1.36
Copyright (c) 2023, Oracle Corporation. All rights reserved.
Oracle Home : /ogg/19c
Central Inventory : /u01/app/oraInventory
from : /ogg/19c/oraInst.loc
OPatch version : 12.2.0.1.36
OUI version : 12.2.0.4.0
Log file location : /ogg/19c/cfgtoollogs/opatch/opatch2023-06-27_16-36-16PM_1.log
Verifying environment and performing prerequisite checks...
OPatch continues with these patches: 35326279
Do you want to proceed? [y|n]
y
User Responded with: Y
All checks passed.
Please shutdown Oracle instances running out of this ORACLE_HOME on the local system.
(Oracle Home = '/ogg/19c')
Is the local system ready for patching? [y|n]
y
User Responded with: Y
Backing up files...
Applying interim patch '35326279' to OH '/ogg/19c'
Patching component oracle.oggcore.ora19c, 19.1.0.0.0...
Patch 35326279 successfully applied.
Log file location: /ogg/19c/cfgtoollogs/opatch/opatch2023-06-27_16-36-16PM_1.log
OPatch succeeded.
[oracle@ora02 35326279]$ $ORACLE_HOME/OPatch/opatch lspatches
35326279;
OPatch succeeded.
[oracle@ora02 35326279]$ cd /ogg/19c
[oracle@ora02 19c]$ ./ggsci
Oracle GoldenGate Command Interpreter for Oracle
Version 19.1.0.0.230422 OGGCORE_19.1.0.0.0OGGBP_PLATFORMS_230423.0822_FBO
Linux, x64, 64bit (optimized), Oracle 19c on Apr 24 2023 04:25:55
Operating system character set identified as UTF-8.
Copyright (C) 1995, 2023, Oracle and/or its affiliates. All rights reserved.
GGSCI (ora02) 1> info all
Program Status Group Lag at Chkpt Time Since Chkpt
MANAGER STOPPED
EXTRACT STOPPED C1 00:00:00 44:27:02
EXTRACT STOPPED D1 00:00:00 44:26:59
EXTRACT STOPPED E1 00:00:00 00:19:31
EXTRACT STOPPED P1 00:00:00 00:19:31
GGSCI (ora02) 2> start mgr
Manager started.
GGSCI (ora02) 3> info all
Program Status Group Lag at Chkpt Time Since Chkpt
MANAGER RUNNING
EXTRACT STOPPED C1 00:00:00 44:27:06
EXTRACT STOPPED D1 00:00:00 44:27:04
EXTRACT STOPPED E1 00:00:00 00:19:36
EXTRACT STOPPED P1 00:00:00 00:19:35
GGSCI (ora02) 4> start e1
Sending START request to MANAGER ...
EXTRACT E1 starting
GGSCI (ora02) 5> start p1
Sending START request to MANAGER ...
EXTRACT P1 starting
GGSCI (ora02) 6> info all
Program Status Group Lag at Chkpt Time Since Chkpt
MANAGER RUNNING
EXTRACT STOPPED C1 00:00:00 44:27:13
EXTRACT STOPPED D1 00:00:00 44:27:10
EXTRACT STOPPED E1 00:00:00 00:19:42
EXTRACT RUNNING P1 00:00:00 00:19:41
GGSCI (ora02) 7> info all
Program Status Group Lag at Chkpt Time Since Chkpt
MANAGER RUNNING
EXTRACT STOPPED C1 00:00:00 44:27:16
EXTRACT STOPPED D1 00:00:00 44:27:13
EXTRACT STOPPED E1 00:00:00 00:19:45
EXTRACT RUNNING P1 00:00:00 00:19:44
GGSCI (ora02) 8> info all
Program Status Group Lag at Chkpt Time Since Chkpt
MANAGER RUNNING
EXTRACT STOPPED C1 00:00:00 44:27:20
EXTRACT STOPPED D1 00:00:00 44:27:17
EXTRACT STOPPED E1 00:00:00 00:19:49
EXTRACT RUNNING P1 00:00:00 00:00:03
GGSCI (ora02) 9> view report e1
***********************************************************************
Oracle GoldenGate Capture for Oracle
Version 19.1.0.0.230422 OGGCORE_19.1.0.0.0OGGBP_PLATFORMS_230423.0822_FBO
Linux, x64, 64bit (optimized), Oracle 19c on Apr 24 2023 04:27:16
Copyright (C) 1995, 2023, Oracle and/or its affiliates. All rights reserved.
Starting at 2023-06-27 16:40:05
***********************************************************************
Operating System Version:
Linux
Version #2 SMP Fri Apr 23 09:05:55 PDT 2021, Release 5.4.17-2102.201.3.el7uek.x86_64
Node: ora02
Machine: x86_64
soft limit hard limit
Address Space Size : unlimited unlimited
Heap Size : unlimited unlimited
File Size : unlimited unlimited
CPU Time : unlimited unlimited
Process id: 9103
Description:
***********************************************************************
** Running with the following parameters **
***********************************************************************
2023-06-27 16:40:05 INFO OGG-03059 Operating system character set identified as UTF-8.
2023-06-27 16:40:05 INFO OGG-02695 ANSI SQL parameter syntax is used for parameter parsing.
2023-06-27 16:40:05 INFO OGG-01360 EXTRACT is running in Integrated mode.
Source Context :
SourceModule : [er.init]
SourceID : [er/init.cpp]
SourceMethod : [get_infile_params]
SourceLine : [4491]
ThreadBacktrace : [11] elements
: [/ogg/19c/libgglog.so(CMessageContext::AddThreadContext())]
: [/ogg/19c/libgglog.so(CMessageFactory::CreateMessage(CSourceContext*, unsigned int,
...))]
: [/ogg/19c/libgglog.so(_MSG_String(CSourceContext*, int, char const*, CMessageFactory
::MessageDisposition))]
: [/ogg/19c/extract()]
: [/ogg/19c/extract()]
: [/ogg/19c/extract(ggs::gglib::MultiThreading::MainThread::ExecMain())]
: [/ogg/19c/extract(ggs::gglib::MultiThreading::Thread::RunThread(ggs::gglib::MultiThr
eading::Thread::ThreadArgs*))]
: [/ogg/19c/extract(ggs::gglib::MultiThreading::MainThread::Run(int, char**))]
: [/ogg/19c/extract(main)]
: [/lib64/libc.so.6(__libc_start_main)]
: [/ogg/19c/extract()]
2023-06-27 16:40:05 ERROR OGG-00303 Extract failed to login to the database as user c##oggadmin specified in
the MININGUSER parameter because of error Error while trying to retrieve text for error ORA-01804.
2023-06-27 16:40:05 ERROR OGG-01668 PROCESS ABENDING.
GGSCI (ora02) 10> view param e1
EXTRACT e1
USERIDALIAS jyc
TRANLOGOPTIONS MININGUSERALIAS mid
TRANLOGOPTIONS INTEGRATEDPARAMS (downstream_real_time_mine Y)
EXTTRAIL ./dirdat/e1
DBOPTIONS ALLOWUNUSEDCOLUMN
GETTRUNCATES
UPDATERECORDFORMAT FULL
fetchoptions nousesnapshot
fetchoptions fetchpkupdatecols
SOURCECATALOG jycdb
TABLE jyc.*;
GGSCI (ora02) 11> dblogin USERIDALIAS jyc
ERROR: Failed to initialize timezone information. Check location of ORACLE_HOME..
此时发现忘记还原database的ORACLE_HOME了，重新进入oracle用户环境变量/u01/app/oracle/product/19.3.0/db_1
GGSCI (ora02) 12> exit
[oracle@ora02 19c]$ exit
logout
[root@ora02 ~]# su - oracle
Last login: Tue Jun 27 16:35:09 CST 2023 on pts/1
[oracle@ora02 ~]$ echo $ORACLE_HOME
/u01/app/oracle/product/19.3.0/db_1
[oracle@ora02 ~]$ cd /ogg/19c
[oracle@ora02 19c]$ ./ggsci
Oracle GoldenGate Command Interpreter for Oracle
Version 19.1.0.0.230422 OGGCORE_19.1.0.0.0OGGBP_PLATFORMS_230423.0822_FBO
Linux, x64, 64bit (optimized), Oracle 19c on Apr 24 2023 04:25:55
Operating system character set identified as UTF-8.
Copyright (C) 1995, 2023, Oracle and/or its affiliates. All rights reserved.
GGSCI (ora02) 1> info all
Program Status Group Lag at Chkpt Time Since Chkpt
MANAGER RUNNING
EXTRACT STOPPED C1 00:00:00 44:30:09
EXTRACT STOPPED D1 00:00:00 44:30:07
EXTRACT STOPPED E1 00:00:00 00:22:39
EXTRACT RUNNING P1 00:00:00 00:00:02
GGSCI (ora02) 2> start e1
Sending START request to MANAGER ...
EXTRACT E1 starting
GGSCI (ora02) 3> info all
Program Status Group Lag at Chkpt Time Since Chkpt
MANAGER RUNNING
EXTRACT STOPPED C1 00:00:00 44:30:13
EXTRACT STOPPED D1 00:00:00 44:30:10
EXTRACT STOPPED E1 00:00:00 00:22:42
EXTRACT RUNNING P1 00:00:00 00:00:06
GGSCI (ora02) 4> view report e1
***********************************************************************
Oracle GoldenGate Capture for Oracle
Version 19.1.0.0.230422 OGGCORE_19.1.0.0.0OGGBP_PLATFORMS_230423.0822_FBO
Linux, x64, 64bit (optimized), Oracle 19c on Apr 24 2023 04:27:16
Copyright (C) 1995, 2023, Oracle and/or its affiliates. All rights reserved.
Starting at 2023-06-27 16:43:08
***********************************************************************
Operating System Version:
Linux
Version #2 SMP Fri Apr 23 09:05:55 PDT 2021, Release 5.4.17-2102.201.3.el7uek.x86_64
Node: ora02
Machine: x86_64
soft limit hard limit
Address Space Size : unlimited unlimited
Heap Size : unlimited unlimited
File Size : unlimited unlimited
CPU Time : unlimited unlimited
Process id: 9284
Description:
***********************************************************************
** Running with the following parameters **
***********************************************************************
2023-06-27 16:43:08 INFO OGG-03059 Operating system character set identified as UTF-8.
2023-06-27 16:43:08 INFO OGG-02695 ANSI SQL parameter syntax is used for parameter parsing.
2023-06-27 16:43:08 INFO OGG-01360 EXTRACT is running in Integrated mode.
Source Context :
SourceModule : [er.init]
SourceID : [er/init.cpp]
SourceMethod : [get_infile_params]
SourceLine : [4491]
ThreadBacktrace : [11] elements
: [/ogg/19c/libgglog.so(CMessageContext::AddThreadContext())]
: [/ogg/19c/libgglog.so(CMessageFactory::CreateMessage(CSourceContext*, unsigned int,
...))]
: [/ogg/19c/libgglog.so(_MSG_String(CSourceContext*, int, char const*, CMessageFactory
::MessageDisposition))]
: [/ogg/19c/extract()]
: [/ogg/19c/extract()]
: [/ogg/19c/extract(ggs::gglib::MultiThreading::MainThread::ExecMain())]
: [/ogg/19c/extract(ggs::gglib::MultiThreading::Thread::RunThread(ggs::gglib::MultiThr
eading::Thread::ThreadArgs*))]
: [/ogg/19c/extract(ggs::gglib::MultiThreading::MainThread::Run(int, char**))]
: [/ogg/19c/extract(main)]
: [/lib64/libc.so.6(__libc_start_main)]
: [/ogg/19c/extract()]
2023-06-27 16:43:08 ERROR OGG-00303 Extract failed to login to the database as user c##oggadmin specified in
the MININGUSER parameter because of error Error while trying to retrieve text for error ORA-01804.
2023-06-27 16:43:08 ERROR OGG-01668 PROCESS ABENDING.
GGSCI (ora02) 5> view param e1
EXTRACT e1
USERIDALIAS jyc
TRANLOGOPTIONS MININGUSERALIAS mid
TRANLOGOPTIONS INTEGRATEDPARAMS (downstream_real_time_mine Y)
EXTTRAIL ./dirdat/e1
DBOPTIONS ALLOWUNUSEDCOLUMN
GETTRUNCATES
UPDATERECORDFORMAT FULL
fetchoptions nousesnapshot
fetchoptions fetchpkupdatecols
SOURCECATALOG jycdb
TABLE jyc.*;
GGSCI (ora02) 6> dblogin USERIDALIAS jyc
Successfully logged into database CDB$ROOT.
GGSCI (ora02 as c##oggadmin@jyc/CDB$ROOT) 7> dblogin MININGUSERALIAS mid
ERROR: Unrecognized parameter (MININGUSERALIAS), expected USERID/USERIDALIAS.
GGSCI (ora02) 8> MININGDBLOGIN USERIDALIAS mid
Successfully logged into mining database.
GGSCI (ora02) 9> info all
Program Status Group Lag at Chkpt Time Since Chkpt
MANAGER RUNNING
EXTRACT STOPPED C1 00:00:00 44:32:08
EXTRACT STOPPED D1 00:00:00 44:32:05
EXTRACT STOPPED E1 00:00:00 00:24:37
EXTRACT RUNNING P1 00:00:00 00:00:01
GGSCI (ora02) 10> start e1
Sending START request to MANAGER ...
EXTRACT E1 starting
GGSCI (ora02) 11> info all
Program Status Group Lag at Chkpt Time Since Chkpt
MANAGER RUNNING
EXTRACT STOPPED C1 00:00:00 44:32:12
EXTRACT STOPPED D1 00:00:00 44:32:10
EXTRACT STOPPED E1 00:00:00 00:24:42
EXTRACT RUNNING P1 00:00:00 00:00:05
GGSCI (ora02) 12> view report e1
***********************************************************************
Oracle GoldenGate Capture for Oracle
Version 19.1.0.0.230422 OGGCORE_19.1.0.0.0OGGBP_PLATFORMS_230423.0822_FBO
Linux, x64, 64bit (optimized), Oracle 19c on Apr 24 2023 04:27:16
Copyright (C) 1995, 2023, Oracle and/or its affiliates. All rights reserved.
Starting at 2023-06-27 16:45:07
***********************************************************************
Operating System Version:
Linux
Version #2 SMP Fri Apr 23 09:05:55 PDT 2021, Release 5.4.17-2102.201.3.el7uek.x86_64
Node: ora02
Machine: x86_64
soft limit hard limit
Address Space Size : unlimited unlimited
Heap Size : unlimited unlimited
File Size : unlimited unlimited
CPU Time : unlimited unlimited
Process id: 9393
Description:
***********************************************************************
** Running with the following parameters **
***********************************************************************
2023-06-27 16:45:07 INFO OGG-03059 Operating system character set identified as UTF-8.
2023-06-27 16:45:07 INFO OGG-02695 ANSI SQL parameter syntax is used for parameter parsing.
2023-06-27 16:45:07 INFO OGG-01360 EXTRACT is running in Integrated mode.
Source Context :
SourceModule : [er.init]
SourceID : [er/init.cpp]
SourceMethod : [get_infile_params]
SourceLine : [4491]
ThreadBacktrace : [11] elements
: [/ogg/19c/libgglog.so(CMessageContext::AddThreadContext())]
: [/ogg/19c/libgglog.so(CMessageFactory::CreateMessage(CSourceContext*, unsigned int,
...))]
: [/ogg/19c/libgglog.so(_MSG_String(CSourceContext*, int, char const*, CMessageFactory
::MessageDisposition))]
: [/ogg/19c/extract()]
: [/ogg/19c/extract()]
: [/ogg/19c/extract(ggs::gglib::MultiThreading::MainThread::ExecMain())]
: [/ogg/19c/extract(ggs::gglib::MultiThreading::Thread::RunThread(ggs::gglib::MultiThr
eading::Thread::ThreadArgs*))]
: [/ogg/19c/extract(ggs::gglib::MultiThreading::MainThread::Run(int, char**))]
: [/ogg/19c/extract(main)]
: [/lib64/libc.so.6(__libc_start_main)]
: [/ogg/19c/extract()]
2023-06-27 16:45:07 ERROR OGG-00303 Extract failed to login to the database as user c##oggadmin specified in
the MININGUSER parameter because of error Error while trying to retrieve text for error ORA-01804.
2023-06-27 16:45:07 ERROR OGG-01668 PROCESS ABENDING.
GGSCI (ora02) 14> info all
Program Status Group Lag at Chkpt Time Since Chkpt
MANAGER RUNNING
EXTRACT STOPPED C1 00:00:00 44:37:46
EXTRACT STOPPED D1 00:00:00 44:37:44
EXTRACT STOPPED E1 00:00:00 00:30:16
EXTRACT RUNNING P1 00:00:00 00:00:09
发现还不好使，原来需要停止全部ogg进程，重新启动解决。
参考：GG Extract On Downstream Database Abends With ERROR OGG-00303 : Extract failed to login to the database as user cataog-name.nppoggmin specified in the MININGUSER parameter because of error ORA-0180 (Doc ID 2447522.1)
GGSCI (ora02) 15> 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 ...
Request processed.
info allManager stopped.
GGSCI (ora02) 16>
Program Status Group Lag at Chkpt Time Since Chkpt
MANAGER STOPPED
EXTRACT STOPPED C1 00:00:00 44:37:54
EXTRACT STOPPED D1 00:00:00 44:37:52
EXTRACT STOPPED E1 00:00:00 00:30:24
EXTRACT RUNNING P1 00:00:00 00:00:07
GGSCI (ora02) 17> stop p1
Sending STOP request to EXTRACT P1 ...
Request processed.
GGSCI (ora02) 18> info all
Program Status Group Lag at Chkpt Time Since Chkpt
MANAGER STOPPED
EXTRACT STOPPED C1 00:00:00 44:38:02
EXTRACT STOPPED D1 00:00:00 44:37:59
EXTRACT STOPPED E1 00:00:00 00:30:31
EXTRACT STOPPED P1 00:00:00 00:00:05
GGSCI (ora02) 19> start mgr
Manager started.
GGSCI (ora02) 20> start e1
Sending START request to MANAGER ...
EXTRACT E1 starting
GGSCI (ora02) 21> start p1
Sending START request to MANAGER ...
EXTRACT P1 starting
GGSCI (ora02) 22> info all
Program Status Group Lag at Chkpt Time Since Chkpt
MANAGER RUNNING
EXTRACT STOPPED C1 00:00:00 44:38:26
EXTRACT STOPPED D1 00:00:00 44:38:23
EXTRACT RUNNING E1 00:00:00 00:30:55
EXTRACT RUNNING P1 00:00:00 00:00:29
GGSCI (ora02) 23> info all
Program Status Group Lag at Chkpt Time Since Chkpt
MANAGER RUNNING
EXTRACT STOPPED C1 00:00:00 44:38:28
EXTRACT STOPPED D1 00:00:00 44:38:26
EXTRACT RUNNING E1 00:00:00 00:30:57
EXTRACT RUNNING P1 00:00:00 00:00:31
GGSCI (ora02) 24> info all
Program Status Group Lag at Chkpt Time Since Chkpt
MANAGER RUNNING
EXTRACT STOPPED C1 00:00:00 44:38:30
EXTRACT STOPPED D1 00:00:00 44:38:27
EXTRACT RUNNING E1 00:00:00 00:30:59
EXTRACT RUNNING P1 00:00:00 00:00:00
GGSCI (ora02) 25> view report e1
***********************************************************************
Oracle GoldenGate Capture for Oracle
Version 19.1.0.0.230422 OGGCORE_19.1.0.0.0OGGBP_PLATFORMS_230423.0822_FBO
Linux, x64, 64bit (optimized), Oracle 19c on Apr 24 2023 04:27:16
Copyright (C) 1995, 2023, Oracle and/or its affiliates. All rights reserved.
Starting at 2023-06-27 16:51:19
***********************************************************************
Operating System Version:
Linux
Version #2 SMP Fri Apr 23 09:05:55 PDT 2021, Release 5.4.17-2102.201.3.el7uek.x86_64
Node: ora02
Machine: x86_64
soft limit hard limit
Address Space Size : unlimited unlimited
Heap Size : unlimited unlimited
File Size : unlimited unlimited
CPU Time : unlimited unlimited
Process id: 9733
Description:
***********************************************************************
** Running with the following parameters **
***********************************************************************
2023-06-27 16:51:19 INFO OGG-03059 Operating system character set identified as UTF-8.
2023-06-27 16:51:19 INFO OGG-02695 ANSI SQL parameter syntax is used for parameter parsing.
2023-06-27 16:51:19 INFO OGG-01360 EXTRACT is running in Integrated mode.
EXTRACT e1
USERIDALIAS jyc
TRANLOGOPTIONS MININGUSERALIAS mid
TRANLOGOPTIONS INTEGRATEDPARAMS (downstream_real_time_mine Y)
EXTTRAIL ./dirdat/e1
DBOPTIONS ALLOWUNUSEDCOLUMN
GETTRUNCATES
UPDATERECORDFORMAT FULL
fetchoptions nousesnapshot
fetchoptions fetchpkupdatecols
SOURCECATALOG jycdb
TABLE jyc.*;
2023-06-27 16:51:20 INFO OGG-02623 Default source catalog name jycdb will be used for source table name jyc
.* mapping.
2023-06-27 16:51:20 WARNING OGG-02735 No heartbeat table schema available. Heartbeat table is not enabled.
2023-06-27 16:51:20 INFO OGG-01815 Virtual Memory Facilities for: BR
anon alloc: mmap(MAP_ANON) anon free: munmap
file alloc: mmap(MAP_SHARED) file free: munmap
target directories:
/ogg/19c/BR/E1.
Bounded Recovery Parameter:
BRINTERVAL = 4HOURS
BRDIR = /ogg/19c/
2023-06-27 16:51:20 WARNING OGG-01568 br_validate_bcp: unsupported BR version: CP.E1.000000010: version expect
ed: 21050000001 version found: 12030001003.
2023-06-27 16:51:20 WARNING OGG-01573 br_validate_bcp: failed in call to: br_validate_bcp.
2023-06-27 16:51:20 WARNING OGG-01633 BOUNDED RECOVERY: NO VALID BCP FOUND: last file examined: CP.E1.00000001
0.
2023-06-27 16:51:20 WARNING OGG-01573 br_restore: failed in call to: br_validate_bcp.
2023-06-27 16:51:20 WARNING OGG-01862 BR RESTORE error. Standard Recovery will be used instead. Please contact
Oracle Support. Please keep the rpt file if possible.
2023-06-27 16:51:20 WARNING OGG-10019 BOUNDED RECOVERY: BR not being used for restore. Extract will revert to
normal recovery for this recovery and then turn on Bounded Recovery again.
2023-06-27 16:51:20 INFO OGG-01851 filecaching started: thread ID: 140198316001024.
2023-06-27 16:51:20 INFO OGG-01815 Virtual Memory Facilities for: COM
anon alloc: mmap(MAP_ANON) anon free: munmap
file alloc: mmap(MAP_SHARED) file free: munmap
target directories:
/ogg/19c/dirtmp.
2023-06-27 16:51:20 INFO OGG-25340
Database Version:
Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
Version 19.3.0.0.0.
2023-06-27 16:51:20 INFO OGG-25341
Database Language and Character Set:
NLS_LANGUAGE = "AMERICAN"
NLS_TERRITORY = "AMERICA"
NLS_CHARACTERSET = "AL32UTF8".
2023-06-27 16:51:21 INFO OGG-06604 Database JYC CPU info: CPU Count 2, CPU Core Count 2, CPU Socket Count 1
.
2023-06-27 16:51:21 INFO OGG-06618 Database JYC Platform: Linux x86 64-bit.
2023-06-27 16:51:21 INFO OGG-06604 Database MID CPU info: CPU Count 2, CPU Core Count 2, CPU Socket Count 1
.
2023-06-27 16:51:21 INFO OGG-06618 Database MID Platform: Linux x86 64-bit.
2023-06-27 16:51:25 WARNING OGG-02045 Database does not have streams_pool_size initialization parameter config
ured.
2023-06-27 16:51:26 INFO OGG-02248 Logmining server DDL filtering enabled.
2023-06-27 16:51:27 INFO OGG-02339 Integrated capture successfully attached to logmining server OGG$CAP_E1
using 60 second streaming duration.
2023-06-27 16:51:27 INFO OGG-02089 Source redo compatibility version is: 19.0.0.
2023-06-27 16:51:27 INFO OGG-02086 Integrated Dictionary will be used.
2023-06-27 16:51:28 WARNING OGG-02905 Replication of OID column in object tables may diverge.
2023-06-27 16:51:28 INFO OGG-02776 Native data capture is enabled for Oracle NUMBER data type.
2023-06-27 16:51:28 INFO OGG-01971 The previous message, 'INFO OGG-02776', repeated 1 times.
2023-06-27 16:51:28 INFO OGG-01055 Recovery initialization completed for target file ./dirdat/e1000000013,
at RBA 3133.
2023-06-27 16:51:28 INFO OGG-01478 Output file ./dirdat/e1 is using format RELEASE 19.1.
2023-06-27 16:51:28 INFO OGG-02776 Native data capture is enabled for Oracle NUMBER data type.
2023-06-27 16:51:28 INFO OGG-01026 Rolling over remote file ./dirdat/e1000000013.
2023-06-27 16:51:28 INFO OGG-01053 Recovery completed for target file ./dirdat/e1000000014, at RBA 1337.
2023-06-27 16:51:28 INFO OGG-01057 Recovery completed for all targets.
***********************************************************************
** Run Time Messages **
***********************************************************************
GGSCI (ora02) 26> info all
Program Status Group Lag at Chkpt Time Since Chkpt
MANAGER RUNNING
EXTRACT STOPPED C1 00:00:00 44:38:40
EXTRACT STOPPED D1 00:00:00 44:38:37
EXTRACT RUNNING E1 00:00:00 00:00:08
EXTRACT RUNNING P1 00:00:00 00:00:09
GGSCI (ora02) 27> info all
Program Status Group Lag at Chkpt Time Since Chkpt
MANAGER RUNNING
EXTRACT STOPPED C1 00:00:00 44:42:05
EXTRACT STOPPED D1 00:00:00 44:42:02
EXTRACT RUNNING E1 00:00:00 00:00:04
EXTRACT RUNNING P1 00:00:00 00:00:04
GGSCI (ora02) 28>
GGSCI (ora02) 28>
GGSCI (ora02) 28> info all
Program Status Group Lag at Chkpt Time Since Chkpt
MANAGER RUNNING
EXTRACT STOPPED C1 00:00:00 44:43:16
EXTRACT STOPPED D1 00:00:00 44:43:13
EXTRACT RUNNING E1 00:00:00 00:00:04
EXTRACT RUNNING P1 00:00:00 00:00:05
GGSCI (ora02) 29>
参考文档：
GG Extract On Downstream Database Abends With ERROR OGG-00303 : Extract failed to login to the database as user cataog-name.nppoggmin specified in the MININGUSER parameter because of error ORA-0180 (Doc ID 2447522.1)
Oracle GoldenGate - Version 12.2.0.1.0 and later
Information in this document applies to any platform.
SYMPTOMS
Goldengate on downstream database :
While restarting the Extract below error is received:
2018-09-16T01:30:57.194AEST ERROR OGG-00303 Oracle GoldenGate Capture for Oracle,xxxx.prm: Extract failed to login to the database as user cataog-name.nppoggmin specified in the MININGUSER parameter because of error Error while trying to retrieve text for error ORA-0180
CAUSE
Manager intermittently doesn't allow GG process to connect to db.
SOLUTION
1. Stop all the extracts and replicat running on that server.
2. Stop the manager process.
3. Exit ggsci.
4. Login back to ggsci.
5. Start manager.
6. Start the extract.
「喜欢这篇文章，您的关注和赞赏是给作者最好的鼓励」
关注作者
【版权声明】本文为墨天轮用户原创内容，转载时必须标注文章的来源（墨天轮），文章链接，文章作者等基本信息，否则作者和墨天轮有权追究责任。如果您发现墨天轮中有涉嫌抄袭或者侵权的内容，欢迎发送邮件至：contact@modb.pro进行举报，并提供相关证据，一经查实，墨天轮将立刻删除相关内容。
