解决方案:
问题发生在listener.org和tnsnames.org配置文件上,重新研究分析后,按照如下配置,并重启oracle server和listener服务,问题解决,配置内容如下,大家可参考修改
在oracle安装目录下D:\app\Lenovo\product\10.2.0\dbhome_2\NETWORK\ADMIN配置listener.org和tnsnames.org文件
listener.org文件
# listener.ora Network Configuration File: D:\app\Lenovo\product\11.2.0\dbhome_2\NETWORK\ADMIN\listener.ora
# Generated by Oracle configuration tools.
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = CLRExtProc)
(ORACLE_HOME = D:\app\Lenovo\product\11.2.0\dbhome_2)
(PROGRAM = extproc)
(ENVS = "EXTPROC_DLLS=ONLY:D:\app\Lenovo\product\11.2.0\dbhome_2\BIN\oraclr11.dll")
)
(SID_DESC =
(GLOBAL_DBNAME = orcl)
(ORACLE_HOME = D:\app\Lenovo\product\11.2.0\dbhome_2)
(SID_NAME = orcl)
)
)
LISTENER =
(DESCRIPTION =
(ADDRESS = (PROTO