好得很程序员自学网

<tfoot draggable='sEl'></tfoot>

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

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

     比如:F:\app\admin-PC\product\11.2.0\dbhome_1\network\admin\

  修改这个目录下的listener.ora和tnsnames.ora

**************************************************************************************

?

1

2

3

4

5

6

7

8

9

10

11

12

13

14

15

16

17

18

19

20

21

22

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

*********************************************************************************

?

1

2

3

4

5

6

7

8

9

10

11

12

13

14

15

16

17

18

19

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

原文链接:https://www.cnblogs.com/like9527/archive/2018/11/12/9945318.html

查看更多关于Oracle数据库新装之后出现的监听程序无法正常启动和运行(Oracle-12514)问题的详细内容...

  阅读:20次