欢迎您访问程序员文章站本站旨在为大家提供分享程序员计算机编程知识!
您现在的位置是: 首页  >  IT编程

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)问题,希望对大家有所帮助