ORACLE PATCH

download opatch

1. download patch
2. unpack
3. shutdown instance
4. read README file
5. change directory to unpacked archive
6. opatch apply
7. run Post Installation Instructions

check patches allready install:

opatch lsinventory
opatch lsinventory -detail

check patch:

opatch query -all /[path_to_patch_directory]

check opatch options

opatch -help [option]

logs:
[ORACLE_HOME]/cfgtoollogs/opatch
[ORACLE_HOME]/cfgtoollogs/opatch/opatch_history.txt
rollback:

opach rollback -id [nr_patcha]

check invalid objects:

SELECT object_name FROM dba_objects WHERE status = 'INVALID';

compile all invalid objects:
[ORACLE_HOME]/rdbms/admin/utlrp.sql
which launch script [ORACLE_HOME]/rdbms/admin/utlprp.sql z parametrem=0
- parametr=0 - run parallel with CPU_COUNT
- parametr=1 - run in one process
- parametr=N - number of parallel run

LINUX CDRECORD

burn DVD:

1. create ISO file

mkisofs -r -o plik.iso /[directory_to_burn/

- DVD+RW

2. disk format (only once in case of new disk):

cdrecord -v dev=/dev/hdc -format

3. burn:

cdrecord -v dev=/dev/hdc speed=4 -dao -data file.iso

4. next record do not need erase disk

- DVD-RW

2. format is not necessary

3. burn:

cdrecord -v dev=/dev/hdc speed=4 -dao -data file.iso

4. next record need erase disk:

cdrecord -v dev=/dev/hdc blank=fast

options:

-dao - write Disk At Once

-tao - write Track At Once (for multisesion, default)

share (files up to 2GB for ISO format):

tar -cf - /[dir_to_tar] |split -b 2000m - FILE.tar

LINUX SCREEN

Table of Contents

• 1 OS commands
• 2 Screen Commands
• 3 .screenrc

1 OS commands

screen -ls	session list
screen -r [session]	attach to active session
screen -x	attach multiply users to active session
screen -dmS [session] [app]	run app without start screen

2 Screen Commands

COMMAND	DESCRIPTION
C-a d	deatach
C-a "	window list
C-a w	window list
C-a :number [0-9]	change window nr
C-a A	change window name
C-a shift+n	show window nr
C-a c	new window
C-a k	kill window
C-a [0-9]	go to window nr
C-a [SPC]	next window
C-a [BPC]	previous window
C-a C-a	last active window
C-a [ESC]	turn on mode scrollback/copy
[SPC]	start/stop buffer copy
C-a ]	paste from buffer
C-a ?	help
C-a :	command line

3 .screenrc

startup_message off
deflogin off
defnonblock 5
termcapinfo xterm*|rxvt* 'Co#256:AB=\E[48;5;%dm:AF=\E[38;5;%dm'
termcapinfo xterm*|rxvt* ti@:te@
#defbce "on"
vbell off
altscreen on
bindkey -k F1 prev
bindkey -k F2 next
bind ^v screen -t ROOT su -
hardstatus alwayslastline
hardstatus string '%{= KM}[ %{G}%H %{M}][%= %{c}%?%-Lw%?%{C}(%{C}%n*%f%t%{C})%{c}%?%+Lw%?%? %=%{M}][%{G} %c %{M}]'
defscrollback 1024
screen 0