Wednesday 22 May 2019

oracle 12.1.0.2.0 RAC file initrac2.ora

[oracle@srv2 dbs]$ cat initrac2.ora
#SPFILE='+DATA/rac/spfilerac.ora'
*.cluster_database=true
#rac2.cluster_instances=2
*.compatible='12.1.0.2'
*.undo_management='AUTO'
*.instance_number=2
rac2.instance_name=rac2
rac1.instance_name=rac1
rac1.instance_number=1
rac2.instance_number=2
#*.db_unique_name=rac
*.db_name=rac
rac2.thread=2
rac1.thread=1
*.REMOTE_LOGIN_PASSWORDFILE=exclusive
*.DB_BLOCK_SIZE=8192
*.control_files='+DATA/rac/CONTROLFILE/Current.264.989780159'
*.db_recovery_file_dest='+FRA'
*.db_recovery_file_dest_size=4g
*.db_file_name_convert ='+DATA/RAC/DATAFILE','+DATA/RAC/DATAFILE'
*.large_pool_size = 12M
rac2.undo_tablespace='undotbs2'
rac1.undo_tablespace='undotbs1'
#*.remote_login_passwordfile='EXCLUSIVE'
*.asm_diskstring = '/dev/oracleasm/disks'
#*.asm_diskgroups = 'DATA'
#*.asm_diskgroups = 'FRA'
#*.asm_diskgroups = 'BACKUP'
#*.asm_power_limit= 1
+ASM2.instance_number=2


smrrac1.__pga_aggregate_target=503316480
smrrac2.__sga_target=1493172224
smrrac1.__sga_target=1493172224
smrrac2.__shared_io_pool_size=67108864
smrrac1.__shared_io_pool_size=67108864
smrrac2.__shared_pool_size=385875968
smrrac1.__shared_pool_size=402653184
smrrac2.__streams_pool_size=0
smrrac1.__streams_pool_size=0
*.audit_file_dest='/u01/app/oracle/admin/smrrac/adump'
*.audit_trail='db'
*.cluster_database=true
*.compatible='12.1.0.2.0'
*.control_files='+DATA/SMRRAC/CONTROLFILE/current.261.999722013','+FRA/SMRRAC/CONTROLFILE/current.256.999722013'
*.db_block_size=8192
*.db_create_file_dest='+DATA'
*.db_domain=''
*.db_name='smrrac'
*.db_recovery_file_dest='+FRA'
*.db_recovery_file_dest_size=4785m
*.diagnostic_dest='/u01/app/oracle'
*.dispatchers='(PROTOCOL=TCP) (SERVICE=smrracXDB)'
smrrac2.instance_number=2
smrrac1.instance_number=1
*.local_listener=''
smrrac1.local_listener='(ADDRESS=(PROTOCOL=TCP)(HOST=192.168.56.81)(PORT=1522))'
smrrac2.local_listener='(ADDRESS=(PROTOCOL=TCP)(HOST=192.168.56.82)(PORT=1522))'
*.log_archive_format='%t_%s_%r.dbf'
*.open_cursors=300
*.pga_aggregate_target=470m
*.processes=300
*.remote_login_passwordfile='exclusive'
*.sga_target=1410m
smrrac2.thread=2
smrrac1.thread=1
smrrac2.undo_tablespace='UNDOTBS2'
smrrac1.undo_tablespace='UNDOTBS1'

No comments:

Post a Comment