今天配置好数据库实例,验证用户是否能登录时,oracle报listener does not currently know of service requested in connect descriptor错误,如图
解决方案:
oracle监听配置有问题,需要检查listener.ora文件,该文件地址为:C:\app\Jay\product\11.2.0\dbhome_1\NETWORK\ADMIN(根据安装时选择的路径),
在原来的基础上添加红色部分,其中TC83为该数据库服务命名。
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = CLRExtProc)
(ORACLE_HOME = C:\app\Jay\product\11.2.0\dbhome_1)
(PROGRAM = extproc)
(ENVS = "EXTPROC_DLLS=ONLY:C:\app\Jay\product\11.2.0\dbhome_1\bin\oraclr11.dll")
)
(SID_DESC =
(SID_NAME = TC83)
(ORACLE_HOME = C:\app\Jay\product\11.2.0\dbhome_1)
(SID_NAME = TC83)
)
)
然后重新启动Oracle服务与监听服务
再次登录验证,则正确连接