Frequently Using GoldenGate(GG)19c Commands Part -3

By -

The following steps are applicable when setting up a GoldenGate MA archicture 

GoldenGate Environment Setup

Launch GGSCI

ggsci

Create required subdirectories (first-time only)

GGSCI> CREATE SUBDIRS

Create credential store (first-time only)

GGSCI> ADD CREDENTIALSTORE

Credential Store

Add user to credential store (source)

GGSCI> ALTER CREDENTIALSTORE ADD USER c##ggadmin@PDB19C PASSWORD

<Password> ALIAS ggadmin

Add user to credential store (target)

GGSCI> ALTER CREDENTIALSTORE ADD USER ggrep@myebspdb PASSWORD

<Password> ALIAS ggrep

Database Login

Login with alias

GGSCI> DBLOGIN USERIDALIAS ggadmin

Login to PDB with username/password

GGSCI> DBLOGIN USERID c##ggadmin@myebsapdb PASSWORD <Password>

Enable Supplemental Logging (per schema on source)

Add schematrandata for APPLSYS

GGSCI> ADD SCHEMATRANDATA "myebspdb".APPLSYS

Add schematrandata for CSI

GGSCI> ADD SCHEMATRANDATA "myebspdb".CSI

Add schematrandata for APPS

GGSCI> ADD SCHEMATRANDATA "myebspdb".APPS 

Extract (Source)

Register extract for PDB

GGSCI> REGISTER EXTRACT EXT19EBS, DATABASE CONTAINER("myebspdb")

Create integrated extract

GGSCI> ADD EXTRACT EXT19EBS, INTEGRATED TRANLOG, BEGIN NOW

Create local trail

GGSCI> ADD EXTTRAIL ./dirdat/eo, EXTRACT EXT19EBS, MEGABYTES 1000

Pump (Source)

Create pump tied to local trail

GGSCI> ADD EXTRACT PMP19EBS, EXTTRAILSOURCE ./dirdat/eo

Create remote trail for target

GGSCI> ADD RMTTRAIL ./dirdat/ro, EXTRACT PMP19EBS, MEGABYTES 1000

Target (Replicat & Tables)

Create checkpoint table

GGSCI> ADD CHECKPOINTTABLE ggrep.chkptab_gg19

Create integrated replicat

GGSCI> ADD REPLICAT REP19EBS, INTEGRATED, EXTRAIL ./dirdat/ro, CHECKPOINTTABLE ggrep.chkptab_gg19

Add heartbeat table on target only

GGSCI> ADD HEARTBEATTABLE, TARGETONLY

Health & Maintenance

Add heartbeat on source

GGSCI> ADD HEARTBEATTABLE

Show process status

GGSCI> INFO ALL

View lag

GGSCI> LAG EXTRACT EXT19EBS

GGSCI> LAG REPLICAT REP19EBS

View reports

GGSCI> VIEW REPORT EXT19EBS

GGSCI> VIEW REPORT REP19EBS

 

Reference: -

Deploying Oracle GoldenGate 19c to Achieve Operational Reporting for Oracle E-Business Suite Release 12 with Oracle Database 19c (KA1135)

Comments

Post a Comment

Popular posts from this blog

How to troubleshoot long running concurrent request in R12.2

By -
We frequently encounter issues with concurrent programs running long and concurrent requests not picking up jobs. These problems are often expected from the development and functional team we need to address this issue To solve this, we should take the following steps: Collect below basis level of information to development team 1 Oracle seeded program/Custom program? 2 How much time it used earlier? 3 Is there any recent code change done in concurrent program? 4 Is this program fetching higher data compare to last run? 5 Does this job running any specific time/ It can be run any time? 6 Does this job fetching data using DB link? 7 Does the problem happen on both the test and production instance?   Troubleshooting Steps for Concurrent Requests Check for Locks and Blocking sessions Identify if the request is running but blocked by database locks/Blocking sessions. Use DBA tools or queries to identify and release locks if necessary. Review Parameters and Data ...
Read more

JSP Compilation in R12.2

By -
Sometime after upgrade, cloning and patching front end login page is not opening showing blank page or showing “ java.lang.StringIndexOutOfBoundsException ” error. This issue was occurring due to cache is not cleared after upgrade/Cloning JSP Compilation steps Step 1: Shutdown the application services Step 2: Take backup for the _Page(class file) folders $ cd $OA_HTML/WEB-INF/classes $ ls -lrt $ mv _pages _pages_bkup<date> a $ cd $OA_HTML/WEB-INF/classes $ ls -lrt $ mv _pages _pages_bkup<date> $ mkdir _pages $ ls -lrt Step 3: Run the below command $ perl $FND_TOP/patch/115/bin/ojspCompile.pl --compile --flush -p 99 Step 4: Start the application and clear browser cache. After completed the JSP compilation home page not coming please clear the image and style sheet cache also Cabo Images and style sheets can be corrupted or out of sync in the cabo caches, you may need to clear the related directories after backup: Step1: Shutdown the services...
Read more

How to find EBS URL in R12.2

By -
There are different way to find the EBS URL Method 1 Login the R12.2 application server Source the Env File [oracle@san ~]$ grep login $CONTEXT_FILE          <login_page oa_var="s_login_page">http://dev1.apps.com:8001/OA_HTML/AppsLogin</login_page> [oracle@san~]$ Method 2: Connect sqlplus apps user SQL> SELECT home_url  FROM icx_parameters; HOME_URL -------------------------------------------------------------------------------- http://<Hostname>:8007/OA_HTML/AppsLogin How to find Weblogic URL and PORT number: Login the R12.2 application server Source the Env File [oracle@sanprod ~]$ grep s_wls_adminport $CONTEXT_FILE          <wls_adminport oa_var="s_wls_adminport" oa_type="PORT" base="7001" step="1" range="-1" label="WLS Admin Server Port"> 7002 </wls_adminport> [oracle@sanprod ~]$ Weblogic Port Number:7002  Weblogic URL:http://<...
Read more