Pavan DBA's Blog

The DBA Knowledge Store

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

Advertisements

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 »

TechMaster – New Oracle 12c DBA batch by Pavan DBA from 22nd Jan

Posted by Pavan DBA on January 18, 2018


TechMaster announcing Oracle 12c DBA online training by Pavan DBA

Mode: Online training
Duration: 45 classes (including 5 classes of Linux basics)
Frequency: 5 days a week
Timings: 6 – 7:30 AM IST
Demo date: 22nd Jan 2018 at 6 AM IST
Batch starting date: 23rd Jan 2018 @ 6 AM IST

Please attend demo and first two classes for free on 23rd and 24th using this link – https://global.gotomeeting.com/join/289753077

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

Posted in Training | Leave a Comment »

 
%d bloggers like this: