|
所在平台: Udemy |
课程主页: https://www.udemy.com/course/hands-on-linux-7-setup-for-oracle-12c-database-zero-to-hero/
课程评论：没有评论
**课程名称：Oracle数据库管理员（DBA）基础** **课程概述：** 本课程旨在为有经验的专业人士提供Oracle数据库的实操技能。Oracle数据库以其复杂性和先进性而闻名，掌握它需要多方面的技能。许多候选人虽然具备OCP认证和扎实的理论知识，但在实际操作方面存在不足。本课程正是为了解决“没有工作如何获得实践经验”这一普遍难题而设计。 **课程内容亮点：** * **核心工具的学习：** 帮助DBA识别问题并有效升级至Oracle技术支持。 * **Oracle 12c 架构内部详解：** 通过幻灯片深入理解Oracle 12c的架构。 * **Oracle 12c 内存内部详解：** 通过幻灯片深入理解Oracle 12c的内存管理。 **实践操作演示（Quick Review）：** * Oracle 18c 安装演示 * Oracle Enterprise Manager (OEM) 安装步骤演示 * Oracle 从非RAC到RAC数据库迁移演示 * RAC 环境下 Oracle 数据库克隆演示 * Oracle 数据库从 Windows 迁移到 Linux 演示 * 使用 RMAN 复制 Oracle 数据库演示 **Oracle Database 19c 安装（Oracle Linux 7）行动计划：** 1. 准备 Oracle Linux 7.6 操作系统以安装 Database 19c。 2. 配置 Virtual Box 以运行 Oracle Linux 7 虚拟机。 3. 设置静态 IP 地址。 4. 配置内核参数。 5. 配置资源限制并停止防火墙。 6. 安装依赖项。 7. 安装 Oracle 数据库。 8. 配置 Oracle Linux 虚拟机的宿主名称。 9. 安装后的 Oracle Listener 配置。 10. 在 SQL Plus 中启动数据库。 11. 创建一个名为 "scott" 的通用用户。 12. 使用 SQL Developer 19.1 连接到 Oracle Database 19c。 13. 挂载可插拔数据库 orclpdb 并检查 SQL Developer 的连接性。 14. 在宿主机的浏览器中访问 Oracle Enterprise Manager。 **目标学员：** 具备一定Oracle理论知识，寻求提升实操能力的数据库专业人士。
Oracle is among the world's most complex and sophisticated databases, and mastering this complex set of computer programs requires many skills. Learning Oracle is only appropriate for experienced professionals with appropriate prerequisite training.I was interviewing a few candidates which had OCP in their resume but even though they had good theoretical knowledge but lack in hands-on. One of the candidate frankly told me that without job how to get hands on. And this course is the answer to his valid question. In this course we will also learn very useful tool which help DBA to identify they issue and how to escalate issue to Oracle support.Oracle 12C Architecture internal (Slides)Oracle 12C Memory Internal (Slides)======QUICK REVIEW VERY Useful for DBA Install oracle 18c Demo Install Oracle enterprise manager(OEM) in steps DemoOracle Migration from Non-RAC to RAC database DemoOracle Database clone in RAC enviroment DemoConvert oracle database from windows to Linux DemoDuplicate Oracle Database using RMAN Demo=========================================Oracle Database 19c installation in Oracle Linux 7 Action Plan: 1. Preparing the Oracle Linux 7.6 Operating System for Database 19c installation. 2. Virtual Box Settings for Oracle Linux 7 VM. 3. Setting the static ip address 4. kernel parameters configuration 5. Resource limit configuration and stopping the Firewall 6. dependencies installation 7. oracle database installation 8. Host name configuration for Oracle Linux VM. 9. Oracle listener configuration after installation. 10. Starting the Database in SQL Plus 11. Create one Common user called "scott" 12. SQL Developer 19.1 Connectivity with Oracle database 19c 13. Mounting the pluggable database orclpdb and check connectivity on SQL Developer. 14. Access the Oracle Enterprise Manager on host machine browser.
