• set semsys:seminfo_semmni=100
    set semsys:seminfo_semmns=1024
    set semsys:seminfo_semmsl=256
    set shmsys:shminfo_shmmax=4294967295
    set shmsys:shminfo_shmmin=1
    set shmsys:shminfo_shmmni=100
    set shmsys:shminfo_shmseg=10

  • groupadd dba
    useradd -g dba -d /opt/oracle -s /bin/csh -m oracle
    passwd oracle
  • setenv ORACLE_BASE /opt/oracle
    setenv ORACLE_HOME $ORACLE_BASE/product/9.2.0
    setenv ORA_NLS33 $ORACLE_HOME/ocommon/nls/admin/data
    setenv CLASSPATH $ORACLE_HOME/jre/1.1.8:$ORACLE_HOME/jlib:$ORACLE_HOME/jlib/product/jlib
    
    set path = ($ORACLE_HOME/bin $path)
    setenv LD_LIBRARY_PATH $ORACLE_HOME/lib:$LD_LIBRARY_PATH

  • cd /tmp
    /cdrom/disk1/runInstaller

  • su
    /tmp/orainstRoot.sh

  • Server
    • Enterprise Edition
    • Statndard Edition
    • Custom
  • Client
    • Administrator
    • Runtime
    • Custome

Database Configuration

  • Server
    • General Propose
    • Transaction Processing
    • Data Warehouse
    • Customized
    • Software Only
  • Client

  • su
    /opt/oracle/product/9.2.0/root.sh
  • /usr/local/bin

  • unzip hogehoge.zip
    cpio -i -d < hogehoge.cpio

  • $ORACLE_BASE/bin/netca

  • lsnrctl start
  • lsnrctl start <lisner名>

  • mkdir /export/home/oracle/oradata
    mkdir /export/home/oracle/admin
    cd $ORACLE_BASE
    ln -s /export/home/oracle/oradata
    ln -s /export/home/oracle/admin
  • $ORACLE_HOME/bin/dbca


TEST:/opt/app/oracle/product/9.2.0:N

    • spfile(SID).ora
      mv $ORACLE_HOME/dbs/spfile(SID).ora $ORACLE_HOME/dbs/_spfile(SID).ora
      
    • cp $ORACLE_BASE/admin/(SID)/pfile/init.ora.xxxx $ORACLE_BASE/admin/(SID)/pfile/init(SID).ora
      ln -s $ORACLE_BASE/admin/(SID)/pfile/init(SID).ora $ORACLE_HOME/dbs/init(SID).ora
      $ORACLE_BASE/admin/(SID)/pfile/init(SID).ora

    •      case $VERSION in
                       "6")  sqldba command=shutdown ;;
                       "internal")  $SQLDBA <<EOF
      connect internal
      shutdown
      EOF
                         ;;
                       *)  $SQLDBA <<EOF
      connect / as sysdba
      shutdown
      EOF
                         ;;
                   esac
    •      case $VERSION in
                       "6")  sqldba command=shutdown ;;
                       "internal")  $SQLDBA <<EOF
      connect internal
      
      EOF
                         ;;
                       *)  $SQLDBA <<EOF
      connect / as sysdba
      
      
      EOF
                         ;;
                   esac

  • #!/bin/sh
    
    ORA_HOME=/opt/app/oracle/product/9.2.0
    ORA_OWNER=oracle
    
    if [ ! -f $ORA_HOME/bin/dbstart -o ! -d $ORA_HOME ]; then
            echo "Oracle startup: cannot start"
    fi
    
    case "$1" in
    'start')
           su - $ORA_OWNER -c "$ORA_HOME/bin/dbstart "
           su - $ORA_OWNER -c "$ORA_HOME/bin/lsnrctl start"
           ;;
    'stop')
           su - $ORA_OWNER -c "$ORA_HOME/bin/lsnrctl stop"
           su - $ORA_OWNER -c "$ORA_HOME/bin/dbshut "
    ;;
    esac
  • cd /etc/rc2.d
    ln -s ../init.d/dbora S98dbora
    cd /etc/rc0.d
    ln -s ../init.d/dbora K11dbora
    cd /etc/rc1.d
    ln -s ../init.d/dbora K11dbora
  • su oracle
    cd ~
    mv .login dot.login

Enterprise Manager

$ORACLE_HOME/bin/oemapp
$ORACLE_HOME/bin/oemapp dbastudio

  • sqlplus "sys/sys@test as sysdba"
  • @utlxplan.sql
  • GRANT SELECT ON SYS.PLAN_TABLE TO PUBLIC; 
    GRANT INSERT ON SYS.PLAN_TABLE TO PUBLIC; 
    GRANT UPDATE ON SYS.PLAN_TABLE TO PUBLIC; 
    GRANT DELETE ON SYS.PLAN_TABLE TO PUBLIC; 
    CREATE PUBLIC SYNONYM PLAN_TABLE FOR SYS.PLAN_TABLE;
  • @plustrce.sql
  • grand plustrace to user





トップ   編集 凍結 差分 バックアップ 添付 複製 名前変更 リロード   新規 一覧 単語検索 最終更新   ヘルプ   最終更新のRSS
Last-modified: Tue, 12 Oct 2021 01:01:08 JST (421d)