终于解决了TNS问题!
来源:互联网 发布:js json判断是否存在 编辑:程序博客网 时间:2024/04/29 09:17
刚刚开始使用Oracle,觉得好麻烦啊!
一堆的工具,各种各样的配置。。。都快要吐了【%…&¥&×发泄一下先】
本来可以使用其最基本的数据库的。然后,终于。。。
我在企业管理器中加了个新的数据库就挂了。。
不停地报错,刚开始只是找不到对象等等。
我就的搜索,百度。。。发现原来还有Net Configuration Asistant这东东。。
就瞎填了一把,瞎删了一把。
竟然发现原来的LTY『数据库』也不能使用了,要不就是TNS错误,要不就是Server_name,要不就是服务名,要不就是SID。。。
快要疯了。不停地修改,试验。。。。网上的东西很多 也导致走了不少弯路。一些人其实不怎么懂,也给『楼主』瞎指挥。。。。
结果就是诱导我不停修改TNSNames.ora有时候又怀疑Listener.ora 又看看sqlnet.ora。。。
经过了痛苦的过程之后,终于发现
http://blog.csdn.net/seulty/archive/2007/07/18/1697869.aspx
虽然文章很短,但是,我确实根据此文解决了问题
赞一个!!
问题解决了,总结如下:
- 只要1个listener即可,多了似乎也没有用处
- TNSNames.ora还是手动改比较好
- 和SQLNET.orb似乎关系不大。。
贴一下改动的文件:
TNSNames.ora:
# TNSNAMES.ORA Network Configuration File: E:oracleora92 etworkadmin nsnames.ora
# Generated by Oracle configuration tools.
INST1_HTTP =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = ace)(PORT = 1521))
)
(CONNECT_DATA =
(SERVER = SHARED)
(SERVICE_NAME = MODOSE)
(PRESENTATION = http://HRService)
)
)
EXTPROC_CONNECTION_DATA =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0))
)
(CONNECT_DATA =
(SID = PLSExtProc)
(PRESENTATION = RO)
)
)
LTY.ACE =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = ace)(PORT = 1521))
)
(CONNECT_DATA =
(SID = lty)
(SERVER = DEDICATED)
)
)
LTY =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 10.7.1.113)(PORT = 1521))
)
(CONNECT_DATA =
(SID = lty)
(SERVER = DEDICATED)
)
)
14_LTY =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 10.7.1.113)(PORT = 1521))
)
(CONNECT_DATA =
(SID = lty)
(SERVER = DEDICATED)
)
)
14TEST_ACE =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 10.7.1.113)(PORT = 1521))
)
(CONNECT_DATA =
(SID = lty)
(SERVER = DEDICATED)
)
)
LTY_ACE =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 10.7.1.113)(PORT = 1521))
)
(CONNECT_DATA =
(SID = lty)
(SERVER = DEDICATED)
)
)
# Generated by Oracle configuration tools.
INST1_HTTP =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = ace)(PORT = 1521))
)
(CONNECT_DATA =
(SERVER = SHARED)
(SERVICE_NAME = MODOSE)
(PRESENTATION = http://HRService)
)
)
EXTPROC_CONNECTION_DATA =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0))
)
(CONNECT_DATA =
(SID = PLSExtProc)
(PRESENTATION = RO)
)
)
LTY.ACE =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = ace)(PORT = 1521))
)
(CONNECT_DATA =
(SID = lty)
(SERVER = DEDICATED)
)
)
LTY =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 10.7.1.113)(PORT = 1521))
)
(CONNECT_DATA =
(SID = lty)
(SERVER = DEDICATED)
)
)
14_LTY =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 10.7.1.113)(PORT = 1521))
)
(CONNECT_DATA =
(SID = lty)
(SERVER = DEDICATED)
)
)
14TEST_ACE =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 10.7.1.113)(PORT = 1521))
)
(CONNECT_DATA =
(SID = lty)
(SERVER = DEDICATED)
)
)
LTY_ACE =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 10.7.1.113)(PORT = 1521))
)
(CONNECT_DATA =
(SID = lty)
(SERVER = DEDICATED)
)
)
Listener.ora
『这里只用了“Listener”这一个服务』,其他两个停掉了。
# LISTENER.ORA Network Configuration File: E:oracleora92 etworkadminlistener.ora
# Generated by Oracle configuration tools.
LTY_LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = ace)(PORT = 1521))
)
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCPS)(HOST = ace)(PORT = 2484))
)
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = NMP)(SERVER = ACE)(PIPE = ORAPIPE))
)
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = lty))
)
)
)
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = ace)(PORT = 1521))
)
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCPS)(HOST = ace)(PORT = 2484))
)
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = NMP)(SERVER = ACE)(PIPE = ORAPIPE))
)
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = lty))
)
)
)
SID_LIST_LTY_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = E:oracleora92)
(PROGRAM = extproc)
)
)
# Generated by Oracle configuration tools.
LTY_LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = ace)(PORT = 1521))
)
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCPS)(HOST = ace)(PORT = 2484))
)
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = NMP)(SERVER = ACE)(PIPE = ORAPIPE))
)
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = lty))
)
)
)
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = ace)(PORT = 1521))
)
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCPS)(HOST = ace)(PORT = 2484))
)
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = NMP)(SERVER = ACE)(PIPE = ORAPIPE))
)
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = lty))
)
)
)
SID_LIST_LTY_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = E:oracleora92)
(PROGRAM = extproc)
)
)
SQLNET.orb
『也贴一下把』
# SQLNET.ORA Network Configuration File: E:oracleora92 etworkadminsqlnet.ora
# Generated by Oracle configuration tools.
SQLNET.AUTHENTICATION_SERVICES= (NTS)
NAMES.DIRECTORY_PATH= (TNSNAMES, ONAMES, HOSTNAME)
# Generated by Oracle configuration tools.
SQLNET.AUTHENTICATION_SERVICES= (NTS)
NAMES.DIRECTORY_PATH= (TNSNAMES, ONAMES, HOSTNAME)
- 终于解决了TNS问题!
- 问题终于解决了
- Linking 问题终于解决了.
- CLOSE_WAIT问题终于解决了
- 终于解决了一点问题
- 终于解决昨天的问题了
- 终于解决了这个怪问题
- 终于解决了这个怪问题
- 问题终于解决了……
- ruby的奇怪问题~~~终于解决了.!
- 终于解决了session问题,总结!
- FCKedit上传问题终于解决了
- FreeTextBox的问题终于解决了
- 终于解决了liferay的缓存问题!
- 终于解决了liferay的缓存问题!
- 终于解决了JSP中编码问题~~~~~~~
- 好累,终于解决了一个问题
- 终于解决了NHibernate的排序问题
- 维克房地产中介管理软件 v2.62 个人版 下载
- 维克仓库管理软件 v3.4 工程网络版 是什么
- DPL,RPL,CPL 资料总结
- 维克仓库管理软件 v3.4 绿色
- 维克采购管理软件 v2.0 免费
- 终于解决了TNS问题!
- 维克仪器客服管理软件 v1.2 怎么用
- 维克样品管理软件 v1.2 免费
- 验证控件
- Fatal Error: Unable to find package java.lang in classpath or bootclasspath
- remoting 开发
- 【转】基于C#的接口基础教程之五(2)
- 什么是dojo
- Petshop4.0 超级详细介绍(一)