Monday, March 21, 2011

kids pic

From: גונן [mailto:aaron_g@bezeqint.net]
Sent: Sunday, March 20, 2011 4:27 PM
To: Amihay Gonen
Subject:

Posted via email from agonen's posterous

Sunday, February 13, 2011

Cool clip

Download now or watch on posterous
Remember_Me.wmv (2407 KB)

From: Alona G (Home) [mailto:alona.gaidi@gmail.com]
Sent: Friday, February 11, 2011 10:06 PM
To: Alona G (Home)
Subject: FW: זוכרת אותי

Posted via email from agonen's posterous

Sunday, May 2, 2010

Sql for query in toad 'redo blocks written'

                Select sn.snap_id, sn.BEGIN_INTERVAL_TIME, sum(lc2.value - lc1.value) "redo blocks written"

From   SYS.DBA_HIST_SYSSTAT lc1,

       SYS.DBA_HIST_SYSSTAT lc2,

       SYS.DBA_HIST_snapshot sn

where  lc1.snap_id = (select max(s.snap_id)

                      from    SYS.DBA_HIST_snapshot s

                      where   s.snap_id < sn.snap_id

                      and     s.instance_number = sn.instance_number

                      and     s.dbid = sn.dbid

                      and     s.startup_time = sn.startup_time)

and    lc2.stat_name='redo blocks written'

and    lc1.stat_name='redo blocks written'                     

and    lc2.snap_id = sn.snap_id

and    lc1.dbid = sn.dbid

and    lc1.instance_number = sn.instance_number

and    lc2.dbid = sn.dbid

and    lc2.instance_number = sn.instance_number

and    sn.snap_id in (&Snapshotlist)

group by sn.snap_id, sn.BEGIN_INTERVAL_TIME

order by sn.snap_id

Posted via email from agonen's posterous

Thursday, April 29, 2010

jvm native leaks in solaris

                interesting article...see chapter 3.4

http://java.sun.com/javase/6/webnotes/trouble/TSG-VM/html/memleaks.html

 

1.gcore <pid>

2.mdb core.pid

            ::findleaks

Use lubumem.so.1 .see link

Posted via email from agonen's posterous

Tuesday, April 27, 2010

Unix/Oracle schudle tasks report

Oracle schedule tasks :

owner

job_name

schdule

last_run_duration

last_start_date

SYS

FGR$AUTOPURGE_JOB

freq=daily;byhour=0;byminute=0;bysecond=0

 

 

SYSTEM

DAILY_EXPORT

FREQ=YEARLY;INTERVAL=3

 

 

NG

JOBMOVEALARMS2HISTORY

FREQ=SECONDLY;INTERVAL=3

+00 00:00:00.040996

27/04/2010 12:54:34.106007 +03:00

OPS3

MOVECLOSEDALARMSTOHISTORY

FREQ=SECONDLY;INTERVAL=30

+00 00:00:00.044452

27/04/2010 12:54:30.108538 +03:00

NG

JOBCHECKTOPOLOGY

FREQ=SECONDLY;INTERVAL=60

+00 00:00:00.040272

27/04/2010 12:54:25.174559 +03:00

OPS3

JOB_SPINSERTCLOSEDALARMS

FREQ=SECONDLY;INTERVAL=70

+00 00:00:00.041415

27/04/2010 12:53:40.109356 +03:00

OPS3

JOB_DELETEOLDRECORDS

FREQ=SECONDLY;INTERVAL=110

+00 00:00:00.043696

27/04/2010 12:53:20.165314 +03:00

OPS3

JOB_DELETEOLDTASKS

FREQ=SECONDLY;INTERVAL=110

+00 00:00:00.042024

27/04/2010 12:53:20.103841 +03:00

EXFSYS

RLM$EVTCLEANUP

FREQ = HOURLY; INTERVAL = 1

+00 00:00:00.041805

27/04/2010 02:39:46.110092 -07:00

EXFSYS

RLM$SCHDNEGACTION

FREQ=MINUTELY;INTERVAL=60

+00 00:00:00.072486

27/04/2010 12:24:30.106135 +03:00

OPS3

SWITCHALARMHISTORY

FREQ=HOURLY

+00 00:00:00.054332

27/04/2010 12:00:00.190979 +03:00

NG

CLEANUP_JOB

FREQ=DAILY;BYHOUR=1;BYMINUTE=0;BYSECOND=0

+00 00:00:02.952196

27/04/2010 01:00:00.175784 +03:00

ECI_ADMIN

DB_MAINTAINCE

FREQ=DAILY;BYHOUR=1;BYMINUTE=0;BYSECOND=0

+00 00:00:03.368310

27/04/2010 01:00:00.122527 +03:00

SYS

GATHER_STATS_JOB

 

+00 00:06:22.460691

26/04/2010 22:00:02.732556 +03:00

SYS

AUTO_SPACE_ADVISOR_JOB

 

+00 00:00:17.485245

26/04/2010 22:00:02.730916 +03:00

ORACLE_OCM

MGMT_CONFIG_JOB

 

+00 00:00:00.211014

26/04/2010 22:00:02.726446 +03:00

SYS

PURGE_LOG

freq=daily;byhour=3;byminute=0;bysecond=0

+00 00:00:14.662377

26/04/2010 03:00:00.167015 -07:00

NG

ALARM_PROP

 

 

22/04/2010 13:08:55.891537 +03:00

ORACLE_OCM

MGMT_STATS_CONFIG_JOB

freq=monthly;interval=1;bymonthday=1;byhour=01;byminute=01;bysecond=01

+00 00:00:00.087157

01/04/2010 01:01:01.820472 -07:00

ECI_ADMIN

JOB_TEMPLATE

FREQ=DAILY; INTERVAL=60

+00 00:00:00.054227

06/01/2010 11:21:59.543579 +02:00

Query :

select owner,job_name,nvl(REPEAT_INTERVAL,

                    (select repeat_interval

                           from dba_scheduler_schedules where owner=a.owner and SCHEDULE_NAME=a.SCHEDULE_NAME)

                              ) schdule,last_run_duration,LAST_START_DATE from dba_scheduler_jobs a

                              order by last_start_date desc

Unix schedule tasks (cron only )  Format :

*     *     *   *    *        command to be executed

-     -     -   -    -

|     |     |   |    |

|     |     |   |    +----- day of week (0 - 6) (Sunday=0)

|     |     |   +------- month (1 - 12)

|     |     +--------- day of        month (1 - 31)

|     +----------- hour (0 - 23)

+------------- min (0 - 59)

Global zone :

::::::::::::::

crontabs/adm

::::::::::::::

::::::::::::::

crontabs/lp

::::::::::::::

13 3 * * 0 cd /var/lp/logs; if [ -f requests ]; then if [ -f requests.1 ]; then /bin/mv requests.1 requests.2; fi; /usr/bin/cp requests requests.1; >requests; fi

::::::::::::::

crontabs/root

::::::::::::::

10 3 * * * /usr/sbin/logadm

15 3 * * 0 /usr/lib/fs/nfs/nfsfind

30 3 * * * [ -x /usr/lib/gss/gsscred_clean ] && /usr/lib/gss/gsscred_clean

11 * * * *    MonitorZFS 3600

::::::::::::::

crontabs/sys

::::::::::::::

Oracle Zone:

::::::::::::::

crontabs/adm

::::::::::::::

::::::::::::::

crontabs/lp

::::::::::::::

13 3 * * 0 cd /var/lp/logs; if [ -f requests ]; then if [ -f requests.1 ]; then /bin/mv requests.1 requests.2; fi; /usr/bin/cp requests requests.1; >requests; fi

::::::::::::::

crontabs/oracle10

::::::::::::::

10 0 * * * /opt/oraServer/sh/OraHouseKeeping

::::::::::::::

crontabs/root

::::::::::::::

10 3 * * * /usr/sbin/logadm

15 3 * * 0 /usr/lib/fs/nfs/nfsfind

30 3 * * * [ -x /usr/lib/gss/gsscred_clean ] && /usr/lib/gss/gsscred_clean

::::::::::::::

Zone 2 (Axl)

::::::::::::::

crontabs/adm

::::::::::::::

::::::::::::::

crontabs/lp

::::::::::::::

13 3 * * 0 cd /var/lp/logs; if [ -f requests ]; then if [ -f requests.1 ]; then /bin/mv requests.1 requests.2; fi; /usr/bin/cp requests requests.1; >requests; fi

::::::::::::::

crontabs/root

::::::::::::::

10 3 * * * /usr/sbin/logadm

15 3 * * 0 /usr/lib/fs/nfs/nfsfind

30 3 * * * [ -x /usr/lib/gss/gsscred_clean ] && /usr/lib/gss/gsscred_clean

::::::::::::::

crontabs/sys

::::::::::::::

Zone 3 (OPS)

::::::::::::::

crontabs/adm

::::::::::::::

::::::::::::::

crontabs/lp

::::::::::::::

13 3 * * 0 cd /var/lp/logs; if [ -f requests ]; then if [ -f requests.1 ]; then /bin/mv requests.1 requests.2; fi; /usr/bin/cp requests requests.1; >requests; fi

::::::::::::::

crontabs/root

::::::::::::::

10 3 * * * /usr/sbin/logadm

15 3 * * 0 /usr/lib/fs/nfs/nfsfind

30 3 * * * [ -x /usr/lib/gss/gsscred_clean ] && /usr/lib/gss/gsscred_clean

::::::::::::::

crontabs/sys

::::::::::::::

Command :

more /var/adm/cron/crontabs/* | grep -v # > /tmp/list

Posted via email from agonen's posterous

Tuesday, January 19, 2010

always fill the resource usage- actual work.png

The message is ready to be sent with the following file or link attachments:

resource usage- actual work.png


Note: To protect against computer viruses, e-mail programs may prevent
sending or receiving certain types of file attachments. Check your e-mail
security settings to determine how attachments are handled.

Posted via email from agonen's posterous

Thursday, January 14, 2010

ג'ינג'ר לט"ו בשבט

Charles de Gaulle  - "The better I get to know men, the more I find myself loving dogs."

---------- Forwarded message ----------
From: efrat gonen <efratgonen@gmail.com>
Date: 2010/1/14
Subject: ג'ינג'ר לט"ו בשבט
To:



שלום לכולם.
 
לאחר סיבוב הופעות וסדנאות מוצלח בחנוכה סטודיו ג'ינג'ר חוזרות לשוק החופשי
 ומזמינות אתכם
 להזמין אותנו
לכבוד החג המתקרב... ט"ו בשבט!
 
ההצגה "מעשה בחושך" הינה שילוב של תיאטרון כביסה וצלליות העושה שימוש חוזר בבגדים וחפצים ובוראת עולם לילי חי ורוחש על הבמה.
 
בסוף ההצגה נלמד למחזר אריזות ישנות ולהכין מהן בובות צללית צבעוניות ולהפעיל אותן.
 
ההצגה מיועדת לגילאי 3-8  ו-20-120.
 
למי שכבר ראה את ההצגה אנו מציעות שלל סדנאות ליצירת בובות מסוגים שונים מחומרי מיחזור (בובות מריונטה מגרביים וגלילי נייר טואלט, בובות מוט משקיות ניילון ועיתונים, ועוד).
 
כולכם מוזמנים לבקר בגלריה שלנו ולראות תמונות מהופעות וסדנאות החנוכה:
 
שלכם
אפרת וגילי
 
נ.ב. אם מי מכם לא מעוניין לקבל מאיתנו מיילים- תגידו ומייד נסיר אתכם מייד מרשימת התפוצה


Posted via email from agonen's posterous

Wednesday, January 13, 2010

צלצולי טלפון בשלוש שפות

Download now or watch on posterous
Rings.wmv (4297 KB)

From: Alona Gaidi [mailto:Alona.Gaidi@timetoknow.org]
Sent: Wednesday, January 13, 2010 11:52 AM
Subject: FW: צלצולי טלפון בשלוש שפות

Posted via email from agonen's posterous

DBA TOOLS

Download now or preview on posterous
scale.ppt (1844 KB)

From: Moti Maimon
Sent: Wednesday, January 13, 2010 11:09 AM
To: Ami Bukris; Amihay Gonen
Subject: DBA TOOLS

Regards,

Moti.

Posted via email from agonen's posterous

Wednesday, April 30, 2008

manage the cluster

To start the cluster:
  1. login as root
  2. run:
    $ORA_CRS_HOME/bin/crsctl start crs
    you should get :
    Attempting to start CRS stack
    The CRS stack will be started shortl
If case the cluster is not started (crs_stat)
check logs at : $ORA_CRS_HOME/log/`hostname`/crsd
and : $ORA_CRS_HOME/log/`hostname`/cssd

on all nodes .

Tuesday, April 8, 2008

usefull commands in RAC

srvctl -V
retrun clusterware version

How the oracle clusterware behave

  1. Oracle clusterware is calling all the scripts on $CRS_HOME/racg/usrco on the node where the actions take place. and only on this node.

Thursday, April 3, 2008

RAC - Troubleshooting

Overview

The clusterware is an oracle software which manage oracle and user defined resources.
There a lot of places which can get wrong. This post intend to provide the initial steps for troubleshooting RAC.

Ok ... you did srvctl .... and go an error . What next ?

1. relax .

2. go the machine which has reported on the error (incase you don't sure . go to the machine you run the command on .

3. cd $ORA_CRS_HOME/log/`hostname`/crsd

4. check crsd.log for errors.


When thing is important to remember :
when something in wrong , first check on the node level .
For example - If cluster can not start database - check alertlog, try to start database without RAC .






Tuesday, March 4, 2008

How to add new Iscsi disk

Use the following steps to create a new iscsi disk on sun solaris (10)

  1. Define the disk in the storage gui
  2. Login as root to the system
  3. Enable Iscsi:
    iscsiadm modify discovery -s enable
    iscsiadm list discovery-address -v
  4. Define Iscsi:
    1. svcs -a | grep -i iscsi
      you should get : disabled Jan_22 svc:/network/
      iscsi_initiator:default
    2. iscsiadm list initiator-node
      you should get : Initiator node name: iqn.1986-03.com.sun:01:0003ba321f11.4523d4a8

  5. Rescan iscsi to find new disks
    1. devfsadm -C -i iscsi
      this command scan for new disks. please note -C is to cleanup old disks definitions , -i is for iscsi only
  6. Use format to define new partitions
    1. format
      you should get a list of disks like that -
      AVAILABLE DISK SELECTIONS:

      0. c0t0d0
      /pci@1c,600000/scsi@2/sd@0,0
      1. c0t1d0
      /pci@1c,600000/scsi@2/sd@1,0
      2. c2t1d0
      /iscsi/disk@0000iqn.2005-10.com.xivstorage%3A0101230000,0
      3. c2t2d0
      /iscsi/disk@0000iqn.2005-10.com.xivstorage%3A0101230000,1
      4. c2t4d0
      /iscsi/disk@0000iqn.2005-10.com.xivstorage%3A0101230000,2
      5. c2t5d0
      /iscsi/disk@0000iqn.2005-10.com.xivstorage%3A0101230000,3
      Specify disk (enter its number):
    2. 3
      choose one of the disks if you get Disk not labeled. Label it now? - put yes
    3. FORMAT MENU:
      disk - select a disk
      type - select (define) a disk type
      partition - select (define) a partition table
      current - describe the current disk
      format - format and analyze the disk
      repair - repair a defective sector
      label - write label to the disk
      analyze - surface analysis
      defect - defect list management
      backup - search for backup labels
      verify - read and display labels
      save - save new disk/partition definitions
      inquiry - show vendor, product and revision
      volname - set 8-character volume name
      ! - execute , then return
      quit
      partition (or p as shortcut)
      print (or p as shortcut)
      quit
      quit (to exit format)
  7. Create a new file system
    1. newfs /dev/rdsk/c2t2d0s6
      you should get newfs: construct a new file system /dev/rdsk/c2t2d0s6: (y/n)?
      press - y
    2. mount /dev/dsk/c2t2d0s6 /oracle
      make sure that /oracle directory is exists.

Sunday, March 2, 2008

Starting to blog

Hi , this is blog will contain items which I know and i don't won't to forget.