SDE For Oracle的安装问题简记

环境：

     AIX: 6.1

     ArcSDE:9.3.1+SP2

    Oracle11.2.0.1.0

症状：

    建完SDE表空间和SDE用户后，运行sdesetup安装资料库的时候，报如下错误：

ORA-01110: data file 1: '/oradata/orcl/system01.dbf'

ORA-27092: size of file exceeds file size limit of the process

Additional information: 131071

Additional information: 640001

ORA-02002: error while writing to audit trail

ORA-00604: error occurred at recursive SQL level 1

ORA-01116: error in opening database file 1

ORA-01110: data file 1: '/oradata/orcl/system01.dbf'

ORA-27092: size of file exceeds file size limit of the process

解决过程：

从提示的错误上应该是Oracle存在问题，使用sde用户登录到操作系统，运行sqlplus登录Oracle，报如下错误：

SQL*Plus: Release 11.2.0.1.0 Production on Sat Jan 15 21:35:02 2011

Copyright (c) 1982, 2009, Oracle.  All rights reserved.

Enter user-name: sde/sde

ERROR:

ORA-00604: error occurred at recursive SQL level 1

ORA-01116: error in opening database file 1

ORA-01110: data file 1: '/oradata/orcl/system01.dbf'

ORA-27092: size of file exceeds file size limit of the process

Additional information: 131071

Additional information: 640001

ORA-02002: error while writing to audit trail

ORA-00604: error occurred at recursive SQL level 1

ORA-01116: error in opening database file 1

ORA-01110: data file 1: '/oradata/orcl/system01.dbf'

ORA-27092: size of file exceeds file size limit of the process

Additional information: 131071

Additional information: 640001

SP2-0157: unable to CONNECT to ORACLE after 3 attempts, exiting SQL*Plus

报的错误和SDE报的基本一致，从字面的意思应该是sde用户生成的进程访问的文件的大小超过了设置了，但是使用Oracle用户登录操作系统，使用sqlplus是可以正常连接Oracle，因此判断可能是Oracle用户和sde用户的SHELL设置不同，分别使用ulimit -a查看相关信息：

bash-3.2$ ulimit -a

core file size          (blocks, -c) 1048575

data seg size           (kbytes, -d) 131072

file size               (blocks, -f) 1048575

max memory size         (kbytes, -m) unlimited

open files                      (-n) unlimited

pipe size            (512 bytes, -p) 64

stack size              (kbytes, -s) 32768

cpu time               (seconds, -t) unlimited

max user processes              (-u) 16384

virtual memory          (kbytes, -v) unlimited

bash-3.2$ su - oracle

oracle's Password: 

[compat]: 3004-300 You entered an invalid login name or password.

3004-501 Cannot su to "oracle" : Authentication is denied.

bash-3.2$ su - oracle

oracle's Password: 

-bash-3.2$ ulimit -a

core file size          (blocks, -c) unlimited

data seg size           (kbytes, -d) unlimited

file size               (blocks, -f) unlimited

max memory size         (kbytes, -m) unlimited

open files                      (-n) unlimited

pipe size            (512 bytes, -p) 64

stack size              (kbytes, -s) unlimited

cpu time               (seconds, -t) unlimited

max user processes              (-u) 16384

virtual memory          (kbytes, -v) unlimited

-bash-3.2$ 

果然，SDE用户的file size是受限制的，修改/etc/security/limits文件的default选项，对file size选项设置为-1，然后重新创建用户重新运行sdesetup命令后OK。