比对两个DB的参数设置

1. 在测试DB进行
2. 创建DBlink "D12和D16"

3. 用SQL比对两个DB的参数设置 (比人工比对更快更准确)

create public database link D12
connect to SYSTEM
identified by "<pwd>"
using'(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=10.9.x.x)(PORT=1521)))(CONNECT_DATA=(SID=D12R1)))';
 
create public database link D16
connect to SYSTEM
identified by "<pwd>"
using'(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=10.9.x.x)(PORT=1521)))(CONNECT_DATA=(SID=D16R1)))';
 
Select a.Name,a.Value,b.Value From v$parameter@D12 a,v$parameter@D16 b
Where a.Value <> b.Value And a.Name=b.Name ;