Re: load balancing dodol :)
Date: Sun, 22 Jun 2008 18:43:03 +0700
listener.ora file content
(SID_NAME = FCRDBPRD1)
(ORACLE_HOME = /oracle/ora10gdb)
(ADDRESS = (PROTOCOL = TCP)(HOST = ip-vip)(PORT = 1666)(QUEUESIZE=50)(IP = FIRST))
(ADDRESS = (PROTOCOL = TCP)(HOST = ip-public)(PORT = 1666)(QUEUESIZE=50)(IP = FIRST))
LOCAL_OS_AUTHENTICATION_LISTENER_FCDBPRD1 = ON
ADMIN_RESTRICTIONS_LISTENER_FCDBPRD1 = ON
LOG_DIRECTORY_LISTENER_FCDBPRD1 = /oracle/ora10gdb/network/log
LOG_FILE_LISTENER_FCDBPRD1 = LISTENER_FCDBPRD1
On Sun, Jun 22, 2008 at 1:33 AM, Rajeev Prabhakar <rprabha01_at_gmail.com> wrote:
> Hello Ujang,
> Could you please share the contents of your listener.ora file ?
> On Sat, Jun 21, 2008 at 2:17 AM, Ujang Jaenudin
> <ujang.jaenudin_at_gmail.com> wrote:
>> i have rac environment:
>> hp-ux itanium
>> 2 node rac
>> db 10.2.0.2
>> now we got problem may be bug...
>> from the OS side it seem balance, that the currently processes running
>> is same (throughtop/glance)
>> the memory utilization is almost balance as well as cpu
>> but from inside oracle node2 has 70% from total sessions.
>> i have configured server-side and client side load balancing altogether.
>> clb_goal set to short, throughput in the service
>> from SR support told me that querying V$osstat on this platform return
>> no rows, that may be the root cause.
>> does anyone have this kind of case?
>> thanks for sharing
>> thanks and regards
>> ujang | oracle dba
>> jakarta - indonesia
> Walt Disney - "I love Mickey Mouse more than any woman I have ever known."
-- thanks and regards ujang | oracle dba jakarta - indonesia -- http://www.freelists.org/webpage/oracle-lReceived on Sun Jun 22 2008 - 06:43:03 CDT