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
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。
阅读更多
想对作者说点什么? 我来说一句

没有更多推荐了,返回首页

加入CSDN,享受更精准的内容推荐,与500万程序员共同成长!
关闭
关闭