Re: load balancing dodol :)

From: Ujang Jaenudin <ujang.jaenudin_at_gmail.com>
Date: Sun, 22 Jun 2008 18:43:03 +0700
Message-ID: <3edcb66e0806220443g254e923ie2fc1f42fe375891@mail.gmail.com>


Rajeev,

listener.ora file content

SID_LIST_LISTENER_FCDBPRD1 =
  (SID_LIST =
  (SID_DESC =
    (SID_NAME = FCRDBPRD1)
    (ORACLE_HOME = /oracle/ora10gdb)
  )
)

LISTENER_FCDBPRD1 =
  (DESCRIPTION_LIST =
  (DESCRIPTION =
   (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 PREFER_LEAST_LOADED_NODE_LISTENER_FCDBPRD1=OFF 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 ?
>
> Rajeev
>
> On Sat, Jun 21, 2008 at 2:17 AM, Ujang Jaenudin
> <ujang.jaenudin_at_gmail.com> wrote:
>> lists,
>>
>> i have rac environment:
>> hp-ux itanium
>> 2 node rac
>> db 10.2.0.2
>> hp-serviceguard
>>
>> 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
>> --
>> http://www.freelists.org/webpage/oracle-l
>>
>>
>>
>
>
>
> --
> 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-l
Received on Sun Jun 22 2008 - 06:43:03 CDT

Original text of this message