EXP-00056: ORACLE error 12714 encountered

When using export next errors may be shown:

EXP-00056: ORACLE error 12714 encountered

ORA-12714: invalid national character set specified

And your

NLS_NCHAR_CHARACTERSET is for example  US7ASCII, WE8ISO8859P1, CL8MSWIN1251
then you have to:

Change the tables to use CHAR, VARCHAR2 or CLOB instead the N-type

or
use export/import the table(s) containing N-type columns and truncate those tables before migrating to Oracle9i+

The recommended NLS_LANG during export is simply the NLS_CHARACTERSET,
not the NLS_NCHAR_CHARACTERSET
To check if there is such users that hace 'NCHAR' columns:

select distinct OWNER, TABLE_NAME from DBA_TAB_COLUMNS where
DATA_TYPE in ('NCHAR','NVARCHAR2', 'NCLOB') and OWNER not in
('SYS','SYSTEM');


Users with such columns are usually sample schemas instaled in database HR,OE,IX or HR8, OE8.....

ERROR EXP-00104: datatype (BINARY_DOUBLE) of column is not supported, table will not be exported

If using exp to export data from a database, user, table.... and got error:

EXP-00104: datatype (BINARY_DOUBLE) of column %COLUMN_NAME% in table %TABLE_NAME% is not supported, table will not be exported

than solution is to use DataPump Export (expdp) instead of conventional Export (exp).

Source: Metalink "Export Failed Due To EXP-104 Error Datatype"

ERROR ORA-12170: TNS:Connect timeout occurred when you try to connect to Oracle Database over firewall

When i try to connect to Oracle 10gR2 database over Cisco ASA Firewall i got ORA-12170 error despite that tnsping-ing "tnsnames_entry" is going just fine. On ASA i set up incoming and outgoing NAT address. Only difference is that listener of database is not configured on standard port of 1521 (it was set at non-default port of 1531)

The problem was resolved with the help i got on this link: What is the advantage of enabling sqlnet inspection in ASA appliance.

After setting following parameter in ASA config:

fixup protocol sqlnet 1531