Network Security Internet Technology Development Database Servers Mobile Phone Android Software Apple Software Computer Software News IT Information

In addition to Weibo, there is also WeChat

Please pay attention

WeChat public account

Shulou

ORA-09925 could not create the audit file

2025-01-20 Update From: SLTechnology News&Howtos shulou NAV: SLTechnology News&Howtos > Database >

Share

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

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.

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.

Views: 0

*The comments in the above article only represent the author's personal views and do not represent the views and positions of this website. If you have more insights, please feel free to contribute and share.

Share To

Wechat

© 2024 shulou.com SLNews company. All rights reserved.

12
Report