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 ΰγǧ
    # ᥬХñ̤ɽΤǡSwap ̤ǧ
    free -m
    

ͥѥ᡼׷

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

ǧޤ礦

  • ͥѥ᡼γǧ
    # -a ɽŪΥѥ᡼ grep 롣 file-max 
    sysctl -a | grep file-max
    
    • ΥɥȤ򻲾Ȥ

⤷ưǽ򤫤ϰʲΥեԽ롣

  • /etc/sysctl.conf ɵƤ
    # ɬפ󤹤
    fs.file-max = 6815744
    

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

  • sysctl.conf ˱
    sysctl -p
    

¤׷

󥹥ȡ root Ǥ͡ȡ

󥹥ȡ

ĶʤХ󥹥ȡ롣ʲ֤ˤäƤ

ѥåΥ󥹥ȡȹ

  1. root ˤʤ
    su -
    
  2. ɤ zip եषƥ󥹥ȡ뤹
    # ˰ưϰ
    cd Downloads/
    
    # 
    unzip oracle-xe-11.2.0-1.0.x86_64.rpm.zip
    
    # 󥹥ȡ
     rpm -ivh Disk1/oracle-xe-11.2.0-1.0.x86_64.rpm
    
  3. ɬפʽ򤹤
    # ؼ̤ oracle-xe ¹
    # Υޥɤ service oracle-xe configure ȤƤƱ
    /etc/init.d/oracle-xe configure
    
    # ʹߡؼ˽äɬפʾϤ롣
    
    • Ϥϰʲ
      • 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. ǧ
    # ~/.bash_profileɤ߹
    source ~/.bash_profile
    
    # /u01/app/... äƲФƤ
    echo $ORACLE_HOME
    

³ǧ

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

  1. SQL*Plus εư
    sqlplus /nolog
    
    • λǵưǤʤвξĶѿꤢȻפΤǺƳǧ
  2. ³ǧ
    -- SYSTEM Ȥ³ѥɤʹΤ
    conn system
    
    -- ³ޤäƽФƤȤ SQL ʸáǰΤǧ
    select * from dual;
    

UI ι

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

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

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

  1. SQL*Plus εư
    # ѥɤ׵ᤵ줿饤󥹥ȡϤ SYSTEM Τ
    sqlplus system
    
  2. -- ʸʸ
    EXEC DBMS_XDB.SETLISTENERLOCALACCESS(FALSE);
    

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

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

ưȽλ

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

  • ޥɤ鵯ư佪λ򤹤
    # ư
    service oracle-xe start
    
    # λ
    service oracle-xe stop
    
  • ư¹Ԥ
    # ư¹Ԥͭˤ
    chkconfig oracle-xe on
    
    # ư¹Ԥ̵ˤ
    chkconfig oracle-xe off
    

饤Ȥ

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

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

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

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


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