熱點推薦:
您现在的位置: 電腦知識網 >> 編程 >> Oracle >> 正文

Oracle9i 安裝手記

2013-11-13 16:16:34  來源: Oracle 

  硬件
  曙光服務器G RAM / XERON CPU/ SCSI HD
  
  操作系統
  RH SERVER/ G SWAP/用一塊硬盤建立ORACLE分區其它用另一塊
  
  設置內核
  echo > /proc/sys/kernel/sem
  echo > /proc/sys/kernel/shmmax
  echo > /proc/sys/fs/filemax
  ulimit n
  echo > /proc/sys/net/ipv/ip_local_port_change
  ulimit u
  
  安裝JDK
  聽說O不需要安裝JDK不過還是安裝的好裝在/usr/local/java中
  
  建立組用戶目錄
  groupadd oinstall
  groupadd dba
  groupadd oper
  groupadd apache
  
  useradd g oinstall G dba oracle
  passwd oracle
  useradd g oinstall G apache apache
  passwd apache
  
  mkdir /oracle/oracle/product
  mkdir /oracle/oracle/product/
  chown R oracleoinstall /oracle/oracle
  
  建立文件 bash_profile放在oracle用戶主目錄下
  ORACLE_BASE=/oracle/oracle; export ORACLE_BASE
  ORACLE_HOME=$ORACLE_BASE/product/; export ORACLE_HOME
  ORACLE_TERM=xterm; export ORACLE_TERM
  PATH=$PATH:$ORACLE_HOME/bin:/usr/local/java/bin; export PATH
  ORACLE_SID=ora; export ORACLE_SID
  LD_LIBRARY_PATH=$ORACLE_HOME/lib; export LD_LIBRARY_PATH
  CLASSPATH=$ORACLE_HOME/JRE:$ORACLE_HOME/jlib:$ORACLE_HOME/rdbms/jlib; export CLASSPATH
  
  TMP=/temp; export TMP
  TMPDIR=$TMP; export TMPDIR
  
  准備oraclei源盤
  gunzip lnx__diskcpiogz
  gunzip lnx__diskcpiogz
  gunzip lnx__diskcpiogz
  
  cpio idmv < lnx__diskcpio
  cpio idmv < lnx__diskcpio
  cpio idmv < lnx__diskcpio
  
  安裝
  #export DISPLAY=本機名:
  # /Disk/runInstaller
  
  安裝中的錯誤
  希望不要碰到錯誤但是免不了我碰到的是無法啟動net configer assistantdatabase configer assitant
  還用很多錯誤如果是mk 的錯誤請用ignore
  
  創建數據庫
  dbca 不能啟動只能自己創建數據庫
   建立initsidora
  在$ORACLE_HOME/dbs/下 #cp initora initorora
   用編輯器把initorora中的數據庫名改為實例名
   sqlplus /nolog 啟動sqlplus 下面是sqlplus 中的操作
  connect sys/change_on_install as sysdba;
  startup nomount;
  @createdatabase; 建立數據庫
  @createtablespace 建立表空間
  @createDL 建立數據字典
   createdatabasesql
  CREATE DATABASE or
  LOGFILE $ORACLE_HOME/dbs/or/oradata/redolog SIZE K
  $ORACLE_HOME/dbs/or/oradata/redolog SIZE K
  $ORACLE_HOME/dbs/or/oradata/redolog SIZE K
  MAXLOGFILES
  MAXLOGMEMBERS
  MAXLOGHISTORY
  DATAFILE $ORACLE_HOME/dbs/or/oradata/systemdbf SIZE M REUSE AUTOEXTEND ON NEXT K
  MAXDATAFILES
  MAXINSTANCES
   createtablespace
  CREATE TABLESPACE RBS DATAFILE $ORACLE_HOME/dbs/or/oradata\rbsdbf SIZE M REUSE
  AUTOEXTEND ON NEXT K
  MINIMUM EXTENT K
  DEFAULT STORAGE ( INITIAL K NEXT K MINEXTENTS MAXEXTENTS )
  /
  CREATE TABLESPACE USERS DATAFILE $ORACLE_HOME/dbs/or/oradata\usersdbf SIZE M REUSE
  AUTOEXTEND ON NEXT K
  MINIMUM EXTENT K
  DEFAULT STORAGE ( INITIAL K NEXT K MINEXTENTS MAXEXTENTS PCTINCREASE )
  /
  CREATE TABLESPACE TEMP DATAFILE $ORACLE_HOME/dbs/or/oradata\tempdbf SIZE M REUSE
  AUTOEXTEND ON NEXT K
  MINIMUM EXTENT K
  DEFAULT STORAGE ( INITIAL K NEXT K MINEXTENTS MAXEXTENTS UNLIMITED PCTINCREASE ) TEMPORARY
  /
  CREATE TABLESPACE TOOLS DATAFILE $ORACLE_HOME/dbs/or/oradata\toolsdbf SIZE M REUSE
  AUTOEXTEND ON NEXT K
  MINIMUM EXTENT K
  DEFAULT STORAGE ( INITIAL K NEXT K MINEXTENTS MAXEXTENTS PCTINCREASE )
  /
  CREATE TABLESPACE INDX DATAFILE $ORACLE_HOME/dbs/or/oradata\indxdbf SIZE M REUSE
  AUTOEXTEND ON NEXT K
  MINIMUM EXTENT K
  DEFAULT STORAGE ( INITIAL K NEXT K MINEXTENTS MAXEXTENTS PCTINCREASE )
  /
  CREATE PUBLIC ROLLBACK SEGMENT RBS TABLESPACE RBS STORAGE ( OPTIMAL K )
  /
  CREATE PUBLIC ROLLBACK SEGMENT RBS TABLESPACE RBS STORAGE ( OPTIMAL K )
  /
  CREATE PUBLIC ROLLBACK SEGMENT RBS TABLESPACE RBS STORAGE ( OPTIMAL K )
  /
  CREATE PUBLIC ROLLBACK SEGMENT RBS TABLESPACE RBS STORAGE ( OPTIMAL K )
  /
  CREATE PUBLIC ROLLBACK SEGMENT RBS TABLESPACE RBS STORAGE ( OPTIMAL K )
  /
  CREATE PUBLIC ROLLBACK SEGMENT RBS TABLESPACE RBS STORAGE ( OPTIMAL K )
  /
  CREATE PUBLIC ROLLBACK SEGMENT RBS TABLESPACE RBS STORAGE ( OPTIMAL K )
  /
  CREATE PUBLIC ROLLBACK SEGMENT RBS TABLESPACE RBS STORAGE ( OPTIMAL K )
  /
  CREATE PUBLIC ROLLBACK SEGMENT RBS TABLESPACE RBS STORAGE ( OPTIMAL K )
  /
  CREATE PUBLIC ROLLBACK SEGMENT RBS TABLESPACE RBS STORAGE ( OPTIMAL K )
  /
  CREATE PUBLIC ROLLBACK SEGMENT RBS TABLESPACE RBS STORAGE ( OPTIMAL K )
  /
  CREATE PUBLIC ROLLBACK SEGMENT RBS TABLESPACE RBS STORAGE ( OPTIMAL K )
  /
  CREATE PUBLIC ROLLBACK SEGMENT RBS TABLESPACE RBS STORAGE ( OPTIMAL K )
  /
  CREATE PUBLIC ROLLBACK SEGMENT RBS TABLESPACE RBS STORAGE ( OPTIMAL K )
  /
  CREATE PUBLIC ROLLBACK SEGMENT RBS TABLESPACE RBS STORAGE ( OPTIMAL K )
  /
  CREATE PUBLIC ROLLBACK SEGMENT RBS TABLESPACE RBS STORAGE ( OPTIMAL K )
  /
  CREATE PUBLIC ROLLBACK SEGMENT RBS TABLESPACE RBS STORAGE ( OPTIMAL K )
  /
  CREATE PUBLIC ROLLBACK SEGMENT RBS TABLESPACE RBS STORAGE ( OPTIMAL K )
  /
  CREATE PUBLIC ROLLBACK SEGMENT RBS TABLESPACE RBS STORAGE ( OPTIMAL K )
  /
  CREATE PUBLIC ROLLBACK SEGMENT RBS TABLESPACE RBS STORAGE ( OPTIMAL K )
  /
  CREATE PUBLIC ROLLBACK SEGMENT RBS TABLESPACE RBS STORAGE ( OPTIMAL K )
  /
  CREATE PUBLIC ROLLBACK SEGMENT RBS TABLESPACE RBS STORAGE ( OPTIMAL K )
  /
  CREATE PUBLIC ROLLBACK SEGMENT RBS TABLESPACE RBS STORAGE ( OPTIMAL K )
  /
  CREATE PUBLIC ROLLBACK SEGMENT RBS TABLESPACE RBS STORAGE ( OPTIMAL K )
  /
  CREATE PUBLIC ROLLBACK SEGMENT RBS TABLESPACE RBS STORAGE ( OPTIMAL K )
  /
  ALTER ROLLBACK SEGMENT RBS ONLINE
  /
  ALTER ROLLBACK SEGMENT RBS ONLINE
  /
  ALTER ROLLBACK SEGMENT RBS ONLINE
  /
  ALTER ROLLBACK SEGMENT RBS ONLINE
  /
  ALTER ROLLBACK SEGMENT RBS ONLINE
  /
  ALTER ROLLBACK SEGMENT RBS ONLINE
  /
  ALTER ROLLBACK SEGMENT RBS ONLINE
  /
  ALTER ROLLBACK SEGMENT RBS ONLINE
  /
  ALTER ROLLBACK SEGMENT RBS ONLINE
  /
  ALTER ROLLBACK SEGMENT RBS ONLINE
  /
  ALTER ROLLBACK SEGMENT RBS ONLINE
  /
  ALTER ROLLBACK SEGMENT RBS ONLINE
  /
  ALTER ROLLBACK SEGMENT RBS ONLINE
  /
  ALTER ROLLBACK SEGMENT RBS ONLINE
  /
  ALTER ROLLBACK SEGMENT RBS ONLINE
  /
  ALTER ROLLBACK SEGMENT RBS ONLINE
  /
  ALTER ROLLBACK SEGMENT RBS ONLINE
  /
  ALTER ROLLBACK SEGMENT RBS ONLINE
  /
  ALTER ROLLBACK SEGMENT RBS ONLINE
  /
  ALTER ROLLBACK SEGMENT RBS ONLINE
  /
  ALTER ROLLBACK SEGMENT RBS ONLINE
  /

From:http://tw.wingwit.com/Article/program/Oracle/201311/18074.html
  • 上一篇文章:

  • 下一篇文章:
  • Copyright © 2005-2013 電腦知識網 Computer Knowledge   All rights reserved.