试一下把TNSNAMES.ORA文件的HOST=你的服务器IP
TNSNAMES.ORA在C:\oracle\ora81\network\ADMIN下
TNSNAMES.ORA在C:\oracle\ora81\network\ADMIN下
解决方案 »
- 我今天第一次接触Oracle,刚装的Oracle,给位高手帮帮我吧!!!!
- 关于ORACLE SERVICE 无法启动:1067 进程意外终止相关问题的请教。
- 求助每天0点执行JOB语法
- ORACLE FUNCTION问题,大惑不解请高手指点如何解决?
- 怎样在存储过程中让变量以结果集的方式显示出来?
- 高手进,看看一条语句能否解决?
- 很奇怪的存储过程参数(自定义类型)问题
- 一个动态sql文的问题
- 我如何判断 00000000000000001101 值是否与数据有A中字段 F中的值有冲突
- oracle远程数据连接问题
- oracles和MMDB相比之下,在关于实时系统的设计的问题时,为什么前者的性能不如后者?
- 如何列出当前用户下可见的所有表名?
如果是应用程序。我们的解决办法就是一旦发生这种错误或是ora-03113错误,即断开原有连接并重新连接数据库即可。
ORA-12545
This error occurs when the client computer tries to look up the hostname of the database server (for example dbp.banner.mcgill.ca) to get its IP address. The lookup is failing.In most cases we have seen, the results are wrong because an old Domain Name Server (DNS), no longer kept current, is still available and many PCs around campus are still pointing to it. It is incorrectly reporting that the Banner database server does not exist. Since the old DNS works fine for most other addresses, users have not realized there was a problem until now.The solution is to change the client computer's TCP/IP properties to point to the correct DNS addresses. Typically only two addresses should be listed: one for the primary DNS, and one for the secondary (alternate) DNS: 132.206.44.21
132.216.44.21Different computers/operating systems have different dialogs for changing this. The general approach is: Edit the Properties of Network Neighborhood (known as "My Network Places" in Windows 2000).
Navigate/drill down until you find the TCP/IP protocol, and edit its Properties. (If there are several TCP/IP entries found, ignore anything which refers to dial-up access or AOL. Hopefully only one possibility will remain.)
Add/Edit/Remove/Move entries as appropriate, until only the two IP addresses listed above remain.
Re-boot the machine if prompted to do so.
Banner should now work properly.Another possible causeThe ORA-12545 error can also occur if other TCP/IP properties are improperly configured, so that TCP/IP itself is not working. In that case, no IP communication will work (e.g. Web browsing). Fixing it is in the LAN manager's domain and will not be further discussed here.
二、连上后过一会就自动断开,但断开后可以再重新连上:说明网络不稳定
三、开始可以连上,过会就连不上了;如果断开再连接也连不上:这种情况说明服务器上启动了某些与ORACLE服务有冲突的东西,关闭这些服务就可以了。
LSNRCTL> STATUS [listener_name]
listener_name is the name of the listener defined in the listener.ora file. It is not necessary to identify the listener if you are using the default listener, named LISTENER. If the output indicates the listener is not running, try starting it with the command: LSNRCTL> START [listener_name]