在Solaris 10 ZFS上安装Oracle 9i( 二 ) _云知道

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,
GROUP 3 ('/dev/zvol/rdsk/ora_pool/redo3_01_400m') SIZE 400M;
spool off
exit;
oracle> cat $ORACLE_BASE/admin/ora9/scripts/CreateDBFiles.sql
connect SYS/change_on_install as SYSDBA
set echo on
spool /opt/oracle/product/9.2/assistants/dbca/logs/CreateDBFiles.log
CREATE TABLESPACE "INDX" LOGGING DATAFILE '/dev/zvol/rdsk/ora_pool/index01_4000m' SIZE 4000M REUSE EXTENT MANAGEMENT LOCAL SEGMENT SPACE MANAGEMENT　AUTO ;
CREATE TABLESPACE "TOOLS" LOGGING DATAFILE '/dev/zvol/rdsk/ora_pool/tools_1000m' SIZE 1000M REUSE EXTENT MANAGEMENT LOCAL SEGMENT SPACE MANAGEMENT　AUTO ;
CREATE TABLESPACE "USERS" LOGGING DATAFILE '/dev/zvol/rdsk/ora_pool/users01_4000m' SIZE 4000M REUSE EXTENT MANAGEMENT LOCAL SEGMENT SPACE MANAGEMENT　AUTO ;
spool off
exit;
oracle> cat $ORACLE_BASE/admin/ora9/scripts/postDBCreation.sql
connect SYS/change_on_install as SYSDBA
set echo on
spool /opt/oracle/product/9.2/assistants/dbca/logs/postDBCreation.log
@/opt/oracle/product/9.2/rdbms/admin/utlrp.sql;
shutdown ;
connect SYS/change_on_install as SYSDBA
set echo on
spool /opt/oracle/product/9.2/assistants/dbca/logs/postDBCreation.log
create spfile='/dev/zvol/rdsk/ora_pool/spfile_30m' FROM pfile='/opt/oracle/admin/ora9/scripts/init.ora';
startup ;
step6. 启动数据库.
oracle> cat /opt/oracle/product/9.2/dbs/initora9.ora
spfile='/dev/zvol/rdsk/ora_pool/spfile_30m'
oracle> echo "ora9:/opt/oracle/product/9.2:Y" >> /var/opt/oracle/oratab
oracle> sqlplus "/as sysdba"
sql> startup pfile='/opt/oracle/admin/ora9/scripts/init.ora
sql> create spfile='/dev/zvol/rdsk/ora_pool/spfile_30m' FROM pfile='/opt/oracle/admin/ora9/scripts/init.ora';
sql> shutdown immediate;
sql> startup pfile='/opt/oracle/product/9.2/dbs/initora9.ora'
sql> show parameters spfile;
NAMETYPEVALUE
------------- ---------
spfilestring/dev/zvol/rdsk/ora_pool/spfile_30m
SQL> select name from v$datafile;
NAME
--------------------------------------------------
/dev/zvol/rdsk/ora_pool/system_800m
/dev/zvol/rdsk/ora_pool/undotbs1_01_4000m
/dev/zvol/rdsk/ora_pool/index01_4000m
/dev/zvol/rdsk/ora_pool/tools_1000m
/dev/zvol/rdsk/ora_pool/users01_4000m
出处：http://blog.sina.com.cn/s/blog_45d51ebc010008uj.html

在Solaris 10 ZFS上安装Oracle 9i( 二 )

推荐阅读

绵阳三台县灵活就业人员社保补贴申领指南

如何驾驶手动挡汽车教学如何驾驶手动挡汽车

我的侠客材料用处介绍我的侠客材料有什么用

怎么选眼影颜色

抖音怎么才能设置屏蔽词抖音屏蔽词设置方式分享

华为畅享9将刘海隐藏的具体操作步骤

安卓手机忘记锁屏密码怎么办

什锦是什么水果什锦罐头里的白色是什么东东

失之东隅收之桑榆的意思失之东隅收之桑榆的解释及出处

狂怒2怎么调字幕狂怒2如何调字幕

吉克毕摩经书是什么

广西乐滩水库在哪里,来宾乐滩水库垂钓官网

学会留住微笑初中优秀作文

狗狗呕吐物图解？狗狗呕吐该如何解决

宝宝巴士儿童安全—公寓着火了，应急逃生知识很重要

杨桃怎么加工好吃杨桃该怎么加工