oracle 10g listener.ora sqlnet.ora tnsnames.ora 监听器配置

flowerjack 2012-09-04 04:01:12

listener.ora sqlnet.ora tnsnames.ora
====================================
这三个文件按网上的改了一下,现在监听器起不来了,配置工具也打不开了
向各位求救

...全文

165 8 打赏收藏转发到动态举报

写回复

用AI写文章

8 条回复

切换为时间正序

请发表友善的回复…

发表回复

flowerjack 2012-09-04

打赏
举报

只是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)

flowerjack 2012-09-04

打赏
举报

知道原因了:之前把机器名改为IP地址了,要重启才可以

Kobayashi 2012-09-04

打赏
举报

这个看起来与你的这几个文件没有关系啊。。都是正确的。
你是不是改了什么东西？
或者你把错误发上来。这样才能分析问题。

ray_suen 2012-09-04

打赏
举报

把listener.ora删了，使用无配置启动

flowerjack 2012-09-04

打赏
举报

以下为三个配置文件的内容,找不到问题,请各位指正
========================================================每个文件以此为分界线

# 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)
)
)

flowerjack 2012-09-04