Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

alter system set service name='' in my alert log?

523059Jan 11 2011 — edited Oct 23 2011

I have a 2 node rac database running 10.2.0.3 on l;inux itanium platform and I see the following messages in my alert log and wondering if anyone can speak to why this is happening. The message is an alter system command that is setting the service_names parameter to null and then putting it back?
Is this a function of rac server side load balancing or something?
This is what I grep'd from the log.
ALTER SYSTEM SET service_names='' SCOPE=MEMORY SID='DB2';
ALTER SYSTEM SET service_names='RCDB' SCOPE=MEMORY SID='DB2';
ALTER SYSTEM SET service_names='' SCOPE=MEMORY SID='DB2';
ALTER SYSTEM SET service_names='RCIDB' SCOPE=MEMORY SID='DB2';
ALTER SYSTEM SET service_names='' SCOPE=MEMORY SID='DB2';
ALTER SYSTEM SET service_names='RCDB' SCOPE=MEMORY SID='DB2';
ALTER SYSTEM SET service_names='' SCOPE=MEMORY SID='DB2';
ALTER SYSTEM SET service_names='RCDB' SCOPE=MEMORY SID='DB2';
ALTER SYSTEM SET service_names='' SCOPE=MEMORY SID='DB2';
ALTER SYSTEM SET service_names='RCDB' SCOPE=MEMORY SID='DB2';
ALTER SYSTEM SET service_names='' SCOPE=MEMORY SID='DB2';
ALTER SYSTEM SET service_names='RCDB' SCOPE=MEMORY SID='DB2';
ALTER SYSTEM SET service_names='' SCOPE=MEMORY SID='DB2';
ALTER SYSTEM SET service_names='RCDB' SCOPE=MEMORY SID='DB2';
ALTER SYSTEM SET service_names='' SCOPE=MEMORY SID='DB2';
ALTER SYSTEM SET service_names='RCDB' SCOPE=MEMORY SID='DB2';
ALTER SYSTEM SET service_names='' SCOPE=MEMORY SID='DB2';
ALTER SYSTEM SET service_names='RCDB' SCOPE=MEMORY SID='DB2';

Thanks.

Locked Post

New comments cannot be posted to this locked post.

Locked on Nov 20 2011

Added on Jan 11 2011

#performance-availability, #real-application-clusters

4 comments

4,674 views