Well, setting the streams_pool_size to 0 fixed the problem.
Scott Canaan ’88 (srcdco@xxxxxxx<mailto:srcdco@xxxxxxx>)
(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: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] On ;
Behalf Of Scott Canaan
Sent: Tuesday, April 19, 2016 1:36 PM
To: Ram
Cc: oracle-l@xxxxxxxxxxxxx
Subject: RE: Network Data Pump Errors
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@xxxxxxx<mailto:srcdco@xxxxxxx>)
(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@xxxxxxxxx]
Sent: Tuesday, April 19, 2016 1:33 PM
To: Scott Canaan
Cc: oracle-l@xxxxxxxxxxxxx<mailto:oracle-l@xxxxxxxxxxxxx>
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@xxxxxxx<mailto:srcdco@xxxxxxx>> 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@old_psamtest;
DBID NAME
---------- ---------
2444256594 PSAMTEST
When I try to do the impdp, I get the following errors:
oracle@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@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@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@xxxxxxx<mailto:srcdco@xxxxxxx>)
(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