我装完8i后数据库可以正常连接,但我把计算机名改了之后就不行了,应该如何解决啊?~~ 修改tnsname.ora文件,或者重新配置 解决方案 » 免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货 1. 用net8 configuration assistant重新配置 2. 把tnsnames.ora,listener.ora,sqlnet.ora文件贴上来 ? 注意: tnsnames.ora中的host参数最好填写ip,也可以填写本机名称. 但要保证 (1) hosts文件中有解析记录 例如 127.0.0.1 localhost (2) 合理配置sqlnet.ora中的 NAMES.DIRECTORY_PATH参数 tnsnames.ora,listener.ora 里面的localhost的地址更改了就可以了。 # TNSNAMES.ORA Network Configuration File: e:\oracle\ora81\network\admin\tnsnames.ora# Generated by Oracle configuration tools.SERVER = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = home)(PORT = 1521)) ) (CONNECT_DATA = (SERVICE_NAME = home) ) )INST1_HTTP = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = home)(PORT = 1521)) ) (CONNECT_DATA = (SERVER = SHARED) (SERVICE_NAME = server) (PRESENTATION = http://admin) ) )##################################### Date..........: Sat Jan 03 19:06:55 CST 2004####################################EXTPROC_CONNECTION_DATA = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0)) ) (CONNECT_DATA = (SID = PLSExtProc) (PRESENTATION = RO) ) )# LISTENER.ORA Network Configuration File: e:\oracle\ora81\network\admin\listener.ora# Generated by Oracle configuration tools.LISTENER = (DESCRIPTION_LIST = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0)) ) (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = home)(PORT = 1521)) ) ) (DESCRIPTION = (PROTOCOL_STACK = (PRESENTATION = GIOP) (SESSION = RAW) ) (ADDRESS = (PROTOCOL = TCP)(HOST = home)(PORT = 2481)) ) )SID_LIST_LISTENER = (SID_LIST = (SID_DESC = (SID_NAME = PLSExtProc) (ORACLE_HOME = e:\oracle\ora81) (PROGRAM = extproc) ) (SID_DESC = (GLOBAL_DBNAME = home) (ORACLE_HOME = e:\oracle\ora81) (SID_NAME = home) ) (SID_DESC = (GLOBAL_DBNAME = server) (ORACLE_HOME = e:\oracle\ora81) (SID_NAME = server) ) )# SQLNET.ORA Network Configuration File: e:\oracle\ora81\network\admin\sqlnet.ora# Generated by Oracle configuration tools.SQLNET.AUTHENTICATION_SERVICES= (NTS)NAMES.DIRECTORY_PATH= (TNSNAMES, ONAMES, HOSTNAME) 改计算机名的话,监听器就无法工作,数据库当然也打不开. :(不用急,就两三步可以搞定. :)在 Oracle 里修改相关的文件,把名字改回来就可以了~解决方法: 1. 修改监听器的文件. ...Oracle目录 \Ora81\network\admin\listener.ora 把里头的 Host = ... 改你现在的计算机名就可以啦~ 2. 修改服务名文件. ...Oracle目录\Ora81\network\admin\tnsnames.ora 同样方法,把对应的 Host = ... 修改. 3. 重启机子就可以啦~ 另: 如果在配置 本地服务名 的时候,在 主机名 里输入IP地址的话,就没有这种情况. 但 IP 地址改变的话,还是要重配置. 上面的问题解决了,但下面的操作还是不行,请问是怎么回事啊?~~~~D:\>exp antuuser/jgfExport: Release 8.1.7.0.0 - Production on 星期日 1月 4 17:49:01 2004(c) Copyright 2000 Oracle Corporation. All rights reserved.EXP-00056: ORACLE 错误 12560 出现ORA-12560: TNS: 协议适配器错误EXP-00000: 导出终止失败 1. tnsping 机器名(ip地址,localhost),看看是不是都能ping通?2. 你到底想连接哪个数据库(home or server)? exp username/password@sid 新手求解如下的SQL语句的意思 求解答:怎么根据手机号查询身份证号码,急急急! 怎样改变archivelog的归档路径 帮我看个简单的错误 谢谢 Oracle的blob字段问题 根据报表内容如何设计数据库? 为什么我的口令输入不了 触发器执行为什么是倒序执行啊? oracle密码忘记了,怎么找回来啊? 不重复记录SQL语句 数据导出时遇到的问题 对sysdate进行加1秒钟,如何写sql!
2. 把tnsnames.ora,listener.ora,sqlnet.ora文件贴上来 ? 注意:
tnsnames.ora中的host参数最好填写ip,也可以填写本机名称.
但要保证 (1) hosts文件中有解析记录 例如 127.0.0.1 localhost
(2) 合理配置sqlnet.ora中的 NAMES.DIRECTORY_PATH参数
# Generated by Oracle configuration tools.SERVER =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = home)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = home)
)
)INST1_HTTP =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = home)(PORT = 1521))
)
(CONNECT_DATA =
(SERVER = SHARED)
(SERVICE_NAME = server)
(PRESENTATION = http://admin)
)
)####################################
# Date..........: Sat Jan 03 19:06:55 CST 2004
####################################EXTPROC_CONNECTION_DATA =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0))
)
(CONNECT_DATA =
(SID = PLSExtProc)
(PRESENTATION = RO)
)
)
# LISTENER.ORA Network Configuration File: e:\oracle\ora81\network\admin\listener.ora
# Generated by Oracle configuration tools.LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0))
)
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = home)(PORT = 1521))
)
)
(DESCRIPTION =
(PROTOCOL_STACK =
(PRESENTATION = GIOP)
(SESSION = RAW)
)
(ADDRESS = (PROTOCOL = TCP)(HOST = home)(PORT = 2481))
)
)SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = e:\oracle\ora81)
(PROGRAM = extproc)
)
(SID_DESC =
(GLOBAL_DBNAME = home)
(ORACLE_HOME = e:\oracle\ora81)
(SID_NAME = home)
)
(SID_DESC =
(GLOBAL_DBNAME = server)
(ORACLE_HOME = e:\oracle\ora81)
(SID_NAME = server)
)
)
# SQLNET.ORA Network Configuration File: e:\oracle\ora81\network\admin\sqlnet.ora
# Generated by Oracle configuration tools.SQLNET.AUTHENTICATION_SERVICES= (NTS)NAMES.DIRECTORY_PATH= (TNSNAMES, ONAMES, HOSTNAME)
在 Oracle 里修改相关的文件,把名字改回来就可以了~解决方法:
1. 修改监听器的文件.
...Oracle目录 \Ora81\network\admin\listener.ora
把里头的 Host = ... 改你现在的计算机名就可以啦~
2. 修改服务名文件.
...Oracle目录\Ora81\network\admin\tnsnames.ora
同样方法,把对应的 Host = ... 修改.
3. 重启机子就可以啦~ 另: 如果在配置 本地服务名 的时候,在 主机名 里输入IP地址的话,就没有这种情况.
但 IP 地址改变的话,还是要重配置.
EXP-00056: ORACLE 错误 12560 出现
ORA-12560: TNS: 协议适配器错误
EXP-00000: 导出终止失败
2. 你到底想连接哪个数据库(home or server)?
exp username/password@sid