rac修改instance_name
来源:互联网 发布:js div position 编辑:程序博客网 时间:2024/05/21 12:42
oracle版本:11.2.0.4
RAC两个节点RAC1和RAC2,分别对应实例为racdb1和racdb2,将实例名
修改为racdb_1,racdb_2
--1.停止实例名
[oracle@rac2 ~]$ srvctl status database -d racdb
Instance racdb1 is not running on node rac1
Instance racdb2 is not running on node rac2
[oracle@rac1~]$ srvctl stop instance -d racdb -i racdb1
[oracle@rac1 ~]$ srvctl stop instance -d racdb -i racdb2
--2.杀死oracle进程
在两个节点的系统检查oracle进程是否被正常枪毙 ps aux | grep ora
--3.删除再添加
[oracle@rac1 ~]$ srvctl status database -d racdb
Instance racdb1 is not running on node rac1
Instance racdb2 is not running on node rac2
--删除
srvctl remove instance -d racdb -i racdb1
srvctl remove instance -d racdb -i racdb2
--添加
srvctl add instance -d racdb -i racdb_1 -n rac1
srvctl add instance -d racdb -i racdb_2 -n rac2
--4.启动2个实例
srvctl start instance -d racdb -i racdb_1
srvctl start instance -d racdb -i racdb_2
[oracle@rac2 ~]$ srvctl status database -d racdb
Instance racdb_1 is running on node rac1
Instance racdb_2 is running on node rac2
SQL> select instance_number,instance_name from gv$instance;
INSTANCE_NUMBER INSTANCE_NAME
--------------- ----------------
2 racdb_2
1 racdb_1
SQL> show parameter instance_name;
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
instance_name string racdb_1
SQL> show parameter instance_name;
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
instance_name string racdb_2
--5.修改pfile(两个节点)
■节点1
sql>create pfile from spfile;
#cd /u01/app/oracle/product/11.2.0/db_1/dbs
#vi /u01/app/oracle/product/11.2.0/db_1/dbs/initracdb_1.ora
racdb_2.__db_cache_size=1392508928
racdb_1.__db_cache_size=1392508928
racdb_1.__java_pool_size=16777216
racdb_2.__java_pool_size=16777216
racdb_1.__large_pool_size=33554432
racdb_2.__large_pool_size=33554432
racdb_1.__oracle_base='/u01/app/oracle'#ORACLE_BASE set from environment
racdb_1.__pga_aggregate_target=1325400064
racdb_2.__pga_aggregate_target=1325400064
racdb_1.__sga_target=1962934272
racdb_2.__sga_target=1962934272
racdb_1.__shared_io_pool_size=0
racdb_2.__shared_io_pool_size=0
racdb_1.__shared_pool_size=486539264
racdb_2.__shared_pool_size=486539264
racdb_1.__streams_pool_size=0
racdb_2.__streams_pool_size=0
*.audit_file_dest='/u01/app/oracle/admin/racdb/adump'
*.audit_trail='db'
*.cluster_database=true
*.compatible='11.2.0.4.0'
*.control_files='+DATA/racdb/controlfile/current.256.901314887','+FRA/racdb/controlfile/current.256.901314889'
*.db_block_size=8192
*.db_create_file_dest='+DATA'
*.db_domain=''
*.db_name='racdb'
*.db_recovery_file_dest='+FRA'
*.db_recovery_file_dest_size=12582912000
*.diagnostic_dest='/u01/app/oracle'
*.dispatchers='(PROTOCOL=TCP) (SERVICE=racdbXDB)'
racdb_2.instance_number=2
racdb_1.instance_number=1
*.local_listener=''
*.memory_target=3274702848
*.open_cursors=300
*.processes=150
*.remote_listener='rac-cluster.jinri.com:1521'
*.remote_login_passwordfile='exclusive'
racdb_2.thread=2
racdb_1.thread=1
racdb_1.undo_tablespace='UNDOTBS1'
racdb_2.undo_tablespace='UNDOTBS2'
sql>startup nomount pfile='/u01/app/oracle/product/11.2.0/db_1/dbs/initracdb_1.ora';
sql>create SPFILE='+DATA/racdb/spfileracdb.ora' from pfile;
#echo "SPFILE='+DATA/racdb/spfileracdb.ora'" >/u01/app/oracle/product/11.2.0/db_1/dbs/initracdb_1.ora
sql>shutdown immediate;
■节点2
#vi /u01/app/oracle/product/11.2.0/db_1/dbs/initracdb_2.ora
racdb_2.__db_cache_size=1392508928
racdb_1.__db_cache_size=1392508928
racdb_1.__java_pool_size=16777216
racdb_2.__java_pool_size=16777216
racdb_1.__large_pool_size=33554432
racdb_2.__large_pool_size=33554432
racdb_2.__oracle_base='/u01/app/oracle'#ORACLE_BASE set from environment
racdb_1.__pga_aggregate_target=1325400064
racdb_2.__pga_aggregate_target=1325400064
racdb_1.__sga_target=1962934272
racdb_2.__sga_target=1962934272
racdb_1.__shared_io_pool_size=0
racdb_2.__shared_io_pool_size=0
racdb_1.__shared_pool_size=486539264
racdb_2.__shared_pool_size=486539264
racdb_1.__streams_pool_size=0
racdb_2.__streams_pool_size=0
*.audit_file_dest='/u01/app/oracle/admin/racdb/adump'
*.audit_trail='db'
*.cluster_database=true
*.compatible='11.2.0.4.0'
*.control_files='+DATA/racdb/controlfile/current.256.901314887','+FRA/racdb/controlfile/current.256.901314889'
*.db_block_size=8192
*.db_create_file_dest='+DATA'
*.db_domain=''
*.db_name='racdb'
*.db_recovery_file_dest='+FRA'
*.db_recovery_file_dest_size=12582912000
*.diagnostic_dest='/u01/app/oracle'
*.dispatchers='(PROTOCOL=TCP) (SERVICE=racdbXDB)'
racdb_2.instance_number=2
racdb_1.instance_number=1
*.local_listener=''
*.memory_target=3274702848
*.open_cursors=300
*.processes=150
*.remote_listener='rac-cluster.jinri.com:1521'
*.remote_login_passwordfile='exclusive'
racdb_2.thread=2
racdb_1.thread=1
racdb_1.undo_tablespace='UNDOTBS1'
racdb_2.undo_tablespace='UNDOTBS2'
sql>startup nomount pfile='/u01/app/oracle/product/11.2.0/db_1/dbs/initracdb_2.ora';
sql>create SPFILE='+DATA/racdb/spfileracdb.ora' from pfile;
#echo "SPFILE='+DATA/racdb/spfileracdb.ora'" >/u01/app/oracle/product/11.2.0/db_1/dbs/initracdb_2.ora
sql>shutdown immediate;
#srvctl config database -d racdb
Database unique name: racdb
Database name: racdb
Oracle home: /u01/app/oracle/product/11.2.0/db_1
Oracle user: oracle
Spfile: +DATA/racdb/spfileracdb.ora
Domain:
Start options: open
Stop options: immediate
Database role: PRIMARY
Management policy: AUTOMATIC
Server pools: racdb
Database instances: racdb_1,racdb_2
Disk Groups: DATA,FRA
Mount point paths:
Services:
Type: RAC
Database is administrator managed
----6.重启数据库
#srvctl stop database -d racdb
#srvctl status database -d racdb
Instance racdb_1 is not running on node rac1
Instance racdb_2 is not running on node rac2
#srvctl start database -d racdb
#srvctl status database -d racdb
Instance racdb_1 is running on node rac1
Instance racdb_2 is running on node rac2
1 0
- rac修改instance_name
- 2013.11.13修改instance_name oracle
- 修改instance_name的语句(alter system set instance_name)
- 修改DBID, DBNAME步骤 不是instance_name哦!
- 修改hostname,db_name,instance_name.service_name作用
- 修改RAC VIP IP
- RAC 修改 spfile 参数
- RAC 修改 spfile 参数
- 修改RAC VIP IP
- ORACLE10g修改RAC VIP
- rac 修改心跳端口
- RAC IP 地址修改
- RAC 修改 spfile 参数
- RAC 修改实例名
- RAC 修改 spfile 参数
- ORACLE10g修改RAC VIP
- RAC 修改 spfile 参数
- RAC 修改 spfile 参数
- iOS版上传数据到阿里后台(AliyunOSSiOS)
- 日经春秋 20160122
- perfect-scrollbar 插件初始滚动条不显示问题。
- 关于Activity(活动)
- 相机和镜头选择时的一些参数
- rac修改instance_name
- 第三篇 基本UI组件
- Eclipse创建Maven项目
- iOS的集中collection布局
- 将语言编译为 Lambda Calculus(译)
- JAVA设计模式之:备忘录模式
- 百度经验分享NGUI3.7.4屏幕适配方案
- Maven较完整教程
- 日期汇总