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-32004: obsolete or deprecated parameter (s) spe

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

Share

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

Error found during database startup: ORA-32004

Turn on log tracing, close the database and restart, and find problems in the parameter file:

The point is: Deprecated system parameters with specified values:

The next parameter: sql_trace

Find the spfile file to view the parameter settings in the spfile file

Comment out its parameters, restart the database, and create a pfile file

The error report still exists at this time. Don't worry.

Next, close the database and start the database to the nomount state with the pfile file

There was no error at this time.

Finally, through the startup pfile file to create a spfile file, restart the database, return to normal.

Problem solving

If there is a better way to solve the problem, you are welcome to leave a message.

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: 221

*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

Database

Wechat

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

12
Report