Non-Oralce user environment variable configuration

Non-Oralce user environment variable configuration

In the project, you need to configure environment variables for web users of the same server to execute sqlldr of Oracle, and record the implementation steps and problems:

(1) copy the settings of the. profile file in the oracle directory for the database environment variables to the. profile file of the web user;

Command Execution Error

$ Sqlldr
Sh: sqlldr: not found.

View, it is found that the web user does not have the execution permission for the oracle_home directory, and cannot enter the bin directory

(2) Use chmod 755 $ oracle_home to change Directory Permissions

Command Execution Error

$ Sqlldr
/Usr/lib/hpux64/dld. so: Unable to find library 'libntsh. so.10.1 '.
Killed

Check and find that you do not have access to $ oracle_home/lib

(3) Use chmod 755 $ oracle_home/lib to change Directory Permissions

Command Execution Error

$ Sqlldr
Message 2100 not found; No message file for product = RDBMS, facility = ULMessage 2100 not found; No message file for product = RDBMS, facility = UL $

After some verification, it is found that the corresponding permissions must be granted to the $ oracle_home/rdbms/mesg directory.

Finally, the command sqlldr can be correctly executed.

Summary: When you need to configure sqlldr for non-oracle users, you not only need to configure environment variables, but also need to grant the access permission of related directories to the user.