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