{"id":2137,"date":"2016-08-23T14:00:11","date_gmt":"2016-08-23T11:00:11","guid":{"rendered":"http:\/\/www.fatihacar.com\/blog\/?p=2137"},"modified":"2016-12-13T14:01:17","modified_gmt":"2016-12-13T11:01:17","slug":"oracle-12c-r2-error-codes-and-solution-suggestions-from-ora-03700-to-ora-04000","status":"publish","type":"post","link":"http:\/\/www.fatihacar.com\/blog\/oracle-12c-r2-error-codes-and-solution-suggestions-from-ora-03700-to-ora-04000\/","title":{"rendered":"Oracle 12c R2 Error Codes and Solution Suggestions from ORA-03700 to ORA-04000"},"content":{"rendered":"

Oracle 12c R2 Error Codes and Solution Suggestions from ORA-03700 to ORA-04000<\/strong><\/p>\n

\n
ORA-03700: More than one shardspace not allowed with system-managed sharding.<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0An attempt to add a shardspace to the catalog was attempted when a shardspace already existed.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Only one shardspace is allowed per system-managed catalog. Use the existing shardspace or re-create the catalog with a different sharding type.<\/span><\/span><\/p>\n

\n
<\/a> ORA-03701: invalid parameter combination:\u00a0string<\/i>\u00a0and\u00a0string<\/i><\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0Mutually exclusive parameters were specified in a command.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Verify the parameters and retry command.<\/span><\/span><\/p>\n

\n
<\/a> ORA-03702: reserved word used as object name:\u00a0string<\/i><\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0A reserved word was used as the name of an object.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Verify the parameters and retry command.<\/span><\/span><\/p>\n

\n
<\/a> ORA-03703: no sharded database pools exist<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0A command was issued which required a sharded database pool, but none existed.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Add a sharded database pool and retry the command.<\/span><\/span><\/p>\n

\n
<\/a> ORA-03704: too many sharded database pools exist<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0A command was issued which required a sharded database pool, but more than one existed.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Remove a sharded database pool and retry the command.<\/span><\/span><\/p>\n

\n
<\/a> ORA-03705: must explicitly specify shardgroup name because there could be multiple candidates<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0A command was issued without specifying a shardgroup and a default shardgroup could not be determined.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Do not omit ‘-shardgroup’ when multiple shardgroups exist.<\/span><\/span><\/p>\n

\n
<\/a> ORA-03706: must explicitly specify shardspace name because there could be multiple candidates<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0A command was issued without specifying a shardspace and a default shardspace could not be determined.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Do not omit ‘-shardspace’ when multiple shardspaces exist.<\/span><\/span><\/p>\n

\n
<\/a> ORA-03707: mandatory environment variable not set at destination:\u00a0string<\/i><\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0An environment variable required for the operation was not set at the specified destination.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Provide a value for the variable and retry operation.<\/span><\/span><\/p>\n

\n
<\/a> ORA-03708: shard ‘string<\/i>‘ does not exist<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0The requested shard did not exist.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Check the name and try again.<\/span><\/span><\/p>\n

\n
<\/a> ORA-03709: input parameter too long<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0The input file contained a parameter that was too long.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Confirm the file contents and parameter being used and retry the operation.<\/span><\/span><\/p>\n

\n<\/p>\n
<\/a> ORA-03710: directory does not exist or is not writeable at destination:\u00a0string<\/i><\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0A directory required for successful operation did not exist or was not writeable at the destination.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Confirm that the directory exists and that permissions allow for the creation of files.<\/span><\/span><\/p>\n

\n
<\/a> ORA-03711: A shard with the same database identifier is a member of a different shardgroup.<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0A shard with the same database identifier was a member of a shardgroup in another shardspace.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0All shards with the same database identifier must be members of the same shardgroup. Specify a different shardroup and retry the operation.<\/span><\/span><\/p>\n

\n
<\/a> ORA-03712: A shard with the same database identifier is already in the shardgroup.<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0A shard with the same database identifier was a member of the specified shardgroup.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0All shards in a shardgroup must have unique database identifiers. Specify a different shardroup and retry the operation.<\/span><\/span><\/p>\n

\n
<\/a> ORA-03713: Shard ‘string<\/i>‘ contained\u00a0string<\/i>\u00a0chunks.<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0A shard that contained chunks was removed from the catalog. Those chunks are no longer available.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0This is an informational message only.<\/span><\/span><\/p>\n

\n
<\/a> ORA-03714: errors found during chunk recovery<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0The chunk recovery procedure was not able to automatically recover corrupted chunks.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Examine the trace files and manually fix the problems by altering shard tablespaces.<\/span><\/span><\/p>\n

\n
<\/a> ORA-03715: invalid user\u00a0string<\/i><\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0The specified user did not exist on this shard.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Ensure that the shard DDL is up to date and re-try.<\/span><\/span><\/p>\n

\n
<\/a> ORA-03716: statement too long<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0The statement was too long.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Reduce the size of the statement to 3800 bytes or less.<\/span><\/span><\/p>\n

\n
<\/a> ORA-03717: Shard\u00a0string<\/i>\u00a0does not exist in the shard pool.<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0A nonexistent shard was provided for execution.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Ensure that the shard exists and try again.<\/span><\/span><\/p>\n

\n
<\/a> ORA-03718: Service management is not available at this time because broker configuration\u00a0string<\/i>\u00a0does not have a registered primary database.<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0The primary database was not registered. Service management requires registration of all primary databases.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Wait for new primary database to be registered and try again.<\/span><\/span><\/p>\n

\n
<\/a> ORA-03719: Shard character set does not match catalog character set.<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0The specified shard character set did not match the catalog character set.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Ensure that the character sets match and try again.<\/span><\/span><\/p>\n

\n
<\/a> ORA-03720: Shard national character set does not match catalog national character set.<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0The specified shard national character set did not match the catalog national character set.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Ensure that the national character sets match and try again.<\/span><\/span><\/p>\n

\n
<\/a> ORA-03736: Database\u00a0string<\/i>\u00a0is not a part of the sharded schema.<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0The specified database was not in the sharded schema.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Ensure that the name is correct and try again.<\/span><\/span><\/p>\n

\n
<\/a> ORA-03737: cannot suspend move for chunk number\u00a0string<\/i><\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0The specified chunk move could not be suspended.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Either the move has already started or is no longer in the the queue. Check the status and try again.<\/span><\/span><\/p>\n

\n
<\/a> ORA-03738: cannot remove chunk number\u00a0string<\/i>\u00a0from the move queue<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0The specified chunk could not be removed from the queue.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Either the move has already started or is no longer in the queue. Check the status and try again.<\/span><\/span><\/p>\n

\n
<\/a> ORA-03739: The specified database is not configured to be a catalog.<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0The specified database was not configured to be a catalog.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Specify a valid catalog database and retry the operation.<\/span><\/span><\/p>\n

\n
<\/a> ORA-03740: Deployment failed with error:\u00a0string<\/i><\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0Unable to successfully complete shard deployment.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Check error returned and retry the operation.<\/span><\/span><\/p>\n

\n
<\/a> ORA-03741: Could not retrieve default template from shard.<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0Unable to retrieve default Oracle Database Configuration Assistant (DBCA) template from shard.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Verify that General_Purpose.dbc exists on shard and retry the operation. Alternately, explicity provide a template via ‘create shard’ command options.<\/span><\/span><\/p>\n

\n
<\/a> ORA-03742: Move chunk conditions are not met.<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0Chunk migration pre-check failed because one of the transporting tablespaces was either read-only or in hot backup mode.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Alter the tablespace to fulfill chunk migration requirements.<\/span><\/span><\/p>\n

\n
<\/a> ORA-03743: cannot create service, sharded services must use preferred_all option<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0An attempt was made to create a service in a sharded pool that specified preferred and available databases.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Use only preferred_all option for sharded services.<\/span><\/span><\/p>\n

\n
<\/a> ORA-03744: Shard DDL state is not up-to-date.<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0The requested operation required one or more involved shards to be up-to-date with the DDL state of the sharded system.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Recover shards, which are in DDL Error state, wait for DDL execution to finish on every shard, then retry executing the operation.<\/span><\/span><\/p>\n

\n
<\/a> ORA-03745: global service manager not running<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0The master global service manager was no longer connected to the catalog.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Restart the global service manager and retry operation.<\/span><\/span><\/p>\n

\n
<\/a> ORA-03746: The GSMUSER account does not have SYSDG and SYSBACKUP privileges.<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0The GSMUSER account was not granted SYSDG and SYSBACKUP privileges.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Grant the necessary privileges and retry the operation.<\/span><\/span><\/p>\n

\n
<\/a> ORA-03747: root table already exists<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0New shardspaces could not be added because a root table already existed in the sharded database.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Drop the root table and retry operation.<\/span><\/span><\/p>\n

\n
<\/a> ORA-03748: A deploy operation is already in progress.<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0A previous request for deploy operation was still in progress.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Wait for the previous deploy operation to complete and check if another deploy operation is required before resubmitting the request.<\/span><\/span><\/p>\n

\n
<\/a> ORA-03749: Chunk move cannot be performed at this time.<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0A database condition that prevents chunk move was detected.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Refer to the following error message for additional information. Correct the error, if possible, and try the move again.<\/span><\/span><\/p>\n

\n
<\/a> ORA-03750: flashback database not enabled<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0The flashback database was not enabled on the database being configured.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Enable flashback database and retry the operation.<\/span><\/span><\/p>\n

\n
<\/a> ORA-03751: user-defined sharding not supported<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0User-defined sharding was not supported on the database being configured.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Use either system-managed or composite sharding.<\/span><\/span><\/p>\n

\n
<\/a> ORA-03752: specified VNCR in use<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0The specified valid node check for registration (VNCR) was in use by at least one database or shard.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Remove any databases or shards that use the VNCR and retry the operation.<\/span><\/span><\/p>\n

\n
<\/a> ORA-03753: The procedure cannot be propagated.<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0SYS.EXEC_SHARD_PLSQL can only execute a limited set of PL\/SQL procedures.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Execute a procedure manually on each shard.<\/span><\/span><\/p>\n

\n
<\/a> ORA-03754: shardgroups not allowed with user-defined sharding<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0An attempt was made to create a shardgroup with user-defined sharding.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Use either system-managed or composite sharding.<\/span><\/span><\/p>\n

\n
<\/a> ORA-03755: current database role is incorrect:\u00a0string<\/i><\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0An attempt was made to create a primary shard from a standby database or a standby shard from a primary database.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Validate the current database role and confirm that it matches the role of the specified shardgroup (for system-managed or composite sharding) or that it matches the -deploy_as parameter specified in the ‘add shard’ command (for user-defined sharding).<\/span><\/span><\/p>\n

\n
<\/a> ORA-03756: The chunk\u00a0string<\/i>\u00a0is already being split.<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0There was an incomplete split operation on the same chunk ID.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Wait until the split finishes and try again.<\/span><\/span><\/p>\n

\n
<\/a> ORA-03757: cannot skip or ignore shard DDL<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0An attempt was made to skip a system DDL request such as SPLITCHUNK.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Fix the error at the shard, which cause the DDL to fail, and then recover.<\/span><\/span><\/p>\n

\n
<\/a> ORA-03758: cannot schedule split during an ongoing move<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0There was an incomplete move operation.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Wait until the move finishes and try again.<\/span><\/span><\/p>\n

\n
<\/a> ORA-03759: This procedure cannot be used to set database parameter\u00a0string<\/i>.<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0An attempt was made to set a database parameter that cannot be set using this procedure.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Do not set this parameter using this procedure.<\/span><\/span><\/p>\n

\n
<\/a> ORA-03760: Oracle RAC affinity is supported only on Oracle RAC database.<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0An attempt to enable affinity on non-Oracle RAC database was made<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Enable affinity on Oracle RAC database<\/span><\/span><\/p>\n

\n
<\/a> ORA-03761: Table is not found.<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0The table specification was not correct.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Specify a valid table name in the ALTER SYSTEM ENABLE AFFINITY statement.<\/span><\/span><\/p>\n

\n
<\/a> ORA-03762: Partitioned table with this name does not exist.<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0The specified table was not partitioned.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Enable affinity for a partitioned table.<\/span><\/span><\/p>\n

\n
<\/a> ORA-03763: Partitioned type ‘string<\/i>‘ is not supported.<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0The specified table was not partitioned by either RANGE, LIST or HASH.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Enable affinity for a partitioned table.<\/span><\/span><\/p>\n

\n
<\/a> ORA-03764: Affinity is already enabled for a different table or service.<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0A table affinity was already specified. Multiple table affinities are currently not supported.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Disable affinity for existing table.<\/span><\/span><\/p>\n

\n
<\/a> ORA-03765: Service\u00a0string<\/i>\u00a0has already been deleted by another session.<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0An attempt was made to delete a service that was already deleted.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0None. The previous delete request completes and the service is removed.<\/span><\/span><\/p>\n

\n
<\/a> ORA-03766: Cannot modify service\u00a0string<\/i>\u00a0because it is being deleted.<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0An attempt was made to modify a service that was already deleted.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0None. The previous delete request completes and the service is removed.<\/span><\/span><\/p>\n

\n
<\/a> ORA-03900: shard internal database link cannot be altered or dropped<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0An attempt was made to directly alter or drop an internal database link for sharding, which is not allowed.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Do not alter or drop shard internal database links.<\/span><\/span><\/p>\n

\n
<\/a> ORA-03901: shard key or partition set key column cannot be renamed<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0An attempt was made to rename a shard key column or a partition set key column of a sharded table, which is not allowed.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Do not rename shard key or partition set key column of a sharded table.<\/span><\/span><\/p>\n

\n
<\/a> ORA-03902: cannot shrink a system-managed or composite sharded table with primary key or any sharded table with functional index<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0An attempt was made to shrink a system-managed or composite sharded table with primary key or a sharded table with functional index, which is not allowed.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Do not perform shrink such tables.<\/span><\/span><\/p>\n

\n
<\/a> ORA-03905: cannot use the same tablespace for multiple partitions of a user-defined sharded table<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0An attempt was made to use a tablespace for multiple partitions of a user-defined sharded table.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Use different tablespaces for different partitions in a user-defined sharded table.<\/span><\/span><\/p>\n

\n
<\/a> ORA-03906: invalid tablespace name specified for the parititon<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0An attempt was made to specify a tablespace for LOBs that belonged to a different shardspace.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Specify tablespaces that belong to the same shardspace for the partition as well as for the LOBs.<\/span><\/span><\/p>\n

\n
<\/a> ORA-03950: GoldenGate error:\u00a0string<\/i><\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0An operation failed when performed using Oracle GoldenGate.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Correct the error specified in Oracle GoldenGate output.<\/span><\/span><\/p>\n

\n
<\/a> ORA-03951: Invalid OGG service descriptor – OGG message:\u00a0string<\/i><\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0One or more components of the Oracle GoldenGate (OGG) service descriptor could not be verified.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Refer to the Oracle GoldenGate message for the required action.<\/span><\/span><\/p>\n

\n
<\/a> ORA-03952: OGG\u00a0string<\/i>\u00a0URI:\u00a0string<\/i>\u00a0is not reachable – HTTP message:\u00a0string<\/i><\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0Oracle GoldenGate (OGG) AdminService or DistributionService could not be reached.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Refer to the HTTP message for the required action.<\/span><\/span><\/p>\n

\n
<\/a> ORA-03953: OGG\u00a0string<\/i>\u00a0URI:\u00a0string<\/i>\u00a0failed to\u00a0string<\/i>\u00a0string<\/i>:\u00a0string<\/i>\u00a0– OGG message:\u00a0string<\/i><\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0Oracle GoldenGate (OGG) AdminService or DistributionService operation failed.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Refer to the Oracle GoldenGate message for the required action.<\/span><\/span><\/p>\n

\n
<\/a> ORA-03954: OGG sharding function called in an invalid context:\u00a0string<\/i>\u00a0function called in\u00a0string<\/i><\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0Internal error. An Oracle GoldenGate (OGG) sharding functionality was called in an invalid context, for example, catalog function in shard or vice versa.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Contact Oracle Support Services.<\/span><\/span><\/p>\n

\n
<\/a> ORA-03955: Invalid combination of OGG deployment parameters specified for shardgroup:\u00a0string<\/i>\u00a0(S=string<\/i>, C=string<\/i>, R=string<\/i>)<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0The values specified for Oracle GoldenGate (OGG) deployment parameters (number of shards – S, number of chunks – C and replication factor – R) for the shardgroup were not compatible with each other.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Ensure that the following invariants hold for the shardgroup: number of chunks >= number of shards number of shards >= replication factor<\/span><\/span><\/p>\n

\n
<\/a> ORA-03956: Invalid entry in the OGG command payload:\u00a0string<\/i><\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0Internal error. The payload for Oracle GoldenGate (OGG) command sent from the sharding catalog to the shard database contained an invalid entry.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Contact Oracle Support Services.<\/span><\/span><\/p>\n

\n
<\/a> ORA-03957: Sharding configuration parameter ‘string<\/i>‘ is not set in the shard database.<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0Internal error. A database initialization parameter required by the shard database was not set during deployment.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Contact Oracle Support Services.<\/span><\/span><\/p>\n

\n
<\/a> ORA-03958: Failure to remove shard:\u00a0string<\/i>\u00a0–\u00a0string<\/i><\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0A request to remove a shard database failed.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Check the shard error message for details.<\/span><\/span><\/p>\n

\n
<\/a> ORA-03959: chunk allocation error in shardgroup:\u00a0string<\/i>\u00a0–\u00a0string<\/i><\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0Internal error. Chunk allocation algorithm for Oracle GoldenGate (OGG) detected inconsistencies in the sharding configuration.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Contact Oracle Support Services.<\/span><\/span><\/p>\n

\n
<\/a> ORA-03960: Chunk number ‘string<\/i>‘ already exists on the target shard.<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0An invalid chunk number or target shard name was provided.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Check the chunk number, shard name and try again.<\/span><\/span><\/p>\n

\n
<\/a> ORA-03961: A move chunk request already exists for chunk number ‘string<\/i>‘ from the source shard.<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0An invalid chunk number or source shard name was provided.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Check the chunk number, shard name and try again.<\/span><\/span><\/p>\n

\n
<\/a> ORA-04000: the sum of PCTUSED and PCTFREE cannot exceed 100<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0the sum of PCTUSED and PCTFREE for a cluster or table exceeds 100<\/span><\/span><\/p>\n

Action:<\/b>\u00a0create the table\/cluster specifying values whose sum is <= 100<\/span><\/span><\/p>\n

\n
<\/dd>\n<\/dl>\n","protected":false},"excerpt":{"rendered":"

Oracle 12c R2 Error Codes and Solution Suggestions from ORA-03700 to ORA-04000 ORA-03700: More than one shardspace not allowed with system-managed sharding. Cause:\u00a0An attempt to add a shardspace to the catalog was attempted when a shardspace already existed. Action:\u00a0Only one shardspace is allowed per system-managed catalog. Use the existing shardspace or re-create the catalog with…<\/p>\n","protected":false},"author":37,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"jetpack_post_was_ever_published":false,"_jetpack_newsletter_access":"","_jetpack_dont_email_post_to_subs":false,"_jetpack_newsletter_tier_id":0,"_jetpack_memberships_contains_paywalled_content":false,"_jetpack_memberships_contains_paid_content":false,"footnotes":""},"categories":[53],"tags":[54],"class_list":["post-2137","post","type-post","status-publish","format-standard","hentry","category-oracle-errors-and-solutions","tag-oracle-error-solutions"],"jetpack_featured_media_url":"","jetpack_shortlink":"https:\/\/wp.me\/p39NFI-yt","jetpack_sharing_enabled":true,"_links":{"self":[{"href":"http:\/\/www.fatihacar.com\/blog\/wp-json\/wp\/v2\/posts\/2137","targetHints":{"allow":["GET"]}}],"collection":[{"href":"http:\/\/www.fatihacar.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/www.fatihacar.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/www.fatihacar.com\/blog\/wp-json\/wp\/v2\/users\/37"}],"replies":[{"embeddable":true,"href":"http:\/\/www.fatihacar.com\/blog\/wp-json\/wp\/v2\/comments?post=2137"}],"version-history":[{"count":1,"href":"http:\/\/www.fatihacar.com\/blog\/wp-json\/wp\/v2\/posts\/2137\/revisions"}],"predecessor-version":[{"id":2138,"href":"http:\/\/www.fatihacar.com\/blog\/wp-json\/wp\/v2\/posts\/2137\/revisions\/2138"}],"wp:attachment":[{"href":"http:\/\/www.fatihacar.com\/blog\/wp-json\/wp\/v2\/media?parent=2137"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/www.fatihacar.com\/blog\/wp-json\/wp\/v2\/categories?post=2137"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/www.fatihacar.com\/blog\/wp-json\/wp\/v2\/tags?post=2137"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}