Some Quirks With oggca_response File Errors

I have just completed 6 deployments and thought I would things I was not are of.

First issue is relared to password requirements.

Password M1llionD0llar$ will not work.

Who doesn’t like million dollar?

[oracle@dinh ~]$ /u01/oracle/app/goldengate/ogg21ma/bin/oggca.sh -silent -responseFile /tmp/dinh_PROD1-PROD2_oggca_response.rsp
[FATAL] [INS-85080] Invalid password.
   CAUSE: The provided password is invalid for the current strong password policy settings. The strong password policy is enabled. 
   Password should contain at least: 
   one lowercase [a..z] character, 
   one uppercase [A..Z] character, 
   one digit [0..9], and 
   one special character [- ! @ % & * . # _]. 
   Length should be between 8..30 characters.
   ACTION: Specify a valid password.
[oracle@dinh ~]$

EZCONNECT will be used for the deployment; there is no need to install client or database.

[oracle@dinh ~]$ /u01/oracle/app/goldengate/ogg21ma/bin/oggca.sh -silent -responseFile /tmp/dinh_PROD1-PROD2_oggca_response.rsp
[FATAL] [INS-85077] Empty value for TNS_ADMIN environment variable.
ACTION: Specify a value for the TNS_ADMIN environment variable.
[oracle@dinh ~]$

The work around is just to create an empty diretory. In my case, just create it under $OGG_HOME

ENV_TNS_ADMIN=/u01/oracle/app/goldengate/ogg21ma/network/admin

SERVICEMANAGER_DEPLOYMENT_HOME

[oracle@dinh ~]$ /u01/oracle/app/goldengate/ogg21ma/bin/oggca.sh -silent -responseFile /tmp/dinh_PROD1-PROD2_oggca_response.rsp
[FATAL] [INS-85103] The path /u01/oracle/app/ogg_deploy/ServiceManager/PROD1-PROD2 cannot be used as a deployment directory.
   CAUSE: Deployment directories cannot be located inside the Service Manager deployment directory.
   ACTION: Provide a valid path for the deployment directory that is not located inside the Service Manager deployment home.
[oracle@dinh ~]$

Move it

SERVICEMANAGER_DEPLOYMENT_HOME=/u01/oracle/app/ogg_deploy/ServiceManager
OGG_DEPLOYMENT_HOME=/u01/oracle/app/ogg_deploy/PROD1-PROD2

I know that you are thinking -RTFM. I would still be reading vs delivering.

Just like learning how to ride a bike. You fall and get back on.

It’s also good to have someone there when youu fall.

Advertisement

Oracle GoldenGate Microservices Architecture Silent Deployment Creation – Better Port Selection

I was working on 6 deployments – 3 primary and 3 standy.

Was heading to home base but then tripped and fell – had port collision.

How fastt can you spot the error?

### DEPLOYMENT #1
PORT_ADMINSRVR=21001
PORT_DISTSRVR=21002
PORT_RCVRSRVR=21003
PORT_PMSRVR=21004
UDP_PORT_PMSRVR=21005

### DEPLOYMENT #2
PORT_ADMINSRVR=21021
PORT_DISTSRVR=21012
PORT_RCVRSRVR=21013
PORT_PMSRVR=21014
UDP_PORT_PMSRVR=21015

### DEPLOYMENT #3
PORT_ADMINSRVR=21021
PORT_DISTSRVR=21022
PORT_RCVRSRVR=21023
PORT_PMSRVR=21024
UDP_PORT_PMSRVR=21025

Remember, we read from left to right.

Now, how fast can you spot the error?

### DEPLOYMENT #1
PORT_ADMINSRVR=10001
PORT_DISTSRVR=10002
PORT_RCVRSRVR=10003
PORT_PMSRVR=10004
UDP_PORT_PMSRVR=10005

### DEPLOYMENT #2
PORT_ADMINSRVR=20001
PORT_DISTSRVR=20002
PORT_RCVRSRVR=20003
PORT_PMSRVR=20004
UDP_PORT_PMSRVR=20005

### DEPLOYMENT #3
PORT_ADMINSRVR=20001
PORT_DISTSRVR=30002
PORT_RCVRSRVR=30003
PORT_PMSRVR=30004
UDP_PORT_PMSRVR=30005

Some good news, with 21c version, it was an easy fix.

Click on bad port to edit and save.

OGG Microservices Silent Installation and Deployment – FUBAR?

There are 2 steps to Implement Oracle GoldenGate Microservices Architecture.

Step1 – Install Oracle GoldenGate – oggcore.rsp is provided

Step2 – Create the Oracle GoldenGate Deployment – oggca.rsp is not provided

To get oggca.rsp, one will need to perform installation using GUI and save the response file as oggca.rsp.

Here is an example for differences for response file header – ogginstall vs oggca – don’t get this wrong.

Install Oracle GoldenGate
oracle.install.responseFileVersion=/oracle/install/rspfmt_ogginstall_response_schema_v21_1_0

Create the Oracle GoldenGate Deployment
oracle.install.responseFileVersion=/oracle/install/rspfmt_oggca_response_schema_v21_1_0

Next, PMSRVR_DATASTORE_TYPE : LMDB or BDB?

System Properties Comparison LMDB vs. Oracle Berkeley DB vs. SQLite

Retrieving and understanding a response file for Oracle GoldenGate Deployment configuration

OCI- How to retrieve instance metadata from command line

When oci-metadata is not available or installed, use curl.

Some information have been removed to protect the innocent.

$ curl -L http://169.254.169.254/opc/v1/instance/
{
  "availabilityDomain" : "SVYj:US-ASHBURN-AD-2",
  "faultDomain" : "FAULT-DOMAIN-1",
  "compartmentId" :
  "displayName" :
  "hostname" : 
  "id" :
  "metadata" : {
    "ssh_authorized_keys" : 
    "nodeNumber" : "0",
    "user_data" :
    "sshkey-resourceID" : 
    "agentAuth" : "true",
    "dbSystemShape" : "Exadata.Quarter3.100"
  },
  "region" : "iad",
  "canonicalRegionName" : "us-ashburn-1",
  "ociAdName" : "iad-ad-2",
  "regionInfo" : {
    "realmKey" : "oc1",
    "realmDomainComponent" : "oraclecloud.com",
    "regionKey" : "IAD",
    "regionIdentifier" : "us-ashburn-1"
  },
  "shape" : "ExadataCavium",
  "state" : "Running",
  "timeCreated" : 1613174787736
}

Reference: OCI- How to retrieve instance metadata from command line (Doc ID 2570001.1)

How To Determine Host Is On OCI

How To Determine Host Is On OCI

Learned something new today.

https://docs.oracle.com/en-us/iaas/Content/Compute/References/oci-metadata.htm

Host is running OEM 13.4.0.0.0

[oracle@oemhost ~]$ oci-metadata
Instance details:
  Display Name: oemhost
  Region: phx - us-phoenix-1 (Phoenix, AZ, USA)
  Canonical Region Name: us-phoenix-1
  Availability Domain: jjZD:PHX-AD-2
  Fault domain: FAULT-DOMAIN-1
  OCID: ocid1.instance.oc1.phx.X
  Compartment OCID: ocid1.compartment.oc1..X
  Instance shape: VM.Standard2.16
  Image ID: ocid1.image.oc1.phx.X
  Created at: 1592424850729
  state: Running
  agentConfig:
    managementDisabled: False
    monitoringDisabled: False
  ociAdName: phx-ad-2
  hostname: oemhost
  regionInfo:
    regionKey: PHX
    realmDomainComponent: oraclecloud.com
    regionIdentifier: us-phoenix-1
    realmKey: oc1
  Instance Metadata:
    ssh_authorized_keys: ssh-rsa *
Networking details:
  VNIC OCID: ocid1.vnic.oc1.phx.X
  VLAN Tag: 293
  Private IP address: 10.157.38.66
  MAC address: 00:00:17:01:47:77
  Subnet CIDR block: 10.157.38.64/26
  Virtual router IP address: 10.157.38.65
[oracle@oemhost ~]$