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

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

程序员文章站 2022-03-31 18:19:46
修改安装目录下的配置文件 比如:F:\app\admin-PC\product\11.2.0\dbhome_1\network\admin\ 修改这个目录下的listener.ora和tnsnames.ora ********************************************* ......

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

     比如:f:\app\admin-pc\product\11.2.0\dbhome_1\network\admin\

  修改这个目录下的listener.oratnsnames.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)
)
)

======================================================

对比修改标红的部分即可