# 配置信息
YASHANDB_HOME=/yashandb/app
YASHANDB_USER=yashandb
LOG_DIR=/yashandb/scripts/logs
LOG_FILE=$LOG_DIR/auto_restart_$(date +”%Y%m%d”).log

# 创建日志目录
mkdir -p $LOG_DIR

# 记录开始时间
echo “[$(date ‘+%Y-%m-%d %H:%M:%S’)] 开始检查YashanDB实例状态” >> $LOG_FILE

# 检查数据库状态
STATUS=$($YASHANDB_HOME/bin/yasboot status | grep -i “status” | awk ‘{print $2}’)

echo “当前数据库状态: $STATUS” >> $LOG_FILE

if [ “$STATUS” != “RUNNING” ]; then
echo “数据库实例未运行，尝试启动…” >> $LOG_FILE
# 启动数据库
$YASHANDB_HOME/bin/yasboot start

# 检查启动结果
sleep 10
NEW_STATUS=$($YASHANDB_HOME/bin/yasboot status | grep -i “status” | awk ‘{print $2}’)

if [ “$NEW_STATUS” == “RUNNING” ]; then
echo “数据库实例启动成功！” >> $LOG_FILE
# 发送通知邮件
# mail -s “YashanDB实例自动重启成功” admin@example.com < $LOG_FILE else echo "数据库实例启动失败！" >> $LOG_FILE
# 发送告警邮件
# mail -s “YashanDB实例自动重启失败” admin@example.com < $LOG_FILE fi else echo "数据库实例运行正常，无需重启" >> $LOG_FILE
fi

# 记录结束时间
echo “[$(date ‘+%Y-%m-%d %H:%M:%S’)] 检查完成” >> $LOG_FILE

# 配置信息
YASHANDB_HOME=/yashandb/app
export LD_LIBRARY_PATH=$YASHANDB_HOME/lib:$LD_LIBRARY_PATH
YASHANDB_USER=fgedu
YASHANDB_PASSWORD=fgedu123
YASHANDB_DBNAME=fgedudb
LOG_DIR=/yashandb/scripts/logs
LOG_FILE=$LOG_DIR/slow_sql_$(date +”%Y%m%d”).log

# 创建日志目录
mkdir -p $LOG_DIR

# 记录开始时间
echo “[$(date ‘+%Y-%m-%d %H:%M:%S’)] 开始分析慢SQL” >> $LOG_FILE

# 收集慢SQL
echo “\n慢SQL分析结果:” >> $LOG_FILE
$YASHANDB_HOME/bin/yasql -U $YASHANDB_USER -P $YASHANDB_PASSWORD -D $YASHANDB_DBNAME -e “SELECT sql_id, sql_text, elapsed_time, execution_count FROM v\$slow_sql ORDER BY elapsed_time DESC LIMIT 10;” >> $LOG_FILE

# 分析执行计划
if [ $? -eq 0 ]; then
echo “\n正在分析慢SQL执行计划…” >> $LOG_FILE
# 获取第一个慢SQL的SQL ID
SQL_ID=$($YASHANDB_HOME/bin/yasql -U $YASHANDB_USER -P $YASHANDB_PASSWORD -D $YASHANDB_DBNAME -e “SELECT sql_id FROM v\$slow_sql ORDER BY elapsed_time DESC LIMIT 1;”)
SQL_ID=$(echo “$SQL_ID” | grep -v “SQL_ID”)

if [ -n “$SQL_ID” ]; then
echo “\nSQL ID: $SQL_ID 的执行计划:” >> $LOG_FILE
$YASHANDB_HOME/bin/yasql -U $YASHANDB_USER -P $YASHANDB_PASSWORD -D $YASHANDB_DBNAME -e “EXPLAIN PLAN FOR SELECT * FROM (SELECT * FROM v\$slow_sql WHERE sql_id = ‘$SQL_ID’) t;” >> $LOG_FILE
$YASHANDB_HOME/bin/yasql -U $YASHANDB_USER -P $YASHANDB_PASSWORD -D $YASHANDB_DBNAME -e “SELECT * FROM TABLE(DBMS_XPLAN.DISPLAY());” >> $LOG_FILE
fi
fi

# 记录结束时间
echo “\n[$(date ‘+%Y-%m-%d %H:%M:%S’)] 慢SQL分析完成” >> $LOG_FILE

# 发送分析报告
# mail -s “YashanDB慢SQL分析报告” admin@example.com < $LOG_FILE

# 配置信息
YASHANDB_HOME=/yashandb/app
INSTALL_DIR=/yashandb/app
DATA_DIR=/yashandb/fgdata
DB_NAME=fgedudb
DB_USER=fgedu
DB_PASSWORD=fgedu123
LOG_DIR=/yashandb/scripts/logs
LOG_FILE=$LOG_DIR/auto_deploy_$(date +”%Y%m%d”).log

# 创建目录
mkdir -p $DATA_DIR
mkdir -p $LOG_DIR

# 记录开始时间
echo “[$(date ‘+%Y-%m-%d %H:%M:%S’)] 开始部署YashanDB实例” >> $LOG_FILE

# 检查安装目录
if [ ! -d “$YASHANDB_HOME” ]; then
echo “错误：YashanDB安装目录不存在！” >> $LOG_FILE
exit 1
fi

# 初始化数据库实例
echo “\n初始化数据库实例…” >> $LOG_FILE
$YASHANDB_HOME/bin/yasinit -d $DATA_DIR -n $DB_NAME

# 启动数据库
echo “\n启动数据库…” >> $LOG_FILE
$YASHANDB_HOME/bin/yasboot start

# 创建用户
echo “\n创建用户…” >> $LOG_FILE
$YASHANDB_HOME/bin/yasql -U sys -P sys -D $DB_NAME -e “CREATE USER $DB_USER IDENTIFIED BY ‘$DB_PASSWORD’; GRANT ALL PRIVILEGES TO $DB_USER;”

# 配置监听
echo “\n配置监听…” >> $LOG_FILE
cat > $YASHANDB_HOME/conf/listener.ora << EOF LISTENER = (DESCRIPTION_LIST = (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 5432)) ) ) EOF # 启动监听 $YASHANDB_HOME/bin/yalistener start # 验证部署 echo "\n验证部署结果..." >> $LOG_FILE
$YASHANDB_HOME/bin/yasboot status >> $LOG_FILE
$YASHANDB_HOME/bin/yalistener status >> $LOG_FILE

# 记录结束时间
echo “\n[$(date ‘+%Y-%m-%d %H:%M:%S’)] YashanDB实例部署完成” >> $LOG_FILE

# 发送部署报告
# mail -s “YashanDB实例部署完成” admin@example.com < $LOG_FILE