惯性聚合 高效追踪和阅读你感兴趣的博客、新闻、科技资讯
阅读原文 在惯性聚合中打开

推荐订阅源

钛媒体:引领未来商业与生活新知
钛媒体:引领未来商业与生活新知
酷 壳 – CoolShell
酷 壳 – CoolShell
博客园_首页
Engineering at Meta
Engineering at Meta
量子位
A
About on SuperTechFans
阮一峰的网络日志
阮一峰的网络日志
Recent Announcements
Recent Announcements
博客园 - 司徒正美
V
Visual Studio Blog
H
Hackread – Cybersecurity News, Data Breaches, AI and More
The GitHub Blog
The GitHub Blog
freeCodeCamp Programming Tutorials: Python, JavaScript, Git & More
F
Fortinet All Blogs
Martin Fowler
Martin Fowler
腾讯CDC
Jina AI
Jina AI
C
Check Point Blog
H
Help Net Security
罗磊的独立博客
OSCHINA 社区最新新闻
OSCHINA 社区最新新闻
V
V2EX
爱范儿
爱范儿
I
InfoQ

博客园 - flyingfish

ORACLE 监听日志文件太大停止写监听日志引起数据库连接不上问题 PostgreSQL Crosstab Query (交叉表)试用随记 基于陕西省地理信息公共服务平台的2011西安世园会电子地图正式发布 Toad Connecting: "cannot load OCI DLL: C:\oracle\product\10.2.0\db_2\BIN\oci.dll" - flyingfish 【转】Javascript 获取链接(url)参数的方法 [转]VisualStudio LightSwitch 7大顶级功能 [转]Silverlight 之轻 有关敏捷软件测试的文章 [转]SSL应用系列之三:去掉讨厌的证书提示警告(多图精解) 【转】Skyline软件介绍 【转】TB(TerraBuilder)转换日志:解决影像数据坐标转换后,在Skyline平台不能显示的问题 如何知道ORACLE表最后被修改,访问的时间 【转】如何成功实施结对编程 【转】结对编程及其优势 诚聘Silverlight、WCF程序员(或实习生) [转]VS2008在64位Windows平台上编译ArcEngine导致HRESULT:0x80040154 (REGDB_E_CLASSNOTREG)错误的解决办法 Web系统突然爆”Asp.net ajax客户端框架未能加载“的一种可能原因(误改服务器系统时间) 再读《没有银弹》 [转]华为总裁任正非谈企业管理:正确的方向来自于妥协
ArcSDE启动遇到ORA-12560: TNS: 协议适配器错误解决办法
flyingfish · 2011-02-24 · via 博客园 - flyingfish

2011-02-24 15:05  flyingfish  阅读(4580)  评论()    收藏  举报

ArcSDE启动遇到ORA-12560: TNS: 协议适配器错误解决办法

http://forums.esri.com/Thread.asp?c=158&f=2285&t=243013

Installation of ArcSDE 9.2 on 64 bit Oracle 10gR2 
Author Dejan Krstevski 
Date Jan 08, 2008 
Message

I have problem starting ArcSDE service on the following configuration:

Operating System: Windows 2003 64bit R2
Database: Oracle 10gR2 10.0.2.0.3 64bit and 32bit client on the same machine.
Patches for Oracle 5500954, 5337014(upgrade to 10.0.2.0.3)
Oracle SID: sdedb
Oracle 32bit Net service name: sdecl
Installed ArcSDE;
Post instalation completed;
Direct connect is working;
Cannot start ArcSDE service, with following error:

Please check event log or error log files.
Error starting esri_sde service(0)
Could not start ArcSDE -- Check Network, $SDEHOME disk, DBMS settings and dbinit
.sde.

Event viewer:

The description for Event ID ( 110 ) in Source ( esri_sde ) cannot be found. The local computer may not have the necessary registry information or message DLL files to display messages from a remote computer. You may be able to use the /AUXSOURCE= flag to retrieve this description; see Help and Support for details. The following information is part of the event: esri_sde, Connection to RDBMS failed.

sde_esri_sde.log

-------------------------------------------------------
ArcSDE 9.2 for Oracle10g Build 1206 Fri Oct 19 08:31:29 2007
-------------------------------------------------------
DB_open_instance()::db_connect (OCI8) error: 12560
init_DB DB_instance_open_as_dba: -51
DBMS error code: 12560
ORA-12560: TNS:protocol adapter error

giomgr_esri_sde.log

Tue Jan 08 14:41:09 2008 - ****** Spatial Database I/O Manager ******
Tue Jan 08 14:41:09 2008 - SDE System Startup Initiated . . .
Tue Jan 08 14:41:09 2008 - Validated System Paths.
Tue Jan 08 14:41:09 2008 - SDE IOMGR going into background . . .

PATH = C:\oracle\product\10.2.0\client_1\bin;C:\oracle\product\10.2.0\db_1\bin;

So Dirrect Connect is working without any problems, but I cannot start the ArcSDE Service. ANY Ideas?

Thank You!!! 

解决办法如下,关键是32-bit Oracle Client端安装情况下要更改dbinit.sde中的Oracle_SID为Local,并且不要在再用Post Install来启动服务。因为PostInstall又会把dbinit.sde改回去:

Re: Installation of ArcSDE 9.2 on 64 bit Oracle 10gR2 
Author Dejan Krstevski 
Date Jan 25, 2008 
Message Yes, actually all it was needed was to set LOCAL variable to 32 bit client on server, instead of ORACLE_SID variable in dbinit.sde.