手工创建数据库（包括oracle rac）(二)
.log append
@/oracle/app/oracle/product/11.2.0/db_1/rdbms/admin/catalog.sql;
@/oracle/app/oracle/product/11.2.0/db_1/rdbms/admin/catblock.sql;
@/oracle/app/oracle/product/11.2.0/db_1/rdbms/admin/catproc.sql;
@/oracle/app/oracle/product/11.2.0/db_1/rdbms/admin/catoctk.sql;
@/oracle/app/oracle/product/11.2.0/db_1/rdbms/admin/owminst.plb;
spool off
connect "SYSTEM"/"oracle"
spool /tmp/system.log append
@/oracle/app/oracle/product/11.2.0/db_1/sqlplus/admin/pupbld.sql;
@/oracle/app/oracle/product/11.2.0/db_1/sqlplus/admin/help/hlpbld.sql helpus.sql;
spool off
6，创建spfile，存放于asm磁盘
[sql]
create spfile from pfile='/oracle/app/oracle/product/11.2.0/db_1/dbs/inithrdb1.ora';
cp /oracle/app/oracle/product/11.2.0/db_1/dbs/inithrdb1.ora /oracle/app/oracle/product/11.2.0/db_1/dbs/inithrdb1.ora.bak
echo "SPFILE='+DATA/hrdb/spfilehrdb.ora'" > /oracle/app/oracle/product/11.2.0/db_1/dbs/inithrdb1.ora
www.2cto.com
7，psu升级，重新编译
[sql]
spool /tmp/postDBCreation.log append
@/oracle/app/oracle/product/11.2.0/db_1/rdbms/admin/catbundle.sql psu apply;
select 'utl_recomp_begin: ' || to_char(sysdate, 'HH:MI:SS') from dual;
execute utl_recomp.recomp_serial();
select 'utl_recomp_end: ' || to_char(sysdate, 'HH:MI:SS') from dual;
8，重新启动，从spfile文件启动，修改为归档模式
[sql]
shutdown immediate;
connect "SYS"/"&&sysPassword" as SYSDBA
startup mount pfile="/oracle/app/oracle/admin/hrdb/scripts/init.ora";
startup mount;
alter database archivelog;
alter database open;
9、添加log file和undo
[sql]
--添加log thread 3
ALTER DATABASE ADD LOGFILE THREAD 3
GROUP 5 SIZE 512M,
GROUP 6 SIZE 512M,
GROUP 9 SIZE 512M;
ALTER DATABASE ENABLE PUBLIC THREAD 3;
--添加log thread 3
ALTER DATABASE ADD LOGFILE THREAD 2
GROUP 3 SIZE 512M, www.2cto.com
GROUP 4 SIZE 512M,
GROUP 8 SIZE 512M;
ALTER DATABASE ENABLE PUBLIC THREAD 2;
undo tablespace
CREATE SMALLFILE UNDO TABLESPACE "UNDOTBS2" DATAFILE SIZE 1024M AUTOEXTEND ON NEXT 5120K MAXSIZE UNLIMITED;
CREATE SMALLFILE UNDO TABLESPACE "UNDOTBS3" DATAFILE SIZE 1024M AUTOEXTEND ON NEXT 5120K MAXSIZE UNLIMITED;
10，CreateClustDBViews
[sql]
spool /oracle/app/oracle/admin/epmdb/scripts/CreateClustDBViews.log append
@/oracle/app/oracle/product/11.2.0/db_1/rdbms/admin/catclust.sql;
spool off
11，修改rac相关的参数
[sql]
alter system set cluster_database=true scope=spfile;
alter system set remote_listener="dtydb-scan2:1521" scope=spfile;
alter system set instance_number=2 scope=spfile sid='hrdb2';
alter system set instance_number=3 scope=spfile sid='hrdb3';
alter system set thread=2 scope=spfile sid='hrdb2';
alter system set thread=3 scope=spfile sid='hrdb3';
alter system set undo_tablespace=UNDOTBS2 scope=spfile sid='hrdb2';
alter system set undo_tablespace=UNDOTBS3 scope=spfile sid='hrdb3';
create pfile = '/tmp/init.ora' from spfile;
create spfile='+DATA/hrdb/spfilehrdb.ora' FROM pfile ='/tmp/init.ora';
www.2cto.com
也可通过修改pfile文件完成
epmdb3.instance_n