DBIx-Custom / t / run / common-oracle.run /
6ab262d 13 years ago
1 contributor
55 lines | 1.303kb
  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.