我原来已经在一台HP N4000上安装了oracle 9i r2的企业版本数据库软件,但是建立的都是单实例的数据库,但是现在准备和另一台N4000做RAC,我看了oracle的rac安装文档,发现rac的安装过程(只安装软件,不建立数据库)除了有一个NODE的选择,就没有什么不一样的,这样我是否可以不用在重新安装,直接就用DBCA或手工创建集群数据库?但是在看手工创建集群数据库的时候发现srvm目录下面少了admin目录下需要的文件,希望碰到过这类问题的朋友帮解答一下,谢谢。
还有一个问题,我用的裸设备创建数据库,除了配置.rhosts可以访问另一台N400后是否就可以开始创建集群数据库,不需要安装什么cluster ware了吧?对使用系统相关cluster ware部分了解的不是十分明确,希望明白的朋友也给回个信,谢谢。
还有一个问题,我用的裸设备创建数据库,除了配置.rhosts可以访问另一台N400后是否就可以开始创建集群数据库,不需要安装什么cluster ware了吧?对使用系统相关cluster ware部分了解的不是十分明确,希望明白的朋友也给回个信,谢谢。
解决方案 »
- oracle 11gR2安装
- Oracle数据库关于外键的on delete cascade问题
- 存储过程-形参为out模式的传值与传引用的区别
- 如何不在本机安装ORALCE,就可以在远程访问Oracle
- 请教!ORCALE能不能实现两台数据库之间的时时交换?
- 二个关于数据库表关联的问题?
- 我在windows 2003装了oracle 版本:CORE 9.0.1.1.1 Production,如何升级到9.2.0.4.0
- OEM搜索节点失败,OracleOraHome92Agent服务已启动,可以搜索到其它机器,但本机就是不行
- 关于sql的问题
- oracle的存储过程问题,菜鸟不知如何入手。求各位好心人解答下
- 请问用export做备份用停数据库么
- 很急~~~~~~~!
另一种直接用操作系统的底层 pv作为 RAW设备来实现RAC。
-----------------------------------------------------------------1. Make a full database backup before you change anything.
2. Copy the existing $ORACLE_HOME/dbs/init<SID1>.ora to
$ORACLE_HOME/dbs/init<db_name>.ora. Add the following parameters to
$ORACLE_HOME/dbs/init<db_name>.ora: *.cluster_database = TRUE
*.cluster_database_instances = 2
*.undo_management=AUTO (Add if you don't have it )
<SID1>.undo_tablespace=undotbs (undo tablespace which already exists)
<SID1>.instance_name=RAC1
<SID1>.instance_number=1
<SID1>.thread=1
<SID1>.local_listener=LISTENER_RAC1 where LISTENER_RAC1 is an entry in the tnsnames.ora file like: LISTENER_RAC1 =
(ADDRESS = (PROTOCOL = TCP)(HOST = <node1>)(PORT = 1521)) Keep only one line in $ORACLE_HOME/dbs/init<SID1>.ora: ifile=$ORACLE_HOME/dbs/init<db_name>.ora You could also create a common spfile from this pfile and add a line
like spfile=$ORACLE_HOME/dbs/spfile<db_name>.ora in each init<SIDn>.ora
file. For more details about how to do this, please refer to Note 136327.1.
3. Open your database and run $ORACLE_HOME/rdbms/admin/catclust.sql to create
cluster database specific views within the existing instance.
4. Recreate control file if you defined maxinstances to be 1 when you created
the single instance database. To check your current setting of maxinstances, run the following command
while the database is mounted or open and connected as a user with DBA
privileges: % sqlplus /nolog
SQL> connect / as sysdba
SQL> startup mount
SQL> alter database backup controlfile to trace; The trace file is located in udump directory. Check the maxinstance value
in the CREATE CONTROLFILE statement. Please refer to Note 118931.1
Recreating the Controlfile in RAC and OPS
5. Add instance specific parameters in the init<db_name>.ora for the second
instance on the second node and set appropriate values for it: *** Names may need to be modified <SID2>.instance_name=RAC2
<SID2>.instance_number=2
<SID2>.local_listener=LISTENER_RAC2
<SID2>.thread=2
<SID2>.undo_tablespace=UNDOTBS2
<SID2>.cluster_database = TRUE
<SID2>.cluster_database_instances = 2 where LISTENER_RAC2 is an entry in the tnsnames.ora file like: LISTENER_RAC2 =
(ADDRESS = (PROTOCOL = TCP)(HOST = <node2>)(PORT = 1521))
6. From the first instance, mount the database and run the following command: *** Path names, file names, and sizes will need to be modified alter database
add logfile thread 2
group 3 ('/dev/RAC/redo2_01_100.dbf') size 100M,
group 4 ('/dev/RAC/redo2_02_100.dbf') size 100M;
alter database enable public thread 2;
7. Create a second Undo Tablespace from the existing instance: *** Path names, file names, and sizes will need to be modified CREATE UNDO TABLESPACE UNDOTBS2 DATAFILE
'/dev/RAC/undotbs_02_210.dbf' SIZE 200M ;
8. Set ORACLE_SID and ORACLE_HOME environment variables on the second node.
9. Start the second Instance.