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