Datasource Synchronization Fails With ORA-01658: unable to create INITIAL extent for segment in tablespace GRC865 (Doc ID 2186412.1)

Last updated on SEPTEMBER 24, 2016

Applies to:

Oracle Application Access Controls Governor - Version 8.6.5 and later
Information in this document applies to any platform.

Symptoms

On : 8.6.5 version, Application Access Contr. Gov.

In GRC application, when run the access synchronization to make sure the GRC repository with current EBS data, the access synchronization job fails with below error message in grc.log file.

ERROR
-----------------------
2016-09-19 16:58:53,560 ERROR [GrcExecutorThread-129] EtlJob:297 Access Sync Failed - Tcg Etl will be skipped
oracle.apps.grc.dataservices.exception.DataServiceException: Datasource synch failed
2016-09-19 16:58:53,563 ERROR [GrcExecutorThread-129] EtlJob:323 Error occured in EtlJob
oracle.apps.grc.common.job.JobExecutionException: oracle.apps.grc.dataservices.exception.DataServiceException: Datasource synch failed


STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Navigate to Setup and Administration > Manage Application Datasources.
2. Select a datasource.
3. Go to Actions > Run Synchronize Access.
4. Go to Manage Jobs page and review the job status.

BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, users cannot able to synchronize the datasource with EBS database.

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms