Oracle在Debian的问题?请教.

LittlesnowLinux

我用wajig启动oracle时,

1. [color=Red]root@1[littlesnow]# wajig start oracle
   
2. Starting Oracle: /etc/profile: line 26: ulimit: open files: cannot modify limit: Operation not permitted
   
3. 
   
4. LSNRCTL for Linux: Version 10.1.0.3.0 - Production on 04-MAY-2005 00:47:30
   
5. 
   
6. Copyright (c) 1991, 2004, Oracle.  All rights reserved.
   
7. 
   
8. Message 1070 not found; No message file for product=network, facility=TNSTNS-12545: Message 12545 not found; No message file for product=network, facility=TNS
   
9. TNS-12560: Message 12560 not found; No message file for product=network, facility=TNS
   
10.   TNS-00515: Message 515 not found; No message file for product=network, facility=TNS
    
11.    Linux Error: 2: No such file or directory
    
12. /etc/profile: line 26: ulimit: open files: cannot modify limit: Operation not permitted
    
13. 
    
14. SQL*Plus: Release 10.1.0.3.0 - Production on Wed May 4 00:47:30 2005
    
15. 
    
16. Copyright (c) 1982, 2004, Oracle.  All rights reserved.
    
17. 
    
18. SQL> Connected to an idle instance.
    
19. SQL> ORACLE instance started.
    
20. 
    
21. Total System Global Area  167772160 bytes
    
22. Fixed Size                   778212 bytes
    
23. Variable Size              57679900 bytes
    
24. Database Buffers          109051904 bytes
    
25. Redo Buffers                 262144 bytes
    
26. Database mounted.
    
27. Database opened.
    
28. SQL> Disconnected from Oracle Database 10g Enterprise Edition Release 10.1.0.3.0 - Production
    
29. With the Partitioning, OLAP and Data Mining options
    
30. 
    
31. Database "oracle" warm started.
    
32. OK[/color]

复制代码

当我用sqlplus登录时:

1. [color=Red]root@1[littlesnow]# su oracle
   
2. sh-3.00$ cd /oracle/app/oracle/product/10.1.0/Db_2/bin/
   
3. sh-3.00$ ./sqlplus
   
4. 
   
5. SQL*Plus: Release 10.1.0.3.0 - Production on Wed May 4 00:49:30 2005
   
6. 
   
7. Copyright (c) 1982, 2004, Oracle.  All rights reserved.
   
8. 
   
9. Enter user-name: sys
   
10. Enter password:
    
11. ERROR:
    
12. ORA-28009: connection to sys should be as sysdba or sysoper
    
13. 
    
14. 
    
15. Enter user-name: sys
    
16. Enter password:
    
17. ERROR:
    
18. ORA-28009: connection to sys should be as sysdba or sysoper
    
19. 
    
20. 
    
21. Enter user-name: sys
    
22. Enter password:
    
23. ERROR:
    
24. ORA-28009: connection to sys should be as sysdba or sysoper
    
25. 
    
26. 
    
27. SP2-0157: unable to CONNECT to ORACLE after 3 attempts, exiting SQL*Plus[/color]

复制代码

我以为我的命令错误,但当我用浏览器时,如截图

我用wajig关闭oracle时.

1. [color=Red]root@1[littlesnow]# wajig stop oracle
   
2. Shutdown Oracle: /etc/profile: line 26: ulimit: open files: cannot modify limit: Operation not permitted
   
3. 
   
4. LSNRCTL for Linux: Version 10.1.0.3.0 - Production on 04-MAY-2005 00:54:55
   
5. 
   
6. Copyright (c) 1991, 2004, Oracle.  All rights reserved.
   
7. 
   
8. Message 1053 not found; No message file for product=network, facility=TNSTNS-12541: Message 12541 not found; No message file for product=network, facility=TNS
   
9. TNS-12560: Message 12560 not found; No message file for product=network, facility=TNS
   
10.   TNS-00511: Message 511 not found; No message file for product=network, facility=TNS
    
11.    Linux Error: 111: Connection refused
    
12. /etc/profile: line 26: ulimit: open files: cannot modify limit: Operation not permitted
    
13. 
    
14. SQL*Plus: Release 10.1.0.3.0 - Production on Wed May 4 00:54:55 2005
    
15. 
    
16. Copyright (c) 1982, 2004, Oracle.  All rights reserved.
    
17. 
    
18. SQL> Connected.
    
19. SQL> Database closed.
    
20. Database dismounted.
    
21. ORACLE instance shut down.
    
22. SQL> Disconnected from Oracle Database 10g Enterprise Edition Release 10.1.0.3.0 - Production
    
23. With the Partitioning, OLAP and Data Mining options
    
24. Database "oracle" shut down.
    
25. OK[/color]

复制代码

而我的/etc/profile,/etc/environment如下:
profile:

1. [color=RoyalBlue]# /etc/profile: system-wide .profile file for the Bourne shell (sh(1))
   
2. # and Bourne compatible shells (bash(1), ksh(1), ash(1), ...).
   
3. 
   
4. PATH="/usr/local/bin:/usr/bin:/bin:/usr/bin/X11:/usr/games:$ORACLE_HOME/bin/:$ORA_HOME/bin"
   
5. 
   
6. if [ "$PS1" ]; then
   
7.   if [ "$BASH" ]; then
   
8.     PS1='\u@\h:\w\$ '
   
9.   else
   
10.     if [ "`id -u`" -eq 0 ]; then
    
11.       PS1='# '
    
12.     else
    
13.       PS1='$ '
    
14.     fi
    
15.   fi
    
16. fi
    
17. 
    
18. export PATH
    
19. 
    
20. umask 022
    
21. if [ $USER = "oracle" ]; then
    
22.       if [ $SHELL = "/bin/ksh" ]; then
    
23.             ulimit -p 16384
    
24.             ulimit -n 65536
    
25.       else
    
26.             ulimit -u 16384 -n 65536
    
27.       fi
    
28. fi[/color]

复制代码

environment:

1. [color=Blue]LANGUAGE="zh_CN:zh"
   
2. CVSROOT=/home/cvs
   
3. LC_ALL=zh_CN
   
4. 
   
5. G_BROKEN_NAME=1
   
6. G_BROKEN_FILENAMES=1
   
7. 
   
8. ORACLE_BASE=/oracle/app/oracle
   
9. ORACLE_SID=oracle
   
10. ORACLE_HOME=/oracle/app/oracle/product/10.1.0/Db_2
    
11. ORA_HOME=/oracle/app/oracle/product/10.1.0/Db_2
    
12. export ORACLE_BASE ORACLE_SID ORACLE_HOME ORA_HOME
    
13. #unset ORACLE_HOME
    
14. unset TNS_ADMIN
    
15. 
    
16. LANG=zh_CN[/color]

复制代码

请问哪里出错了? :mad:  :mad:

blue_stone

使用 sqlplus sys/syspassword as sysdba
登陆看看
[oracle@rrac1 ~]$ sqlplus sys/oracle as sysdba

SQL*Plus: Release 10.2.0.1.0 - Production on Wed Dec 28 21:44:25 2005

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


Connected to:
Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production
With the Partitioning, Real Application Clusters, OLAP and Data Mining options

SQL>


ps下面的语句也可以不要的
             ulimit -u 16384 -n 65536

dancingpig

wajig
是什么
你这个应该是系统问题
如果是oracle错误它都有ora- 错误号的

dancingpig

Starting Oracle: /etc/profile: line 26: ulimit: open files: cannot modify limit: Operation not permitted

看26行是什么

longfei_007

你的Oracle是在linux什么发行版中安装的？Debian下能安装么？怎么安装？

blue_stone

我在debian下和redhat下安ÅÇ10g
redhat下也安ÅÇ9i
debian下的9iÙà天正在Å