oracle手工建库步骤

1、创建audit目录
 mkdir -p /u01/app/oracle/admin/pbrac/adump
2、配置参数文件  --注参数文件里面不能有中文字符
*.audit_file_dest='/u01/app/oracle/admin/pbrac/adump'
*.audit_trail='db'
*.control_files='+DATA/pbrac/controlfile/control01.ctl','+DATA/pbrac/controlfile/control02.ctl'                                            
*.db_block_size=8192
*.db_create_file_dest='+DATA'
*.db_domain=''
*.db_name='pbrac'
*.db_recovery_file_dest='+DATA'
*.db_recovery_file_dest_size=10737418240
*.diagnostic_dest='/u01/app/oracle'
*.memory_target=1658847232
*.open_cursors=300
*.processes=150
*.remote_listener='ractest-scan:1521'
*.remote_login_passwordfile='exclusive'
3、创建ASM目录和创建spfile
su - grid
asmcmd
cd +data
mkdir pbrac
create spfile='+DATA/pbrac/spfilepbrac.ora' from pfile='/home/oracle/pbrac.ora';

创建init文件
节点1
vi initpbrac1.ora
SPFILE='+DATA/pbrac/spfilepbrac.ora'
节点2
vi initpbrac2.ora
SPFILE='+DATA/pbrac/spfilepbrac.ora'

4、创建密码文件
节点一
orapwd file=?/dbs/orapwpbrac1 password=oracle  force=y;
节点二、
orapwd file=?/dbs/orapwpbrac2 password=oracle  force=y;

5、创建DB
CREATE DATABASE pbrac
   USER SYS IDENTIFIED BY oracle
   USER SYSTEM IDENTIFIED BY oracle
   LOGFILE GROUP 1  SIZE 100M,
           GROUP 2  SIZE 100M,
           GROUP 3  SIZE 100M
   MAXLOGFILES 16
   MAXLOGMEMBERS 5
   MAXLOGHISTORY 680
   MAXDATAFILES 1024
   CHARACTER SET ZHS16GBK
   EXTENT MANAGEMENT LOCAL
   DATAFILE  SIZE 325M
   SYSAUX DATAFILE  SIZE 325M
   DEFAULT TABLESPACE users
      DATAFILE
      SIZE 500M  AUTOEXTEND ON MAXSIZE UNLIMITED
   DEFAULT TEMPORARY TABLESPACE temp01
      TEMPFILE
      SIZE 200M
   UNDO TABLESPACE undotbs1
      DATAFILE
      SIZE 200M  AUTOEXTEND ON MAXSIZE UNLIMITED;
6、创建节点二的undo 和添加redo	  
CREATE UNDO TABLESPACE UNDOTBS2 DATAFILE SIZE 200M;
ALTER DATABASE ADD LOGFILE THREAD 2 GROUP 4 SIZE 100M; 
ALTER DATABASE ADD LOGFILE THREAD 2 GROUP 5 SIZE 100M;
ALTER DATABASE ADD LOGFILE THREAD 2 GROUP 6 SIZE 100M; 	  
7、 添加rac 参数(以下转单实例db到RAC DB)	  
ALTER SYSTEM SET cluster_database=true scope=spfile sid='*';
ALTER SYSTEM SET instance_number=1 scope=spfile sid='pbrac1';
ALTER SYSTEM SET instance_number=2 scope=spfile sid='pbrac2';
ALTER SYSTEM SET thread=1 scope=spfile sid='pbrac1';
ALTER SYSTEM SET thread=2 scope=spfile sid='pbrac2';
ALTER SYSTEM SET undo_tablespace='UNDOTBS1' scope=spfile sid='pbrac1';
ALTER SYSTEM SET undo_tablespace='UNDOTBS2' scope=spfile sid='pbrac2';
alter database enable public thread 2;
8、 启动所有节点实例
先启动节点一，然后在节点一执行  ALTER DATABASE ENABLE PUBLIC THREAD 2;
然后启动节点二

9、rac 数据库添加到srvctl中
将数据库配置添加到 Oracle Clusterware。
需要用oracle用户操作
srvctl add database -d pbrac -c rac -o /u01/app/oracle/product/11.2.0/db_1 -p '+DATA/pbrac/spfilepbrac.ora' -r primary -n pbrac
显示database配置
srvctl config database -d pbrac -a
将数据库实例添加到Oracle Clusterware。
srvctl add instance -d pbrac -i pbrac1 -n ractest01
srvctl add instance -d pbrac -i pbrac2 -n ractest02
查看数据库状态
srvctl status database -d pbrac 
重启数据库
srvctl stop db -d pbrac(此处直接stop会报错，还是到各节点上shutdown immediate)
srvctl start db -d pbrac	  
再次查看数据库状态
srvctl status database -d pbrac 	 

10、编译数据字典脚本	 
SPOOL /tmp/dictionary_tmp.sql
@?/rdbms/admin/catalog.sql
@?/rdbms/admin/catproc.sql
@?/rdbms/admin/catclust.sql
@?/rdbms/admin/dbmspool.sql
@?/rdbms/admin/catblock.sql
@?/rdbms/admin/caths.sql
@?/rdbms/admin/owminst.plb
@?/sqlplus/admin/plustrce.sql
@?/rdbms/admin/utlrp.sql
@?/rdbms/admin/utlsampl.sql
conn system/oracle
@?/sqlplus/admin/pupbld.sql
@?/sqlplus/admin/help/hlpbld.sql helpus.sql
SPOOL off