So, this reminds me the first chapter. But, one thing that I've only noticed now is.. in the first skillset, it starts with "Create the Database". There is no "Install Oracle Database software" there. ^^ Here, what I recommend you to practice is: Install Oracle DB using GUI (preferable, of course). Install Oracle DB using CLI …
Jul 27
OCM 11g Preparation - Start, stop, configure and administer Oracle Grid Infrastructure
Configure and administer Grid Infrastructure can be done using the 2 main provided tools: "crsctl" and "srvctl". srvctl start/stop -> Start/Stop the cluster services. srvctl realocate -> Move some service, like the scan listener. srvctl status -> Check if service is running. srvctl config -> Display configuration. srvctl modify -> Change configuration. crsctl start/stop crs -> Start/Stop everything. …
Jul 27
OCM 11g Preparation - Implement ASM failure groups
Failure groups is a way to implement some kind of RAID protection in your diskgroups. Its very useful when you want to guarantee an extra protection and turn on hot swap of your disks without an extra cost of an storage system. Honestly, every company that I've worked avoided this protection as we had this …
Jul 27
OCM 11g Preparation - Create ASM Disk Groups
Creating ASM disk groups is a easy task. You have several ways of doing it, like: asmca (Preferable) sqlplus asmcmd Enterprise Manager (Yes, don't forget him!) Practice all of them. Path to Documentation: Automatic Storage Management Administrator's Guide -> 4 Administering Oracle ASM Disk Groups Automatic Storage Management Administrator's Guide -> 11 Oracle ASM Configuration …
Jul 26
OCM 11g Preparation - Creating ACFS File System
Oracle ACFS files systems are typically configured for clusterwide access. File systems, files, and directories are visible and accessible from all cluster members and can be referenced by users and applications using the same path names from any cluster member. This is a good way to also implement a unique Oracle Database Home shared in …