Notes on Arc SDE 安装

最新推荐文章于 2025-09-11 20:53:34 发布

weixin_30737363

最新推荐文章于 2025-09-11 20:53:34 发布

阅读量62

点赞数

CC 4.0 BY-SA版权

文章标签：数据库网络

原文链接：http://www.cnblogs.com/henyihanwobushi/archive/2013/01/30/2883754.html

本文详细介绍了在安装配置Oracle数据库过程中，如何编辑listener.ora和sqlnet.ora文件以确保数据库服务正常运行。同时强调了正确设置SID对于连接数据库的重要性。

1.When you post install an Arc SDE with an Oracle DataBase, you should not leave anything that may watch the regiditer and the service on, then there will be no such many problems.

2.You need to edit the configure files under the "X:\app\XXX\product\11.2.0\dbhome_1\NETWORK\ADMIN" path:

　　1) edit the listener.ora file:

# listener.ora Network Configuration File: D:\app\zhangjb\product\11.2.0\dbhome_1\network\admin\listener.ora
# Generated by Oracle configuration tools.

SID_LIST_LISTENER =
  (SID_LIST =
    (SID_DESC =
      (SID_NAME = CLRExtProc)
      (ORACLE_HOME = D:\app\zhangjb\product\11.2.0\dbhome_1)
      (PROGRAM = extproc)
      (ENVS = "EXTPROC_DLLS=ONLY:D:\app\zhangjb\product\11.2.0\dbhome_1\bin\oraclr11.dll")
    )
  )

LISTENER =
  (DESCRIPTION_LIST =
    (DESCRIPTION =
      (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
      (ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))
    )
  )

ADR_BASE_LISTENER = D:\app\zhangjb

　　to this:

# listener.ora Network Configuration File: D:\app\zhangjb\product\11.2.0\dbhome_1\network\admin\listener.ora
# Generated by Oracle configuration tools.

SID_LIST_LISTENER =
  (SID_LIST =
    (SID_DESC =
      (SID_NAME = CLRExtProc)
      (ORACLE_HOME = D:\app\zhangjb\product\11.2.0\dbhome_1)
      (PROGRAM = extproc)
      (ENVS = "EXTPROC_DLLS=ONLY:D:\app\zhangjb\product\11.2.0\dbhome_1\bin\oraclr11.dll")
    )
   (SID_DESC =
    (GLOBAL_DBNAME = ORCL)
    (ORACLE_HOME = E:\Oracle10g)
    (SID_NAME = ORCL)
    )
  )

LISTENER =
  (DESCRIPTION_LIST =
    (DESCRIPTION =
      (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
      (ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))
    )
  )

ADR_BASE_LISTENER = D:\app\zhangjb

　　2) Edit the sqlnet.ora to this:

# sqlnet.ora Network Configuration File: D:\app\zhangjb\product\11.2.0\dbhome_1\network\admin\sqlnet.ora
# Generated by Oracle configuration tools.

# This file is actually generated by netca. But if customers choose to 
# install "Software Only", this file wont exist and without the native 
# authentication, they will not be able to connect to the database on NT.

SQLNET.AUTHENTICATION_SERVICES= (NONE)

NAMES.DIRECTORY_PATH= (TNSNAMES, EZCONNECT)

　　3) The server name on the configfile with which you use to log on the database is your the SID of you DATABASE, not the name of your machine.

转载于:https://www.cnblogs.com/henyihanwobushi/archive/2013/01/30/2883754.html