Oracle访问DM相关配置的方法

Oracle连接DM7的相关配置，可以通过odbc接口实现。具体方法如下：

1.配置odbc

在odbc 64位（其中案例Oracle和DM都是64位）系统DSN中，配置dmlink的数据源，测试通过即可。

2.配置HS

在%ORACLE_HOME%/hs/admin/路径下添加文件initDMSERVER.ora

内容：

HS_FDS_CONNECT_INFO = dmlink

HS_FDS_TRACE_LEVEL = debug

SID_LIST_LISTENER =

  (SID_LIST =

    (SID_DESC =

      (SID_NAME = CLRExtProc)

      (ORACLE_HOME = d:\app\product\11.2.0\dbhome_1)

      (PROGRAM = extproc)

      (ENVS = "EXTPROC_DLLS=ONLY:d:\app\product\11.2.0\dbhome_1\bin\oraclr11.dll")

    )

    (SID_DESC =

      (SID_NAME = DMSERVER)

      (ORACLE_HOME = D:\app\product\11.2.0\dbhome_1)

      (PROGRAM = dg4odbc)

    )

  )

LISTENER =

  (DESCRIPTION =

    (ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))

  )

ADR_BASE_LISTENER = d:\app

4.配置Oracle的tnsnames.ora

添加：

DM =

  (DESCRIPTION =

    (ADDRESS_LIST =

      (ADDRESS = (PROTOCOL = TCP)(HOST = 127.0.0.1)(PORT = 1521))

    )

    (CONNECT_DATA =

      (SERVICE_NAME = DMSERVER)

    )

    (HS=OK)

  )

登录oracle测试，

create database link dmlink connect to "SYSDBA" identified by "SYSDBA" using 'DM'; 

测试即可，

亦或是用select * from test_1@DMLINK；测试是否能查询出结果。