oracle 批量修改系统默认账号密码

1、脚本内容ch_o_passwd.sh

#!/bin/bash

#export ORACLE_SID=$1
ps -ef |grep ora_smon |grep -v grep |grep -vi asm |awk '{print $NF}' |awk -F'_' '{print $NF}'
for ORACLE_SID in $(ps -ef |grep ora_smon |grep -v grep |grep -vi asm |awk '{print $NF}' |awk -F'_' '{print $NF}')
do
if [[ -z $ORACLE_SID ]];then
	echo "Please input ORACLE_SID, usage: $0 ORACLE_SID"
	exit 1 
fi
v_num=$(ps -ef |grep ora_smon_${ORACLE_SID} |grep -v grep|wc -l)
if [[ $v_num -gt 0 ]];then
	echo "this sid $ORACLE_SID normal run."
else
	echo "this sid $ORACLE_SID not run. It will exit."
	exit 1
fi 
source ~/.bash_profile

v_password='1qaz@WSX'
v_users='OJVMSYS,LBACSYS,OUTLN,SYS$UMF,DBSNMP,APPQOSSYS,DBSFWUSER,GGSYS,ANONYMOUS,CTXSYS,DVSYS,DVF,GSMADMIN_INTERNAL,MDSYS,OLAPSYS,XDB,WMSYS,GSMCATUSER,MDDATA,SYSBACKUP,REMOTE_SCHEDULER_AGENT,GSMUSER,SYSRAC,GSMROOTUSER,SI_INFORMTN_SCHEMA,AUDSYS,DIP,ORDPLUGINS,SYSKM,ORDDATA,ORACLE_OCM,SYSDG,ORDSYS'

v_users="'$(echo $v_users|sed "s/,/','/g")'"
echo $v_users
sqlplus -s -N / as sysdba > /tmp/.chgpw.sql <<EOF
set head off echo off feedback off pagesize 4000
select 'alter user '||username ||' identified by "$v_password" ;' from dba_users where username in ($v_users);
EOF

sqlplus  / as sysdba<<EOF
@/tmp/.chgpw.sql
EOF

rm -f /tmp/.chgpw.sql

done

2、脚本变量解释

v_password  表示要修改的密码
v_users 表示要修改的账号

3、执行

sh ch_o_passwd.sh