SQLLDR is installed oracle11.1 guided missiles from the virtual machine, the need to connect to the remote oracle server is oracle10 version, up sqlplus 12.0.2 version before installation,
Error message is as follows:
SQL * Loader: Release 11.1.0.6.0 - Production on Wed Dec 30 10:36:55 2015

Copyright (c) 1982, 2007, Oracle. All rights reserved.

SQL * Loader - 704: Internal error: ulconnect: OCIEnvCreate [1]


/usr/lib/oracle/12.1/network/admin/tnsnames. Ora file content is as follows (-. -. -. - the specific IP) :
The DB=
(the DESCRIPTION=
(ADDRESS=(TCP) PROTOCOL=(HOST=-. -. -. -) (1521) PORT=)
(ADDRESS=(TCP) PROTOCOL=(HOST=-. -. -. -) (1521) PORT=)
(ADDRESS=(TCP) PROTOCOL=(HOST=-. -. -. -) (1521) PORT=)
(ADDRESS=(TCP) PROTOCOL=(HOST=-. -. -. -) (1521) PORT=)
(LOAD_BALANCE=yes)
(CONNECT_DATA=
https://bbs.csdn.net/topics/(=DEDICATED SERVER)
(SERVICE_NAME=db3_2)
)
)


The/etc/profile content is as follows:
Export ORACLE_BASE=/usr/lib/oracle/12.1/client64
Export ORACLE_HOME=$ORACLE_BASE
Export TNS_ADMIN=/usr/lib/oracle/12.1/network/admin/
Export LD_LIBRARY_PATH=$ORACLE_HOME/lib: $HOME/lib/usr/lib:
The export PATH=$PATH: $ORACLE_HOME/bin/: $HOME/bin
Export SHLIB_PATH=/usr/share/oracle/12.1/client64
The export is=db3_2

CodePudding user response:

1, change the environment variables to oracle11g, ORACLE_BASE, ORACLE_HOME.
2, will be under oracle12c tnsnames. Ora a copy to the oracle11g $ORACLE_HOME/NETWORK/admin/tnsnames. Ora;
3, make sure can find your control file;

CodePudding user response:

Thank you very much! @ LHDZ_BJ,