GoldenGate integrated Extract gives to dbas powerful tool to check GoldenGate’s operation in database, this package can be found to download on Doc ID 1448324.1.
This Healthcheck is similar AWR reports and it been very useful to find some error or bottleneck.
Tool give some advices and parameter tips.
Let’s check my lab HC topics
Environment overview:
Performance tips:
This HC uses system views created by OGG, so you can customize you own HC 🙂
Maiquel.
Hi!
A few months ago I watched a very good webinar about Oracle Licensing, by Rimini Street. And I found the link for this presetation again! 😀
It’s about 1 hour, take a look:
Sometimes GoldenGate EXTRACT capture long transactions from database and could be some B.O.F.H making DUMMY, if it’s the case, it’s a ‘UNWANTED’ transaction, and can skip it on ggsci:
(GUARANTEED DATA LOSS – db transaction skipped)
GGSCI (cloud-db) 60> send ext2 showtrans Sending SHOWTRANS request to EXTRACT EXT2 ... Oldest redo log files necessary to restart Extract are: Redo Thread 1, Redo Log Sequence Number 20322, SCN 1661.3085726936 (7137026405592), RBA 597023248 ------------------------------------------------------------ XID: 2049.13.3951869 Items: 1 Extract: EXT2 Redo Thread: 1 Start Time: 2016-11-07:15:22:07 SCN: 1661.3085726936 (7137026405592) Redo Seq: 20322 Redo RBA: 597023248 Status: Running ------------------------------------------------------------
GGSCI (cloud-db) 62> send ext2 SKIPTRANS 2049.13.3951869 THREAD 1 Sending SKIPTRANS request to EXTRACT EXT2 ... Are you sure you sure you want to skip transaction [XID 2049.13.3951869, Redo Thread 1, Start Time 2016-11-07:15:22:07, SCN 1661.3085726936 (7137026405592)]? (y/n)y Sending SKIPTRANS request to EXTRACT EXT2 ... Transaction [XID 2049.13.3951869, Redo Thread 1, Start Time 2016-11-07:15:22:07, SCN 1661.3085726936 (7137026405592)] skipped.
Check your applications and kill it in the database 🙂
Maiquel.
I checked strange coincidence during GoldenGate Director monitoring failure and GoldenGate Manager messages.
During GoldenGate operation, it append never-ending failure messages bellow, however, none GoldenGate proccess change to “ABBENDED” status
2016-10-26 08:47:28 ERROR OGG-01224 Oracle GoldenGate Command Interpreter for Oracle: Bad file number. 2016-10-26 08:47:29 ERROR OGG-01668 Oracle GoldenGate Command Interpreter for Oracle: PROCESS ABENDING.
It’s caused by GoldenGate logfile size ( ggserr.log), so correct with this:
grepora-gg@machine oracle$ cp ggserr.log ggserr.log-err-temp-log && > ggserr.log
It good idea stop manager proccess (if it’s possible) before truncate log file.
Keep this in mind 😉
Maiquel.
Sometimes it’s necessary to restart GoldenGate process, and after start GG Extract, it take’s long time ‘in recovery’ status.
It’ a interesting subject, and can be found here (before read below 🙂 ) .
GGSCI (greporagg) 16> send EXT status EXTRACT EXT (PID 23068830) Current status: In recovery[1]: Processing data Current read position: Redo thread #: 2 Sequence #: 4246 RBA: 223285824 Timestamp: 2016-10-08 07:32:36.000000 SCN: 1658.1839128718 Current write position: Sequence #: 29295 RBA: 74336127 Timestamp: 2016-10-14 17:59:43.476624 Extract Trail: ./dirdat/TR
So let’s check how to find transaction:
GGSCI (greporagg) 17> send EXT showtrans Sending SHOWTRANS request to EXTRACT EXT ... ------------------------------------------------------------ XID: 783.27.1959817 Items: 0 Extract: EXT Redo Thread: 4 Start Time: 2016-10-08:07:33:51 SCN: 1658.1839293825 (7122895070593) Redo Seq: 3388 Redo RBA: 224131088 Status: Running ------------------------------------------------------------
In database (dark) side:
SQL> select s.sid ,s.serial# ,s.username ,s.machine ,s.status ,s.lockwait ,t.used_ublk ,t.used_urec ,t.start_time ,t.XIDUSN ,t.XIDSLOT ,t.XIDSQN from gv$transaction t inner join gv$session s on t.addr = s.taddr order by start_time asc;
Maiquel.
This week, had a unexpected stop on Weblogic server after start this server it played a trick, it turns to refuse any telnet request on managed server port even localhost, however it was started successfully.
It’s so easy to resolve:
GGSCI (GoldenGate Software Command Interface) has some interesting shortcuts, quick, and good to use day-to-day GoldenGate.
My preferred:
Command history (h):
GGSCI (grepora) 4> h
GGSCI Command History
1: info all
2: shell tail -f ggserr.log
3: edit params extr
4: h
Was reading GoldenGate news, so found interesting video about Oracle Cloud and embedded GoldenGate configuration.
What nice news.
Full eBook avaliable here.
Reset the AdminServer Password in WebLogic 11g and 12c:
source $DOMAIN_HOME/bin/setDomainEnv.sh
cd $DOMAIN_HOME/servers/AdminServer/
mv data data-old
cd $DOMAIN_HOME/security
java weblogic.security.utils.AdminAccount weblogic NEW_PASSWORD .
Restart the AdminServer.
If the weblogic has the file boot.properties in $DOMAIN_HOME/servers/AdminServer/security/, should be adjusted the credentials of user and password, before restart the AdminServer.
OBS: Check the post on decrypt datasource password, which can also be used to decrypt the credentials of boot.properties file, avoiding making the above procedure, if this file exists.
That’s all for today.
Jackson.
In the latest post, I documented how to copy/move high table data volume using GoldenGate Initial Load (with SPECIALRUN option).
Sometimes, we (dba/sysadmins) need to move HIGH data (tables with billion rows), in shortest time possible.
So, sharing useful tips, that helps to reach this goal.
Making GoldenGate Initial load work as PARALLEL:
More“How to sincronize high data volume with GoldenGate – Part II”