1 / 19

Oracle DBA Online Training

Oracle DBA Online Training : <br><br>As you are aware, Oracle DBA is an evergreen technology in the market. As the usage of Oracle DBA is increasing day by day, the demand for experts is ever increasing. Cheyat offers the best up-to-date Oracle DBA online training through its seasoned trainers. Jump ahead in your career by joining Cheyat to get the latest version of Oracle DBA online training. Basic knowledge on SQL programming is sufficient for a learner to get started and become a master professional in Oracle DBA.<br><br>Course Content : http://cheyat.com/oracle/oracle-dba-online-training-tutorials<br><br> For more info Contact us : Trainings@cheyat.com <br>Thanks & Regards,<br>Jilani Shaik<br> 91-9100998433 / 34 (WAPP)

cheyattech
Download Presentation

Oracle DBA Online Training

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  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

  2. What is Oracle DBA • 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.

  3. Course Content 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

  4. Infrastructure setupinstallation of virtual workstationinstallation of OEL operating systemOEL oracle enterprise linuxdisk druid configurationmanual partitionsassigning static ip to ethernettime zone selectionroot user password configurationpackages selectionpost installation configurationlogin to the OSinstalling virtual toolssharing of folders from host OS to virtual OScloning of OS in virtual workstationstart and shut of OS

  5. Basic linux commandspre installation configurationcreating group,userpassword assigningcreating, appending, & view file with catmoving and renaming a filecopy, remove commandscreation of directorytouch, persistence, visual editor & time stamp password configuration, normal user switchingxhost + hostname configurationservice restartingchange directorypresent working directorybash profile, executing bash profilepermissions,ownershipexecuting bashXHOST +switching user

  6. Basic installation methodAdvance installation methodDBCA methodmanual database creationConnecting to DatabaseSQLPLUS toolVerify database nameVerify database statusVerify control file locationVerify data files locationVerify redo log files locationVerify flash recovery area locationVerify Archive mode or No archive modeShut database

  7. Parameter file managementDatabase startup processdatabase no mount stageSID and parameter filePFILE locationPFILE namePFILE configurationverify PFILE OR SPFILE in DBSPFILE nameSPFILE configurationSPFILE memory optionSPFILE scope optionSPFILE SPFILE optioncreate SPFILE from SPFILEcreate PFILE from SPFILEbackup and restoration of parameter file

  8. Control file managementORACLE instance start up processDATABASE mount stagecontrol file characteristicscontrol file multiplexingverify multiplexingRedo log file managementORACLE instanceREDOLOG algorithmREDOLOG multiplexingview redo log groupsview redo log membersredo log creationdrop redo log group , memberadding member to redo log groupview statusmanual switchingdrop members from group

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

  10. Oracle network servicesTCP IP configurationpinglistenertns namesnetca toolport rangelocationlistener servicesbouncing servicesstop servicestart servicestatus servicetesting connectionclient side tns configurationlinux 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

  11. Patch managementwhat is a patchunderstand oracle versioninstalling oracle softwarecreating database 10gpatch set procedureunzip the patch setapply patchscriptsverify invalid objectsUp gradation from 10g to 11gunderstanding pre requisite for upgradeverify existing oracle home locationverify existing oracle base locationinstalling 11gverify pre upgrade scriptmodification of parameter file valuesupgrading database with 11g

  12. 3-tier Architecture 

  13. Cloningcloning conceptonline cloningpre requisite for online cloningonline backupgenerate control trace fileconversion of trace filepreparing client machinecloning on client machinerecover data from archive logAutomatic storage managementASM conceptpre requisite ASMdisk group creationASM instance configurationlocal configuration addASM diskinstalling oracle binariesRDBMS instance configuratio

  14. Data guard - disaster recovery solutiondata guard conceptfeature of DGimplementing DGpre requisite of DGDG configuration on primary serverDG configuration on secondary serververify replication through manual switch log filesrecovery manager infrastructure setuppre requisite of RMANRMAN configuration on server sideRMAN configuration on client sideconnecting to idle catalog databasecreate catalog databaseRMAN database registerverify target server informationRMAN statementsusing RMAN backup

  15. Responsibilities of Administrator

  16. Highlights ofOracle DBA Online training Provided By Cheyattraining • 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.

  17. Offered other modules : • 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

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

More Related