Get the App
SLTechnology News&Howtos  ›  Database  › 

ORA-32004: obsolete or deprecated parameter (s) spe

Shulou Source: shulou.com Published: 2022-06-01 10:02:40 10月27日 Update

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.

Tags: File data database parameters questions next situation method log comment status focus error communication tracking Apple Docker Huawei Linux macOS MariaDB Microsoft MySQL NVidia OPPO Reno Shulou Tech Info Shulou Information Shulou Technology MySQL Linux