DBIx-Custom / t / _run / common-oracle.run /
Newer Older
55 lines | 1.303kb
test cleanup in progress
Yuki Kimoto authored on 2011-08-15
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