Parameter on bash.

MacBook-de-Andre-Silva als$ cat tmp.sh
#!/bin/bash

echo spool  /home/analyze_$2.log
MacBook-de-Andre-Silva als$ ./tmp.sh - info_parameter
spool /home/analyze_info_parameter.log
MacBook-de-Andre-Silva als$ ./tmp.sh - info_number
spool /home/analyze_info_number.log
MacBook-de-Andre-Silva als$

Read More

Script Rename File / Windows / Expdp

@echo off
Rem Get Day,Mth & Year from %Date%
set Day=%Date:~0,2%
set Mth=%Date:~3,2%
set Yr=%Date:~6,4%
ren 1.txt 1_%Day%-%Mth%-%Yr%_I.txt

@echo off
ren texte.txt texte_%Date:~0,2%%Date:~3,2%%Date:~6,4%.txt


set ORACLE_SID=TEST

C:\oracle\app\Administrador\product\11.2.0\dbhome_1\BIN\expdp.exe siltech/siltech@INSTANCE parfile=F:\Oracle\Backup\expdp.par

rename F:\export\expfull_TEST.log expfull_TEST_%Date:~0,2%%Date:~3,2%%Date:~6,4%.log
       
rename F:\export\EXPFULL_TEST.dmp expfull_TEST_%Date:~0,2%%Date:~3,2%%Date:~6,4%.dmp
       
forfiles -p "F:\export\" -d -5 -m *.dmp -c "cmd /c del /f /q @path"

Read More

Bytecode [ Perlcc is dead on RedHat 6.* -> PP new Solution ]

#Commands
CD_IN='cd'
CD_OUT='cd ..'
TAR='tar -xvzf'
PERL_MAKEFILE='perl Makefile.PL'
MAKE='make'
MAKE_INSTALL='make install'
CHMOD='chmod +x Makefile'

#Module
M1=IO-Compress-2.060
M2=Archive-Zip-1.30
M3=Getopt-ArgvFile-1.11
M4=Module-ScanDeps-1.10
M5=PAR-1.007
M6=PAR-Dist-0.49
M7=AutoLoader-5.73
M8=Compress-Raw-Zlib-2.060
M9=AutoLoader-5.73
M10=CPAN-Meta-Requirements-2.122
M11=CPAN-Meta-YAML-0.008
M12=JSON-PP-2.27202
M13=Parse-CPAN-Meta-1.4404
M14=version-0.9902
M15=CPAN-Meta-2.130880
M16=Perl-OSType-1.003
M17=Module-Metadata-1.000011
M18=Module-Build-0.4004
M19=Text-ParseWords-3.29
M20=Test-Harness-3.26
M21=Time-Local-1.2300
M22=File-Path-2.09
M23=File-Temp-0.2301
M24=Test-Simple-0.98
M25=PathTools-3.40
M26=ExtUtils-MakeMaker-6.66
M27=IO-1.25

#Uncompress
FILE_GZ=`ls *.gz`
for i in ${FILE_GZ} ; do \
       ${TAR} ${i}
done;

#Execute Install
for i in ${M1} ${M2} ${M3} ${M4} ${M5} ${M6} ${M7} ${M8} ${M9} ${M10} ${M11} ${M12} ${M13} ${M14} ${M15} ${M16} ${M17} ${M18} ${M19} ${M20} ${M21} ${M22} ${M23} ${M24} ${M25} ${M26} ${M27} ${M28} ${M29} ; do \
${CD_IN} ${i}
${PERL_MAKEFILE}
${CHMOD}
${MAKE}
${MAKE_INSTALL}
${CD_OUT}
done;

Read More

Reser Tablet ZTE

Emergency Call + *983*987#

Read More

Windows / FORFILES - [ To delete old archives ]

command : Forfiles
-p  = PATH
-d  = DAYS
-m = REGEX
-c  = NEW COMMAND


C:\Users\Administrador\Desktop\IDADB_TEST>forfiles -p "C:\Users\Administrador\De
sktop\IDADB_TEST" -d -80 -m *.pl

"IdaDB_03122012.pl"
"IdaDB_Windows_SRV.pl"
"IdaDB_Windows_SRV_03122012.pl"
"tmp1.pl"

C:\Users\Administrador\Desktop\IDADB_TEST>forfiles -p "C:\Users\Administrador\De
sktop\IDADB_TEST" -d -80 -m *.pl -c "cmd /c del /f /q @path"

C:\Users\Administrador\Desktop\IDADB_TEST>forfiles -p "C:\Users\Administrador\De
sktop\IDADB_TEST" -d -80 -m *.pl
ERRO: Nenhum arquivo encontrado com os critérios de pesquisa especificados.

Read More

ORACLE - [ spreport ]

1:
SQL> exec perfstat.statspack.snap

2:
SQL> exec perfstat.statspack.snap

3:
SQL> @$ORACLE_HOME/rdbms/admin/spreport

Read More

ORACLE - NLS_LANG

SQL> select DECODE(parameter, 'NLS_CHARACTERSET', 'CHARACTER SET',
'NLS_LANGUAGE', 'LANGUAGE',
'NLS_TERRITORY', 'TERRITORY') name,
value from v$nls_parameters
WHERE parameter IN ( 'NLS_CHARACTERSET', 'NLS_LANGUAGE', 'NLS_TERRITORY');

NAME          VALUE
------------- ----------------------------------------------------------------
LANGUAGE      AMERICAN
TERRITORY     AMERICA
CHARACTER SET WE8ISO8859P1

SQL> exit

NLS_LANG=<LANGUAGE>_<TERRITORY>.<CHARACTER SET>

C:\>set NLS_LANG=AMERICAN_AMERICA.WE8ISO8859P1

C:\>echo %NLS_LANG%
AMERICAN_AMERICA.WE8ISO8859P1

Read More