RE: freebie. Summarize Oracle Listener logs

. Summarize Oracle Listener logs I wanted to summarize our listener logs to see who's connecting with what tools. I checked google and didn't see anything, so I decided to write one. It may be useful to somebody else. It summarizes the linesof a listener log. the output is similar

RE: freebie. Summarize Oracle Listener logs

- Sent: 05 January 2004 03:29 To: Multiple recipients of list ORACLE-L I wanted to summarize our listener logs to see who's connecting with what tools. I checked google and didn't see anything, so I decided to write one. It may be useful to somebody else. It summarizes the lines of a listener log

RE: freebie. Summarize Oracle Listener logs

]++ == 0)lines[++count] = $0}\ END{for (i = 1; i = count; i++)print lines[i],\tdata[lines[i]]}'\ |sort -n +4 rm /tmp/j.lis rm /tmp/j1.lis -Original Message- Sent: 05 January 2004 03:29 To: Multiple recipients of list ORACLE-L I wanted to summarize our listener logs to see who's

freebie. Summarize Oracle Listener logs

I wanted to summarize our listener logs to see who's connecting with what tools. I checked google and didn't see anything, so I decided to write one. It may be useful to somebody else. It summarizes the linesof a listener log. the output is similar to Ora Listener Log Summary V0.5Oracle

Re: Listener without IPC

Yes Yechiel Adar Mehish - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Tuesday, November 18, 2003 7:24 AM What will happens if I remove all occurence of IPC protocol from communication level, i.e. Listener? Can U work only over TCP/IP

Re: Listener without IPC

if I remove all occurence of IPC protocol from communication level, i.e. Listener? Can U work only over TCP/IP? -- (VirVit) Oracle 9i DBA beginner -- Please see the official ORACLE-L FAQ [EMAIL PROTECTED] vices--858-538-5051httpwww.fatcity.zl6SanDiego,California--Mailinglistandweb

Listener without IPC

What will happens if I remove all occurence of IPC protocol from communication level, i.e. Listener? Can U work only over TCP/IP? -- (VirVit) Oracle 9i DBA beginner -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: VirVit INET: [EMAIL PROTECTED] Fat City Network

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

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

Re: Listener problem on one client computer

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

Listener Lockout Feature

Any idea if a listener lockout feature is going to be added to the listener utility, i.e. lock after x failed login attempts (this is on the listener password). Are failed login attempts logged in the log file? Being lazy on that last question. Thanks, Ethan -- Please see the official ORACLE

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

RE: Listener Lockout Feature

Whoops, disregard my last post - do you mean logging on to lsnrctl? -Original Message- Post, Ethan Sent: 03 September 2003 17:39 To: Multiple recipients of list ORACLE-L Any idea if a listener lockout feature is going to be added to the listener utility, i.e. lock after x failed login

Re: Listener Lockout Feature

Hi Ethan, I have not heard that Oracle will include a lock out or the listener but I did hear that they will change the listener to allow the text strings to be changed dynamically so that listeners can be made silent in terms of the banner info they give out. It would be nice if Oracle did put

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

RE: Listener Lockout Feature

of list ORACLE-L Any idea if a listener lockout feature is going to be added to the listener utility, i.e. lock after x failed login attempts (this is on the listener password). Are failed login attempts logged in the log file? Being lazy on that last question. Thanks, Ethan -- Please see

Re: Listener Lockout Feature

Listener password failures do not lock the password, unfortunately; but it is possible to identify the failed logins. The listener log shows entries similar to the lines below 05-JUL-2003 21:14:39 * services * 1169 TNS-01169: The listener has not recognized the password Note the lines TNS-01169

RE: Listener Lockout Feature

-L Any idea if a listener lockout feature is going to be added to the listener utility, i.e. lock after x failed login attempts (this is on the listener password). Are failed login attempts logged in the log file? Being lazy on that last question. Thanks, Ethan -- Please see the official ORACLE

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

RE: Listener problem on one client computer

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

Re: Listener problem on one client computer

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

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

RE: Listener problem on one client computer

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

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

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

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

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.

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

Re: Listener problem on one client computer

, 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

URGENT !!! Listener Errors !!! ( HPUX Error: 2: No such file or

-12545: Connect failed because target host or object does not exist TNS-12560: TNS:protocol adapter error TNS-00515: Connect failed because target host or object does not exist HPUX Error: 2: No such file or directory I have already bounced the listener 3 times . Almost no help from

RE: URGENT !!! Listener Errors !!! ( HPUX Error: 2: No such file or

server process TNS-12545: Connect failed because target host or object does not exist TNS-12560: TNS:protocol adapter error TNS-00515: Connect failed because target host or object does not exist HPUX Error: 2: No such file or directory I have already bounced the listener 3 times . Almost

RE: URGENT !!! Listener Errors !!! ( HPUX Error: 2: No such file

-00515: Connect failed because target host or object does not exist HPUX Error: 2: No such file or directory I have already bounced the listener 3 times . Almost no help from ORACLE so far . Madhu Reddy X13944 -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Reddy

RE: URGENT !!! Listener Errors !!! ( HPUX Error: 2: No such file or

Madhu, If you are sure you are starting all the listeners, not just the default listener but named listeners as well (if any). I would look into the HPUX error next. What is file or directory is it looking for? I would examine the listener.ora closely and verify that the logging/tracing

RE: URGENT !!! Listener Errors !!! ( HPUX Error: 2: No such file or

-00515: Connect failed because target host or object does not exist HPUX Error: 2: No such file or directory I have already bounced the listener 3 times . Almost no help from ORACLE so far . Madhu Reddy X13944 -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Reddy

Re: URGENT !!! Listener Errors !!! ( HPUX Error: 2: No such file

to start a dedicated server process TNS-12545: Connect failed because target host or object does not exist TNS-12560: TNS:protocol adapter error TNS-00515: Connect failed because target host or object does not exist HPUX Error: 2: No such file or directory I have already bounced the listener 3

RE: URGENT !!! Listener Errors !!! ( HPUX Error: 2: No such file

bounced the listener 3 times . Almost no help from ORACLE so far . Madhu Reddy X13944 -- Joseph S Testa Chief Technology Officer Data Management Consulting p: 614-791-9000 f: 614-791-9001 -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Joe Testa INET: [EMAIL

Re: URGENT !!! Listener Errors !!! ( HPUX Error: 2: No such file

: TNS:protocol adapter error TNS-00515: Connect failed because target host or object does not exist HPUX Error: 2: No such file or directory I have already bounced the listener 3 times . Almost no help from ORACLE so far . Madhu Reddy X13944 -- Joseph S Testa Chief Technology Officer Data

RE: URGENT !!! Listener Errors !!! ( HPUX Error: 2: No such file

- From: Joe Testa [mailto:[EMAIL PROTECTED] Sent: Friday, August 15, 2003 2:59 PM To: Multiple recipients of list ORACLE-L Subject: Re: URGENT !!! Listener Errors !!! ( HPUX Error: 2: No such file i always did like that about the internet, i can telnet to 127.0.0.1 on ANY server

RE: URGENT !!! Listener Errors !!! ( HPUX Error: 2: No such file

:[EMAIL PROTECTED] Sent: Friday, August 15, 2003 2:59 PM To: Multiple recipients of list ORACLE-L Subject: Re: URGENT !!! Listener Errors !!! ( HPUX Error: 2: No such file i always did like that about the internet, i can telnet to 127.0.0.1 on ANY server and it knows my userid/passwd, total

RE: URGENT !!! Listener Errors !!! ( HPUX Error: 2: No such

adapter error TNS-00515: Connect failed because target host or object does not exist HPUX Error: 2: No such file or directory I have already bounced the listener 3 times . Almost no help from ORACLE so far . Madhu Reddy X13944 -- Please see the official ORACLE-L FAQ: http://www.orafaq.net

How can I turn Oracle listener on for Oracle 9i on solaris - FYI

Hi, My servers are power off. Now I get the power and start them up. I would like to know how to start Oracle 9.2 listener on Solaris platform so that my program can talk to it. Any suggestions are appreciated! Thanks in advance! Don -- Please see the official ORACLE-L FAQ: http

Re: How can I turn Oracle listener on for Oracle 9i on solaris - FYI

lsnrctl start -ak - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Friday, July 18, 2003 11:09 AM Hi, My servers are power off. Now I get the power and start them up. I would like to know how to start Oracle 9.2 listener on Solaris platform

RE: How can I turn Oracle listener on for Oracle 9i on solaris - FYI

listener on Solaris platform so that my program can talk to it. Any suggestions are appreciated! Thanks in advance! Don -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Don Yu INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com

listener

Is it possible to have listner running on box a while databases running on X,Y,Z . If yes , then how does oracle instance find the address of the box running the listner , if I configure ini.ora with service_name . Does it mean that local tnsnames.ora file ( on server X,Y,Z) should haave an

Re: listener

Hi! Your databases actually have to register with your listener on remote machine. Your databases have to have tnsnames.ora configured with entry for listener location as well and your instances' REMOTE_LISTENER parameter has to specify the tns alias for listener location. That way

RE: oracle listener (auto increment value for PK)

Hi Markus! Here's a recipe that might help you (assuming your table is called MYTABLE: 1. create a sequence: CREATE SEQUENCE MYTABLE_Sequence start with 1 increment by 1 nocycle nocache; 2. create an insert trigger CREATE OR REPLACE TRIGGER MYTABLE_Insert_Trigger BEFORE INSERT ON

RE: oracle listener (auto increment value for PK)

Sorry I meant Hi Martin -Original Message- Sent: Tuesday, July 15, 2003 8:59 PM To: Multiple recipients of list ORACLE-L Hi Markus! Here's a recipe that might help you (assuming your table is called MYTABLE: 1. create a sequence: CREATE SEQUENCE MYTABLE_Sequence start with 1

RE: LISTENER ON LINUX

A simple ps -ef|grep lsnr will work. Terry Ball, DBA Birch Telecom Work: 816-300-1335 FAX: 816-300-1800 -Original Message- Sent: Friday, July 11, 2003 11:20 AM To: Multiple recipients of list ORACLE-L Hi When I try to see listener process on Linux box by ps -ef |grep tns .It doen't

oracle listener

hi i run oracle8 on w2000 advanced server. my question is how to create a auto increment primary key for this table: id number(5) name varchar(12) id should auto increment after inserting a new datarow must i create a trigger ? excuse my bad english thx martin -- Please see the official ORACLE-L

Re: oracle listener

Hello Martin, You can create a sequence in Oracle and assign it to the table. You don';t have to create trigger on it. Hope this helps Raju. sorry for my english too :) --- pfeffer [EMAIL PROTECTED] wrote: hi i run oracle8 on w2000 advanced server. my question is how to create a auto

listener newbie

hi i has configured my listener but if i try to ping i get the error: target host or object does not exist. means the server in the config the database name or the computername i run ora8 on w2000 server thx martin -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: pfeffer

LISTENER ON LINUX

Hi When I try to see listener process on Linux box by ps -ef |grep tns .It doen't show but when I tried to see the status thru lsnrctl status listener_name .its shows service handler. How to check whether listener is running or not and how to start that? thx -seema

RE: LISTENER ON LINUX

use ps -lax instead Ciao Fuzzy :-) -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Seema Singh Sent: Friday, July 11, 2003 17:20 To: Multiple recipients of list ORACLE-L Subject: LISTENER ON LINUX Hi When I try to see listener process on Linux

RE: LISTENER ON LINUX

: LISTENER ON LINUX Hi When I try to see listener process on Linux box by ps -ef |grep tns .It doen't show but when I tried to see the status thru lsnrctl status listener_name .its shows service handler. How to check whether listener is running or not and how to start that? thx -seema

Re: LISTENER ON LINUX

ps -efw|grep tns -Candi On Fri, 2003-07-11 at 12:19, Seema Singh wrote: Hi When I try to see listener process on Linux box by ps -ef |grep tns .It doen't show but when I tried to see the status thru lsnrctl status listener_name .its shows service handler. How to check whether listener

RE: LISTENER ON LINUX

]); -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Seema Singh Sent: Wednesday, July 02, 2003 2:36 PM To: Multiple recipients of list ORACLE-L Subject: LISTENER ON LINUX Hi, When I am trying to start listener on Linux box ,getting error TNS-12542

listener

one can configure init.ora file so that instance registers itself with listener ( oracle 8i ) . what happens if the listener is stopped after that ( registering )? Does it require boucing those instances which register themselves to listener ? -ak

Re: listener

try it and see, the best way to learn. joe AK wrote: one can configure init.ora file so that instance registers itself with listener ( oracle 8i ) . what happens if the listener is stopped after that ( registering ) ? Does it require boucing those instances which register themselves

Re: listener

In 9i, there is command alter system register which does the trick. In 8i, it takes approximately 15 minutes for the instance to re-register with the listener. On 2003.07.08 20:44, Joe Testa wrote: try it and see, the best way to learn. joe AK wrote: one can configure init.ora file so

RE: listener

If the listener is stopped, then within 60 seconds of restarting, the running services will be registered with the newly started listener again. At least this is the case on AIX and Solaris servers. HTH, -Ron- -Original Message- Testa Sent: Tuesday, July 08, 2003 7:44 PM To: Multiple

RE: LISTENER ON LINUX

1521 and 1522 netstat 9i From: Gogala, Mladen [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: RE: LISTENER ON LINUX Date: Wed, 02 Jul 2003 11:15:56 -0800 What is the port? How did you check that it wasn't used? Which distro, which

LISTENER ON LINUX

Hi, When I am trying to start listener on Linux box ,getting error TNS-12542: TNS:address already in use TNS-12560: TNS:protocol adapter error TNS-00512: Address already in use Linux Error: 98: Address already in use I checked no process fro listener and no port used by another process. Let me

RE: LISTENER ON LINUX

Sounds like a duplicated IP or duplicated Service name. Luis -Original Message- Sent: Wednesday, July 02, 2003 12:36 PM To: Multiple recipients of list ORACLE-L Hi, When I am trying to start listener on Linux box ,getting error TNS-12542: TNS:address already in use TNS-12560

RE: LISTENER ON LINUX

trying to start listener on Linux box ,getting error TNS-12542: TNS:address already in use TNS-12560: TNS:protocol adapter error TNS-00512: Address already in use Linux Error: 98: Address already in use I checked no process fro listener and no port used by another process. Let me know how

Oracle Application Server Listener Anomalies

the OAS listener(s). On Monday morning we looked in the log files associated with OAS. It showed the reboot occurred at 10:05 p.m. It also showed connections to OAS as late as ten minutes before the reboot. In fact, it showed a light stream of connections right up to the time OAS was restarted. One

Re: Listener showing 2 service handlers for the same service

Naveen, Do you have local_listener set in your init.ora file? -Ravi. --- Naveen Nahata [EMAIL PROTECTED] wrote: Hi All, When I start the listener, after sometimes the instance registers itself with the listener. After this the status of the listener shows 2 service handlers for the same

Listener showing 2 service handlers for the same service

Hi All, When I start the listener, after sometimes the instance registers itself with the listener. After this the status of the listener shows 2 service handlers for the same service. For the sake of clarity I'm pasting the output and listener.ora file. Initial Status: --- Services

Can't start listener after installing 9.2.0.3 Patch ?

that,the installation of the patch was successful. but while starting the listener,i get the error: PROCEDURE ENTRY POINT OF LXHLCMOD NOT FOUND IN ORANLS9.DLL. and i am not able to start the listener. am i missing out something ? have anyone faced the same before ? TIA. Jp. -- Please see the official

8i databases under 9i listener?

Title: 8i databases under 9i listener? RS6000 running AIX 4.3.3. We are experiencing the following issues with our 8.1.7.4 databases under a 9.2.0.1 listener. 1) PL/SQL procedures utilizing UTL_FILE fail with INVALID_PATH errors when attempting to open a file. 2) Database links from

RE: 8i databases under 9i listener?

Title: Message We are also finding difficulties with a mixed Oracle environment. We are running AIX 4.3.3-ML10, Oracle 8.1.7.3-EE-64 bit, PeopleSoft 8.18 and moving to Oracle 9.2.0.2. In the past, when moving to a new Oracle release, we would install the software, upgrade our listener

RE: 8i databases under 9i listener?

://www.thomson.net/videochain -Original Message-From: Stephen Murphy [mailto:[EMAIL PROTECTED]Sent: Wednesday, March 05, 2003 10:06 AMTo: Multiple recipients of list ORACLE-LSubject: RE: 8i databases under 9i listener? We are also finding difficulties with a mixed Oracle environment. We

Listener Hangs

We are running Oracle 7.3.4.5.0 on an IBM/AIX RISC System/6000: Version 2.3.4.0.0. Yesterday morning our LISTENER process hung. ERROR: ORA-12203: TNS:unable to connect to destination. We resolved the problem using the following steps: a) Stop Listener using LSNRCTL utility (this hung

RE: Listener Hangs

This is how you can cleanup listener.log w/o taking the listener down. You can copy the listener.log to an archive location, then do the following: cat "/dev/null" and redirect to listener.log file. This will zero the current file and allow other updates to the log from th

Re: Listener Hangs

It's possible. I've heard of this happening before and the recommendation was to clear out the listener.log file. There are a couple of ways to clear out that file. One is to stop the listener and delete it. The other is to cat /dev/null to it (i.e. cat /dev/null listener.log). The latter

RE: Listener Hangs

: Listener Hangs This is how you can cleanup listener.log w/o taking the listener down. You can copy the listener.log to an archive location, then do the following: cat /dev/null and redirect to listener.log file. This will zero the current file and allow other updates

Listener/Database shutdown sequence

Should the databases be shutdown before the listener or the other way around. A DBA here (actually at Service Provider) believes that the listener has to be shutdown before the databases in 8i according to some documentation (they can't recall). I am proposing: Set Oracle 817 environment

Re: Listener/Database shutdown sequence

Why do you/they think it matters, regardless of the documentation? You can shut them down in any order you want. Users just get a different error if the listener is up vs. when it is down. Starting up, if services are registered via local_listener or mts_dispatchers, the listener should be up

RE: Listener/Database shutdown sequence

There might be some docs somewhere but the issues are not as much technical as procedural. If you shut the database down, leave the listener up, and bring the database backup there are no connection problems except when the db is down. This implies that the instance and the listener

RE: Listener/Database shutdown sequence

David, it just doesn't matter. why do you even feel the need to shut the listener down? Tom Mercadante Oracle Certified Professional -Original Message- Sent: Monday, March 03, 2003 9:59 AM To: Multiple recipients of list ORACLE-L Should the databases be shutdown before the listener

RE: Listener/Database shutdown sequence

Sometimes it does matter what is stopped rather than the order, but we can't tell why the original poster was asking. It depends on your environment. For example, one site I worked at had a separate listener for every database in their environment. Their reasoning was they made life easier

RE: Listener/Database shutdown sequence

Tom, It is for the server auto-start/auto-shutdown procedures run by root. From: Mercadante, Thomas F [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: RE: Listener/Database shutdown sequence Date: Mon, 03 Mar 2003 09:04:11 -0800

Fwd: Re: Listener/Database shutdown sequence

From: Jeremiah Wilton [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: Re: Listener/Database shutdown sequence Date: Mon, 03 Mar 2003 08:19:06 -0800 Why do you/they think it matters, regardless of the documentation? You can

Re: Listener/Database shutdown sequence

, the most successful path is the list. Thx David From: Jeremiah Wilton [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: Re: Listener/Database shutdown sequence Date: Mon, 03 Mar 2003 08:19:06 -0800 Why do you/they think it matters

RE: Listener/Database shutdown sequence

Dave, that's kind of a different question. in this case, as others have stated, the order of shutting things down does not matter too much. For practical purposes, I would shut the listener down first and then the database - only because the database takes longer to shut down. For startup, I

RE: Listener/Database shutdown sequence

stolen away by a needlessly spinning listener(s) that is just rejecting connections, one after another. So, in such a case, listener first, then database. But shutdown immediate is for wimps. Just shoot DBW0 in the head with a SIGKILL. ;-) -- Jeremiah Wilton http://www.speakeasy.net/~jwilton On Mon

Listener

Title: Message Hi list, I have my DB server with 2 network card and I want to split theconnections between the users to balance the load. I addedLOAD_BALANCE=ON in the listener.ora and another line with the new ip address with the port 1526. Now all the connections are managed with

RE: Listener Hanging 64 Bit Solaris 8 Oracle 9.2

We had this problem recently- running 8.1.7 (64-bit) and 9.0.1.3 (32-bit) on Sun Solaris 2.8. Both databases were registered in the same version 9.0.1.3.0 Listener. Oracle Support eventually told me that Listener versions below 9iR2 do not support mixed bit versions (64- and 32-bit). You would

Listener Hanging 64 Bit Solaris 8 Oracle 9.2

Anyone had this issue? Oracle support has been helpless so far, even with mega trace files. - Ethan -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Post, Ethan INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego,

Re: Listener Hanging 64 Bit Solaris 8 Oracle 9.2

Ethan, We're currently having is on one of out HP/Compaq Tru64 5.1a clusters running mostly 8.1.7.3. Since we started tracing earlier this week, we haven't had a problem. I'll let you know if we find anything. Stephen [EMAIL PROTECTED] 02/13/03 02:59PM Anyone had this issue? Oracle

common listener

Hi DBA's I have a common listener setup for 4 database on a server. i.e. listener.ora is listening to 4 different databases on the server (port numbers are different for each DB). is there a way to stop services for only 1 database (I mean if I stop listener, it stops connections for all

Re: common listener

short answer: no Longer answer: you would have to have a separate listener for each database to stop the services only for one database. Or you could edit the listener.ora file, remove the one database you wanted to stop listening for, stop the listener (this won't disconnect anyone already

RE: common listener

Srinivas Stopping the listener does not affect existing connections, but only users that are trying to connect. Therefore you can modify the listener.ora file, then stop and start the listener without affecting your users. I would recommend that you avoid doing this when a lot of your users

RE: common listener

How about just a 'Reload' insead of stop and start? Much faster. Ron Smith -Original Message- Sent: Monday, February 10, 2003 8:04 AM To: Multiple recipients of list ORACLE-L Srinivas Stopping the listener does not affect existing connections, but only users that are trying

Re: common listener

kommareddy sreenivasa, hei, you can just create 4 listener and each listener listeners on one port for one database, isn't it pretty easy? Regards zhu chao msn:[EMAIL PROTECTED] www.happyit.net www.cnoug.org(China Oracle User Group) === 2003-02-10 04:03:00 ,you wrote£º

Re: RE: common listener

Kommareddy, Srinivas (MED, Wissen Infotech), What about change it from the database? like alter system enable resticted session?So, general user without special privs will not be able to logon to the database even the listener is still up and conection to other database is still

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

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 UNKN

Oracle connection/listener/dispatcher stops allowing connections

Hello, Just in time for the Holidays. Oracle stops accepting connections. I am wondering if people here can give me their horror stories when Oracle stops accepting new connections or stops accepting connections altogether? Scalability problems when you've got around 5,000 concurrent

RE: Oracle connection/listener/dispatcher stops allowing connecti

Lyndon I would look at the wait statistics to see what is happening inside Oracle. I would also look at the O.S. performance statistics to see what is happening underneath Oracle. Don't make any rash assumptions. Also, are any error messages or trace files generated? For me the funny story

RE: Oracle connection/listener/dispatcher stops allowing connecti

The reason I ask is because people around me always blame Oracle when things stop working. Anyways, the problem was traced to a corrupted Oracle database (as to whether the tables or the data file got corrupted. how and why - a $$$ consultant is trying to find out). How could an Oracle database

  1   2   3   4   >