Month: April 2017

12c new feature identity column not yet support with Goldengate 12.2 / 12c

The 12c new feature “identity columns” are not yet support with Goldengate 12.2 / 12c. The failure to replicate the new “identity” type will not be logged – anywhere.  The issue is only identified by running GoldenGate Integrated Extract Healthcheck script, found in MOS article 1448324.1 – but that means you have to be pro-active. So, if …

12c new feature identity column not yet support with Goldengate 12.2 / 12c Read More »

RMAN Duplicate or restore until what sequence? Use restore preview and SQL

When you restore and recover using an RMAN backup that was in archivelog mode –  at very least – RMAN also needs all the archivelog that was produced while the RMAN backup was being run / generated. Here is one way to determine what the absolute minimum archivelog sequence that is necessary to restore with …

RMAN Duplicate or restore until what sequence? Use restore preview and SQL Read More »

with Oracle Enterprise database 12.2 or 12.1 after setting ORA-01017 after setting sec_case_sensitive_logon=false

Basically, with 12.2 default behavior – there is NO default authentication method left after setting case sensitivity to false – just set it back to true – see Oracle Support Doc ID 2040705.1 Additionally, the following Doc IDs supply additional info: 1957995.1 and 1304142.1 alter system sec_case_sensitive_logon=true scope=both; — then use case sensitive passwords or or …

with Oracle Enterprise database 12.2 or 12.1 after setting ORA-01017 after setting sec_case_sensitive_logon=false Read More »

GoldenGate 12.2 setup Uni-Directional Sync of some DB schemas with RMAN Active Duplicate Initial Load

This blog demonstrates an Oracle GoldenGate 12.2 setup Uni-Directional Sync of a subset of schemas Oracle 12.2 DB with / using RMAN Active Duplicate for the “Initial Load” (initial GoldenGate load of the target).  The entire DB will be duplicated so we can replicate whatever schemas we choose – for now I’m picking HR – which …

GoldenGate 12.2 setup Uni-Directional Sync of some DB schemas with RMAN Active Duplicate Initial Load Read More »

RMAN duplicate using active RMAN technology

This blog demonstrates the use of an RMAN duplicate using “active” RMAN technology.  Active duplication is available with Oracle’s Enterprise Database product starting with 11gR2 forward 11.2.x.x.x, 12c etc. Basically “active duplicate” uses the control file and the currently open database as a source to clone / duplicate from – no backup is required.  It …

RMAN duplicate using active RMAN technology Read More »

EBS R12 AD Administration / adadmin & AutoPatch / adpatch

Work in progress excuse my dust… Executable locations: Apps Tier: $AD_TOP/bin DB Tier: $ORACLE_HOME/appsutil/bin AD Administration / adadmin and AutoPatch / adpatch place their log files in the following locations: UNIX: $APPL_TOP/admin/<SID>/log Windows: %APPL_TOP%\admin\<SID>\log How to use – basics: adpatch: adpatch driver types U, C, G, D U – Universal drivers are the newer versions …

EBS R12 AD Administration / adadmin & AutoPatch / adpatch Read More »

EBS R12 – what is the difference between adconfig.sh adautocfg.sh

EBS R12 – what is the difference between adconfig.sh adautocfg.sh? adautocfg.sh is a wrapper around adconfig.sh adconfig.sh is in the bin directory on both the apps tier and the db tier $AD_TOP/bin $ORACLE_HOME/appsutil/bin adautocfg.sh is in the scripts directory on both the apps tier and the db tier $INST_TOP/admin/scripts $ORACLE_HOME/appsutil/scripts/<context_name> <context_name> = <SID_HOSTNAME> adconfig.sh in …

EBS R12 – what is the difference between adconfig.sh adautocfg.sh Read More »

Missing or corrupt Library Files on the Target Instance caused the libgcc_s.so: undefined reference to `__stack_chk_fail@GLIBC_2.4' error.

Per Oracle Support Doc ID: 761566.1 Missing or corrupt Library Files on the Target Instance caused the libgcc_s.so: undefined reference to `__stack_chk_fail@GLIBC_2.4′ error. This error indicated that a bad library file was linked into the 10.1.2 & 10.1.3 IAS Oracle Homes. SOLUTION Check what RPMs are installed on the Source and Target machines by running the …

Missing or corrupt Library Files on the Target Instance caused the libgcc_s.so: undefined reference to `__stack_chk_fail@GLIBC_2.4' error. Read More »