shell脚本获取oracle pdb

最新推荐文章于 2022-10-13 21:42:49 发布

原创最新推荐文章于 2022-10-13 21:42:49 发布 · 1.8k 阅读

0 ·

CC 4.0 BY-SA版权

文章标签：

#oracle

Oracle 专栏收录该内容

63 篇文章

订阅专栏

这是一个用Shell脚本展示Oracle数据库多PDB名称的脚本，适用于Linux和AIX平台。脚本首先通过SQL查询确定CDB状态，然后在CDB为开启状态时列出所有非种子PDB。

#!/bin/ksh
###############################################################################################################
#Script name: show_oracle_mode.sh
#Script description: show oracle pdb name for multi pdbs.
#Current Release Version: 1.0.0
#Script Owner:
#Latest editor:
#Support platform: Linux & AIX.
#Change log:first version.
#
#Descript:date 2021/8/17
#
#
###############################################################################################################
load_sql="select cdb from v\$database;"
show_pdbs="SELECT NAME FROM V\$PDBS where name not like 'PDB\$SEED';"
open_mode=`sqlplus -S "/ as sysdba" <<EOF
set feed off
set heading off
$load_sql
exit;
EOF`
open_mode=`echo $open_mode | sed 's/[ \t]//g'`
#echo $open_mode
#res=`echo "$open_mode"| awk '{printf "%s\n", $0}'`
#echo $res
if [[ $open_mode == "YES" ]];then
pdbs=`sqlplus -S "/ as sysdba" << EOF
set feed off
set heading off
$show_pdbs
exit
EOF`
for pdbname in $pdbs;do
echo $pdbname
done
elif [[ $open_mode == "NO" ]];then
echo "open_mode is NO"
else
echo "open_mode does not exist."
exit 1
fi