четверг, 31 октября 2013 г.

Oracle Grid Standalone update 11.2.0.3 to 11.2.0.4


Backup ASM spfile
$srvctl config asm
ASM home: /u01/app/oracle/product/11.2.0/grid
ASM listener: LISTENER
Spfile: +DATA/asm/asmparameterfile/registry.253.811613369
ASM diskgroup discovery string: /dev/oracleasm/disks/*

$asmcmd
spbackup +DATA/ASM/ASMPARAMETERFILE/REGISTRY.253.811613369 /home/oracle/init+ASM.ora.backup

Backup OLR:
The default backup location for the OLR is in the path Grid_home/cdata/host_name

#ocrconfig –local –manualbackup

To restore OLR:
# crsctl stop crs
# ocrconfig -local -restore file_name
# ocrcheck -local
# crsctl start crs
$ cluvfy comp olr

Begin update
Shutdown the database, oem.
. oraenv prompt dbsid
$emctl stop dbconsole
$srvctl stop database -d dbsid

$unset ORA_CRS_HOME
$unset ORACLE_BASE
$unset ORACLE_HOME
$unset ORACLE_SID
Recommended practice is to upgrade an Oracle ASM instance with Oracle Universal Installer or asmca (after install new GI home) ./runInstaller

Confirm that asm, listener, database, oem are running.
. oraenv
+ASM
$crsctl stat res -t

. oraenv
dbsid
$srvctl start database -d dbsid
$emctl start dbconsole


воскресенье, 27 октября 2013 г.

Oracle update 11.2.0.3 to 11.2.0.4

I have Grid Standalone installation 11.2.0.3 and Oracle Database 11.2.0.3
I plan update to 11.2.0.4
Patching end date for 11.2.0.3 is 27-Aug-2015.

1. Need PSU (Doc ID 1392633.1) and Latest Opatch to apply.
Oracle Grid Infrastructure Patch Set Update 11.2.0.3.8 (Includes Database PSU 11.2.0.3.8) - 17272731
2. Download Patch Set 11.2.0.4 13390677

Pre-Upgrade Utility Note 884522.1

Use DBUA for out-of-place installation


to be continued ...

понедельник, 21 октября 2013 г.

iptables perfect ruleset


Loopback 
-A INPUT -i lo -j ACCEPT

Obsolete extensions:
• -m state: replaced by -m conntrack
• -j NOTRACK: replaced by -j CT --notrack (from 2.6.35)

TCP flag checks
-A INPUT (-p tcp) -m conntrack --ctstate INVALID -j badflags

State tracking
-A INPUT -m conntrack --ctstate ESTABLISHED -j ACCEPT

http://inai.de/documents/Perfect_Ruleset.pdf

понедельник, 14 октября 2013 г.

downgrade php 5.3.to 5.2 on CentOS 6

The Atomic repo is unavailable.

yum -y install bzip2-devel curl-devel   db4-devel gmp-devel httpd-devel pam-devel libstdc++-devel pcre-devel  readline-devel  libtool gcc-c++  libc-client-devel cyrus-sasl-devel openldap-devel  postgresql-devel unixODBC-devel libxml2-devel net-snmp-devel libxslt-devel libxml2-devel expat-devel ncurses-devel libjpeg-devel libpng-devel freetype-devel libmcrypt-devel  mhash-devel libtidy-devel  freetds-devel aspell-devel

wget http://museum.php.net/php5/php-5.2.17.tar.bz2

and ./configure

make 
make install


четверг, 10 октября 2013 г.

Asterisk convert sounds

ls -1| awk -F. ' {print $1}'| xargs -n 1 --replace=$ sox -r 6000 $.vox -r 8000 $.gsm resample -ql
ls -1| awk -F. ' {print $1}'| xargs -n 1 --replace=$ astconv /usr/lib64/asterisk/modules/codec_g729.so -e 160  $.alaw $.g729