Oracle RAC 更改instance name完整步骤

下面是更改的部分步骤，但是启动问题还是存在，求达人完整。单实例的数据库修改SID比较简单，只需要修改pfile相关参数，就可以挂载数据库。 RAC环境其实一样，只不过除了修改pfile，还需要修改 OCR信息。首先来看看RAC的状态：
[root@rac1 tmp]# /u01/app/crs/bin/crs_stat -t
Name Type Target State Host
------------------------------------------------------------
ora.orcl.db application ONLINE ONLINE rac1
ora....l1.inst application ONLINE ONLINE rac1
ora....l2.inst application ONLINE ONLINE rac2
ora....SM1.asm application ONLINE ONLINE rac1
ora....C1.lsnr application ONLINE ONLINE rac1
ora.rac1.gsd application ONLINE ONLINE rac1
ora.rac1.ons application ONLINE ONLINE rac1
ora.rac1.vip application ONLINE ONLINE rac1
ora....SM2.asm application ONLINE ONLINE rac2
ora....C2.lsnr application ONLINE ONLINE rac2
ora.rac2.gsd application ONLINE ONLINE rac2
ora.rac2.ons application ONLINE ONLINE rac2
ora.rac2.vip application ONLINE ONLINE rac2现在RAC状态一切正常，所有服务已经启动。下面来试下如何修改2台RAC机器的SID，分别修改为：orcl3, orcl41. 创建pfile,然后把orcl1--->orcl3 orcl2--->orcl4,并传输给另外一个节点，其他参数不任何变更
SQL> conn /as sysdba
Connected.
SQL> create pfile="/tmp/pfile" from spfile;File created.[Oracle@rac1 companion]$ scp /tmp/pfile 192.168.18.9:/tmp
pfile 100% 1290 1.3KB/s 00:00[oracle@rac1 companion]$ cat /tmp/pfile
orcl4.__db_cache_size=75497472
orcl3.__db_cache_size=58720256
orcl3.__java_pool_size=4194304
orcl4.__java_pool_size=4194304
orcl3.__large_pool_size=4194304
orcl4.__large_pool_size=4194304
orcl4.__shared_pool_size=79691776
orcl3.__shared_pool_size=96468992
orcl3.__streams_pool_size=0
orcl4.__streams_pool_size=0
*.audit_file_dest="/u01/app/oracle/admin/orcl/adump"
*.background_dump_dest="/u01/app/oracle/admin/orcl/bdump"
*.cluster_database_instances=2
*.cluster_database=true
*.compatible="10.2.0.1.0"
*.control_files="+DATA1/orcl/controlfile/current.260.696461787"
*.core_dump_dest="/u01/app/oracle/admin/orcl/cdump"
*.db_block_size=8192
*.db_create_file_dest="+DATA1"
*.db_domain="oracle.com"
*.db_file_multiblock_read_count=16
*.db_name="orcl"
*.dispatchers="（PROTOCOL=TCP）（SERVICE=orclXDB）"
orcl4.instance_number=2
orcl3.instance_number=1
*.job_queue_processes=10
*.log_archive_dest_1="LOCATION=+DATA1/orcl/"
*.log_archive_format="%t_%s_%r.dbf"
*.open_cursors=300
*.pga_aggregate_target=16777216
*.processes=150
*.remote_listener="LISTENERS_ORCL"
*.remote_login_passwordfile="exclusive"
*.sga_target=167772160
orcl4.thread=2
orcl3.thread=1
*.undo_management="AUTO"
orcl3.undo_tablespace="UNDOTBS1"
orcl4.undo_tablespace="UNDOTBS2"
*.user_dump_dest="/u01/app/oracle/admin/orcl/udump"

Oracle 跟踪文件和文件转储PostgreSQL的用户、角色和权限管理相关资讯 Oracle RAC Oracle Instance

Oracle RAC 更换存储实验（今 06:38）
Oracle RAC客户端tnsnames.ora相关（09/02/2015 19:31:57）
Oracle 11gR2 RAC集群服务启动与关（04/29/2015 10:27:54）

11.2.04 Oracle RAC 目录中（12/21/2015 15:10:42）
关于心跳网络引起的Oracle RAC的节（06/04/2015 17:53:20）
RedHat 6.4安装Oracle11.2.0.2 RAC （04/27/2015 19:26:34）

本文评论查看全部评论（0）

评论声明