d:\>sqlplus scott/tiger
SQL*Plus: Release 10.1.0.2.0 - Production on 星期四 9月 16 14:07:37 2010Copyright (c) 1982, 2004, Oracle. All rights reserved.ERROR:
ORA-01034: ORACLE not available
ORA-27101: shared memory realm does not exist顺便说怎么查看oracle_home与oracle_sid的配置是否正确 在线等...............
SQL*Plus: Release 10.1.0.2.0 - Production on 星期四 9月 16 14:07:37 2010Copyright (c) 1982, 2004, Oracle. All rights reserved.ERROR:
ORA-01034: ORACLE not available
ORA-27101: shared memory realm does not exist顺便说怎么查看oracle_home与oracle_sid的配置是否正确 在线等...............
sqlplus / as sysdba
startup
看看成不
d:\> sqlplus /nolog
conn / as sysdba
startup;
conn scott/tiger
C:\Documents and Settings\Administrator>sqlplus scott/tiger @liuSQL*Plus: Release 10.1.0.2.0 - Production on 星期四 9月 16 14:31:08 2010Copyright (c) 1982, 2004, Oracle. All rights reserved.
Connected to:
Oracle Database 10g Enterprise Edition Release 10.1.0.2.0 - Production
With the Partitioning, OLAP and Data Mining optionsSP2-0310: unable to open file "liu.sql"
再用C:\Documents and Settings\Administrator>sqlplus scott/tiger@ip:1521/liu
试一下,
sqlplus scott/tiger 命令通过 beq 协议连接数据库,其要求 oracle_sid 环境变量的设置与数据库的 sid 一致。命令行中执行
echo %ORACLE_SID%
echo %ORACLE_HOME%