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.