Configure Database Instance: Properties
we have the following architecture:
1)two unix server ("A" and "B") with a VIP that switches from one to another.
2)an instance database that is configured on VIP, and initially it works on host "A".
XXX =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = tcp)(HOST = VIP)(PORT = 1523))
(CONNECT_DATA =
(SID = XXX)
)
)
LISTENER_XXX =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = VIP)(PORT = 1523))
)
We have installed the Oracle Enterprise manager agent on each server (first "A" and then "B") and we have configurated the instance in the following manner:
Oracle home path: /u01/app/oracle/....
Monitor Username: dbsnmp
...
Listener Machine Name: VIP
Port: 1523
Database SID: XXX
All works fine (OEM see the instance up) until the VIP remains in the host "A", in wich firstable we have discovered the database (in fact the listener take the name of host and not vip).
2)an instance database that is configured on VIP, and initially it works on host "A".
XXX =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = tcp)(HOST = VIP)(PORT = 1523))
(CONNECT_DATA =
(SID = XXX)
)
)
LISTENER_XXX =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = VIP)(PORT = 1523))
)
We have installed the Oracle Enterprise manager agent on each server (first "A" and then "B") and we have configurated the instance in the following manner:
Oracle home path: /u01/app/oracle/....
Monitor Username: dbsnmp
...
Listener Machine Name: VIP
Port: 1523
Database SID: XXX
All works fine (OEM see the instance up) until the VIP remains in the host "A", in wich firstable we have discovered the database (in fact the listener take the name of host and not vip).
0