RHEL6 + Oracle 11g Client Rapid deployment
Requirements: Just use the client's Sqlplus, Sqlldr function.
Scenario: Fast deployment of clients with Lite version
1. Upload Oracle Lite client to server/tmp directory, unzip to/opt directory, rename to OracleClient
# CD/unzip /tmp/oracle_instantclient_11_2_for_linux. Zip mvchown -R orajy:orajy/opt/oracleclient
2. Environment variable configuration (/BIN/CSH)
2.1 Modifying the installation Client user shell environment for/BIN/CSH
#VI /etc/passwd--Modify the user shell to install the Oracle client as/BIN/CSH
2.2 Log in to the installation user (assuming the client installs the user as ORAJY), configure the environment variables
Su-orajy
VI ~/.CSHRC
setenv oracle_home/opt/oracleclient//opt/"simplified Chinese_china. ZHS16GBK ""yyyy-mm-dd HH24:Mi:SS"/opt/oracleclient/ Instantclient_11_2: $PATH
SOURCE ~/.CSHRC Effective environment variable
Note: This lite version of the installation package Sqlplus,sqlldr in the $oracle_home directory, Tnsnames.ora in the/opt/oracleclient/directory.
-- give Sqlplus,sqlldr Execute permissions CD $ORACLE _homechmod u+x sqlplus Sqlldr
3. Test Authentication Client Sqlplus, SQLLDR available, any directory input command will return the following prompt to prove that the client configuration is successful.
$ sqlplussql 11.2. 0.1. 0 - : 1982, Oracle. All rights reserved. Please enter your user name :
$ sqlldrsql*loader:release11.2.0.1.0-Production on Friday September - the: the: to theCopyright (c)1982, the, Oracle and/or its affiliates. All rights reserved. Usage: SQLLDR keyword=value [, keyword=value,...] Valid keywords: userid--ORACLE User name/Password Control--control File name log--log file name bad--error file name Data--data file name Discard--obsolete file name Discardmax--number of files allowed to be discarded (all default) Skip--The number of logical records to skip (default0) Load--The number of logical records to load (all default) errors--Number of errors allowed (default -) Rows--The number of rows between the regular path-bound array or the direct path to save data (default: Regular path -, all direct paths) Bindsize--the size of the regular path-bound array (in bytes) (default256000) Silent--Hide messages during run (header, feedback, error, discard, partition) direct--use direct path (default FALSE) Parfile--parameter file: The name of the file that contains the parameter description parallel--performing a parallel load (default FALSE)file--the file to allocate extents from the following objects Skip_unusable_indexes--Not allowed/allow use of useless indexes or index partitions (default FALSE) Skip_index_maintenance--The index is not maintained and the affected index is marked as useless (default FALSE) commit_discontinued--the row that was loaded when the load interrupt was submitted (default FALSE) ReadSize--the size of the read buffer (default1048576) external_table--use external tables for loading; not_used, Generate_only, EXECUTE (default not_used) Columnarrayrows--The number of rows in the Direct path column array (default the) Streamsize--the size of the direct road runoff buffer (in bytes) (default256000) Multithreading--using multithreaded resumable in a direct path--enables or disables the current recoverable session (default FALSE) Resumable_name--a text string that helps identify a recoverable statement resumable_timeout--Resumable wait time (in seconds) (default7200) Date_cache--Date conversion cache size (in entries) (default +) No_index_errors--abort load when any index error occurs (default FALSE) Please note: command-line arguments can be specified by location or by keyword. Examples of the former are'SqlldrScott/tiger Foo'; an example of the latter case is'Sqlldr control=Foouserid=scott/tiger'. The location specifies that the parameter must be before the timebut not later than the parameters specified by the keyword. For example, allow'sqlldr scott/tiger Control=foo logfile=log', but not allowed'sqlldr scott/tiger control=foo log', even if the parameter'Log'Position is correct.
Fast deployment of Oracle Lite client on Linux