linux oracle 目录

sudo chown -R oracle:oinstall /path/to/oracle/home
sudo chmod -R 755 /path/to/oracle/home

df -h  # 查看磁盘使用情况
du -sh /path/to/oracle/datafiles  # 查看特定目录的大小
# 清理不必要的文件或扩展磁盘空间

vi $ORACLE_HOME/network/admin/listener.ora
# 检查并修正配置
lsnrctl reload  # 重新加载监听器配置

sqlplus / as sysdba
startup mount
alter database open resetlogs;  # 尝试重置日志打开数据库

#!/bin/bash

ORACLE_HOME="/u01/app/oracle/product/19.0.0/dbhome_1"
DATA_DIR="/u01/app/oracle/oradata"

# 检查Oracle Home目录权限
if [ "$(stat -c %U $ORACLE_HOME)" != "oracle" ]; then
    echo "Fixing Oracle Home directory permissions..."
    sudo chown -R oracle:oinstall $ORACLE_HOME
fi

# 检查Data Files目录权限
if [ "$(stat -c %U $DATA_DIR)" != "oracle" ]; then
    echo "Fixing Data Files directory permissions..."
    sudo chown -R oracle:oinstall $DATA_DIR
fi

echo "Permissions check and fix completed."