The Hellespontos

11 Ağustos 2014 Pazartesi

TSM backupset silinmesi

delete node
ANR2152E REMOVE NODE
q filespace
delete filesp *
q backupset
delete backupset nodename backupsetname

query occupancy nodename
select * from backups where node_name=

9 Ağustos 2014 Cumartesi

KERNEL_UPGRADE_721

Olayın Tanımı

7.20 to 7.21_ext uc kernel upgrade

Öncesinde Yapılacak İşlemler

Disp+work ile version kontrol edilir.

Tavsiye Edilen İşlem

İşlem sonrası sgen çalıştırılabilir.

Yapılan İşlem

snote 1553465 - Prerequisites for 720/721 EXT and higher kernels on Windows

1713986 - Installation of kernel 721 (EXT)

adm

Sap stop edilir ve eski uc old yapılarak yedeği alınır. Servislerde stop edilir. Yeni kernel dosyası eskisinin adıyla değiştirilir.

-sap servisler ve sap açılır.

Cıkan Sorun ve Problemler

Ek Bilgiler

4 Ağustos 2014 Pazartesi

Cannot process message; maximum size exceeded hatası için;
mpi/total_size_MB parametresi istenen mail boyutunun 4 katı olarak girilmelidir.
snote 690020 SAPconnect send process hangs with large mails
ayrıca SCOT > SMTP > Internet Set > output format for SAP Documents kısmında formatlar set edilmelidir.

sood tablolarını silmek için;
RSBCS_DELETE_QUEUE
RSBCS_REORG

966854 - Reorganization - New report

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: