How to fix the Oracle error ORA-01622: thread number must be specified – default not specific?

In this post, you’ll learn more about the Oracle ErrorORA-01622: thread number must be specified – default not specific with the details on why you receive this error and the possible solution to fix it.

Oracle Error Description

ORA-01622: thread number must be specified – default not specific

Reason for the Error ORA-01622: thread number must be specified – default not specific

The thread was not specified when adding a log, and the currently mounted thread was chosen by default at mount time. Since the current thread was not specified explicitly the user cannot know which thread the log will be added to.

How to fix the Error ORA-01622: thread number must be specified – default not specific ?

You can fix this error in Oracle by following the below steps

Explicitly specify the thread number either in the INIT.ORA parameter “thread”, or in the add command.