使用shell脚本为Oracle用户生成随机密码

#!/bin/bash

# 生成随机密码函数
generate_password() {
  # 密码长度
  length=$1
  # 密码字符集
  characters="ABCDEFGHIJKLMNOPQRSTUVWXYZabcdefghijklmnopqrstuvwxyz0123456789!@#$%^&*()"
  password=""
  for i in $(seq 1 $length); do
    # 从字符集中随机选择一个字符
    password+=${characters:$(($RANDOM%${#characters})):1}
  done
  echo $password
}

# Oracle用户名
username="your_username"

# 生成8位长度的随机密码
password=$(generate_password 8)

# 设置用户密码
echo "ALTER USER $username IDENTIFIED BY $password;" | sqlplus / as sysdba

echo "生成的随机密码为：$password"