1 ORA-12541 TNS :no listener on 1 specific remote database, but not on others 3 ORA-12505, TNS:listener does not currently know of SID given in connect 1 ORA-12154 error TNS could not resolve the connect identified specified 0 ORA-12543: TNS:destination host ...
We have a Windows 2012 R2 server, sitting behind a subnet and firewall. It has Oracle 11g Client software installed on the G: drive (does Oracle require install on C: drive?). When we try to connect to the Oracle RAC database on a Linux server, we get th...
LSNRCTL> status Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=admin-41f89f35d)(PORT=1521))) TNS-12541: TNS:no listener TNS-12560: TNS:protocol adapter error TNS-00511: No listener 32-bit Windows Error: 61: Unknown error tnsnames.ora # TNSNAMES.ORA Network Configuration File: F...
停用监视器:lsnrctl stop 监视器状态:lsnrctl status 以上代码如果依然解决不了问题,就需要手动开启监视了 有以下注意事项: A.看看你有没有防火墙,有的话关掉,例如我的诺顿就不行! B.去"控制面板"->"管理工具"->"服 务"下,找oracleorahomeTNSListener(肯能名字不同,但 ...
importcx_Oracle conn= cx_Oracle.connect('testma/dingjia@192.168.88.139:1521/orcl') Traceback (most recent call last): File"", line 1,incx_Oracle.DatabaseError: ORA-12541: TNS:no listener 解决: 打开Oralce机器的Net Configuration Assistant,重新进行TNS配置。ps:若没有则添加一个。
你先下一个Oracle官方的SQL Developer试试看，那里的连接配置比较简单易用。环境变量
You see the error "ORA-12541: TNS:no listener" on theSymantec Data Loss Prevention Enforce server.Learnhow to check the status of the Oracle listener service, and start or restart the service if necessary. ORA-12541: TNS:no listener
TNS-12541: TNS:no listener TNS-12560: TNS:protocol adapter error TNS-00511: No listener Linux Error:,今天是2014-06-17。遇到一个很奇怪的问题,可能之前測试改动监听的原因,导致监听启动后自己主动关闭,特此记录一下整个处理过程,监听配置文件信息例如以下:[ora
有种解决办法是修改Network Configuration File: %ORACLE_HOME%\network\admin\下的tnsnames.ora和listener.ora文件, 把其中的HOST=后的主机名或ip改为当前的主机名或ip,并重新启动监听服务。有人曾用这个方法解决了此问题,看来是我没有按方法说的进行正确操作。