ablog

不器用で落着きのない技術者のメモ

Oracle Database の初期化パラメータに含まれるパスを抽出する

-bash-3.00$ echo -e "/ as sysdba\nselect value from v\$parameter;"|sqlplus -s|perl -nle '/\// and print'
/export/home/app/oracle/product/11.2.0/dbhome_1/dbs/spfileorcl.ora
/export/home/oradata/orcl/control01.ctl, /export/home/app/oracle/fast_recovery_area/orcl/control02.ctl
?/dbs/arch
/export/home/app/oracle/fast_recovery_area
/export/home/app/oracle/diag/rdbms/orcl/orcl/trace
/export/home/app/oracle/diag/rdbms/orcl/orcl/trace
/export/home/app/oracle/diag/rdbms/orcl/orcl/cdump
/export/home/app/oracle/admin/orcl/adump
/export/home/app/oracle/product/11.2.0/dbhome_1/dbs/dr1orcl.dat
/export/home/app/oracle/product/11.2.0/dbhome_1/dbs/dr2orcl.dat
/export/home/app/oracle