Re: Listener problems
once clients are connected, you can shut down the listener... all that means is that no one else can connect once it is down. size of listener.log is OS dependent, it's just a file on disk. You can recreate it by shutting down the listener renaming or deleting the listener.log file starting up the listener --- Tatireddy, Shrinivas (MED, Keane) [EMAIL PROTECTED] wrote: Hi lists, I have some problem with my listener. That is resolved with the help of metalink. But I have a doubt in this regard. When I try to see the status, lsnrctl status 816LISTENER the statement hung for 10 minutes. I checked metalink and found the solution was, probably the size of listener.log is very big. So archive/remove it. In the mean time , this was resolved by another group of DBAs. In such a situations how to create another listener.log. If I stop/start the listener, this will affect the clients who are running trnx. how do i create another log. And how to know the size of listener.log (There is no parameter for this) is is o/s dependent? Thnx and regards, Srinivas -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Tatireddy, Shrinivas (MED, Keane) 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). __ Do You Yahoo!? Yahoo! GeoCities - quick and easy web site hosting, just $8.95/month. http://geocities.yahoo.com/ps/info1 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rachel Carmichael 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 problems
Title: RE: Listener problems The following script is one I pulled off from the list a few months ago and added a few lines. It is proving pretty useful. Note it uses the set option to redirect to a new output file John #!/bin/ksh # Script to copy out listener.log and compress it. ORACLE_BASE=/u01/app/oracle export ORACLE_BASE ORACLE_HOME=$ORACLE_BASE/product/8.1.6 export ORACLE_HOME PATH=$ORACLE_HOME/bin:/usr/local/bin:/bin:/usr/bin export PATH COMPRESSED_FILE=/u01/app/oracle/product/8.1.6/network/log/listener`date +%Y%m%d%H%M`.log lsnrctl set log_file /u01/app/oracle/product/8.1.6/network/log/listener2.log mv /u01/app/oracle/product/8.1.6/network/log/listener.log $COMPRESSED_FILE mv /u01/app/oracle/product/8.1.6/network/log/listener2.log /u01/app/oracle/product/8.1.6/network/log/listener.log lsnrctl set log_file /u01/app/oracle/product/8.1.6/network/log/listener.log compress $COMPRESSED_FILE # # now remove all compressed listener logs older than 10 days # find /u01/app/oracle/product/8.1.6/network/log/list*.Z -mtime +10 -print -exec rm {} \; A suitable crontab entry for the oracle account would be 00 19 * * * /home/oracle/tidy_listener_log.sh /home/oracle/tidy_listener_log.log 21 -Original Message- From: Rachel Carmichael [mailto:[EMAIL PROTECTED]] Sent: 26 November 2001 09:30 To: Multiple recipients of list ORACLE-L Subject: Re: Listener problems once clients are connected, you can shut down the listener... all that means is that no one else can connect once it is down. size of listener.log is OS dependent, it's just a file on disk. You can recreate it by shutting down the listener renaming or deleting the listener.log file starting up the listener --- Tatireddy, Shrinivas (MED, Keane) [EMAIL PROTECTED] wrote: Hi lists, I have some problem with my listener. That is resolved with the help of metalink. But I have a doubt in this regard. When I try to see the status, lsnrctl status 816LISTENER the statement hung for 10 minutes. I checked metalink and found the solution was, probably the size of listener.log is very big. So archive/remove it. In the mean time , this was resolved by another group of DBAs. In such a situations how to create another listener.log. If I stop/start the listener, this will affect the clients who are running trnx. how do i create another log. And how to know the size of listener.log (There is no parameter for this) is is o/s dependent? Thnx and regards, Srinivas -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Tatireddy, Shrinivas (MED, Keane) 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). __ Do You Yahoo!? Yahoo! GeoCities - quick and easy web site hosting, just $8.95/month. http://geocities.yahoo.com/ps/info1 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rachel Carmichael 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). ** This email and any attachments may be confidential and the subject of legal professional privilege. Any disclosure, use, storage or copying of this email without the consent of the sender is strictly prohibited. Please notify the sender immediately if you are not the intended recipient and then delete the email from your inbox and do not disclose the contents to another person, use, copy or store the information in any medium. **
Listener problems
Hi lists, I have some problem with my listener. That is resolved with the help of metalink. But I have a doubt in this regard. When I try to see the status, lsnrctl status 816LISTENER the statement hung for 10 minutes. I checked metalink and found the solution was, probably the size of listener.log is very big. So archive/remove it. In the mean time , this was resolved by another group of DBAs. In such a situations how to create another listener.log. If I stop/start the listener, this will affect the clients who are running trnx. how do i create another log. And how to know the size of listener.log (There is no parameter for this) is is o/s dependent? Thnx and regards, Srinivas -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Tatireddy, Shrinivas (MED, Keane) 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 problems
Have you put the datbase mtipdb into the tnsnames.ora file? If not, you must do so. You could also check for the lsnrctl executable in $ORACLE_HOME/bin. HTH, Ruth - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Wednesday, June 20, 2001 9:40 AM Hi everybody, I have problems starting a listener on creatded in the net8assistant on Sun Solaris. When I try to start the listener with the command start in the LSNRCTL I get the following error message: TNS-01201: Listener cannot find executable /opt/oracle/product/8.0.6/bin/mtipdb for SID mtipdb Does anybody know what the problem could be? Thanks in advance Mikael -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mikael Granhed 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: Ruth Gramolini 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 problems
Hi everybody, I have problems starting a listener on creatded in the net8assistant on Sun Solaris. When I try to start the listener with the command start in the LSNRCTL I get the following error message: TNS-01201: Listener cannot find executable /opt/oracle/product/8.0.6/bin/mtipdb for SID mtipdb Does anybody know what the problem could be? Thanks in advance Mikael -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mikael Granhed 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 problems
Has anybody come across the following error message in the listener.log, and know what the resolution is. TNS-12500: TNS:listener failed to start a dedicated server process TNS-12540: TNS:internal limit restriction exceeded TNS-12560: TNS:protocol adapter error TNS-00510: Internal limit restriction exceeded Solaris Error: 12: Not enough space What is this Solaris Error 12? I have nothing set in the listener.ora or sqlnet.ora (in fact this dosn't even exist) files. 8.1.7 on Solaris 5.6 regards Zabair _ Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: zabair ahmed 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 problems
Out of space on the file system I believe. -Original Message- Sent: Thursday, May 31, 2001 11:16 AM To: Multiple recipients of list ORACLE-L Has anybody come across the following error message in the listener.log, and know what the resolution is. TNS-12500: TNS:listener failed to start a dedicated server process TNS-12540: TNS:internal limit restriction exceeded TNS-12560: TNS:protocol adapter error TNS-00510: Internal limit restriction exceeded Solaris Error: 12: Not enough space What is this Solaris Error 12? I have nothing set in the listener.ora or sqlnet.ora (in fact this dosn't even exist) files. 8.1.7 on Solaris 5.6 regards Zabair _ Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: zabair ahmed 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: Kevin Lange 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 problems
Title: RE: Listener problems -Original Message- From: zabair ahmed [mailto:[EMAIL PROTECTED]] Has anybody come across the following error message in the listener.log, and know what the resolution is. TNS-12500: TNS:listener failed to start a dedicated server process TNS-12540: TNS:internal limit restriction exceeded TNS-12560: TNS:protocol adapter error TNS-00510: Internal limit restriction exceeded Solaris Error: 12: Not enough space What is this Solaris Error 12? I have nothing set in the listener.ora or sqlnet.ora (in fact this dosn't even exist) files. 8.1.7 on Solaris 5.6 I posted this question to the list about a week ago. If you go to the archives at http://www.fatcity.com , enter the beta site, search ORACLE-L for messages in 2001 with Sun Solaris 8 - Listener in the subject line, you will find the messages related to the subject. Here's a summary of the discussion from last week. Following that are some suggestions I found on Metalink. --- From ORACLE-L - I had the following suggestions: - purge listener.log (Shahid Nasir) - check max number of processes vs. max number of processes per user (John Kanagaraj) - swap space being filled (Hagedorn, Linda) - Use the truss command to trace the system calls when you get the ORA-12500. Example: truss -f -o error.log sqlplus (Narender Akula) - increasing number of semaphores (eric harrington) Narender Akula had also asked if we have Oracle 32-bit and Oracle 64-bit versions both running on the same server. Yes we do. I tried all of the above except using truss. I will experiment with that later. What I did for now to fix the problem: I made the SGA smaller on several of the test databases and the problem went away (it looks like some of the init files were copied over from a production system with no changes. No, I didn't do it, so don't start throwing tomatoes at me.) I'm still not sure why this fixed the problem since ipcs -pmb showed a total of approx. 800MB being used and the machine has 4GB of physical memory. From Metalink - Intermittent TNS-12500 errors are caused by a lack of resources on the server. Finding which resource is depleted may be difficult. 1. The TNS-12500 can be a result of the 'processes' parameter in the init.ora file being too low. 2. If the init.ora 'processes' parameter seems ok then you may need to increase the Unix kernel parameters for the maximum number of processes or users (for example, nproc or maxuprc). Check the manuals for the Unix operating system for more information on these parameters. 3. Check that you have adequate swap space. 4. Disable OTRACE. OTRACE is a tracing feature that can cause many problems. OTRACE is enabled by default. To disable OTRACE: a. Stop the Oracle database. b. Go to the $ORACLE_HOME/otrace/admin directory. c. Delete all files with a '.dat' extension. d. Restart the Oracle database. 5. Use the Multi-Threaded Server (MTS) option. Jacques R. Kilchoƫr x8816
Re: Listener problems
You are out of space on that filesystem. Check the size of your log files, as they are likely responsible for consuming a lot of space. Also check in the cdump directory for core files. Jared On Thursday 31 May 2001 09:16, zabair ahmed wrote: Has anybody come across the following error message in the listener.log, and know what the resolution is. TNS-12500: TNS:listener failed to start a dedicated server process TNS-12540: TNS:internal limit restriction exceeded TNS-12560: TNS:protocol adapter error TNS-00510: Internal limit restriction exceeded Solaris Error: 12: Not enough space What is this Solaris Error 12? I have nothing set in the listener.ora or sqlnet.ora (in fact this dosn't even exist) files. 8.1.7 on Solaris 5.6 regards Zabair _ Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jared Still 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 problems
Take a look at /var/adm/messages for any reported errors -Original Message- Sent: Thursday, May 31, 2001 12:16 PM To: Multiple recipients of list ORACLE-L Has anybody come across the following error message in the listener.log, and know what the resolution is. TNS-12500: TNS:listener failed to start a dedicated server process TNS-12540: TNS:internal limit restriction exceeded TNS-12560: TNS:protocol adapter error TNS-00510: Internal limit restriction exceeded Solaris Error: 12: Not enough space What is this Solaris Error 12? I have nothing set in the listener.ora or sqlnet.ora (in fact this dosn't even exist) files. 8.1.7 on Solaris 5.6 regards Zabair _ Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: zabair ahmed 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: Khedr, Waleed 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).