|
updated private test
|
1 |
### Cent OS 5 |
| 2 | ||
|
prepare oracle test
|
3 |
# Download |
|
updated private test
|
4 |
cd /usr/local/src |
| 5 |
curl -L http://download.oracle.com/otn/linux/oracle10g/xe/10201/oracle-xe-univ-10.2.0.1-1.0.i386.rpm > oracle-xe-univ-10.2.0.1-1.0.i386.rpm |
|
|
prepare oracle test
|
6 | |
| 7 |
# Install |
|
| 8 |
rpm -ivh oracle-xe-univ-10.2.0.1-1.0.i386.rpm |
|
| 9 |
/etc/init.d/oracle-xe configure |
|
| 10 | ||
| 11 |
# Note |
|
| 12 |
Port number is set to 8090 |
|
| 13 | ||
| 14 |
# HTTP access |
|
| 15 |
http://127.0.0.1:8090/apex |
|
| 16 | ||
| 17 |
# Create user |
|
| 18 |
id: dbix_custom |
|
| 19 |
password: dbix_custom |
|
| 20 | ||
| 21 |
Add all privirage |
|
| 22 | ||
| 23 |
# DBD::Oracle |
|
| 24 |
You must be install install client |
|
| 25 |
oracle-instantclient11.2-basic-11.2.0.2.0.i386.rpm |
|
| 26 |
oracle-instantclient11.2-devel-11.2.0.2.0.i386.rpm |
|
| 27 |
oracle-instantclient11.2-sqlplus-11.2.0.2.0.i386.rpm |
|
| 28 | ||
| 29 |
rpm -hiv oracle-instantclient11.2-basic-11.2.0.2.0.i386.rpm |
|
| 30 |
rpm -hiv oracle-instantclient11.2-devel-11.2.0.2.0.i386.rpm |
|
| 31 |
rpm -hiv oracle-instantclient11.2-sqlplus-11.2.0.2.0.i386.rpm |
|
| 32 | ||
| 33 |
vi /etc/profile.d/oracle.sh |
|
| 34 |
export ORACLE_HOME='/usr/lib/oracle/11.2/client' |
|
| 35 |
export C_INCLUDE_PATH='/usr/include/oracle/11.2/client' |
|
| 36 |
export LD_LIBRARY_PATH='/usr/lib/oracle/11.2/client/lib' |
|
| 37 | ||
| 38 |
vi /etc/ld.so.conf.d/oracle.conf |
|
| 39 |
/usr/lib/oracle/11.2/client/lib |
|
| 40 | ||
| 41 |
cpan DBD::Oracle |
|
| 42 | ||
| 43 |
sqlplus dbix_custom/dbix_custom@localhost:1521/XE |
|
| 44 | ||
| 45 |
mkdir -p $ORACLE_HOME/network/admin/ |
|
| 46 |
vi $ORACLE_HOME/network/admin/tnsnames.ora |
|
| 47 | ||
| 48 |
XE = |
|
| 49 |
(DESCRIPTION = |
|
| 50 |
(ADDRESS_LIST = |
|
| 51 |
(ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521)) |
|
| 52 |
) |
|
| 53 |
(CONNECT_DATA = |
|
| 54 |
(SID = orcl) |
|
| 55 |
) |
|
| 56 |
) |
|
| 57 | ||
| 58 |