[二零一五1121]不大概透过powershell读取sql server质量

2019-03-30 01:53栏目:程序人生

  12:On the “Security” tab, select “Customize” under “Launch and Activation Permissions”, then click the “Edit” button.

消除措施:

7. 填写Oracle的登陆账号密码:选用项->安全性->接纳”使用此安全上下文建立连接”,并填入Oracle登录名与登陆密码

图片 1

  3:Copy the “Application ID” on the properties page.

  • 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_MACHINESYSTEMCurrentControlSetControlSecurePipeServerswinreg 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.

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

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

Ran into this issue where the linked server would work for users who were local admins on the server, but not for anyone else. After many hours of messing around, I managed to fix the problem using the following steps:

     全新服务器,需求充实属性监察和控制,发现不能透过powershell读取质量目的

  1. 布局”OraOLEDB.Oracle”属性->启用项“允许进度内”;

  2. 新建链接服务器(名称 自定 :ORA_LINK)

  3. 填写链接服务器名称->选择访问接口”Oracle Provider for OLE DB”

  4. 填写产品名称->Oracle

万一此工作已明地或暗地被肯定或终止 难点还并未缓解能够参考以下设置:

  18:Find the “OraOLEDB.Oracle” provider in SQL Server. Make sure the “Allow Inprocess” parameter is checked.

背景:

首先sqlserver 链接oracle能够通过多个访问接口:

  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 等采取,具体设置如下图。
    图片 2
  4. 上述的截图是在win8上的,如若您的系统是xp或是二〇〇三则有点变化.展开至 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) 等选项,具体设置如下图。
    图片 3
  5. 肯定后会供给重复启航Service。注:固然在背后的步骤做完后,照旧不或然消除难点,大概需求重启电脑。
  6. 认可DTC不会被你的防火墙阻止。

  19:Reboot the server.

Oracle 的 透明网关(transparent Gateway) 也得以兑现 Oracle 能够与 别的异构数据库的团结

末段找到解决方案:

  17:Click the “Advanced Permissions” button, then click “Change Permissions”. Select “Replace all child object permissions with inheritable permissions from this object”. Apply the new permissions.

 

图片 4

此时急需在“服务器对象”——>“链接服务器”——>“访问接口”下,找到OraOLEDB.Oracle选项,单击右键选择属性,然后在做客接口选项下勾选“允许进度内”(Allow inprocess)。即可化解地方难题,有时候,大概必要重新新建此链接服务器。

二 、“OraOLEDB.Oracle” 访问接口是由oracle 的Oracle Probider for OLE DB 驱动提供的。它化解了多个数据库类型不等同的的标题。而且只要急需采纳分布式事务,必须运用它来创制链接服务器。后文少禽有详细介绍。 在开立在此之前,在SQLSE大切诺基VE中华V中,链接服务器->访问接口->OraOLEDB.Oracle->右键属性,选中 "Allow inprocess" (普通话为:允许进度内) 这一步是使大家选拔的OraOLEDB.Oracle接口打开执行操作。如未设置会报如下错误: “不恐怕开始化链接服务器 "null" 的 OLE DB 访问接口 "OraOLEDB.Oracle" 的数据源对象"

If you don’t see a range above and the window looks exactly like the one above, that would mean that the DCOM port range is not configured on the machine.
You can click Add in the above window and type the range (let's say as 5000-5100) and say Ok. Make sure it looks like this. (Both the radio buttons should be selected for Internet Range)

 

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

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

版权声明:本文由ca888发布于程序人生,转载请注明出处:[二零一五1121]不大概透过powershell读取sql server质量