Oracle 9i SQL Plus 使用问题（有内容）

coolguy77cn

总是出现以下出错，什么原因？
D:\oracle\ora92\bin>;sqlplus /nolog

SQL*Plus: Release 9.2.0.1.0 - Production on 星期二 9月 30 11:46:23 2003

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

SQL>; connect / as sysdba
ERROR:
ORA-12560: TNS: 协议适配器错误


SQL>; connect sys/sys as sysdba
ERROR:
ORA-12560: TNS: 协议适配器错误


SQL>;

liupch

看一下你的tnsnames.ora
应该是这个配置文件有问题

coolguy77cn

以下是我的tnsnames.ora，我增加了ipc的方式也不行。
我是在没有启动数据库的时候，连接的，我想在命令行去启动数据库

# TNSNAMES.ORA Network Configuration File: d:\oracle\ora92\network\admin\tnsnames.ora
# Generated by Oracle configuration tools.

ORCL.HARRIS.GUANGZHOU.GD.CN =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = yxb)(PORT = 1521))
    )
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = orcl)
    )
  )

TEST.HARRIS.GUANGZHOU.GD.CN =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = IPC)(KEY = 1234))
    )
    (CONNECT_DATA =
      (SERVICE_NAME = test)
    )
  )

EXTPROC_CONNECTION_DATA.HARRIS.GUANGZHOU.GD.CN =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0))
    )
    (CONNECT_DATA =
      (SID = PLSExtProc)
      (PRESENTATION = RO)
    )
  )

INST1_HTTP.HARRIS.GUANGZHOU.GD.CN =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = yxb)(PORT = 1521))
    )
    (CONNECT_DATA =
      (SERVER = SHARED)
      (SERVICE_NAME = MODOSE)
      (PRESENTATION = http://HRService)
    )
  )