Task #786
configure Oracle Instant Client 10.2.0.4
| Status: | Work Completed-End life cycle | Start date: | February 16, 2011 | |
|---|---|---|---|---|
| Priority: | Normal | Due date: | February 17, 2011 | |
| Assignee: | % Done: | 100% | ||
| Category: | - | Estimated time: | 3.00 hours | |
| Target version: | - | Spent time: | - |
Description
Note for sample configuration on CentOS release 5.4 (Final)
History
#1
Updated by Ahmad Hazri over 13 years ago
- Status changed from New - Begin Life Cycle to Development / Work In Progress
A. Install Instant Client - RPM version
i)Basic
ii)SQL Plus package
iii) JDBC package
B. Set ENV - .bash_profile
LD_LIBRARY_PATH=/usr/lib/oracle/10.2.0.4/client/lib
TNS_ADMIN=/usr/lib/oracle/10.2.0.4/client/network/admin
ORACLE_SID=DB1
export JAVA_HOME PATH LD_LIBRARY_PATH ORACLE_SID TNS_ADMIN
#2
Updated by Ahmad Hazri over 13 years ago
testing
i)Login as oracle.
ii) execute
sqlplus ateh/password@db1
check version
SQL > select * from v$version where banner like 'Oracle%';
#3
Updated by Ahmad Hazri over 13 years ago
- Status changed from Development / Work In Progress to Work Completed-End life cycle
#4
Updated by Ahmad Hazri over 13 years ago
- % Done changed from 20 to 100
sample TNSNAME.ORA
DB1 =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = dbhost)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = DB1)
)