To add to Jeff's comment, you'll need an entire Oracle 9.2 client, or 9.2
server install to make sure you have all the NLS files needed for export to
work correctly. You cannot just copy one binary and expect it to work.
I "think" the export/import utilities were included in the 9i client but
I'm not 100% positive. So, first I would try installing the 9i client to
either the 10g server, or to a machine that has access to connect to the
10g environment.
Once installed, make sure you environment variables such as ORACLE_HOME are
set to your 9i installation for your SESSION and rerun the export against
the 10g database.
HTH
Chris
On Tue, Jan 26, 2016 at 2:25 PM, Beckstrom Jeffrey <JBECKSTROM@xxxxxxxxx>
wrote:
You have to run 9i export against the 10g database. The version of the
export dump has to match the version of the database you will be importing
to.
Target: Oracle 9i Release 2 (Production server)Jimmy Brock <jimmybrock@xxxxxxxxx> 1/26/16 3:16 PM >>>
Source: Oracle 10g Release 2 (Stage server)
On 10g I used EXP to export data. When importing into 9i I get an error:
IMP-00010: not a valid export file, header failed verification
IMP-00000: Import terminated unsuccessfully
So i used SCP to copy the Oracle 9i EXP tool over to the 10g server. Now I
encountered this error:
EXP-00056: ORACLE error 12705 encountered
ORA-12705: Cannot access NLS data files or invalid environment specified
At this point I logged into the Oracle 9i and did a small export to see
what the NLS setttings were:
Export done in US7ASCII character set and AL16UTF16 NCHAR character set
server uses WE8ISO8859P1 character set (possible charset conversion)
So on the 10g server I modified the NLS_LANG setting:
export NLS_LANG=AMERICAN_AMERICA.US7ASCII
Now I get this error:
EXP-00056: ORACLE error 3106 encountered
ORA-03106: fatal two-task communication protocol error
The oerr utility doesn't provide much insight:
ora92 >oerr ora 3106
03106, 00000, "fatal two-task communication protocol error"
// *Cause:
// *Action:
I need this to run on 10g (source) database. Because 9i (production)
cannot connect to 10g. It is a production system so they have it locked
down.
--
Jimmy Brock
.