Target: Oracle 9i Release 2 (Production server)
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
