Re: ORA-01647 during TTS IMPDP from 11.2.0.4 64 bit Solaris SPARC to 12.1.0.2 64 bit RHEL

On 11/10/18 6:44 PM, Sundar Mahadevan wrote:
> Thanks Mladen for reverting back. Yes, I did
> run DBMS_TTS.TRANSPORT_SET_CHECK, with the constraints included, on
> the source side and it returned no issues.
>
> ${ORACLE_HOME}/bin/sqlplus -s /nolog << eom
> > set head off feedback on pages 0 lines 400 echo on
> > connect / as sysdba
> > execute
> sys.dbms_tts.transport_set_check('ARGUS_AEXP_DATA_01,ARGUS_AEXP_INDEX_01,DLP_INDEX_06,DLP_INDEX_04,ARGUS_DATA_01,
> -
> >
> DLP_DATA_04,ARGUS_AL_INDEX_01,XDB,ARGUS_INDEX_03,ARGUS_INDEX_06,ESM_INDEX_01,ARGUS_DATA_02,ARGUS_DATA_04,DLP_INDEX_05,
> -
> >
> ARGUS_INDEX_01,ARGUS_DATA_03,DLP_DATA_01,ARGUS_AL_DATA_01,ARGUS_INDEX_02,DLP_DATA_02,DLP_DATA_05,ARGUS_DATA_05,ARGUS_INDEX_04,
> -
> >
> DLP_INDEX_03,DLP_DATA_03,DLP_INDEX_02,ESM_DATA_01,DLP_LOB_01,DLP_INDEX_01,USERS,ARGUS_INDEX_05',
> true, true);
> > select * from sys.transport_set_violations;
> > eom
>
> PL/SQL procedure successfully completed.
>
>
> no rows selected
>

It looks like a bug in Oracle 12c on RHEL. You should open a support case. If TTS check didn't report any issues, your tablespaces should have been imported. The only thing that comes to mind is some curious file protection issue which prevents Oracle 12c on Linux to open the file for writing.

-- 
Mladen Gogala
Database Consultant
Tel: (347) 321-1217

--
http://www.freelists.org/webpage/oracle-l