MERCADOS FINANCIEROS

Mostrando entradas con la etiqueta Configuracion de Red Cluster Oracle. Mostrar todas las entradas
Mostrando entradas con la etiqueta Configuracion de Red Cluster Oracle. Mostrar todas las entradas

lunes, 11 de julio de 2016

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)



)



)