Get the App
SLTechnology News&Howtos  ›  Database  › 

ORA-09925 could not create the audit file

Shulou Source: shulou.com Published: 2022-06-01 05:21:57 10月03日 Update

The database under the solaris environment has not been used for a long time. Open the error report.

Possible reasons

1. The authority is not enough, obviously I am not here

2. the path is wrong, which should be the problem.

Because none of the database instances can be opened, you can't see the system parameters, so you need to find the pfile or spfile file to view the parameters

The default name of PFILE is "init+ routine name.ora" file path: ORACLE_HOME\ dbs, which is a text file that can be opened with any text editing tool.

The default name of SPFILE is "spfile+ routine name.ora" file path: ORACLE_HOME\ dbs exists as binary text and cannot be modified with the vi editor. (two files can be created with the command CREATE PFILE FROM SPFILE or CREATE SPFILE FROM PFILE)

Open the pfile file and see the following sentence

Change the original ORACLE_BASE in audit_file_dest to an absolute path, and then you can open the database.

Tags: File path parameter data database text name obvious insufficient two binary reason command instance tool form permission environment system editor Apple Docker Huawei Linux macOS MariaDB Microsoft MySQL NVidia OPPO Reno Shulou Tech Info MariaDB Shulou Technology NVidia Docker