modify undo retention parametrs on OMS RAC and relocate wmprod_be to node3
上一篇 /
下一篇 2012-01-06 10:31:47
/ 个人分类:oracle
This CRQ finished now, currently everything looks good.
SQL> select inst_id,NAME,VALUE from gv$parameter where name in ('undo_retention','_highthreshold_undoretention') order by inst_id;
INST_ID NAME VALUE
---------- ------------------------------ --------------------
1 _highthreshold_undoretention 86400
1 undo_retention 10800
2 undo_retention 10800
2 _highthreshold_undoretention 86400
3 undo_retention 10800
3 _highthreshold_undoretention 86400
6 rows selected.
SQL> select tablespace_name,status, count(1) from dba_undo_extents group by tablespace_name,status order by tablespace_name;
TABLESPACE_NAME STATUS COUNT(1)
------------------------------ --------- ----------
UNDOTBS1 ACTIVE 39
UNDOTBS1 EXPIRED 50720
UNDOTBS1 UNEXPIRED 5045
UNDOTBS2 ACTIVE 63
UNDOTBS2 EXPIRED 55892
UNDOTBS2 UNEXPIRED 33973
UNDOTBS3 EXPIRED 2827
UNDOTBS3 UNEXPIRED 6742
8 rows selected.
SQL> host srvctl status service -d wmprod
Service wmprod_be is running on instance(s) wmprod3
Service wmprod_fe is running on instance(s) wmprod2
Service wmprod_app is running on instance(s) wmprod1
Service wmprod_batch is running on instance(s) wmprod1
Service wmprod_rtcc is running on instance(s) wmprod2
One more thing is on wmprod1, the tns:WMPROD was hard code to point wmprod1, after wmprod_be running on wmprod3, one db_link(CUSTOMER.HOMEWAREHOUSE) got invalid immediately, as workaround, just changed wmprod1 to wmprod3 in tnsnames.ora like below:
SQL> select host from dba_db_links where db_link='CUSTOMER.HOMEWAREHOUSE';
HOST
--------------------------------------------------------------------------------
Wmprod
wmprod =
(DESCRIPTION = (CONNECT_TIMEOUT=10)(RETRY_COUNT=3)
(ADDRESS_LIST= (LOAD_BALANCE=on)(FAILOVER=ON)
(ADDRESS = (PROTOCOL = TCP)(HOST = ndc-scan-r1)(PORT = 1521))
(ADDRESS = (PROTOCOL = TCP)(HOST = edc-scan-r1)(PORT = 1521)))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = wmprod_be.homewarehouse)
(INSTANCE_NAME = wmprod1 wmprod3)
)
)
收藏
举报
TAG: