gentoo安装oracle xe遇到的问题！

chengliye

$ sqlplus "/as sysdba"

SQL*Plus: Release 10.2.0.1.0 - Production on Tue Jun 14 11:27:28 2011

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

Connected to an idle instance.

SQL> startup
ORA-27078: unable to determine limit for open files
Linux Error: 1: Operation not permitted
Additional information: 1
Additional information: 1
Additional information: -1027188
SQL>

renxiao2003

权限问题。当前用户支文件的读写权限是否都有。

chengliye

果然是权限问题。
不好意思，我才学习oracle，刚开始安装好，对很多问题还不明白，谢谢！

chengliye

不好意思，再次出现这一问题。
oraclexe@ghost ~ $ sqlplus "/as sysdba"
                        
SQL*Plus: Release 10.2.0.1.0 - Production on Sat Jun 25 07:19:58 2011
                        
Copyright (c) 1982, 2005, Oracle.  All rights reserved.
                        
Connected to an idle instance.
                        
SQL> show user         
USER is "SYS"           
SQL> startup            
ORA-27078: unable to determine limit for open files
Linux Error: 1: Operation not permitted
Additional information: 1
Additional information: 1
Additional information: -2958340
SQL> startup force      
ORA-27078: unable to determine limit for open files
Linux Error: 1: Operation not permitted
Additional information: 1
Additional information: 1
Additional information: -3378372
SQL> startup            
ORA-03113: end-of-file on communication channel
SQL> exit               
Disconnected

chengliye

发现一个奇怪现象：
1、如果
@ghost:~]$ ll $ORACLE_HOME/bin/oracle -rwxr-x--x 1 oraclexe dba 74016852 Feb 20 2006 /usr/lib/oracle/xe/app/oracle/product/10.2.0/server/bin/oracle
则用户oraclexe可以正常用sqlplus启动或停止数据库。

oraclexe@ghost ~ $ sqlplus '/as sysdba'

SQL*Plus: Release 10.2.0.1.0 - Production on Wed Jun 29 10:36:32 2011

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


Connected to:
Oracle Database 10g Express Edition Release 10.2.0.1.0 - Production

SQL> startup
ORA-01081: cannot start already-running ORACLE - shut it down first
SQL> shutdown immediate;
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL> startup
ORACLE instance started.

Total System Global Area  771751936 bytes
Fixed Size                  1261252 bytes
Variable Size             201326908 bytes
Database Buffers          566231040 bytes
Redo Buffers                2932736 bytes
Database mounted.
Database opened.
SQL>

如果设置$ORACLE_HOME/bin/oracle文件的权限的S位则会出现前述错误。