当前位置: 代码迷 >> Oracle管理 >> Oracle(10g)安装正常,计算机重启后就出现ORA-12514: TNS:listener does not currently know of service requested in connect descriptor,该如何解决
  详细解决方案

Oracle(10g)安装正常,计算机重启后就出现ORA-12514: TNS:listener does not currently know of service requested in connect descriptor,该如何解决

热度:425   发布时间:2016-04-24 06:02:21.0
Oracle(10g)安装正常,计算机重启后就出现ORA-12514: TNS:listener does not currently know of service requested in connect descriptor
求救...如题
在网上查了两天没有结果.我保证装完oracle之后没有修改任何东西,只是测试一下能不能登陆,然后重启计算机,然后就出现问题了.高手救命...
#   listener.ora   Network   Configuration   File:   E:\oracle\product\10.1.0\Db_1\network\admin\listener.ora
#   Generated   by   Oracle   configuration   tools.

SID_LIST_LISTENER   =
    (SID_LIST   =
        (SID_DESC   =
            (SID_NAME   =   PLSExtProc)
            (ORACLE_HOME   =   E:\oracle\product\10.1.0\Db_1)
            (PROGRAM   =   extproc)
        )
    )

LISTENER   =
    (DESCRIPTION_LIST   =
        (DESCRIPTION   =
            (ADDRESS_LIST   =
                (ADDRESS   =   (PROTOCOL   =   IPC)(KEY   =   EXTPROC))
            )
            (ADDRESS_LIST   =
                (ADDRESS   =   (PROTOCOL   =   TCP)(HOST   =   bell-xu.apachefootwear.com)(PORT   =   1521))
            )
        )
    )


----------------------------------------


#   tnsnames.ora   Network   Configuration   File:   E:\oracle\product\10.1.0\Db_1\network\admin\tnsnames.ora
#   Generated   by   Oracle   configuration   tools.

ORCL   =
    (DESCRIPTION   =
        (ADDRESS   =   (PROTOCOL   =   TCP)(HOST   =   bell-xu.apachefootwear.com)(PORT   =   1521))
        (CONNECT_DATA   =
            (SERVER   =   DEDICATED)
            (SERVICE_NAME   =   orcl)
        )
    )

EXTPROC_CONNECTION_DATA   =
    (DESCRIPTION   =
        (ADDRESS_LIST   =
            (ADDRESS   =   (PROTOCOL   =   IPC)(KEY   =   EXTPROC))
        )
        (CONNECT_DATA   =
            (SID   =   PLSExtProc)
            (PRESENTATION   =   RO)
        )
    )


------解决方案--------------------
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = E:\oracle\product\10.1.0\Db_1)
(PROGRAM = extproc)
)
)

改为:
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = E:\oracle\product\10.1.0\Db_1)
(PROGRAM = extproc)
)
(SID_DESC =
(GOLBAL_DBNAME= orcl)
(ORACLE_HOME = E:\oracle\product\10.1.0\Db_1)
(SID_NAME=orcl)
)
)

------解决方案--------------------
  相关解决方案