Oracle初期化パラメータ整形シェル

https://gblog.hatenablog.jp/entry/2017/06/01/124439
https://qiita.com/keniooi/items/289db04addd2cfcf6fdd

 

#!/bin/bash

sqlplus -S / as sysdba <<EOF > a.log
set head off
set tab off
set lines 1000
set pages 5000

col NAME_COL_PLUS_SHOW_PARAM form a50;
col TYPE form a20;
col VALUE_COL_PLUS_SHOW_PARAM form a100;

show parameter;

EOF

# スペース5個以上をタブに置換
# 改行コードを\r\nに変更

cat a.log | \
sed -r 's/ {5,}/\t/g' |\
sed -r 's/$/\r/g' > $(uname -n).log

 

exit 0