Network Data Pump Errors

From: Scott Canaan <srcdco_at_rit.edu>
Date: Tue, 19 Apr 2016 16:30:23 +0000
Message-id: <49a1b5dc6e7e40a7a467f1d878cbde83_at_ex04mail01b.ad.rit.edu>

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

Received on Tue Apr 19 2016 - 18:30:23 CEST