Latest Post

Online Trainings On Oracle Database 11g

Written By askMLabs on Friday, September 13, 2013 | 12:57 PM

We are starting new trainings on oracle database 11g. Please review our site http://askmlabs.com or attend our free demo to know more details.
1) Oracle Database 11g Administration ( with 12c new features )
2) Oracle Database 11gR2 Grid with ASM and RAC Administration
3) Oracle Database 11gR2 DataGuard Administration

All these trainings including lab sessions are handled by Srikrishna Murthy Annam.

askmlabs-online-trainings1

Thanks

SRI

Change Online Redolog Group Member Size

Written By askMLabs on Wednesday, September 11, 2013 | 8:31 AM

In this article, i am going to show you how to change the online redolog file size. The existing configuration is having 3 redolog groups with one member in each group. Each member in group is 50MB in size. Now we are going to change the size of these online redolog group members from 50MB to 300MB.

SQL> select group#,thread#,MEMBERS,bytes/1024/1024 from v$log;
    GROUP#    THREAD#    MEMBERS BYTES/1024/1024
---------- ---------- ---------- ---------------
         1          1          1              50
         2          1          1              50
         3          1          1              50
SQL> select member from v$logfile;
MEMBER
--------------------------------------------------------------------------------
/home/apps/oem12c/oradata/oem12c/redo03.log
/home/apps/oem12c/oradata/oem12c/redo02.log
/home/apps/oem12c/oradata/oem12c/redo01.log
SQL> alter database add logfile thread 1 group 4 ('/home/apps/oem12c/oradata/oem12c/redo04.log') size 300M;
Database altered.
SQL> alter database add logfile thread 1 group 5 ('/home/apps/oem12c/oradata/oem12c/redo05.log') size 300M;
Database altered.
SQL> alter database add logfile thread 1 group 6 ('/home/apps/oem12c/oradata/oem12c/redo06.log') size 300M;
Database altered.
SQL> select group#,thread#,MEMBERS,status,bytes/1024/1024 from v$log;
    GROUP#    THREAD#    MEMBERS STATUS           BYTES/1024/1024
---------- ---------- ---------- ---------------- ---------------
         1          1          1 INACTIVE                      50
         2          1          1 CURRENT                       50
         3          1          1 INACTIVE                      50
         4          1          1 UNUSED                       300
         5          1          1 UNUSED                       300
         6          1          1 UNUSED                       300
6 rows selected.
SQL> alter database drop logfile group 1;
Database altered.
SQL> alter database drop logfile group 3;
Database altered.
SQL> alter system switch logfile;
System altered.
SQL> alter system checkpoint;
System altered.
SQL> select group#,thread#,MEMBERS,status,bytes/1024/1024 from v$log;
    GROUP#    THREAD#    MEMBERS STATUS           BYTES/1024/1024
---------- ---------- ---------- ---------------- ---------------
         2          1          1 INACTIVE                      50
         4          1          1 CURRENT                      300
         5          1          1 UNUSED                       300
         6          1          1 UNUSED                       300
SQL> alter database drop logfile group 2;
Database altered.
SQL> select group#,thread#,MEMBERS,status,bytes/1024/1024 from v$log;
    GROUP#    THREAD#    MEMBERS STATUS           BYTES/1024/1024
---------- ---------- ---------- ---------------- ---------------
         4          1          1 CURRENT                      300
         5          1          1 UNUSED                       300
         6          1          1 UNUSED                       300
SQL> 

Hope this helps
SRI

Oracle Database 12c Architecture Free Demo

Written By askMLabs on Friday, September 6, 2013 | 4:27 PM

demo1

Registration :  http://askmlabs.com


Our new Website askmlabs.com

Written By askMLabs on Tuesday, September 3, 2013 | 12:51 PM

We have launched a new website for oracle trainings and cloud services. http://askmlabs.com/

  • We offer corporate trainings on oracle technologies in various formats. The biggest challenge in today's IT enabled industry is the lack of good technical skills and we fill the gap by providing technical skills to resources to meet the industry standard.

  • We offer online trainings and virtual labs facility. You can attend the trainings at your convinience and practice the labs from your home. We provide virtual lab from our cloud setup.

  • We offer the ready to use virtual machines as products. You can spend your time in practicing the technology rather than setting up the environment. All these virtual machines are provided at a very low cost. Please visit our site http://askmlabs.com/ for more information or contact us at info@askmlabs.com

  • We offer PaaS and SaaS from our cloud setup. We will provide the IT infrastructure needs as per your requirements at a very low cost with high availability. Please visit our site http://askmlabs.com/ for more information or contact us at info@askmlabs.com

askMLabs


We Offer:
1) Training Solutions
2) Ready To Use Virtual Machines as Products
3) Online Virtual labs
4) PaaS and SaaS from our cloud setup
5) Knowledge base as blog
6) Forum for technical discussions
7) Login facility with your existing social account
8) Full length technical videos


Thanks

SRI

ORACLE RAC 11GR2 ADMINISTRATION TRAINING

Written By askMLabs on Sunday, September 1, 2013 | 4:54 AM







This course gives you an introduction to the features and capabilities of oracle real application clusters RAC 11gR2.

Current Training Schedule : 
Training Format
Online Training
Fee
USD 300 /  INR 15,000/-
Duration
4 weeks ( Sat & Sun ) - 4 Hr Session
Date
DD-MON-YYYY
Time
HH:MI to HH:MI
Instructor
Srikrishna Murthy Annam

Services :
Training Format
Self Study Material with Lab practice examples
Fee
USD xxx /  INR x,xxx/-
Prepared By
Srikrishna Murthy Annam

Only Lab :
Practice Lab
24/7 practice lab access from our data center
Fee
USD xxx /  INR x,xxx/-
Guided  By
Srikrishna Murthy Annam

Course Content : 
This course gives you an introduction to the features and capabilities of oracle real application clusters RAC 11gR2. This course will provide you step by step guidance to create RAC environment
  1. Oracle Clusterware Installation
    1. Oracle RAC 11g Installation
    2. Cluster Setup Tasks
    3. Using Raw Partitions
    4. Cluster Configuration
  2. RAC Installation
    1. Installing Grid Infra and Automatic Storage Management
    2. Configure ASM Storage
    3. Install the Database Software
  3. Database Creation
    1. Storage Options for Database Files
    2. Create the Database
    3. Single Instance to RAC Conversion
  4. Oracle Clusterware Administration
    1. Controlling the Oracle Clusterware Stack
    2. Back Up and Recover Your Voting Disks
    3. Back Up and Recover Oracle Cluster Registry
    4. Prevent Automatic Instance Restarts
    5. Manage network settings
  5. RAC DB Administration
    1. Cluster Database Instance Administration
    2. Topology Viewer
    3. Automatic Undo Management and RAC
    4. Quiescing RAC Databases
    5. Transparent Data Encryption and Wallets in RAC
    6. ASM Instance and Crash Recovery in RAC
  6. Backup and Recover a RAC DB
    1. Protecting Against Media Failure
    2. Oracle Recovery Manager
  7. Administering ASM Instances
    1. Explain and apply ASM init.ora parameters
    2. Manage ASM Instances and associated processes
    3. Monitor ASM using v$asm dynamic performance views
  8. Administering ASM Disk groups
    1. Create and delete Automatic Storage Management (ASM) Disk groups
    2. Set the attributes of an existing ASM disk group
    3. Perform ongoing maintenance tasks on ASM disk groups
    4. Explain key performance and scalability considerations for ASM disk groups
  9. Administering ASM Files,Directories and Templates
    1. Use different client tools to access Automatic Storage Management (ASM) files
    2. Describe the format of a fully qualified ASM file name
    3. Explain how ASM files, directories, and aliases are created and managed
    4. Describe and manage disk group templates.
  10. RAC Patching
    1. Types of Patching
    2. Out-Of-Place Clusterware Upgrade
    3. Patch Properties
    4. Rolling Patches
    5. Opatch
    6. Installing Patches with Minimum Downtime
  11. Services
    1. Workload Dispatching
    2. High Availability of Services in RAC
    3. Services and Resource Manager with EM
    4. Change Service Thresholds
    5. Using Distributed Transactions with RAC
  12. High Availability of Connections
    1. Fast Application Notification
    2. Load Balancing Advisory
    3. Transparent Application Failover
  13. Troubleshooting the Oracle Clusterware components
    1. Locate Oracle Clusterware Log files
    2. Gather all log files using diagcollection.pl
    3. Enable resource debugging
    4. Enable component-level debugging
    5. Enable tracing for java-based tools
    6. Troubleshoot the Oracle Cluster Registry (OCR) file
  14. Node Addition/Removal
    1. Add and Delete Nodes and Instances
    2. Clone Oracle Clusterware
  15. Design for High Availability
    1. Maximum Availability Architecture
    2. RAC and Data Guard Topologies
    3. Extended RAC Connectivity
    4. Extended RAC disk mirroring
    5. Patch your RAC system in a rolling fashion
  16. Oracle RAC One Node
    1. Online database migration
    2. Add a RAC One Node database to an existing cluster
    3. Convert a RAC One Node Database to a RAC database
    4. Convert a single instance database to a RAC One Node database


Who Can Attend : 
  1. Data Warehouse Administrator
  2. Database Administrators
  3. Database Designers
  4. Project Manager
  5. Support Engineer
  6. System Analysts
  7. Technical Administrator
  8. Technical Consultant

Course Objective :
  1. Install, create, administer, and monitor a Real Application Clusters database
  2. Use configuration and management tools for Real Application Clusters databases
  3. Setup services for workloads management, and applications high availability
  4. Develop a backup and recovery strategy for Real Application Clusters databases
  5. Configure and monitor Oracle Clusterware resources
  6. Review high availability best practices
  7. Identify Real Application Clusters components

Why To Choose Us :
  1. Free Plug & Play virtual Machine 11g RAC
  2. Handouts for each topics
  3. Lab facility from anywhere* ( From our cloud servers )
  4. Guidance from expert trainers
  5. Help to setup database in local machines
  6. 100% Student Satisfaction
  7. Direct Interaction with Faculty at office
  8. Guidance for Interview Preparation
  9. Guidance for certification

Fee Details :
  1. Single payment 10% discount
  2. Two installments ( 50% before starting and 50% after 2 weeks )  -- 5% discount on second payment
  3. Three installments (20% before starting + 50% before 3rd week + 30% before 4th week)
  4. Refer a friend and get 20% discount on course fee
  5. Good negotiable price for group of people as a batch

 
Support :
Copyright © 2013. askMLabs - All Rights Reserved
Proudly powered by Blogger