The Hellespontos: 2010

13 Temmuz 2010 Salı

TSM UPDATE PATH

driver tsm tarafından gozukuyor olmasına rahmen tivolide gozukmuyorsa;
UPDATE PATH BOYDAKTSM DRIVE01 SRCTYPE=SERVER DESTTYPE=DRIVE LIBRARY=TS3310 DEVICE=mt2.0.0.4 ONLINE=YES AUTODETECT=NO

veya
object view->server storage -> tape paths

q drive f=d
q path
q libr

21 Mayıs 2010 Cuma

aix aygıtların ayrıntıları

lscfg -vpl fcs1

lsdev -C -c disk

lscfg -vl hdisk2
lsattr -E -l hdisk12

lslpp -l | grep mpio

storage pool
Maximum Scratch Volumes Allowed
--------------
snap gbc

snap -ar
snap -ac

15 Nisan 2010 Perşembe

BR0971W The default temporary tablespace of database sid is set to SYSTEM

BR0971W The default temporary tablespace of database is set to SYSTEM

cozum;

select username,temporary_tablespace from dba_users

ALTER DATABASE DEFAULT TEMPORARY TABLESPACE PSAPTEMP;

8 Nisan 2010 Perşembe

SAP se14 partitioning

-se14
-tablo edit
-storage parameter
-for new creation
partition ekliyoruz.
-extact-force

30 Mart 2010 Salı

SAP db16 table

select * from SAPSR3.DBMSGORA where SAPSR3.DBMSGORA.time like '20100316%' and severity='E'

select * from SAPSR3.DBCHECKORA

select * from SAPSR3.DBDIFF

Solaris zoneadm ve security, websites oracle

http://blogs.sun.com/menno/entry/faster_zone_provisioning_using_zoneadm
http://www.mernin.com/blog/?p=68

more /etc/security/login.cfg

http://wikis.sun.com/display/SAPonSun/Running+SAP%27s+Java+Gui+on+OpenSolaris+%28sort+of%29

http://www.wiziq.com/online-tests/9296-sap-basic-installation-on-unix-oracle-data-base-test-2
http://www.oracle-base.com/articles/10g/Auditing_10gR2.php
http://www.akadia.com/services/ora_linux_install_10g.html

http://unix.ittoolbox.com/groups/technical-functional/unixadmin-l/script-to-automate-sending-of-alertnotification-of-filesystem-utilization-3187954
http://www.unix.com/unix-dummies-questions-answers/36228-aix-send-mail-html-message-body-binary-attachment.html
http://www.oracle.com/technology/oramag/code/tips2004/060704.html
http://www.praetoriate.com/oracle_tips_alert_scripting.htm
http://ipucu.enderunix.org/view.php?id=44&lang=en
http://forums13.itrc.hp.com/service/forums/questionanswer.do?admit=109447627+1266486022084+28353475&threadId=1027646
http://forums.sdn.sap.com/message.jspa?messageID=6864807
http://www.oracle.com/technology/oramag/code/tips2005/index.html
--------------------------------------------
http://download.oracle.com/docs/cd/B19306_01/server.102/b14230/toc.htm
http://download.oracle.com/docs/cd/B19306_01/server.102/b14239/toc.htm
http://download.oracle.com/docs/cd/B19306_01/server.102/b14239/manage_ps.htm
http://kb.dbatoolz.com/tp/2693.create_oracle_10gr2_standby_database_using_real_time_apply.html

http://www.dbasupport.com/forums/showthread.php?t=58129
http://download.oracle.com/docs/cd/B19306_01/server.102/b14239/role_management.htm#i1027411
http://www.dba-oracle.com/t_oracledataguard_235_dba_logstdby_.htm

http://www.oracle.com/technology/obe/obe9ir2/obe-ha/dataguard/dg.htm#10

broker
http://www.dbasupport.com/oracle/ora11g/11gDataGuard_02.shtml
--http://www.ritzyblogs.com/OraTalk/EntryId/122/How-to-setup-DGMGRL-broker-with-example

http://www.dba-oracle.com/t_password_security.htm sec

solaris format komudu örnek

format -e c1t2d0
295 zfs list
296 zpool add -f rpool c1t2d0s0
297 prtvtpc /dev/rdsk/c1t0d0s0 | fmthard -s - /dev/rdsk//c1t2d0s0
298 prtvtoc /dev/rdsk/c1t0d0s0 | fmthard -s - /dev/rdsk//c1t2d0s0
299 zpool attach rpool c1t0d0s0 c1t2d0s0
300 zpool attach -f rpool c1t0d0s0 c1t2d0s0
301 format
302 format
303 format
304 format
305 zpool attach -f rpool c1t0d0s0 c1t2d0s0
306 installgrub -m /boot/grub/stage1 /boot/grub/stage /dev/rdsk/c1t2d0s0 -- iptal
307 installgrub -m /boot/grub/stage1 /boot/grub/stage2 /dev/rdsk/c1t2d0s0
308 zpool status
309 historyq

zpool detach rpool c1t2d0s0
----------------------
uname -r
pkginfo -i
showrev -p

aix send mail

cat /tmp/t/mailheader /tmp/t/mailbody | /usr/lib/sendmail -t

uuencode /tmp/text.txt | mailx -s "my report" ferhan@tekin.com

mail TEST

SAP - Oracle parameters sapnotes

830576 oracle - sap parameter
1171650
1289199
926023 security
709756
Note 619188 - FAQ: Oracle wait events

3 Mart 2010 Çarşamba

IBM Storage fw geçilmesi

ILK OLARAK STORAGE ILE BIRLIKTE GELEN CD NIN IÇINDEKI STORAGE MANAGER I KURUYORUZ. PROGRAMI AÇTIĞIMIZDA OTOTAMTIK OLARAK STORAGE TARATIYORUZ. DIKKAT EDILMESI GEREKEN NOKTA STORAGE ILE MAKINA AYNI NETWORK TE OLMALIDIR. STORAGE BULDUKTAN SONRA SAĞ TIKALYIP MANAGE DIYORUZ. ARAÇ CUBUĞUNDAN ADVANCED – MAINTAINCE DEDIĞIMIZDE HANGI FW I GEÇEĞIMIZI ISTEYECEĞI MENULER CIKIYOR. ILK ÖNCE DISKLERI SONRA CONTROLLER FW GECMEMIZ DAHA DOGRU OLUR. BU ESNADA STORAGE ILE BILI ALIŞ VERIŞI OLMAMASI GEREKMEKTEDIR. FW GECECEĞIMI DOSYALARI IBM SUPPORT SITESINDEN STORAGE MODELINI YAZARAK TEMIN EDIYORUZ.SON VERSION 07.60.28 OLARAK GUNCELLENDI.

12 Şubat 2010 Cuma

SAP kernel upgrade

sidadm> stopsap
su - root
cd sapmnt
sapmnt> cp -pr exe exe_old
cd /usr/sap/trans/kernel_yeni
SAPCAR -xvf SAPEXE_236-20001810.SAR
SAPCAR -xvf SAPEXEDB_236-20001829.SAR
SAPCAR -xvf tp_239-20001810.sar
SAPCAR -xvf lib_dbsl_241-20001829.sar
testadm> rm SAPEXE_236-20001810.SAR
testadm> rm SAPEXEDB_236-20001829.SAR
testadm> rm tp_239-20001810.sar
testadm> rm lib_dbsl_241-20001829.sar
root
sapmnt>cd exe
>rm -Rf *
cp -pr /usr/sap/trans/kernel_yeni/* /sapmnt/BMI/exe/
ls -lrt
sapmnt>
cp -pr exe_yedek/saproot.sh exe/
cd exe
bash-3.00# ksh saproot.sh BMI
saproot.sh[122]: whoami: not found
saproot.sh[122]: test: argument expected
Preparing saposcol ...

Preparing icmbnd ...
done
------------
sm51 den release note deyip sondurumu bakabilirsiniz
----------
diger sistem için
test2adm> pwd
/sapmnt/BMT
test2adm> ls
exe global kernel_yeni profile
test2adm>
test DE OLUŞTURULAN KERNEL_YENİ KLASORU /SAPMNT/ İÇERİSİNE KOPYALANDI. ADI EXE OLARAK DEĞİŞİTİRİLDİ.

11 Şubat 2010 Perşembe

Solaris xterm ile bağlantı ve locale ayarları

chmod 777 /usr/openwin/lib/X11/fontserver.cfg
ex path: /usr/bin/:/usr/dt/bin:/usr/openwin/bin:/usr/ucb

ssh -X -l root ip
DISPLAY=:0.0
export DISPLAY
xclock
--------------
locale
LC_ALL
vim /etc/defaults/locale
locale -a
localedef -v -c -i en_US -f UTF-8 en_US.UTF-8
localedef -i en_US -c -f UTF-8 en_US.UTF-8
$HOME/.profile or
$HOME/.cshrc
LANG=C
LC_ALL=C -- c asci

Example from the /etc/default/init file:

10 Şubat 2010 Çarşamba

SAP organization level ekleme

se38
PFCG_ORGFIELD_CREATE

Solaris'de IP aliasing - Bir ethernet kartina birden fazla IP verm

Solaris'te IP aliasing yapmak icin:

# ifconfig arabirim:N plumb
# ifconfig arabirim:N IP_ADRESİ netmask NETMASK up

N: 1 den buyuk ve izin verilen en fazla yalanci aygit sayisindan kucuk bir sayi(solaris 2.6 ve onceki versiyonlarda 255)
ornek: ce0 ethernet arabirimi icin 192.168.1.1 IP adresini 2. IP olarak eklemek icin:

# ifconfig ce0:1 plumb
# ifconfig ce0:1 192.168.1.1 netmask 255.255.255.0 up

Degisikligin her acilista etkinlesmesi icin
/etc/hosts dosyasina asagidaki gibi kayit eklenir.
192.168.1.1 host_adi

/etc/hostname.ce0:1 dosyasi olusturup icerisine
host_adi
yazilir
# cat /etc/hostname.ce0:1
host_adi
#

SAP parola değiştirme ve os den db bağlantı

R3trans baglantisini test edilmesi
R3trans -x

sapsr3 parola degistirme
brconnect -u / -f chpass -o sapsr3 -p password
--------------------------
işletim sisteminde database bağlantı yapma;
DROP TABLE OPS$sidADM.SAPUSER CASCADE CONSTRAINTS;

CREATE TABLE OPS$sidADM.SAPUSER
(
USERID VARCHAR2(255 BYTE),
PASSWD VARCHAR2(255 BYTE)
)
TABLESPACE SYSTEM
PCTUSED 40
PCTFREE 10
INITRANS 1
MAXTRANS 255
STORAGE (
INITIAL 64K
MINEXTENTS 1
MAXEXTENTS UNLIMITED
PCTINCREASE 0
FREELISTS 1
FREELIST GROUPS 1
BUFFER_POOL DEFAULT
)
LOGGING
NOCOMPRESS
NOCACHE
NOPARALLEL
MONITORING;

--DROP SYNONYM OPS$SAPSERVICEsid.SAPUSER;

CREATE SYNONYM OPS$SAPSERVICEsid.SAPUSER FOR OPS$sidADM.SAPUSER;

GRANT INSERT, SELECT, UPDATE ON OPS$sidADM.SAPUSER TO OPS$SAPSERVICEsid;

SAP tp ile request taşıma

request cofile ve datafile a taşınıyor
tp addtobuffer request SID pf=/usr/sap/trans/bin/TP_DOMAIN_SID.PFL
tp SETTRANSFERRED ALL SID pf=/usr/sap/trans/bin/TP_DOMAIN_SID.PFL REMOTE=SID2 -Dtransdir=/usr/sap/trans
tp import request SID U client=900 pf=/usr/sap/trans/bin/TP_DOMAIN_SID.PFL
--yok tp TRANSMITBUFFER SID pf=/usr/sap/trans/bin/TP_DOMAIN_SID.PFL REMOTE=SID2 -Dtransdir=/usr/sap/trans

SAP Support Package installation

Basis Plug-In (PI_BASIS) 2006.1
sap note:1007796

5 Şubat 2010 Cuma

Aix to Solaris nfs mount

aix makinada
/etc/exports dosyasina;
/test -sec=sys:krb5p:krb5i:krb5:dh,rw,root=solaris_hostname

usr/sbin/exportfs -a yi calıştırıyoruz.

solaris makinada
/etc/filesystems/

/test2:
dev = "/test"
vfs = nfs
nodename = aix_hostname
mount = false
type = sap_nfs
options = rw,bg,soft,intr,sec=sys
account = false

/etc/default/nfs
client version 3 olacak
sonra;
mount aix:/test /test2
client version hemen set olmazsa;
mount -F nfs -o vers=3 aix:/test /test2

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

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/