遇到这个问题首先考虑检查配置文件listener.ora和tnsnames.ora。

1  listener.ora文件

获取电脑主机名称：可通过dba登录sqlplus利用

select HOST_NAME from v$instance;

语句查询主机名

模板如下： 

SID_LIST_LISTENER =(SID_LIST =(SID_DESC =(SID_NAME = CLRExtProc)(ORACLE_HOME = D:\app\Lenovo\product\11.2.0\dbhome_1)(PROGRAM = extproc)(ENVS = "EXTPROC_DLLS=ONLY:D:\app\Lenovo\product\11.2.0\dbhome_1\BIN\OraClr11.dll")))LISTENER =(DESCRIPTION_LIST =(DESCRIPTION =(ADDRESS = (PROTOCOL = TCP)(HOST = LAPTOP-W)(PORT = 1521))))ADR_BASE_LISTENER = D:\app\Lenovo

2  tnsnames.ora文件

①这里的SID要和示例名一致

②这里的SERVICE_NAME要和服务端的名称一致

模板如下：

  (DESCRIPTION =(ADDRESS_LIST =(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521)))(CONNECT_DATA =(SID = CLRExtProc)(PRESENTATION = RO)))ORCL =(DESCRIPTION =(ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))(CONNECT_DATA =(SERVER = DEDICATED)(SID = orcl)(SERVICE_NAME = orcl)))