Shulou(Shulou.com)06/01 Report--

Today, ORACLE database 11.2.0.4 for linux maintenance, single instance oracle cluster database, ASM instance is down, database instance is down.

Grid or oracle uses sqlplus / as sysasm and sqlplus / as sysdba to log in to the command line console to mistakenly prompt ORA09925.

The error message is as follows:

After troubleshooting, the database server stores the available space for the file system and 11GB. ORA09925 prompts that insufficient space is misleading, and oracle enters adump

After the directory, either ls-l or exit the adump directory du-sh * command is stuck, which suggests that it may be caused by running out of inode in the file directory. Use oracle to enter the adump directory and execute rm-rf * .aud to prompt that the file list is too long, so you can be sure that too many broken files in the oracle audit directory caused the file system

Failure to write caused asm and database instances to hang.

Too many broken files in the oracle audit directory:

How to deal with it: oracle exits the adump directory, deletes the folder to rebuild, ASM and DB instances start successfully, the problem is solved!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.