Re: Network Data Pump Errors

Is your db link private?

Sent from my iPhone

> On Apr 19, 2016, at 12:30 PM, Scott Canaan <srcdco_at_rit.edu> wrote:
>
> I’m trying to use the network data pump to migrate data from one server to another. I’ve done this many, many times without an issue, until now.
>
> The new database is 12.1.0.2 on Red Hat 7. The old database is 11.2.0.4 on Red Hat 6. I created the database link and can select from it, so the port is open:
>
> SQL> select dbid, name from v$database_at_old_psamtest;
>
> DBID NAME
> ---------- ---------
> 2444256594 PSAMTEST
>
> When I try to do the impdp, I get the following errors:
>
> oracle_at_prosamtest02b:PSAMTEST>impdp schemas=sigdev directory=data_pump_dir ne>
>
> Import: Release 12.1.0.2.0 - Production on Tue Apr 19 12:21:26 2016
>
> Copyright (c) 1982, 2014, Oracle and/or its affiliates. All rights reserved.
>
> Username: / as sysdba
>
> Connected to: Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production
> With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options
> ORA-39006: internal error
> ORA-39113: Unable to determine database version
> ORA-06550: line 1, column 7:
> PLS-00352: Unable to access another database 'OLD_PSAMTEST.RIT.EDU'
> ORA-06550: line 1, column 7:
> PLS-00201: identifier 'SYS_at_OLD_PSAMTEST.RIT.EDU' must be declared
> ORA-06550: line 1, column 7:
> PL/SQL: Statement ignored
>
> ORA-39097: Data Pump job encountered unexpected error -6550
>
> oracle_at_prosamtest02b:PSAMTEST>
>
> The directory exists:
>
> SQL> create directory data_pump_dir as '/oracle/PSAMTEST/data/export';
>
> Directory created.
>
> SQL>
>
> I have looked online and can’t find anything with these particular errors.
>
> Scott Canaan ’88 (srcdco_at_rit.edu)
> (585) 475-7886 – work (585) 339-8659 – cell
> “Life is like a sewer, what you get out of it depends on what you put into it.” – Tom Lehrer
>

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