†

†

• 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

†

1. • spfile(SID).ora

     mv $ORACLE_HOME/dbs/spfile(SID).ora $ORACLE_HOME/dbs/_spfile(SID).ora
     

2. • 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