Oracle数据库新装之后出现的监听程序无法正常启动和运行(Oracle-12514)问题
程序员文章站
2022-05-05 11:30:51
修改安装目录下的配置文件
比如:f:\app\admin-pc\product\11.2.0\dbhome_1\netw...
修改安装目录下的配置文件
比如:f:\app\admin-pc\product\11.2.0\dbhome_1\network\admin\
修改这个目录下的listener.ora和tnsnames.ora
**************************************************************************************
listener.ora: sid_list_listener = (sid_list = (sid_desc = (sid_name = clrextproc) (oracle_home = f:\app\xieliangliang\product\11.2.0\dbhome_1) (program = extproc) (envs = "extproc_dlls=only:f:\app\admin-pc\product\11.2.0\dbhome_1\bin\oraclr11.dll") ) (sid_desc = (global_dbname = orcl) (oracle_home = f:\app\admin-pc\product\11.2.0\dbhome_1) (sid_name = orcl) ) ) listener = (description_list = (description = (address = (protocol = tcp)(host = 127.0.0.1)(port = 1521)) ) ) adr_base_listener = f:\app\admin-pc
*********************************************************************************
tnsnames.ora: oraclr_connection_data = (description = (address_list = (address = (protocol = ipc)(key = extproc1521)) ) (connect_data = (sid = clrextproc) (presentation = ro) ) ) orcl = (description = (address = (protocol = tcp)(host = 127.0.0.1)(port = 1521)) (connect_data = (server = dedicated) (service_name = orcl) ) )
======================================================
对比修改标红的部分即可
总结
以上所述是小编给大家介绍的oracle数据库新装之后出现的监听程序无法正常启动和运行(oracle-12514)问题,希望对大家有所帮助
上一篇: 用ps把文字变模糊
下一篇: ASP.NET中常用的种代码实例解析