Re: Listener problem on one client computer
Thank you very mutch for your replys, Today I finally found the problem. The traceroute shows the good route, but a Ms Proxy Client installed on the server blocked the request apparently. Just disabling it resolve everything. Damien Damien wrote: I have to do netstat -a on the webserver or on the Oracle server? Listener.ora is on the oracle server or on the webserver? I don't have any access on the oracle server and nobody can help on this side. Best regards, Damien - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Tuesday, September 02, 2003 9:14 PM The ports are the same, I've checked the tnsnames.ora files and copied pasted the content of the box who work on the web server. Still same prob. How can I check if i can open the port? It's a Win2000 server. To see if your Win2K server listens on port 1521 open MSDOS 'box' and type: C:\netstat -n Among (many) other things you should see something of this sort: Active Connections Proto Local Address Foreign AddressState TCP192.168.200.38:1031192.168.200.38:1521ESTABLISHED TCP192.168.200.38:1521192.168.200.38:1031ESTABLISHED You could also check contents of LISTENER.ORA file as it should list host name, protocol and listening port. You've mentioned that your problem is inability to acces database from the web server. Normally web server should be sitting in insulated DMZ environmemt, and there *should* be a firewall betweeen database and your web server. May be that's the part you are not aware of and/or not under your control, or it might happen that somebody changed firewall rules leaving your SQL*Net sessions on dry. If you do have DMZ, you should either have SQL*Net aware firewall or you could force Oracle to use static port (look for Metalink Note: 66382.1) as normally SQL*Net ports are dynamically negotiated, and only initial connection negotiation starts on port 1521. Branimir -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Branimir Petrovic INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Damien Babilon INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Listener problem on one client computer
Damien Your gesture is appreciated. It is a must that such solutions are shared with the list members. GovindanK Thank you very mutch for your replys, Today I finally found the problem. The traceroute shows the good route, but a Ms Proxy Client installed on the server blocked the request apparently. Just disabling it resolve everything. Damien Damien wrote: I have to do netstat -a on the webserver or on the Oracle server? Listener.ora is on the oracle server or on the webserver? I don't have any access on the oracle server and nobody can help on this side. Best regards, Damien - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Tuesday, September 02, 2003 9:14 PM The ports are the same, I've checked the tnsnames.ora files and copied pasted the content of the box who work on the web server. Still same prob. How can I check if i can open the port? It's a Win2000 server. To see if your Win2K server listens on port 1521 open MSDOS 'box' and type: C:\netstat -n Among (many) other things you should see something of this sort: Active Connections Proto Local Address Foreign AddressState TCP192.168.200.38:1031192.168.200.38:1521ESTABLISHED TCP192.168.200.38:1521192.168.200.38:1031ESTABLISHED You could also check contents of LISTENER.ORA file as it should list host name, protocol and listening port. You've mentioned that your problem is inability to acces database from the web server. Normally web server should be sitting in insulated DMZ environmemt, and there *should* be a firewall betweeen database and your web server. May be that's the part you are not aware of and/or not under your control, or it might happen that somebody changed firewall rules leaving your SQL*Net sessions on dry. If you do have DMZ, you should either have SQL*Net aware firewall or you could force Oracle to use static port (look for Metalink Note: 66382.1) as normally SQL*Net ports are dynamically negotiated, and only initial connection negotiation starts on port 1521. Branimir -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Branimir Petrovic INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Damien Babilon INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: GovindanK INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Listener problem on one client computer
The database server. This has been run FROM de web server. Damien - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Tuesday, September 02, 2003 6:34 PM Damien, What does 200.XX.101.XX refer to, your WEB server or the database server?? Dick Goulet Senior Oracle DBA Oracle Certified 8i DBA -Original Message- Sent: Tuesday, September 02, 2003 8:30 AM To: Multiple recipients of list ORACLE-L I have no access on the Oracle server, then I can't check the tnsnames.ora on it, but they are the sames on both tested clients. Best regards, Damien - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Tuesday, September 02, 2003 1:14 PM Hi Damien, have you checked tnsnames.ora on both boxes? Maybe there's a different port or something in the one on the working computer. That would give the exact error you posted. hth, Guido [EMAIL PROTECTED] 02.09.2003 12.59 Uhr Hi everybody, I'm new to the list, I don't know anything about oracle. I have make a script to get some informations by stored procedures on a remote server. I can't access this server, and can't get logs from it. Since 5 days, I have a tns-listener problem with this server. He did'n reply anymore. This problems occurs only from one machine (my web server from where the strored procedure are executed) I've tryed from another computer into the lan and I get responses from the server. Here is the output from tnsping: TNS Ping Utility for 32-bit Windows: Version 8.1.7.0.0 - Production on 02-SEP-2003 11:11:41 (c) Copyright 1997 Oracle Corporation. All rights reserved. Attempting to contact (ADDRESS=(PROTOCOL=TCP)(HOST=200.XX.101.XX)(PORT=1521)) TNS-12541: TNS:no listener The tracert output are the sames on the working box the web server. Please, help me... I don't know what to do ! On my side (web server) nothing has been changed since 5 days. Best regards and thank's in advance, Damien -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Guido Konsolke INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Damien INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Goulet, Dick INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Damien INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Listener problem on one client computer
I have to do netstat -a on the webserver or on the Oracle server? Listener.ora is on the oracle server or on the webserver? I don't have any access on the oracle server and nobody can help on this side. Best regards, Damien - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Tuesday, September 02, 2003 9:14 PM The ports are the same, I've checked the tnsnames.ora files and copied pasted the content of the box who work on the web server. Still same prob. How can I check if i can open the port? It's a Win2000 server. To see if your Win2K server listens on port 1521 open MSDOS 'box' and type: C:\netstat -n Among (many) other things you should see something of this sort: Active Connections Proto Local Address Foreign AddressState TCP192.168.200.38:1031192.168.200.38:1521ESTABLISHED TCP192.168.200.38:1521192.168.200.38:1031ESTABLISHED You could also check contents of LISTENER.ORA file as it should list host name, protocol and listening port. You've mentioned that your problem is inability to acces database from the web server. Normally web server should be sitting in insulated DMZ environmemt, and there *should* be a firewall betweeen database and your web server. May be that's the part you are not aware of and/or not under your control, or it might happen that somebody changed firewall rules leaving your SQL*Net sessions on dry. If you do have DMZ, you should either have SQL*Net aware firewall or you could force Oracle to use static port (look for Metalink Note: 66382.1) as normally SQL*Net ports are dynamically negotiated, and only initial connection negotiation starts on port 1521. Branimir -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Branimir Petrovic INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Damien INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Listener problem on one client computer
Good idea, here is the output of my telnet: C:\telnet 200.XX.101.XX 1521 Connecting To 200.XX.101.37...Could not open a connection to host on port 1521 : Connect failed C:\telnet 200.55.101.XX 1526 Connecting To 200.XX.101.XX...Could not open a connection to host on port 1526 : Connect failed Ping did'n work... maybe because port 8 is closed on the oracle server. - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Tuesday, September 02, 2003 9:44 PM Wolfgang, if I were him, I would first try with ping and telnet to the port. That can be any number of things. For instance, SA might have changed the IP address of the box and the name server and his PC is not updated and so the tns descriptor is desperately trying to cajole network printer into providing a connection on port 1521. I've actually had such a case. It's a very good thing that the fire alarms are usually not accessible by using the TCP protocol. -- Mladen Gogala Oracle DBA -Original Message- Wolfgang Breitling Sent: Tuesday, September 02, 2003 3:15 PM To: Multiple recipients of list ORACLE-L Is there a sqlnet.ora file on the PC that can connect? If so copy that as well. Maybe that pc is not even using the tnsnames.ora. At 10:44 AM 9/2/2003 -0800, you wrote: TNSPING sends a message to some host on (in your case) port 1521 and finds no program listening on this port and answering. There are several possibilities : o You are addressing the wrong port. Check on which one you are 'talking' from the other machine, o Or you are prevented from opening a connection on port 1521 from your machine HTH, The ports are the same, I've checked the tnsnames.ora files and copied pasted the content of the box who work on the web server. Still same prob. How can I check if i can open the port? It's a Win2000 server. Wolfgang Breitling Oracle7, 8, 8i, 9i OCP DBA Centrex Consulting Corporation http://www.centrexcc.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Wolfgang Breitling INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). Note: This message is for the named person's use only. It may contain confidential, proprietary or legally privileged information. No confidentiality or privilege is waived or lost by any mistransmission. If you receive this message in error, please immediately delete it and all copies of it from your system, destroy any hard copies of it and notify the sender. You must not, directly or indirectly, use, disclose, distribute, print, or copy any part of this message if you are not the intended recipient. Wang Trading LLC and any of its subsidiaries each reserve the right to monitor all e-mail communications through its networks. Any views expressed in this message are those of the individual sender, except where the message states otherwise and the sender is authorized to state them to be the views of any such entity. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Mladen Gogala INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Damien INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Listener problem on one client computer
Hi everybody, I'm new to the list, I don't know anything about oracle. I have make a script to get some informations by stored procedures on a remote server. I can't access this server, and can't get logs from it. Since 5 days, I have a tns-listener problem with this server. He did'n reply anymore. This problems occurs only from one machine (my web server from where the strored procedure are executed) I've tryed from another computer into the lan and I get responses from the server. Here is the output from tnsping: TNS Ping Utility for 32-bit Windows: Version 8.1.7.0.0 - Production on 02-SEP-2003 11:11:41 (c) Copyright 1997 Oracle Corporation. All rights reserved. Attempting to contact (ADDRESS=(PROTOCOL=TCP)(HOST=200.XX.101.XX)(PORT=1521)) TNS-12541: TNS:no listener The tracert output are the sames on the working box the web server. Please, help me... I don't know what to do ! On my side (web server) nothing has been changed since 5 days. Best regards and thank's in advance, Damien -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Damien INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Listener problem on one client computer
Hi Damien, have you checked tnsnames.ora on both boxes? Maybe there's a different port or something in the one on the working computer. That would give the exact error you posted. hth, Guido [EMAIL PROTECTED] 02.09.2003 12.59 Uhr Hi everybody, I'm new to the list, I don't know anything about oracle. I have make a script to get some informations by stored procedures on a remote server. I can't access this server, and can't get logs from it. Since 5 days, I have a tns-listener problem with this server. He did'n reply anymore. This problems occurs only from one machine (my web server from where the strored procedure are executed) I've tryed from another computer into the lan and I get responses from the server. Here is the output from tnsping: TNS Ping Utility for 32-bit Windows: Version 8.1.7.0.0 - Production on 02-SEP-2003 11:11:41 (c) Copyright 1997 Oracle Corporation. All rights reserved. Attempting to contact (ADDRESS=(PROTOCOL=TCP)(HOST=200.XX.101.XX)(PORT=1521)) TNS-12541: TNS:no listener The tracert output are the sames on the working box the web server. Please, help me... I don't know what to do ! On my side (web server) nothing has been changed since 5 days. Best regards and thank's in advance, Damien -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Guido Konsolke INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Listener problem on one client computer
I have no access on the Oracle server, then I can't check the tnsnames.ora on it, but they are the sames on both tested clients. Best regards, Damien - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Tuesday, September 02, 2003 1:14 PM Hi Damien, have you checked tnsnames.ora on both boxes? Maybe there's a different port or something in the one on the working computer. That would give the exact error you posted. hth, Guido [EMAIL PROTECTED] 02.09.2003 12.59 Uhr Hi everybody, I'm new to the list, I don't know anything about oracle. I have make a script to get some informations by stored procedures on a remote server. I can't access this server, and can't get logs from it. Since 5 days, I have a tns-listener problem with this server. He did'n reply anymore. This problems occurs only from one machine (my web server from where the strored procedure are executed) I've tryed from another computer into the lan and I get responses from the server. Here is the output from tnsping: TNS Ping Utility for 32-bit Windows: Version 8.1.7.0.0 - Production on 02-SEP-2003 11:11:41 (c) Copyright 1997 Oracle Corporation. All rights reserved. Attempting to contact (ADDRESS=(PROTOCOL=TCP)(HOST=200.XX.101.XX)(PORT=1521)) TNS-12541: TNS:no listener The tracert output are the sames on the working box the web server. Please, help me... I don't know what to do ! On my side (web server) nothing has been changed since 5 days. Best regards and thank's in advance, Damien -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Guido Konsolke INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Damien INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Listener problem on one client computer
Hi everybody, I'm new to the list, I don't know anything about oracle. I have make a script to get some informations by stored procedures on a remote server. I can't access this server, and can't get logs from it. Since 5 days, I have a tns-listener problem with this server. He did'n reply anymore. This problems occurs only from one machine (my web server from where the strored procedure are executed) I've tryed from another computer into the lan and I get responses from the server. Here is the output from tnsping: TNS Ping Utility for 32-bit Windows: Version 8.1.7.0.0 - Production on 02-SEP-2003 11:11:41 (c) Copyright 1997 Oracle Corporation. All rights reserved. Attempting to contact TNS-12541: TNS:no listener The tracert output are the sames on the working box the web server. Please, help me... I don't know what to do ! On my side (web server) nothing has been changed since 5 days. Best regards and thank's in advance, Damien TNSPING sends a message to some host on (in your case) port 1521 and finds no program listening on this port and answering. There are several possibilities : o You are addressing the wrong port. Check on which one you are 'talking' from the other machine, o Or you are prevented from opening a connection on port 1521 from your machine HTH, Stephane Faroult Oriole -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Stephane Faroult INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Listener problem on one client computer
Damien, What does 200.XX.101.XX refer to, your WEB server or the database server?? Dick Goulet Senior Oracle DBA Oracle Certified 8i DBA -Original Message- Sent: Tuesday, September 02, 2003 8:30 AM To: Multiple recipients of list ORACLE-L I have no access on the Oracle server, then I can't check the tnsnames.ora on it, but they are the sames on both tested clients. Best regards, Damien - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Tuesday, September 02, 2003 1:14 PM Hi Damien, have you checked tnsnames.ora on both boxes? Maybe there's a different port or something in the one on the working computer. That would give the exact error you posted. hth, Guido [EMAIL PROTECTED] 02.09.2003 12.59 Uhr Hi everybody, I'm new to the list, I don't know anything about oracle. I have make a script to get some informations by stored procedures on a remote server. I can't access this server, and can't get logs from it. Since 5 days, I have a tns-listener problem with this server. He did'n reply anymore. This problems occurs only from one machine (my web server from where the strored procedure are executed) I've tryed from another computer into the lan and I get responses from the server. Here is the output from tnsping: TNS Ping Utility for 32-bit Windows: Version 8.1.7.0.0 - Production on 02-SEP-2003 11:11:41 (c) Copyright 1997 Oracle Corporation. All rights reserved. Attempting to contact (ADDRESS=(PROTOCOL=TCP)(HOST=200.XX.101.XX)(PORT=1521)) TNS-12541: TNS:no listener The tracert output are the sames on the working box the web server. Please, help me... I don't know what to do ! On my side (web server) nothing has been changed since 5 days. Best regards and thank's in advance, Damien -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Guido Konsolke INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Damien INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Goulet, Dick INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Listener problem on one client computer
he should try something like telnet server 1521 If the server is found but connection is immediately refused, then listener is not started on the server or is started at another port. If the connection appears to be hanging, then there is a server on port 1521, but there is a problem with it. -- Mladen Gogala Oracle DBA -Original Message- Goulet, Dick Sent: Tuesday, September 02, 2003 12:34 PM To: Multiple recipients of list ORACLE-L Damien, What does 200.XX.101.XX refer to, your WEB server or the database server?? Dick Goulet Senior Oracle DBA Oracle Certified 8i DBA -Original Message- Sent: Tuesday, September 02, 2003 8:30 AM To: Multiple recipients of list ORACLE-L I have no access on the Oracle server, then I can't check the tnsnames.ora on it, but they are the sames on both tested clients. Best regards, Damien - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Tuesday, September 02, 2003 1:14 PM Hi Damien, have you checked tnsnames.ora on both boxes? Maybe there's a different port or something in the one on the working computer. That would give the exact error you posted. hth, Guido [EMAIL PROTECTED] 02.09.2003 12.59 Uhr Hi everybody, I'm new to the list, I don't know anything about oracle. I have make a script to get some informations by stored procedures on a remote server. I can't access this server, and can't get logs from it. Since 5 days, I have a tns-listener problem with this server. He did'n reply anymore. This problems occurs only from one machine (my web server from where the strored procedure are executed) I've tryed from another computer into the lan and I get responses from the server. Here is the output from tnsping: TNS Ping Utility for 32-bit Windows: Version 8.1.7.0.0 - Production on 02-SEP-2003 11:11:41 (c) Copyright 1997 Oracle Corporation. All rights reserved. Attempting to contact (ADDRESS=(PROTOCOL=TCP)(HOST=200.XX.101.XX)(PORT=1521)) TNS-12541: TNS:no listener The tracert output are the sames on the working box the web server. Please, help me... I don't know what to do ! On my side (web server) nothing has been changed since 5 days. Best regards and thank's in advance, Damien -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Guido Konsolke INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Damien INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Goulet, Dick INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). Note: This message is for the named person's use only. It may contain confidential, proprietary or legally privileged information. No confidentiality or privilege is waived or lost by any mistransmission. If you receive this message in error, please immediately delete it and all copies of it from your system, destroy any hard copies of it and notify the sender. You must not, directly or indirectly, use, disclose, distribute, print, or copy any part of this message if you are not the intended recipient. Wang Trading LLC and any of its subsidiaries each reserve the right to monitor all e-mail communications through its networks. Any views expressed in this message are those of the individual
Re: Listener problem on one client computer
TNSPING sends a message to some host on (in your case) port 1521 and finds no program listening on this port and answering. There are several possibilities : o You are addressing the wrong port. Check on which one you are 'talking' from the other machine, o Or you are prevented from opening a connection on port 1521 from your machine HTH, The ports are the same, I've checked the tnsnames.ora files and copied pasted the content of the box who work on the web server. Still same prob. How can I check if i can open the port? It's a Win2000 server. Best regards, Damien Stephane Faroult Oriole -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Stephane Faroult INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Damien INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Listener problem on one client computer
The ports are the same, I've checked the tnsnames.ora files and copied pasted the content of the box who work on the web server. Still same prob. How can I check if i can open the port? It's a Win2000 server. To see if your Win2K server listens on port 1521 open MSDOS 'box' and type: C:\netstat -n Among (many) other things you should see something of this sort: Active Connections Proto Local Address Foreign AddressState TCP192.168.200.38:1031192.168.200.38:1521ESTABLISHED TCP192.168.200.38:1521192.168.200.38:1031ESTABLISHED You could also check contents of LISTENER.ORA file as it should list host name, protocol and listening port. You've mentioned that your problem is inability to acces database from the web server. Normally web server should be sitting in insulated DMZ environmemt, and there *should* be a firewall betweeen database and your web server. May be that's the part you are not aware of and/or not under your control, or it might happen that somebody changed firewall rules leaving your SQL*Net sessions on dry. If you do have DMZ, you should either have SQL*Net aware firewall or you could force Oracle to use static port (look for Metalink Note: 66382.1) as normally SQL*Net ports are dynamically negotiated, and only initial connection negotiation starts on port 1521. Branimir -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Branimir Petrovic INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Listener problem on one client computer
Is there a sqlnet.ora file on the PC that can connect? If so copy that as well. Maybe that pc is not even using the tnsnames.ora. At 10:44 AM 9/2/2003 -0800, you wrote: TNSPING sends a message to some host on (in your case) port 1521 and finds no program listening on this port and answering. There are several possibilities : o You are addressing the wrong port. Check on which one you are 'talking' from the other machine, o Or you are prevented from opening a connection on port 1521 from your machine HTH, The ports are the same, I've checked the tnsnames.ora files and copied pasted the content of the box who work on the web server. Still same prob. How can I check if i can open the port? It's a Win2000 server. Wolfgang Breitling Oracle7, 8, 8i, 9i OCP DBA Centrex Consulting Corporation http://www.centrexcc.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Wolfgang Breitling INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Listener problem on one client computer
Wolfgang, if I were him, I would first try with ping and telnet to the port. That can be any number of things. For instance, SA might have changed the IP address of the box and the name server and his PC is not updated and so the tns descriptor is desperately trying to cajole network printer into providing a connection on port 1521. I've actually had such a case. It's a very good thing that the fire alarms are usually not accessible by using the TCP protocol. -- Mladen Gogala Oracle DBA -Original Message- Wolfgang Breitling Sent: Tuesday, September 02, 2003 3:15 PM To: Multiple recipients of list ORACLE-L Is there a sqlnet.ora file on the PC that can connect? If so copy that as well. Maybe that pc is not even using the tnsnames.ora. At 10:44 AM 9/2/2003 -0800, you wrote: TNSPING sends a message to some host on (in your case) port 1521 and finds no program listening on this port and answering. There are several possibilities : o You are addressing the wrong port. Check on which one you are 'talking' from the other machine, o Or you are prevented from opening a connection on port 1521 from your machine HTH, The ports are the same, I've checked the tnsnames.ora files and copied pasted the content of the box who work on the web server. Still same prob. How can I check if i can open the port? It's a Win2000 server. Wolfgang Breitling Oracle7, 8, 8i, 9i OCP DBA Centrex Consulting Corporation http://www.centrexcc.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Wolfgang Breitling INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). Note: This message is for the named person's use only. It may contain confidential, proprietary or legally privileged information. No confidentiality or privilege is waived or lost by any mistransmission. If you receive this message in error, please immediately delete it and all copies of it from your system, destroy any hard copies of it and notify the sender. You must not, directly or indirectly, use, disclose, distribute, print, or copy any part of this message if you are not the intended recipient. Wang Trading LLC and any of its subsidiaries each reserve the right to monitor all e-mail communications through its networks. Any views expressed in this message are those of the individual sender, except where the message states otherwise and the sender is authorized to state them to be the views of any such entity. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Mladen Gogala INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Listener problem on one client computer
May be Metalink note 111910.1 will help you. HTH GovindanK Hi everybody, I'm new to the list, I don't know anything about oracle. I have make a script to get some informations by stored procedures on a remote server. I can't access this server, and can't get logs from it. Since 5 days, I have a tns-listener problem with this server. He did'n reply anymore. This problems occurs only from one machine (my web server from where the strored procedure are executed) I've tryed from another computer into the lan and I get responses from the server. Here is the output from tnsping: TNS Ping Utility for 32-bit Windows: Version 8.1.7.0.0 - Production on 02-SEP-2003 11:11:41 (c) Copyright 1997 Oracle Corporation. All rights reserved. Attempting to contact (ADDRESS=(PROTOCOL=TCP)(HOST=200.XX.101.XX)(PORT=1521)) TNS-12541: TNS:no listener The tracert output are the sames on the working box the web server. Please, help me... I don't know what to do ! On my side (web server) nothing has been changed since 5 days. Best regards and thank's in advance, Damien -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Damien INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Listener problem ....
Joshua, This is not a problem. From Oracle 8i onwards, the instance running can register itself with the listener running on the local host without any listener.ora file. Or, if the listener.ora is defined and the listener runs on the default port, 1521. In this case you have one handler for the onedefined in listener.ora file (under SID_LIST parameter) an anotherfor the onethat hasbeen registered automatically. HTH. Arup Nanda - Original Message - From: Joshua Becker To: Multiple recipients of list ORACLE-L Sent: Monday, January 20, 2003 11:59 PM Subject: Listener problem Hi all, I am wondering is there something wrong with my listener settings. I mean when I type LSNRCTL servicesConnecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=test01u)(PORT=1521)))Services Summary...Service "TEST2" has 2 instance(s). Instance "TEST2", status UNKNOWN, has 1 handler(s) for this service... Handler(s): "DEDICATED" established:0 refused:0 LOCAL SERVER Instance "TEST2", status READY, has 1 handler(s) for this service... Handler(s): "DEDICATED" established:1 refused:0 state:ready LOCAL SERVERService "TEST1" has 2 instance(s). Instance "TEST1", status UNKNOWN, has 1 handler(s) for this service... Handler(s): "DEDICATED" established:0 refused:0 LOCAL SERVER Instance "TEST1",! status READY, has 1 handler(s) for this service... Handler(s): "DEDICATED" established:0 refused:0 state:ready LOCAL SERVERService "TEST3" has 2 instance(s). Instance "TEST3", status UNKNOWN, has 1 handler(s) for this service... Handler(s): "DEDICATED" established:0 refused:0 LOCAL SERVER Instance "TEST3", status READY, has 1 handler(s) for this service... Handler(s): "DEDICATED" established:0 refused:0 state:ready LOCAL SERVER Why it shows service has 2 instances? I am using Sun Solaris with Oracle 8.1.7 and 9.2. rgds, Joshua Gratis e-mail resten av livet på: www.yahoo.se/mailBusenkelt!
Listener problem ....
Hi all, I am wondering is there something wrong with my listener settings. I mean when I type LSNRCTL servicesConnecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=test01u)(PORT=1521)))Services Summary...Service "TEST2" has 2 instance(s). Instance "TEST2", status UNKNOWN, has 1 handler(s) for this service... Handler(s): "DEDICATED" established:0 refused:0 LOCAL SERVER Instance "TEST2", status READY, has 1 handler(s) for this service... Handler(s): "DEDICATED" established:1 refused:0 state:ready LOCAL SERVERService "TEST1" has 2 instance(s). Instance "TEST1", status UNKNOWN, has 1 handler(s) for this service... Handler(s): "DEDICATED" established:0 refused:0 LOCAL SERVER Instance "TEST1", status READY, has 1 handler(s) for this service... Handler(s): "DEDICATED" established:0 refused:0 state:ready LOCAL SERVERService "TEST3" has 2 instance(s). Instance "TEST3", status UNKNOWN, has 1 handler(s) for this service... Handler(s): "DEDICATED" established:0 refused:0 LOCAL SERVER Instance "TEST3", status READY, has 1 handler(s) for this service... Handler(s): "DEDICATED" established:0 refused:0 state:ready LOCAL SERVER Why it shows service has 2 instances? I am using Sun Solaris with Oracle 8.1.7 and 9.2. rgds, JoshuaGratis e-mail resten av livet på: www.yahoo.se/mail Busenkelt!
Instances cannot be together LISTENER PROBLEM??
Hi, I have a Win2000 Server with a 8.1.7. ora database with an instance called XXX, after that I've created a new one, called YYY. I open both databases without problems but 45 min then both instances are down. I open the X instance, then the Y instance, checked the status of the listener: Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC0))) STATUS of the LISTENER Alias LISTENER Version TNSLSNR for 32-bit Windows: Version 8.1.7.0.0 - Prod tion Start Date12-NOV-2002 17:06:22 Uptime0 days 0 hr. 0 min. 0 sec Trace Level off Security OFF SNMP OFF Listener Parameter File D:\oracle\ora81\network\admin\listener.ora Listener Log File D:\oracle\ora81\network\log\listener.log Services Summary... PLSExtProchas 1 service handler(s) XXX has 1 service handler(s) YYY has 1 service handler(s) The command completed successfully Suddenly appears a DOS screen (at the server) executing several times the command: D:\jdk1.3.1\bin\javac Checking the status again: Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC0))) STATUS of the LISTENER Alias LISTENER Version TNSLSNR for 32-bit Windows: Version 8.1.7.0.0 - Prod tion Start Date12-NOV-2002 17:06:22 Uptime0 days 0 hr. 9 min. 59 sec Trace Level off Security OFF SNMP OFF Listener Parameter File D:\oracle\ora81\network\admin\listener.ora Listener Log File D:\oracle\ora81\network\log\listener.log Services Summary... PLSExtProchas 1 service handler(s) XXX has 1 service handler(s) YYYhas 1 service handler(s) YYYhas 2 service handler(s) The command completed successfully The databases are down 15 minutes after that. I am not sure if the problem is with the listener, is this a normal behavior? Its normal having 3 services for the same instance? I've never used the jrun machine, is normal that executes is this way several times every x minutes? I have the following error at the SQLNET.log every minute (almost at the same the time javac runs): Fatal NI connect error 12640, connecting to: (DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq))) VERSION INFORMATION: TNS for 32-bit Windows: Version 8.1.7.0.0 - Production Oracle Bequeath NT Protocol Adapter for 32-bit Windows: Version 8.1.7.0.0 - Production Time: 12-NOV-2002 17:29:26 Tracing not turned on. Tns error struct: nr err code: 0 ns main err code: 12640 TNS-12640: Authentication adapter initialization failed ns secondary err code: 0 nt main err code: 0 nt secondary err code: 0 nt OS err code: 0 What do I need to check to detect what is shutting down the DB's? TIA Gabriel __ Do you Yahoo!? U2 on LAUNCH - Exclusive greatest hits videos http://launch.yahoo.com/u2 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Gabriel Aragon INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Listener Problem
Unfortunately, our company is large enough that no one ever really has to admit to anything because it is simply too difficult to run down the perpetrators. The listener did start. Some users could connect to the databases from one server but not another. We think it was related to an intrusion software install, but the back out of the install did not fix the problem. There was a giant meeting of everyone who might have any impact on the box and minutes after the meeting ended everything was working again. My guess is that someone in the meeting recognized a mistake and corrected it without saying anything. So, we will never know the true cause. --- #34;Jesse, Rich#34; lt;[EMAIL PROTECTED]gt; wrote: gt; As luck would have it, we just went through a gt; similar problem. gt; gt; Does the listener actually startup? Can you stop gt; and restart it manually gt; using #34;lsnrctl#34;? gt; gt; Ours wouldn't. We tracked it down to two problems, gt; both security related. gt; The one that was hampering our listener was a change gt; in /etc/nsswitch.conf gt; that caused a change in the way that the listener gt; tried to listen on the gt; port. Specifically, look for differences in the gt; #34;protocols#34; line and the gt; #34;services#34; line. Also, potentially, the #34;ipnodes#34; gt; line. gt; gt; We were installing LDAP and had changed these lines gt; to #34;ldap gt; [NOTFOUND=return] files#34;, but the listener just gt; didn't like it, so we gt; changed them back to just #34;files#34;. Also, the only gt; time we'd see a problem gt; is in the start and stop of the listener. If we gt; changed the files back to gt; #34;ldap...#34; while the listener was up, connections gt; worked fine. We just gt; couldn't start it back up if it was shutdown. gt; gt; Barring this, check for security differences in your gt; #34;bin#34; and #34;network#34; dir gt; trees under $ORACLE_HOME. Check for owner, group gt; and protection bits. gt; gt; HTH! GL! :) gt; gt; Rich gt; gt; gt; Rich Jesse System/Database gt; Administrator gt; [EMAIL PROTECTED] Quad/Tech gt; International, Sussex, WI USA gt; gt; gt; gt; -Original Message- gt; gt; From: Peter Barnett [mailto:[EMAIL PROTECTED]] gt; gt; Sent: Wednesday, October 09, 2002 2:09 PM gt; gt; To: Multiple recipients of list ORACLE-L gt; gt; Subject: Listener Problem gt; gt; gt; gt; gt; gt; Yesterday we had a cpu panic followed by a gt; spontaneous gt; gt; reboot of a Sun E6000 server. When the server and gt; gt; databases came back on line we were getting 'no gt; gt; listener' errors from several Unix servers but not gt; all gt; gt; of them. We also lost connectivity between the gt; gt; mainframe and the databases on the affected gt; server. gt; gt; Those that failed were consistent, those that gt; conected gt; gt; were also consistent. gt; gt; gt; gt; The Unix Admin captured the following lines from a gt; gt; netsta -an command: gt; gt; gt; gt; Following line is from dragon - the server that gt; has gt; gt; the TNSLISTENER on only one interface gt; gt; gt; gt; 161.208.1.138.1521 *.* 0 gt; 0 gt; gt; 0 0 LISTEN gt; gt; gt; gt; gt; gt; Following line is from beowulf - the server that gt; has gt; gt; the TNSLISTENER on all interfaces gt; gt; gt; gt; *.1521 *.* 0 gt; 0 gt; gt; 0 0 LISTEN gt; gt; gt; gt; He is focusing the ip address binding to the gt; oracle gt; gt; port on one server but using a wild card for the gt; gt; other. gt; gt; gt; gt; We have a tar open for this but so far, they have gt; not gt; gt; been too helpful. gt; gt; gt; -- gt; Please see the official ORACLE-L FAQ: gt; http://www.orafaq.com gt; -- gt; Author: Jesse, Rich gt; INET: [EMAIL PROTECTED] gt; gt; Fat City Network Services-- 858-538-5051 gt; http://www.fatcity.com gt; San Diego, California-- Mailing list and web gt; hosting services gt; - gt; To REMOVE yourself from this mailing list, send an gt; E-Mail message gt; to: [EMAIL PROTECTED] (note EXACT spelling of gt; 'ListGuru') and in gt; the message BODY, include a line containing: UNSUB gt; ORACLE-L gt; (or the name of mailing list you want to be removed gt; from). You may gt; also send the HELP command for other information gt; (like subscribing). = Pete Barnett Lead Database Administrator The Regence Group [EMAIL PROTECTED] __ Do you Yahoo!? Faith Hill - Exclusive Performances, Videos More http://faith.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Peter Barnett INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE
Listener Problem
Yesterday we had a cpu panic followed by a spontaneous reboot of a Sun E6000 server. When the server and databases came back on line we were getting 'no listener' errors from several Unix servers but not all of them. We also lost connectivity between the mainframe and the databases on the affected server. Those that failed were consistent, those that conected were also consistent. The Unix Admin captured the following lines from a netsta -an command: Following line is from dragon - the server that has the TNSLISTENER on only one interface 161.208.1.138.1521 *.*0 0 0 0 LISTEN Following line is from beowulf - the server that has the TNSLISTENER on all interfaces *.1521 *.*0 0 0 0 LISTEN He is focusing the ip address binding to the oracle port on one server but using a wild card for the other. We have a tar open for this but so far, they have not been too helpful. = Pete Barnett Lead Database Administrator The Regence Group [EMAIL PROTECTED] __ Do you Yahoo!? Faith Hill - Exclusive Performances, Videos More http://faith.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Peter Barnett INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Listener Problem
Magically, it's fixed. No one has 'fessed up' but it is definietly not an Oracle problem. --- Peter Barnett [EMAIL PROTECTED] wrote: Yesterday we had a cpu panic followed by a spontaneous reboot of a Sun E6000 server. When the server and databases came back on line we were getting 'no listener' errors from several Unix servers but not all of them. We also lost connectivity between the mainframe and the databases on the affected server. Those that failed were consistent, those that conected were also consistent. The Unix Admin captured the following lines from a netsta -an command: Following line is from dragon - the server that has the TNSLISTENER on only one interface 161.208.1.138.1521 *.*0 0 0 0 LISTEN Following line is from beowulf - the server that has the TNSLISTENER on all interfaces *.1521 *.*0 0 0 0 LISTEN He is focusing the ip address binding to the oracle port on one server but using a wild card for the other. We have a tar open for this but so far, they have not been too helpful. = Pete Barnett Lead Database Administrator The Regence Group [EMAIL PROTECTED] __ Do you Yahoo!? Faith Hill - Exclusive Performances, Videos More http://faith.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Peter Barnett INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). = Pete Barnett Lead Database Administrator The Regence Group [EMAIL PROTECTED] __ Do you Yahoo!? Faith Hill - Exclusive Performances, Videos More http://faith.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Peter Barnett INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Listener Problem
As luck would have it, we just went through a similar problem. Does the listener actually startup? Can you stop and restart it manually using lsnrctl? Ours wouldn't. We tracked it down to two problems, both security related. The one that was hampering our listener was a change in /etc/nsswitch.conf that caused a change in the way that the listener tried to listen on the port. Specifically, look for differences in the protocols line and the services line. Also, potentially, the ipnodes line. We were installing LDAP and had changed these lines to ldap [NOTFOUND=return] files, but the listener just didn't like it, so we changed them back to just files. Also, the only time we'd see a problem is in the start and stop of the listener. If we changed the files back to ldap... while the listener was up, connections worked fine. We just couldn't start it back up if it was shutdown. Barring this, check for security differences in your bin and network dir trees under $ORACLE_HOME. Check for owner, group and protection bits. HTH! GL! :) Rich Rich Jesse System/Database Administrator [EMAIL PROTECTED] Quad/Tech International, Sussex, WI USA -Original Message- From: Peter Barnett [mailto:[EMAIL PROTECTED]] Sent: Wednesday, October 09, 2002 2:09 PM To: Multiple recipients of list ORACLE-L Subject: Listener Problem Yesterday we had a cpu panic followed by a spontaneous reboot of a Sun E6000 server. When the server and databases came back on line we were getting 'no listener' errors from several Unix servers but not all of them. We also lost connectivity between the mainframe and the databases on the affected server. Those that failed were consistent, those that conected were also consistent. The Unix Admin captured the following lines from a netsta -an command: Following line is from dragon - the server that has the TNSLISTENER on only one interface 161.208.1.138.1521 *.*0 0 0 0 LISTEN Following line is from beowulf - the server that has the TNSLISTENER on all interfaces *.1521 *.*0 0 0 0 LISTEN He is focusing the ip address binding to the oracle port on one server but using a wild card for the other. We have a tar open for this but so far, they have not been too helpful. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jesse, Rich INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Listener Problem
Hmmm...check the dates on your /etc/*.conf files! :) Rich Rich Jesse System/Database Administrator [EMAIL PROTECTED] Quad/Tech International, Sussex, WI USA -Original Message- From: Peter Barnett [mailto:[EMAIL PROTECTED]] Sent: Wednesday, October 09, 2002 3:34 PM To: Multiple recipients of list ORACLE-L Subject: Re: Listener Problem Magically, it's fixed. No one has 'fessed up' but it is definietly not an Oracle problem. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jesse, Rich INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: listener problem ???
Do you have a service like Oracle_HOMETNSListener? I assume that you must. You don't need a separate listener for each instance. What does the TNSNames.ora entry for LMANAGER look like? Leslie Lu leslie_y_lu To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] @yahoo.com cc: Sent by: rootSubject: listener problem ??? 09/19/2002 03:18 PM Please respond to ORACLE-L Hi all, I have a database LMANAGER (817 on win2000), it's on my local machine. I can log into it using svrmgrl. But when I connect using sqlplus, I got ORA-12541: TNS:no listener. LMANAGER is already in listener.ora file, and lsnrctl status shows LMANAGER is there: (c) Copyright 1998 Oracle Corporation. All rights reserved. Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC0))) STATUS of the LISTENER Alias LISTENER Version TNSLSNR for 32-bit Windows: Version 8.1.7.0.0 - Produ tion Start Date19-SEP-2002 12:01:44 Uptime0 days 0 hr. 5 min. 1 sec Trace Level off Security OFF SNMP OFF Listener Parameter File C:\oracle\oracle81\network\admin\listener.ora Listener Log File C:\oracle\oracle81\network\log\listener.log Services Summary... LMANAGER has 1 service handler(s) prod has 1 service handler(s) The command completed successfully However, I don't see a service in NT services like Oracle_HOMETNSListenerLMANAGER. How do I create it? Thank you in advance! Leslie __ Do you Yahoo!? New DSL Internet Access from SBC Yahoo! http://sbc.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Leslie Lu INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Thomas Day INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
listener problem ???
Hi all, I have a database LMANAGER (817 on win2000), it's on my local machine. I can log into it using svrmgrl. But when I connect using sqlplus, I got ORA-12541: TNS:no listener. LMANAGER is already in listener.ora file, and lsnrctl status shows LMANAGER is there: (c) Copyright 1998 Oracle Corporation. All rights reserved. Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC0))) STATUS of the LISTENER Alias LISTENER Version TNSLSNR for 32-bit Windows: Version 8.1.7.0.0 - Produ tion Start Date19-SEP-2002 12:01:44 Uptime0 days 0 hr. 5 min. 1 sec Trace Level off Security OFF SNMP OFF Listener Parameter File C:\oracle\oracle81\network\admin\listener.ora Listener Log File C:\oracle\oracle81\network\log\listener.log Services Summary... LMANAGER has 1 service handler(s) prod has 1 service handler(s) The command completed successfully However, I don't see a service in NT services like Oracle_HOMETNSListenerLMANAGER. How do I create it? Thank you in advance! Leslie __ Do you Yahoo!? New DSL Internet Access from SBC Yahoo! http://sbc.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Leslie Lu INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Listener problem in Oracle 8.1.5 for RH 6.2
Hi All I have problem related to listener. On my machine I have Oracle 8.1.5 on RH 6.2. When I issued the command $ lsnrctl I got the following error message lsnrctl: error in loading shared libraries: libskgxp8.so: cannot open shared object file: No such file or directory I have downloaded the library from rpmfind.net and installed it from root user on my machine. My file libskgxp8.so is located in $ORACLE_HOME/lib. However still when I say $ lsnrctl then I get the above error. Is that file is not used or what? I have also restarted my machine but it is still not working. I already have these settings in my .bash_profile. But it is not working. Does anyone has the solution for this problem? LD_LIBRARY_PATH=/u01/app/oracle/product/8.1.5/lib; export LD_LIBRARY_PATH Amol _ Click below to visit monsterindia.com and review jobs in India or Abroad http://monsterindia.rediff.com/jobs -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Nandu Garg INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Listener problem in Oracle 8.1.5 for RH 6.2
Amol - I think that you are on the right track, looking at LD_LIBRARY_PATH. Possibly you don't have that variable set just quite right, or it isn't set when you issue the lsnrctl. You can check the setting by entering env just before you issue lsnrctl. Try to check for extra characters or non-printing characters. Try to find someone that knows more about Unix to look over your shoulder. Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Friday, May 10, 2002 2:48 AM To: Multiple recipients of list ORACLE-L Hi All I have problem related to listener. On my machine I have Oracle 8.1.5 on RH 6.2. When I issued the command $ lsnrctl I got the following error message lsnrctl: error in loading shared libraries: libskgxp8.so: cannot open shared object file: No such file or directory I have downloaded the library from rpmfind.net and installed it from root user on my machine. My file libskgxp8.so is located in $ORACLE_HOME/lib. However still when I say $ lsnrctl then I get the above error. Is that file is not used or what? I have also restarted my machine but it is still not working. I already have these settings in my .bash_profile. But it is not working. Does anyone has the solution for this problem? LD_LIBRARY_PATH=/u01/app/oracle/product/8.1.5/lib; export LD_LIBRARY_PATH Amol _ Click below to visit monsterindia.com and review jobs in India or Abroad http://monsterindia.rediff.com/jobs -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Nandu Garg INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: DENNIS WILLIAMS INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
listener problem
Hi, I am doing a fresh install of oracle 8.1.6.0.0 on win2k and it hangs at the Net 8 configuration assistant at this step : Done parsing command line arguments.Net8 Configuration:Profile configuration complete.Net8 Listener Startup: Running Listener Control: D:\Oracle\Ora81\bin\lsnrctl start LISTENER when i try to kill this process and try to see the status as: D:\Oracle\Ora81\BINlsnrctl LSNRCTL for 32-bit Windows: Version 8.1.6.0.0 - Production on 22-AUG-2001 17:12: 00 (c) Copyright 1998, 1999, Oracle Corporation. All rights reserved. Welcome to LSNRCTL, type help for information. LSNRCTL status Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC0))) TNS-01103: Protocol specific component of the address is incorrectly specified TNS-12541: TNS:no listener TNS-12560: TNS:protocol adapter error TNS-00511: No listener 32-bit Windows Error: 2: No such file or directory and listener.ora looks like: # LISTENER.ORA Network Configuration File: D:\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 = my_machine)(PORT = 1521)) ) ) (DESCRIPTION = (PROTOCOL_STACK = (PRESENTATION = GIOP) (SESSION = RAW) ) (ADDRESS = (PROTOCOL = TCP)(HOST = my_machine)(PORT = 2481)) ) ) SID_LIST_LISTENER = (SID_LIST = (SID_DESC = (SID_NAME = PLSExtProc) (ORACLE_HOME = D:\Oracle\Ora81) (PROGRAM = extproc) ) ) I am not able to start , stop or create listener again... what might be the problem?? Thanks -Harvinder -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Harvinder Singh INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
listener problem......
Hi, I have configured 2 listeners one name listener(default) on port 1521 and listener1 on 1526 for same database... and specify port 1526 in local_listener in init.ora when default listerner on port 1521 is stopped while listener1 is up...when i try to run application i get error TNS-12541 no listener why is it trying to use listener on port 1521 while local_listener specified 1526... How to resolve the problem... Thanks Harvinder -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Harvinder Singh INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: listener problem......
Harvinder, Where is the application resolving the port from? Tnsnames / ONames? Check the port defined with the connect string in these destinations as they will be the ones who will identify which port the app goes to. HTH Shailesh -Original Message- Sent: Wednesday, July 25, 2001 4:39 PM To: Multiple recipients of list ORACLE-L Hi, I have configured 2 listeners one name listener(default) on port 1521 and listener1 on 1526 for same database... and specify port 1526 in local_listener in init.ora when default listerner on port 1521 is stopped while listener1 is up...when i try to run application i get error TNS-12541 no listener why is it trying to use listener on port 1521 while local_listener specified 1526... How to resolve the problem... Thanks Harvinder -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Harvinder Singh INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Yadav, Shailesh INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: listener problem......
Do you have the second port defined in your tnsnames.ora? -Original Message- From: Harvinder Singh [mailto:[EMAIL PROTECTED]] Sent: Wednesday, July 25, 2001 4:39 PM To: Multiple recipients of list ORACLE-L Subject: listener problem.. Hi, I have configured 2 listeners one name listener(default) on port 1521 and listener1 on 1526 for same database... and specify port 1526 in local_listener in init.ora when default listerner on port 1521 is stopped while listener1 is up...when i try to run application i get error TNS-12541 no listener why is it trying to use listener on port 1521 while local_listener specified 1526... How to resolve the problem... Thanks Harvinder -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Harvinder Singh INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Page, Bruce INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: listener problem......
PORT SPECIFIED IN TNSNAMES.ORA IS 1526 -Original Message- Sent: Wednesday, July 25, 2001 5:07 PM To: Multiple recipients of list ORACLE-L Harvinder, Where is the application resolving the port from? Tnsnames / ONames? Check the port defined with the connect string in these destinations as they will be the ones who will identify which port the app goes to. HTH Shailesh -Original Message- Sent: Wednesday, July 25, 2001 4:39 PM To: Multiple recipients of list ORACLE-L Hi, I have configured 2 listeners one name listener(default) on port 1521 and listener1 on 1526 for same database... and specify port 1526 in local_listener in init.ora when default listerner on port 1521 is stopped while listener1 is up...when i try to run application i get error TNS-12541 no listener why is it trying to use listener on port 1521 while local_listener specified 1526... How to resolve the problem... Thanks Harvinder -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Harvinder Singh INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Yadav, Shailesh INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Harvinder Singh INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: listener problem......
ONLY 1 PORT 1526 SPECIFIED IN TNSNAMES.ORA.. -Original Message- Sent: Wednesday, July 25, 2001 5:02 PM To: Multiple recipients of list ORACLE-L Do you have the second port defined in your tnsnames.ora? -Original Message- From: Harvinder Singh [mailto:[EMAIL PROTECTED]] Sent: Wednesday, July 25, 2001 4:39 PM To: Multiple recipients of list ORACLE-L Subject: listener problem.. Hi, I have configured 2 listeners one name listener(default) on port 1521 and listener1 on 1526 for same database... and specify port 1526 in local_listener in init.ora when default listerner on port 1521 is stopped while listener1 is up...when i try to run application i get error TNS-12541 no listener why is it trying to use listener on port 1521 while local_listener specified 1526... How to resolve the problem... Thanks Harvinder -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Harvinder Singh INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Page, Bruce INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Harvinder Singh INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: listener problem......
What are you trying to do? If you set up 2 listeners for the same database, the tnsnames.ora that is used to access it needs to have an entry pointing to that port and sid. -Original Message- From: Harvinder Singh [mailto:[EMAIL PROTECTED]] Sent: Wednesday, July 25, 2001 5:39 PM To: Multiple recipients of list ORACLE-L Subject: RE: listener problem.. ONLY 1 PORT 1526 SPECIFIED IN TNSNAMES.ORA.. -Original Message- Sent: Wednesday, July 25, 2001 5:02 PM To: Multiple recipients of list ORACLE-L Do you have the second port defined in your tnsnames.ora? -Original Message- From: Harvinder Singh [mailto:[EMAIL PROTECTED]] Sent: Wednesday, July 25, 2001 4:39 PM To: Multiple recipients of list ORACLE-L Subject: listener problem.. Hi, I have configured 2 listeners one name listener(default) on port 1521 and listener1 on 1526 for same database... and specify port 1526 in local_listener in init.ora when default listerner on port 1521 is stopped while listener1 is up...when i try to run application i get error TNS-12541 no listener why is it trying to use listener on port 1521 while local_listener specified 1526... How to resolve the problem... Thanks Harvinder -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Harvinder Singh INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Page, Bruce INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Harvinder Singh INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Page, Bruce INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Listener problem
I was wondering if you could help me debug a problem. I have the following tnsnames on an app server. And when the primary listener is down it does not attempt to connect to the second address. was.world= (description = (load_balance=off) (failover=on) (address=(protocol=tcp)(port=1521)(host=tpdapp2)) (address=(protocol=tcp)(port=1521)(host=tpdweb2)) (connect_data=(service_name=was.world)) ) Doing a tnsping from an appserver reports: Attempting to contact (address=(protocol=tcp)(port=1521)(host=tpdapp2)) TNS-12541: TNS:no listener But yet from that same appserver I can connect to the database on the second server by fully qualifying the connect string: (tpdapp1)# sqlplus ejsadmin/ejsadmin@(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=tpdweb2)(PORT=15 21))(CONNECT_DATA=(SERVICE_NAME=WAS.world))) -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Vikas Kawatra INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).