数据库安装成功之后登录Scott能够登录成功,把监听和实例服务重启之后,登录Scott报错ORA-12514。但是不断的登录,偶尔也能够登录上。
解决方法:修改配置文件listener.ora中的配置信息。
修改前:
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = CLRExtProc)
(ORACLE_HOME = D:\ruanjian\oracle\product\11.2.0\dbhome_1)
(PROGRAM = extproc)
(ENVS = "EXTPROC_DLLS=ONLY:D:\ruanjian\oracle\product\11.2.0\dbhome_1\bin\oraclr11.dll")
)
)
修改后:
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = CLRExtProc)
(ORACLE_HOME = D:\ruanjian\oracle\product\11.2.0\dbhome_1)
(PROGRAM = extproc)
(ENVS = "EXTPROC_DLLS=ONLY:D:\ruanjian\oracle\product\11.2.0\dbhome_1\bin\oraclr11.dll") --这一句可以去掉也可以带着
)
(SID_DESC =
(GLOBAL_DBNAME = orcl)
(ORACLE_HOME = D:\ruanjian\oracle\product\11.2.0\dbhome_1)
(SID_NAME = orcl)
)
)