nastar_change_secret.sh

来源：互联网发布：莫尼卡·莱文斯基知乎编辑：程序博客网时间：2024/06/05 00:38

startListener()
{
    #启动监听进程
    RET=`su - $DBUSER -c "lsnrctl status"`

    RET=`printf "${RET}" | grep "The command completed successfully"`

    if [ "-" == "-${RET}" ]
    then
        RET=`su - $DBUSER -c "lsnrctl start"`
        RET=`printf "${RET}" | grep "The command completed successfully"`

        if [ "-" == "-${RET}" ]
        then
            printf " Starting open listener failed , please try it again or contact to Support Engineers.\n\r"
            exit
        else
           printf "Starting open listener done.\n\r"
        fi
    fi

return 0;
}

function password_check_verify_null()
{
   su - $DBUSER -c "sqlplus / as sysdba <<EOF
       alter profile default limite password_verify_function null;
       quit;
       EOF" >>/tmp/change_secret.log 2>&1
}
function change_secret_emsems()
{
   rm -rf /tmp/change_emsems.log
   su - $DBUSER -c "sqlplus / as sysdba <<EOF

alter user alarmdb identified by emsems;

alter user imapeamdb identified by emsems;

alter user imaplogdb identified by emsems;

alter user imapsmdb identified by emsems;

alter user imaptmdb identified by emsems;

alter user imaptempdb identified by emsems;

alter user imapuser identified by emsems;

alter user naspa identified by emsems;

alter user system identified by emsems;

       alter user imap_db identified by emsems;

       alter user ossdcm identified by emsems;

quit;
EOF" >>/tmp/change_emsems.log 2>&1
}

function change_secret_Changeme_123()
{
rm -rf /tmp/change_Changeme_123.log
su - $DBUSER -c "sqlplus / as sysdba <<EOF

alter user alarmdb identified by Changeme_123;

alter user imapeamdb identified by Changeme_123;

alter user imaplogdb identified by Changeme_123;

alter user imapsmdb identified by Changeme_123;

alter user imaptmdb identified by Changeme_123;

alter user imaptempdb identified by Changeme_123;

alter user imapuser identified by Changeme_123;

alter user naspa identified by Changeme_123;

alter user system identified by Changeme_123;

       alter user imap_db identified by Changeme_123;

       alter user ossdcm identified by Changeme_123;

quit;
EOF" >>/tmp/change_Changeme_123.log 2>&1
}

function display_emsems_PD()
{
ERROR=`cat /tmp/change_emsems.log|grep "ERROR"`
if [ "_" == _"$ERROR" ]
then
printf "change password ok!\n\r"
else
printf "change password failed, Please check database instance or database user!\n\r"
fi
}

function display_Change_123_PD()
{
ERROR1=`cat /tmp/change_Changeme_123.log|grep "ERROR"`
if [ "_" == _"$ERROR1" ]
then
printf "change password ok!\n\r"
else
printf "change password failed, Please check database instance or database user!\n\r"
fi
}

function change_secret()
{
        #取消oracle用户密码复杂度校验功能
        password_check_verify_null
        #修改数据库用户密码
        echo 'Change password list:'
        printf "change emsems ........................................... \033[1m[1]\033[0m\n"
        printf "change Changeme_123 ..................................... \033[1m[2]\033[0m\n"
        printf "exit change ............................................. \033[1m[3]\033[0m\n"
        while [ 1 ]
        do
            printf "Please input your choice[1~3]:"
     read choice
            case $choice in
            1 )
                change_secret_emsems
                echo " "
                display_emsems_PD
                sleep 0.5s
                break
                ;;
            2 )
                change_secret_Changeme_123
                echo " "
                display_Change_123_PD
                sleep 0.5s
                break
                ;;
            3 )
               echo " "
                exit
                ;;
            * )
                echo "Invalid input !"
                continue
                ;;
            esac
        done
}
############################################################################################################################
DBUSER=oracle
old_password=emsems
new_password=Changeme_123
#检查侦听状态
startListener
change_secret