注册

  HowTo:  Make Oracle database authentication connections using a Net Service Name

【相关信息】
Article ID: 42393
Software:
ArcSDE 10.1, 10.2
ArcGIS for Desktop Advanced 10.1, 10.2, 10.2.1
ArcGIS for Desktop Standard 10.1, 10.2, 10.2.1
ArcGIS for Desktop Basic 10.1, 10.2, 10.2.1
Platforms: N/A

【问题描述】
Instructions provided describe the steps to make Oracle database authentication connections using the Oracle Instant Client and a Net Service Name. See
Knowledge Base article 42269 for more information.
2015-12-03 添加评论
分享

没有找到相关结果

    已邀请:

    易智瑞技术支持

    赞同来自:

    【解决方案】
    1. Download the (32-bit) Oracle Instant Client from the ESRI Customer Care Portal, and unzip it to a location on the local ArcGIS Desktop machine. Change the name of the folder if desired. 
      EXAMPLE: C:\OracleInstantClient_32
    2. Add the Oracle Instant Client path to the beginning of the existing PATH (operating system) Environment Variable. 
      EXAMPLE: PATH=C:\OracleInstantClient_32;...
    3. Create a file called 'TNSNAMES.ORA' inside the Oracle Instant Client directory, and add an entry in the file specifying a desired Net Service Name, the Host machine name (with the local domain), and the Service Name. 
      EXAMPLE: ORCL =(DESCRIPTION =(ADDRESS = (PROTOCOL = TCP)(HOST = ORASRVR.<yourDOMAINNAME>)(PORT = 1521))(CONNECT_DATA =(SERVER = DEDICATED)(SERVICE_NAME = ORCL)))
    4. Create an Environment Variable on the Windows operating system called 'TNS_ADMIN' that references the location of the Oracle Instant Client directory. 
    5. Launch ArcCatalog and make a connection using the Net Service Name and selecting the Database Authentication option from the drop-down, and specify a username and password. 


    【其它相关参考】
    1. Make Oracle database authentication connections using EZCONNECT syntax
    2. How to make Oracle external authentication connections (OSA for Oracle) using EZCONNECT syntax
    3. How to make Oracle external authentication connections (OSA for Oracle) using a Net Service Name
    4. How to create an Oracle External Authentication user


    【创建及修改时间】
    Created: 4/4/2014

    Last Modified: 4/16/2014
    【原文链接】
    http://support.esri.com/en/kno ... 42393
    回复时间：2015-12-04 21:15:36 0 0
    分享
    为什么被折叠? 0 个回复被折叠

    要回复问题请先登录或注册


    Copyright © 2025