The Best Oracle DBA Online Training Institute - Cheyat Technologies

Views:
 
Category: Education
     
 

Presentation Description

Cheyat Technologies offers the best up-to-date Oracle DBA Online Training Free Demo Session Today @ 10:00 PM IST through its seasoned trainers. Cheyat Technologies provide quality teaching services which in turn help us to earn multitude of the learners, with real time examples in order to ensure that all our students are capable enough to handle real time scenarios. We provide on job support by real time experts in India and USA. View Oracle DBA Online Training Demo Video & Course Content: http://cheyat.com/oracle/oracle-dba-online-training-tutorials.html

Comments

Presentation Transcript

Slide 1:

ORACLE DBA ONLINE TRAINING Email Id : trainings@cheyat.com Contact IND : +91-91009-98433/34(WAPP) USA : +1(224) 676-9882 Skype ID : Cheyattraining

Slide 2:

A database administrator (DBA) directs or performs all activities related to maintaining a successful  database  environment. Responsibilities include designing, implementing, and maintaining the database system; establishing policies and procedures pertaining to the management,  security, maintenance, and use of the  database management system ; and training employees in database management and use. A DBA is usually expected to have experience with one or more of the major database management products, such as Structured Query Language,   SAP, and Oracle-based database management software . What is Oracle DBA

Slide 3:

Infrastructure setup Basic Linux commands Installing ORACLE And Database creation Connecting to Database Parameter file management Control file management Redo Log file management Archive Log And Flash Recovery Area Table space Management User Management And Security Oracle Network Services Backup And Restoration Patch Management Up gradation from 10g to 11g Cloning Automatic Storage Management Data Guard - Disaster Recovery solution Recovery Manager Infrastructure setup 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:

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 pre installation configuration creating group,user password assigning creating, appending, & view file with cat moving and renaming a file copy, remove commands creation of directory touch, persistence, visual editor & time stamp password configuration, normal user switching xhost + hostname configuration service restarting change directory present working directory bash profile, executing bash profile permissions,ownership executing bash XHOST +switching user:

Basic linux commands pre installation configuration creating group,user password assigning creating, appending, & view file with cat moving and renaming a file copy, remove commands creation of directory touch, persistence, visual editor & time stamp password configuration, normal user switching xhost + hostname configuration service restarting change directory present working directory bash profile, executing bash profile permissions,ownership executing bash XHOST +switching user

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:

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

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:

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:

Control file management ORACLE instance start up process DATABASE mount stage control file characteristics control file multiplexing verify multiplexing R edo 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

Slide 9:

Oracle 50% OF Market Share DB2 INFORMIX SQL Server SYBASE Oracle Data Base  A database is an organized collection of data for one or more purposes, usually in digital form .

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 :

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 Restoring 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 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 :

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 U p 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

Slide 12:

3-tier Architecture 

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 Automatic storage management ASM concept pre requisite ASM disk group creation ASM instance configuration local configuration add ASM disk installing oracle binaries RDBMS instance configuratio:

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 Automatic storage management ASM concept pre requisite ASM disk group creation ASM instance configuration local configuration add ASM disk installing oracle binaries RDBMS instance configuratio

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:

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

Responsibilities of Administrator:

Responsibilities of Administrator

Slide 16:

Highly interactive and career oriented sessions. A comprehensive training program based on your learning needs. Record sessions options are available for reference after the completion of the course. Most of our trainers have minimum of 6+ years experience in the field of corporate training. Excellent communication skills. 24/7 access to practice whenever and wherever necessary. 24/7 access to technical support team through e-mail, chat and phone. Boundless access to the digital library in order to become a master of the course . Highlights of   Oracle DBA Online training Provided By Cheyattraining

Slide 17:

SAP : BPC 10.1 BASIS, Security, GRC, Netweaver, ABAP, FICO, Hana, MM,MDG, PI/XI, Hana Admin, FSCM, Oil& Gas …….Etc . ORACLE : DBA, PL/SQL OBIEE, Apps DBA, SOA, IDM…..ETC. QA : Loadrunner , Selenium, UFT, HP AM,HP Quality Center ….ETC Hot Course : Work Day …. Etc Offered other modules :

Slide 18:

Contact us Email Id : trainings@cheyat.com Contact us : IND : + 91-91009-98433/34(WAPP) USA : +1(224) 676-9882 Skype ID : Cheyattraining

authorStream Live Help