主机上多版本oracle的sqlplus连接问题

lovegigi1999

windows xp环境
事先装了9i，配置了库lin
之后安装了10g，配置了库auxi

现在想连接到lin库
C:\Documents and Settings\ll>set oracle_sid=lin

C:\Documents and Settings\ll>sqlplus "/as sysdba"
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

C:\Documents and Settings\ll>d:

D:\>cd D:\oracle\ora92\bin

D:\oracle\ora92\bin>set ORACLE_HOME="D:\oracle\ora92\bin"

D:\oracle\ora92\bin>sqlplus "/as sysdba"
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

这里正确的设置了oracle_home后就可以连接了
D:\oracle\ora92\bin>set ORACLE_HOME=D:\oracle\ora92\

D:\oracle\ora92\bin>sqlplus "/as sysdba"

SQL*Plus: Release 9.2.0.1.0 - Production on 星期二 5月 24 19:48:48 2011

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


连接到:
Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production
With the Partitioning, OLAP and Data Mining options