处理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

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

Enter password:

Connected to:

Oracle Database10g Enterprise Edition Release 10.2.0.4.0 - Production With the Partitioning, OLAP, DataMining and Real Application Testing options

SQL

> select open_mode from v$database;
OPEN_MODE

---------
READWRITE
```

数据库的处于打开状态，现在基本上确定了是sde用户没有权限访问oracle的共享内存，问题应该出现在启动oracle实例的文件上，该文件为$ORACLE_HOME/bin/oracle，查看该文件的权限
```
[oracle@test1 ~]$ cd $ORACLE_HOME/bin
[oracle@test1 bin]$ ls -l oracle
-rwxrwxrwx 1 oracle oinstall 96789104 11-25 12:47 oracle
[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

Enter password:

Connected to:

Oracle Database10g 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.

```

再次启动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 ~]$
```

最后更新于 2019-10-21 16:27:05 并被添加「」标签，已有 3170 位童鞋阅读过。

本站使用「署名 4.0 国际」创作共享协议，可自由转载、引用，但需署名作者且注明文章出处

vps 之家

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

此处评论已关闭