需 求
主机名修改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.dg
ONLINE ONLINE hf-ahla-db-09-pre
ora.LISTENER.lsnr
ONLINE ONLINE hf-ahla-db-09-pre
ora.LISTENER_ADG.lsnr
ONLINE ONLINE hf-ahla-db-09-pre
ora.UDRDG.dg
OFFLINE OFFLINE hf-ahla-db-09-pre
ora.asm
ONLINE ONLINE hf-ahla-db-09-pre Started
ora.ons
ONLINE ONLINE hf-ahla-db-09-pre
--------------------------------------------------------------------------------
Cluster Resources
--------------------------------------------------------------------------------
ora.carpre.carro.svc
1 ONLINE ONLINE hf-ahla-db-09-pre
ora.carpre.carrw.svc
1 OFFLINE OFFLINE
ora.carpre.db
1 ONLINE ONLINE hf-ahla-db-09-pre Open,Readonly
ora.crmpre.crmro.svc
1 ONLINE ONLINE hf-ahla-db-09-pre
ora.crmpre.crmrw.svc
1 OFFLINE OFFLINE
ora.crmpre.db
1 ONLINE ONLINE hf-ahla-db-09-pre Open,Readonly
ora.cssd
1 ONLINE ONLINE hf-ahla-db-09-pre
ora.diskmon
1 OFFLINE OFFLINE
ora.evmd
1 ONLINE ONLINE hf-ahla-db-09-pre
ora.shqpre.db
1 ONLINE ONLINE hf-ahla-db-09-pre Open,Readonly
ora.shqpre.shqro.svc
1 ONLINE ONLINE hf-ahla-db-09-pre
ora.shqpre.shqrw.svc
1 OFFLINE OFFLINE
ora.tbcpre.db
1 ONLINE ONLINE hf-ahla-db-09-pre Open,Readonly
ora.tbcpre.tbcro.svc
1 ONLINE ONLINE hf-ahla-db-09-pre
ora.tbcpre.tbcrw.svc
1 OFFLINE OFFLINE
ora.tjdpre.db
1 ONLINE ONLINE hf-ahla-db-09-pre Open,Readonly
ora.tjdpre.tjdro.svc
1 ONLINE ONLINE hf-ahla-db-09-pre
ora.tjdpre.tjdrw.svc
1 OFFLINE OFFLINE
[oracle@hf-ahla-db-09-pre ~]$ ps -ef|grep pmon
oracle 5230 1 0 10:33 ? 00:00:00 ora_pmon_tjdpre
oracle 22802 22645 0 11:15 pts/10 00:00:00 grep --color=auto pmon
oracle 38583 1 0 10:16 ? 00:00:00 ora_pmon_crmpre
grid 40715 1 0 May06 ? 00:03:45 asm_pmon_+ASM
oracle 40919 1 0 10:16 ? 00:00:00 ora_pmon_shqpre
oracle 41964 1 0 10:17 ? 00:00:00 ora_pmon_carpre
oracle 48760 1 0 10:24 ? 00:00:00 ora_pmon_tbcpre
SYS@tjdpre>show parameter name
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
db_file_name_convert string
db_name string shqtj
db_unique_name string tjdpre
global_names boolean FALSE
instance_name string tjdpre
lock_name_space string
log_file_name_convert string
processor_group_name string
service_names string tjdro
SYS@crmpre>show parameter name
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
cell_offloadgroup_name string
db_file_name_convert string
db_name string orcyehoo
db_unique_name string crmpre
global_names boolean FALSE
instance_name string crmpre
lock_name_space string
log_file_name_convert string
processor_group_name string
service_names string crmro
SYS@shqpre>show parameter name
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
cell_offloadgroup_name string
db_file_name_convert string
db_name string ahladb
db_unique_name string shqpre
global_names boolean FALSE
instance_name string shqpre
lock_name_space string
log_file_name_convert string
processor_group_name string
service_names string shqro
SYS@carpre>show parameter name
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
db_file_name_convert string
db_name string cxcddb
db_unique_name string carpre
global_names boolean FALSE
instance_name string carpre
lock_name_space string
log_file_name_convert string
processor_group_name string
service_names string carro
SYS@tbcpre>show parameter name
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
cell_offloadgroup_name string
db_file_name_convert string
db_name string tbc
db_unique_name string tbcpre
global_names boolean FALSE
instance_name string tbcpre
lock_name_space string
log_file_name_convert string
processor_group_name string
service_names string tbcro
SQL> 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_008
PATH
--------------------------------------------------------------------------------
/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_047
PATH
--------------------------------------------------------------------------------
/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_016
PATH
--------------------------------------------------------------------------------
/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_040
PATH
--------------------------------------------------------------------------------
/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_010
PATH
--------------------------------------------------------------------------------
/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_029
PATH
--------------------------------------------------------------------------------
/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_024
70 rows selected.
[root@hf-ahla-db-09-pre ~]# hostname
hf-ahla-db-09-pre
操 作
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.1043685383
ORA-15001: diskgroup "UDRDG" does not exist or is not mounted
SQL> show parameter name
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
db_unique_name string +ASM
instance_name string +ASM
lock_name_space string
service_names string +ASM
SQL> show parameter type
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
instance_type string asm
SQL> show parameter large
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
large_pool_size big integer 16M
use_large_pages string TRUE
SQL> show parameter diskstring
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
asm_diskstring string /dev/mapper/*
SQL> show parameter login
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
remote_login_passwordfile string EXCLUSIVE
SQL>
SQL> show parameter diskgroup
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
asm_diskgroups string DATA
hostnamectl set-hostname hf-ahla-db-09-zsc
[root@hf-ahla-db-09-pre ~]# cat /etc/hosts
127.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
[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 -deconfig -force
/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"
ps -ef|grep d.bin
crsctl stop has
ps -ef|grep d.bin
-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
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;
[oracle@hf-ahla-db-09-pre dbs]$ cat inittjdpre.ora
tjdudr.__db_cache_size=48049946624
tjdpre.__db_cache_size=48049946624
tjdudr.__java_pool_size=134217728
tjdpre.__java_pool_size=134217728
tjdudr.__large_pool_size=268435456
tjdpre.__large_pool_size=134217728
tjdudr.__oracle_base=/u01/app/oracle#ORACLE_BASE set from environment
tjdpre.__oracle_base=/u01/app/oracle#ORACLE_BASE set from environment
tjdudr.__pga_aggregate_target=8589934592
tjdpre.__pga_aggregate_target=8589934592
tjdudr.__sga_target=53687091200
tjdpre.__sga_target=53687091200
tjdudr.__shared_io_pool_size=0
tjdpre.__shared_io_pool_size=0
tjdudr.__shared_pool_size=4966055936
tjdpre.__shared_pool_size=4831838208
tjdudr.__streams_pool_size=0
tjdpre.__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===========新增
[oracle@hf-ahla-db-09-pre dbs]$ cat inittbcpre.ora
tbcudr.__db_cache_size=26843545600
tbcpre.__db_cache_size=26709327872
tbcudr.__java_pool_size=939524096
tbcpre.__java_pool_size=939524096
tbcudr.__large_pool_size=134217728
tbcpre.__large_pool_size=134217728
tbcudr.__oracle_base=/u01/app/oracle#ORACLE_BASE set from environment
tbcpre.__oracle_base=/u01/app/oracle#ORACLE_BASE set from environment
tbcudr.__pga_aggregate_target=8589934592
tbcpre.__pga_aggregate_target=8589934592
tbcudr.__sga_target=32212254720
tbcpre.__sga_target=32212254720
tbcudr.__shared_io_pool_size=0
tbcpre.__shared_io_pool_size=0
tbcudr.__shared_pool_size=4026531840
tbcpre.__shared_pool_size=4160749568
tbcudr.__streams_pool_size=0
tbcpre.__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.ora
shqudr.__db_cache_size=47110422528
shqpre.__db_cache_size=47110422528
shqudr.__java_pool_size=939524096
shqpre.__java_pool_size=939524096
shqudr.__large_pool_size=134217728
shqpre.__large_pool_size=134217728
shqudr.__oracle_base=/u01/app/oracle#ORACLE_BASE set from environment
shqpre.__oracle_base=/u01/app/oracle#ORACLE_BASE set from environment
shqudr.__pga_aggregate_target=8589934592
shqpre.__pga_aggregate_target=8589934592
shqudr.__sga_target=53687091200
shqpre.__sga_target=53687091200
shqudr.__shared_io_pool_size=0
shqpre.__shared_io_pool_size=0
shqudr.__shared_pool_size=5234491392
shqpre.__shared_pool_size=4966055936
shqudr.__streams_pool_size=0
shqpre.__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===========新增
[oracle@hf-ahla-db-09-pre dbs]$ cat initcrmpre.ora
crmudr.__db_cache_size=47378857984
crmpre.__db_cache_size=47110422528
crmudr.__java_pool_size=939524096
crmpre.__java_pool_size=939524096
crmudr.__large_pool_size=134217728
crmpre.__large_pool_size=134217728
crmudr.__oracle_base=/u01/app/oracle#ORACLE_BASE set from environment
crmpre.__oracle_base=/u01/app/oracle#ORACLE_BASE set from environment
crmudr.__pga_aggregate_target=8589934592
crmpre.__pga_aggregate_target=8589934592
crmudr.__sga_target=53687091200
crmpre.__sga_target=53687091200
crmudr.__shared_io_pool_size=0
crmpre.__shared_io_pool_size=0
crmudr.__shared_pool_size=4966055936
crmpre.__shared_pool_size=4966055936
crmudr.__streams_pool_size=0
crmpre.__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===========新增
[oracle@hf-ahla-db-09-pre dbs]$ cat initcarpre.ora
carudr.__db_cache_size=47915728896
carpre.__db_cache_size=48184164352
carudr.__java_pool_size=134217728
carpre.__java_pool_size=134217728
carudr.__large_pool_size=268435456
carpre.__large_pool_size=134217728
carudr.__oracle_base=/u01/app/oracle#ORACLE_BASE set from environment
carpre.__oracle_base=/u01/app/oracle#ORACLE_BASE set from environment
carudr.__pga_aggregate_target=8589934592
carpre.__pga_aggregate_target=8589934592
carudr.__sga_target=53687091200
carpre.__sga_target=53687091200
carudr.__shared_io_pool_size=0
carpre.__shared_io_pool_size=0
carudr.__shared_pool_size=5100273664
carpre.__shared_pool_size=4966055936
carudr.__streams_pool_size=0
carpre.__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===========新增
crsctl start has
crsctl check has
crsctl stat resource
crsctl stat res -t
[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/grid
SUBSCRIBE_FOR_NODE_DOWN_EVENT_LISTENER_ADG = OFF
ENABLE_GLOBAL_DYNAMIC_ENDPOINT_LISTENER_ADG = ON
LISTENER =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = hf-ahla-db-09-zsc)(PORT = 1521))
)
ADR_BASE_LISTENER = /u01/app/grid
SID_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 = OFF
ENABLE_GLOBAL_DYNAMIC_ENDPOINT_LISTENER = ON
srvctl add listener -l LISTENER
srvctl add listener -l LISTENER_ADG
srvctl start listener
srvctl add asm
crsctl modify resource "ora.asm" -init -attr "AUTO_START=1"
startup pfile=init+ASM.ora
create spfile=+DATA from pfile=/u01/app/11.2.0/grid/dbs/init+ASM.ora;
srvctl modify asm -l LISTENER
srvctl modify asm -l LISTENER_ADG========新增
srvctl add service -d crmzsc -s crmzsc
srvctl add service -d shqzsc -s shqro
srvctl add service -d tbczsc -s tbcro
srvctl add service -d tjdzsc -s tjdro
srvctl add service -d carzsc -s tjdrw
srvctl add ons
crsctl stop has
crsctl start has
crsctl stat res -t
ps -ef|grep pmon
export ORACLE_SID=carzsc
srvctl add database -d crmzsc -n orcyehoo -o /u01/app/oracle/11.2.0/dbhome_1 -icrmzsc
srvctl add database -d shqzsc -n ahladb -o /u01/app/oracle/11.2.0/dbhome_1 -i shqzsc
srvctl add database -d tbczsc -n tbc -o /u01/app/oracle/11.2.0/dbhome_1 -i tbczsc
srvctl add database -d tjdzsc -n shqtj -o /u01/app/oracle/11.2.0/dbhome_1 -i tjdzsc
srvctl add database -d carzsc -n cxcddb -o /u01/app/oracle/11.2.0/dbhome_1 -i carzsc
文章版权归作者所有,未经允许请勿转载,若此文章存在违规行为,您可以联系管理员删除。
转载请注明本文地址:https://www.ucloud.cn/yun/129596.html
摘要:原文链接浏览器缓存浏览器缓存强缓存协商缓存强缓存释义客户端第一次问服务器要某个资源时,服务器丢还给客户端所请求的这个资源同时,告诉客户端将这个资源保存在本地,并且在未来的某个时点之前如果还需要这个资源,直接从本地获取就行了,不用向服务器请求 原文链接:浏览器缓存 浏览器缓存 强缓存 & 协商缓存 强缓存 释义: 客户端第一次问服务器要某个资源时,服务器丢还给客户端所请求的这个资源...
摘要:原文链接浏览器缓存浏览器缓存强缓存协商缓存强缓存释义客户端第一次问服务器要某个资源时,服务器丢还给客户端所请求的这个资源同时,告诉客户端将这个资源保存在本地,并且在未来的某个时点之前如果还需要这个资源,直接从本地获取就行了,不用向服务器请求 原文链接:浏览器缓存 浏览器缓存 强缓存 & 协商缓存 强缓存 释义: 客户端第一次问服务器要某个资源时,服务器丢还给客户端所请求的这个资源...
摘要:如果发送请求的时间在之前,那么本地缓存始终有效,否则就会发送请求到服务器来获取资源。不使用本地缓存,需要使用协商缓存。直接禁止浏览器缓存数据。 每天系统复习一个知识点 http缓存 http缓存主要分为了两类 强缓存(本地缓存)和协商缓存 浏览器在请求某一资源时,会先获取改资源缓存的header信息,判断是否命中强缓存(expires的信息和cache-control)若命中直接从缓存...
摘要:互联网通信协议协议,是一个无状态协议。具体来说,就是协议里面,四个表示操作方式的动词。版本号的版本号和客户端的版本号是毫无关系的,不要让将它们用于提交应用市场的版本号传递到服务器,而是提供类似于之类的版本号。版本号拼接在中。 为什么要用 RESTful RESTful 给我的最大感觉就是规范、易懂和优雅,一个结构清晰、易于理解的 API 完全可以省去许多无意义的沟通和文档。并且 RES...
阅读 1235·2023-01-11 13:20
阅读 1543·2023-01-11 13:20
阅读 996·2023-01-11 13:20
阅读 1651·2023-01-11 13:20
阅读 3958·2023-01-11 13:20
阅读 2456·2023-01-11 13:20
阅读 1290·2023-01-11 13:20
阅读 3454·2023-01-11 13:20