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:

 

评分:0

我来说两句

zhuqingna0238

zhuqingna0238

51毕业学员

我的栏目

日历

« 2024-05-03  
   1234
567891011
12131415161718
19202122232425
262728293031 

数据统计

  • 访问量: 5319
  • 日志数: 7
  • 文件数: 5
  • 建立时间: 2009-05-09
  • 更新时间: 2012-01-06

RSS订阅

Open Toolbar