Subject: Re: ORA-01647 during TTS IMPDP from 11.2.0.4 64 bit Solaris SPARC to
 12.1.0.2 64 bit RHEL
To: Sundar Mahadevan <sundarmahadevan82@gmail.com>
Cc: ORACLE-L <oracle-l@freelists.org>
References: <CADmQEr5Eej9dgtXSQ3A6JzXkio9fF7=jrhfwf2Dhb=YbUugt4A@mail.gmail.com>
 <cde4c57b-57cd-3fb7-82be-6de3d81bed3e@gmail.com>
 <CADmQEr5j0xqGaSjGvkrjVJwF-_ZNNZO0vupjPEyrWX53==xLqA@mail.gmail.com>
From: Mladen Gogala <gogala.mladen@gmail.com>
Message-ID: <974aaa8b-ce42-05d6-bc33-5e1fae4c10ce@gmail.com>
Date: Sat, 10 Nov 2018 19:01:22 -0500
User-Agent: Mozilla/5.0 (X11; Linux x86_64; rv:60.0) Gecko/20100101
 Thunderbird/60.2.1
MIME-Version: 1.0
In-Reply-To: <CADmQEr5j0xqGaSjGvkrjVJwF-_ZNNZO0vupjPEyrWX53==xLqA@mail.gmail.com>
Content-Type: text/plain; charset=utf-8; format=flowed
Content-Transfer-Encoding: 8bit
Content-Language: en-US
Sender: oracle-l-bounce@freelists.org
Errors-to: oracle-l-bounce@freelists.org
Precedence: normal
Reply-To: gogala.mladen@gmail.com


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