解决方法,链接服务器

可能需要重新新建此链接服务器,链接服务器,解决方法,链接服务器””的 OLE DB 访问接口 “MSDAORA” 返回了消息 “发生了一个 Oracle,链接服务器””的 OLE DB 访问接口,在开发阶段是在一台计算机上运行只要是启动分布式服务就没什么问题,里面用到了分布式事务,&gt,.

图片 2

  10:Run “dcomconfig”. Navigate to
“Component Services -> Computers -> My Computer -> DCOM
Config”.

     全新服务器,需要增加性能监控,发现无法通过powershell读取性能指标

SELECT *
FROM OPENQUERY(ORA_LINK,’SELECT * FROM
USERNAME.TABLE’);

最近再用SSIS做数据归档,里面用到了分布式事务。在开发阶段是在一台计算机上运行只要是启动分布式服务就没什么问题,可是昨天把它部署到uat的时候遇到问题,错误信息是:

(3) Click on Add a Site Group to
add a new group.

 

解决方法:

2、“OraOLEDB.Oracle” 访问接口是由oracle 的Oracle Probider for OLE DB
驱动提供的。它解决了两个数据库类型不一致的的问题。而且如果需要使用分布式事务,必须使用它来创建链接服务器。后文会有详细介绍。 在创建之前,在SQLSERVER中,链接服务器->访问接口->OraOLEDB.Oracle->右键属性,选中
“Allow inprocess”
(中文为:允许进程内) 这一步是使我们选择的OraOLEDB.Oracle接口打开执行操作。如未设置会报如下错误: “无法初始化链接服务器
“null” 的 OLE DB 访问接口 “OraOLEDB.Oracle” 的数据源对象”

1.还发现一个问题,数据库也需要开启分布式事务的支持:右键“服务器连接”的属性,在打开的属性窗口选择“连接”,在窗口右侧,勾选“需要将分布式事务用于服务器到服务器的通信”,确定即可。

1. Managing Site Security with Site
Groups

  7:Add the local administrators group
to the permissions, grant them full control.

  • Open the Registry Editor by going to the Start Menu and selecting
    Run…, then type “regedit”, and click the OK button.
  • Navigate to the
    HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Control\SecurePipeServers\winreg registry
    key.
  • Right click on the “winreg” key and select Permissions. Add users or
    groups to which you want to grant Read access.
  • Exit Registry Editor and restart Windows.

服务器 windows server 2008 r2 64位  或 win 7 enterprise 64位

To get rid of this error just follow these steps to configure the
registry key and REBOOT the machine.

In some situation, those default
groups can’t meet your requirements to restrict access control. So
custom site groups can be created with rights selected by the creator
the group. Please follow the following steps to create a custom site
group.

  16:Edit the security properties of
the Oracle root directory. Add “Authenticated Users” and grant them
“Read & Execute”, “List folder contents” and “Read” permissions. Apply
the new permissions.

背景:

安装:Windows Server2008 R2下安装Oracle
10g

  1. 确认”Distribute Transaction
    Coordinator”服务在Server和本地都是运行状态。(如失败可以 输入:msdtc
    -resetlog (注意运行此命令时,不要执行挂起的事务)
  2. 在Server上打开 Component Services。 Control Panel –> System and
    Security –> Administrative Tools –> Component Services.
  3. 展开至 Component Services –> Computers –> My Computer –>
    Distributed Transaction Coordinator –> Local DTC,
    右键,选择Properties。在弹出的Dialog中选择Tab “Security”,
    勾选Network DTC Access 等选项,具体设置如下图。
    图片 1
  4. 以上的截图是在win8上的,如果你的系统是xp或是2003则有些变化.展开至
    Component Services –> Computers –> My Computer
    右键,选择Properties。在弹出的Dialog中选择Tab “MSDTC”–>Security
    Configuration, 勾选”Network DTC Access”, “Allow Remote Client”,
    “Allow Inbound/Outbound”, “Enable TIP” (Some option may not
    benecessary, have a try to get your configuration)
    等选项,具体设置如下图。
    图片 2
  5. 确认后会要求重新启动Service。注:如果在后面的步骤做完后,还是无法解决问题,可能需要重启电脑。
  6. 确认DTC不会被你的防火墙阻止。

 

  13:Add “Authenticated Users” and
grant them all 4 launch and activation permissions.

Oracle 的 透明网关(transparent Gateway)
也可以实现 Oracle 可以与 其它异构数据库的互联

是因为防火墙禁止了icmp数据包.
具体查看:
开始-控制面板-防火墙-高级-ICMP-设置.允许了就可以ping通了

Security is used in multiple ways in
SharePoint. This article provides an overview of the security features
that can be used when managing access to documents and libraries, which
is also a supplementary to my previous posting, <<SPS中Shared
Documents的访问权限管理>> .

  6:Right click the “{???}” folder and
select “Permissions”

  1. 服务器上需要安装Oracle
    64位的客户端(
  1. On the Edit menu, point to New, and then click Key.

    Note If the RPC registry key already exists, go to step

  2. Type RPC, and then press ENTER.
  3. Click RPC.
  4. On the Edit menu, point to New, and then click DWORD
    Value.
  5. Type RestrictRemoteClients, and then press ENTER.

  6. Click RestrictRemoteClients.

  7. On the Edit menu, click Modify.
  8. In the Value data box, type 0, and then click OK.

    Note To enable the RestrictRemoteClients setting,
    type1.

  9. Close Registry Editor and restart the computer.

Figure
1: Add a custom site group

 

6.
数据源填写Oracle客户端/服务端配置的连接地址的服务名(tnsnames.ora中的服务名)

  1. Click Start, click Run, type Regedit, and then click
    OK.
  2. Locate and then click the following registry key:

On that page, you can click on Add
Users to add a new user. On the next page, click on Advanced permissions
to switch to advanced permissions view, where you can control more fine
granularity.