ORA-00479: RVWR process terminated with error

 Problem:

When trying to enable flashback feature on a 19c DB I get this error:

 26-Jun-2023 16:03:25 SYS@fq> alter database flashback on;
alter database flashback on
*
ERROR at line 1:
ORA-00479: RVWR process terminated with error

Analysis:

Current SQLPlus session settings can contribute in getting this error.

Solution:

Connect to SQLPlus using "nolog" option, where login.sql will not be effective, then enable the Flashback feature:

[oracle@fq ~]$ sqlplus /nolog

SQL*Plus: Release 19.0.0.0.0 - Production on Mon Jun 26 16:10:52 2023
Version 19.5.0.0.0

Copyright (c) 1982, 2019, Oracle.  All rights reserved.

SQL> conn / as sysdba
Connected.

SQL> alter database flashback on;

Database altered.

TOP command is not showing the processes in a right order

Problem:

I came across a weird problem where top Linux command is not sorting the processes by the top consumer processes under oracle user, but when running top Linux command with any other user it sorts the processes in a right order.
If you still unable to understand the issue, look at this screenshot which shows top command output under oracle user on the left side where the processes are listed randomly, and the same command output ran by opc user on the right side where the processes are sorted by the top consumers.

There is no alias being invoked for top command:

 

Analysis:

There is a file with name ".toprc" under /home/oracle saves top command settings, where it influences top command output. This file get created when you press "W" after calling top command to save its current call setting:

Solution:

I've simply renamed the .toprc file and the top command output is back to its normal setting sorting the processes by top CPU consumers.

# cd ~
# mv .toprc  .toprc.old

 

Conclusion:

This is not a problem, but it's just a wrong configuration impacted the output of top command and also impacted the behavior of all monitoring script that depend on top command output for reporting the top consuming processes.

References:

https://www.thegeekstuff.com/2010/01/15-practical-unix-linux-top-command-examples/