1、 shared_pool_size=524288000 sort_area_size=524288 undo_management=AUTO #cluster_database=true /* Uncomment the parameter, when database created */ cluster_database_instances=2 remote_listener=LISTENERS_RAC Instance Specific Parameters for Instance RAC1 instance_name=RAC1 instance_number=1 local_list
2、ener=LISTENER_RAC1 thread=1 undo_tablespace=UNDOTBS * The local_listener parameter requires that you first add the listener address to the TNSNAMES.ORA - remember to do so on both Node 1 and Node 2. * You can also use an spfile as described in Note 136327.1.2. Run the following sqlplus command to co
3、nnect to the database: sqlplus / as sysdba3. Startup up the database in NOMOUNT mode: SQL startup nomount4. Create the Database (All raw devices must be pre-created) : CREATE DATABASE CONTROLFILE REUSE MAXDATAFILES 254 MAXINSTANCES 32 MAXLOGHISTORY 100 MAXLOGMEMBERS 5 MAXLOGFILES 64 DATAFILE /dev/RA
4、C/system_01_400.dbf SIZE 900M REUSE EXTENT MANAGEMENT LOCAL segment space management auto UNDO TABLESPACE UNDOTBS DATAFILE /dev/RAC/undotbs_01_210.dbf SIZE 200M REUSE EXTENT MANAGEMENT LOCAL segment space management auto DEFAULT TABLESPACE USER_DEFAULT DATAFILE/u01/oracle/rbdb1/user_default_1.dbf si
5、ze 2000M REUSE SYSAUX DATAFILE /u01/oracle/rbdb1/sysaux_1.dbf size 500M REUSE EXTENT MANAGEMENT LOCAL segment space management auto CHARACTER SET US7ASCII LOGFILE GROUP 1 (/dev/RAC/redo1_01_100.dbf) SIZE 100M REUSE, GROUP 2 (/dev/RAC/redo1_02_100.dbf) SIZE 100M REUSE;5. Create a Temporary Tablespace
6、: CREATE TEMPORARY TABLESPACE TEMP TEMPFILE /dev/RAC/temp_01_50.dbf SIZE 40M REUSE 6. Create a 2nd Undo Tablespace: CREATE UNDO TABLESPACE UNDOTBS2/dev/RAC/undotbs_02_210.dbf NEXT 5120K MAXSIZE UNLIMITED;7. Run the necessary scripts to build views, synonyms, etc.: The primary scripts that you must r
7、un are: i CATALOG.SQL-creates the views of data dictionary tables and the dynamic performance views ii CATPROC.SQL-establishes the usage of PL/SQL functionality and creates many of the PL/SQL Oracle supplied packages iii CATCLUST.SQL-creates RAC specific views8. Edit initstartup nomountORACLE instan
8、ce started.Total System Global Area 356515840 bytesFixed Size 2096248 bytesVariable Size 293602184 bytesDatabase Buffers 54525952 bytesRedo Buffers 6291456 bytes26 SYShcndb142:20 SYShcndb1d. 创建库11:00:18 SYShcndb1CREATE DATABASE hcndb18 2 USER SYS IDENTIFIED BY oracle18 3 USER SYSTEM IDENTIFIED BY or
9、acle18 4 LOGFILE GROUP 1 (+datadg) SIZE 100M,18 5 GROUP 2 (18 6 GROUP 3 () SIZE 100M18 7 MAXLOGFILES 1518 8 MAXLOGMEMBERS 418 9 MAXLOGHISTORY 118 10 MAXDATAFILES 100018 11 CHARACTER SET ZHS16GBK18 12 NATIONAL CHARACTER SET AL16UTF1618 13 EXTENT MANAGEMENT LOCAL18 14 DATAFILE SIZE 325M REUSE18 15 SYS
10、AUX DATAFILE 18 16 DEFAULT TABLESPACE users18 17 DATAFILE 18 18 SIZE 500M REUSE AUTOEXTEND ON MAXSIZE UNLIMITED19 19 DEFAULT TEMPORARY TABLESPACE tempts119 20 TEMPFILE 19 21 SIZE 20M REUSE19 22 UNDO TABLESPACE undotbs119 23 DATAFILE 19 24 SIZE 200M REUSE AUTOEXTEND OFF;Database created.32 SYShcndb1e
11、. 执行脚本The primary scripts that you must run are:iiiiii运行下面的脚本?/rdbms/admin/catalog.sql/rdbms/admin/catproc.sql/sqlplus/admin/pupbld.sql/rdbms/admin/catclust.sqlf. 创建undotbs2CREATE UNDO TABLESPACE UNDOTBS2 DATAFILE SIZE 200M autoextend on;g. 关闭数据库,参数文件增加节点2的信息由于使用的是ASM,这里的control_files要修改为具体的控制文件+dat
12、adg/hcndb/controlfile/Current.282.836478023cluster_database=true #下面的内容要加上具体实例名hcndb1.instance_name=hcndb1hcndb1.undo_tablespace=UNDOTBS1hcndb2.instance_name=hcndb2#hcndb2.thread=2 -等h步骤完毕后,才能打开这个参数hcndb2.undo_tablespace=UNDOTBS2oraclehcn1 dbs$h. 添加2号节点的redo log40:03 SYShcndb1alter database add logfile thre