Pavan DBA's Blog

The DBA Knowledge Store

TechMaster – New Oracle RAC batch from 11th May

Posted by Pavan DBA on May 9, 2019


TechMaster announcing Oracle RAC online training by Raj

Mode: Online training
Duration: 30 classes
Frequency: 5 days a week
Timings: 6 – 7 AM IST
Demo date & time: 11th May at 6 AM IST
Free classes: 13th and 14th May at 6 AM IST

Batch starting date: 15th May at 6 AM IST

Please attend demo and first two classes for free using this link – https://global.gotomeeting.com/join/243703973

Course content and other details are available at – http://www.thetechmaster.in/courses/oracle-rac

For more details, contact:-
Email to: admin@thetechmaster.in
Call or WhatsApp to: +919676516545
http://www.thetechmaster.in

Posted in Training | Leave a Comment »

TechMaster – New Oracle Cloud DBA batch from 21st May

Posted by Pavan DBA on May 15, 2018


TechMaster announcing Oracle Cloud administration online training by Raj

Mode: Online training
Duration: 25 classes
Frequency: 5 days a week
Timings: 6 – 7 AM IST
Demo date & time: 19th May 2018 at 6 AM IST
Batch starting date: 21st May 2018 at 6 AM IST

Please attend demo and first two classes for free using this link – https://global.gotomeeting.com/join/783411133

Course content and other details are available at – http://www.thetechmaster.in/courses/oracle-cloud-administration

For more details, contact:-
Email to: admin@thetechmaster.in
Call or WhatsApp to: +919676516545
http://www.thetechmaster.in

Posted in Training | Tagged: , , | Leave a Comment »

TechMaster – New SQL Server DBA batch from 21st Feb

Posted by Pavan DBA on February 14, 2018


TechMaster announcing SQL Server DBA online training by Rathnakar

Mode: Online training
Duration: 40 classes
Frequency: 5 days a week
Timings: 7 – 8 AM IST
Demo date & time: 21st Feb 2018 at 7 AM IST
Batch starting date: 22nd Feb 2018 @ 7 AM IST

Please attend demo and first two classes for free using this link – https://global.gotomeeting.com/join/444274765

For more details, contact:-
Email to: admin@thetechmaster.in
Call or WhatsApp to: +919676516545
http://www.thetechmaster.in

Posted in Training | Leave a Comment »

TechMaster – New Oracle Apps DBA R12.2 batch from 12th Feb

Posted by Pavan DBA on February 9, 2018


TechMaster announcing Oracle Apps DBA R12.2 online training by Himanshu.

Mode: Online training
Duration: 30 classes
Frequency: 5 days a week
Timings: 8 – 9 AM IST
Demo date & time: 12th Feb 2018 @ 8 AM IST
Batch starting date: 13th Feb 2018 @ 8 AM IST

Please attend demo and first two classes using this link – https://global.gotomeeting.com/join/560072829

For more details, contact:-
Email to: admin@thetechmaster.in
Call or WhatsApp to: +919676516545

Posted in Training | Tagged: , , , , | Leave a Comment »

AWR report in restricted mode

Posted by Pavan DBA on February 8, 2018


Today, I have learned new thing regarding AWR report when database is in restricted mode.

By default, if your database is in restricted mode, you cannot generate AWR report. It will throw below error in the alert log.

ORA-13516: AWR Operation failed

or

ORA-20200: Database/Instance nnnnnn does not exist in DBA_HIST_DATABASE_INSTANCE

This is because Oracle database will not allow to generate AWR report in restricted mode. To still continue with report generation, you need to set below hidden parameter in your spfile

_AWR_RESTRICT_MODE

Steps to perform:

  1. alter system set _awr_restrict_mode=TRUE scope=SPFILE; -> Default value is FALSE
  2. srvctl stop database -d <database_name> (for RAC, restart node by node)

But, there is a limitation for this parameter. When it is set to TRUE, AWR snapshots will not generate during OPEN mode and you need to change this parameter back to FALSE.

Posted in Perf Tuning | Tagged: , , , , | Leave a Comment »

 
%d bloggers like this: