大家好！请教一个oracle问题

skid

我安装oracle9i以后，启动oracle的时候
[oracle@localhost ~]$ sqlplus /nolog
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


监听
LSNRCTL for Linux: Version 9.2.0.4.0 - Production on 26-JUN-2000 19:29:21

Copyright (c) 1991, 2002, Oracle Corporation.  All rights reserved.

Message 1070 not found; No message file for product=network, facility=TNSSegmentation fault
我的.bash_profile
ORACLE_BASE=/u10/app/oracle; export ORACLE_BASE
ORACLE_HOME=$ORACLE_BASE/product/9.2.0.1.0; export ORALCE_HOME
ORACLE_TERM=xterm; export ORACLE_TERM
PATH=$ORACLE_HOME/binPATH:/usr/local/j2sdk1.4.2_06/bin; export PATH
ORACLE_OWNER=oracle; export ORACLE_OWNER
ORACLE_SID=ORCL; export ORACLE_SID
LD_LIBRARY_PATH=$ORACLE_HOME/lib; export LD_LIBRARY_PATH
CLASSPATH=$ORACLE_HOME/JREORACLE_HOME/jlibORACLE_HOME/rdbms/jlib; export CLASSPATH
LD_ASSUME_KERNEL=2.4.1; export LD_ASSUME_KERNEL
THREADS_FLAG=native; export THREADS_FLAG
TMP=/tmp; export TMP
TMPDI=$TMP; export TMPDIR
谢谢大家帮我看看，找了半天也没有办法。鞠躬先谢谢了！

imtj

su - oracle
sqlplus /NOLOG
在试试！

skid

sqlplus /nolog也是一样错误

zhen917

应该是你的环境变量设置有问题。具体原因你自己去找.
你可以参照我在AS3下装9.2.0.4的BASH_PROFILE

1. # .bash_profile
   
2. 
   
3. # Get the aliases and functions
   
4. if [ -f ~/.bashrc ]; then
   
5.         . ~/.bashrc
   
6. fi
   
7. 
   
8. # User specific environment and startup programs
   
9. 
   
10. PATH=$PATH:$HOME/bin
    
11. BASH_ENV=$HOME/.bashrc
    
12. USERNAME="root"
    
13. 
    
14. export USERNAME BASH_ENV PATH
    
15. export ORACLE_HOME=/opt/oracle
    
16. export ORACLE_HOEM=/opt/oracle/product/9.2.0
    
17. 
    
18. oracle下.bash_profile
    
19. # .bash_profile
    
20. 
    
21. # Get the aliases and functions
    
22. if [ -f ~/.bashrc ]; then
    
23.         . ~/.bashrc
    
24. fi
    
25. 
    
26. # User specific environment and startup programs
    
27. 
    
28. PATH=$PATH:$HOME/bin
    
29. 
    
30. export PATH
    
31. unset USERNAME
    
32. #ORACLE9.2.0.4
    
33. export ORACLE_BASE=/opt/oracle
    
34. export ORACLE_HOME=/opt/oracle/product/9.2.0
    
35. export PATH=$ORACLE_HOME/bin:$ORACLE_HOME/Apache/Apache/bin:$PATH
    
36. export ORACLE_OWNER=oracle
    
37. export ORACLE_SID=HZ2004
    
38. export ORACLE_TERM=vt100
    
39. export LD_ASSUME_KERNEL=2.4.1
    
40. export THREADS_FLAG=native
    
41. export LD_LIBRARY_PATH=/opt/oracle/product/9.2.0/lib:$LD_LIBRARY_PATH
    
42. export PATH=/opt/oracle/product/9.2.0/bin: $PATH
    
43. #
    
44. # change this NLS settings to suit your country:
    
45. # example:
    
46. # german_germany.we8iso8859p15, american_america.we8iso8859p2 etc.
    
47. #
    
48. export LANG=en_US

复制代码

bitao

ORACLE_HOME=$ORACLE_BASE/product/9.2.0.1.0; export ORALCE_HOME
ORACLE_HOME=$ORACLE_BASE/product/9.2.0.1.0; export ORACLE_HOME


呵呵，，写错啦

自己看下

export ORALCE_HOME

skid

修改以后也还是一样

bitao

对比下　zhen917 (E.T.zhen)    提供的例子吧

看看自己到底少了什么

bitao

要退出当前控制台重新登陆　参数才生效哦

imtj

你的问题是由参数设置错误产生的，我以前由遇到过，你只需要设置正确就OK了！

skid

现在好了，是我马虎，谢谢大家了。