Configuracion de Red Cluster Oracle

# Red publica


172.28.28.10 ct1bosunsipep01

172.28.28.12 ct1bosunsipep02

172.28.28.14 ct1bosunsipep03

172.28.28.16 ct1bosunsipep04


172.28.28.11 ct1bosunsipep01-test1

172.28.28.22 ct1bosunsipep01-test2


#Red Backup


172.28.249.120 ct1bosunsipep01-bk

172.28.249.122 ct1bosunsipep02-bk

172.28.249.121 ct1bosunsipep01-bk-test1



# Red privada Cluster

192.168.250.33 clusternode1-priv

192.168.250.34 clusternode2-priv

192.168.250.35 clusternode3-priv

192.168.250.36 clusternode4-priv


192.168.250.9 ct1bosunsipep01-priv1



# Red VIP oracle

172.28.28.18 ct1bosunsipep01-vip

172.28.28.19 ct1bosunsipep02-vip

172.28.28.20 ct1bosunsipep03-vip

172.28.28.21 ct1bosunsipep04-vip



# Servidor de Backup



# 172.28.250.94 bksrv01







# 172.28.250.205 dboracle



# 172.28.250.207 dboraclenew



# 172.28.255.132 sunmc01







172.28.250.21 mserver01



172.28.250.20 mserver02



172.28.250.97 mserver03







# SERVIDOR TIVOLI MONITORY



10.201.2.130 srvtivcc01



bash-3.00$







LISTENER.ORA







# listener.ora.ct1bosunsipep01 Network Configuration File: /app/oracle/dbs/10.2.0.3/network/admin/listener.ora.ct1bosunsipep01



# Generated by Oracle configuration tools.







LISTENER_CT1BOSUNSIPEP01 =


(DESCRIPTION_LIST =


(DESCRIPTION =


(ADDRESS = (PROTOCOL = TCP)(HOST = ct1bosunsipep01-vip)(PORT = 1521)(IP = FIRST))



(ADDRESS = (PROTOCOL = TCP)(HOST = 172.28.28.10)(PORT = 1521)(IP = FIRST))


)



)







SID_LIST_LISTENER_CT1BOSUNSIPEP01 =



(SID_LIST =



(SID_DESC =



(SID_NAME = PLSExtProc)



(ORACLE_HOME = /app/oracle/dbs/10.2.0.3)



(PROGRAM = extproc)



)



(SID_DESC =



(SID_NAME = sirspe1)



(ORACLE_HOME = /app/oracle/dbs/10.2.0.3)



(GLOBAL_DBNAME = sirspe)



)



)











MAQUINA 2







# listener.ora.ct1bosunsipep02 Network Configuration File: /app/oracle/dbs/10.2.0.3/network/admin/listener.ora.ct1bosunsipep02



# Generated by Oracle configuration tools.







LISTENER_CT1BOSUNSIPEP02 =



(DESCRIPTION_LIST =



(DESCRIPTION =



(ADDRESS = (PROTOCOL = TCP)(HOST = ct1bosunsipep02-vip)(PORT = 1521)(IP = FIRST))



(ADDRESS = (PROTOCOL = TCP)(HOST = 172.28.28.12)(PORT = 1521)(IP = FIRST))



)



)







SID_LIST_LISTENER_CT1BOSUNSIPEP02 =



(SID_LIST =



(SID_DESC =



(SID_NAME = PLSExtProc)



(ORACLE_HOME = /app/oracle/dbs/10.2.0.3)



(PROGRAM = extproc)



)



(SID_DESC =



(SID_NAME = sirspe2)



(ORACLE_HOME = /app/oracle/dbs/10.2.0.3)



(GLOBAL_DBNAME = sirspe)



)



)







TNSNAMES.ORA




LISTENERS_SIRSPE =



(ADDRESS_LIST =



(ADDRESS = (PROTOCOL = TCP)(HOST = 172.28.28.18)(PORT = 1521))



(ADDRESS = (PROTOCOL = TCP)(HOST = 172.28.28.19)(PORT = 1521))


(ADDRESS = (PROTOCOL = TCP)(HOST = ct1bosunsipep03-vip)(PORT = 1521))



(ADDRESS = (PROTOCOL = TCP)(HOST = ct1bosunsipep04-vip)(PORT = 1521))


)




SIRSPE4 =

(DESCRIPTION =

(ADDRESS = (PROTOCOL = TCP)(HOST = ct1bosunsipep04-vip)(PORT = 1521))

(CONNECT_DATA =

(SERVER = DEDICATED)

(SERVICE_NAME = sirspe)

(INSTANCE_NAME = sirspe4)

)



)



SIRSPE3 =


(DESCRIPTION =


(ADDRESS = (PROTOCOL = TCP)(HOST = ct1bosunsipep03-vip)(PORT = 1521))


(CONNECT_DATA =


(SERVER = DEDICATED)


(SERVICE_NAME = sirspe)



(INSTANCE_NAME = sirspe3)



)



)







SIRSPE2 =


(DESCRIPTION =

(ADDRESS = (PROTOCOL = TCP)(HOST = 172.28.28.19)(PORT = 1521))

(CONNECT_DATA =

(SERVER = DEDICATED)

(SERVICE_NAME = sirspe)

(INSTANCE_NAME = sirspe2)



)



)







SIRSPE1 =


(DESCRIPTION =


(ADDRESS = (PROTOCOL = TCP)(HOST = 172.28.28.18)(PORT = 1521))


(CONNECT_DATA =


(SERVER = DEDICATED)


(SERVICE_NAME = sirspe)

(INSTANCE_NAME = sirspe1)

)



)



SIRSPE_SRV =


(DESCRIPTION =


(ADDRESS = (PROTOCOL = TCP)(HOST = 172.28.28.18)(PORT = 1521))

(ADDRESS = (PROTOCOL = TCP)(HOST = 172.28.28.19)(PORT = 1521))


(ADDRESS = (PROTOCOL = TCP)(HOST = 172.28.28.20)(PORT = 1521))

(ADDRESS = (PROTOCOL = TCP)(HOST = 172.28.28.21)(PORT = 1521))


(LOAD_BALANCE = yes)


(CONNECT_DATA =

(SERVER = DEDICATED)

(SERVICE_NAME = sirspe_srv)

(FAILOVER_MODE =

(TYPE = SELECT)

(METHOD = BASIC)

(RETRIES = 180)

(DELAY = 5)

)



)



)


SIRSPE =

(DESCRIPTION =

(ADDRESS = (PROTOCOL = TCP)(HOST = 172.28.28.18)(PORT = 1521))

(ADDRESS = (PROTOCOL = TCP)(HOST = 172.28.28.19)(PORT = 1521))

(ADDRESS = (PROTOCOL = TCP)(HOST = ct1bosunsipep03-vip)(PORT = 1521))

(ADDRESS = (PROTOCOL = TCP)(HOST = ct1bosunsipep04-vip)(PORT = 1521))

(LOAD_BALANCE = yes)



(CONNECT_DATA =



(SERVER = DEDICATED)



(SERVICE_NAME = sirspe)



)



)







LISTENERS_CT1BOSUNSIPEP02 =



(ADDRESS_LIST =



(ADDRESS = (PROTOCOL = TCP)(HOST = 172.28.28.19)(PORT = 1521))



)







CAT10G =



(DESCRIPTION =



(ADDRESS = (PROTOCOL = TCP)(HOST = dboraclenew)(PORT = 1528))



(CONNECT_DATA =



(SERVER = DEDICATED)



(SERVICE_NAME = cat10g)



)



)