26 Ocak 2010 Salı

SAP smtp problem

scot ile giriyoruz setting/default domain girdikten sonra kontrol edebilirsiniz!
ilgili işlem kodları:SU01D and SCOT and SOST

21 Ocak 2010 Perşembe

solaris

devfsadm
format
format
Searching for disks...done


AVAILABLE DISK SELECTIONS:
0. c0d0
/pci@0,0/pci-ide@7,1/ide@0/cmdk@0,0
1. c2t0d0
/pci@0,0/pci15ad,1976@10/sd@0,0
2. c2t1d0
/pci@0,0/pci15ad,1976@10/sd@1,0
3. c2t2d0
/pci@0,0/pci15ad,1976@10/sd@2,0

zpool create fpool mirror c2t0d0 c2t1d0
df -h /fpool
zfs create fpool/fs
zpool list
zfs set mountpoint=/fs /fpool/fs
zpool offline fpool c2t0d0
zpool status -v fpool
zpool replace fpool c2t0d0 c2t2d0
ex:
# zpool offline rpool c1t0d0s0
# cfgadm -c unconfigure c1::dsk/c1t0d0
# cfgadm -c configure c1::dsk/c1t0d0
# zpool replace rpool c1t0d0s0
# zpool online rpool c1t0d0s0

zpool attach fpool c2t2d0 c2t0d0
zpool detach fpool c2t2d0

zpool add fpool spare c2t2d0

zpool replace fpool c2t1d0 c2t2d0 --disk1 bozuldu
zpool remove fpool c2t2d0

zpool get all fpool

Solaris Zone network ayari

1. Via zonecfg:
zonecfg -z zone1
add net
set physical=e1000g0
set address=192.168.80.151
end
verify
commit

2. Via ifconfig:
ifconfig e1000g0:1 plumb 192.168.80.151 netmask + broadcast + up
ifconfig e1000g0:1 zone zone1

ilkinde zone u restart etmek gerekcek. fakat ikincisinde gerek yok.

20 Ocak 2010 Çarşamba

Solaris Zone olusturma

# zfs list
NAME USED AVAIL REFER MOUNTPOINT
rpool 5.16G 2.66G 33K /rpool
rpool/ROOT 3.87G 2.66G 21K legacy
rpool/ROOT/s10x_u8wos_08a 3.87G 2.66G 3.87G /
rpool/dump 808M 2.66G 808M -
rpool/export 250K 2.66G 23K /export
rpool/export/home 226K 2.66G 226K /export/home
rpool/swap 512M 2.99G 170M -
testpool 1.94G 0 1.94G /testpool
testpool/zones 21K 0 21K /testpool/zones
# zfs create -o canmount=noauto rpool/ROOT/s10x_u8wos_08a/zones
# zfs mount rpool/ROOT/s10x_u8wos_08a/zones
# zfs list
NAME USED AVAIL REFER MOUNTPOINT
rpool 5.16G 2.66G 33K /rpool
rpool/ROOT 3.87G 2.66G 21K legacy
rpool/ROOT/s10x_u8wos_08a 3.87G 2.66G 3.87G /
rpool/ROOT/s10x_u8wos_08a/zones 21K 2.66G 21K /zones
rpool/dump 808M 2.66G 808M -
rpool/export 250K 2.66G 23K /export
rpool/export/home 226K 2.66G 226K /export/home
rpool/swap 512M 2.99G 170M -
testpool 1.94G 0 1.94G /testpool
testpool/zones 21K 0 21K /testpool/zones
# zfs mount rpool/ROOT/s10x_u8wos_08a/zones
# zfs list
NAME USED AVAIL REFER MOUNTPOINT
rpool 5.16G 2.66G 33K /rpool
rpool/ROOT 3.87G 2.66G 21K legacy
rpool/ROOT/s10x_u8wos_08a 3.87G 2.66G 3.87G /
rpool/ROOT/s10x_u8wos_08a/zones 21K 2.66G 21K /zones
rpool/dump 808M 2.66G 808M -
rpool/export 250K 2.66G 23K /export
rpool/export/home 226K 2.66G 226K /export/home
rpool/swap 512M 2.99G 170M -
testpool 1.94G 0 1.94G /testpool
testpool/zones 21K 0 21K /testpool/zones
# zfs create -o canmount=noauto rpool/ROOT/s10x_u8wos_08a/zones/test1
# zfs mount rpool/ROOT/s10x_u8wos_08a/zones/test1
# zonecfg -z test1
test1: No such zone configured
Use 'create' to begin configuring a new zone.
zonecfg:test1> create
zonecfg:test1> set zonepath=/zones/test1
zonecfg:test1> set autoboot=true
zonecfg:test1> add net
zonecfg:test1:net> set physical=e1000g0
zonecfg:test1:net> set address=192.168.80.141
zonecfg:test1:net> end
zonecfg:test1> verify
zonecfg:test1> commit
zonecfg:test1> exi
# chmod 700 /zones/test1
# zoneadm -z test1 verify
# zoneadm -z test1 verify
# zoneadm -z test1 install
Preparing to install zone .
Creating list of files to copy from the global zone.
Copying <7513> files to the zone.
Initializing zone product registry.
Determining zone package initialization order.
Preparing to initialize <1124> packages on the zone.
Initialized <1124> packages on zone.
Zone is initialized.
The file contains a log of the zone installation.
# zoneadm list -c
global
testzone
zone1
test1
# zoneadm list -cv
ID NAME STATUS PATH BRAND IP
0 global running / native shared
- testzone incomplete /testpool/home/test1 native shared
- zone1 incomplete /testpool/zones/zone1 native shared
- test1 installed /zones/test1 native shared
# zoneadm list -iv
ID NAME STATUS PATH BRAND IP
0 global running / native shared
- test1 installed /zones/test1 native shared
# zoneadm -z test1 ready
zoneadm: zone 'test1': WARNING: e1000g0:1: no matching subnet found in netmasks(4) for 192.168.80.141; using default of 255.255.255.0.
# zoneadm -z test1 boot
# zlogin -C -e \# test1
turkiye utf seçtim
cde
geri kalanlar default2
dns yok.
#zlogin test1

4 Ocak 2010 Pazartesi

sap parametrelerine işletim sistemi üzerinden bakma

sappfpar all

sappfpar check pf=WRP_D00_WERPPROA


SAP EarlyWatch Alert

aix komutları -2

lssrc -s nimsh --servis bilgileri
ipcs -ma --shared memory bilgileri

tail -f /var/hacmp/log/hacmp.out

vi .bash_profile

tivoli tsm sorguları

QUERY ACTLOG BEGINDATE=12/25/2009 BEGINTIME=NOW-1:00 ENDDATE=12/26/2009 ENDTIME=NOW ORIGINATOR=ALL


QUERY SESSION


QUERY EVENT * * BEGINDATE=12/25/2009 BEGINTIME=00:00 ENDDATE=12/26/2009 ENDTIME="08:02:14 "



select
volume_name as dbbackup from volhistory where type='BACK-
UPFULL' and devclass='LTO'



select
stgpool_name,count(*) as "toplam adet" from volumes where
devclass_name='LTO' group by stgpool_name order by 1


select count(*) as Scratch_adedi from libvolumes where status='Scratch'


select
count(*) as Lib_Kartus_sayisi from libvolumes


select
node_name,contact from nodes where node_name in (select
node_name from nodes where node_name in (select node_name
from events where (scheduled_start between '2009-12-22
08:00:00' and '2009-12-23 07:59:59') and LENGTH(domain_n-
ame) IS NOT NULL and (status='Missed')))


select
node_name,contact from nodes where node_name in (select
node_name from nodes where node_name in (select node_name
from events where (scheduled_start between '2009-12-22
08:00:00' and '2009-12-23 07:59:59') and LENGTH(domain_n-
ame) IS NOT NULL and (status='Failed')))


select
nodename,substr(char(date_time), 1, 16) as "TME",message
from actlog where (msgno=4005 or msgno=4007 or msgno=4018
or msgno=4037 or msgno=4987) and (date_time between
'2009-12-22 08:00:00' and '2009-12-23 07:59:59') order by
nodename

select
substr(char(date_time), 1, 16) as date_time,message from
actlog where (date_time between '2009-12-22 08:00:00' and
'2009-12-23 07:59:59') and severity<>'I'


select
entity,activity,bytes as BYTES from summary where
(activity='BACKUP' or activity='RESTORE' or activity='AR-
CHIVE' or activity='RETRIEVE') and (end_time between
'2009-12-22 08:00:00' and '2009-12-23 07:59:59') order by
bytes desc


select node_name,platform_name,client_os_level,client_version,c-
lient_release,client_level,client_sublevel from nodes
where node_name in (select entity from summary where
(activity='BACKUP' or activity='RESTORE' or activity='AR-
CHIVE' or activity='RETRIEVE') and (end_time between
'2009-12-22 08:00:00' and '2009-12-23 07:59:59'))

lob segment shrink

https://forums.sdn.sap.com/thread.jspa?threadID=1414229&messageID=7891933

https://websmp230.sap-ag.de/sap%28bD10ciZjPTAwMQ==%29/bc/bsp/spn/sapnotes/index2.htm?numm=821687
https://websmp230.sap-ag.de/sap%28bD10ciZjPTAwMQ==%29/bc/bsp/spn/sapnotes/index2.htm?numm=1319517
https://websmp130.sap-ag.de/sap%28bD10ciZjPTAwMQ==%29/bc/bsp/spn/sapnotes/index2.htm?numm=1010237

ESBIGTBL Tablespace is Growing More Than a Giga Per Day [ID 331534.1]


select owner, table_name, column_name from dba_lobs
where segment_name = 'SYS_LOB0000080468C00006$$'


select * from SAPSR3.tst03

SYS_LOB0000080468C00006$$

tst03 112
lob -3.25

alter table SAPSR3.TST03 disable row movement;

alter table SAPSR3.TST03 shrink space cascade;

select s.segment_name, c.column_name, s.bytes/1024/1024 "MB"
from dba_segments s, dba_lobs c
where s.segment_name = c.segment_name and c.table_name = 'DYNPSOURCE'
----------------------------------------------
SOFFCONT1.SYS_LOB0000068056C00007$$ 64G
RSBCS_REORG
RSDBDEOC
SO30 trans (RSBCSRE03 report)

14,4 08.20 GSYS_LOB0000076186C00006$$

alter table SAPSR3.TST03 enable row movement;
alter table SAPSR3.TST03 shrink space cascade;
alter table SAPSR3.TST03 enable row movement;


select s.segment_name, c.column_name, s.bytes/1024/1024 "MB"
from dba_segments s, dba_lobs c
where s.segment_name = c.segment_name and c.table_name = 'DYNPSOURCE'


SOFFCONT1
so30
RSBCS_REORG
RSSOCVPC

RSSORE00
RSCBCSRE03
RSBCSRE03

ALTER TABLE SOFFCONT1 MODIFY LOB (CLUSTD) (SHRINK SPACE);

select owner, table_name, column_name from dba_lobs
where table_name='SOFFCONT1'
brspace -c force -p initsid.sap -s 20 -l E -f tbalter -a shrink -s PSAPSR3 -o SAPSR3 -t TST03
-------------
set heading off;
set echo off;
Set pages 999;
set long 90000;
spool shrink_list
select 'brspace -c force -p initBP3.sap -s 20 -l E -f tbalter -a shrink -s PSAPSR3 -o SAPSR3 -t '||table_name from user_tables;
spool off
---------------
http://forums.sdn.sap.com/thread.jspa?threadID=338689

1. Run RSSO_DELETE_PRIVATE - I have run these for Document class RAW and OTF.
2. Run RSSODFRE
3. Run RSBCS_REORG - I have run these for Document class RAW and OTF.

This will delete and clean-up SOC3 and SOFFCONT1.
SOFFCONT1 stores any reports sent thru SAP office / workplace.

crontab

http://www.bilgipasaji.com/forum/hosting-genel-bilgi-395/46206-cron-jobs-kurulumu-ayarlari-kullanimi.html

sap portal açılış adımları

JdbcCon.log
/home/bpdadm/startdb.log

/home/bpdadm/startsap_SCS01.log

/home/bpdadm/startsap_JC00.log

error 0516-787 extendlv: Maximum allocation for logical volume

: 0516-787 extendlv: Maximum allocation for logical volume ... is 512

permalink
chlv -x 1000

brbackup, brspace datafile boyutu resize

brspace -f dfalter -a resize -f '/oracle/SID/sapdata4/sr3_27/sr3.data27' -s 11500M
alter database datafile '/oracle/SID/sapdata4/sr3_27/sr3.data27' resize 11500M

brspace -f dfalter -a resize -f '/oracle/SID/sapdata4/sr3_30/sr3.data30' -s 14500M

ALTER DATABASE DATAFILE '/oracle/SID/sapdata1/sysaux_4/sysaux.data4' RESIZE 10240M;
ALTER DATABASE DATAFILE '/oracle/SID/sapdata1/sysaux_4/sysaux.data4' AUTOEXTEND ON NEXT 500M MAXSIZE 10240M;

---------------------------
brbackup -u system/***** -c -m all -t online

./nbackint -p /utl/ -f password -- yedekleme kartuj sistemi ile bağlantı

backint -p D:\oracle\%ORACLE_SID%\102\database\init%ORACLE_SID%.utl -f password

brbackup -u system/manager -c -m all -t offline_force
brarchive -u system/manager -c force -sd


-p initBPD2.sap -d disk
-t online -m all -k no -e 0 -l E

-p initBPD.sap -d util_file_online -r initBPD.utl
-t online -m all -k no -l E

-p initBPD.sap -d util_file_online -r initBPD.utl -t online -b -d -m all -k no -l E

sap oracle bağlantısı testi

startsap options:
# startsap - starts r3 and database.
# startsap db - starts only the database.
# startsap r3 - starts r3 and assumes that the database is already started.

Stopping of an R/3 uses the file stopsap.
http://myadmin.wordpress.com/2007/01/29/startsap-what-is-behind-it/


R3trans -x sap database bağlantı sağlyabiliyormu
http://help.sap.com/saphelp_40b/helpdata/pt/3d/ad5ca44ebc11d182bf0000e829fbfe/content.htm

http://www.tech-recipes.com/rx/569/some-common-aixunix-commands/