nastar_change_secret.sh

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