暂无图片
暂无图片
暂无图片
暂无图片
暂无图片

Ora-12514

Oracle那些事 2021-02-06
875

;这个错误是指监听程序出现了问题,而监听文件为listener.ora,在product\11.2.0\dbhome_1\NETWORK\ADMIN目录下。

按照下面方式修改

    # listener.ora Network Configuration File: F:\app1\92306\product\11.2.0\dbhome_1\network\admin\listener.ora
    # Generated by Oracle configuration tools.


    SID_LIST_LISTENER =
    (SID_LIST =
    (SID_DESC =
    (SID_NAME = CLRExtProc)
    (ORACLE_HOME = F:\app1\92306\product\11.2.0\dbhome_1)
    (PROGRAM = extproc)
    (ENVS = "EXTPROC_DLLS=ONLY:F:\app1\92306\product\11.2.0\dbhome_1\bin\oraclr11.dll")
    )
    (SID_DESC=
    (GLOBAL_DBNAME= orcl)
    (ORACLE_HOME = F:\app1\92306\product\11.2.0\dbhome_1)
    (SID_NAME = ORCL)
    )
    )
    LISTENER =
    (DESCRIPTION_LIST =
    (DESCRIPTION =
    (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
    (ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))
    )
    )


    ADR_BASE_LISTENER = F:\app1\92306




    注意下面这部分

      (SID_DESC=
      (GLOBAL_DBNAME= orcl)
      (ORACLE_HOME = F:\app1\92306\product\11.2.0\dbhome_1)
      (SID_NAME = ORCL)
      )

      然后重启监听:

        lsnrctl stop
        lsnrctl start


        文章转载自Oracle那些事,如果涉嫌侵权,请发送邮件至:contact@modb.pro进行举报,并提供相关证据,一经查实,墨天轮将立刻删除相关内容。

        评论