SQL loader data import problems

SQL loader data import problems encountered when using oracle SQL loader tool to import data, the specific shell script is as follows: 01 #! /Bin/bash02 03 04 export LANG = zh_CN.GBK05 export NLS_LANG = export ORACLE_BASE =/u01/oracle07 export ORACLE_HOME =/u01/oracle08 09 10 export PATH = "$ PATH: $ ORACLE_BASE: $ ORACLE_HOME: $ ORACLE_SID: 11 12 $ ORACLE_HOME/bin "13 14 15 SQLLDR ="/u01/oracle/bin/sqlldr "16 ORACLE_USER =" username "17 ORACLE_PWD =" password "18 ORACLE_SID =" orcl" 19 20 21 CTL_FILE = "/home/***/test. ctl "22 DATA_FILE ="/home/***/test/test.txt "23 LOG_FILE ="/home/***/test. log "24 BAD_FILE ="/home/***/test. bad "25 26 27" $ SQLLDR "" $ ORACLE_USER "/" $ ORACLE_PWD "@" $ ORACLE_SID "28 29 control =" $ CTL_FILE "data =" $ DATA_FILE "direct = true BAD = "$ BAD_FILE" 30 31log = "$ LOG_FILE" 2> & 1 Question 1: SQL * Loader-704: Internal error: ulconnect: OCIServerAttach [0] ORA-12532: TNS: invalid argument cause: Database sid Path Problem Solution: Configure Oracle sid to localhost: port Number/sid Name, must specify the database address and port number problem 2: ORA-12705: Cannot access NLS data files or invalid environment specified reason: NLS_LANG configuration is incorrect, the reason may be that the NLS_LANG does not exist or the above error is reported because I wrote AMERICAN_AMERICA.ZHS16GBK as AMERICAN_AMERICAN.ZHS16GBK IN THE NLS_LANG = AMERICAN_AMERICA.ZHS16GBK.