版本：11.2.0.1.0 - 64bit
本机安装oracle后链接测试发现以下情况：
sqlplus scott/tiger 正常登陆
sqlplus scott/tiger@orcl 登陆失败，，提示ora-12514错误，应该是无法识别服务名orcl
为此查阅资料，找到以下解决方案：
-------------------------------------------------------------------
找到oracle安装目录下listener文件：
原文件如下：
sid_list_listener =
(sid_list =
(sid_desc =
(sid_name = clrextproc)
(oracle_home = d:\app\administrator\product\11.2.0\dbhome_1)
(program = extproc)
(envs = extproc_dlls=only:d:\app\administrator\product\11.2.0\dbhome_1\bin\oraclr11.dll)
)
)
listener =
(description_list =
(description =
(address = (protocol = ipc)(key = extproc1521))
(address = (protocol = tcp)(host = idylan)(port = 1521))
)
)
adr_base_listener = d:\app\administrator
修改后如下：
sid_list_listener =
(sid_list =
(sid_desc =
(sid_name = clrextproc)
(oracle_home = d:\app\administrator\product\11.2.0\dbhome_1)
(program = extproc)
(envs = extproc_dlls=only:d:\app\administrator\product\11.2.0\dbhome_1\bin\oraclr11.dll)
)
(sid_desc =
(global_dbname = orcl)
(oracle_home = d:\app\administrator\product\11.2.0\dbhome_1)
(sid_name = orcl)
)
)
listener =
(description_list =
(description =
(address = (protocol = ipc)(key = extproc1521))
(address = (protocol = tcp)(host = idylan)(port = 1521))
)
)
adr_base_listener = d:\app\administrator
保存，后sqlplus scott/tiger@orcl 可正常登陆。
--------------------------
dylan presents.
相关阅读：
goldengate不使用数据泵完成oracle-oracle的双向复制
使用goldengate的数据泵进行oracle-oracle的单向复制
如何对 oracle 数据泵（expdp/impdp） 进行 debug
oracle 数据库导出数据泵（expdp）文件存放的位置
oracle 10g 数据泵分区表的导出