oracle 10g listener.ora sqlnet.ora tnsnames.ora 监听器配置 listener.ora sqlnet.ora tnsnames.ora====================================这三个文件按网上的改了一下,现在监听器起不来了,配置工具也打不开了向各位求救 解决方案 » 免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货 以下为三个配置文件的内容,找不到问题,请各位指正========================================================每个文件以此为分界线# listener.ora Network Configuration File: D:\oracle\product\10.2.0\db_1\NETWORK\ADMIN\listener.ora# Generated by Oracle configuration tools.SID_LIST_LISTENER = (SID_DESC = (GLOBAL_DBNAME = orcl) (ORACLE_HOME = D:\oracle\product\10.2.0\db_1) (SID_NAME = ORCL) )SID_LIST_LISTENEROA = (SID_LIST = (SID_DESC = (GLOBAL_DBNAME = orcl) (ORACLE_HOME = D:\oracle\product\10.2.0\db_1) (SID_NAME = ORCL) ) )LISTENER = (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = jyjdata)(PORT = 1521)) )LISTENEROA = (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = jyjdata)(PORT = 1522)) )========================================================# sqlnet.ora Network Configuration File: D:\oracle\product\10.2.0\db_1\network\admin\sqlnet.ora# Generated by Oracle configuration tools.# 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)NAMES.DIRECTORY_PATH= (TNSNAMES, EZCONNECT)========================================================# tnsnames.ora Network Configuration File: D:\oracle\product\10.2.0\db_1\NETWORK\ADMIN\tnsnames.ora# Generated by Oracle configuration tools.ORCL = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = jyjdata)(PORT = 1521)) ) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = orcl) ) )EXTPROC_CONNECTION_DATA = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1)) ) (CONNECT_DATA = (SID = PLSExtProc) (PRESENTATION = RO) ) ) 把listener.ora删了,使用无配置启动 只是imp 指令还是用不了 :imp user/psd@orcl file=e:\orcl.dmp full=y;遇到oracle 错误 12154 :TNS无法解析指定的连接标识符==============================================请问:是和sqlnet.ora配置有关吗?SQLNET.AUTHENTICATION_SERVICES= (NTS)NAMES.DIRECTORY_PATH= (TNSNAMES, EZCONNECT) 查询问题,请教高手 怎样建立这样的视图? who 推荐oracle管理时间的书籍 错误:无法找到入口。 jdbc输出xml 学Oracle的问题~ 关于rman一些很弱的问题,高手指点 一段SQL语句 请大家指点 windows xp下oracle 8.16的listen无法启动,请各位帮帮忙 外联结是干什么用的? 关于递归查询的问题 oracle解析xml实例增删改,自己收藏
========================================================每个文件以此为分界线# listener.ora Network Configuration File: D:\oracle\product\10.2.0\db_1\NETWORK\ADMIN\listener.ora
# Generated by Oracle configuration tools.SID_LIST_LISTENER =
(SID_DESC =
(GLOBAL_DBNAME = orcl)
(ORACLE_HOME = D:\oracle\product\10.2.0\db_1)
(SID_NAME = ORCL)
)SID_LIST_LISTENEROA =
(SID_LIST =
(SID_DESC =
(GLOBAL_DBNAME = orcl)
(ORACLE_HOME = D:\oracle\product\10.2.0\db_1)
(SID_NAME = ORCL)
)
)LISTENER =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = jyjdata)(PORT = 1521))
)LISTENEROA =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = jyjdata)(PORT = 1522))
)========================================================
# sqlnet.ora Network Configuration File: D:\oracle\product\10.2.0\db_1\network\admin\sqlnet.ora
# Generated by Oracle configuration tools.# 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)NAMES.DIRECTORY_PATH= (TNSNAMES, EZCONNECT)
========================================================
# tnsnames.ora Network Configuration File: D:\oracle\product\10.2.0\db_1\NETWORK\ADMIN\tnsnames.ora
# Generated by Oracle configuration tools.ORCL =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = jyjdata)(PORT = 1521))
)
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = orcl)
)
)EXTPROC_CONNECTION_DATA =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1))
)
(CONNECT_DATA =
(SID = PLSExtProc)
(PRESENTATION = RO)
)
)
imp user/psd@orcl file=e:\orcl.dmp full=y;遇到oracle 错误 12154 :TNS无法解析指定的连接标识符
==============================================
请问:是和sqlnet.ora配置有关吗?
SQLNET.AUTHENTICATION_SERVICES= (NTS)NAMES.DIRECTORY_PATH= (TNSNAMES, EZCONNECT)