最近自己 装 Oracle 10g 服务器(个人版) 来用,碰到了一些问题,特来请教 前辈!自己的单机,装了 Oracle 10g 服务器,用NET Manager配置了服务名,测试连接 老是 报 这个错误 :ORA-12514: TNS: 监听程序当前无法识别连接描述符中请求的服务---------------------------------------------------------------
百般郁闷,服务名 和 监听程序 删了重建 N 次,服务也重起了 N 次,连机器也重起过了。
tnsnames.ora 文件内容如下HHH =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = aaa)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = hhh)
)
)-----------------------
listener.ora 文件内容如下
# listener.ora Network Configuration File: c:\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 = c:\oracle\product\10.1.0\db_1)
(PROGRAM = extproc)
)
)LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = aaa)(PORT = 1521))
)
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC))
)
)
)
---------------------------sqlnet.ora 文件内容如下# This file is actually generated by netca. But if customers choose to
# install "Software Only", this file wont exist and without the native
# authentication, they will not be able to connect to the database on NT.SQLNET.AUTHENTICATION_SERVICES = (NTS)------------------------------------------------------网上的例子 和 各种 错误,各种 方法 试遍 !郁闷
网 高手 解惑 !!!!
百般郁闷,服务名 和 监听程序 删了重建 N 次,服务也重起了 N 次,连机器也重起过了。
tnsnames.ora 文件内容如下HHH =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = aaa)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = hhh)
)
)-----------------------
listener.ora 文件内容如下
# listener.ora Network Configuration File: c:\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 = c:\oracle\product\10.1.0\db_1)
(PROGRAM = extproc)
)
)LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = aaa)(PORT = 1521))
)
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC))
)
)
)
---------------------------sqlnet.ora 文件内容如下# This file is actually generated by netca. But if customers choose to
# install "Software Only", this file wont exist and without the native
# authentication, they will not be able to connect to the database on NT.SQLNET.AUTHENTICATION_SERVICES = (NTS)------------------------------------------------------网上的例子 和 各种 错误,各种 方法 试遍 !郁闷
网 高手 解惑 !!!!
2007 15:11:13Copyright (c) 1997, 2003, Oracle. All rights reserved.已使用的参数文件:
c:\oracle\product\10.1.0\db_1\network\admin\sqlnet.ora
已使用 TNSNAMES 适配器来解析别名
Attempting to contact (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)
(HOST = aaa)(PORT = 1521))) (CONNECT_DATA = (SERVICE_NAME = hhh)))
OK (20 毫秒)
-------------------------------------------------------
ping 这个 服务名 可以 ping 通 .....