Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

oradebug -g all dump systemstate 266

768668Jun 3 2010 — edited Jun 24 2010

Hi All,

I am trying to create SYSTEMSTATE dump for my RAC database. Recently we had a node crash, due to hanging sessions. When we open a SR with oracle, they suggested us to run following if the same scenario repeats.

oradebug setmypid
oradebug unlimit
oradebug -g all dump systemstate 266
wait for 2 min
oradebug -g all dump systemstate 266
wait for 2 min
oradebug -g all dump systemstate 266

I tried running the above without "oradebug unlimit". I got "ORA-02819: Write failed" after generating 30Mb trace file.

Second time, I did set "oradebug unlimit" and trying to run "oradebug -g all dump systemstate 266".

But getting the following error.

Error 2819 encountered by local DIAG [ospid=529126]
Error 2819 encountered by remote DIAG [ospid=1151684][instance=2]
Error 2819 encountered by remote DIAG [ospid=1208710][instance=4]
Error 2819 encountered by remote DIAG [ospid=549384][instance=3]

Please advice.

Thanks in advance.

Locked Post

New comments cannot be posted to this locked post.

Locked on Jul 22 2010

Added on Jun 3 2010

#general-database-discussions

5 comments

4,386 views