日期:2014-05-16  浏览次数:27031 次

协议适配器错误

本来用conn / as sysdba或conn sys/apps as sysdba在cmd中连接虚拟机上的数据库,总是出现协议适配器错误的信息,

用conn sys/apps@dv11 as sysdba连接就成功了。

------------------------------------

C:\Users\Administrator>sqlplus /nolog

SQL*Plus: Release 11.2.0.1.0 Production on 星期一 6月 18 01:15:14 2012

Copyright (c) 1982, 2010, Oracle.  All rights reserved.

SQL> conn sys/apps@dv11 as sysdba
已连接。
SQL> select * from hr.employees where rownum=1
  2  /

EMPLOYEE_ID FIRST_NAME
----------- ----------------------------------------
LAST_NAME
--------------------------------------------------
EMAIL
--------------------------------------------------
PHONE_NUMBER                             HIRE_DATE      JOB_ID
---------------------------------------- -------------- --------------------
    SALARY COMMISSION_PCT MANAGER_ID DEPARTMENT_ID
---------- -------------- ---------- -------------
        198 Donald
OConnell
DOCONNEL

EMPLOYEE_ID FIRST_NAME
----------- ----------------------------------------
LAST_NAME
--------------------------------------------------
EMAIL
--------------------------------------------------
PHONE_NUMBER                             HIRE_DATE      JOB_ID
---------------------------------------- -------------- --------------------
    SALARY COMMISSION_PCT MANAGER_ID DEPARTMENT_ID
---------- -------------- ---------- -------------
650.507.9833                             21-6月 -99     SH_CLERK
      2600                       124            50


SQL>

------------------------------

但Toad工具仍然连不上,呜呜……