电脑技术学习

在Solaris 10 ZFS上安装Oracle 9i

dn001

  export PATH=$PATH:/opt/oracle/product/9.2/bin/

  echo Add this entry in the oratab: ora9:/opt/oracle/product/9.2:Y

  orapwd file=/opt/oracle/product/9.2/dbs/orapwora9 passWord=change_on_install

  sqlplus /nolog @/opt/oracle/admin/ora9/scripts/CreateDB.sql

  sqlplus /nolog @/opt/oracle/admin/ora9/scripts/CreateDBFiles.sql

  sqlplus /nolog @/opt/oracle/admin/ora9/scripts/CreateDBCatalog.sql

  sqlplus /nolog @/opt/oracle/admin/ora9/scripts/postDBCreation.sql

  oracle> cat $ORACLE_BASE/admin/ora9/scripts/CreateDB.sql

  connect SYS/change_on_install as SYSDBA

  set echo on

  spool /opt/oracle/product/9.2/assistants/dbca/logs/CreateDB.log

  startup nomount pfile="/opt/oracle/admin/ora9/scripts/init.ora";

  CREATE DATABASE ora9

  MAXINSTANCES 1

  MAXLOGHISTORY 1

  MAXLOGFILES 5

  MAXLOGMEMBERS 3

  MAXDATAFILES 100

  DATAFILE '/dev/zvol/rdsk/ora_pool/system_800m' SIZE 800M REUSE

  EXTENT MANAGEMENT LOCAL

  DEFAULT TEMPORARY TABLESPACE TEMP TEMPFILE '/dev/zvol/rdsk/ora_pool/temp01_4000m' SIZE 4000M REUSE

  UNDO TABLESPACE "UNDOTBS1" DATAFILE '/dev/zvol/rdsk/ora_pool/undotbs1_01_4000m' SIZE 4000M REUSE

  CHARACTER SET UTF8

  NATIONAL CHARACTER SET AL16UTF16

  LOGFILE GROUP 1 ('/dev/zvol/rdsk/ora_pool/redo1_01_400m') SIZE 400M,

  GROUP 2 ('/dev/zvol/rdsk/ora_pool/redo2_01_400m') SIZE 400M,

标签: