最近客户的oracle 报错:03113 ,还有就是客户端plsql 也报一些连续断网的error.
解决方案:
1: the hostname of file: listener.ora should be changed from Upper case to lower case as below:
(ADDRESS = (PROTOCOL = TCP)(HOST = ABCD01)(PORT = 1521)) --> (ADDRESS = (PROTOCOL = TCP)(HOST = abcd01)(PORT = 1521))
因为:
#cat /etc/hosts
10.82.201.185 abcd01
主机名是小写:abcd01
(以上已可以把主机名改成ip address:10.82.201.185 )
2: Do relink operation. And first, we should shut down the Database, then do following command:
$relink all
(因为按装的时候是copy安装的,一定要做relink)
3:检查client 的plsql 中的system32 中的host 文件的配置:也要为小写,还有oracle/network/admin/tnsnames.ora 的配置。
4:注意:改这些配置,要关掉database 的,如果是生产机的,要放到周末来做。
二:解决客户端的问题:
1:把客户端的hosts 文件修改:
Add following to your client hosts : C:WINDOWSsystem32driversetchosts
2:检查客户端的plsql 的版本,主机上是oracle 11g 的,客户端就不能用9i, 还有指定以外的版本
3(仅供参考)修改注册表
On Windows NT/2000:
HKEY_LOCAL_MACHINE
SYSTEM
CurrentControlSet
Services
Tcpip
Parameters
add a key "TcpMaxDataRetransmissions" (REG_DWORD) and set its value to 10.
On the Edit menu, click Add Value, and then add the following:
Value Name: TcpMaxDataRetransmissions
Value Type: REG_DWORD - Number
Valid Range: 0 - 0xFFFFFFFF
Default Value: 5 Decimal
New Value: 10 to Decimal
如果觉得我的文章对您有用,请点赞。您的支持将鼓励我继续创作!
关于TWT使用指南社区专家合作厂商入驻社区企业招聘投诉建议版权与免责声明联系我们 © 2024talkwithtrend — talk with trend,talk with technologist京ICP备09031017号-30
添加新评论0 条评论