首页 > 数据库 > Oracle > 正文

Oracle数据库新装之后出现的监听程序无法正常启动和运行(Oracle-12514)问题

2020-07-26 13:59:37
字体:
来源:转载
供稿:网友

修改安装目录下的配置文件

     比如: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)问题,希望对大家有所帮助,如果大家有任何疑问请给我留言,小编会及时回复大家的。在此也非常感谢大家对武林网网站的支持!

发表评论 共有条评论
用户名: 密码:
验证码: 匿名发表