Database Tuning (MOSC)

MOSC Banner

One RAC instance couldn't generat AWR report

edited Jul 4, 2019 12:28PM in Database Tuning (MOSC) 5 commentsAnswered

Has anyone run into issue generating AWR report from a RAC instance?

I have two instances with this 12.2 RAC database, and I was able to generate Global AWR report, and also instance1 AWR report. However when I go to instance2 and select the begin & end snapshot number to generate report, it just ran and ran and never return the result.

Issued command:

select instance_number,begin_interval_time,end_interval_time from dba_hist_snapshot where snap_id in(6564,6565);

It seems like the snapshots were created for instance_number 3 for the snapshot range I was trying to run.

Something special about this instance2: The original instance2 was deleted and recreated a while ago. I have not tried to generate any AWR report after the deletion and recreation. Not sure if that is related. So the instance name is like:  instance2, but the instance_nubmer is 3 in the above query result. I have rediscovered this instance2 from OEM.

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

Instructions for posting

×

1. Select a discussion category from the picklist.


2. Enter a title that clearly identifies the subject of your question.


3. In the body, insert detailed information, including Oracle product and version.


Please abide by the Oracle Community guidelines and refrain from posting any customer or personally identifiable information (PI/CI).


Cloud / Fusion customers - Our Cloud community has moved! Please go to Cloud Customer Connect .


New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center