http://download.oracle.com/docs/cd/B19306_01/server.102/b14219/toc.htm ORA-12170: TNS:Connect timeout occurred Cause: The server shut down because connection establishment or communication with a client failed to complete within the allotted time interval. This may be a result of network or system delays; or this may indicate that a malicious client is trying to cause a Denial of Service attack on the server. Action: If the error occurred because of a slow network or system, reconfigure one or all of the parameters SQLNET.INBOUND_CONNECT_TIMEOUT, SQLNET.SEND_TIMEOUT, SQLNET.RECV_TIMEOUT in sqlnet.ora to larger values. If a malicious client is suspected, use the address in sqlnet.log to identify the source and restrict access. Note that logged addresses may not be reliable as they can be forged (e.g. in TCP/IP).
新建监听和新建服务会提示一样错误，如下servicealiasexception : 无法初始化工服务别名 :tns-04404: 没有错误 caused by L : oracle.net.config.configexception: tns-04414: 文件错误 caused by : tns-04612 : "db.world" 的 rhs 为空
有高手来指点下么?谢谢数据库里的过程还在自动运行，但用pl/sql进不去数据库新建监听和新建服务会提示一样错误，如下 servicealiasexception : 无法初始化工服务别名 :tns-04404: 没有错误 caused by L : oracle.net.config.configexception: tns-04414: 文件错误 caused by : tns-04612 : "db.world" 的 rhs 为空
2、选择【本地net服务名配置】→下一步。
3、选择【添加】→下一步。
4、在【服务名】中输入你想要连接的服务器上的oracle服务的名字→下一步。
5、选择【tcp】→下一步。
6、在【主机名】中输入你想要连接的服务器ip，端口号不变→下一步。
7、选择【进行测试】→下一步。（当然你也可以选择不测试）
※1测试如果不通过，点击【更改登录】输入一个肯定能登入的【用户名】和【口令】→确定，出现【正在连接...测试成功。】表明测试成功。
※2测试不通过的话，点【上一步】确认你写的【服务名】和【主机名】，确认无误的情况下，确认你要连接的服务器oracle监听服务已经打开。
8、在【net服务名中】输入你想要使用的本地的服务名→下一步。
※就是【sqlplus user/passwd @本地服务名】。
9、选择【否】→下一步。
10、出现【net服务配置完毕】字样→下一步。
11、点击【完成】完成服务配置。
12、在上面服务配置完成以后，在cmd中输入如下命令即可远程登录oracle服务器：
sqlplus user_name/password@本地服务名
一定记住，上面的本地服务名是你第8步写的服务名
Cause: The server shut down because connection establishment or communication with a client failed to complete within the allotted time interval. This may be a result of network or system delays; or this may indicate that a malicious client is trying to cause a Denial of Service attack on the server.
Action: If the error occurred because of a slow network or system, reconfigure one or all of the parameters SQLNET.INBOUND_CONNECT_TIMEOUT, SQLNET.SEND_TIMEOUT, SQLNET.RECV_TIMEOUT in sqlnet.ora to larger values. If a malicious client is suspected, use the address in sqlnet.log to identify the source and restrict access. Note that logged addresses may not be reliable as they can be forged (e.g. in TCP/IP).
caused by L : oracle.net.config.configexception: tns-04414: 文件错误
caused by : tns-04612 : "db.world" 的 rhs 为空
caused by L : oracle.net.config.configexception: tns-04414: 文件错误
caused by : tns-04612 : "db.world" 的 rhs 为空