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.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.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
阅读(1505) | 评论(0) | 转发(0) |
