:em16: 救命阿。oracle不能启动？

jnzsh

为什么安装完了oracle9.2.0(for linux)，执行sqlplus 告诉我 command not found 我装了2次了，都是这个提示啊？
在 bin下面执行也是这个错误。

ga0feng

到$ORACLE_HOME/bin下面，
然后
./sqlplus

jnzsh

执行./sqlplus
则提示：
Error 6 initializing SQL*Plus
Message file sp1<lang>;.msb not found
SP2-0750: You may need to set ORACLE_HOME to your Oracle software directory

jnzsh

我的 .bash_profile
BASH_ENV=$HOME/.bashrc
ORACLE_BASE=/usr/oracle
ORACLE_HOME=$ORACLE_BASE/product/9.2.0
ORACLE_TERM=xterm
LD_ASSUME_KERNEL=2.4.1
NLS_LANG=american_america.zhs16gbk
ORA_NLS33=$ORACLE_HOME/ocommon/nls/admin/data
LD_LIBRARY_PATH=$LD_LIBRARY_PATHORACLE_HOME/lib32ORACLE_HOME/libORACLE_HOM
E/oracm/libORACLE_HOME/bin:/usr/local/bin
CLASSPATH=$CLASSPATHORACLE_HOME/network/jlibORACLE_HOME/JREORACLE_HOME/jli
bORACLE_HOME/rdbms/jlib
THREADS_FLAG=native
DISPLAY=localhost:0.0
PATH=$PATHORACLE_HOME/bin:/usr/sbin:/sbin:/usr/ccs/bin:/usr/bin/X11:/usr/local
/binORACLE_HOME/oracm/bin:/usr/openwin

弱智

你当前的用户是oracle吗?

弱智

env | grep ORACLE 看看啊是不是有oracle用户的?

jnzsh

执行结果
LOGNAME=oracle
LOGIN=oracle
HOME=/usr/oracle
USER=oracle
PWD=/usr/oracle

弱智

env | grep ORACLE
而且, 没看到path环境变量.

jnzsh

为什么啊？我不太明白，我的.bash_profile 文件中已经设置了？
我应该怎么做？帮帮我

弱智

下面是我的oracle用户~/.bash_profile内容:

1. 
   
2. 
   
3. 
   
4. # .bash_profile
   
5. 
   
6. # Get the aliases and functions
   
7. if [ -f ~/.bashrc ]; then
   
8.         . ~/.bashrc
   
9. fi
   
10. 
    
11. # User specific environment and startup programs
    
12. PATH=$PATH:$HOME/bin
    
13. 
    
14. export PATH
    
15. unset USERNAME
    
16. 
    
17. 
    
18. 
    
19. 
    
20. # appended by Kurt Z, 20050408, for oracle9i installation.
    
21. # these lines are Oracle Environment below
    
22. 
    
23. export ORACLE_BASE=/opt/oracle
    
24. export LD_ASSUME_KERNEL=2.4.1
    
25. export DISPLAY="192.168.1.38:0.0"
    
26. export ORACLE_BASE=/opt/oracle
    
27. export ORACLE_HOME=$ORACLE_BASE/opt/oracle/product/9.2.0
    
28. export ORACLE_SID=QUANJU
    
29. export ORACLE_TERM=xterm
    
30. export NLS_LANG=AMERICAN;
    
31. export ORA_NLS33=$ORACLE_HOME/ocommon/nls/admin/data
    
32. LD_LIBRARY_PATH=$ORACLE_HOME/lib:/lib:/usr/lib:/usr/openwin/lib
    
33. LD_LIBRARY_PATH=$LD_LIBRARY_PATH:/usr/local/lib:/usr/td/lib:/usr/ucblib
    
34. export LD_LIBRARY_PATH
    
35. 
    
36. 
    
37. # Set shell search paths
    
38. PATH=/bin:/usr/bin:/usr/sbin:/etc:/opt/bin:/usr/ccs/bin:/usr/openwin/bin:opt/local/GNU/bin
    
39. PATH=$PATH:/opt/local/bin:/opt/NSCPnav/bin:$ORACLE_HOME/bin
    
40. PATH=$PATH:/usr/local/samba/bin:/usr/ucb:
    
41. export PATH=$PATH:$ORACLE_HOME/bin
    
42. 
    
43. #CLASSPATH must include the following JRE locations:
    
44. CLASSPATH=$ORACLE_HOME/JRE:$ORACDLE_HOME/jlib:$ORACLE_HOME/rdbms/jlib
    
45. CLASSPATH=$CLASSPATH:$ORACLE_HOME/network/jlib
    

复制代码