本来用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工具仍然连不上,呜呜……