RE: Network Data Pump Errors

From: Scott Canaan <srcdco_at_rit.edu>
Date: Tue, 19 Apr 2016 17:35:49 +0000
Message-id: <44b022ad0f9b4ff081d031e2c139f8b9_at_ex04mail01b.ad.rit.edu>

It is public.

I’ve done this about 100 times over the last 3 years, which is why I can’t figure out what’s wrong with this one. I’m beginning to think that it has something to do with the Red Hat 7 cluster that the database lives on. This is the first time I’ve done this on a cluster.

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

From: Ram [mailto:ram.cheruvattath_at_gmail.com] Sent: Tuesday, April 19, 2016 1:33 PM
To: Scott Canaan
Cc: oracle-l_at_freelists.org
Subject: Re: Network Data Pump Errors

Refer to MOS doc 2100177.1

Is your db link private?

Sent from my iPhone

On Apr 19, 2016, at 12:30 PM, Scott Canaan <srcdco_at_rit.edu<mailto: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<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 - 19:35:49 CEST