Re: load balancing dodol :)

  • From: "Ujang Jaenudin" <ujang.jaenudin@xxxxxxxxx>
  • To: "Rajeev Prabhakar" <rprabha01@xxxxxxxxx>
  • Date: Sun, 22 Jun 2008 18:43:03 +0700

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@xxxxxxxxx> 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@xxxxxxxxx> 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
>> --
>> //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
--
//www.freelists.org/webpage/oracle-l


Other related posts: