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

Thanks Mladen and Amir. Case was opened 2 days back. Waiting on them. So far not much progress on the SR.

On Sat, Nov 10, 2018 at 4:01 PM Mladen Gogala <gogala.mladen_at_gmail.com> wrote:

>
> 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