Teach on Udemy

Turn what you know into an opportunity and reach millions around the world.

Learn More

Your cart is empty.

Keep shopping

Oracle Database Administration

Name: Oracle Database Administration
Rating: 3.6 (60 reviews)

Complete tutorial for oracle dba | Oracle database administration with practical solutions

Created byAnkush Thavali

Last updated 9/2019

English

English [Auto],

What you'll learn

Oracle DBA experts
Core DBA technology Knowledge
Advance Knowledege on Oracle Database-Administration
Oracle 12C basic concepts
Dataguard configuration and there diffrent type installation
ASM knowledge and configuration part
Backup in Oracle database
Diffeferent recovery real time scneraios
Performance Tuning Basics
Basics of RAC and High Availability
Oracle 18C database Installation and Administration
New trending topics will be added soon based on demand also

Course content

6 sections • 42 lectures • 7h 54m total length

Intoduction7:31
Explore Oracle database administration, roles and responsibilities, ensuring data availability, managing listeners, tablespace and data file space, backups, performance tuning, migrations, and upgrades through practical scenarios.
How to open GUI in putty session12:21
Learn how to open a graphical user interface in a PuTTY session by using Xming as the X server, enabling X11 forwarding, and configuring the display to localhost:0.
Create,Delete Oracle Services using Oradim Utility13:01
How to Set Environment in Oracle Windows Server- Set ORACLE_HOME & ORACLE_SID18:06
Learn to set the Oracle environment on Windows by configuring ORACLE_HOME and ORACLE_SID, adjusting PATH and system variables, and connecting to a database using sequel plus across multiple Oracle homes.
How to start,stop database .9:26
Learn to start and shut down an Oracle database in production, including connecting to an Oracle instance, choosing startup stages (normal, mount, open), and safe shutdown practices.
How to change DBID in oracle7:04
Change the Oracle DBID and database name using the provided syntax, perform practical steps, and verify the new DBID while noting that backups may become unusable after the change.
How to change DB Name in Oracle15:11
Discover how to change a database name in Oracle, covering preparation, applying the new name, and restarting the database with proper privileges and updated log records.
How to rename datafile in Oracle 11G8:04
Identify all Oracle 11g datafiles and their status, offline the target file, rename and move it to a new name and location, then online the file with the updated name.
How to change Archive destination in Oracle9:28
Learn how to change the Oracle archive destination to a new directory when space runs out, verify available space, and switch archivelogs via command line without downtime.
How to start,stop,Reload Listener in Oracle8:15
Start and stop the oracle listener, check its status, and restart to apply changes. Understand that listener status is separate from business services.
Alert log file in Oracle7:33
Discover how to locate the Oracle alert log, understand its role in capturing errors, and learn practical steps to view the log when the database is up or down.
How to recover missing control file10:00
Discover how to recover a missing control file in Oracle database administration by restoring a backup control file, shutting down and starting up the database, and mounting the database.
How to recover missing data files15:32
Spool file in Oracle7:32
Learn how to spool output from Oracle SQL queries into log and spool files, create and replace spool files, and use spooling to capture application query results.
How to set Static Ip address6:23
Learn to distinguish static and dynamic IP addresses and set a static IP on an Oracle enterprise linux 5.5 server, using practical IP examples.
Basic Unix command for Oracle DBA11:10
Learn essential Unix commands for Oracle DBA, including navigating directories, listing files, editing with vi, managing permissions, and launching SQL Plus to connect to a server.
Export Import Table in oracle16:26
Learn to back up a table using Oracle's data pump export and import utilities. Set a dump and log file in a directory, export the table, then reimport after drop.
Parfile in oracle10:25
How to Install SQL developer tool7:12
Install and use the sql developer tool to connect to an oracle database by creating a new connection, configuring hostname, listener, and login details.
How to Create Pfile to SPFile and Vice-Versa8:57
Learn how to create a pfile from an spfile and vice versa, including options to create from an existing file, start the database, and adjust initialization parameters.
Parameter Files in Oracle - PFile and SPfile7:49
Explore parameter files in Oracle, including pfile and spfile, and how they affect starting the database, file formats (human readable vs binary), and locating data files and Oracle home paths.

How to create Non-Container Database-Oralcle 12C Administration17:59
Learn to create a non-container Oracle 12c database using the DBC seed, select templates, configure memory and system password, and verify the running database with generated scripts.
Create Pluggable database using DBCA-Oracle 12C Administration8:16
learn how to create a pluggable database using dbca in oracle 12c administration, using the graphical interface to name the pdb, set data file locations, and verify status.
How to create Pluggable database Manually-Oracle 12C database administration8:03
Learn how to manually create a pluggable database in Oracle 12c using SQL prompt, including creating a pdb, user, password, and associated tablespace, with template seed data.
How to start/stop/Basic of Pluggable database-Oracle 12C administration9:31
Learn the basics of Oracle 12c pluggable database administration by starting and stopping a PDB, checking connection status, and performing container to pluggable operations.
How to Rename Pluggable Database-Oracle 12C Administration9:14
Rename a pluggable database in oracle 12c administration by preparing the new name, restricting user connections, shutting down the database, and applying the updated pdb name.
How to Drop Pluggable database - Oracle 12C Administration6:30
students learn how to drop a pluggable database in Oracle 12c administration, including options to drop or keep data files with the including data files clause.
How to take backup of container-pluggable database21:24
Migration from Non-Container Database to Pluggable Database-PART I- Oracle 12C9:30
Migrate a non-container database to a pluggable database in Oracle 12c by preparing a manifest with DBMSs, validating compatibility, and creating the pluggable database with the same name.
Migration from Non-Container Database to Pluggable Database-PART II- Oracle 12C37:16
See a practical migration from a non-container database to a pluggable database in Oracle 12c, using a manifest file, compatibility checks, and post-migration data validation.
Oracle 12C Feature on Invisible Column4:10
Explore Oracle 12c's invisible column feature, which hides a column from standard selects for security; create with invisible and require explicit column names to access data.

Introduction of Dataguard5:07
Explain how Data Guard provides disaster recovery and business continuity by maintaining a primary database and a standby database, with change synchronization and rapid failover.
Check if Primary database is in Sync with Standby in Dataguard6:31
Verify that the primary database is in sync with the standby in Dataguard by checking the primary and standby states and log shipping status.
Snapshot Standby Database Introduction6:14
Learn how snapshot standby databases relate to physical standbys, how to create and manage snapshots, and how to convert between snapshot and physical standby using available knobs.
How to convert Physical standby database to Snapshot Standby Database7:05
Learn how to convert a physical standby database to a snapshot standby in Oracle, create a restore point, and verify replication status.
How to convert SnapShot to Physical Standby database9:06
learn how to convert a snapshot standby to a physical standby database, including shutting down and mounting the standby, starting the process to apply changes, and verifying the standby status.
Swichover introduction in Oracle Dataguard5:48
Explore how Oracle Data Guard switchover lets a standby take over for the primary during maintenance or disaster, preserving availability and seamless access for users.

Oracle 18C download and Prerequisite9:33
Verify windows 64-bit readiness and memory and storage prerequisites before installing oracle 18c on windows. Download the software, accept the license, and proceed with the installation.
Installation of Oracle 18C database on Windows Server24:10
Install Oracle 18c database on Windows server by downloading and extracting the software to a dedicated folder, configuring permissions, and creating a Windows user for administration.
How to connect to EM(Enterprise manager) Express with Oracle 18C database16:03
Learn to connect to Oracle 18c via Enterprise Manager Express, configure ports, and monitor databases with mail notifications and reports for efficient database administration.

Requirements

Basic knowledge of SQL and Linux. We are here to help you out for more understanding.
Please mark the Video speed to 1x .
Please download udemy app from google play store and run the video from app for better Audio and Video quality.

Description

Course targeting to those students who wanted to start there carrier as Oracle Database administration. I have covered most of the topic including real time scenario. I will keep posted the same on your demand.

Please send me mail on below email ID if you have any queries. I will try to solve the same as soon as possible.

Following are the important topics covered in course

1) Core DBA

2)RAC(Real application cluster)

3)Dataguard

4)ASM(Automatic Storage management)

5)Oracle 12C Administration

6)RMAN Backups

7)Logical Backups

8)Monitoring Tools

9)Basic understanding of ITIL Process

Course Feature

===========================

1)All videos contain the real time scenario which you will face in daily DBA routine. We create the problem and then provide the way to get the solution.

2)New Videos will be added to course

3)On Demand Videos will be added.

4)you can reach directly vie mail or message for any technical query.

What Do Oracle Database Administrator (DBA)s Do?

Oracle database administrators are responsible for designing, maintaining and ensuring that the company's Oracle database runs smoothly; they are often responsible for other databases as well. These administrators work alongside other IT specialists, office staff and department heads, and they oversee database assistants. Oracle database administrators work with computers and computer systems daily, running multiple monitors and systems to check their accuracy and workability, as well as troubleshoot any errors found. Common tasks include writing code for a program, testing it to make sure it works, and implementing it into their company software. They may deal with issues in existing software and collaborate with other employees in the company to determine what changes, if any, need to be made.

Who this course is for:

Students looking for Oracle DBA as career in future
Working people in IT industry those who want to start there in DBA life
Anyone who is interested in understanding of data management and data security
Previous experience will help to understand much clear

Oracle Database Administration

What you'll learn

Explore related topics

Course content

Core Oracle Dba Administration21 lectures • 3hr 37min

Oracle 12C Container-Pluggable database Administration10 lectures • 2hr 12min

Dataguard Administration6 lectures • 40min

RAC (Real Application Cluster)1 lecture • 19min

Oracle 18C Database3 lectures • 50min

Oracle 19C Installation1 lecture • 17min

Requirements

Description

Who this course is for: