OracleRAC修改数据库资源信息

作者：deniz2502915157 | 来源：互联网 | 2023-09-18 11:40

点击上方“IT那活儿”，关注后了解更多内容，不管IT什么活儿，干就完了！！！

需求

预发布PRE改为准生产ZSC：

主机名修改hf-ahla-db-09-pre -》 hf-ahla-db-09-zsc；
实例名修改 pre标识换zsc；
unique name修改 pre标识换zsc；
监听标识修改 pre标识换zsc；
其他保持不变。

前期检查

查看数据库相关资源信息：

[grid@hf-ahla-db-09-pre ~]$ crsctl stat res -t--------------------------------------------------------------------------------NAME TARGET STATE SERVER STATE_DETAILS--------------------------------------------------------------------------------Local Resources--------------------------------------------------------------------------------ora.DATA.dgONLINE ONLINE hf-ahla-db-09-preora.LISTENER.lsnrONLINE ONLINE hf-ahla-db-09-preora.LISTENER_ADG.lsnrONLINE ONLINE hf-ahla-db-09-preora.UDRDG.dgOFFLINE OFFLINE hf-ahla-db-09-preora.asmONLINE ONLINE hf-ahla-db-09-pre Startedora.onsONLINE ONLINE hf-ahla-db-09-pre--------------------------------------------------------------------------------Cluster Resources--------------------------------------------------------------------------------ora.carpre.carro.svc1 ONLINE ONLINE hf-ahla-db-09-preora.carpre.carrw.svc1 OFFLINE OFFLINEora.carpre.db1 ONLINE ONLINE hf-ahla-db-09-pre Open,Readonlyora.crmpre.crmro.svc1 ONLINE ONLINE hf-ahla-db-09-preora.crmpre.crmrw.svc1 OFFLINE OFFLINEora.crmpre.db1 ONLINE ONLINE hf-ahla-db-09-pre Open,Readonlyora.cssd1 ONLINE ONLINE hf-ahla-db-09-preora.diskmon1 OFFLINE OFFLINEora.evmd1 ONLINE ONLINE hf-ahla-db-09-preora.shqpre.db1 ONLINE ONLINE hf-ahla-db-09-pre Open,Readonlyora.shqpre.shqro.svc1 ONLINE ONLINE hf-ahla-db-09-preora.shqpre.shqrw.svc1 OFFLINE OFFLINEora.tbcpre.db1 ONLINE ONLINE hf-ahla-db-09-pre Open,Readonlyora.tbcpre.tbcro.svc1 ONLINE ONLINE hf-ahla-db-09-preora.tbcpre.tbcrw.svc1 OFFLINE OFFLINEora.tjdpre.db1 ONLINE ONLINE hf-ahla-db-09-pre Open,Readonlyora.tjdpre.tjdro.svc1 ONLINE ONLINE hf-ahla-db-09-preora.tjdpre.tjdrw.svc1 OFFLINE OFFLINE[oracle@hf-ahla-db-09-pre ~]$ ps -ef|grep pmonoracle 5230 1 0 10:33 ? 00:00:00 ora_pmon_tjdpreoracle 22802 22645 0 11:15 pts/10 00:00:00 grep --color=auto pmonoracle 38583 1 0 10:16 ? 00:00:00 ora_pmon_crmpregrid 40715 1 0 May06 ? 00:03:45 asm_pmon_+ASMoracle 40919 1 0 10:16 ? 00:00:00 ora_pmon_shqpreoracle 41964 1 0 10:17 ? 00:00:00 ora_pmon_carpreoracle 48760 1 0 10:24 ? 00:00:00 ora_pmon_tbcpreSYS@tjdpre>show parameter nameNAME TYPE VALUE------------------------------------ ----------- ------------------------------db_file_name_convert stringdb_name string shqtjdb_unique_name string tjdpreglobal_names boolean FALSEinstance_name string tjdprelock_name_space stringlog_file_name_convert stringprocessor_group_name stringservice_names string tjdroSYS@crmpre>show parameter nameNAME TYPE VALUE------------------------------------ ----------- ------------------------------cell_offloadgroup_name stringdb_file_name_convert stringdb_name string orcyehoodb_unique_name string crmpreglobal_names boolean FALSEinstance_name string crmprelock_name_space stringlog_file_name_convert stringprocessor_group_name stringservice_names string crmroSYS@shqpre>show parameter nameNAME TYPE VALUE------------------------------------ ----------- ------------------------------cell_offloadgroup_name stringdb_file_name_convert stringdb_name string ahladbdb_unique_name string shqpreglobal_names boolean FALSEinstance_name string shqprelock_name_space stringlog_file_name_convert stringprocessor_group_name stringservice_names string shqroSYS@carpre>show parameter nameNAME TYPE VALUE------------------------------------ ----------- ------------------------------db_file_name_convert stringdb_name string cxcddbdb_unique_name string carpreglobal_names boolean FALSEinstance_name string carprelock_name_space stringlog_file_name_convert stringprocessor_group_name stringservice_names string carroSYS@tbcpre>show parameter nameNAME TYPE VALUE------------------------------------ ----------- ------------------------------cell_offloadgroup_name stringdb_file_name_convert stringdb_name string tbcdb_unique_name string tbcpreglobal_names boolean FALSEinstance_name string tbcprelock_name_space stringlog_file_name_convert stringprocessor_group_name stringservice_names string tbcroSQL> select path from v$asm_disk;PATH--------------------------------------------------------------------------------/dev/mapper/rootvg-lv_asmdata_udr_001/dev/mapper/rootvg-lv_asmdata_udr_025/dev/mapper/rootvg-lv_asmdata_udr_026/dev/mapper/rootvg-lv_asmdata_udr_035/dev/mapper/rootvg-lv_asmdata_udr_037/dev/mapper/rootvg-lv_asmdata_udr_020/dev/mapper/rootvg-lv_asmdata_udr_003/dev/mapper/rootvg-lv_asmdata_udr_054/dev/mapper/rootvg-lv_asmdata_udr_070/dev/mapper/rootvg-lv_asmdata_udr_069/dev/mapper/rootvg-lv_asmdata_udr_008PATH--------------------------------------------------------------------------------/dev/mapper/rootvg-lv_asmdata_udr_062/dev/mapper/rootvg-lv_asmdata_udr_067/dev/mapper/rootvg-lv_asmdata_udr_014/dev/mapper/rootvg-lv_asmdata_udr_015/dev/mapper/rootvg-lv_asmdata_udr_068/dev/mapper/rootvg-lv_asmdata_udr_058/dev/mapper/rootvg-lv_asmdata_udr_060/dev/mapper/rootvg-lv_asmdata_udr_066/dev/mapper/rootvg-lv_asmdata_udr_056/dev/mapper/rootvg-lv_asmdata_udr_061/dev/mapper/rootvg-lv_asmdata_udr_047PATH--------------------------------------------------------------------------------/dev/mapper/rootvg-lv_asmdata_udr_063/dev/mapper/rootvg-lv_asmdata_udr_055/dev/mapper/rootvg-lv_asmdata_udr_002/dev/mapper/rootvg-lv_asmdata_udr_057/dev/mapper/rootvg-lv_asmdata_udr_028/dev/mapper/rootvg-lv_asmdata_udr_048/dev/mapper/rootvg-lv_asmdata_udr_039/dev/mapper/rootvg-lv_asmdata_udr_034/dev/mapper/rootvg-lv_asmdata_udr_044/dev/mapper/rootvg-lv_asmdata_udr_033/dev/mapper/rootvg-lv_asmdata_udr_016PATH--------------------------------------------------------------------------------/dev/mapper/rootvg-lv_asmdata_udr_045/dev/mapper/rootvg-lv_asmdata_udr_004/dev/mapper/rootvg-lv_asmdata_udr_053/dev/mapper/rootvg-lv_asmdata_udr_011/dev/mapper/rootvg-lv_asmdata_udr_017/dev/mapper/rootvg-lv_asmdata_udr_007/dev/mapper/rootvg-lv_asmdata_udr_027/dev/mapper/rootvg-lv_asmdata_udr_042/dev/mapper/rootvg-lv_asmdata_udr_023/dev/mapper/rootvg-lv_asmdata_udr_046/dev/mapper/rootvg-lv_asmdata_udr_040PATH--------------------------------------------------------------------------------/dev/mapper/rootvg-lv_asmdata_udr_051/dev/mapper/rootvg-lv_asmdata_udr_018/dev/mapper/rootvg-lv_asmdata_udr_059/dev/mapper/rootvg-lv_asmdata_udr_012/dev/mapper/rootvg-lv_asmdata_udr_022/dev/mapper/rootvg-lv_asmdata_udr_064/dev/mapper/rootvg-lv_asmdata_udr_013/dev/mapper/rootvg-lv_asmdata_udr_005/dev/mapper/rootvg-lv_asmdata_udr_065/dev/mapper/rootvg-lv_asmdata_udr_049/dev/mapper/rootvg-lv_asmdata_udr_010PATH--------------------------------------------------------------------------------/dev/mapper/rootvg-lv_asmdata_udr_006/dev/mapper/rootvg-lv_asmdata_udr_021/dev/mapper/rootvg-lv_asmdata_udr_041/dev/mapper/rootvg-lv_asmdata_udr_030/dev/mapper/rootvg-lv_asmdata_udr_031/dev/mapper/rootvg-lv_asmdata_udr_009/dev/mapper/rootvg-lv_asmdata_udr_036/dev/mapper/rootvg-lv_asmdata_udr_052/dev/mapper/rootvg-lv_asmdata_udr_043/dev/mapper/rootvg-lv_asmdata_udr_032/dev/mapper/rootvg-lv_asmdata_udr_029PATH--------------------------------------------------------------------------------/dev/mapper/rootvg-lv_asmdata_udr_038/dev/mapper/rootvg-lv_asmdata_udr_050/dev/mapper/rootvg-lv_asmdata_udr_019/dev/mapper/rootvg-lv_asmdata_udr_02470 rows selected.[root@hf-ahla-db-09-pre ~]# hostnamehf-ahla-db-09-pre

操作

1. 备份oracle不同实例的以及asm的参数文件：

SYS@tbcpre>create pfile from spfile;File created.asm:SQL> create pfile from spfile;create pfile from spfile*ERROR at line 1:ORA-01565: error in identifying file'+UDRDG/asm/asmparameterfile/registry.253.1043685383'ORA-17503: ksfdopn:10 Failed to open file+UDRDG/asm/asmparameterfile/registry.253.1043685383ORA-15001: diskgroup "UDRDG" does not exist or is not mounted

2. 查看资源组信息：

SQL> show parameter nameNAME TYPE VALUE------------------------------------ ----------- ------------------------------db_unique_name string +ASMinstance_name string +ASMlock_name_space stringservice_names string +ASMSQL> show parameter typeNAME TYPE VALUE------------------------------------ ----------- ------------------------------instance_type string asmSQL> show parameter largeNAME TYPE VALUE------------------------------------ ----------- ------------------------------large_pool_size big integer 16Muse_large_pages string TRUESQL> show parameter diskstringNAME TYPE VALUE------------------------------------ ----------- ------------------------------asm_diskstring string dev/mapper/*SQL> show parameter loginNAME TYPE VALUE------------------------------------ ----------- ------------------------------remote_login_passwordfile string EXCLUSIVESQL>SQL> show parameter diskgroupNAME TYPE VALUE------------------------------------ ----------- ------------------------------asm_diskgroups string DATA

3. 先修改主机名：

hostnamectl set-hostname hf-ahla-db-09-zsc

修改/etc/hosts：

[root@hf-ahla-db-09-pre ~]# cat etc/hosts127.0.0.1 localhost localhost.localdomain localhost4 localhost4.localdomain4::1 localhost localhost.localdomain localhost6 localhost6.localdomain6***.***.***.229 hf-ahla-db-09-zsc#nbu***.***.***.120 hf-ust-app01-nbu

4. 删除原先配置

[root@hf-ahla-db-09-pre ~]# find / -name roothas.pl/home/grid/18370031/files/crs/install/roothas.pl/home/grid/28429134/27735020/files/crs/install/roothas.pl/home/oracle/28429134/27735020/files/crs/install/roothas.pl/u01/app/11.2.0.4/grid/crs/install/roothas.pl/u01/app/11.2.0.4/grid/.patch_storage/18370031_Aug_15_2014_16_14_40/files/crs/install/roothas.pl/u01/app/11.2.0.4/grid/.patch_storage/27735020_Sep_20_2018_02_02_56/files/crs/install/roothas.pl/u01/app/oracle/product/11.2.0.4/dbhome_1/crs/install/roothas.pl/u01/app/oracle/product/11.2.0.3/dbhome_1/crs/install/roothas.pl

用/u01/app/11.2.0.4/grid/crs/install/roothas.pl来执行删除配置操作。

/u01/app/11.2.0.4/grid/crs/install/roothas.pl -deconfig -force

5. 安装资源配置

/u01/app/11.2.0/grid/crs/install/roothas.pl

6. 查看资源状态

crsctl stat res -t

设置开机自启动。

/u01/app/11.2.0/grid/bin/crsctl modify resource "ora.cssd" -init -attr "AUTO_START=1"

查看资源状态，并停止has服务。

ps -ef|grep d.bincrsctl stop hasps -ef|grep d.bin

依次在不同库的参数文件下修改db_unique_name、fal_client、log_archive_config、log_archive_dest_1。

添加参数instance_name。结果只看到这三个库的备份pfile：

-rw-r--r--. 1 oracle dba 3215 May 25 13:30 initcrmpre.ora-rw-r--r--. 1 oracle dba 2708 May 25 13:30 initshqpre.ora-rw-r--r--. 1 oracle dba 3407 May 25 13:31 inittbcpre.ora

==》对tjdpre与carpre单独根据目录创建：

create pfile='/u01/app/oracle/product/11.2.0.4/dbhome_1/dbs/inittjdpre.ora' from spfile;create pfile='/u01/app/oracle/product/11.2.0.4/dbhome_1/dbs/initcarpre.ora' from spfile;

--这里先修改tjdpre的参数文件：

[oracle@hf-ahla-db-09-pre dbs]$ cat inittjdpre.oratjdudr.__db_cache_size=48049946624tjdpre.__db_cache_size=48049946624tjdudr.__java_pool_size=134217728tjdpre.__java_pool_size=134217728tjdudr.__large_pool_size=268435456tjdpre.__large_pool_size=134217728tjdudr.__oracle_base='/u01/app/oracle'#ORACLE_BASE set from environmenttjdpre.__oracle_base='/u01/app/oracle'#ORACLE_BASE set from environmenttjdudr.__pga_aggregate_target=8589934592tjdpre.__pga_aggregate_target=8589934592tjdudr.__sga_target=53687091200tjdpre.__sga_target=53687091200tjdudr.__shared_io_pool_size=0tjdpre.__shared_io_pool_size=0tjdudr.__shared_pool_size=4966055936tjdpre.__shared_pool_size=4831838208tjdudr.__streams_pool_size=0tjdpre.__streams_pool_size=268435456*.archive_lag_target=1800*.audit_trail='none'*.compatible='11.2.0.0.0'*.control_file_record_keep_time=31*.control_files='+DATA/tjdudr/controlfile/current.265.1043715485','+DATA/tjdudr/controlfile/current.266.1043715485'*.db_block_size=8192*.db_create_file_dest='+DATA'*.db_create_online_log_dest_1='+DATA'*.db_domain=''*.db_files=500*.db_flashback_retention_target=4320*.db_lost_write_protect='none'*.db_name='shqtj'*.db_recovery_file_dest_size=4398046511104*.db_recovery_file_dest='+DATA'*.db_unique_name='tjdzsc'=========================================修改点*.diagnostic_dest='/u01/app/oracle'*.enable_ddl_logging=TRUE*.fal_client='tjdzsc'=====================================修改点*.fal_server='tjdust'*.job_queue_processes=100*.local_listener=''*.log_archive_cOnfig='DG_COnFIG=(tjdust,tjdzsc)'==================修改点*.log_archive_dest_1='LOCATION=USE_DB_RECOVERY_FILE_DEST VALID_FOR=(ALL_LOGFILES,ALL_ROLES) DB_UNIQUE_NAME=tjdzsc'=======修改点*.log_archive_dest_2=''*.log_archive_dest_3=''*.log_archive_max_processes=6*.open_cursors=300*.open_links=0*.open_links_per_instance=0*.parallel_max_servers=128*.parallel_servers_target=400*.pga_aggregate_target=8g*.processes=3000*.remote_login_passwordfile='EXCLUSIVE'*.sessiOns=2500*.sga_max_size=50g*.sga_target=50g*.standby_file_management='AUTO'*.undo_tablespace='UNDOTBS1'*.instance_name='tjdzsc'===========新增

--tbcpre

[oracle@hf-ahla-db-09-pre dbs]$ cat inittbcpre.oratbcudr.__db_cache_size=26843545600tbcpre.__db_cache_size=26709327872tbcudr.__java_pool_size=939524096tbcpre.__java_pool_size=939524096tbcudr.__large_pool_size=134217728tbcpre.__large_pool_size=134217728tbcudr.__oracle_base='/u01/app/oracle'#ORACLE_BASE set from environmenttbcpre.__oracle_base='/u01/app/oracle'#ORACLE_BASE set from environmenttbcudr.__pga_aggregate_target=8589934592tbcpre.__pga_aggregate_target=8589934592tbcudr.__sga_target=32212254720tbcpre.__sga_target=32212254720tbcudr.__shared_io_pool_size=0tbcpre.__shared_io_pool_size=0tbcudr.__shared_pool_size=4026531840tbcpre.__shared_pool_size=4160749568tbcudr.__streams_pool_size=0tbcpre.__streams_pool_size=0*._b_tree_bitmap_plans=false*._bloom_filter_enabled=false*._external_scn_logging_threshold_secOnds=21600*._external_scn_rejection_threshold_hours=24*._gby_hash_aggregation_enabled=false*._index_partition_large_extents='false'*._keep_remote_column_size=TRUE*._ksmg_granule_size=134217728*._lm_sync_timeout=1200*._lm_tickets=5000*._memory_imm_mode_without_autosga=FALSE*._nlj_batching_misses_enabled=0*._optim_peek_user_binds=false*._optimizer_mjc_enabled=false*._optimizer_null_aware_antijoin=false*._optimizer_squ_bottomup=FALSE*._optimizer_use_feedback=false*._partition_large_extents='false'*._px_use_large_pool=true*._smu_debug_mode=134217728*._undo_autotune=FALSE*._use_adaptive_log_file_sync='false'*.archive_lag_target=1800*.audit_trail='none'*.compatible='11.2.0.4.0'*.control_file_record_keep_time=31*.control_files='+DATA/tbcudr/controlfile/current.267.1043715581','+DATA/tbcudr/controlfile/current.268.1043715581'*.db_block_size=8192*.db_create_file_dest='+DATA'*.db_create_online_log_dest_1='+DATA'*.db_domain=''*.db_file_multiblock_read_count=32*.db_files=1024*.db_flashback_retention_target=4320*.db_lost_write_protect='none'*.db_name='tbc'*.db_recovery_file_dest_size=2199023255552*.db_recovery_file_dest='+DATA'*.db_securefile='PERMITTED'*.db_unique_name='tbczsc'=========================修改点*.deferred_segment_creation=FALSE*.diagnostic_dest='/u01/app/oracle'*.distributed_lock_timeout=240*.enable_ddl_logging=true*.enable_goldengate_replication=TRUE*.event='10949 trace name context forever:28401 trace name context forever, level 1'*.fal_client='tbczsc'===============================修改点*.fal_server='tbcust'*.fast_start_parallel_rollback='low'*.filesystemio_optiOns='SETALL'*.global_names=FALSE*.job_queue_processes=1000*.local_listener=''*.log_archive_cOnfig='DG_COnFIG=(tbcust,tbczsc)'=====================修改点*.log_archive_dest_1='LOCATION=USE_DB_RECOVERY_FILE_DEST VALID_FOR=(ALL_LOGFILES,ALL_ROLES) DB_UNIQUE_NAME=tbczsc'=========修改点*.log_archive_dest_2=''*.log_archive_dest_3=''*.log_archive_dest_state_2='ENABLE'*.log_archive_format='%d_%t_%s_%r.dbf'*.max_shared_servers=0*.nls_territory='AMERICA'*.open_cursors=2000*.open_links=0*.open_links_per_instance=0*.parallel_execution_message_size=16384*.parallel_max_servers=128*.parallel_servers_target=400*.pga_aggregate_target=8g*.processes=3000*.query_rewrite_enabled='TRUE'*.query_rewrite_integrity='trusted'*.remote_login_passwordfile='EXCLUSIVE'*.resource_manager_plan='force:'*.session_cached_cursors=200*.sessiOns=1655*.sga_max_size=32212254720*.sga_target=32212254720*.shared_servers=0*.standby_file_management='AUTO'*.star_transformation_enabled='FALSE'*.timed_statistics=TRUE*.undo_management='AUTO'*.undo_retention=10800*.undo_tablespace='UNDOTBS1'*.instance_name='tbczsc'===========新增

--shqpre

[oracle@hf-ahla-db-09-pre dbs]$ cat initshqpre.orashqudr.__db_cache_size=47110422528shqpre.__db_cache_size=47110422528shqudr.__java_pool_size=939524096shqpre.__java_pool_size=939524096shqudr.__large_pool_size=134217728shqpre.__large_pool_size=134217728shqudr.__oracle_base='/u01/app/oracle'#ORACLE_BASE set from environmentshqpre.__oracle_base='/u01/app/oracle'#ORACLE_BASE set from environmentshqudr.__pga_aggregate_target=8589934592shqpre.__pga_aggregate_target=8589934592shqudr.__sga_target=53687091200shqpre.__sga_target=53687091200shqudr.__shared_io_pool_size=0shqpre.__shared_io_pool_size=0shqudr.__shared_pool_size=5234491392shqpre.__shared_pool_size=4966055936shqudr.__streams_pool_size=0shqpre.__streams_pool_size=268435456*._b_tree_bitmap_plans=FALSE*._bloom_filter_enabled=FALSE*._gby_hash_aggregation_enabled=FALSE*._index_partition_large_extents='FALSE'*._optimizer_mjc_enabled=FALSE*._optimizer_squ_bottomup=TRUE*._smu_debug_mode=134217728*.archive_lag_target=1800*.audit_trail='none'*.compatible='11.2.0.0.0'*.control_file_record_keep_time=31*.control_files='+DATA/shqudr/controlfile/current.271.1043715717','+DATA/shqudr/controlfile/current.272.1043715717'*.db_block_size=8192*.db_create_file_dest='+DATA'*.db_create_online_log_dest_1='+DATA'*.db_domain=''*.db_file_multiblock_read_count=32*.db_files=1500*.db_flashback_retention_target=4320*.db_lost_write_protect='none'*.db_name='ahladb'*.db_recovery_file_dest_size=2199023255552*.db_recovery_file_dest='+DATA'*.db_unique_name='shqzsc'======================修改点*.diagnostic_dest='/u01/app/oracle'*.distributed_lock_timeout=240*.enable_ddl_logging=true*.enable_goldengate_replication=TRUE*.event='10949 trace name context forever:28401 trace name context forever, level 1'*.fal_client='shqzsc'=================================修改点*.fal_server='shqust'*.fast_start_parallel_rollback='low'*.global_names=FALSE*.job_queue_processes=150*.local_listener=''*.log_archive_cOnfig='DG_COnFIG=(shqust,shqzsc)'======================修改点*.log_archive_dest_1='LOCATION=USE_DB_RECOVERY_FILE_DEST VALID_FOR=(ALL_LOGFILES,ALL_ROLES) DB_UNIQUE_NAME=shqzsc'=========修改点*.log_archive_dest_2=''*.log_archive_dest_3=''*.max_shared_servers=0*.open_cursors=3000*.open_links=0*.open_links_per_instance=0*.parallel_execution_message_size=16384*.parallel_max_servers=128*.parallel_servers_target=400*.pga_aggregate_target=8G*.processes=3000*.query_rewrite_enabled='TRUE'*.query_rewrite_integrity='trusted'*.remote_login_passwordfile='EXCLUSIVE'*.resource_manager_plan='force:'*.session_cached_cursors=200*.sessiOns=4000*.sga_max_size=50g*.SGA_target=50g*.shared_servers=0*.standby_file_management='AUTO'*.star_transformation_enabled='FALSE'*.timed_statistics=TRUE*.undo_retention=10800*.undo_tablespace='UNDOTBS1'*.use_large_pages='ONLY'*.instance_name='shqzsc'===========新增

--crmpre

[oracle@hf-ahla-db-09-pre dbs]$ cat initcrmpre.oracrmudr.__db_cache_size=47378857984crmpre.__db_cache_size=47110422528crmudr.__java_pool_size=939524096crmpre.__java_pool_size=939524096crmudr.__large_pool_size=134217728crmpre.__large_pool_size=134217728crmudr.__oracle_base='/u01/app/oracle'#ORACLE_BASE set from environmentcrmpre.__oracle_base='/u01/app/oracle'#ORACLE_BASE set from environmentcrmudr.__pga_aggregate_target=8589934592crmpre.__pga_aggregate_target=8589934592crmudr.__sga_target=53687091200crmpre.__sga_target=53687091200crmudr.__shared_io_pool_size=0crmpre.__shared_io_pool_size=0crmudr.__shared_pool_size=4966055936crmpre.__shared_pool_size=4966055936crmudr.__streams_pool_size=0crmpre.__streams_pool_size=268435456*._b_tree_bitmap_plans=false*._bloom_filter_enabled=false*._gby_hash_aggregation_enabled=false*._index_partition_large_extents='false'*._keep_remote_column_size=TRUE*._ksmg_granule_size=134217728*._lm_sync_timeout=1200*._lm_tickets=5000*._memory_imm_mode_without_autosga=FALSE*._nlj_batching_misses_enabled=0*._optim_peek_user_binds=FALSE*._optimizer_mjc_enabled=false*._optimizer_null_aware_antijoin=false*._optimizer_squ_bottomup=FALSE*._optimizer_use_feedback=false*._partition_large_extents='false'*._px_use_large_pool=true*._smu_debug_mode=134217728*._undo_autotune=FALSE*._use_adaptive_log_file_sync='false'*.archive_lag_target=1800*.audit_trail='none'*.compatible='11.2.0.4.0'*.control_file_record_keep_time=31*.control_files='+DATA/crmudr/controlfile/current.273.1043715771','+DATA/crmudr/controlfile/current.274.1043715771'*.db_block_size=8192*.db_create_file_dest='+DATA'*.db_create_online_log_dest_1='+DATA'*.db_domain=''*.db_file_multiblock_read_count=32*.db_files=1500*.db_flashback_retention_target=4320*.db_lost_write_protect='none'*.db_name='orcyehoo'*.db_recovery_file_dest_size=2199023255552*.db_recovery_file_dest='+DATA'*.db_unique_name='crmzsc'================================修改点*.diagnostic_dest='/u01/app/oracle'*.distributed_lock_timeout=240*.enable_ddl_logging=true*.enable_goldengate_replication=TRUE*.event='10949 trace name context forever:28401 trace name context forever, level 1'*.fal_client='crmzsc'================================修改点*.fal_server='crmust'*.fast_start_parallel_rollback='low'*.global_names=FALSE*.job_queue_processes=100*.local_listener=''*.log_archive_cOnfig='DG_COnFIG=(crmust,crmzsc)'============================修改点*.log_archive_dest_1='LOCATION=USE_DB_RECOVERY_FILE_DEST VALID_FOR=(ALL_LOGFILES,ALL_ROLES) DB_UNIQUE_NAME=crmzsc'================修改点*.log_archive_dest_2=''*.log_archive_dest_3=''*.log_archive_dest_state_3='enable'*.log_archive_format='%d_%t_%s_%r.dbf'*.max_shared_servers=0*.open_cursors=2000*.open_links=0*.open_links_per_instance=0*.parallel_execution_message_size=16384*.parallel_max_servers=128*.parallel_servers_target=400*.pga_aggregate_target=8G*.processes=3000*.query_rewrite_enabled='TRUE'*.query_rewrite_integrity='trusted'*.remote_login_passwordfile='EXCLUSIVE'*.resource_manager_plan='force:'*.instance_name='crmzsc'===========新增

--carpre

[oracle@hf-ahla-db-09-pre dbs]$ cat initcarpre.oracarudr.__db_cache_size=47915728896carpre.__db_cache_size=48184164352carudr.__java_pool_size=134217728carpre.__java_pool_size=134217728carudr.__large_pool_size=268435456carpre.__large_pool_size=134217728carudr.__oracle_base='/u01/app/oracle'#ORACLE_BASE set from environmentcarpre.__oracle_base='/u01/app/oracle'#ORACLE_BASE set from environmentcarudr.__pga_aggregate_target=8589934592carpre.__pga_aggregate_target=8589934592carudr.__sga_target=53687091200carpre.__sga_target=53687091200carudr.__shared_io_pool_size=0carpre.__shared_io_pool_size=0carudr.__shared_pool_size=5100273664carpre.__shared_pool_size=4966055936carudr.__streams_pool_size=0carpre.__streams_pool_size=0*.aq_tm_processes=0*.archive_lag_target=1800*.audit_trail='none'*.compatible='11.2.0.0.0'*.control_file_record_keep_time=31*.control_files='+DATA/carudr/controlfile/current.269.1043715643','+DATA/carudr/controlfile/current.270.1043715643'*.db_block_size=8192*.db_create_file_dest='+DATA'*.db_create_online_log_dest_1='+DATA'*.db_domain=''*.db_files=1000*.db_flashback_retention_target=4320*.db_lost_write_protect='none'*.db_name='cxcddb'*.db_recovery_file_dest_size=2199023255552*.db_recovery_file_dest='+DATA'*.db_unique_name='carzsc'=========================修改点*.diagnostic_dest='/u01/app/oracle'*.enable_ddl_logging=TRUE*.fal_client='carzsc'=====================================修改点*.fal_server='carust'*.job_queue_processes=150*.local_listener=''*.log_archive_cOnfig='DG_COnFIG=(carust,carzsc)'========================修改点*.log_archive_dest_1='LOCATION=USE_DB_RECOVERY_FILE_DEST VALID_FOR=(ALL_LOGFILES,ALL_ROLES) DB_UNIQUE_NAME=carzsc'==========修改点*.log_archive_dest_2=''*.log_archive_dest_3=''*.open_cursors=300*.open_links=0*.open_links_per_instance=0*.parallel_max_servers=128*.parallel_servers_target=400*.pga_aggregate_target=8g*.processes=3000*.remote_login_passwordfile='EXCLUSIVE'*.sec_case_sensitive_logon=FALSE*.sessiOns=4000*.sga_max_size=50g*.sga_target=50g*.standby_file_management='AUTO'*.instance_name='carzsc'===========新增

--从主即ust上$ORACLE_HOME/dbs目录下拷贝密码文件到ahla上并且重命名。

先通过scp传输过去，然后mv重名名。

==》发现Permission denied,权限被阻止了是因为接收地目录权限位置，设置个临时目录给777，然后再cp到相应目录即可。

在grid用户下开启has服务并检查：

crsctl start hascrsctl check hascrsctl stat resourcecrsctl stat res -t

编辑listener.ora

[grid@hf-ahla-db-09-zsc admin]$ cat listener.ora# listener.ora Network Configuration File: /u01/app/11.2.0.4/grid/network/admin/listener.ora# Generated by Oracle configuration tools.LISTENER_ADG =(DESCRIPTION =(ADDRESS = (PROTOCOL = TCP)(HOST = hf-ahla-db-09-zsc)(PORT = 1207))(SEND_BUF_SIZE=10485760)(RECV_BUF_SIZE=10485760))ADR_BASE_LISTENER_ADG = /u01/app/gridSUBSCRIBE_FOR_NODE_DOWN_EVENT_LISTENER_ADG = OFFENABLE_GLOBAL_DYNAMIC_ENDPOINT_LISTENER_ADG = OnLISTENER=(DESCRIPTION =(ADDRESS = (PROTOCOL = TCP)(HOST = hf-ahla-db-09-zsc)(PORT = 1521)))ADR_BASE_LISTENER = /u01/app/gridSID_LIST_LISTENER_ADG =(SID_LIST =(SID_DESC =(SDU=65535)(GLOBAL_DBNAME = crmzsc)(ORACLE_HOME = /u01/app/oracle/product/11.2.0.4/dbhome_1)(SID_NAME = crmzsc))(SID_DESC =(SDU=65535)(GLOBAL_DBNAME = shqzsc)(ORACLE_HOME = /u01/app/oracle/product/11.2.0.4/dbhome_1)(SID_NAME = shqzsc))(SID_DESC =(SDU=65535)(GLOBAL_DBNAME = carzsc)(ORACLE_HOME = /u01/app/oracle/product/11.2.0.3/dbhome_1)(SID_NAME = carzsc))(SID_DESC =(SDU=65535)(GLOBAL_DBNAME = tjdzsc)(ORACLE_HOME = /u01/app/oracle/product/11.2.0.3/dbhome_1)(SID_NAME = tjdzsc))(SID_DESC =(SDU=65535)(GLOBAL_DBNAME = tbczsc)(ORACLE_HOME = /u01/app/oracle/product/11.2.0.4/dbhome_1)(SID_NAME = tbczsc)))SUBSCRIBE_FOR_NODE_DOWN_EVENT_LISTENER = OFFENABLE_GLOBAL_DYNAMIC_ENDPOINT_LISTENER = ON

然后grid用户下执行：

srvctl add listener==========这里因为生产环境是两个监听，因此是错误的。

srvctl add listener -l LISTENERsrvctl add listener -l LISTENER_ADGsrvctl start listener

--添加asm资源：

srvctl add asmcrsctl modify resource "ora.asm" -init -attr "AUTO_START=1"

然后sqlplus / as sysasm登陆asm实例，以备份的pfile文件来启动：

startup pfile=init+ASM.ora

然后创建spfile：

create spfile='+DATA' from pfile='/u01/app/11.2.0/grid/dbs/init+ASM.ora';

将监听重新修改下：

srvctl modify asm -l LISTENERsrvctl modify asm -l LISTENER_ADG========新增

--生产上有很多的资源都需要重新注册到OCR里===================新增。

--添加服务资源：

srvctl add service -d crmzsc -s crmpre.crmro==》错误写法，资源那显示前面一个点是db_unique_name，而-d包含了。

srvctl add service -d crmzsc -s crmpre.crmrw====>这步省略，原资源状态就是不可用。

srvctl add service -d crmzsc -s crmzscsrvctl add service -d shqzsc -s shqrosrvctl add service -d tbczsc -s tbcrosrvctl add service -d tjdzsc -s tjdrosrvctl add service -d carzsc -s tjdrw

--添加ons资源：

srvctl add ons

停启has服务，查看资源状态：

crsctl stop hascrsctl start hascrsctl stat res -tps -ef|grep pmon

切换环境变量来登录不同数据库。

export ORACLE_SID=carzsc

然后以修改后的pfile来登陆数据库到nomount状态。

创建spfile。

关库。

以这个为范例修改，不同实例下添加不同的库资源。

--添加数据库资源，oracle来执行：

srvctl add database -d crmzsc -n orcyehoo -o /u01/app/oracle/11.2.0/dbhome_1 -icrmzscsrvctl add database -d shqzsc -n ahladb -o /u01/app/oracle/11.2.0/dbhome_1 -i shqzscsrvctl add database -d tbczsc -n tbc -o /u01/app/oracle/11.2.0/dbhome_1 -i tbczscsrvctl add database -d tjdzsc -n shqtj -o /u01/app/oracle/11.2.0/dbhome_1 -i tjdzscsrvctl add database -d carzsc -n cxcddb -o /u01/app/oracle/11.2.0/dbhome_1 -i carzsc