Question
Do you already use Pluggable databases?
Yes, in production
Yes, but not (yet) in production
We are not yet on 12c
We are on 12c but don't use it
No idea or not applicable
Answer and see the results
DBA Top 10
1 M. Cadot 77250
2 A. Kavsek 43900
3 T. Boles 38550
4 B. Vroman 36300
5 P. Wisse 25500
6 J. Schnackenberg 23100
7 K. Subramaniam 20300
8 J. Péran 16450
9 H. Shahi 13150
10 A. Khan 12700
About
DBA-Village
Download PLATO
The free tool for auditing and tuning your database
Version 55 now available
Apr 07, 2015
(recommended update: build 1462)
The DBA-Village forum
Forum as RSS
as RSS feed
Site Statistics
Ever registered47275
Total active users29813
Act. users last 24h7
Act. users last hour1
Hits last week1331
Hits last month5684
Go up

service_update in Listener.log
Next thread: as config
Prev thread: Table scan twice in same query -- why

Message Score Author Date
Hi Gurus, Can anyone please explain me what is th...... Manju Varghese Apr 19, 2006, 18:21
Hi Manju, It means that TEST database service w...... Shailandra Vaish Apr 19, 2006, 19:03
Hi Manju, Meaning of service_update is ... The ...... Aditi Roshan Apr 19, 2006, 19:13
Hi Shailandra Vaish, Aditi Chatterji, Thanks for ...... Manju Varghese Apr 20, 2006, 08:47
Hi, caused by an LOCAL_LISTENER entry in your i...... Score: 200 PtsScore: 200 PtsScore: 200 PtsScore: 200 PtsScore: 200 Pts Alexander Lavecchia Apr 20, 2006, 14:31

Follow up by mail Click here


Subject: service_update in Listener.log
Author: Manju Varghese, India
Date: Apr 19, 2006, 18:21, 3301 days ago
Os info: Sun Solaris
Oracle info: 8.1.7.4
Error info: 28-MAR-2006 21:08:06 * service_update * TEST * 0
Message: Hi Gurus,
Can anyone please explain me what is the * service_update *<SID> * 0 in the Listner.log file.

28-MAR-2006 21:08:06 * service_update * TEST * 0


Regards
Manju
Goto: Reply - Top of page 
If you think this item violates copyrights, please click here

Subject: Re: service_update in Listener.log
Author: Shailandra Vaish, United States
Date: Apr 19, 2006, 19:03, 3300 days ago
Message: Hi Manju,

It means that TEST database service was updated successfully with the listener. There are two ways you let listener recognize your database. One by listing your database in SID_LIST_$LISTENER_NAME in the listener.ora file or secondly by let listener discover the database service (this usually takes some time may be couple of minutes ater the database has been started).

Regards
Your rating?: This reply is Good Excellent
Goto: Reply - Top of page 
If you think this item violates copyrights, please click here

Subject: Re: service_update in Listener.log
Author: Aditi Roshan, United Arab Emirates
Date: Apr 19, 2006, 19:13, 3300 days ago
Message: Hi Manju,
Meaning of service_update is ...
The listener received updated registration information for a particular instance, such as dispatcher or instance load information.


http://www.cs.uvm.edu/oracle9doc/network.901/a90154/troubles.htm and search for service_update.

-Aditi


Your rating?: This reply is Good Excellent
Goto: Reply - Top of page 
If you think this item violates copyrights, please click here

Subject: Re: service_update in Listener.log
Author: Manju Varghese, India
Date: Apr 20, 2006, 08:47, 3300 days ago
Message: Hi Shailandra Vaish, Aditi Chatterji,
Thanks for the rapid reply; I have one more doubt to. When a client connect to DB how the service is updating because I didn’t make any changes in the listener setting but this message is keep on coming in the log file. Will it have any impact inf performance

As per my current set up client are using the oracle 6i to connect using Net 8.
Regards
Manju
Your rating?: This reply is Good Excellent
Goto: Reply - Top of page 
If you think this item violates copyrights, please click here

Subject: Re: service_update in Listener.log
Author: Alexander Lavecchia, Germany
Date: Apr 20, 2006, 14:31, 3300 days ago
Score:   Score: 200 PtsScore: 200 PtsScore: 200 PtsScore: 200 PtsScore: 200 Pts
Message: Hi,

caused by an LOCAL_LISTENER entry in your init.ora file PMON attempts every minute a registration of the instance to the listener defined, if you do not have a local_listener entry it looks for listener running on port 1521 (default port) to register.

If listener is up and you start your instance, registering will take place immediately, if instance is up and you start your listener, it can take up to one minute til it is registered.

You will not suffer from bad performance due to this service updates.

Here you'll get some more informations:

Metalink Note:235562.1, Issues affecting Automatic Service Registration

Kind Regards

Alex
Your rating?: This reply is Good Excellent
Goto: Reply - Top of page 
If you think this item violates copyrights, please click here