Quick one today!
Having message below in your 18.104.22.168 on AIX like this?
WARNING: Heavy swapping observed on system in last 5 mins.
pct of memory swapped in [31.28%] pct of memory swapped out [3.81%].
Please make sure there is no memory pressure and the SGA and PGA are configured correctly.
Look at DBRM trace file for more details.
Stand down, this issue is caused by unpublished Bug 11801934, mentioned in MOS False Swap Warning Messages Printed To Alert.log On AIX (Doc ID 1508575.1).
Basically happens because the v$osstat does not reflect proper stats for the swap space paging.
So, stay calm and see you next week!
As the oldest readers know, someday I had to found some entries in the alertlog and I had a really big log. So I jerrry-ringed some scripts for grepping alert with auxiliar files and etc.
I can see the posts here: Grepping Alert by Day and Grepping Entries from Alert.log.
So… They are functional, but probably the worst ways to get it. I didn’t know and was innocent to not search by the view x$dbgalertext.
There is also possible to write on alert through the procedure SYS.DBMS_SYSTEM.KSDWRT.
Ok, so let me fix this situation with theese two good guys: @write_alert and @find_alert
ORA-06512 ORA-48168 ORA-12012 for ADR Job Raising Errors
A database is raising stack below on alertlog:
Errors in file /db/u7011/oracle/admin/MYDB/trace/MYDB_j002_22935.trc:
ORA-12012: error on auto execute of job "SYS"."DRA_REEVALUATE_OPEN_FAILURES"
ORA-48168: the ADR sub-system is not initialized
ORA-06512: at "SYS.DBMS_IR", line 522
As you know, since 11g we have a Automatic Diagnostic Repository (ADR). To better manage it, we also have a Command-line Interface, called ADRCI.
ADR contains all diagnostic information for database (logs, traces, incidents, problems, etc).
Just a curiosity: Have you ever noticed in a database alert log the occourance of the following message for every logfile switch:
Thread 1 cannot allocate new log, sequence 9281
Private strand flush not complete
Current log# 5 seq# 9280 mem# 0: /db/u5001/oradata/GREPORADB/redo05a.log
Thread 1 advanced to log sequence 9281 (LGWR switch)
Current log# 6 seq# 9281 mem# 0: /db/u5001/oradata/GREPORADB/redo06a.log
cat /var/log/mysqld.log |grep `date +%y%m%d` | grep "\[Warning\]"
cat /var/log/mysqld.log |grep `date +%y%m%d` | grep "\[ERROR\]"
And a Bonus!
To get entries from X days ago:
cat /var/log/mysqld.log |grep `date --date="46 days ago" +%y%m%d`
Errors in file /oracle/diag/rdbms/mydb/mydb2/trace/mydb2_reco_26083546.trc:
ORA-02062: distributed recovery received DBID e450df78, expected 0311e884
for d in (select local_tran_id from dba_2pc_pending) loop
dbms_transaction.purge_lost_db_entry( d.local_tran_id );