DB/Oracle/XE Ķ

Top/DB/Oracle/XE Ķ

ܼ

̵ǻȤ Oracle Database Express EditionOracle XEˤȤ RedHat Enterprise Linux 6RHEL 6ˤ˥󥹥ȡ뤹뤪áС 2011 ǯ 11 1 ߤǺǿΡ11g Release 2

ʹߤ CentOS Fedora RedHatϤʤΤϤ


Oracle Database Express Edition ϡRDBMS ΥǥեȥɤǤ Oracle Database ̵ǡ̵ʤϤΤΡϤʴĶǤнʬѤѤ롣

ϰʲΤȤꡣ

  • CPU 1 Ȥʤ
  • 󥹥󥹤 1 ĤΤ
  • 桼ǡ 11 GB ޤ
  • 1 GB ޤ
  • HTTPS ϥݡȤʤ

ɤȻȥɥ

Oracle Web Ȥ饤󥹥ȡѤΥѥåʺ x64 ĶѤ *.rpm.zipˤɤƤ롣

󥹥ȡˤäƻȤ٤ɥȤϤѸ줷ʤߤʤ

Ķγǧ

ǽ˥󥹥ȡ׷ǧϸɥȡ

ƥ׷

RHEL6 бƤʤġ ȡġġޤɤˤʤ֤󡣤ȻפäƤäɤˤʤäΤס

ä񤯤ȡOS OEL 4 5RHEL 4 5SUSE 10 11ʤ͡

RAM Ϻ 256MB512MB ʾ侩HDD ζ 1.5GB

ɬפʥѥåϰʲΤȤꡣʤ yum Ǥ餫Ƥ

  • ѥå׷
    ѥåС
    glibc2.3.4-2.41 ʾ
    make3.80 ʾ
    binutils2.16.91.0.5 ʾ
    gcc4.1.2 ʾ
    libaio0.3.104 ʾ

SWAP ΰ׷

2GB RAM ܤΤɤ餫ʤۤɬס

ǧޤ礦

  • SWAP ΰγǧ

ͥѥ᡼׷

ͥѥ᡼׳ǧȤϤ׷꾯ʤä饤󥹥ȡ餬˽Ƥ褦ʤΤǤޤ굤ˤʤƤ⤤⤷ʤ

ǧޤ礦

  • ͥѥ᡼γǧ
    
    
    • ΥɥȤ򻲾Ȥ

⤷ưǽ򤫤ϰʲΥեԽ롣

  • /etc/sysctl.conf ɵƤ

ưǽ顢Ƶư뤫ʲ¹ԤȿǤ롣

  • sysctl.conf ˱
    sysctl -p
    

¤׷

󥹥ȡ root Ǥ͡ȡ

󥹥ȡ

ĶʤХ󥹥ȡ롣ʲ֤ˤäƤ

ѥåΥ󥹥ȡȹ

  1. root ˤʤ
    su -
    
  2. ɤ zip եषƥ󥹥ȡ뤹
  3. ɬפʽ򤹤
    
    
    • Ϥϰʲ
      • Oracle Application ExpressWeb ١δ UIˤȤ HTTP ݡȡ8080
      • ꥹʤδƻݡȡ1521
      • SYS SYSTEM Υѥ
      • ƥ൯ưμư¹Ԥ
  4. Ԥ
    • Installation completed successfully. äƽФ鴰λǤ˥ꥹʤΩ夬äƤ

Ķѿ

ǡ١μ¹ԤɬפʴĶѿꡣ

ꤷƤ⤤ɡǫ˥ץȤѰդƤΤǡɬפʥ桼 ~/.bash_profile ƤӽФ褦ˤ롣

  1. ~/.bash_profile ɵ
    . /u01/app/oracle/product/11.2.0/xe/bin/oracle_env.sh
    
  2. ǧ

³ǧ

ޤǤǤ³ǧޤϥĶ SQL*Plus Ǥ뤫ǧ롣

  1. SQL*Plus εư
    sqlplus /nolog
    
    • λǵưǤʤвξĶѿꤢȻפΤǺƳǧ
  2. ³ǧ

UI ι

λǤǤ˴ĶϤǤäƤΤǡʹߤ SQL*Plus Ω夲вǤǤ롣

ǡXE ˤɸ Web ١δ UI ĤƤɡɸǤϥĶ餷Ǥʤ⡼ȤǤ⥢Ǥ褦ꤹ롣

XE Ǥ HTTPS ݡȤʤΤǡ UI ȤΤȤϰŹ沽ʤδ UI Ȥݤ DBA ¤ǥ󤹤ɬפɡλΥѥɤŹ沽ʤȤˤʤΤǡ8080 ֥ݡȤθϰϤϿŤ˹ͤʤȤʤե魯줺ˡ

  1. SQL*Plus εư

ꤷ顢ͥåȥϤϰΥۥȤǤаʲ URL ǥǽ

  • UI URL
    http://<ip-addr>:8080/apex/f?p=4950
    
    • ̤ݤ SYSTEM Ȥǥ󤹤Ф褤
  • Oracle Application Express URL
    http://<ip-addr>:8080/apex/
    
    • Oracle DB ѤץꥱȯǻȤ Web ץꥱ󡣾ܺ٤ϤäɥȸꤹФ狼

ưȽλ

ưǵưȽλ򤹤硢뤤ϼư¹Ԥꤷʤʤɤϰʲ̤ꡣܤǤ͡

  • ޥɤ鵯ư佪λ򤹤
  • ư¹Ԥ

饤Ȥ

Ф̵˹ۤǤ顢饤ȡ̤ʪޥˤ SQL*Plus ǤĤʤ褦ˤƤȲȳڡܺ٤̥ڡˡ

󡢤虜虜饤ȥޥ SQL*Plus Τʤ顢SSH ǥФˤĤʤǤ饵о SQL*Plus 餻ΤǤʤ

ĶǤ鱿ѡ㤨ХǥեȤɽΰ USERS 뤱ɤɲäꡢ桼ɲä긢¤ͿꡢȤ٤ȤϤ롣̥ڡ˥ޥɤˤޤȤƤΤŬȤΤȡ

Υڡ XE ǤϤʤǤ 11g ١˽񤤤ΤǼ㴳㤦Ȥ⤢뤫⤷ʤǤܤϰΤϤ


Last-modified: 2011-11-08 () 11:47:19