{"id":2129,"date":"2016-08-20T13:54:06","date_gmt":"2016-08-20T10:54:06","guid":{"rendered":"http:\/\/www.fatihacar.com\/blog\/?p=2129"},"modified":"2016-12-13T13:55:07","modified_gmt":"2016-12-13T10:55:07","slug":"oracle-12c-r2-error-codes-and-solution-suggestions-from-ora-02600-to-ora-02800","status":"publish","type":"post","link":"http:\/\/www.fatihacar.com\/blog\/oracle-12c-r2-error-codes-and-solution-suggestions-from-ora-02600-to-ora-02800\/","title":{"rendered":"Oracle 12c R2 Error Codes and Solution Suggestions from ORA-02600 to ORA-02800"},"content":{"rendered":"

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

\n
ORA-02600: credential name is invalid:\u00a0string<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0An invalid credential name was specified.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Verify credential name and retry the operation.<\/span><\/span><\/p>\n

\n
<\/a> ORA-02601: credential already exists:\u00a0string<\/i><\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0Credential name specified already used by an existing object.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Verify credential name and retry the operation.<\/span><\/span><\/p>\n

\n
<\/a> ORA-02602: credential does not exist:\u00a0string<\/i><\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0The specified credential does not exist.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Verify credential name and retry the operation.<\/span><\/span><\/p>\n

\n
<\/a> ORA-02603: file name is invalid:\u00a0string<\/i><\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0An invalid file name was specified.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Verify credential name and retry operation.<\/span><\/span><\/p>\n

\n
<\/a> ORA-02604: file already exists:\u00a0string<\/i><\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0File name specified already used by an existing object.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Verify filename and retry the operation.<\/span><\/span><\/p>\n

\n
<\/a> ORA-02605: file does not exist:\u00a0string<\/i><\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0The specified file does not exist.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Verify file name and retry the operation.<\/span><\/span><\/p>\n

\n
<\/a> ORA-02606: destination name is invalid:\u00a0string<\/i><\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0An invalid destination name was specified.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Verify destination name and retry the operation.<\/span><\/span><\/p>\n

\n
<\/a> ORA-02607: destination not specified<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0A destination must be specified in the command.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Provide destination and retry the operation.<\/span><\/span><\/p>\n

\n
<\/a> ORA-02608: destination does not exist:\u00a0string<\/i><\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0The specified destination does not exist.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Verify destination and retry the operation.<\/span><\/span><\/p>\n

\n
<\/a> ORA-02609: remote scheduler agent not running<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0The specified remote scheduler agent cannot be contacted.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Confirm that the agent is running and retry the operation.<\/span><\/span><\/p>\n

\n
<\/a> ORA-02610: Remote job failed with error:\u00a0string<\/i><\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0Unable to successfully run specified job.<\/span><\/span><\/p>\n

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

\n
<\/a> ORA-02611: shardgroup name is invalid:\u00a0string<\/i><\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0An invalid shardgroup name was specified.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Verify the shardgroup name and retry the operation.<\/span><\/span><\/p>\n

\n
<\/a> ORA-02612: shardgroup does not exist:\u00a0string<\/i><\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0The specified shardgroup did not exist.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Verify the shardgroup name and retry the operation.<\/span><\/span><\/p>\n

\n
<\/a> ORA-02613: shardspace name is invalid:\u00a0string<\/i><\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0An invalid shardspace name was specified.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Verify the shardspace name and retry the operation.<\/span><\/span><\/p>\n

\n
<\/a> ORA-02614: shardspace does not exist:\u00a0string<\/i><\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0The specified shardspace did not exist.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Verify the shardspace name and retry the operation.<\/span><\/span><\/p>\n

\n
<\/a> ORA-02615: Neither a shardgroup nor a shardspace name was specified.<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0A shardgroup or shardspace name was not specified.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Update the parameters and retry the operation.<\/span><\/span><\/p>\n

\n
<\/a> ORA-02616: Both a shardgroup and a shardspace name were specified.<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0A shardgroup and a shardspace name were both specified. For this command, either a shardgroup or shardspace name may be specified, but not both.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Update the parameters and retry the operation.<\/span><\/span><\/p>\n

\n
<\/a> ORA-02617: Neither a credential nor login information was specified<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0Either a credential or login information must be specified.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Update the parameters and retry the operation.<\/span><\/span><\/p>\n

\n
<\/a> ORA-02618: Both a credential and login information was specified<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0For this command, either a credential or login information may be specified, not both.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Update the parameters and retry the operation.<\/span><\/span><\/p>\n

\n
<\/a> ORA-02619: Both a file name and file contents were specified.<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0A file name and file contents were both specified.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Update the parameters and retry the operation.<\/span><\/span><\/p>\n

\n
<\/a> ORA-02620: db_domain value too long:\u00a0string<\/i><\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0The value specified for db_domain exceeded the 128 character limit.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Modify the value specified for db_domain and retry the operation.<\/span><\/span><\/p>\n

\n
<\/a> ORA-02621: file in use by shard ‘string<\/i>‘<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0The specified file was in use by an undeployed shard.<\/span><\/span><\/p>\n

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

\n
<\/a> ORA-02622: Shard is not open in write mode.<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0The shard was not opened in the correct mode.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Open the shard in write mode and retry the operation.<\/span><\/span><\/p>\n

\n
<\/a> ORA-02623: Failed to create broker configuration with error\u00a0string<\/i>.<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0A request to create the broker configuration failed.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Check the broker logs for details.<\/span><\/span><\/p>\n

\n
<\/a> ORA-02624: Failed to enable broker configuration with error\u00a0string<\/i>.<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0A request to enable the broker configuration failed.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Check the broker logs for details.<\/span><\/span><\/p>\n

\n
<\/a> ORA-02625: Failed to add standby shard\u00a0string<\/i>\u00a0to the broker configuration with error\u00a0string<\/i>.<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0A request to add the shard to the broker configuration failed.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Check the broker logs for details.<\/span><\/span><\/p>\n

\n
<\/a> ORA-02626: Failed to enable standby shard\u00a0string<\/i>\u00a0for the broker configuration with error\u00a0string<\/i>.<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0A request to enable the shard for the broker configuration failed.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Check the broker logs for details.<\/span><\/span><\/p>\n

\n
<\/a> ORA-02627: Shardspace ‘string<\/i>‘ does not exist.<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

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

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

\n
<\/a> ORA-02628: invalid shardgroup name ‘string<\/i>‘<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0The shardgroup name was invalid.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Use a different name for the shardgroup.<\/span><\/span><\/p>\n

\n
<\/a> ORA-02629: cannot modify deployed shardgroup\u00a0string<\/i><\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0The shardgroup was already deployed and could no longer be modified.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Do not modify a deployed shardgroup. Delete it and add it again.<\/span><\/span><\/p>\n

\n
<\/a> ORA-02630: cannot modify primary or standby status of shardgroup\u00a0string<\/i><\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0The shardgroup already contained a shard and could not be converted from a primary shard to a standby shard or from a standby shard to a primary shard.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Do not modify the primary or standby status of this shardgroup.<\/span><\/span><\/p>\n

\n
<\/a> ORA-02631: The shardspace name ‘string<\/i>‘ is invalid.<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0An invalid shardspace name was provided.<\/span><\/span><\/p>\n

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

\n
<\/a> ORA-02632: cannot modify deployed shardspace ‘string<\/i>‘<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0The shardspace was already deployed and could no longer be modified.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Do not modify deployed shardspaces.<\/span><\/span><\/p>\n

\n
<\/a> ORA-02633: The shardspace ‘string<\/i>‘ is invalid.<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0An invalid shardpsace name was provided.<\/span><\/span><\/p>\n

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

\n
<\/a> ORA-02634: Oracle XML DB is not installed.<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0Oracle XML DB was required for remote scheduler agent configuration but was not installed.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Install Oracle XML DB in the catalog database.<\/span><\/span><\/p>\n

\n
<\/a> ORA-02635: The value of chunks must be greater than one.<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0An invalid value of chunks was passed.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Set chunks to a value greater than one.<\/span><\/span><\/p>\n

\n
<\/a> ORA-02636: Shard is already in shardspace\u00a0string<\/i>.<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0The shard was already in a shardspace.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Remove the shard from the sharding schema before adding it to another shardspace.<\/span><\/span><\/p>\n

\n
<\/a> ORA-02637: The source and target shards are in different shardgroups.<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0The source and target shards for a chunk move operation were in different shardgroups.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Chunks cannot be moved across shardgroups. Specify a source and target shard that are in the same shardgroup.<\/span><\/span><\/p>\n

\n
<\/a> ORA-02638: The shardgroup\u00a0string<\/i>\u00a0is not deployed.<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0The containing shardgroup for the source and target shards was not yet deployed.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Chunks cannot be moved until the shardgroup has been deployed. Deploy the shardgroup before moving chunks.<\/span><\/span><\/p>\n

\n
<\/a> ORA-02639: Source and target shards are the same.<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0The source and target shards for a chunk move were the same.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Chunks cannot be moved to the same shard. Specify a different source and target.<\/span><\/span><\/p>\n

\n
<\/a> ORA-02640: Shardspace already has a primary shardgroup.<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0An attempt was made to add a primary shardgroup to a shardspace that already had a primary shardgroup. When Oracle Data Guard replication is used, only one primary shardgroup is allowed in each shardspace.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Do not add another primary shardgroup to this shardspace.<\/span><\/span><\/p>\n

\n
<\/a> ORA-02641: Shard\u00a0string<\/i>\u00a0was not deployed because it does not contain a corresponding shard in all shardgroups.<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0The shard did not have a corresponding shard in all shardgroups in an Oracle Data Guard configuration, therefore it was not deployed.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0This is only a warning and the deployment will continue without this shard. In order to make use of this shard, either remove shardgroups, or add shards to other shardgroups so that there are the same number of shards in all shardgroups.<\/span><\/span><\/p>\n

\n
<\/a> ORA-02642: There were no new shards to deploy.<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0The ‘deploy’ command was issued, but there were no new shards to deploy.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0This is only a warning. Deploy may continue to recover previous deployment attempts, if any exist, but no new shards will be deployed.<\/span><\/span><\/p>\n

\n
<\/a> ORA-02643: failed to enable fast-start failover with error\u00a0string<\/i><\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0A request to enable fast-start failover failed.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Check the broker logs for details.<\/span><\/span><\/p>\n

\n
<\/a> ORA-02644: Shard ‘string<\/i>‘ already exists in specified rack ‘string<\/i>‘.<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0The specified rack already contained another shard in the same Oracle Data Guard configuration.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Specify a different value for the rack parameter.<\/span><\/span><\/p>\n

\n
<\/a> ORA-02645: only one primary shard allowed per shardspace<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0The specified shardspace already contained a primary shard.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Specify a different shardspace or create a standby shard instead.<\/span><\/span><\/p>\n

\n
<\/a> ORA-02646: Standby shards not allowed in Oracle GoldenGate configurations.<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0The Oracle GoldenGate configurations contained standby shards.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Create a primary shard instead of a standby shard.<\/span><\/span><\/p>\n

\n
<\/a> ORA-02647: The rack name ‘string<\/i>‘ is invalid.<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0An invalid rack name was provided.<\/span><\/span><\/p>\n

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

\n
<\/a> ORA-02648: Password for SYS account was not specified.<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0A SYS password was not specified when creating a new shard using Oracle Database Configuration Assistant (DBCA).<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Retry the operation and specify a SYS password.<\/span><\/span><\/p>\n

\n
<\/a> ORA-02649: cannot change region for a system-managed or composite shard<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0An attempt was made to change the region value for a system-managed or composite shard.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Change the region value at the shardgroup level instead.<\/span><\/span><\/p>\n

\n
<\/a> ORA-02650: remote scheduler agent error:\u00a0string<\/i><\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0An operation failed when performed using the remote scheduler agent.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Correct the error specified in the remote scheduler agent output.<\/span><\/span><\/p>\n

\n
<\/a> ORA-02651: The specified pool ‘string<\/i>‘ is not sharded.<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0The specified pool was not sharded.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Specify a sharded pool and retry the operation.<\/span><\/span><\/p>\n

\n
<\/a> ORA-02652: The maximum number of sharded GDS pools has been reached.<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0The maximum number of Global Data Services (GDS) sharded pools had been reached.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0No more Global Data Services (GDS) sharded pools can be added without first removing a pool.<\/span><\/span><\/p>\n

\n
<\/a> ORA-02653: shardgroup already exists:\u00a0string<\/i><\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0The specified shardgroup was already in existence.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Verify the shardgroup name and retry the operation.<\/span><\/span><\/p>\n

\n
<\/a> ORA-02654: Shards and shardgroups cannot exist in the same database pool.<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0The specified database pool already contained either a conflicting shard or shardgroup.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Verify the database pool name and retry the operation.<\/span><\/span><\/p>\n

\n
<\/a> ORA-02655: not a sharded catalog<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0The catalog was not enabled for sharding and a sharding command was executed.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Re-create the catalog with ‘create shardcatalog’ or verify the command issued.<\/span><\/span><\/p>\n

\n
<\/a> ORA-02656: shardspace already exists:\u00a0string<\/i><\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0The specified shardspace was already in existence.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Verify the shardspace name and retry the operation.<\/span><\/span><\/p>\n

\n
<\/a> ORA-02657: too few chunks specified for shardspace<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0The number of chunks in the specified shardspace was less than twice the number of shards in one of its shardgroups.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0If the shardspace is not deployed, modify the shardspace to increase the number of chunks it contains.<\/span><\/span><\/p>\n

\n
<\/a> ORA-02658: shardspace already exists:\u00a0string<\/i><\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0The specified shardspace was already in existence.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Verify the shardspace name and retry the operation.<\/span><\/span><\/p>\n

\n
<\/a> ORA-02659: cannot remove a shard which contains chunks<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0An attempt was made to remove a shard which currently contains chunks.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Move the chunks to another shard and then retry the operation.<\/span><\/span><\/p>\n

\n
<\/a> ORA-02660: Shard ‘string<\/i>‘ was also removed.<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0When a shard was removed, all other shards in the same Oracle Data Guard configuration were also removed.<\/span><\/span><\/p>\n

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

\n
<\/a> ORA-02661: shardspace and shardgroup parameters are mutually exclusive<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0A command was issued that included both the shardspace and and shardgroup parameters.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Remove one of the conflicting parameters from the command.<\/span><\/span><\/p>\n

\n
<\/a> ORA-02662: Chunk number ‘string<\/i>‘ does not exist on the source database.<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

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

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

\n
<\/a> ORA-02663: Remote scheduler agents may be listening on previously specified port.<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0The ‘-agent_port’ parameter specified a new agent port value. The already registered scheduler agents must re-register with the catalog database to use this new value.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0This is only a warning. Re-register the existing scheduler agents as necessary.<\/span><\/span><\/p>\n

\n
<\/a> ORA-02664: Specified port may be in use.<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0The ‘-agent_port’ parameter specified a new agent port value. The port specified may already have been in use by another process in the system.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0This is only a warning. Confirm that there is no port conflict before continuing the operation.<\/span><\/span><\/p>\n

\n
<\/a> ORA-02665: shardspace not specified<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0A command was issued that did not include shardspace”.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Specify shardspace.<\/span><\/span><\/p>\n

\n
<\/a> ORA-02666: cannot split if tablespace set not created<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0An attempt was made to split a chunk before creating a tablespace set.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Create a tablespace set before issuing the SPLIT command.<\/span><\/span><\/p>\n

\n
<\/a> ORA-02667: cannot split if root table not created<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0An attempt was made to split a chunk before creating a sharded table.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Create a sharded table before issuing the SPLIT command.<\/span><\/span><\/p>\n

\n
<\/a> ORA-02668: Observer cannot be started for database “string<\/i>“<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0One or more conditions required by Data Guard observer were not met.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Confirm that Data Guard technology is used for replication, the database belongs to disaster recovery group with FSFO enabled, and there is an online primary database in that group.<\/span><\/span><\/p>\n

\n
<\/a> ORA-02669: data type or length of a partitionset column in a sharded table cannot be changed<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0An attempt was made to issue an ALTER TABLE statement to modify the data type or length of a column used to super-partition the specified sharded table.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Do not modify the data type or length of a sharded table super- partitioning column or columns.<\/span><\/span><\/p>\n

\n
<\/a> ORA-02670: unsupported SQL construct:\u00a0string<\/i><\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0The query had a construct that was not supported for inter shard query.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Rewrite the query to avoid using an unsupported construct. Consult Oracle documentation for details.<\/span><\/span><\/p>\n

\n
<\/a> ORA-02671: DML are not allowed on more than one shard<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0The DML was applied to more than one shard.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Rewrite the DML to limit operation to a single shard.<\/span><\/span><\/p>\n

\n
<\/a> ORA-02672: cannot update sharding key<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0An attempt was made to update the sharding key value using the UPDATE command.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Drop and re-create the sharding key.<\/span><\/span><\/p>\n

\n
<\/a> ORA-02673:\u00a0string<\/i>\u00a0maps to multiple shards<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0The aggregate, group by, semi-join, or anti-join subquery was mapped to multiple shards.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Rewrite the query so that subqueries map to a single shard.<\/span><\/span><\/p>\n

\n
<\/a> ORA-02674: illegal join predicate on sharding key<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0The query had illegal or no join predicate on the sharding key.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Rewrite the query to include join on sharding columns.<\/span><\/span><\/p>\n

\n
<\/a> ORA-02675: sharded table\u00a0string<\/i>\u00a0outer joined with replicated table\u00a0string<\/i><\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0The query had a sharded table outer joined to the replicated table.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Rewrite the query to remove the outer join.<\/span><\/span><\/p>\n

\n
<\/a> ORA-02676: non-equality join on sharding key<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0The query had a non-equality join on the sharding key.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Rewrite the query to remove the non-equality join.<\/span><\/span><\/p>\n

\n
<\/a> ORA-02677: queries not supported on objects with user-specified sharding<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0The query had an object defined by user-specified sharding.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0None<\/span><\/span><\/p>\n

\n
<\/a> ORA-02678: cross shard queries not supported on composite sharding<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0The query had an object defined under composite sharding.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0None<\/span><\/span><\/p>\n

\n
<\/a> ORA-02679: queries involving private and sharded tables not supported<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0The query referenced a private and a sharded table.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Rewrite the query to refer to either private tables or sharded tables, but not both.<\/span><\/span><\/p>\n

\n
<\/a> ORA-02680: unsupported construct referred in the query<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0The query referenced unsupported constructs which could not be fetched from the shard.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Rewrite the query to avoid using unsupported constructs.<\/span><\/span><\/p>\n

\n
<\/a> ORA-02681: array DML not supported on a sharded table<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0The statement attempts an array DML operation on a sharded table.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Rewrite the array DML statement as separate DML statements.<\/span><\/span><\/p>\n

\n
<\/a> ORA-02682: shard key missing in INSERT statement<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0The INSERT statement was used to insert a row in the sharded table without inserting a value for the shard column.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Insert a value for the shard key column.<\/span><\/span><\/p>\n

\n
<\/a> ORA-02683: inconsistent shard schema<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0The schema definition on the shard and the coordinator did not match.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Verify and fix the schema inconsistency between the shard and the coordinator.<\/span><\/span><\/p>\n

\n
<\/a> ORA-02684: invalid partition for the chunk\u00a0string<\/i><\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0A valid partition was not found for the chunk number passed to the shard database.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Check the chunks handled by the shard database.<\/span><\/span><\/p>\n

\n
<\/a> ORA-02700: osnoraenv: error translating ORACLE_SID<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0Two-task driver could not find the value of ORACLE_SID in the environment.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Make sure that the ORACLE_SID environment variable has been properly set and exported.<\/span><\/span><\/p>\n

\n
<\/a> ORA-02701: osnoraenv: error translating oracle image name<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0ORACLE_HOME environment variable not set.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Make sure that the ORACLE_HOME environment variable has been properly set and exported.<\/span><\/span><\/p>\n

\n
<\/a> ORA-02702: osnoraenv: error translating orapop image name<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0ORACLE_HOME environment variable not set.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Make sure that the ORACLE_HOME environment variable has been properly set and exported.<\/span><\/span><\/p>\n

\n
<\/a> ORA-02703: osnpopipe: pipe creation failed<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0The pipe driver failed to create pipes for communications with the orapop process.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0You have probably exceeded the maximum number of open file descriptors per user or the system file table is full. Note the operating system error code and contact your system administrator.<\/span><\/span><\/p>\n

\n
<\/a> ORA-02704: osndopop: fork failed<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0The two-task driver could not fork orapop.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Verify that there are enough system resources to support another process. The user or system process limit may have been exceeded, or the amount of free memory or swap space may be temporarily insufficient.<\/span><\/span><\/p>\n

\n
<\/a> ORA-02705: osnpol: polling of communication channel failed<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0The pipe driver failed while polling the communications channel.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Contact your customer support representative.<\/span><\/span><\/p>\n

\n
<\/a> ORA-02706: osnshs: host name too long<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0The length of your host-string specified by the TWO_TASK environment variable exceeds the ORACLE system-imposed limit.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Contact your customer support representative.<\/span><\/span><\/p>\n

\n
<\/a> ORA-02707: osnacx: cannot allocate context area<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0The invoked Unix two-task driver could not allocate heap space for the context area.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Contact your customer support representative.<\/span><\/span><\/p>\n

\n
<\/a> ORA-02708: osnrntab: connect to host failed, unknown ORACLE_SID<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0The invoked Unix two-task driver failed to find an entry in oratab for the sid you supplied.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0First, check whether you have read access to oratab, and see if the desired sid is there. Add an entry to oratab for the desired sid, if necessary.<\/span><\/span><\/p>\n

\n
<\/a> ORA-02709: osnpop: pipe creation failed<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0The pipe driver failed to create pipes for two-task communications with the oracle shadow process.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0You have probably exceeded the maximum number of open file descriptors per user or the system file table is full. Note the operating system error code and contact your system administrator.<\/span><\/span><\/p>\n

\n
<\/a> ORA-02710: osnpop: fork failed<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0The pipe driver could not fork the oracle shadow process.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Verify that there are enough system resources to support another process. The user or system process limit may have been exceeded, or the amount of free memory or swap space may be temporarily insufficient.<\/span><\/span><\/p>\n

\n
<\/a> ORA-02711: osnpvalid: write to validation channel failed<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0The pipe driver failed to write to the orapop process.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Contact your customer support representative.<\/span><\/span><\/p>\n

\n
<\/a> ORA-02712: osnpop: malloc failed<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0The pipe driver failed to allocate enough heap space for its context area buffers.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Contact your customer support representative.<\/span><\/span><\/p>\n

\n
<\/a> ORA-02713: osnprd: message receive failure<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0The pipe driver failed to read a message from the communications channel.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Contact your customer support representative.<\/span><\/span><\/p>\n

\n
<\/a> ORA-02714: osnpwr: message send failure<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0The pipe driver failed to write a message to the communications channel.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Contact your customer support representative.<\/span><\/span><\/p>\n

\n
<\/a> ORA-02715: osnpgetbrkmsg: message from host had incorrect message type<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0The pipe driver received a message having an unrecognizable message type.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Contact your customer support representative.<\/span><\/span><\/p>\n

\n
<\/a> ORA-02716: osnpgetdatmsg: message from host had incorrect message type<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0The Pipe driver received a message having an unrecognizable message type.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Contact your customer support representative.<\/span><\/span><\/p>\n

\n
<\/a> ORA-02717: osnpfs: incorrect number of bytes written<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0The Pipe driver sent a message that was apparently successful, but the number of bytes transmitted did not match the number of bytes furnished to the driver.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Contact your customer support representative.<\/span><\/span><\/p>\n

\n
<\/a> ORA-02718: osnprs: reset protocol error<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0The two-task driver could not reset the connection.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Contact your customer support representative.<\/span><\/span><\/p>\n

\n
<\/a> ORA-02719: osnfop: fork failed<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0The fast driver could not fork the oracle shadow process.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Verify that there are enough system resources to support another process. The user or system process limit may have been exceeded, or the amount of free memory or swap space may be temporarily insufficient.<\/span><\/span><\/p>\n

\n
<\/a> ORA-02720: osnfop: shmat failed<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0When the fast driver was invoked, processes failed to attach to the shared memory buffer. You probably supplied an illegal shared memory attach address, or the system ran out of data space to accomodate the buffer.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Try invoking the Fast driver later, or use the default attach address.<\/span><\/span><\/p>\n

\n
<\/a> ORA-02721: osnseminit: cannot create semaphore set<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0The Fast driver failed to get a semaphore set.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0The system-imposed limit on semaphores or semaphore identifiers may have been exceeded. Read the returned operating system error code and check with your system administrator.<\/span><\/span><\/p>\n

\n
<\/a> ORA-02722: osnpui: cannot send break message to orapop<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0The Pipe driver could not send a break message to orapop.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Contact your customer support representative.<\/span><\/span><\/p>\n

\n
<\/a> ORA-02723: osnpui: cannot send break signal<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0The Pipe driver could not send a break message to the ORACLE shadow process.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Contact your customer support representative.<\/span><\/span><\/p>\n

\n
<\/a> ORA-02724: osnpbr: cannot send break message to orapop<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0The Pipe driver could not send a break message to orapop.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Contact your customer support representative.<\/span><\/span><\/p>\n

\n
<\/a> ORA-02725: osnpbr: cannot send break signal<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0The Pipe driver could not send a break message to the ORACLE shadow process.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Kill system call failed. Check errno and contact customer support.<\/span><\/span><\/p>\n

\n
<\/a> ORA-02726: osnpop: access error on oracle executable<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0The Pipe driver could not access the oracle executable.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Check the permissions on the ORACLE executable and each component of the ORACLE_HOME\/bin path.<\/span><\/span><\/p>\n

\n
<\/a> ORA-02727: osnpop: access error on orapop executable<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0The Pipe driver could not access the orapop executable.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Check the permissions on the orapop executable and each component of the ORACLE_HOME\/bin path.<\/span><\/span><\/p>\n

\n
<\/a> ORA-02728: osnfop: access error on oracle executable<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0The Fast driver could not access the oracle executable.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Check the permissions on the ORACLE executable and each component of the ORACLE_HOME\/bin path.<\/span><\/span><\/p>\n

\n
<\/a> ORA-02729: osncon: driver not in osntab<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0The driver you have specified is not supported.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Check with your database administrator which drivers are supported.<\/span><\/span><\/p>\n

\n
<\/a> ORA-02730: osnrnf: cannot find user logon directory<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0The driver you have specified could not find your logon directory while searching for your local .sqlnet file.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Set and export the HOME environment variable to identify your home directory. Check with your system administrator to make sure that your uid and home directory are correct in the \/etc\/passwd file.<\/span><\/span><\/p>\n

\n
<\/a> ORA-02731: osnrnf: malloc of buffer failed<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0The specified driver could not find enough heap space to malloc a buffer.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Contact your customer support representative.<\/span><\/span><\/p>\n

\n
<\/a> ORA-02732: osnrnf: cannot find a matching database alias<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0Database alias specified was not identified in either $HOME\/.sqlnet or \/etc\/sqlnet.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Create the alias in a file called .sqlnet in your home directory for personal use or ask your system administrator to create the alias in \/etc\/sqlnet for system-wide use.<\/span><\/span><\/p>\n

\n
<\/a> ORA-02733: osnsnf: database string too long<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0While converting a database alias to a database ID, the resulting database ID string exceeded the ORACLE system-imposed limit.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Contact your customer support representative.<\/span><\/span><\/p>\n

\n
<\/a> ORA-02734: osnftt: cannot reset shared memory permission<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0The Fast driver was unable to reset shared memory permissions.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Contact your customer support representative.<\/span><\/span><\/p>\n

\n
<\/a> ORA-02735: osnfpm: cannot create shared memory segment<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0The Fast driver failed to create a shared memory segment for two-task communication.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Check whether the system-imposed limit on shared memory identifiers has already been reached for your system.<\/span><\/span><\/p>\n

\n
<\/a> ORA-02736: osnfpm: illegal default shared memory address<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0The Fast driver failed to establish a default shared memory address.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Contact your customer support representative.<\/span><\/span><\/p>\n

\n
<\/a> ORA-02737: osnpcl: cannot tell orapop to exit<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0The Pipe driver failed to send orapop the command to exit.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Contact your customer support representative.<\/span><\/span><\/p>\n

\n
<\/a> ORA-02738: osnpwrtbrkmsg: incorrect number of bytes written<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0The pipe driver apparently sent an imcomplete break message.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Contact your customer support representative.<\/span><\/span><\/p>\n

\n
<\/a> ORA-02739: osncon: host alias is too long<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0The alias used for a sqlnet host is longer than 161 characters.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Use a shorter alias.<\/span><\/span><\/p>\n

\n
<\/a> ORA-02750: osnfsmmap: cannot open shared memory file ?\/dbs\/ftt_pid<\/i>.dbf<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0The Fast driver failed to create a shared memory file for two-task communication.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Check the permissions on the directory ?\/dbs<\/span><\/span><\/p>\n

\n
<\/a> ORA-02751: osnfsmmap: cannot map shared memory file<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0The Fast driver failed to map a shared memory file for two-task communication.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Contact your customer support representative.<\/span><\/span><\/p>\n

\n
<\/a> ORA-02752: osnfsmmap: illegal shared memory address<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0The Fast driver failed to attach shared memory at the expected location.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Contact your customer support representative.<\/span><\/span><\/p>\n

\n
<\/a> ORA-02753: osnfsmmap: cannot close shared memory file<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0The Fast driver cannot close the shared memory file.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Contact your customer support representative.<\/span><\/span><\/p>\n

\n
<\/a> ORA-02754: osnfsmmap: cannot change shared memory inheritence<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0The Fast driver could not alter the inheritence attributes of the shared memory.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Contact your customer support representative.<\/span><\/span><\/p>\n

\n
<\/a> ORA-02755: osnfsmcre: cannot create chared memory file ?\/dbs\/ftt_pid<\/i>.dbf<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0The Fast driver failed to create a file for shared memory.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Check the permissions on the directory ?\/dbs<\/span><\/span><\/p>\n

\n
<\/a> ORA-02756: osnfsmnam: name translation failure<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0The Fast driver encountered an error translating the shared memory filename ?\/dbs\/ftt_pid<\/i>.dbf.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Contact your customer support representative.<\/span><\/span><\/p>\n

\n
<\/a> ORA-02757: osnfop: fork_and_bind failed<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0The Fast driver failed to fork a process onto the desired cluster and node number.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Check the desired node number in sercose[0] and cluster ID in sercose[1]. If these seem valid, contact customer support.<\/span><\/span><\/p>\n

\n
<\/a> ORA-02758: Allocation of internal array failed<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0The package was unable to allocate memory for an array because the system ran out of memory.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Either reclaim memory by killing other processes or reboot the machine with more memory.<\/span><\/span><\/p>\n

\n
<\/a> ORA-02759: Not enough request descriptors available<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0All of the package’s request descriptors are in use performing other requests.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Either wait until enough requests are done, or shut the package down and re-initialize it with more request descriptors.<\/span><\/span><\/p>\n

\n
<\/a> ORA-02760: Client close of file failed.<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0The client was unable to close a file after forking the servers.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0This is a system problem – contact your System Administrator.<\/span><\/span><\/p>\n

\n
<\/a> ORA-02761: File number to be canceled is negative.<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0The file number contained with the sfiov structure is less than zero.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0This may be a programming error. If it is not, contact ORACLE support.<\/span><\/span><\/p>\n

\n
<\/a> ORA-02762: file number to be cancelled is greater than the maximum.<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0The file number contained with the sfiov structure is greater than the maximum.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0This may be a programming error. If it is not, contact ORACLE support.<\/span><\/span><\/p>\n

\n
<\/a> ORA-02763: Unable to cancel at least one request<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0No requests were found that could be cancelled.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0This error can occur if all the requests dealing with that file number have already been filled.<\/span><\/span><\/p>\n

\n
<\/a> ORA-02764: Invalid package mode<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0The mode of the package can only be parallel or duplex.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0See sfa.h for the correct values.<\/span><\/span><\/p>\n

\n
<\/a> ORA-02765: Invalid maximum number of servers<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0The number of servers given was less than or equal to zero.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Use a number greater than zero.<\/span><\/span><\/p>\n

\n
<\/a> ORA-02766: Invalid maximum of request descriptors<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0The number of request descriptors was less than or equal to zero.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Use a number greater than zero.<\/span><\/span><\/p>\n

\n
<\/a> ORA-02767: Less than one request descriptor was allocated per server<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0The package requires that the number of request descriptors be greater than or equal to the number of servers used.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Use a higher number<\/span><\/span><\/p>\n

\n
<\/a> ORA-02768: Maximum number of files is invalid<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0The maximum number of files to be used by the package was less than or equal to zero.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Use a positive number.<\/span><\/span><\/p>\n

\n
<\/a> ORA-02769: Setting of handler for SIGTERM failed<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0The package was unable to set up handling by the server for the termination signal. This is an internal error.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Contact ORACLE support.<\/span><\/span><\/p>\n

\n
<\/a> ORA-02770: Total number of blocks is invalid<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0The total number of blocks to be allocated for use by the package was not greater than zero.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Use a positive number.<\/span><\/span><\/p>\n

\n
<\/a> ORA-02771: Illegal request time out value<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0The number was not a positive number.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Use a positive number.<\/span><\/span><\/p>\n

\n
<\/a> ORA-02772: Invalid maximum server idle time<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0The time given was not a positive number.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Use a positive number.<\/span><\/span><\/p>\n

\n
<\/a> ORA-02773: Invalid maximum client wait time<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0The time given was not a positive number.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Use a positive number.<\/span><\/span><\/p>\n

\n
<\/a> ORA-02774: Invalid request list latch time out value<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0The time given was not a positive number.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Use a positive number.<\/span><\/span><\/p>\n

\n
<\/a> ORA-02775: Invalid request done signal<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0The signal number was not a positive number.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Use a positive number.<\/span><\/span><\/p>\n

\n
<\/a> ORA-02776: Value for request done signal exceeds maximum<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0The value sent to the package for use as the “request done” signal exceeds the maximum allowed by the operating system.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0n\/a<\/span><\/span><\/p>\n

\n
<\/a> ORA-02777: Stat failed on log directory<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0The package was unable to get information about the directory in which the log files are to reside.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Check the permissions on the directory or use a different directory name.<\/span><\/span><\/p>\n

\n
<\/a> ORA-02778: Name given for the log directory is invalid<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0The name given for the directory in which the logs are to be kept does not correspond to a directory.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Use a different name.<\/span><\/span><\/p>\n

\n
<\/a> ORA-02779: Stat failed on core dump directory<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0The package was unable to get information about the directory into which the servers are to dump core in the event of an exception.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Check the permissions on the directory or use a different directory name.<\/span><\/span><\/p>\n

\n
<\/a> ORA-02780: Name given for the core dump directory is invalid<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0The name given for the directory in which the server processes are to dump core in the event of an exception does not correspond to a directory.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Use a different name.<\/span><\/span><\/p>\n

\n
<\/a> ORA-02781: Invalid value given for the timing wanted flag<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0The value given was not TRUE or FALSE.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0n\/a<\/span><\/span><\/p>\n

\n
<\/a> ORA-02782: Both read and write functions were not specified<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0To ensure that the functions act symmetrically, pointers to both the read and write functions must be given.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Either specify both functions or specify neither. The package will supply its own functions.<\/span><\/span><\/p>\n

\n
<\/a> ORA-02783: Both post and wait functions were not specified<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0To ensure that the functions act symmetrically, pointers to both the posting and waiting functions must be given.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Either specify both functions or specify neither. The package will supply its own functions.<\/span><\/span><\/p>\n

\n
<\/a> ORA-02784: Invalid shared memory ID specified<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0The ID of the segment specified for use as the shared buffer region was invalid.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Use a different ID, or let the package specify its own.<\/span><\/span><\/p>\n

\n
<\/a> ORA-02785: Invalid shared memory buffer size<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0The size given for the shared memory segment to be used as the shared buffer region was less than or equal to zero.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Use a positive number.<\/span><\/span><\/p>\n

\n
<\/a> ORA-02786: Size needed for shared region is greater than segment size<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0The size of the shared segment that was specified for the shared buffer region is less than the number of bytes required. The first field of the “additional information” field is the size needed. The second is the size of the segment.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Use a larger size segment or let the package allocate its own.<\/span><\/span><\/p>\n

\n
<\/a> ORA-02787: Unable to allocate memory for segment list<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0The package cannot allocate memory for an internal segment list because the system has run out of memory. The “additional information” field is the amount of memory that the package attempted to allocate.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0n\/a<\/span><\/span><\/p>\n

\n
<\/a> ORA-02788: Unable to find kernel process pointer in async process array<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0Internal error – Contact ORACLE support.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0n\/a<\/span><\/span><\/p>\n

\n
<\/a> ORA-02789: Maximum number of files reached<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0The maximum number of files that can be used for asynchronous I\/O has been reached.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Shut down the servers and re-initialize the package with a higher number.<\/span><\/span><\/p>\n

\n
<\/a> ORA-02790: File name is too long<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0The length of the name of a file that is being opened for asynchronous I\/O is longer than the maximum. The “additional information” field is the maximum length.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Use a shorter name.<\/span><\/span><\/p>\n

\n
<\/a> ORA-02791: Unable to open file for use with asynchronous I\/O<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0The package could not open file for some reason.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Check the file name.<\/span><\/span><\/p>\n

\n
<\/a> ORA-02792: Unable to fstat() a file being used for asynchronous I\/O.<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0The fstat(2) call on a file being used for asynchronous I\/O failed.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Check the file name.<\/span><\/span><\/p>\n

\n
<\/a> ORA-02793: Close of asynchronous I\/O failed.<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0The client was unable to close a file being used for asynchronous I\/O.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Contact ORACLE support – this should not happen.<\/span><\/span><\/p>\n

\n
<\/a> ORA-02794: Client unable to get key for shared memory<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0The client was unable to get a key so that it obtain shared memory for use with shared memory.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Contact ORACLE support – this is an internal error.<\/span><\/span><\/p>\n

\n
<\/a> ORA-02795: Request list is empty<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0The client was signalled by a server that it was done with a request but the “done” list was empty.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Internal error – contact ORACLE support.<\/span><\/span><\/p>\n

\n
<\/a> ORA-02796: Done request is not in correct state<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0A request is not in the right state.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Internal error – contact ORACLE support.<\/span><\/span><\/p>\n

\n
<\/a> ORA-02797: No requests available<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0No free request descriptors are available.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Wait until some requests are filled and then retry the request, or shutdown the servers and initialize the package with a higher number of requests.<\/span><\/span><\/p>\n

\n
<\/a> ORA-02798: Invalid number of requests<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0The number of operations sent to either sfard() or sfawrite() is less than zero.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0This is a user programming error.<\/span><\/span><\/p>\n

\n
<\/a> ORA-02799: Unable to arm signal handler<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0The arming of a signal handler for the “done” signal failed.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0Internal error – contact ORACLE support.<\/span><\/span><\/p>\n

\n
<\/a> ORA-02800: Requests timed out<\/b><\/span><\/span><\/span><\/dt>\n<\/dl>\n

Cause:<\/b>\u00a0Some of the requests for asynchronous input or output were not serviced in the required amount of time.<\/span><\/span><\/p>\n

Action:<\/b>\u00a0If the load on the system is high, it is possible that the timeout limit is too low. Reset it with sfainit(). If the server processes are dying due to unexpected signals, this is an internal error, and ORACLE support should be contacted.<\/span><\/span><\/p>\n

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

Oracle 12c R2 Error Codes and Solution Suggestions from ORA-02600 to ORA-02800 ORA-02600: credential name is invalid:\u00a0string Cause:\u00a0An invalid credential name was specified. Action:\u00a0Verify credential name and retry the operation. ORA-02601: credential already exists:\u00a0string Cause:\u00a0Credential name specified already used by an existing object. Action:\u00a0Verify credential name and retry the operation. ORA-02602: credential does not exist:\u00a0string…<\/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-2129","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-yl","jetpack_sharing_enabled":true,"_links":{"self":[{"href":"http:\/\/www.fatihacar.com\/blog\/wp-json\/wp\/v2\/posts\/2129","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=2129"}],"version-history":[{"count":1,"href":"http:\/\/www.fatihacar.com\/blog\/wp-json\/wp\/v2\/posts\/2129\/revisions"}],"predecessor-version":[{"id":2130,"href":"http:\/\/www.fatihacar.com\/blog\/wp-json\/wp\/v2\/posts\/2129\/revisions\/2130"}],"wp:attachment":[{"href":"http:\/\/www.fatihacar.com\/blog\/wp-json\/wp\/v2\/media?parent=2129"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/www.fatihacar.com\/blog\/wp-json\/wp\/v2\/categories?post=2129"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/www.fatihacar.com\/blog\/wp-json\/wp\/v2\/tags?post=2129"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}