Create a gold image for 19c Oracle Database Software Home

Creating a gold image of 19c Oracle Database software with below command. Please note you would need sufficient amount of disk space before you begin, for a 9905899041 byte file it required almost 76 GB space for me to make it available on the file system, in one of my other post i had explained how to extend rhel7 file systems at run time online with root user :

[oracle@rhel7 ~]$ $ORACLE_HOME/runInstaller -silent  -createGoldImage -destinationLocation /u01/software/19c_dbhome
Launching Oracle Database Setup Wizard...

[FATAL] [INS-32707] The specified destination location (/u01/software/19c_dbhome) does not have enough free space.
   ACTION: Provide a destination location path with at least (76,112) MB of free space.

So once the space was made available i was able to make the gold image from the software home

[oracle@rhel7 ~]$ $ORACLE_HOME/runInstaller -silent  -createGoldImage -destinationLocation /u01/software/19c_dbhome
Launching Oracle Database Setup Wizard...

......

.................

.................................
Successfully Setup Software.
Gold Image location: /u01/software/19c_dbhome/db_home_2020-07-14_09-15-53PM.zip

OGYatra 2020 Oracle Events of All India Oracle Users Group (AIOUG)

The biggest Oracle User group conference is here from AIOUG https://www.aioug.org/ogyatra

The Oracle Groundbreakers / Oracle ACEs/ Oracle User Group Evangelists in the region are organizing an event called ‘Oracle Groundbreakers Yatra’ during the month of July 2020. India is a primary hub for information technology and a station for most software development centers and support centers for Oracle applications. Oracle community in India comprises of several 400000 users. In a large country like India, such user concentration is not in one location or one IT park but spread across its length and breadth.

The health of All India Oracle Users Community (AIOUG) is our primary concern. Considering global precautions for the COVID-19 Coronavirus, and building upon recommendations from the World Health Organization, AIOUG is taking a new approach to its Oracle Groundbreaker Yatra event. The event is a highly concentrated 15-day collaboration and transformation while providing the deep technical education needed for our Indian Oracle Community.

Join us Yatra and meet industry Gurus /celebrities. You will be able to acquire knowledge directs from the experts and get a deep dive into different skill areas.

Highlights:

• Global Webinar Series covering APAC, EMEA, AMS
• 14 days, 125+ hours of learning and networking
• 100+ Sessions, 100+ Speakers from 25+ Countries
• 60+ Oracle ACE community Speakers
• 7+ Hands-on Lab Sessions
• 5+ Master Classes
• 7 Tracks & No. of sessions
  • Database (DBA) – 32
  • Applications – 8
  • Analytics – 8
  • Future Technology - 8
  • Cloud - 8 
  • Java – 8
  • Community Sessions – 16
• Keynote, Interviews, and many more...

Register for FREE and Secure Your Seat! Hurry Up! We have Limited Place!!

Registration: 3 simple steps to register

1. Go to https://www.aioug.org/join page and join the AIOUG FREE membership
2. Log in and go to https://www.aioug.org/ogyatra page  
3. Check the schedule and register your favorite session(s). 

How to Join the Webinars:
Login to the AIOUG website and Go to https://www.aioug.org/ogyatra page and join the webinar 10 minutes before the actual time.

Who should attend?
If you are working with Oracle Database & Application in any aspect of Administration, Development this is a must-attend event for you. In the event, you get to meet and learn from the Oracle experts around the world at a single place. You discuss, ask questions, socialize, share knowledge, and meet fellow Oracle enthusiasts.  The event will be led on multiple tracks to target all the professionals at all levels to make the most of the event. Do you want more? It doesn’t stop there. You can meet and discuss with the Oracle experts out of the sessions after hours if you are not satisfied with the daylong sessions. 

Oracle Database Administrator, Developers, Technical Consultants, Functional Consultants, Data Scientists, System Administrator, Architects, Middleware Administrators, Operations Manager, Application Managers, Business Analysts

Reasons to Attend?

1. Be part of Yatra - Your one-stop shop for knowledge on Oracle where you can learn from experts from around the globe.
2. Build your network - A not-to-be-missed opportunity to meet in-person with your Oracle experts from across continents community with countless networking opportunities, you'll get to share thoughts and hear success stories all in person.
3. Learn best practices - Learn how to make the best of Oracle
4. Carry back the knowledge - Return from this conference with the confidence in knowledge gain that you can apply right back to your work. With the knowledge, you gain you can retrain your colleagues and showcase the best you can do with Oracle.
5. To expand your knowledge and get the answers you need all in Yatra
6. Share the knowledge - Meet the fellow Oracle folks and share your knowledge in various discussions in a session or over a coffee in the hallway. There is no restriction on where you talk about what you know or what you want to learn

Heartbeat table in Oracle Goldengate

Managing heartbeat in goldengate is important specially when it comes to monitor the lag and the heartbeat, this post covers how to add a heartbeat table at target, clean it up and reconfigure the heartbeat table

GGSCI (rhel7.example.com as ggadmin@euro) 3> add heartbeattable

2020-07-13 00:22:30  INFO    OGG-14001  Successfully created heartbeat seed table ""GGADMIN"."GG_HEARTBEAT_SEED"".

2020-07-13 00:22:30  INFO    OGG-14089  Successfully tracking extract restart position with heartbeat table ""GGADMIN"."GG_HEARTBEAT_SEED"".

2020-07-13 00:22:30  INFO    OGG-14032  Successfully added supplemental logging for heartbeat seed table ""GGADMIN"."GG_HEARTBEAT_SEED"".

2020-07-13 00:22:30  INFO    OGG-14000  Successfully created heartbeat table ""GGADMIN"."GG_HEARTBEAT"".

2020-07-13 00:22:30  INFO    OGG-14089  Successfully tracking extract restart position with heartbeat table ""GGADMIN"."GG_HEARTBEAT"".

2020-07-13 00:22:30  INFO    OGG-14033  Successfully added supplemental logging for heartbeat table ""GGADMIN"."GG_HEARTBEAT"".

2020-07-13 00:22:30  INFO    OGG-14016  Successfully created heartbeat history table ""GGADMIN"."GG_HEARTBEAT_HISTORY"".

2020-07-13 00:22:30  INFO    OGG-14089  Successfully tracking extract restart position with heartbeat table ""GGADMIN"."GG_HEARTBEAT_HISTORY"".

2020-07-13 00:22:30  INFO    OGG-14086  Successfully disabled partitioning for heartbeat history table ""GGADMIN"."GG_HEARTBEAT_HISTORY"".

2020-07-13 00:22:30  INFO    OGG-14023  Successfully created heartbeat lag view ""GGADMIN"."GG_LAG"".

2020-07-13 00:22:30  INFO    OGG-14024  Successfully created heartbeat lag history view ""GGADMIN"."GG_LAG_HISTORY"".

2020-07-13 00:22:30  INFO    OGG-14003  Successfully populated heartbeat seed table with "EURO".

2020-07-13 00:22:31  INFO    OGG-14004  Successfully created procedure ""GGADMIN"."GG_UPDATE_HB_TAB"" to update the heartbeat tables.

2020-07-13 00:22:31  INFO    OGG-14017  Successfully created procedure ""GGADMIN"."GG_PURGE_HB_TAB"" to purge the heartbeat history table.

2020-07-13 00:22:31  INFO    OGG-14005  Successfully created scheduler job ""GGADMIN"."GG_UPDATE_HEARTBEATS"" to update the heartbeat tables.

2020-07-13 00:22:31  INFO    OGG-14018  Successfully created scheduler job ""GGADMIN"."GG_PURGE_HEARTBEATS"" to purge the heartbeat history table.


GGSCI (rhel7.example.com as ggadmin@euro) 2> delete heartbeattable

2020-07-13 00:22:25  INFO    OGG-14007  Heartbeat seed table ""GGADMIN"."GG_HEARTBEAT_SEED"" dropped.

2020-07-13 00:22:25  INFO    OGG-14009  Heartbeat table ""GGADMIN"."GG_HEARTBEAT"" dropped.

2020-07-13 00:22:25  INFO    OGG-14011  Heartbeat history table ""GGADMIN"."GG_HEARTBEAT_HISTORY"" dropped.

2020-07-13 00:22:25  INFO    OGG-14026  Heartbeat lag view ""GGADMIN"."GG_LAG"" dropped.

2020-07-13 00:22:25  INFO    OGG-14028  Heartbeat lag history view ""GGADMIN"."GG_LAG_HISTORY"" dropped.

2020-07-13 00:22:25  INFO    OGG-14013  Procedure ""GGADMIN"."GG_UPDATE_HB_TAB"" dropped.

2020-07-13 00:22:25  INFO    OGG-14020  Procedure ""GGADMIN"."GG_PURGE_HB_TAB"" dropped.

2020-07-13 00:22:25  INFO    OGG-14015  Scheduler job ""GGADMIN"."GG_UPDATE_HEARTBEATS"" dropped.

2020-07-13 00:22:25  INFO    OGG-14022  Scheduler job ""GGADMIN"."GG_PURGE_HEARTBEATS"" dropped.

GGSCI (rhel7.example.com as ggadmin@euro) 3> add heartbeattable

2020-07-13 00:22:30  INFO    OGG-14001  Successfully created heartbeat seed table ""GGADMIN"."GG_HEARTBEAT_SEED"".

2020-07-13 00:22:30  INFO    OGG-14089  Successfully tracking extract restart position with heartbeat table ""GGADMIN"."GG_HEARTBEAT_SEED"".

2020-07-13 00:22:30  INFO    OGG-14032  Successfully added supplemental logging for heartbeat seed table ""GGADMIN"."GG_HEARTBEAT_SEED"".

2020-07-13 00:22:30  INFO    OGG-14000  Successfully created heartbeat table ""GGADMIN"."GG_HEARTBEAT"".

2020-07-13 00:22:30  INFO    OGG-14089  Successfully tracking extract restart position with heartbeat table ""GGADMIN"."GG_HEARTBEAT"".

2020-07-13 00:22:30  INFO    OGG-14033  Successfully added supplemental logging for heartbeat table ""GGADMIN"."GG_HEARTBEAT"".

2020-07-13 00:22:30  INFO    OGG-14016  Successfully created heartbeat history table ""GGADMIN"."GG_HEARTBEAT_HISTORY"".

2020-07-13 00:22:30  INFO    OGG-14089  Successfully tracking extract restart position with heartbeat table ""GGADMIN"."GG_HEARTBEAT_HISTORY"".

2020-07-13 00:22:30  INFO    OGG-14086  Successfully disabled partitioning for heartbeat history table ""GGADMIN"."GG_HEARTBEAT_HISTORY"".

2020-07-13 00:22:30  INFO    OGG-14023  Successfully created heartbeat lag view ""GGADMIN"."GG_LAG"".

2020-07-13 00:22:30  INFO    OGG-14024  Successfully created heartbeat lag history view ""GGADMIN"."GG_LAG_HISTORY"".

2020-07-13 00:22:30  INFO    OGG-14003  Successfully populated heartbeat seed table with "EURO".

2020-07-13 00:22:31  INFO    OGG-14004  Successfully created procedure ""GGADMIN"."GG_UPDATE_HB_TAB"" to update the heartbeat tables.

2020-07-13 00:22:31  INFO    OGG-14017  Successfully created procedure ""GGADMIN"."GG_PURGE_HB_TAB"" to purge the heartbeat history table.

2020-07-13 00:22:31  INFO    OGG-14005  Successfully created scheduler job ""GGADMIN"."GG_UPDATE_HEARTBEATS"" to update the heartbeat tables.

2020-07-13 00:22:31  INFO    OGG-14018  Successfully created scheduler job ""GGADMIN"."GG_PURGE_HEARTBEATS"" to purge the heartbeat history table.