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
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)
)
)
------解决方案--------------------
你是在本机连的,还是客户端
你的服务名配置了吗
------解决方案--------------------
你是否更改了计算机的名字？？？
------解决方案--------------------
是不是你的操作系统的问题，，，shared memory realm does not exist
系统和内存之间读取的时候出问题了，使你操作系统不能给oracle分配有效的内存空间
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)
)
)
------解决方案--------------------
你是在本机连的,还是客户端
你的服务名配置了吗
------解决方案--------------------
你是否更改了计算机的名字？？？
------解决方案--------------------
是不是你的操作系统的问题，，，shared memory realm does not exist
系统和内存之间读取的时候出问题了，使你操作系统不能给oracle分配有效的内存空间