Install Oracle client and SQLLDR on Linux

1, the establishment of Oracle installation directory, generally/opt/oracle;
2, put the installation package instantclient-basic-linux.x64-11.2.0.3.0.zip into the directory, and extract: Unzip XXX, generate directory:/opt/oracle/instantclient_11 _2;;
3. Create a new Tnsnames.ora file in the/opt/oracle/instantclient_11_2 directory to write the database connection information;
4. Configure environment variables:/ect/profile file
Export Oracle_home=/opt/oracle
export Nls_lang=american_america. ZHS16GBK
Export Oracle_ic_home=/opt/oracle/instantclient_11_2
export oracle_home= $ORACLE _ic_home
export tns_admin= $ORACLE _ic_home
export path= $PATH: $HOME/bin: $ORACLE _ic_home
export ld_library_path= $ORACLE _ic_home:/usr/lib
Export Oracle_sid=newst (database connection string name)
5, the new directory:/OPT/ORACLE/INSTANTCLIENT_11_2/RDBMS/MESG, and put ULUS.MSB files to the place;
6, put Sqlldr and sqlplus into the/opt/oracle/instantclient_11_2 directory after decompression;
7. Directory Structure:

8, use the command sqlldr and Sqlplus test;
9, the RDBMS directory needs to be empowered;

Install Oracle client and SQLLDR on Linux