CharliePiks: Juni 2016

Donnerstag, 16. Juni 2016

How to verify private and public keypair?

Reads the private key an prints the corresponding public key which can be directly compared to your available public keys

1	ssh-keygen -y -e -f myprivate.key

Donnerstag, 2. Juni 2016

Oracle Database Daily Backup and delete older then 5 days

#!/bin/sh
#exec >/tmp/export.log
#exec 2>&1

# Set Environment
. ~oracle/oracle_env_arculhbt
DIR=/oradata/arculhbt/dpdump/daily_backup
DD=DATAPUMPDIR

sqlplus / as sysdba <<EOF
  set echo on
  create or replace directory $DD as '$DIR';
  exit
EOF

DUMP=arculhbt_$(date +%Y-%m-%d)_full.dmp
LOG=arculhbt_$(date +%Y-%m-%d)_full_exp.log

if [ -f $DIR/$DUMP ];then
  echo Dump already exist! => "Abort!"
  exit 1
  # rm $DIR/$DUMP
fi

if [ -f $DIR/$LOG ];then
  rm $DIR/$LOG
fi

P=`dd if=/dev/urandom bs=512 count=1 2>/dev/null | tr -dc "a-zA-Z0-9-_\.\+\$\?" | fold -w 15 | head -1`
echo "alter user system identified by \"$P\";" | sqlplus -S "/ as sysdba"

expdp system/"$P" full=yes DIRECTORY=$DD DUMPFILE=$DUMP logfile=$LOG METRICS=YES
#  STATUS=120


sqlplus / as sysdba <<EOF
set echo on
drop directory $DD;
exit
EOF

echo
echo "-----[ DONE ]-----"

echo "Create Zip-File and delete dump-file"
zip -rm /oradata/arculhbt/dpdump/daily_backup/arculhbt_$(date +%Y-%m-%d)_full.zip /oradata/arculhbt/dpdump/daily_backup/arculhbt_$(date +%Y-%m-%d)_full.dmp /oradata/arculhbt/dpdump/daily_backup/arculhbt_$(date +%Y-%m-%d)_full_exp.log

echo "Delete Backups older then 5 days"
find /oradata/arculhbt/dpdump/daily_backup -iname "*.zip" -mtime +5 -delete

Sending Mail from Command Line

Method 1 - Perl Script with attachment

#!/usr/bin/perl
 
use MIME::Lite;
 
$to = 'test_1@mail.de;test_2@mail.de';
 
$from = 'test_3@mail.de';
 
$subject = 'Test_Mail';
 
$message = 'Hello  
 
this is a test mail
 
best regards
 
me
 
';
 
 
$msg = MIME::Lite->new(
 
                 From     => $from,
 
                 To       => $to,
 
                 Cc       => $cc,
 
                 Subject  => $subject,
 
                 Type     => 'multipart/mixed'
 
                 );
 
 
# Add your text message.
 
$msg->attach(Type         => 'text',
 
             Data         => $message
 
            );
 
 
# Specify your file as attachement.
 
$msg->attach(Type        => " application/msexcel ",
 
             Path        => '/home/test_user/excel_filename.xls',
 
             Filename    => 'excel_filename.xls',
 
             Disposition => 'attachment'
 
            );
 
$msg->send;
 
print "Email Sent Successfully\n";

Method 2 - From Command Line

echo Hello, whats up | mail -s "Request" "test@mail.de"

Method 2a - From Command Line with attachment

mail -s "Test" test@mail.de < /var/log/messages

Method 3 - From Command Line with attachment

1	echo "Test: OK" \| mutt -a "error.txt" "calc.txt" -s "Subject: OK!" -- test.me@mail.de

Transfer file from Windows to Linux

Required Software

PSCP
PuttyGen

http://www.chiark.greenend.org.uk/~sgtatham/putty/download.html

Generate Key

1. Start puttygen.exe on Windows

2. Change → "Number of bits in a generated key" to what you need, example 4096 or 2048

3. Click "Generate"

4. Change → "Key Comment"

5. Chose → "Key passpharse" and "Confirm passpharse"

6. Select and copy all of the text in the box labeled “Public key for pasting into OpenSSH authorized_keys file”.

7. Paste the public key from the Clipboard into the the authorized_keys file of the, which is located in the .ssh directory in your home directory on the remote host( If no such file is there we will have to manually create it).

8. Save the private key.

9. Use this code to transfer automatically

echo y | pscp.exe -i privatekey.ppk -pw myPassword E:\Zinsmatrix\Zinsmatrix\*.csv* oracle@10.10.10.10:/home/oracle/Zins

Check Tablespace size from Oracle Database

select df.tablespace_name "Tablespace", totalusedspace "Used MB",(df.totalspace - tu.totalusedspace) "Free MB", df.totalspace "Total MB", round(100 * ( (df.totalspace - tu.totalusedspace)/ df.totalspace)) "Pct. Free" from (select tablespace_name, round(sum(bytes) / 1048576) TotalSpace from dba_data_files group by tablespace_name) df, (select round(sum(bytes)/(1024*1024)) totalusedspace, tablespace_name from dba_segments group by tablespace_name) tu where df.tablespace_name = tu.tablespace_name ;

Change Archive Mode in Oracle Database

1. Check status of archivelog

select log_mode from v$database;

2. Shutdown Database

shutdown immediate;

3. Startup Database in Mount-Mode

startup mount;

4. Alter Database

alter database noarchivelog;

alter database archivelog;

5. Open Database

alter database open;

6. Check if the archivlog is correct

select log_mode from v$database;

Disconnect User from Oracle Database

1. Select all user:

select username from v$session where username is not null;

2. Select specific user:

select sid,serial#,program from v$session where username = 'yourusername';

3. Disconnect user by SID and Serial#:

alter system disconnect session 'SID','Serial' immediate;

Mittwoch, 1. Juni 2016

Search and replace in multiple files in Linux with grep

#Syntax
grep -rl matchstring somedir/ | xargs sed -i 's/string1/string2/g'
 
#Example
grep -rl 'arcust' ./ | xargs sed -i 's/arcust/arcusp/g'

Oracle Database Export Import

Export

#!/bin/sh
#exec >/tmp/export.log
#exec 2>&1
 
# set environment
. ~oracle/env
 
 
DIR=/oracle/tmp_dump
DD=DATAPUMPDIR
 
sqlplus / as sysdba < Abbruch!"  exit 1  # rm $DIR/$DUMP
fi
 
if [ -f $DIR/$LOG ];then
  rm $DIR/$LOG
fi
 
P=`dd if=/dev/urandom bs=512 count=1 2>/dev/null | tr -dc "a-zA-Z0-9-_\.\+\$\?" | fold -w 15 | head -1`
echo "alter user system identified by \"$P\";" | sqlplus -S "/ as sysdba"
 
expdp system/"$P" full=yes DIRECTORY=$DD DUMPFILE=$DUMP logfile=$LOG METRICS=YES
#  STATUS=120
 
 
sqlplus / as sysdba <<EOF
set echo on
drop directory $DD;
exit
EOF 

echo "-----[ Done ]-----"

Import

#!/bin/sh
 
  sqlplus / as sysdba <<EOF
  set echo on
  create or replace directory DUMP_DIR as '/oracle/tmp_dump/';
  GRANT read, write ON DIRECTORY DUMP_DIR to system;
  select * from dba_directories;
        exit
EOF
 
# -----
# generate a random password for SYSTEM
 
P=`dd if=/dev/urandom bs=512 count=1 2>/dev/null | tr -dc "a-zA-Z0-9-_\.\+\$\?" | fold -w 15 | head -1`
echo "alter user system identified by \"$P\";" | sqlplus -S "/ as sysdba"
 
 
impdp system/"$P"  directory=DUMP_DIR schemas=test_1,test_2 table_exists_action=replace dumpfile=full.dmp logfile=imp.log

Create file with size if 1GB

1	dd if=/dev/zeroof=1g.bin bs=1G count=1

Vim Tipps and Tricks

Vim

w = go to the next word
b = go the the word before
G = go to the end of file
G<number> = go to the number
gg = go to the beginning of the file
r = replace the char under the cursor
dw = delete from cursor to end of word
d$ oder D = delete from cursor to end of the line
d0 = delete from cursor to beginning of the line
dd = delete current line

dd = delete from current line the next lines
dG = delete from current line to end of file
d1G = delete from cursor to the beginning of the file
I = Enter insert mode at first non-blank character
S = Delete line and begin insert at beginning of same line
o = Enter insert mode and create a new line below
O = Enter insert mode and create a new line above
C = Delete from cursor to end of line and beginn insert
^ = First non-blank character of the line

Search

* = Serached under the cursor - forward (bounded)
g* = Searched unde the cursor forward (unbounded)

Search and replace

1	:%s/OLD/NEW/g