处理SDE服务无法启动案例简记

环境: OS: Redhat 4.0 AS DBMS:oracle10.2.0.4.0 ArcSDE9.3 for oracle 10g 启动错误提示如下: 在sde用户下：
------------------------------------------------------- ArcSDE 9.3 for

Oracle10g Build 508 Thu Apr 17 12:23:18 2008 -------------------------------------------------------

DB_open_instance()::db_connect (OCI8) error:

1034 init_DB DB_instance_open_as_dba: -51

DBMS error code: 1034 ORA-01034: ORACLE not available

ORA-27123: unable to attach to shared memory segment Linux Error: 13: Permission denied

Could not start ArcSDE -- Check Network, $SDEHOME disk, DBMS settings and dbinit.sde.

使用sqlplus连接，出现如下错误，和启动sde服务错误一致
[sde@test1 ~]$ sqlplus sde/sde

SQL

*Plus: Release 10.2.0.4.0 - Production on

Mon Jan 18 17:27:41 2010

Copyright (c) 1982, 2007, Oracle. All

Rights Reserved.

ERROR:

ORA-01034: ORACLE not

available

ORA-27123: unable to

attach to

shared memory segment

Linux Error: 13: Permission denied

查看oracle的共享内存： [sde@test1 ~]$ ipcs -m ------ Shared Memory Segments -------- key shmid owner perms bytes nattch status 0xccc7f63c 360449 oracle 640 1260388352 19 共享内存已经开辟出来，然后切换到oracle用户下：
[oracle@test1 ~]$ sqlplus sys as

sysdba

SQL

*Plus: Release 10.2.0.4.0 - Production on

Mon Jan 18 17:21:46 2010

Copyright (c) 1982, 2007, Oracle. All

Rights Reserved.

Enter password:

Connected to

:

Oracle Database

10g Enterprise Edition Release 10.2.0.4.0 - Production

With

the Partitioning, OLAP, Data

Mining and

Real

Application Testing options

SQL

> select

open_mode from

v$database

;

OPEN_MODE

----------



READ

WRITE



数据库的处于打开状态，现在基本上确定了是sde用户没有权限访问oracle的共享内存，问题应该出现在启动oracle实例的文件上，该文件为$ORACLE_HOME/bin/oracle，查看该文件的权限
1:

[oracle@test1 ~]$ cd $ORACLE_HOME/bin
2:

[oracle@test1 bin]$ ls -l oracle
3:

-rwxrwxrwx 1 oracle oinstall 96789104 11-25 12:47 oracle
4:

[oracle@test1 bin]$

文件的权限为777，缺少s权限,把s权限赋给oracle文件 chmod a+s oracle 重启oracle实例:
[oracle@test1 bin]$ sqlplus sys as

sysdba

SQL

*Plus: Release 10.2.0.4.0 - Production on

Mon Jan 18 17:25:07 2010

Copyright (c) 1982, 2007, Oracle. All

Rights Reserved.

Enter password:

Connected to

:

Oracle Database

10g Enterprise Edition Release 10.2.0.4.0 - Production

With

the Partitioning, OLAP, Data

Mining and

Real

Application Testing options

SQL

> shutdown

immediate

;

Database

closed.

Database

dismounted.

ORACLE instance shut down.

SQL

> startup

ORACLE instance started.

Total System Global

Area 1258291200 bytes

Fixed Size

1267236 bytes

Variable

Size

318769628 bytes

Database

Buffers 922746880 bytes

Redo Buffers 15507456 bytes

Database

mounted.

Database

opened.

SQL

>

再次启动sde服务，成功
[sde@test1 ~]$ sdemon -o start

-p sde

-------------------------------------------------------



ArcSDE 9.3 for

Oracle10g Build 508 Thu Apr 17 12:23:18 2008

-------------------------------------------------------



ST_Geometry Schema

Owner: (SDE) Type Release: 1007

Instance initialized for

((sde)) . . .

Connected to

instance . . .

DBMS Connection

established...

RDBMS: "Oracle"

Instance Name: "esri_sde"

IOMGR Process ID (PID): 19128

ArcSDE Instance esri_sde started Mon Jan 18 17:26:04 2010

[sde@test1 ~]$

文章来源：http://blog.csdn.net/liufeng1980423/article/details/6074530