Oracle Sharding - Troubleshooting Tips and Techniques (Doc ID 2180259.1)

Last updated on JUNE 05, 2021

Applies to:

Oracle Database - Enterprise Edition - Version 12.2 BETA1 to 12.2 BETA1 [Release 12.2]
Gen 1 Exadata Cloud at Customer (Oracle Exadata Database Cloud Machine) - Version N/A and later
Oracle Cloud Infrastructure - Database Service - Version N/A and later
Oracle Database Cloud Exadata Service - Version N/A and later
Oracle Database Exadata Express Cloud Service - Version N/A and later
Information in this document applies to any platform.

Goal

This Document explains Troubleshooting Tips and techniques on Oracle database 12.2 New feature "Oracle Sharding"

Solution

	To view full details, sign in with your My Oracle Support account.
	Don't have a My Oracle Support account? Click to get started!

In this Document

I. Deployment

1. Issues on starting remote Scheduler Agent on all the shard hosts

2. Issues on Create Shard

2.1 Make sure to create $ORACLE_BASE/oradata , $ORACLE_BASE/fast_recovery_area directories to avoid below errors on 'create shard'

2.2 Privilege issues

3. DEPLOY Errors

3.2 Incorrect DB status after DEPLOY

NOTE : If deploy fails with some error run the select on CATALOG DB to knwo the eact reason.

4. add shard failing on ORA-1017
Bug 21609033 : AUTO: PRIMARY SHARD TO STANDBY MAPPING INCORRECT LEADING TO ORA 01017

5. GDSCTL> validate failing with,

6. Add shardGroup Failing with below error,

7. Add DG broker config failing with,

III. Direct Routing

IV. Proxy Routing

V. Lifecycle Management

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.