Monday, 25 July 2016

Oracle DBA LIVE DEMO @ APEX [ By Real Time Expert ] for online trainnig

Oracle DBA LIVE DEMO @ APEX [ By Real Time Expert ]
Tuesday, July 26, 2016
11:00 pm  |  India Time (Mumbai, GMT+05:30)  |  1 hr
 
USA TIME : Same day, @ 12:30 pm CST or 1:30 pm EST

FOR FREE DEMO contact us at:

Email : training@apex-online-it-training.com

Phone/WhattsApp : +91-(868) 622-2553 

Friday, 22 July 2016

Oracle Apps DBA online training New batch starting from next week Real time training by working faculty ...

​​

FOR FREE DEMO contact us at:

Email : training@apex-online-it-training.com

Phone/WhattsApp : +91-(868) 622-2553 


​​
COURSE HIGHLIGHTS 

  1. Instructor lead online training by Real time working faculty   

  2. Software  or lab access will be provided for unlimited hours

  3. Good quality Material will be provided

  4. Real time assignments to get hands on experience 

  5. Interview and job oriented training by exceptionally good trainers 

​Course Content ​​   


Infrastructure setup


  • Installation of Virtual workstation

  • Installation of OEL Operating system

  • OEL Oracle Enterprise Linux

  • Disk Druid configuration

  • Manual partitions

  • Assigning  static ip to Ethernet

  • Time zone selection

  • Root user password configuration

  • Packages selection

  • Post installation configuration

  • Login to the OS

  • Installing Virtual tools

  • Sharing of Folders from host OS to virtual OS

  • Cloning of OS in virtual workstation

  • Start and Shut of OS



Pre installation configuration


  • EBS software stage

  • Db tier

  • Apps tier

  • Edit the host file

  • Group creation

  • User creation

  • Ownership permission

  • Set password

  • Rpms installation


EBS single node installation


  • Execute the rapid wiz

  • Install Oracle application

  • New configuration port no

  • Database node configuration

  • Select necessary options

  • Final installation

  • Post installation steps

  • Bash profile configuration

  • DB tier bash profile

  • Apps tier bash profile

  • Login to url

  • verify


EBS multi node installation


  • Prepare the 2 node OS

  • Perform pre installation

  • Execute rapid wiz on first node

  • Select db tier node

  • Select Apps tier node

  • Edit services

  • OPMN

  • Web entry point

  • Web application services

  • Batch process service

  • Other service

  • run the rapid wiz on 2nd node

  • Save load configuration file

  • Bash profile configuration

  • Login to URL

  • Verify


EBS File system


  • Database environment file

  • Db context file

  • control scripts

  • C,R,D files

  • Application environment file

  • context file

  • Db connectivity file

  • control scripts Apps tier

  • AD utilities

  • Apache server configuration file

  • Form sever configuration file


Manage EBS Service


  • Db tier service

  • Traditional method

  • Control script service

  • Listener service

  • Apps tier service

  • Apps Control scripts

  • Individual service

  • Apache server

  • Forms server

  • CMS server

  • Application listener

  • OPMN Service

  • OC4J Service

  • OC4J oacore - html based

  • OC4J forms

  • OC4J oafm - web service

  • Oracle http service


Patch


  • Patch concepts

  • one of patch

  • single patch

  • mini patch

  • family patch

  • maintenance patch pack

  • Pre requisite patch

  • Patch tool kit

  • adpatch,adctrl,adadmin.adautocfg,admrgpch

  • Maintenance mode

  • Apply the patch

  • Driver file

  • Disable maintenance mode

  • Verify patch

  • Merging patch concept





System Admin


  • User creation

  • Password reset

  • Account lock and unlock

  • Profile

  • Assign profile to users

  • Monitor application users

  • Terminate application user

  • Create responsibility

  • Assign responsibility to user

  • Compile custom application

  • Printer configuration

  • Ad admin

  • Auto config

  • Custom manager

  • Report

  • Request set

Cloning


  • Online and Offline cloning

  • Multiple scenario

  • Single node to single node

  • single node to multi node

  • multi node to single node

  • multi node to multi node

  • Verify

  • Db tier adpreclone

  • Apps tier clone

  • Prepare the target system

  • pre configuration

  • Run adpreclone.pl

  • Copy db tier and apps tier

  • tar statement

  • perform adcfgclone.pl

  • Monitor statement

  • Bash profile configuration

  • Post cloning steps

  • Verify


Up Gradation


  • Ebs upgrade from 11i to R12

  • Prepare 11i ebs system

  • db 9i to 10g

  • Apps 11i to R12

  • Apply latest IOP

  • Apply AD Patch

  • Apply IOP patch

  • Install 10g software

  • configure env file

  • apply patch set

  • Run dbua to upgrade

  • Enable autoconfig

  • Listener config

  • start application service

  • Test application

  • Apps tier upgrade

  • Run rapdiwiz R12

  • upgrade file system

  • startup with R12

  • Apply R12 AD Patch

  • Apply maintenance patch pack



FOR FREE DEMO contact us at:

Email : training@apex-online-it-training.com

Phone/WhattsApp : +91-(868) 622-2553 
​ 




Oracle DBA online training New batch starting from Monday Real time training by working faculty ...

FOR FREE DEMO contact us at:

Email : training@apex-online-it-training.com

Phone/WhattsApp : +91-(868) 622-2553 


COURSE HIGHLIGHTS 

  1. Instructor lead online training by Real time working faculty   

  2. Software  or lab access will be provided for unlimited hours

  3. Good quality Material will be provided

  4. Real time assignments to get hands on experience 

  5. Interview and job oriented training by exceptionally good trainers 

Course Content 

ORACLE DBA                                                                                              

 

 

Infrastructure setup

 

ü  Installation of Virtual workstation

ü  Installation of OEL Operating system

ü  OEL Oracle Enterprise Linux

ü  Disk Druid configuration

ü  Manual partitions

ü  Assigning  static ip to Ethernet

ü  Time zone selection

ü  Root user password configuration

ü  Packages selection

ü  Post installation configuration

ü  Login to the OS

ü  Installing Virtual tools

ü  Sharing of Folders from host OS to virtual OS

ü  Cloning of OS in virtual workstation

ü  Start and Shut of OS

 

Basic Linux commands

 

ü  list

ü  creating file with cat

ü  appending file with cat

ü  view file contents with cat

ü  moving and renaming a file

ü  copy  commands

ü  remove commands

ü  creation of Directory

ü  touch

ü  persistence

ü  visual editor

ü  time stamp

ü  Groups

ü  Users

ü  password configuration

ü  Normal user switching

ü  Xhost +

ü  hostname configuration

ü  netconfig

ü  neat

ü  service restarting

ü  Basic file permission

ü  Ownership

ü  Change directory

ü  change mod

ü  Present working directory

ü  Bash profile

ü  executing bash profile

ü  head

ü  tail

 

 

Pre Installation Configuration

 

ü  Creating group

ü  Creating user

ü  Password assigning

ü  Create directory path

ü  Permissions

ü  Ownership

ü  Bash profile

ü  Executing bash

ü  XHOST +

ü  Switching user

 

Installing ORACLE And Database creation

 

ü  Basic Installation method

ü  Advance Installation method

ü  DBCA Method

ü  Manual Database creation

 

Connecting to Database

 

ü  SQLPLUS  tool

ü  Verify  database name

ü  Verify database status

ü  Verify  control file location

ü  Verify data files location

ü  Verify redo log files location

ü  Verify flash recovery area location

ü  Verify Archive mode or No archive mode

ü  Shut database

ü  Startup database

 

Parameter file management

 

ü  Database startup process

ü  Database No mount stage

ü  SID and Parameter file

ü  PFILE  location

ü  PFILE Name

ü  PFILE Configuration

ü  Verify PFILE OR SPFILE in DB

ü  SPFILE Name

ü  SPFILE Configuration

ü  SPFILE  Memory option

ü  SPFILE Scope option

ü  SPFILE  SPFILE  option

ü  Create SPFILE from SPFILE

ü  Create PFILE from SPFILE

ü  Backup and Restoration of Parameter file

 

 

Control file management

 

ü  ORACLE instance start up process

ü  DATABASE  Mount Stage

ü  Control file characteristics

ü  Control file multiplexing

ü  Verify multiplexing

 

Redo Log file management

 

ü  ORACLE Instance

ü  REDOLOG Algorithm

ü  REDOLOG multiplexing

ü  View Redo log Groups

ü  View Redo log members

ü  Redo log creation

ü  Drop Redo log group , member

ü  Adding member to Redo log group

ü  View status

ü  Manual Switching

ü  Drop members from group

 

     Archive Log And Flash Recovery Area

 

ü  Configuring Database in Archive log mode

ü  Configuring database in no archive log mode

ü  Configure FRA

ü  Manual switching

ü  Verify

 

 

Table space Management

 

ü  Permanent table space

ü  Temporary table space

ü  Undo table space

ü  SYSTEM .dbf

ü  SYSAUX.dbf

ü  Users.dbf

ü  Temp.dbf

ü  Unodtbs.dbf

ü  Roll back

ü  Creating permanent table space with limited size

ü  Creating permanent table space with unlimited size

ü  Creating permanent table space with fixed size

ü  Adding data file to existing table space

ü  Resizing data file

ü  Table space online

ü  Table space offline

ü  Drop table space

ü  Auto extend feature

ü  View user table space

ü  Determine Database size

ü  Determine used database size

ü  Determine allocate data size

ü  Determine table space size

ü  Determine table size

 

User Management And Security

 

ü  Database user creation

ü  User connects to database

ü  Creating role

ü  Assigning privilege to role

ü  Assigning role to a user

ü  Revoking privilege from role

ü  View user roles

ü  View user privileges

ü  Password set for user

ü  User account lock

ü  User account unlock

ü  Drop a user

ü  User creation with Permanent table space

ü  User creation with Temporary table space

ü  Quota configuration

ü  Quota increase

ü  Quota decrease

ü  Quota revoke

ü  Quota unlimited

ü  Security Profile  

ü  Security Password

ü  Security Kernel

 

 

Oracle Network Services

 

ü  TCP IP Configuration

ü  Ping

ü  Listener

ü  Tns names

ü  Netca tool

ü  Port Range

ü  Location

ü  Listener services

ü  Bouncing services

ü  Stop service

ü  Start service

ü  status service

ü  Testing connection

ü  Client side tns configuration

ü  Linux to Linux setup

 

 

Backup  And Restoration

 

ü  Logical backup

ü  Physical backup

ü  Online backup

ü  Offline backup

ü  Import statement

ü  Export Statement

ü  Data pump technology

ü  Full database level backup

ü  Incremental level backup

ü  Cumulative level backup

ü  User level backup

ü  Table level backup

 

 

Patch Management

 

ü  What is a patch

ü  Understand Oracle version

ü  Installing Oracle software

ü  Creating database 10g

ü  Patch set procedure

ü  Unzip the patch set

ü  Apply patch

ü  scripts

ü  Verify invalid objects

ü  Recompile

ü  Verify Oracle version

 

 

Up gradation from 10g to 11g

 

ü  Understanding Pre requisite for upgrade

ü  Verify existing Oracle home location

ü  Verify existing Oracle Base location

ü  Installing 11g

ü  Verify pre upgrade script

ü  Modification of Parameter file values

ü  Upgrading database with 11g

ü  Verify invalid objects

ü  Recompile

ü  Verify Oracle version

 

Cloning

 

ü  Cloning concept

ü  Online Cloning

ü  Pre requisite for online cloning

ü  online backup

ü  Generate control trace file

ü  Conversion of trace file

ü  Preparing client machine

ü  Cloning on client machine

ü  Recover data from archive log

ü  Verify cloning on client machine

 

 

Automatic Storage Management

 

ü  ASM Concept

ü  Pre requisite ASM

ü  Disk group creation

ü  ASM Instance configuration

ü  Local configuration add

ü  ASM disk

ü  Installing Oracle binaries

ü  RDBMS instance configuration

ü  Manual database creation on storage

ü  verify database creation

 

 

Data Guard - Disaster Recovery solution

 

ü  Data Guard concept

ü  Feature of DG

ü  Implementing DG

ü  Pre requisite of DG

ü  DG configuration on Primary server

ü  DG configuration on secondary server

ü  Verify replication through manual switch log files

 

Recovery Manager Infrastructure setup

 

ü  Pre requisite of RMAN

ü  RMAN configuration on server side

ü  RMAN configuration on client side

ü  connecting to idle catalog database

ü  create catalog database

ü  RMAN database register

ü  verify target server information

ü  RMAN statements

ü  Using RMAN backup

 

 


FOR FREE DEMO contact us at:

Email : training@apex-online-it-training.com

Phone/WhattsApp : +91-(868) 622-2553