Primary Site:
Parameter
File:
*.audit_file_dest='/u01/app/oracle/admin/usa/adump'
*.audit_trail='db'
*.cluster_database=true
*.compatible='11.2.0.0.0'
*.control_files='+DATA/usa/controlfile/current.266.762305293','+FRA/usa/controlfile/current.263.762305307'
*.db_block_size=8192
*.db_create_file_dest='+DATA'
*.db_create_online_log_dest_1='+DATA'
*.db_create_online_log_dest_2='+FRA'
*.db_domain='hingu.net'
*.db_file_name_convert='INDIA','USA'
*.db_name='bhavin'
*.db_recovery_file_dest='+FRA'
*.db_recovery_file_dest_size=1099511627776
*.db_unique_name='usa'
*.diagnostic_dest='/u01/app/oracle'
*.dispatchers='(PROTOCOL=TCP)
(SERVICE=bhavinXDB)'
*.fal_server='INDIA'
bhavin3.instance_number=3
bhavin1.instance_number=1
bhavin2.instance_number=2
bhavin1.local_listener='LISTENER_BHAVIN1'
bhavin2.local_listener='LISTENER_BHAVIN2'
bhavin3.local_listener='LISTENER_BHAVIN3'
*.log_archive_config='DG_CONFIG=(USA,INDIA)'
*.log_archive_dest_1='LOCATION=USE_DB_RECOVERY_FILE_DEST
VALID_FOR=(ALL_LOGFILES,ALL_ROLES) DB_UNIQUE_NAME=USA'
*.log_archive_dest_2='SERVICE=INDIA
SYNC NOAFFIRM VALID_FOR=(ONLINE_LOGFILES,
PRIMARY_ROLE) DB_UNIQUE_NAME=INDIA'
*.log_archive_dest_state_2='enable'
*.log_archive_dest_state_3='ENABLE'
*.log_archive_format='%t_%s_%r.arc'
*.log_archive_max_processes=8
*.log_file_name_convert='INDIA','USA'
*.memory_target=1484783616
*.open_cursors=300
*.processes=1024
*.remote_listener='lab-scan.hingu.net:1525'
*.remote_login_passwordfile='exclusive'
*.service_names='OLTP','OLTP.hingu.net','USA','USA.hingu.net'
*.sessions=1131
*.standby_file_management='AUTO'
bhavin3.thread=3
bhavin2.thread=2
bhavin1.thread=1
bhavin1.undo_tablespace='UNDOTBS1'
bhavin2.undo_tablespace='UNDOTBS2'
bhavin3.undo_tablespace='UNDOTBS3'
tnsnames.ora
(same on all the primary nodes)
# tnsnames.ora
Network Configuration File: /u01/app/oracle/db11201/network/admin/tnsnames.ora
# Generated
by Oracle configuration tools.
USA =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = lab-scan.hingu.net)(PORT = 1525))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = usa.hingu.net)
)
)
LISTENER_BHAVIN1=(DESCRIPTION =(ADDRESS = (PROTOCOL = TCP)(HOST =
node1-vip.hingu.net)(PORT = 1530)))
LISTENER_BHAVIN2=(DESCRIPTION =(ADDRESS = (PROTOCOL = TCP)(HOST =
node2-vip.hingu.net)(PORT = 1530)))
LISTENER_BHAVIN3=(DESCRIPTION =(ADDRESS = (PROTOCOL = TCP)(HOST =
node3-vip.hingu.net)(PORT = 1530)))
OLTP =
(DESCRIPTION =
(LOAD_BALANCE=on)
(FAILOVER=on)
(ADDRESS = (PROTOCOL = TCP)(HOST = lab-scan.hingu.net)(PORT = 1525))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = oltp.hingu.net)
(FAILOVER_MODE=
(TYPE=select)
(METHOD=basic)
)
)
)
USA1 =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = node1-vip.hingu.net)(PORT = 1530))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = usa.hingu.net)
(SID = bhavin1)
)
)
USA2 =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = node2-vip.hingu.net)(PORT = 1530))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = usa.hingu.net)
(SID = bhavin2)
)
)
USA3 =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = node3-vip.hingu.net)(PORT = 1530))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = usa.hingu.net)
(SID = bhavin3)
)
)
INDIA =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = dr-lab-scan.hingu.net)(PORT = 1525))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = india.hingu.net)
)
)
INDIA1 =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = dr-node1-vip.hingu.net)(PORT = 1530))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = india.hingu.net)
(SID = bhavin1)
)
)
INDIA2 =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = dr-node2-vip.hingu.net)(PORT = 1530))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = india.hingu.net)
(SID = bhavin2)
)
)
Listener.ora
(same on all the nodes):
BHAVIN_LISTENER=(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=IPC)(KEY=BHAVIN_LISTENER)))) #
line added by Agent
ENABLE_GLOBAL_DYNAMIC_ENDPOINT_BHAVIN_LISTENER=ON # line added by Agent
Standby Site:
parameter File:
*.audit_file_dest='/u01/app/oracle/admin/india/adump'
*.audit_trail='db'
*.cluster_database=true
*.compatible='11.2.0.0.0'
*.control_files='+DATA/india/controlfile/control01.ctl','+FRA/india/controlfile/control02.ctl'
*.db_block_size=8192
*.db_create_file_dest='+DATA'
*.db_create_online_log_dest_1='+DATA'
*.db_create_online_log_dest_2='+FRA'
*.db_domain='hingu.net'
*.db_file_name_convert='USA','INDIA'
*.db_name='bhavin'
*.db_recovery_file_dest='+FRA'
*.db_recovery_file_dest_size=4039114752
*.db_unique_name='india'
*.diagnostic_dest='/u01/app/oracle'
*.dispatchers='(PROTOCOL=TCP)
(SERVICE=bhavinXDB)'
*.fal_server='USA'
bhavin1.instance_number=1
bhavin2.instance_number=2
bhavin1.local_listener='LISTENER_BHAVIN1'
bhavin2.local_listener='LISTENER_BHAVIN2'
*.log_archive_config='DG_CONFIG=(USA,INDIA)'
*.log_archive_dest_1='LOCATION=USE_DB_RECOVERY_FILE_DEST
VALID_FOR=(ALL_LOGFILES,ALL_ROLES)
DB_UNIQUE_NAME=INDIA'
*.log_archive_dest_2='SERVICE=USA
SYNC NOAFFIRM VALID_FOR=(ONLINE_LOGFILES,PRIMARY_ROLE)
DB_UNIQUE_NAME=USA'
*.log_archive_dest_state_3='ENABLE'
*.log_archive_format='%t_%s_%r.arc'
*.log_archive_max_processes=8
*.log_file_name_convert='USA','INDIA'
*.memory_target=1484783616
*.open_cursors=300
*.processes=1024
*.remote_listener='dr-lab-scan.hingu.net:1525'
*.remote_login_passwordfile='exclusive'
*.service_names='INDIA','india.hingu.net'
*.sessions=1131
*.standby_file_management='AUTO'
bhavin2.thread=2
bhavin1.thread=1
bhavin1.undo_tablespace='UNDOTBS1'
bhavin2.undo_tablespace='UNDOTBS2'
tnsnames.ora
(same on all the standby nodes)
# tnsnames.ora
Network Configuration File: /u01/app/oracle/db11201/network/admin/tnsnames.ora
# Generated
by Oracle configuration tools.
USA =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = lab-scan.hingu.net)(PORT = 1525))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = usa.hingu.net)
)
)
LISTENER_BHAVIN2 =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = dr-node2-vip.hingu.net)(PORT = 1530))
)
LISTENER_BHAVIN1 =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = dr-node1-vip.hingu.net)(PORT = 1530))
)
USA3 =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = node3-vip.hingu.net)(PORT = 1530))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = usa.hingu.net)
(SID = bhavin3)
)
)
USA2 =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = node2-vip.hingu.net)(PORT = 1530))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = usa.hingu.net)
(SID = bhavin2)
)
)
USA1 =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = node1-vip.hingu.net)(PORT = 1530))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = usa.hingu.net)
(SID = bhavin1)
)
)
OLTP =
(DESCRIPTION =
(LOAD_BALANCE = on)
(FAILOVER = on)
(ADDRESS = (PROTOCOL = TCP)(HOST = lab-scan.hingu.net)(PORT = 1525))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = oltp.hingu.net)
(FAILOVER_MODE =
(TYPE = select)
(METHOD = basic)
)
)
)
INDIA =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = dr-lab-scan.hingu.net)(PORT = 1525))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = india.hingu.net)
)
)
INDIA1 =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = dr-node1-vip.hingu.net)(PORT = 1530))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = india.hingu.net)
(SID = bhavin1)
)
)
INDIA2 =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = dr-node2-vip.hingu.net)(PORT = 1530))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = india.hingu.net)
(SID = bhavin2)
)
)
Listener.ora
(same on all the nodes):
BHAVIN_LISTENER=(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=IPC)(KEY=BHAVIN_LISTENER)))) #
line added by Agent
ENABLE_GLOBAL_DYNAMIC_ENDPOINT_BHAVIN_LISTENER=ON # line added by Agent