Home
Search results “Oracle status standby”
How to Start Physical Standby database & Check if Database is in Sync
 
06:32
How to Start Physical Standby database & Check if Database is in Sync Dataguard Status ==================================================== Start Standby Database =============================== startup nomount alter database mount standby database; alter database recover managed standby database disconnect from session; DB STATUS ======================= select status,instance_name,database_role,protection_mode from v$database,v$instance; TO check if dataguard in synchronizing with standby. ============================================================================= select thread#,max(sequence#) from v$archived_log where applied='YES' group by thread#; Status of MRP Process --------------------------- select process,status,client_process,thread#,sequence#,block#,blocks,delay_mins from v$managed_standby; To get the diffrence between Recived and applied logs. ------------------------------------------------------- select MAX_RECEIVED,MAX_APPLIED,(MAX_RECEIVED - MAX_APPLIED) as "Difference" from (SELECT ARCHIVED_THREAD#, MAX(ARCHIVED_SEQ#) as MAX_RECEIVED, APPLIED_THREAD#, MAX(APPLIED_SEQ#) as MAX_APPLIED FROM V$ARCHIVE_DEST_STATUS) ARCH ; ================================================= Hi Folks, Greetings!! I am professional part time oracle dba trainer and having good experience in oracle database administration. This is the right place to enroll yourself for Oracle DBA real time course. Please use following email ID for more details. Don’t hesitate to WhatsApp me any time. I will give you the best training and will create path to get DBA job easily. Enjoy the free YouTube video and connect with me for deep Oracle DBA knowledge. Mobile No : + 91 9960262955 (WhatsApp Number) EmailID: [email protected]
Views: 935 ANKUSH THAVALI
Concurrent Request Phase and Status( phase  Inactive Status No Manager Oracle Requests error)
 
06:04
Explain the "phase Inactive Status No Manager" error in oracle E-Business Suite
Views: 1663 Mohamed Farag
Redo Logs in an Oracle Database - DBArch Video 11
 
08:54
This video explains the concepts of Redo Log Groups and Files in an Oracle Database. You will understand how Oracle Instance uses Redo Buffers and Logwriter to keep the redo in Redo Logs. Our Upcoming Online Course Schedule is available in the url below https://docs.google.com/spreadsheets/d/1qKpKf32Zn_SSvbeDblv2UCjvtHIS1ad2_VXHh2m08yY/edit#gid=0 Reach us at [email protected]
Views: 11539 Ramkumar Swaminathan
How to convert Physical  Standby database to Snapshot Standby Database-DataGuard
 
07:05
Check DB Status =========================================== select status,instance_name,database_role,open_mode from v$database,v$Instance; Check Flashback status =================================== select flashback_on from v$database; Status of MRP Process ----------------------------- set lines 1234 pages 1234; select process,status,client_process,thread#,sequence#,block#,blocks,delay_mins from v$managed_standby; Cancel the MRP ================================ alter database recover managed standby database cancel; Convert to Snapshot Standby ========================================== alter database convert to snapshot standby; Open the database =========================== alter database open; ============================================== Hi Folks, Greetings!! I am professional part time oracle dba trainer and having good experience in oracle database administration. This is the right place to enroll yourself for Oracle DBA real time course. Please use following email ID for more details. Don’t hesitate to WhatsApp me any time. I will give you the best training and will create path to get DBA job easily. Enjoy the free YouTube video and connect with me for deep Oracle DBA knowledge. Mobile No : + 91 9960262955 (WhatsApp Number) EmailID: [email protected]
Views: 243 ANKUSH THAVALI
How to convet physical standby into read only mode part-3
 
05:21
How to convert your physical standby database into read only mode and how to bring back into physical standby step by step. HOW TO APPLY REDO PROCESS IN ORACLE DATA GUARD 11G R2 STEP BY STEP. PART-1 USE BELOW LINK https://youtu.be/wfzEfeNvr_Q PART-2 USE BELOW LINK https://www.youtube.com/watch?v=1UsKglLEvtc PART-4 USE BELOW LINK https://www.youtube.com/watch?v=1Gf2UVXD3RY PART-5 USE BELOW LINK https://www.youtube.com/watch?v=Qkz8gj64PYo PART-6 USE BELOW LINK https://www.youtube.com/watch?v=62GrNn8e06Q
Views: 2347 OCP Technology
How to convert Snapshot  Standby Database to Physical Standby Database-Oracle Dataguard
 
09:07
Database should be in mount Stage select name, guarantee_flashback_database from v$restore_point; ALTER DATABASE CONVERT TO PHYSICAL STANDBY; shutdown database startup database in mount stage Start the MRP process
Views: 142 ANKUSH THAVALI
Oracle Standby DataGaurd 12c Part 1
 
14:32
Oracle Standby DataGaurd 12c Part 1
Views: 140 Jamaal Khan
Using DG-Broker how to switchover Primary and standby roles step by step
 
06:02
Hello Friends, Today i'm going to show you how to switchover primary & standby role using DG-Broker step by step. Please subscribe ocptechnology on YouTube for more updated.
Views: 1777 OCP Technology
06.05 Oracle_10gR2_DataGuard_6.5 Perform a Failover to the Physical Standby - xiamennode.avi
 
13:47
Oracle 10g/11g RAC, DataGuard, GoldenGate,Streams Hands-on Practices Training. Please feel free to contact me: E-mail/Skype: [email protected] Oracle Database 10gR2 High Availability with Data Guard on Linux http://www.youtube.com/playlist?list=PLCEC4947864F3B571 6. Role Transition - Physical Standby Database 6.1 Perform a Switchover with shanghainode and xiamennode Step 1: Verify the Switchover status on the Primary - shanghainode Step 2: Convert the primary database into a physical standby database Step 3: Shut down and restart the former primary as a new standby Step 4: Query the SWITCHOVER_STATUS on the standby database Step 5: Convert the former standby to a primary database Step 6: Shutdown and restart the new primary database Step 7: Start Redo Apply on the new physical standby - shanghainode Step 8: Start Redo Apply on the physical standby - longyannode Step 9: Verify the new primary and standby database 6.2 Perform a Switchback with xiamennode and shanghainode Step 1: Verify the Switchover status on the Primary - xiamennode Step 2: Convert the primary database into a physical standby database Step 3: Shut down and restart the former primary as a new standby Step 4: Query the SWITCHOVER_STATUS on the standby database Step 5: Convert the former standby to a primary database Step 6: Shutdown and restart the new primary database Step 7: Start Redo Apply on the new physical standby - xiamennode Step 8: Start Redo Apply on the physical standby - longyannode Step9: Verify the new primary and standby database 6.3 Perform a Switchover with shanghainode and longyannode Step 1: Verify the Switchover status on the Primary - shanghainode Step 2: Convert the primary database into a physical standby database Step 3: Shut down and restart the former primary as a new standby Step 4: Query the SWITCHOVER_STATUS on the standby database Step 5: Convert the standby to a primary database Step 6: Shutdown and restart the new primary database Step 7: Start Redo Apply on the new physical standby - shanghainode Step 8: Start Redo Apply on the physical standby - xiamennode Step 9: Verify the new primary and standby database 6.4 Perform a Switchback with longyannode and shanghainode Step 1: Verify the Switchover status on the Primary - shanghainode Step 2: Convert the primary database into a physical standby database Step 3: Shut down and restart the former primary as a new standby Step 4: Query the SWITCHOVER_STATUS on the standby database Step 5: Convert the former standby to a primary database Step 6: Shutdown and restart the new primary database Step 7: Start Redo Apply on the new physical standby - longyannode Step 8: Start Redo Apply on the physical standby - xiamennode Step 9: Verify the new primary and standby database 6.5 Perform a Failover to the Physical Standby - xiamennode Step1: Identify and resolve any archive log gaps Step2: Copy and register any other missing archived redo logs Step3: Perform terminal recovery on the target standby Step4: convert the physical standby into a primary database Step5: Restart the new primary database in read/write mode Step6: Verify the new Primary Database Step7: Perform a full backup of the new primary database Step8: Flashing Back the Physical Standby Database - longyannode Step9: Using Flashback Database After a Failover 6.6 Flashing Back a Failed Primary into a Physical Standby Step1: Determine the SCN at which the old standby database became the primary database Step 2: Flash back the failed primary database Step 3: Convert the Failed Database to a Physical Standby Database Step 4: Shut down and restart the old primary database Step 5: Restart transporting redo to the new physical standby Step 6: Start Redo Apply Step 7: Restart Redo Apply on the new physical standby database if necessary Step 8: Verify the new primary and standby database 6.7 Perform a Switchback with xiamennode and shanghainode Step1: Verify the Switchover status on the Primary - xiamennode Step2: Convert the primary database into a physical standby database Step3: Shut down and restart the former primary as a new standby Step4: Query the SWITCHOVER_STATUS on the standby database Step5: Convert the former standby to a primary database Step6: Shutdown and restart the new primary database Step7: Start Redo Apply on the new physical standby - xiamennode Step8: Start Redo Apply on the physical standby - longyannode Step9: Verify the new primary and standby database
Views: 515 Yongcheng Lai
How to Create Oracle Duplicate Database with Recovery Manager RMAN Part 01
 
12:54
How to Create Oracle Duplicate Database with Recovery Manager RMAN Part 01
Views: 15921 Abbasi Asif
06.06 Oracle_10gR2_DataGuard_6.6 Flashing Back a Failed Primary into a Physical Standby.avi
 
10:17
Oracle 10g/11g RAC, DataGuard, GoldenGate,Streams Hands-on Practices Training. Please feel free to contact me: E-mail/Skype: [email protected] Oracle Database 10gR2 High Availability with Data Guard on Linux http://www.youtube.com/playlist?list=PLCEC4947864F3B571 6. Role Transition - Physical Standby Database 6.1 Perform a Switchover with shanghainode and xiamennode Step 1: Verify the Switchover status on the Primary - shanghainode Step 2: Convert the primary database into a physical standby database Step 3: Shut down and restart the former primary as a new standby Step 4: Query the SWITCHOVER_STATUS on the standby database Step 5: Convert the former standby to a primary database Step 6: Shutdown and restart the new primary database Step 7: Start Redo Apply on the new physical standby - shanghainode Step 8: Start Redo Apply on the physical standby - longyannode Step 9: Verify the new primary and standby database 6.2 Perform a Switchback with xiamennode and shanghainode Step 1: Verify the Switchover status on the Primary - xiamennode Step 2: Convert the primary database into a physical standby database Step 3: Shut down and restart the former primary as a new standby Step 4: Query the SWITCHOVER_STATUS on the standby database Step 5: Convert the former standby to a primary database Step 6: Shutdown and restart the new primary database Step 7: Start Redo Apply on the new physical standby - xiamennode Step 8: Start Redo Apply on the physical standby - longyannode Step9: Verify the new primary and standby database 6.3 Perform a Switchover with shanghainode and longyannode Step 1: Verify the Switchover status on the Primary - shanghainode Step 2: Convert the primary database into a physical standby database Step 3: Shut down and restart the former primary as a new standby Step 4: Query the SWITCHOVER_STATUS on the standby database Step 5: Convert the standby to a primary database Step 6: Shutdown and restart the new primary database Step 7: Start Redo Apply on the new physical standby - shanghainode Step 8: Start Redo Apply on the physical standby - xiamennode Step 9: Verify the new primary and standby database 6.4 Perform a Switchback with longyannode and shanghainode Step 1: Verify the Switchover status on the Primary - shanghainode Step 2: Convert the primary database into a physical standby database Step 3: Shut down and restart the former primary as a new standby Step 4: Query the SWITCHOVER_STATUS on the standby database Step 5: Convert the former standby to a primary database Step 6: Shutdown and restart the new primary database Step 7: Start Redo Apply on the new physical standby - longyannode Step 8: Start Redo Apply on the physical standby - xiamennode Step 9: Verify the new primary and standby database 6.5 Perform a Failover to the Physical Standby - xiamennode Step1: Identify and resolve any archive log gaps Step2: Copy and register any other missing archived redo logs Step3: Perform terminal recovery on the target standby Step4: convert the physical standby into a primary database Step5: Restart the new primary database in read/write mode Step6: Verify the new Primary Database Step7: Perform a full backup of the new primary database Step8: Flashing Back the Physical Standby Database - longyannode Step9: Using Flashback Database After a Failover 6.6 Flashing Back a Failed Primary into a Physical Standby Step1: Determine the SCN at which the old standby database became the primary database Step 2: Flash back the failed primary database Step 3: Convert the Failed Database to a Physical Standby Database Step 4: Shut down and restart the old primary database Step 5: Restart transporting redo to the new physical standby Step 6: Start Redo Apply Step 7: Restart Redo Apply on the new physical standby database if necessary Step 8: Verify the new primary and standby database 6.7 Perform a Switchback with xiamennode and shanghainode Step1: Verify the Switchover status on the Primary - xiamennode Step2: Convert the primary database into a physical standby database Step3: Shut down and restart the former primary as a new standby Step4: Query the SWITCHOVER_STATUS on the standby database Step5: Convert the former standby to a primary database Step6: Shutdown and restart the new primary database Step7: Start Redo Apply on the new physical standby - xiamennode Step8: Start Redo Apply on the physical standby - longyannode Step9: Verify the new primary and standby database
Views: 230 Yongcheng Lai
Oracle Redo log group status-  Simple Example
 
06:45
This video explains about the ORACLE REDO GROUP STATUS This has 4 status  Current  Active  In Active  Unused These 4 statuses will be cycled whether Database is in Archive mode or No Archive mode.
Views: 106 Ezylearning
Cluster Health Monitor
 
04:44
Cluster Health Monitor is a tool (formerly known as Instantaneous Problem Detector for Clusters or IPD/OS) is designed to detect and analyze operating system (OS) and cluster resource related degradation and failures in order to bring more explanatory power to many issues that occur in clusters where Oracle Clusterware and Oracle RAC are running such as node eviction. For more information on this course, please visit https://www.koenig-solutions.com/oracle-training-certification-courses.aspx
Views: 73 Koenig Solutions
Turn FLASHBACK DATABASE on & off while the Database stays OPEN
 
03:38
The clip demonstrates how to change FLASHBACK DATABASE without having to restart the instance. A text version is here: https://uhesse.com/2010/06/25/turning-flashback-database-on-off-with-instance-in-status-open/ The demo is done with 12c but the shown can be done with 11gR2 as well.
Oracle E-Business Suite Installation on Linux in Virtual Environment Part 01
 
43:00
Oracle E-Business Suite Installation on Linux in Virtual Environment Part 01
Views: 15281 Abbasi Asif
Backup Oracle Database using Oracle Enterprise Manager
 
04:02
Demo showing how to take Oracle Backup using Oracle Enterprise Manager
Views: 21425 Tamal Chatterjee
02.24_Oracle_10gR2_RACDG_2.24 Create a Cluster Database(2012_01_13).flv
 
01:19:49
Oracle 10g/11g RAC, DataGuard, GoldenGate,Streams Hands-on Practices Training. Please feel free to contact me: E-mail/Skype: [email protected] 1. Building an Oracle RAC 10gR2 for RAC Primary 1.1 Install Linux OS(CentOS 5.3) - () 1.2 Install Required Linux Packages for Oracle RAC- (Video) 1.3 Network Configuration - (Video) 1.4 Create "oracle" User and Directories - (Video) 1.5 Configure the Linux Servers for Oracle - (Video) 1.6 Configure the "hangcheck-timer" Kernel Module - (Video) 1.7 Configure RAC Nodes for Remote Access using SSH - (Video) 1.8 IP SAN Configuration - Openfiler - () 1.9 Install Openfiler - SAN - () 1.10 Configure iSCSI Volumes using openfiler - (Video) 1.11 Configure iSCSI Volumes on Oracle RAC Nodes - (Video) 1.12 Install and configure Oracle Cluster File System(OCFS2)- (Video) 1.13 Install and Configure ASM (ASMLib2.0) - (Video) 1.14 Download Oracle RAC 10g Software - (Video) 1.15 Pre-Installation Tasks for Oracle 10g Release 2- (Video) 1.16 Install Oracle Clusterware 10g - 10.2.0.1.0 - (Video) 1.17 Upgrade Oracle Clusterware from 10.2.0.1.0 to 10.2.0.3.0 - (Video) 1.18 Install and configure Automatic Storage Management (ASM) - (Video) 1.19 Apply the Patch Set 10.2.0.3.0 to the ASM Home - (Video) 1.20 Install Oracle Database 10gR2 Software - 10.2.0.1.0 - (Video) 1.21 Install Oracle Database 10g Companion CD Software - (Video) 1.22 Apply the Patch set 10.2.0.3.0 to Oracle Home - (Video) 1.23 Create TNS Listener Process - (Video) 1.24 Create ASM Instance - (Video) 1.25 Install the EM agent on each cluster node - (Video) 1.25.1 Pre-Installation Requirements - (Video) 1.25.2 Download Oracle Management Agent (10.2.0.5) - (Video) 1.25.3 Install Management Agent (10.2.0.5) in RAC Environment - (Video) 1.25.4 Verify Agent Status - (Video) 1.25.5 Secure the Management Agent if necessary - (Video) 1.26 Create a Cluster Database - (Video) 1.27 Post-Installation Tasks - (Optional) - (Video) 1.27.1 Re-compile Invalid Objects - (Video) 1.27.2 Enabling Archive Logs and Flashback in a RAC Environment - (Video) 1.27.3 Create Shared Oracle Password Files - (Video) 1.28 Verify TNS Networking Files - (Video) 1.29 Create / Alter Tablespaces - () 1.30 Verify the RAC Cluster & Database Configuration - (Video) 1.31 Configuring the Initialization Parameters - (Video) 1.32 Startup / Shutdown the Oracle RAC 10gR2 - (Video) 1.32.1 Stopping the Oracle RAC 10g Environment - (Video) 1.32.2 Start Monitor the alert.log - () 1.32.3 Start the Oracle RAC 10g - () 2. Building an Oracle RAC 10gR2 for RAC Standby 2.1 Install Linux OS(CentOS 5.3) - () 2.2 Install Required Linux Packages for Oracle RAC - (Video) 2.3 Network Configuration - (Video) 2.4 Create "oracle" User and Directories - (Video) 2.5 Configure the Linux Servers for Oracle - (Video) 2.6 Configure the "hangcheck-timer" Kernel Module - (Video) 2.7 Configure RAC Nodes for Remote Access using SSH - (Video) 2.8 Configure iSCSI Volumes using openfiler - (Video) 2.9 Configure iSCSI Volumes on Oracle RAC Nodes - (Video) 2.10 Install and configure Oracle Cluster File System(OCFS2) - (Video) 2.11 Install and Configure ASM (ASMLib2.0) - (Video) 2.12 Download Oracle RAC 10g Software - (Video) 2.13 Pre-Installation Tasks for Oracle 10g Release 2 - (Video) 2.14 Install Oracle Clusterware 10g - 10.2.0.1.0 - (Video) 2.15 Upgrade Oracle Clusterware from 10.2.0.1.0 to 10.2.0.3.0 - (Video) 2.16 Install and configure Automatic Storage Management (ASM) - (Video) 2.17 Apply the Patch Set 10.2.0.3.0 to the ASM Home - (Video) 2.18 Install Oracle Database 10gR2 Software - 10.2.0.1.0 - (Video) 2.19 Install Oracle Database 10g Companion CD Software - (Video) 2.20 Apply the Patch set 10.2.0.3.0 to Oracle Home - (Video) 2.21 Create TNS Listener Process - (Video) 2.22 Create ASM Instance - (Video) 2.23 Install the EM agent on each cluster node - (Video) 2.23.1 Pre-Installation Requirements - (Video) 2.23.2 Download Oracle Management Agent (10.2.0.5) - (Video) 2.23.3 Install Management Agent (10.2.0.5) in RAC Environment - (Video) 2.23.4 Verify Agent Status - () 2.23.5 Secure the Management Agent if necessary - () 2.24 Create a Cluster Database - (Video) 2.25 Post-Installation Tasks - (Optional) - (Video) 2.25.1 Re-compile Invalid Objects - (Video) 2.25.2 Enabling Archive Logs and Flashback in a RAC Environment - (Video) 2.25.3 Create Shared Oracle Password Files - (Video) 2.26 Verify TNS Networking Files - (Video) 2.27 Create / Alter Tablespaces - () 2.28 Verify the RAC Cluster & Database Configuration - (Video) 2.29 Configuring the Initialization Parameters - (Video) 2.30 Startup / Shutdown the Oracle RAC 10gR2 - ()
Views: 611 Yongcheng Lai
Oracle Enterprise Manager: Always-On Monitoring
 
25:23
The Enterprise Manager Always-On Monitoring application provides the ability to monitor critical target status and metric alerts when the Oracle Management Service is unavailable. The service continuously monitors critical targets through the Enterprise Manager Agent and can be easily configured to send email notifications for these events to administrators. See Enterprise manager online documentation for more information: http://docs.oracle.com/cd/E73210_01/EMADM/GUID-3152AD33-8118-4478-B888-A332CFAB3453.htm#EMADM15489 ================================= To improve the video quality, click the gear icon and set the Quality to 1080p/720p HD. For more information, see http://www.oracle.com/goto/oll Copyright © 2016 Oracle and/or its affiliates. Oracle is a registered trademark of Oracle and/or its affiliates. All rights reserved. Other names may be registered trademarks of their respective owners. Oracle disclaims any warranties or representations as to the accuracy or completeness of this recording, demonstration, and/or written materials (the “Materials”). The Materials are provided “as is” without any warranty of any kind, either express or implied, including without limitation warranties or merchantability, fitness for a particular purpose, and non-infringement.
Standby Servers Lesson 13.3
 
05:14
Chapter13.High Availability
Views: 318 PrasadBadana
Oracle 11g how to start and stop the listener
 
01:08
How to show the status of the listener, start and stop it. More : http://database-school.com/
Views: 17062 jeremjerem
How to Set Up MySQL Replication
 
03:08
In this easy step by step tutorial, you will learn how to replicate the contents of MySQL database. Don't forget to check out our site http://howtech.tv/ for more free how-to videos! http://youtube.com/ithowtovids - our feed http://www.Facebook.com/howtechtv - join us on Facebook https://plus.google.com/103440382717658277879 - our group in Google+ Introduction MySQL Replication basically allows the contents of the master database server in MySQL to be replicated to other database servers. In this tutorial we will show you how to set up MySQL replication through phpMyAdmin. Step#1: Getting Started with Replication To get started, first of all, log in to your php my admin panel, and then click on the Replication tab on the top. Step#2: Replication Plan From there, click on the Configure option, under the Master Replication section. With that done, the master configuration section will expand, having a list of databases and a replication plan as well. Step#3: Create new Database Here, you can either Replicate All databases while ignoring the ones selected, or the other way round, that is, ignore all the databases and replicate the ones which would be selected. Let's choose the second plan and then select the database named "test" over here. With that done, copy the lines shown below the list. These have to be added in the MySQL "my.ini" file. Step#4: MY.INI File Since we are using the XAMPP server, the "my.ini" file can be fetched by clicking on the Config button and choosing the "my.ini" option against the MySQL Module. Step#5: Setting up MY.INI File Once the file opens up, navigate to the "log_error" parameter, and just paste the copied lines beneath that. With that done, change the "max allowed packet" size to 16 MB. Once you are done with that, scroll down the file and comment out the "server-id" parameter with a hash sign. When you are done with that, save the file and then restart the services of both Mysql and Apache. Step#6: Master Replication Setup After that, switch back to your phpMyAdmin page, and hit the F5 key to refresh the panel. With that done, move over to the Replication tab again. There you will find that the Master Replication has been set up successfully. You can click on the Show Master Status option to see its status. Now, click on the Add Slave Replication user option to add a Replication user Step#7: Creating Replication User Specify the username and the host, and then click on the Go button. A replication user would be added as a result. Step#8: Slave Replication Setup Now open up the Replication tab again, and click on the Configure option under the Slave Replication section. Another page will open up, and from here, copy the Server id which has to be pasted in the "my.ini" file. So let's open up the "my.ini" file again and locate the "server-id " parameter which we had commented earlier. Over here, simply paste the Server id copied from the Slave configuration, save the file and restart the MySQL services. Step#9: Updating Slave Configuration Now switch back to the Slave Replication page again, and specify the user details which were created before. With that done, click on the Go button. A message will appear that the Master server had changed successfully. Step#10: Warning Messages Now, if you open the Replication tab once more, you will notice two warning messages appearing in the Slave Replication portion. One would be regarding the Slave SQL Thread and the other would be regarding the Slave IO Thread, both of which won't be running. To resolve these errors, simply click on the Control Slave option, and Start these threads one after another. You will notice that the warning messages would disappear. Step#11: Verifying Replicated database Now click on the Databases tab and here you can see that the test database has been replicated successfully. This means that we have setup and configured MySQL replication. And this is how to set up MySQL replication using phpMyAdmin.
HOW TO INCREASE DECREASE MEMORY TARGET IN ORACLE 11G
 
04:55
How to increase/decrease memory_target in 11g ====================================================== oracle 10g --sga_target (parameter new in 10g) oracle 11g --memory_target (parameter new in 11g) How to check whether the parameter is static or dynamic? ========================================================= select name, value, issys_modifiable from v$parameter where name like '%&parameter%' ; if issys_modifiable=false --- parameter is static (database bounce required) if issys_modifiable=immediate --- parameter is dynamic (database bounce not required) (note: consider using spfile) sql commands ================ show parameter memory; alter system set memory_target=350m scope=spfile; alter system set memory_max_target=350m scope=spfile;
Views: 4341 Praveen Biyyapu
06.03 Oracle_10gR2_DataGuard_6.3 Perform a Switchover with shanghainode and longyannode.avi
 
12:42
Oracle 10g/11g RAC, DataGuard, GoldenGate,Streams Hands-on Practices Training. Please feel free to contact me: E-mail/Skype: [email protected] Oracle Database 10gR2 High Availability with Data Guard on Linux http://www.youtube.com/playlist?list=PLCEC4947864F3B571 6. Role Transition - Physical Standby Database 6.1 Perform a Switchover with shanghainode and xiamennode Step 1: Verify the Switchover status on the Primary - shanghainode Step 2: Convert the primary database into a physical standby database Step 3: Shut down and restart the former primary as a new standby Step 4: Query the SWITCHOVER_STATUS on the standby database Step 5: Convert the former standby to a primary database Step 6: Shutdown and restart the new primary database Step 7: Start Redo Apply on the new physical standby - shanghainode Step 8: Start Redo Apply on the physical standby - longyannode Step 9: Verify the new primary and standby database 6.2 Perform a Switchback with xiamennode and shanghainode Step 1: Verify the Switchover status on the Primary - xiamennode Step 2: Convert the primary database into a physical standby database Step 3: Shut down and restart the former primary as a new standby Step 4: Query the SWITCHOVER_STATUS on the standby database Step 5: Convert the former standby to a primary database Step 6: Shutdown and restart the new primary database Step 7: Start Redo Apply on the new physical standby - xiamennode Step 8: Start Redo Apply on the physical standby - longyannode Step9: Verify the new primary and standby database 6.3 Perform a Switchover with shanghainode and longyannode Step 1: Verify the Switchover status on the Primary - shanghainode Step 2: Convert the primary database into a physical standby database Step 3: Shut down and restart the former primary as a new standby Step 4: Query the SWITCHOVER_STATUS on the standby database Step 5: Convert the standby to a primary database Step 6: Shutdown and restart the new primary database Step 7: Start Redo Apply on the new physical standby - shanghainode Step 8: Start Redo Apply on the physical standby - xiamennode Step 9: Verify the new primary and standby database 6.4 Perform a Switchback with longyannode and shanghainode Step 1: Verify the Switchover status on the Primary - shanghainode Step 2: Convert the primary database into a physical standby database Step 3: Shut down and restart the former primary as a new standby Step 4: Query the SWITCHOVER_STATUS on the standby database Step 5: Convert the former standby to a primary database Step 6: Shutdown and restart the new primary database Step 7: Start Redo Apply on the new physical standby - longyannode Step 8: Start Redo Apply on the physical standby - xiamennode Step 9: Verify the new primary and standby database 6.5 Perform a Failover to the Physical Standby - xiamennode Step1: Identify and resolve any archive log gaps Step2: Copy and register any other missing archived redo logs Step3: Perform terminal recovery on the target standby Step4: convert the physical standby into a primary database Step5: Restart the new primary database in read/write mode Step6: Verify the new Primary Database Step7: Perform a full backup of the new primary database Step8: Flashing Back the Physical Standby Database - longyannode Step9: Using Flashback Database After a Failover 6.6 Flashing Back a Failed Primary into a Physical Standby Step1: Determine the SCN at which the old standby database became the primary database Step 2: Flash back the failed primary database Step 3: Convert the Failed Database to a Physical Standby Database Step 4: Shut down and restart the old primary database Step 5: Restart transporting redo to the new physical standby Step 6: Start Redo Apply Step 7: Restart Redo Apply on the new physical standby database if necessary Step 8: Verify the new primary and standby database 6.7 Perform a Switchback with xiamennode and shanghainode
Views: 212 Yongcheng Lai
02.15_Oracle_10gR2_RACDG_2.15 Upgrade Oracle Clusterware
 
09:15
Oracle 10g/11g RAC, DataGuard, GoldenGate,Streams Hands-on Practices Training. Please feel free to contact me: E-mail/Skype: [email protected] 1. Building an Oracle RAC 10gR2 for RAC Primary 1.1 Install Linux OS(CentOS 5.3) - () 1.2 Install Required Linux Packages for Oracle RAC- (Video) 1.3 Network Configuration - (Video) 1.4 Create "oracle" User and Directories - (Video) 1.5 Configure the Linux Servers for Oracle - (Video) 1.6 Configure the "hangcheck-timer" Kernel Module - (Video) 1.7 Configure RAC Nodes for Remote Access using SSH - (Video) 1.8 IP SAN Configuration - Openfiler - () 1.9 Install Openfiler - SAN - () 1.10 Configure iSCSI Volumes using openfiler - (Video) 1.11 Configure iSCSI Volumes on Oracle RAC Nodes - (Video) 1.12 Install and configure Oracle Cluster File System(OCFS2)- (Video) 1.13 Install and Configure ASM (ASMLib2.0) - (Video) 1.14 Download Oracle RAC 10g Software - (Video) 1.15 Pre-Installation Tasks for Oracle 10g Release 2- (Video) 1.16 Install Oracle Clusterware 10g - 10.2.0.1.0 - (Video) 1.17 Upgrade Oracle Clusterware from 10.2.0.1.0 to 10.2.0.3.0 - (Video) 1.18 Install and configure Automatic Storage Management (ASM) - (Video) 1.19 Apply the Patch Set 10.2.0.3.0 to the ASM Home - (Video) 1.20 Install Oracle Database 10gR2 Software - 10.2.0.1.0 - (Video) 1.21 Install Oracle Database 10g Companion CD Software - (Video) 1.22 Apply the Patch set 10.2.0.3.0 to Oracle Home - (Video) 1.23 Create TNS Listener Process - (Video) 1.24 Create ASM Instance - (Video) 1.25 Install the EM agent on each cluster node - (Video) 1.25.1 Pre-Installation Requirements - (Video) 1.25.2 Download Oracle Management Agent (10.2.0.5) - (Video) 1.25.3 Install Management Agent (10.2.0.5) in RAC Environment - (Video) 1.25.4 Verify Agent Status - (Video) 1.25.5 Secure the Management Agent if necessary - (Video) 1.26 Create a Cluster Database - (Video) 1.27 Post-Installation Tasks - (Optional) - (Video) 1.27.1 Re-compile Invalid Objects - (Video) 1.27.2 Enabling Archive Logs and Flashback in a RAC Environment - (Video) 1.27.3 Create Shared Oracle Password Files - (Video) 1.28 Verify TNS Networking Files - (Video) 1.29 Create / Alter Tablespaces - () 1.30 Verify the RAC Cluster & Database Configuration - (Video) 1.31 Configuring the Initialization Parameters - (Video) 1.32 Startup / Shutdown the Oracle RAC 10gR2 - (Video) 1.32.1 Stopping the Oracle RAC 10g Environment - (Video) 1.32.2 Start Monitor the alert.log - () 1.32.3 Start the Oracle RAC 10g - () 2. Building an Oracle RAC 10gR2 for RAC Standby 2.1 Install Linux OS(CentOS 5.3) - () 2.2 Install Required Linux Packages for Oracle RAC - (Video) 2.3 Network Configuration - (Video) 2.4 Create "oracle" User and Directories - (Video) 2.5 Configure the Linux Servers for Oracle - (Video) 2.6 Configure the "hangcheck-timer" Kernel Module - (Video) 2.7 Configure RAC Nodes for Remote Access using SSH - (Video) 2.8 Configure iSCSI Volumes using openfiler - (Video) 2.9 Configure iSCSI Volumes on Oracle RAC Nodes - (Video) 2.10 Install and configure Oracle Cluster File System(OCFS2) - (Video) 2.11 Install and Configure ASM (ASMLib2.0) - (Video) 2.12 Download Oracle RAC 10g Software - (Video) 2.13 Pre-Installation Tasks for Oracle 10g Release 2 - (Video) 2.14 Install Oracle Clusterware 10g - 10.2.0.1.0 - (Video) 2.15 Upgrade Oracle Clusterware from 10.2.0.1.0 to 10.2.0.3.0 - (Video) 2.16 Install and configure Automatic Storage Management (ASM) - (Video) 2.17 Apply the Patch Set 10.2.0.3.0 to the ASM Home - (Video) 2.18 Install Oracle Database 10gR2 Software - 10.2.0.1.0 - (Video) 2.19 Install Oracle Database 10g Companion CD Software - (Video) 2.20 Apply the Patch set 10.2.0.3.0 to Oracle Home - (Video) 2.21 Create TNS Listener Process - (Video) 2.22 Create ASM Instance - (Video) 2.23 Install the EM agent on each cluster node - (Video) 2.23.1 Pre-Installation Requirements - (Video) 2.23.2 Download Oracle Management Agent (10.2.0.5) - (Video) 2.23.3 Install Management Agent (10.2.0.5) in RAC Environment - (Video) 2.23.4 Verify Agent Status - () 2.23.5 Secure the Management Agent if necessary - () 2.24 Create a Cluster Database - (Video) 2.25 Post-Installation Tasks - (Optional) - (Video) 2.25.1 Re-compile Invalid Objects - (Video) 2.25.2 Enabling Archive Logs and Flashback in a RAC Environment - (Video) 2.25.3 Create Shared Oracle Password Files - (Video) 2.26 Verify TNS Networking Files - (Video) 2.27 Create / Alter Tablespaces - () 2.28 Verify the RAC Cluster & Database Configuration - (Video) 2.29 Configuring the Initialization Parameters - (Video) 2.30 Startup / Shutdown the Oracle RAC 10gR2 - ()
Views: 270 Yongcheng Lai
FIX :ORA-01017: invalid username/password; logon denied
 
03:49
copy and paste - sqlplus "/as sysdba" COPY PASTE BELOW LINE ALTER USER user_name IDENTIFIED BY new_password; ** user_name - example SYSTEM new_password - ENTER NEW PASSWORD Blog - maheshkarandeprojects.wordpress.com MUSIC : You're free to use this song and monetize your video, but you must include the following in your video description: Essence by Audionautix is licensed under a Creative Commons Attribution license (https://creativecommons.org/licenses/by/4.0/) Artist: http://audionautix.com/ Keywords: ora-01017 invalid username/password logon denied,ora-01017 invalid username/password logon denied 12c,ora-01017 invalid username/password logon denied oracle 12c,ora-01017 invalid username/password logon denied sap,ora-01017 invalid username/password logon denied ora-02063 preceding line from,ora-01017 invalid username/password logon denied rman,ora-01017 invalid username/password logon denied oracle 10g,ora-01017 invalid username/password logon denied standby database,ora-01017 invalid username/password logon denied (dbd error ocisessionbegin),ora-01017 invalid username/password logon denied dblink,ora-01017 invalid username/password logon denied brtools,ora-01017 invalid username/password logon denied brconnect,ora-01017 invalid username/password logon denied brbackup,ora-01017 invalid username/password logon denied bi publisher,ora-01017 invalid username/password logon denied burleson,ora-01017 invalid username/password logon denied sap backup,br0301e ora-01017 invalid username/password logon denied,log by0= ora-01017 invalid username/password logon denied,sap brtools ora-01017 invalid username/password logon denied,dg broker ora-01017 invalid username/password logon denied,ora-01017 invalid username/password logon denied c#,ora-01017 invalid username/password logon denied change password,ora-01017 invalid username/password logon denied connection string,ora-01017 invalid username/password logon denied cloud control,ora-01017 invalid username/password logon denied config tool,ora-01017 invalid username/password logon denied the connect descriptor was,ora-01017 invalid username/password logon denied oracle client,ora 01017 invalid username password logon denied error code 1017,ora-01017 invalid username/password logon denied system copy,ora-01017 invalid username/password logon denied at oci call ocisessionbegin,ora-01017 invalid username/password logon denied dgmgrl,ora-01017 invalid username/password logon denied db13,ora-01017 invalid username/password logon denied during switchover,data guard ora-01017 invalid username/password logon denied,ora-01017 invalid username/password logon denied discoverer,ora-01017 invalid username/password logon denied dbca,ora-01017 invalid username/password logon denied dbsnmp,ora-01017 invalid username/password logon denied switchover data guard,ora 01017 invalid username password logon denied enterprise manager,ora-01017 invalid username/password logon denied external user,ora-01017 invalid username/password logon denied emca,ora-01017 invalid username/password logon denied expdp,ora-01017 invalid username/password logon denied error,ora-01017 invalid username/password logon denied expired,ora 01017 invalid username password logon denied identified externally,ora-01017 invalid username/password logon denied in eclipse,ora-01017 invalid username/password logon denied for sys user,ora-01017 invalid username/password logon denied for sys,ora-01017 invalid username/password logon denied forms,ora-01017 invalid username/password logon denied for dblink,ora 01017 invalid username password logon denied oracle forms,failed ora-01017 invalid username/password logon denied,test failed ora-01017 invalid username/password logon denied jdeveloper,authentication failed ora-01017 invalid username/password logon denied,brconnect failed ora-01017 invalid username/password logon denied,failure test failed ora 01017 invalid username password logon denied,ora-01017 invalid username/password logon denied data guard,error ora-01017 invalid username/password logon denied dataguard,glassfish ora-01017 invalid username/password logon denied,oracle data guard ora-01017 invalid username/password logon denied,data guard switchover ora-01017 invalid username/password logon denied,ora-01017 invalid username/password logon denied hibernate,ora-01017 invalid username/password logon denied hr,how to resolve ora-01017 invalid username/password logon denied,how to solve ora-01017 invalid username/password logon denied,ora-28001 the password has expired ora-01017 invalid username/password logon denied,ora-01017 invalid username/password logon denied in 12c,ora-01017 invalid username/password logon denied in sql developer,ora-01017 invalid username/password logon denied in sap,ora-01017 invalid
Views: 8386 Mahesh Karande
Migration from Non-Container to PDB database-PART I- Oracle 12C Administration
 
09:30
Non-Container Name =NCDB convert to PDB-NCDB Container DB Name=CDB =========================== Steps for Conversion. Step 1. Cleanly Shutdown the Non-CDB Database Instance. ==- set environment to NCDB ==- sqlplus / as sysdba ==- Shutdown immediate Step 2. Once You Have Cleanly Shutdown the Database, Start Up the database in Mount Exclusive Mode and Open the Database in Read-Only Mode. ==- set environment to NCDB ==- sqlplus / as sysdba ==- startup mount exclusive ==- alter database open read only; Step 3. Generate a Pluggable Database Manifest File from the Non-Container Database. ==- set environment to NCDB ==- sqlplus / as sysdba ==- exec dbms_pdb.describe (pdb_descr_file=-'E:\app\oracle\manifest\NCDB_manifest_file.xml'); Step 4. Shutdown the NON-CDB file Once Step 3 Completes Successfully. ==- Set environment to NCDB ==- sqlplus / as sysdba ==- shutdown immediate Step 5. Start the CDB (CDB) if it’s Not Already Up and Check the Compatibility with CDB. ==- set environment to CDB ==- sqlplus / as sysdba ==- startup (If not up) ==- Run below at SQL prompt. SET SERVEROUTPUT ON; DECLARE Compatible CONSTANT VARCHAR2(3) :=CASE DBMS_PDB.CHECK_PLUG_COMPATIBILITY (pdb_descr_file =- 'E:\app\oracle\manifest\NCDB_manifest_file.xml') WHEN TRUE THEN 'YES' ELSE 'NO' END; BEGIN DBMS_OUTPUT.PUT_LINE(compatible); END; / Step 6. Once it Completes Successfully, Query PDB_PLUG_IN_VIOLATIONS View from CDB Database for Any Errors. ==- set environment to CDB ==- sqlplus / as sysdba ==- select name, cause, type, message, status from PDB_PLUG_IN_VIOLATIONS where name='NCDB'; Note: "There should be no violations reported. If there are any, you need to fix it before proceeding". Step 7. Connect to the CDB Where Database has to be Plugged in Using the Noncdb Manifest File and Plug the PDDB12C Database. ==- set environment to CDB ==- sqlplus / as sysdba ==- CREATE PLUGGABLE DATABASE NCDB USING 'E:\app\oracle\manifest\NCDB_manifest_file.xml' COPY FILE_NAME_CONVERT = ('E:\APP\ORACLE\ORADATA\NCDB\', 'E:\app\oracle\oradata\CDB1\'); Note: "Below options are supported and you can chose one based on the env" 1) COPY: The datafiles of noncdb remains intact and it is copied to create PDBs at new locations and keep original datafiles intact at the original location. (This would mean that a noncdb database would still be operational after the creation of a PDB). 2) MOVE: The datafiles of noncdb are moved to a new location to create a PDB. In this case, noncdb database would not be available after a PDB is created. NOCOPY: The datafiles of noncdb are used to create a PDB2 and it uses same existing location. In this case, a noncdb database would not be available after a PDB is created. You can use FILE_NAME_CONVERT parameter to specify the new location of the datafiles while using COPY or MOVE option. Step 8. Once Step 7 Completes Successfully, Switch to the PDB Container and Run the "$ORACLE_HOME/rdbms/admin/noncdb_to_pdb.sql". ==- set environment to CDB ==- sqlplus / as sysdba ==- alter session set container=NCDB ==- @$ORACLE_HOME/rdbms/admin/noncdb_to_pdb.sql Step 9. Startup the PDB and Check the Open Mode. ==- set environment to CDB ==- sqlplus / as sysdba ==- ALTER PLUGGABLE DATABASE OPEN; ==-SELECT name, open_mode FROM v$pdbs;
Views: 601 ANKUSH THAVALI
02.23.02_Oracle_10gR2_RACDG_2.23.2 Download Oracle Management Agent (10.2.0.5)(2012_01_13).flv
 
01:41
Oracle 10g/11g RAC, DataGuard, GoldenGate,Streams Hands-on Practices Training. Please feel free to contact me: E-mail/Skype: [email protected] 1. Building an Oracle RAC 10gR2 for RAC Primary 1.1 Install Linux OS(CentOS 5.3) - () 1.2 Install Required Linux Packages for Oracle RAC- (Video) 1.3 Network Configuration - (Video) 1.4 Create "oracle" User and Directories - (Video) 1.5 Configure the Linux Servers for Oracle - (Video) 1.6 Configure the "hangcheck-timer" Kernel Module - (Video) 1.7 Configure RAC Nodes for Remote Access using SSH - (Video) 1.8 IP SAN Configuration - Openfiler - () 1.9 Install Openfiler - SAN - () 1.10 Configure iSCSI Volumes using openfiler - (Video) 1.11 Configure iSCSI Volumes on Oracle RAC Nodes - (Video) 1.12 Install and configure Oracle Cluster File System(OCFS2)- (Video) 1.13 Install and Configure ASM (ASMLib2.0) - (Video) 1.14 Download Oracle RAC 10g Software - (Video) 1.15 Pre-Installation Tasks for Oracle 10g Release 2- (Video) 1.16 Install Oracle Clusterware 10g - 10.2.0.1.0 - (Video) 1.17 Upgrade Oracle Clusterware from 10.2.0.1.0 to 10.2.0.3.0 - (Video) 1.18 Install and configure Automatic Storage Management (ASM) - (Video) 1.19 Apply the Patch Set 10.2.0.3.0 to the ASM Home - (Video) 1.20 Install Oracle Database 10gR2 Software - 10.2.0.1.0 - (Video) 1.21 Install Oracle Database 10g Companion CD Software - (Video) 1.22 Apply the Patch set 10.2.0.3.0 to Oracle Home - (Video) 1.23 Create TNS Listener Process - (Video) 1.24 Create ASM Instance - (Video) 1.25 Install the EM agent on each cluster node - (Video) 1.25.1 Pre-Installation Requirements - (Video) 1.25.2 Download Oracle Management Agent (10.2.0.5) - (Video) 1.25.3 Install Management Agent (10.2.0.5) in RAC Environment - (Video) 1.25.4 Verify Agent Status - (Video) 1.25.5 Secure the Management Agent if necessary - (Video) 1.26 Create a Cluster Database - (Video) 1.27 Post-Installation Tasks - (Optional) - (Video) 1.27.1 Re-compile Invalid Objects - (Video) 1.27.2 Enabling Archive Logs and Flashback in a RAC Environment - (Video) 1.27.3 Create Shared Oracle Password Files - (Video) 1.28 Verify TNS Networking Files - (Video) 1.29 Create / Alter Tablespaces - () 1.30 Verify the RAC Cluster & Database Configuration - (Video) 1.31 Configuring the Initialization Parameters - (Video) 1.32 Startup / Shutdown the Oracle RAC 10gR2 - (Video) 1.32.1 Stopping the Oracle RAC 10g Environment - (Video) 1.32.2 Start Monitor the alert.log - () 1.32.3 Start the Oracle RAC 10g - () 2. Building an Oracle RAC 10gR2 for RAC Standby 2.1 Install Linux OS(CentOS 5.3) - () 2.2 Install Required Linux Packages for Oracle RAC - (Video) 2.3 Network Configuration - (Video) 2.4 Create "oracle" User and Directories - (Video) 2.5 Configure the Linux Servers for Oracle - (Video) 2.6 Configure the "hangcheck-timer" Kernel Module - (Video) 2.7 Configure RAC Nodes for Remote Access using SSH - (Video) 2.8 Configure iSCSI Volumes using openfiler - (Video) 2.9 Configure iSCSI Volumes on Oracle RAC Nodes - (Video) 2.10 Install and configure Oracle Cluster File System(OCFS2) - (Video) 2.11 Install and Configure ASM (ASMLib2.0) - (Video) 2.12 Download Oracle RAC 10g Software - (Video) 2.13 Pre-Installation Tasks for Oracle 10g Release 2 - (Video) 2.14 Install Oracle Clusterware 10g - 10.2.0.1.0 - (Video) 2.15 Upgrade Oracle Clusterware from 10.2.0.1.0 to 10.2.0.3.0 - (Video) 2.16 Install and configure Automatic Storage Management (ASM) - (Video) 2.17 Apply the Patch Set 10.2.0.3.0 to the ASM Home - (Video) 2.18 Install Oracle Database 10gR2 Software - 10.2.0.1.0 - (Video) 2.19 Install Oracle Database 10g Companion CD Software - (Video) 2.20 Apply the Patch set 10.2.0.3.0 to Oracle Home - (Video) 2.21 Create TNS Listener Process - (Video) 2.22 Create ASM Instance - (Video) 2.23 Install the EM agent on each cluster node - (Video) 2.23.1 Pre-Installation Requirements - (Video) 2.23.2 Download Oracle Management Agent (10.2.0.5) - (Video) 2.23.3 Install Management Agent (10.2.0.5) in RAC Environment - (Video) 2.23.4 Verify Agent Status - () 2.23.5 Secure the Management Agent if necessary - () 2.24 Create a Cluster Database - (Video) 2.25 Post-Installation Tasks - (Optional) - (Video) 2.25.1 Re-compile Invalid Objects - (Video) 2.25.2 Enabling Archive Logs and Flashback in a RAC Environment - (Video) 2.25.3 Create Shared Oracle Password Files - (Video) 2.26 Verify TNS Networking Files - (Video) 2.27 Create / Alter Tablespaces - () 2.28 Verify the RAC Cluster & Database Configuration - (Video) 2.29 Configuring the Initialization Parameters - (Video) 2.30 Startup / Shutdown the Oracle RAC 10gR2 - ()
Views: 218 Yongcheng Lai
Oracle Database Online Patching
 
05:58
Oracle Database Online Patching
Views: 1511 The Silent DBA
02.25.02_Oracle_10gR2_RACDG_2.25.2 Enabling Archive Logs and Flashback in a RAC
 
05:56
Oracle 10g/11g RAC, DataGuard, GoldenGate,Streams Hands-on Practices Training. Please feel free to contact me: E-mail/Skype: [email protected] 1. Building an Oracle RAC 10gR2 for RAC Primary 1.1 Install Linux OS(CentOS 5.3) - () 1.2 Install Required Linux Packages for Oracle RAC- (Video) 1.3 Network Configuration - (Video) 1.4 Create "oracle" User and Directories - (Video) 1.5 Configure the Linux Servers for Oracle - (Video) 1.6 Configure the "hangcheck-timer" Kernel Module - (Video) 1.7 Configure RAC Nodes for Remote Access using SSH - (Video) 1.8 IP SAN Configuration - Openfiler - () 1.9 Install Openfiler - SAN - () 1.10 Configure iSCSI Volumes using openfiler - (Video) 1.11 Configure iSCSI Volumes on Oracle RAC Nodes - (Video) 1.12 Install and configure Oracle Cluster File System(OCFS2)- (Video) 1.13 Install and Configure ASM (ASMLib2.0) - (Video) 1.14 Download Oracle RAC 10g Software - (Video) 1.15 Pre-Installation Tasks for Oracle 10g Release 2- (Video) 1.16 Install Oracle Clusterware 10g - 10.2.0.1.0 - (Video) 1.17 Upgrade Oracle Clusterware from 10.2.0.1.0 to 10.2.0.3.0 - (Video) 1.18 Install and configure Automatic Storage Management (ASM) - (Video) 1.19 Apply the Patch Set 10.2.0.3.0 to the ASM Home - (Video) 1.20 Install Oracle Database 10gR2 Software - 10.2.0.1.0 - (Video) 1.21 Install Oracle Database 10g Companion CD Software - (Video) 1.22 Apply the Patch set 10.2.0.3.0 to Oracle Home - (Video) 1.23 Create TNS Listener Process - (Video) 1.24 Create ASM Instance - (Video) 1.25 Install the EM agent on each cluster node - (Video) 1.25.1 Pre-Installation Requirements - (Video) 1.25.2 Download Oracle Management Agent (10.2.0.5) - (Video) 1.25.3 Install Management Agent (10.2.0.5) in RAC Environment - (Video) 1.25.4 Verify Agent Status - (Video) 1.25.5 Secure the Management Agent if necessary - (Video) 1.26 Create a Cluster Database - (Video) 1.27 Post-Installation Tasks - (Optional) - (Video) 1.27.1 Re-compile Invalid Objects - (Video) 1.27.2 Enabling Archive Logs and Flashback in a RAC Environment - (Video) 1.27.3 Create Shared Oracle Password Files - (Video) 1.28 Verify TNS Networking Files - (Video) 1.29 Create / Alter Tablespaces - () 1.30 Verify the RAC Cluster & Database Configuration - (Video) 1.31 Configuring the Initialization Parameters - (Video) 1.32 Startup / Shutdown the Oracle RAC 10gR2 - (Video) 1.32.1 Stopping the Oracle RAC 10g Environment - (Video) 1.32.2 Start Monitor the alert.log - () 1.32.3 Start the Oracle RAC 10g - () 2. Building an Oracle RAC 10gR2 for RAC Standby 2.1 Install Linux OS(CentOS 5.3) - () 2.2 Install Required Linux Packages for Oracle RAC - (Video) 2.3 Network Configuration - (Video) 2.4 Create "oracle" User and Directories - (Video) 2.5 Configure the Linux Servers for Oracle - (Video) 2.6 Configure the "hangcheck-timer" Kernel Module - (Video) 2.7 Configure RAC Nodes for Remote Access using SSH - (Video) 2.8 Configure iSCSI Volumes using openfiler - (Video) 2.9 Configure iSCSI Volumes on Oracle RAC Nodes - (Video) 2.10 Install and configure Oracle Cluster File System(OCFS2) - (Video) 2.11 Install and Configure ASM (ASMLib2.0) - (Video) 2.12 Download Oracle RAC 10g Software - (Video) 2.13 Pre-Installation Tasks for Oracle 10g Release 2 - (Video) 2.14 Install Oracle Clusterware 10g - 10.2.0.1.0 - (Video) 2.15 Upgrade Oracle Clusterware from 10.2.0.1.0 to 10.2.0.3.0 - (Video) 2.16 Install and configure Automatic Storage Management (ASM) - (Video) 2.17 Apply the Patch Set 10.2.0.3.0 to the ASM Home - (Video) 2.18 Install Oracle Database 10gR2 Software - 10.2.0.1.0 - (Video) 2.19 Install Oracle Database 10g Companion CD Software - (Video) 2.20 Apply the Patch set 10.2.0.3.0 to Oracle Home - (Video) 2.21 Create TNS Listener Process - (Video) 2.22 Create ASM Instance - (Video) 2.23 Install the EM agent on each cluster node - (Video) 2.23.1 Pre-Installation Requirements - (Video) 2.23.2 Download Oracle Management Agent (10.2.0.5) - (Video) 2.23.3 Install Management Agent (10.2.0.5) in RAC Environment - (Video) 2.23.4 Verify Agent Status - () 2.23.5 Secure the Management Agent if necessary - () 2.24 Create a Cluster Database - (Video) 2.25 Post-Installation Tasks - (Optional) - (Video) 2.25.1 Re-compile Invalid Objects - (Video) 2.25.2 Enabling Archive Logs and Flashback in a RAC Environment - (Video) 2.25.3 Create Shared Oracle Password Files - (Video) 2.26 Verify TNS Networking Files - (Video) 2.27 Create / Alter Tablespaces - () 2.28 Verify the RAC Cluster & Database Configuration - (Video) 2.29 Configuring the Initialization Parameters - (Video) 2.30 Startup / Shutdown the Oracle RAC 10gR2 - ()
Views: 247 Yongcheng Lai
Process to check alert log in oracle
 
02:25
Here is a simple procedure by which you can checkout aleart log . regards, Pushpak Pattewar
Views: 9665 Pushpak Pattewar
Migration of  Non-Container Database to Pluggable-PART II- Oracle 12C Administration
 
37:16
Non-Container Name =NCDB convert to PDB-NCDB Container DB Name=CDB =========================== Steps for Conversion. Step 1. Cleanly Shutdown the Non-CDB Database Instance. ==- set environment to NCDB ==- sqlplus / as sysdba ==- Shutdown immediate Step 2. Once You Have Cleanly Shutdown the Database, Start Up the database in Mount Exclusive Mode and Open the Database in Read-Only Mode. ==- set environment to NCDB ==- sqlplus / as sysdba ==- startup mount exclusive ==- alter database open read only; Step 3. Generate a Pluggable Database Manifest File from the Non-Container Database. ==- set environment to NCDB ==- sqlplus / as sysdba ==- exec dbms_pdb.describe (pdb_descr_file=-'E:\app\oracle\manifest\NCDB_manifest_file.xml'); Step 4. Shutdown the NON-CDB file Once Step 3 Completes Successfully. ==- Set environment to NCDB ==- sqlplus / as sysdba ==- shutdown immediate Step 5. Start the CDB (CDB) if it’s Not Already Up and Check the Compatibility with CDB. ==- set environment to CDB ==- sqlplus / as sysdba ==- startup (If not up) ==- Run below at SQL prompt. SET SERVEROUTPUT ON; DECLARE Compatible CONSTANT VARCHAR2(3) :=CASE DBMS_PDB.CHECK_PLUG_COMPATIBILITY (pdb_descr_file =- 'E:\app\oracle\manifest\NCDB_manifest_file.xml') WHEN TRUE THEN 'YES' ELSE 'NO' END; BEGIN DBMS_OUTPUT.PUT_LINE(compatible); END; / Step 6. Once it Completes Successfully, Query PDB_PLUG_IN_VIOLATIONS View from CDB Database for Any Errors. ==- set environment to CDB ==- sqlplus / as sysdba ==- select name, cause, type, message, status from PDB_PLUG_IN_VIOLATIONS where name='NCDB'; Note: "There should be no violations reported. If there are any, you need to fix it before proceeding". Step 7. Connect to the CDB Where Database has to be Plugged in Using the Noncdb Manifest File and Plug the PDDB12C Database. ==- set environment to CDB ==- sqlplus / as sysdba ==- CREATE PLUGGABLE DATABASE NCDB USING 'E:\app\oracle\manifest\NCDB_manifest_file.xml' COPY FILE_NAME_CONVERT = ('E:\APP\ORACLE\ORADATA\NCDB\', 'E:\app\oracle\oradata\CDB1\'); Note: "Below options are supported and you can chose one based on the env" 1) COPY: The datafiles of noncdb remains intact and it is copied to create PDBs at new locations and keep original datafiles intact at the original location. (This would mean that a noncdb database would still be operational after the creation of a PDB). 2) MOVE: The datafiles of noncdb are moved to a new location to create a PDB. In this case, noncdb database would not be available after a PDB is created. NOCOPY: The datafiles of noncdb are used to create a PDB2 and it uses same existing location. In this case, a noncdb database would not be available after a PDB is created. You can use FILE_NAME_CONVERT parameter to specify the new location of the datafiles while using COPY or MOVE option. Step 8. Once Step 7 Completes Successfully, Switch to the PDB Container and Run the "$ORACLE_HOME/rdbms/admin/noncdb_to_pdb.sql". ==- set environment to CDB ==- sqlplus / as sysdba ==- alter session set container=NCDB ==- @$ORACLE_HOME/rdbms/admin/noncdb_to_pdb.sql Step 9. Startup the PDB and Check the Open Mode. ==- set environment to CDB ==- sqlplus / as sysdba ==- ALTER PLUGGABLE DATABASE OPEN; ==-SELECT name, open_mode FROM v$pdbs; ==================================== Hi Folks, Greetings!! I am professional part time oracle dba trainer and having good experience in oracle database administration. This is the right place to enroll yourself for Oracle DBA real time course. Please use following email ID for more details. Don’t hesitate to WhatsApp me any time. I will give you the best training and will create path to get DBA job easily. Enjoy the free YouTube video and connect with me for deep Oracle DBA knowledge. Mobile No : + 91 9960262955 (WhatsApp Number) EmailID: [email protected]
Views: 603 ANKUSH THAVALI
06.04 Oracle_10gR2_DataGuard_6.4 Perform a Switchback with longyannode and shanghainode.avi
 
12:29
Oracle 10g/11g RAC, DataGuard, GoldenGate,Streams Hands-on Practices Training. Please feel free to contact me: E-mail/Skype: [email protected] Oracle Database 10gR2 High Availability with Data Guard on Linux http://www.youtube.com/playlist?list=PLCEC4947864F3B571 6. Role Transition - Physical Standby Database 6.1 Perform a Switchover with shanghainode and xiamennode Step 1: Verify the Switchover status on the Primary - shanghainode Step 2: Convert the primary database into a physical standby database Step 3: Shut down and restart the former primary as a new standby Step 4: Query the SWITCHOVER_STATUS on the standby database Step 5: Convert the former standby to a primary database Step 6: Shutdown and restart the new primary database Step 7: Start Redo Apply on the new physical standby - shanghainode Step 8: Start Redo Apply on the physical standby - longyannode Step 9: Verify the new primary and standby database 6.2 Perform a Switchback with xiamennode and shanghainode Step 1: Verify the Switchover status on the Primary - xiamennode Step 2: Convert the primary database into a physical standby database Step 3: Shut down and restart the former primary as a new standby Step 4: Query the SWITCHOVER_STATUS on the standby database Step 5: Convert the former standby to a primary database Step 6: Shutdown and restart the new primary database Step 7: Start Redo Apply on the new physical standby - xiamennode Step 8: Start Redo Apply on the physical standby - longyannode Step9: Verify the new primary and standby database 6.3 Perform a Switchover with shanghainode and longyannode Step 1: Verify the Switchover status on the Primary - shanghainode Step 2: Convert the primary database into a physical standby database Step 3: Shut down and restart the former primary as a new standby Step 4: Query the SWITCHOVER_STATUS on the standby database Step 5: Convert the standby to a primary database Step 6: Shutdown and restart the new primary database Step 7: Start Redo Apply on the new physical standby - shanghainode Step 8: Start Redo Apply on the physical standby - xiamennode Step 9: Verify the new primary and standby database 6.4 Perform a Switchback with longyannode and shanghainode Step 1: Verify the Switchover status on the Primary - shanghainode Step 2: Convert the primary database into a physical standby database Step 3: Shut down and restart the former primary as a new standby Step 4: Query the SWITCHOVER_STATUS on the standby database Step 5: Convert the former standby to a primary database Step 6: Shutdown and restart the new primary database Step 7: Start Redo Apply on the new physical standby - longyannode Step 8: Start Redo Apply on the physical standby - xiamennode Step 9: Verify the new primary and standby database 6.5 Perform a Failover to the Physical Standby - xiamennode Step1: Identify and resolve any archive log gaps Step2: Copy and register any other missing archived redo logs Step3: Perform terminal recovery on the target standby Step4: convert the physical standby into a primary database Step5: Restart the new primary database in read/write mode Step6: Verify the new Primary Database Step7: Perform a full backup of the new primary database Step8: Flashing Back the Physical Standby Database - longyannode Step9: Using Flashback Database After a Failover 6.6 Flashing Back a Failed Primary into a Physical Standby Step1: Determine the SCN at which the old standby database became the primary database Step 2: Flash back the failed primary database Step 3: Convert the Failed Database to a Physical Standby Database Step 4: Shut down and restart the old primary database Step 5: Restart transporting redo to the new physical standby Step 6: Start Redo Apply Step 7: Restart Redo Apply on the new physical standby database if necessary Step 8: Verify the new primary and standby database 6.7 Perform a Switchback with xiamennode and shanghainode Step1: Verify the Switchover status on the Primary - xiamennode Step2: Convert the primary database into a physical standby database Step3: Shut down and restart the former primary as a new standby Step4: Query the SWITCHOVER_STATUS on the standby database Step5: Convert the former standby to a primary database Step6: Shutdown and restart the new primary database Step7: Start Redo Apply on the new physical standby - xiamennode Step8: Start Redo Apply on the physical standby - longyannode Step9: Verify the new primary and standby database
Views: 94 Yongcheng Lai
01.26_Oracle_10gR2_RACDG_1.26 Create a Cluster Database(2012_01_12).flv
 
04:19:31
Oracle 10g/11g RAC, DataGuard, GoldenGate,Streams Hands-on Practices Training. Please feel free to contact me: E-mail/Skype: [email protected] 1. Building an Oracle RAC 10gR2 for RAC Primary 1.1 Install Linux OS(CentOS 5.3) - () 1.2 Install Required Linux Packages for Oracle RAC- (Video) 1.3 Network Configuration - (Video) 1.4 Create "oracle" User and Directories - (Video) 1.5 Configure the Linux Servers for Oracle - (Video) 1.6 Configure the "hangcheck-timer" Kernel Module - (Video) 1.7 Configure RAC Nodes for Remote Access using SSH - (Video) 1.8 IP SAN Configuration - Openfiler - () 1.9 Install Openfiler - SAN - () 1.10 Configure iSCSI Volumes using openfiler - (Video) 1.11 Configure iSCSI Volumes on Oracle RAC Nodes - (Video) 1.12 Install and configure Oracle Cluster File System(OCFS2)- (Video) 1.13 Install and Configure ASM (ASMLib2.0) - (Video) 1.14 Download Oracle RAC 10g Software - (Video) 1.15 Pre-Installation Tasks for Oracle 10g Release 2- (Video) 1.16 Install Oracle Clusterware 10g - 10.2.0.1.0 - (Video) 1.17 Upgrade Oracle Clusterware from 10.2.0.1.0 to 10.2.0.3.0 - (Video) 1.18 Install and configure Automatic Storage Management (ASM) - (Video) 1.19 Apply the Patch Set 10.2.0.3.0 to the ASM Home - (Video) 1.20 Install Oracle Database 10gR2 Software - 10.2.0.1.0 - (Video) 1.21 Install Oracle Database 10g Companion CD Software - (Video) 1.22 Apply the Patch set 10.2.0.3.0 to Oracle Home - (Video) 1.23 Create TNS Listener Process - (Video) 1.24 Create ASM Instance - (Video) 1.25 Install the EM agent on each cluster node - (Video) 1.25.1 Pre-Installation Requirements - (Video) 1.25.2 Download Oracle Management Agent (10.2.0.5) - (Video) 1.25.3 Install Management Agent (10.2.0.5) in RAC Environment - (Video) 1.25.4 Verify Agent Status - (Video) 1.25.5 Secure the Management Agent if necessary - (Video) 1.26 Create a Cluster Database - (Video) 1.27 Post-Installation Tasks - (Optional) - (Video) 1.27.1 Re-compile Invalid Objects - (Video) 1.27.2 Enabling Archive Logs and Flashback in a RAC Environment - (Video) 1.27.3 Create Shared Oracle Password Files - (Video) 1.28 Verify TNS Networking Files - (Video) 1.29 Create / Alter Tablespaces - () 1.30 Verify the RAC Cluster & Database Configuration - (Video) 1.31 Configuring the Initialization Parameters - (Video) 1.32 Startup / Shutdown the Oracle RAC 10gR2 - (Video) 1.32.1 Stopping the Oracle RAC 10g Environment - (Video) 1.32.2 Start Monitor the alert.log - () 1.32.3 Start the Oracle RAC 10g - () 2. Building an Oracle RAC 10gR2 for RAC Standby 2.1 Install Linux OS(CentOS 5.3) - () 2.2 Install Required Linux Packages for Oracle RAC - (Video) 2.3 Network Configuration - (Video) 2.4 Create "oracle" User and Directories - (Video) 2.5 Configure the Linux Servers for Oracle - (Video) 2.6 Configure the "hangcheck-timer" Kernel Module - (Video) 2.7 Configure RAC Nodes for Remote Access using SSH - (Video) 2.8 Configure iSCSI Volumes using openfiler - (Video) 2.9 Configure iSCSI Volumes on Oracle RAC Nodes - (Video) 2.10 Install and configure Oracle Cluster File System(OCFS2) - (Video) 2.11 Install and Configure ASM (ASMLib2.0) - (Video) 2.12 Download Oracle RAC 10g Software - (Video) 2.13 Pre-Installation Tasks for Oracle 10g Release 2 - (Video) 2.14 Install Oracle Clusterware 10g - 10.2.0.1.0 - (Video) 2.15 Upgrade Oracle Clusterware from 10.2.0.1.0 to 10.2.0.3.0 - (Video) 2.16 Install and configure Automatic Storage Management (ASM) - (Video) 2.17 Apply the Patch Set 10.2.0.3.0 to the ASM Home - (Video) 2.18 Install Oracle Database 10gR2 Software - 10.2.0.1.0 - (Video) 2.19 Install Oracle Database 10g Companion CD Software - (Video) 2.20 Apply the Patch set 10.2.0.3.0 to Oracle Home - (Video) 2.21 Create TNS Listener Process - (Video) 2.22 Create ASM Instance - (Video) 2.23 Install the EM agent on each cluster node - (Video) 2.23.1 Pre-Installation Requirements - (Video) 2.23.2 Download Oracle Management Agent (10.2.0.5) - (Video) 2.23.3 Install Management Agent (10.2.0.5) in RAC Environment - (Video) 2.23.4 Verify Agent Status - () 2.23.5 Secure the Management Agent if necessary - () 2.24 Create a Cluster Database - (Video) 2.25 Post-Installation Tasks - (Optional) - (Video) 2.25.1 Re-compile Invalid Objects - (Video) 2.25.2 Enabling Archive Logs and Flashback in a RAC Environment - (Video) 2.25.3 Create Shared Oracle Password Files - (Video) 2.26 Verify TNS Networking Files - (Video) 2.27 Create / Alter Tablespaces - () 2.28 Verify the RAC Cluster & Database Configuration - (Video) 2.29 Configuring the Initialization Parameters - (Video) 2.30 Startup / Shutdown the Oracle RAC 10gR2 - ()
Views: 836 Yongcheng Lai
01.12_Oracle_10gR2_RACDG_1.12 Install and configure Oracle Cluster File System
 
10:59
Oracle 10g/11g RAC, DataGuard, GoldenGate,Streams Hands-on Practices Training. Please feel free to contact me: E-mail/Skype: [email protected] 1. Building an Oracle RAC 10gR2 for RAC Primary 1.1 Install Linux OS(CentOS 5.3) - () 1.2 Install Required Linux Packages for Oracle RAC- (Video) 1.3 Network Configuration - (Video) 1.4 Create "oracle" User and Directories - (Video) 1.5 Configure the Linux Servers for Oracle - (Video) 1.6 Configure the "hangcheck-timer" Kernel Module - (Video) 1.7 Configure RAC Nodes for Remote Access using SSH - (Video) 1.8 IP SAN Configuration - Openfiler - () 1.9 Install Openfiler - SAN - () 1.10 Configure iSCSI Volumes using openfiler - (Video) 1.11 Configure iSCSI Volumes on Oracle RAC Nodes - (Video) 1.12 Install and configure Oracle Cluster File System(OCFS2)- (Video) 1.13 Install and Configure ASM (ASMLib2.0) - (Video) 1.14 Download Oracle RAC 10g Software - (Video) 1.15 Pre-Installation Tasks for Oracle 10g Release 2- (Video) 1.16 Install Oracle Clusterware 10g - 10.2.0.1.0 - (Video) 1.17 Upgrade Oracle Clusterware from 10.2.0.1.0 to 10.2.0.3.0 - (Video) 1.18 Install and configure Automatic Storage Management (ASM) - (Video) 1.19 Apply the Patch Set 10.2.0.3.0 to the ASM Home - (Video) 1.20 Install Oracle Database 10gR2 Software - 10.2.0.1.0 - (Video) 1.21 Install Oracle Database 10g Companion CD Software - (Video) 1.22 Apply the Patch set 10.2.0.3.0 to Oracle Home - (Video) 1.23 Create TNS Listener Process - (Video) 1.24 Create ASM Instance - (Video) 1.25 Install the EM agent on each cluster node - (Video) 1.25.1 Pre-Installation Requirements - (Video) 1.25.2 Download Oracle Management Agent (10.2.0.5) - (Video) 1.25.3 Install Management Agent (10.2.0.5) in RAC Environment - (Video) 1.25.4 Verify Agent Status - (Video) 1.25.5 Secure the Management Agent if necessary - (Video) 1.26 Create a Cluster Database - (Video) 1.27 Post-Installation Tasks - (Optional) - (Video) 1.27.1 Re-compile Invalid Objects - (Video) 1.27.2 Enabling Archive Logs and Flashback in a RAC Environment - (Video) 1.27.3 Create Shared Oracle Password Files - (Video) 1.28 Verify TNS Networking Files - (Video) 1.29 Create / Alter Tablespaces - () 1.30 Verify the RAC Cluster & Database Configuration - (Video) 1.31 Configuring the Initialization Parameters - (Video) 1.32 Startup / Shutdown the Oracle RAC 10gR2 - (Video) 1.32.1 Stopping the Oracle RAC 10g Environment - (Video) 1.32.2 Start Monitor the alert.log - () 1.32.3 Start the Oracle RAC 10g - () 2. Building an Oracle RAC 10gR2 for RAC Standby 2.1 Install Linux OS(CentOS 5.3) - () 2.2 Install Required Linux Packages for Oracle RAC - (Video) 2.3 Network Configuration - (Video) 2.4 Create "oracle" User and Directories - (Video) 2.5 Configure the Linux Servers for Oracle - (Video) 2.6 Configure the "hangcheck-timer" Kernel Module - (Video) 2.7 Configure RAC Nodes for Remote Access using SSH - (Video) 2.8 Configure iSCSI Volumes using openfiler - (Video) 2.9 Configure iSCSI Volumes on Oracle RAC Nodes - (Video) 2.10 Install and configure Oracle Cluster File System(OCFS2) - (Video) 2.11 Install and Configure ASM (ASMLib2.0) - (Video) 2.12 Download Oracle RAC 10g Software - (Video) 2.13 Pre-Installation Tasks for Oracle 10g Release 2 - (Video) 2.14 Install Oracle Clusterware 10g - 10.2.0.1.0 - (Video) 2.15 Upgrade Oracle Clusterware from 10.2.0.1.0 to 10.2.0.3.0 - (Video) 2.16 Install and configure Automatic Storage Management (ASM) - (Video) 2.17 Apply the Patch Set 10.2.0.3.0 to the ASM Home - (Video) 2.18 Install Oracle Database 10gR2 Software - 10.2.0.1.0 - (Video) 2.19 Install Oracle Database 10g Companion CD Software - (Video) 2.20 Apply the Patch set 10.2.0.3.0 to Oracle Home - (Video) 2.21 Create TNS Listener Process - (Video) 2.22 Create ASM Instance - (Video) 2.23 Install the EM agent on each cluster node - (Video) 2.23.1 Pre-Installation Requirements - (Video) 2.23.2 Download Oracle Management Agent (10.2.0.5) - (Video) 2.23.3 Install Management Agent (10.2.0.5) in RAC Environment - (Video) 2.23.4 Verify Agent Status - () 2.23.5 Secure the Management Agent if necessary - () 2.24 Create a Cluster Database - (Video) 2.25 Post-Installation Tasks - (Optional) - (Video) 2.25.1 Re-compile Invalid Objects - (Video) 2.25.2 Enabling Archive Logs and Flashback in a RAC Environment - (Video) 2.25.3 Create Shared Oracle Password Files - (Video) 2.26 Verify TNS Networking Files - (Video) 2.27 Create / Alter Tablespaces - () 2.28 Verify the RAC Cluster & Database Configuration - (Video) 2.29 Configuring the Initialization Parameters - (Video) 2.30 Startup / Shutdown the Oracle RAC 10gR2 - ()
Views: 313 Yongcheng Lai
02.04_Oracle_10gR2_RACDG_2.4 Create oracle User and Directories(2012_01_13).flv
 
05:32
Oracle 10g/11g RAC, DataGuard, GoldenGate,Streams Hands-on Practices Training. Please feel free to contact me: E-mail/Skype: [email protected] 1. Building an Oracle RAC 10gR2 for RAC Primary 1.1 Install Linux OS(CentOS 5.3) - () 1.2 Install Required Linux Packages for Oracle RAC- (Video) 1.3 Network Configuration - (Video) 1.4 Create "oracle" User and Directories - (Video) 1.5 Configure the Linux Servers for Oracle - (Video) 1.6 Configure the "hangcheck-timer" Kernel Module - (Video) 1.7 Configure RAC Nodes for Remote Access using SSH - (Video) 1.8 IP SAN Configuration - Openfiler - () 1.9 Install Openfiler - SAN - () 1.10 Configure iSCSI Volumes using openfiler - (Video) 1.11 Configure iSCSI Volumes on Oracle RAC Nodes - (Video) 1.12 Install and configure Oracle Cluster File System(OCFS2)- (Video) 1.13 Install and Configure ASM (ASMLib2.0) - (Video) 1.14 Download Oracle RAC 10g Software - (Video) 1.15 Pre-Installation Tasks for Oracle 10g Release 2- (Video) 1.16 Install Oracle Clusterware 10g - 10.2.0.1.0 - (Video) 1.17 Upgrade Oracle Clusterware from 10.2.0.1.0 to 10.2.0.3.0 - (Video) 1.18 Install and configure Automatic Storage Management (ASM) - (Video) 1.19 Apply the Patch Set 10.2.0.3.0 to the ASM Home - (Video) 1.20 Install Oracle Database 10gR2 Software - 10.2.0.1.0 - (Video) 1.21 Install Oracle Database 10g Companion CD Software - (Video) 1.22 Apply the Patch set 10.2.0.3.0 to Oracle Home - (Video) 1.23 Create TNS Listener Process - (Video) 1.24 Create ASM Instance - (Video) 1.25 Install the EM agent on each cluster node - (Video) 1.25.1 Pre-Installation Requirements - (Video) 1.25.2 Download Oracle Management Agent (10.2.0.5) - (Video) 1.25.3 Install Management Agent (10.2.0.5) in RAC Environment - (Video) 1.25.4 Verify Agent Status - (Video) 1.25.5 Secure the Management Agent if necessary - (Video) 1.26 Create a Cluster Database - (Video) 1.27 Post-Installation Tasks - (Optional) - (Video) 1.27.1 Re-compile Invalid Objects - (Video) 1.27.2 Enabling Archive Logs and Flashback in a RAC Environment - (Video) 1.27.3 Create Shared Oracle Password Files - (Video) 1.28 Verify TNS Networking Files - (Video) 1.29 Create / Alter Tablespaces - () 1.30 Verify the RAC Cluster & Database Configuration - (Video) 1.31 Configuring the Initialization Parameters - (Video) 1.32 Startup / Shutdown the Oracle RAC 10gR2 - (Video) 1.32.1 Stopping the Oracle RAC 10g Environment - (Video) 1.32.2 Start Monitor the alert.log - () 1.32.3 Start the Oracle RAC 10g - () 2. Building an Oracle RAC 10gR2 for RAC Standby 2.1 Install Linux OS(CentOS 5.3) - () 2.2 Install Required Linux Packages for Oracle RAC - (Video) 2.3 Network Configuration - (Video) 2.4 Create "oracle" User and Directories - (Video) 2.5 Configure the Linux Servers for Oracle - (Video) 2.6 Configure the "hangcheck-timer" Kernel Module - (Video) 2.7 Configure RAC Nodes for Remote Access using SSH - (Video) 2.8 Configure iSCSI Volumes using openfiler - (Video) 2.9 Configure iSCSI Volumes on Oracle RAC Nodes - (Video) 2.10 Install and configure Oracle Cluster File System(OCFS2) - (Video) 2.11 Install and Configure ASM (ASMLib2.0) - (Video) 2.12 Download Oracle RAC 10g Software - (Video) 2.13 Pre-Installation Tasks for Oracle 10g Release 2 - (Video) 2.14 Install Oracle Clusterware 10g - 10.2.0.1.0 - (Video) 2.15 Upgrade Oracle Clusterware from 10.2.0.1.0 to 10.2.0.3.0 - (Video) 2.16 Install and configure Automatic Storage Management (ASM) - (Video) 2.17 Apply the Patch Set 10.2.0.3.0 to the ASM Home - (Video) 2.18 Install Oracle Database 10gR2 Software - 10.2.0.1.0 - (Video) 2.19 Install Oracle Database 10g Companion CD Software - (Video) 2.20 Apply the Patch set 10.2.0.3.0 to Oracle Home - (Video) 2.21 Create TNS Listener Process - (Video) 2.22 Create ASM Instance - (Video) 2.23 Install the EM agent on each cluster node - (Video) 2.23.1 Pre-Installation Requirements - (Video) 2.23.2 Download Oracle Management Agent (10.2.0.5) - (Video) 2.23.3 Install Management Agent (10.2.0.5) in RAC Environment - (Video) 2.23.4 Verify Agent Status - () 2.23.5 Secure the Management Agent if necessary - () 2.24 Create a Cluster Database - (Video) 2.25 Post-Installation Tasks - (Optional) - (Video) 2.25.1 Re-compile Invalid Objects - (Video) 2.25.2 Enabling Archive Logs and Flashback in a RAC Environment - (Video) 2.25.3 Create Shared Oracle Password Files - (Video) 2.26 Verify TNS Networking Files - (Video) 2.27 Create / Alter Tablespaces - () 2.28 Verify the RAC Cluster & Database Configuration - (Video) 2.29 Configuring the Initialization Parameters - (Video) 2.30 Startup / Shutdown the Oracle RAC 10gR2 - ()
Views: 179 Yongcheng Lai
01.02_Oracle_10gR2_RACDG_1.2 Install Required Linux Packages for Oracle RAC(2012_01_12).flv
 
02:13
Oracle 10g/11g RAC, DataGuard, GoldenGate,Streams Hands-on Practices Training. ONLY $199 Please feel free to contact me: E-mail/Skype: [email protected] 1. Building an Oracle RAC 10gR2 for RAC Primary 1.1 Install Linux OS(CentOS 5.3) - () 1.2 Install Required Linux Packages for Oracle RAC- (Video) 1.3 Network Configuration - (Video) 1.4 Create "oracle" User and Directories - (Video) 1.5 Configure the Linux Servers for Oracle - (Video) 1.6 Configure the "hangcheck-timer" Kernel Module - (Video) 1.7 Configure RAC Nodes for Remote Access using SSH - (Video) 1.8 IP SAN Configuration - Openfiler - () 1.9 Install Openfiler - SAN - () 1.10 Configure iSCSI Volumes using openfiler - (Video) 1.11 Configure iSCSI Volumes on Oracle RAC Nodes - (Video) 1.12 Install and configure Oracle Cluster File System(OCFS2)- (Video) 1.13 Install and Configure ASM (ASMLib2.0) - (Video) 1.14 Download Oracle RAC 10g Software - (Video) 1.15 Pre-Installation Tasks for Oracle 10g Release 2- (Video) 1.16 Install Oracle Clusterware 10g - 10.2.0.1.0 - (Video) 1.17 Upgrade Oracle Clusterware from 10.2.0.1.0 to 10.2.0.3.0 - (Video) 1.18 Install and configure Automatic Storage Management (ASM) - (Video) 1.19 Apply the Patch Set 10.2.0.3.0 to the ASM Home - (Video) 1.20 Install Oracle Database 10gR2 Software - 10.2.0.1.0 - (Video) 1.21 Install Oracle Database 10g Companion CD Software - (Video) 1.22 Apply the Patch set 10.2.0.3.0 to Oracle Home - (Video) 1.23 Create TNS Listener Process - (Video) 1.24 Create ASM Instance - (Video) 1.25 Install the EM agent on each cluster node - (Video) 1.25.1 Pre-Installation Requirements - (Video) 1.25.2 Download Oracle Management Agent (10.2.0.5) - (Video) 1.25.3 Install Management Agent (10.2.0.5) in RAC Environment - (Video) 1.25.4 Verify Agent Status - (Video) 1.25.5 Secure the Management Agent if necessary - (Video) 1.26 Create a Cluster Database - (Video) 1.27 Post-Installation Tasks - (Optional) - (Video) 1.27.1 Re-compile Invalid Objects - (Video) 1.27.2 Enabling Archive Logs and Flashback in a RAC Environment - (Video) 1.27.3 Create Shared Oracle Password Files - (Video) 1.28 Verify TNS Networking Files - (Video) 1.29 Create / Alter Tablespaces - () 1.30 Verify the RAC Cluster & Database Configuration - (Video) 1.31 Configuring the Initialization Parameters - (Video) 1.32 Startup / Shutdown the Oracle RAC 10gR2 - (Video) 1.32.1 Stopping the Oracle RAC 10g Environment - (Video) 1.32.2 Start Monitor the alert.log - () 1.32.3 Start the Oracle RAC 10g - () 2. Building an Oracle RAC 10gR2 for RAC Standby 2.1 Install Linux OS(CentOS 5.3) - () 2.2 Install Required Linux Packages for Oracle RAC - (Video) 2.3 Network Configuration - (Video) 2.4 Create "oracle" User and Directories - (Video) 2.5 Configure the Linux Servers for Oracle - (Video) 2.6 Configure the "hangcheck-timer" Kernel Module - (Video) 2.7 Configure RAC Nodes for Remote Access using SSH - (Video) 2.8 Configure iSCSI Volumes using openfiler - (Video) 2.9 Configure iSCSI Volumes on Oracle RAC Nodes - (Video) 2.10 Install and configure Oracle Cluster File System(OCFS2) - (Video) 2.11 Install and Configure ASM (ASMLib2.0) - (Video) 2.12 Download Oracle RAC 10g Software - (Video) 2.13 Pre-Installation Tasks for Oracle 10g Release 2 - (Video) 2.14 Install Oracle Clusterware 10g - 10.2.0.1.0 - (Video) 2.15 Upgrade Oracle Clusterware from 10.2.0.1.0 to 10.2.0.3.0 - (Video) 2.16 Install and configure Automatic Storage Management (ASM) - (Video) 2.17 Apply the Patch Set 10.2.0.3.0 to the ASM Home - (Video) 2.18 Install Oracle Database 10gR2 Software - 10.2.0.1.0 - (Video) 2.19 Install Oracle Database 10g Companion CD Software - (Video) 2.20 Apply the Patch set 10.2.0.3.0 to Oracle Home - (Video) 2.21 Create TNS Listener Process - (Video) 2.22 Create ASM Instance - (Video) 2.23 Install the EM agent on each cluster node - (Video) 2.23.1 Pre-Installation Requirements - (Video) 2.23.2 Download Oracle Management Agent (10.2.0.5) - (Video) 2.23.3 Install Management Agent (10.2.0.5) in RAC Environment - (Video) 2.23.4 Verify Agent Status - () 2.23.5 Secure the Management Agent if necessary - () 2.24 Create a Cluster Database - (Video) 2.25 Post-Installation Tasks - (Optional) - (Video) 2.25.1 Re-compile Invalid Objects - (Video) 2.25.2 Enabling Archive Logs and Flashback in a RAC Environment - (Video) 2.25.3 Create Shared Oracle Password Files - (Video) 2.26 Verify TNS Networking Files - (Video) 2.27 Create / Alter Tablespaces - () 2.28 Verify the RAC Cluster & Database Configuration - (Video) 2.29 Configuring the Initialization Parameters - (Video) 2.30 Startup / Shutdown the Oracle RAC 10gR2 - ()
Views: 280 Yongcheng Lai
01.16_Oracle_10gR2_RACDG_1.16 Install Oracle Clusterware 10g - 10.2.0.1.0(2012_01_12).flv
 
28:44
Oracle 10g/11g RAC, DataGuard, GoldenGate,Streams Hands-on Practices Training. Please feel free to contact me: E-mail/Skype: [email protected] 1. Building an Oracle RAC 10gR2 for RAC Primary 1.1 Install Linux OS(CentOS 5.3) - () 1.2 Install Required Linux Packages for Oracle RAC- (Video) 1.3 Network Configuration - (Video) 1.4 Create "oracle" User and Directories - (Video) 1.5 Configure the Linux Servers for Oracle - (Video) 1.6 Configure the "hangcheck-timer" Kernel Module - (Video) 1.7 Configure RAC Nodes for Remote Access using SSH - (Video) 1.8 IP SAN Configuration - Openfiler - () 1.9 Install Openfiler - SAN - () 1.10 Configure iSCSI Volumes using openfiler - (Video) 1.11 Configure iSCSI Volumes on Oracle RAC Nodes - (Video) 1.12 Install and configure Oracle Cluster File System(OCFS2)- (Video) 1.13 Install and Configure ASM (ASMLib2.0) - (Video) 1.14 Download Oracle RAC 10g Software - (Video) 1.15 Pre-Installation Tasks for Oracle 10g Release 2- (Video) 1.16 Install Oracle Clusterware 10g - 10.2.0.1.0 - (Video) 1.17 Upgrade Oracle Clusterware from 10.2.0.1.0 to 10.2.0.3.0 - (Video) 1.18 Install and configure Automatic Storage Management (ASM) - (Video) 1.19 Apply the Patch Set 10.2.0.3.0 to the ASM Home - (Video) 1.20 Install Oracle Database 10gR2 Software - 10.2.0.1.0 - (Video) 1.21 Install Oracle Database 10g Companion CD Software - (Video) 1.22 Apply the Patch set 10.2.0.3.0 to Oracle Home - (Video) 1.23 Create TNS Listener Process - (Video) 1.24 Create ASM Instance - (Video) 1.25 Install the EM agent on each cluster node - (Video) 1.25.1 Pre-Installation Requirements - (Video) 1.25.2 Download Oracle Management Agent (10.2.0.5) - (Video) 1.25.3 Install Management Agent (10.2.0.5) in RAC Environment - (Video) 1.25.4 Verify Agent Status - (Video) 1.25.5 Secure the Management Agent if necessary - (Video) 1.26 Create a Cluster Database - (Video) 1.27 Post-Installation Tasks - (Optional) - (Video) 1.27.1 Re-compile Invalid Objects - (Video) 1.27.2 Enabling Archive Logs and Flashback in a RAC Environment - (Video) 1.27.3 Create Shared Oracle Password Files - (Video) 1.28 Verify TNS Networking Files - (Video) 1.29 Create / Alter Tablespaces - () 1.30 Verify the RAC Cluster & Database Configuration - (Video) 1.31 Configuring the Initialization Parameters - (Video) 1.32 Startup / Shutdown the Oracle RAC 10gR2 - (Video) 1.32.1 Stopping the Oracle RAC 10g Environment - (Video) 1.32.2 Start Monitor the alert.log - () 1.32.3 Start the Oracle RAC 10g - () 2. Building an Oracle RAC 10gR2 for RAC Standby 2.1 Install Linux OS(CentOS 5.3) - () 2.2 Install Required Linux Packages for Oracle RAC - (Video) 2.3 Network Configuration - (Video) 2.4 Create "oracle" User and Directories - (Video) 2.5 Configure the Linux Servers for Oracle - (Video) 2.6 Configure the "hangcheck-timer" Kernel Module - (Video) 2.7 Configure RAC Nodes for Remote Access using SSH - (Video) 2.8 Configure iSCSI Volumes using openfiler - (Video) 2.9 Configure iSCSI Volumes on Oracle RAC Nodes - (Video) 2.10 Install and configure Oracle Cluster File System(OCFS2) - (Video) 2.11 Install and Configure ASM (ASMLib2.0) - (Video) 2.12 Download Oracle RAC 10g Software - (Video) 2.13 Pre-Installation Tasks for Oracle 10g Release 2 - (Video) 2.14 Install Oracle Clusterware 10g - 10.2.0.1.0 - (Video) 2.15 Upgrade Oracle Clusterware from 10.2.0.1.0 to 10.2.0.3.0 - (Video) 2.16 Install and configure Automatic Storage Management (ASM) - (Video) 2.17 Apply the Patch Set 10.2.0.3.0 to the ASM Home - (Video) 2.18 Install Oracle Database 10gR2 Software - 10.2.0.1.0 - (Video) 2.19 Install Oracle Database 10g Companion CD Software - (Video) 2.20 Apply the Patch set 10.2.0.3.0 to Oracle Home - (Video) 2.21 Create TNS Listener Process - (Video) 2.22 Create ASM Instance - (Video) 2.23 Install the EM agent on each cluster node - (Video) 2.23.1 Pre-Installation Requirements - (Video) 2.23.2 Download Oracle Management Agent (10.2.0.5) - (Video) 2.23.3 Install Management Agent (10.2.0.5) in RAC Environment - (Video) 2.23.4 Verify Agent Status - () 2.23.5 Secure the Management Agent if necessary - () 2.24 Create a Cluster Database - (Video) 2.25 Post-Installation Tasks - (Optional) - (Video) 2.25.1 Re-compile Invalid Objects - (Video) 2.25.2 Enabling Archive Logs and Flashback in a RAC Environment - (Video) 2.25.3 Create Shared Oracle Password Files - (Video) 2.26 Verify TNS Networking Files - (Video) 2.27 Create / Alter Tablespaces - () 2.28 Verify the RAC Cluster & Database Configuration - (Video) 2.29 Configuring the Initialization Parameters - (Video) 2.30 Startup / Shutdown the Oracle RAC 10gR2 - ()
Views: 566 Yongcheng Lai
Using Configuration Wizards in Nagios XI (Step 4)
 
02:58
In this video, we continue to work our way through a Nagios XI configuration wizard to help users understand how they work and give them an example so they can easily monitor their own environment. Nagios XI is powerful monitoring software that monitors all mission-critical infrastructure components in any environment. Whether you’re a sys admin at a startup, the CTO of a multi-billion dollar company or somewhere in between, Nagios XI’s comprehensive features can work for you. Download XI: http://nag.is/xldd Technical documentation: http://nag.is/xitd User manuals: http://nag.is/xiud Support Forum: http://nag.is/nsf Learn More About Nagios XI: http://bit.ly/mIEcx0 Nagios homepage: https://www.nagios.com
Views: 7165 nagiosvideo
Oracle DBA Justin - How to backup and restore an Oracle database with RMAN (basic)
 
18:53
How to backup and restore an Oracle database with RMAN (basic)
Views: 282532 jbleistein11
02.23.01_Oracle_10gR2_RACDG_2.23.1 Pre-Installation Requirements(2012_01_13).flv
 
04:17
Oracle 10g/11g RAC, DataGuard, GoldenGate,Streams Hands-on Practices Training. Please feel free to contact me: E-mail/Skype: [email protected] 1. Building an Oracle RAC 10gR2 for RAC Primary 1.1 Install Linux OS(CentOS 5.3) - () 1.2 Install Required Linux Packages for Oracle RAC- (Video) 1.3 Network Configuration - (Video) 1.4 Create "oracle" User and Directories - (Video) 1.5 Configure the Linux Servers for Oracle - (Video) 1.6 Configure the "hangcheck-timer" Kernel Module - (Video) 1.7 Configure RAC Nodes for Remote Access using SSH - (Video) 1.8 IP SAN Configuration - Openfiler - () 1.9 Install Openfiler - SAN - () 1.10 Configure iSCSI Volumes using openfiler - (Video) 1.11 Configure iSCSI Volumes on Oracle RAC Nodes - (Video) 1.12 Install and configure Oracle Cluster File System(OCFS2)- (Video) 1.13 Install and Configure ASM (ASMLib2.0) - (Video) 1.14 Download Oracle RAC 10g Software - (Video) 1.15 Pre-Installation Tasks for Oracle 10g Release 2- (Video) 1.16 Install Oracle Clusterware 10g - 10.2.0.1.0 - (Video) 1.17 Upgrade Oracle Clusterware from 10.2.0.1.0 to 10.2.0.3.0 - (Video) 1.18 Install and configure Automatic Storage Management (ASM) - (Video) 1.19 Apply the Patch Set 10.2.0.3.0 to the ASM Home - (Video) 1.20 Install Oracle Database 10gR2 Software - 10.2.0.1.0 - (Video) 1.21 Install Oracle Database 10g Companion CD Software - (Video) 1.22 Apply the Patch set 10.2.0.3.0 to Oracle Home - (Video) 1.23 Create TNS Listener Process - (Video) 1.24 Create ASM Instance - (Video) 1.25 Install the EM agent on each cluster node - (Video) 1.25.1 Pre-Installation Requirements - (Video) 1.25.2 Download Oracle Management Agent (10.2.0.5) - (Video) 1.25.3 Install Management Agent (10.2.0.5) in RAC Environment - (Video) 1.25.4 Verify Agent Status - (Video) 1.25.5 Secure the Management Agent if necessary - (Video) 1.26 Create a Cluster Database - (Video) 1.27 Post-Installation Tasks - (Optional) - (Video) 1.27.1 Re-compile Invalid Objects - (Video) 1.27.2 Enabling Archive Logs and Flashback in a RAC Environment - (Video) 1.27.3 Create Shared Oracle Password Files - (Video) 1.28 Verify TNS Networking Files - (Video) 1.29 Create / Alter Tablespaces - () 1.30 Verify the RAC Cluster & Database Configuration - (Video) 1.31 Configuring the Initialization Parameters - (Video) 1.32 Startup / Shutdown the Oracle RAC 10gR2 - (Video) 1.32.1 Stopping the Oracle RAC 10g Environment - (Video) 1.32.2 Start Monitor the alert.log - () 1.32.3 Start the Oracle RAC 10g - () 2. Building an Oracle RAC 10gR2 for RAC Standby 2.1 Install Linux OS(CentOS 5.3) - () 2.2 Install Required Linux Packages for Oracle RAC - (Video) 2.3 Network Configuration - (Video) 2.4 Create "oracle" User and Directories - (Video) 2.5 Configure the Linux Servers for Oracle - (Video) 2.6 Configure the "hangcheck-timer" Kernel Module - (Video) 2.7 Configure RAC Nodes for Remote Access using SSH - (Video) 2.8 Configure iSCSI Volumes using openfiler - (Video) 2.9 Configure iSCSI Volumes on Oracle RAC Nodes - (Video) 2.10 Install and configure Oracle Cluster File System(OCFS2) - (Video) 2.11 Install and Configure ASM (ASMLib2.0) - (Video) 2.12 Download Oracle RAC 10g Software - (Video) 2.13 Pre-Installation Tasks for Oracle 10g Release 2 - (Video) 2.14 Install Oracle Clusterware 10g - 10.2.0.1.0 - (Video) 2.15 Upgrade Oracle Clusterware from 10.2.0.1.0 to 10.2.0.3.0 - (Video) 2.16 Install and configure Automatic Storage Management (ASM) - (Video) 2.17 Apply the Patch Set 10.2.0.3.0 to the ASM Home - (Video) 2.18 Install Oracle Database 10gR2 Software - 10.2.0.1.0 - (Video) 2.19 Install Oracle Database 10g Companion CD Software - (Video) 2.20 Apply the Patch set 10.2.0.3.0 to Oracle Home - (Video) 2.21 Create TNS Listener Process - (Video) 2.22 Create ASM Instance - (Video) 2.23 Install the EM agent on each cluster node - (Video) 2.23.1 Pre-Installation Requirements - (Video) 2.23.2 Download Oracle Management Agent (10.2.0.5) - (Video) 2.23.3 Install Management Agent (10.2.0.5) in RAC Environment - (Video) 2.23.4 Verify Agent Status - () 2.23.5 Secure the Management Agent if necessary - () 2.24 Create a Cluster Database - (Video) 2.25 Post-Installation Tasks - (Optional) - (Video) 2.25.1 Re-compile Invalid Objects - (Video) 2.25.2 Enabling Archive Logs and Flashback in a RAC Environment - (Video) 2.25.3 Create Shared Oracle Password Files - (Video) 2.26 Verify TNS Networking Files - (Video) 2.27 Create / Alter Tablespaces - () 2.28 Verify the RAC Cluster & Database Configuration - (Video) 2.29 Configuring the Initialization Parameters - (Video) 2.30 Startup / Shutdown the Oracle RAC 10gR2 - ()
Views: 90 Yongcheng Lai
06.02 Oracle_10gR2_DataGuard_6.2 Perform a Switchback with xiamennode and shanghainode.avi
 
13:18
Oracle 10g/11g RAC, DataGuard, GoldenGate,Streams Hands-on Practices Training. Please feel free to contact me: E-mail/Skype: [email protected] Oracle Database 10gR2 High Availability with Data Guard on Linux http://www.youtube.com/playlist?list=PLCEC4947864F3B571 6. Role Transition - Physical Standby Database 6.1 Perform a Switchover with shanghainode and xiamennode - (Video) Step 1: Verify the Switchover status on the Primary - shanghainode - (Video) Step 2: Convert the primary database into a physical standby database - (Video) Step 3: Shut down and restart the former primary as a new standby - (Video) Step 4: Query the SWITCHOVER_STATUS on the standby database - (Video) Step 5: Convert the former standby to a primary database - (Video) Step 6: Shutdown and restart the new primary database - (Video) Step 7: Start Redo Apply on the new physical standby - shanghainode - (Video) Step 8: Start Redo Apply on the physical standby - longyannode - (Video) Step 9: Verify the new primary and standby database - (Video) 6.2 Perform a Switchback with xiamennode and shanghainode - (Video) Step 1: Verify the Switchover status on the Primary - xiamennode - (Video) Step 2: Convert the primary database into a physical standby database - (Video) Step 3: Shut down and restart the former primary as a new standby - (Video) Step 4: Query the SWITCHOVER_STATUS on the standby database - (Video) Step 5: Convert the former standby to a primary database - (Video) Step 6: Shutdown and restart the new primary database - (Video) Step 7: Start Redo Apply on the new physical standby - xiamennode - (Video) Step 8: Start Redo Apply on the physical standby - longyannode - (Video) Step9: Verify the new primary and standby database - (Video) 6.3 Perform a Switchover with shanghainode and longyannode - (Video) 6.4 Perform a Switchback with longyannode and shanghainode - (Video) Step 1: Verify the Switchover status on the Primary - shanghainode - (Video) Step 2: Convert the primary database into a physical standby database - (Video) Step 3: Shut down and restart the former primary as a new standby - (Video) Step 4: Query the SWITCHOVER_STATUS on the standby database - (Video) Step 5: Convert the former standby to a primary database - (Video) Step 6: Shutdown and restart the new primary database - (Video) Step 7: Start Redo Apply on the new physical standby - longyannode - (Video) Step 8: Start Redo Apply on the physical standby - xiamennode - (Video) Step 9: Verify the new primary and standby database - (Video) 6.5 Perform a Failover to the Physical Standby - xiamennode - (Video) Step1: Identify and resolve any archive log gaps - (Video) Step2: Copy and register any other missing archived redo logs - (Video) Step3: Perform terminal recovery on the target standby - (Video) Step4: convert the physical standby into a primary database - (Video) Step5: Restart the new primary database in read/write mode - (Video) Step6: Verify the new Primary Database - (Video) Step7: Perform a full backup of the new primary database - (Video) Step8: Flashing Back the Physical Standby Database - longyannode - (Video) Step9: Using Flashback Database After a Failover - (Video) 6.6 Flashing Back a Failed Primary into a Physical Standby - (Video) Step1: Determine the SCN at which the old standby database became the primary database - (Video) Step 2: Flash back the failed primary database - (Video) Step 3: Convert the Failed Database to a Physical Standby Database - (Video) Step 4: Shut down and restart the old primary database - (Video) Step 5: Restart transporting redo to the new physical standby - (Video) Step 6: Start Redo Apply - (Video) Step 7: Restart Redo Apply on the new physical standby database if necessary - (Video) Step 8: Verify the new primary and standby database - (Video) 6.7 Perform a Switchback with xiamennode and shanghainode - (Video)
Views: 88 Yongcheng Lai
01.32.01_Oracle_10gR2_RACDG_1.32.1 Stopping the Oracle RAC 10g Environment(2012_01_13).flv
 
02:52
Oracle 10g/11g RAC, DataGuard, GoldenGate,Streams Hands-on Practices Training. Please feel free to contact me: E-mail/Skype: [email protected] 1. Building an Oracle RAC 10gR2 for RAC Primary 1.1 Install Linux OS(CentOS 5.3) - () 1.2 Install Required Linux Packages for Oracle RAC- (Video) 1.3 Network Configuration - (Video) 1.4 Create "oracle" User and Directories - (Video) 1.5 Configure the Linux Servers for Oracle - (Video) 1.6 Configure the "hangcheck-timer" Kernel Module - (Video) 1.7 Configure RAC Nodes for Remote Access using SSH - (Video) 1.8 IP SAN Configuration - Openfiler - () 1.9 Install Openfiler - SAN - () 1.10 Configure iSCSI Volumes using openfiler - (Video) 1.11 Configure iSCSI Volumes on Oracle RAC Nodes - (Video) 1.12 Install and configure Oracle Cluster File System(OCFS2)- (Video) 1.13 Install and Configure ASM (ASMLib2.0) - (Video) 1.14 Download Oracle RAC 10g Software - (Video) 1.15 Pre-Installation Tasks for Oracle 10g Release 2- (Video) 1.16 Install Oracle Clusterware 10g - 10.2.0.1.0 - (Video) 1.17 Upgrade Oracle Clusterware from 10.2.0.1.0 to 10.2.0.3.0 - (Video) 1.18 Install and configure Automatic Storage Management (ASM) - (Video) 1.19 Apply the Patch Set 10.2.0.3.0 to the ASM Home - (Video) 1.20 Install Oracle Database 10gR2 Software - 10.2.0.1.0 - (Video) 1.21 Install Oracle Database 10g Companion CD Software - (Video) 1.22 Apply the Patch set 10.2.0.3.0 to Oracle Home - (Video) 1.23 Create TNS Listener Process - (Video) 1.24 Create ASM Instance - (Video) 1.25 Install the EM agent on each cluster node - (Video) 1.25.1 Pre-Installation Requirements - (Video) 1.25.2 Download Oracle Management Agent (10.2.0.5) - (Video) 1.25.3 Install Management Agent (10.2.0.5) in RAC Environment - (Video) 1.25.4 Verify Agent Status - (Video) 1.25.5 Secure the Management Agent if necessary - (Video) 1.26 Create a Cluster Database - (Video) 1.27 Post-Installation Tasks - (Optional) - (Video) 1.27.1 Re-compile Invalid Objects - (Video) 1.27.2 Enabling Archive Logs and Flashback in a RAC Environment - (Video) 1.27.3 Create Shared Oracle Password Files - (Video) 1.28 Verify TNS Networking Files - (Video) 1.29 Create / Alter Tablespaces - () 1.30 Verify the RAC Cluster & Database Configuration - (Video) 1.31 Configuring the Initialization Parameters - (Video) 1.32 Startup / Shutdown the Oracle RAC 10gR2 - (Video) 1.32.1 Stopping the Oracle RAC 10g Environment - (Video) 1.32.2 Start Monitor the alert.log - () 1.32.3 Start the Oracle RAC 10g - () 2. Building an Oracle RAC 10gR2 for RAC Standby 2.1 Install Linux OS(CentOS 5.3) - () 2.2 Install Required Linux Packages for Oracle RAC - (Video) 2.3 Network Configuration - (Video) 2.4 Create "oracle" User and Directories - (Video) 2.5 Configure the Linux Servers for Oracle - (Video) 2.6 Configure the "hangcheck-timer" Kernel Module - (Video) 2.7 Configure RAC Nodes for Remote Access using SSH - (Video) 2.8 Configure iSCSI Volumes using openfiler - (Video) 2.9 Configure iSCSI Volumes on Oracle RAC Nodes - (Video) 2.10 Install and configure Oracle Cluster File System(OCFS2) - (Video) 2.11 Install and Configure ASM (ASMLib2.0) - (Video) 2.12 Download Oracle RAC 10g Software - (Video) 2.13 Pre-Installation Tasks for Oracle 10g Release 2 - (Video) 2.14 Install Oracle Clusterware 10g - 10.2.0.1.0 - (Video) 2.15 Upgrade Oracle Clusterware from 10.2.0.1.0 to 10.2.0.3.0 - (Video) 2.16 Install and configure Automatic Storage Management (ASM) - (Video) 2.17 Apply the Patch Set 10.2.0.3.0 to the ASM Home - (Video) 2.18 Install Oracle Database 10gR2 Software - 10.2.0.1.0 - (Video) 2.19 Install Oracle Database 10g Companion CD Software - (Video) 2.20 Apply the Patch set 10.2.0.3.0 to Oracle Home - (Video) 2.21 Create TNS Listener Process - (Video) 2.22 Create ASM Instance - (Video) 2.23 Install the EM agent on each cluster node - (Video) 2.23.1 Pre-Installation Requirements - (Video) 2.23.2 Download Oracle Management Agent (10.2.0.5) - (Video) 2.23.3 Install Management Agent (10.2.0.5) in RAC Environment - (Video) 2.23.4 Verify Agent Status - () 2.23.5 Secure the Management Agent if necessary - () 2.24 Create a Cluster Database - (Video) 2.25 Post-Installation Tasks - (Optional) - (Video) 2.25.1 Re-compile Invalid Objects - (Video) 2.25.2 Enabling Archive Logs and Flashback in a RAC Environment - (Video) 2.25.3 Create Shared Oracle Password Files - (Video) 2.26 Verify TNS Networking Files - (Video) 2.27 Create / Alter Tablespaces - () 2.28 Verify the RAC Cluster & Database Configuration - (Video) 2.29 Configuring the Initialization Parameters - (Video) 2.30 Startup / Shutdown the Oracle RAC 10gR2 - ()
Views: 314 Yongcheng Lai
02.13_Oracle_10gR2_RACDG_2.13 Pre-Installation Tasks for Oracle 10g Release 2(2012_01_13).flv
 
03:33
Oracle 10g/11g RAC, DataGuard, GoldenGate,Streams Hands-on Practices Training. Please feel free to contact me: E-mail/Skype: [email protected] 1. Building an Oracle RAC 10gR2 for RAC Primary 1.1 Install Linux OS(CentOS 5.3) - () 1.2 Install Required Linux Packages for Oracle RAC- (Video) 1.3 Network Configuration - (Video) 1.4 Create "oracle" User and Directories - (Video) 1.5 Configure the Linux Servers for Oracle - (Video) 1.6 Configure the "hangcheck-timer" Kernel Module - (Video) 1.7 Configure RAC Nodes for Remote Access using SSH - (Video) 1.8 IP SAN Configuration - Openfiler - () 1.9 Install Openfiler - SAN - () 1.10 Configure iSCSI Volumes using openfiler - (Video) 1.11 Configure iSCSI Volumes on Oracle RAC Nodes - (Video) 1.12 Install and configure Oracle Cluster File System(OCFS2)- (Video) 1.13 Install and Configure ASM (ASMLib2.0) - (Video) 1.14 Download Oracle RAC 10g Software - (Video) 1.15 Pre-Installation Tasks for Oracle 10g Release 2- (Video) 1.16 Install Oracle Clusterware 10g - 10.2.0.1.0 - (Video) 1.17 Upgrade Oracle Clusterware from 10.2.0.1.0 to 10.2.0.3.0 - (Video) 1.18 Install and configure Automatic Storage Management (ASM) - (Video) 1.19 Apply the Patch Set 10.2.0.3.0 to the ASM Home - (Video) 1.20 Install Oracle Database 10gR2 Software - 10.2.0.1.0 - (Video) 1.21 Install Oracle Database 10g Companion CD Software - (Video) 1.22 Apply the Patch set 10.2.0.3.0 to Oracle Home - (Video) 1.23 Create TNS Listener Process - (Video) 1.24 Create ASM Instance - (Video) 1.25 Install the EM agent on each cluster node - (Video) 1.25.1 Pre-Installation Requirements - (Video) 1.25.2 Download Oracle Management Agent (10.2.0.5) - (Video) 1.25.3 Install Management Agent (10.2.0.5) in RAC Environment - (Video) 1.25.4 Verify Agent Status - (Video) 1.25.5 Secure the Management Agent if necessary - (Video) 1.26 Create a Cluster Database - (Video) 1.27 Post-Installation Tasks - (Optional) - (Video) 1.27.1 Re-compile Invalid Objects - (Video) 1.27.2 Enabling Archive Logs and Flashback in a RAC Environment - (Video) 1.27.3 Create Shared Oracle Password Files - (Video) 1.28 Verify TNS Networking Files - (Video) 1.29 Create / Alter Tablespaces - () 1.30 Verify the RAC Cluster & Database Configuration - (Video) 1.31 Configuring the Initialization Parameters - (Video) 1.32 Startup / Shutdown the Oracle RAC 10gR2 - (Video) 1.32.1 Stopping the Oracle RAC 10g Environment - (Video) 1.32.2 Start Monitor the alert.log - () 1.32.3 Start the Oracle RAC 10g - () 2. Building an Oracle RAC 10gR2 for RAC Standby 2.1 Install Linux OS(CentOS 5.3) - () 2.2 Install Required Linux Packages for Oracle RAC - (Video) 2.3 Network Configuration - (Video) 2.4 Create "oracle" User and Directories - (Video) 2.5 Configure the Linux Servers for Oracle - (Video) 2.6 Configure the "hangcheck-timer" Kernel Module - (Video) 2.7 Configure RAC Nodes for Remote Access using SSH - (Video) 2.8 Configure iSCSI Volumes using openfiler - (Video) 2.9 Configure iSCSI Volumes on Oracle RAC Nodes - (Video) 2.10 Install and configure Oracle Cluster File System(OCFS2) - (Video) 2.11 Install and Configure ASM (ASMLib2.0) - (Video) 2.12 Download Oracle RAC 10g Software - (Video) 2.13 Pre-Installation Tasks for Oracle 10g Release 2 - (Video) 2.14 Install Oracle Clusterware 10g - 10.2.0.1.0 - (Video) 2.15 Upgrade Oracle Clusterware from 10.2.0.1.0 to 10.2.0.3.0 - (Video) 2.16 Install and configure Automatic Storage Management (ASM) - (Video) 2.17 Apply the Patch Set 10.2.0.3.0 to the ASM Home - (Video) 2.18 Install Oracle Database 10gR2 Software - 10.2.0.1.0 - (Video) 2.19 Install Oracle Database 10g Companion CD Software - (Video) 2.20 Apply the Patch set 10.2.0.3.0 to Oracle Home - (Video) 2.21 Create TNS Listener Process - (Video) 2.22 Create ASM Instance - (Video) 2.23 Install the EM agent on each cluster node - (Video) 2.23.1 Pre-Installation Requirements - (Video) 2.23.2 Download Oracle Management Agent (10.2.0.5) - (Video) 2.23.3 Install Management Agent (10.2.0.5) in RAC Environment - (Video) 2.23.4 Verify Agent Status - () 2.23.5 Secure the Management Agent if necessary - () 2.24 Create a Cluster Database - (Video) 2.25 Post-Installation Tasks - (Optional) - (Video) 2.25.1 Re-compile Invalid Objects - (Video) 2.25.2 Enabling Archive Logs and Flashback in a RAC Environment - (Video) 2.25.3 Create Shared Oracle Password Files - (Video) 2.26 Verify TNS Networking Files - (Video) 2.27 Create / Alter Tablespaces - () 2.28 Verify the RAC Cluster & Database Configuration - (Video) 2.29 Configuring the Initialization Parameters - (Video) 2.30 Startup / Shutdown the Oracle RAC 10gR2 - ()
Views: 335 Yongcheng Lai
01.25.02_Oracle_10gR2_RACDG_1.25.2 Download Oracle Management Agent (10.2.0.5)(2012_01_12).flv
 
01:28
Oracle 10g/11g RAC, DataGuard, GoldenGate,Streams Hands-on Practices Training. Please feel free to contact me: E-mail/Skype: [email protected] 1. Building an Oracle RAC 10gR2 for RAC Primary 1.1 Install Linux OS(CentOS 5.3) - () 1.2 Install Required Linux Packages for Oracle RAC- (Video) 1.3 Network Configuration - (Video) 1.4 Create "oracle" User and Directories - (Video) 1.5 Configure the Linux Servers for Oracle - (Video) 1.6 Configure the "hangcheck-timer" Kernel Module - (Video) 1.7 Configure RAC Nodes for Remote Access using SSH - (Video) 1.8 IP SAN Configuration - Openfiler - () 1.9 Install Openfiler - SAN - () 1.10 Configure iSCSI Volumes using openfiler - (Video) 1.11 Configure iSCSI Volumes on Oracle RAC Nodes - (Video) 1.12 Install and configure Oracle Cluster File System(OCFS2)- (Video) 1.13 Install and Configure ASM (ASMLib2.0) - (Video) 1.14 Download Oracle RAC 10g Software - (Video) 1.15 Pre-Installation Tasks for Oracle 10g Release 2- (Video) 1.16 Install Oracle Clusterware 10g - 10.2.0.1.0 - (Video) 1.17 Upgrade Oracle Clusterware from 10.2.0.1.0 to 10.2.0.3.0 - (Video) 1.18 Install and configure Automatic Storage Management (ASM) - (Video) 1.19 Apply the Patch Set 10.2.0.3.0 to the ASM Home - (Video) 1.20 Install Oracle Database 10gR2 Software - 10.2.0.1.0 - (Video) 1.21 Install Oracle Database 10g Companion CD Software - (Video) 1.22 Apply the Patch set 10.2.0.3.0 to Oracle Home - (Video) 1.23 Create TNS Listener Process - (Video) 1.24 Create ASM Instance - (Video) 1.25 Install the EM agent on each cluster node - (Video) 1.25.1 Pre-Installation Requirements - (Video) 1.25.2 Download Oracle Management Agent (10.2.0.5) - (Video) 1.25.3 Install Management Agent (10.2.0.5) in RAC Environment - (Video) 1.25.4 Verify Agent Status - (Video) 1.25.5 Secure the Management Agent if necessary - (Video) 1.26 Create a Cluster Database - (Video) 1.27 Post-Installation Tasks - (Optional) - (Video) 1.27.1 Re-compile Invalid Objects - (Video) 1.27.2 Enabling Archive Logs and Flashback in a RAC Environment - (Video) 1.27.3 Create Shared Oracle Password Files - (Video) 1.28 Verify TNS Networking Files - (Video) 1.29 Create / Alter Tablespaces - () 1.30 Verify the RAC Cluster & Database Configuration - (Video) 1.31 Configuring the Initialization Parameters - (Video) 1.32 Startup / Shutdown the Oracle RAC 10gR2 - (Video) 1.32.1 Stopping the Oracle RAC 10g Environment - (Video) 1.32.2 Start Monitor the alert.log - () 1.32.3 Start the Oracle RAC 10g - () 2. Building an Oracle RAC 10gR2 for RAC Standby 2.1 Install Linux OS(CentOS 5.3) - () 2.2 Install Required Linux Packages for Oracle RAC - (Video) 2.3 Network Configuration - (Video) 2.4 Create "oracle" User and Directories - (Video) 2.5 Configure the Linux Servers for Oracle - (Video) 2.6 Configure the "hangcheck-timer" Kernel Module - (Video) 2.7 Configure RAC Nodes for Remote Access using SSH - (Video) 2.8 Configure iSCSI Volumes using openfiler - (Video) 2.9 Configure iSCSI Volumes on Oracle RAC Nodes - (Video) 2.10 Install and configure Oracle Cluster File System(OCFS2) - (Video) 2.11 Install and Configure ASM (ASMLib2.0) - (Video) 2.12 Download Oracle RAC 10g Software - (Video) 2.13 Pre-Installation Tasks for Oracle 10g Release 2 - (Video) 2.14 Install Oracle Clusterware 10g - 10.2.0.1.0 - (Video) 2.15 Upgrade Oracle Clusterware from 10.2.0.1.0 to 10.2.0.3.0 - (Video) 2.16 Install and configure Automatic Storage Management (ASM) - (Video) 2.17 Apply the Patch Set 10.2.0.3.0 to the ASM Home - (Video) 2.18 Install Oracle Database 10gR2 Software - 10.2.0.1.0 - (Video) 2.19 Install Oracle Database 10g Companion CD Software - (Video) 2.20 Apply the Patch set 10.2.0.3.0 to Oracle Home - (Video) 2.21 Create TNS Listener Process - (Video) 2.22 Create ASM Instance - (Video) 2.23 Install the EM agent on each cluster node - (Video) 2.23.1 Pre-Installation Requirements - (Video) 2.23.2 Download Oracle Management Agent (10.2.0.5) - (Video) 2.23.3 Install Management Agent (10.2.0.5) in RAC Environment - (Video) 2.23.4 Verify Agent Status - () 2.23.5 Secure the Management Agent if necessary - () 2.24 Create a Cluster Database - (Video) 2.25 Post-Installation Tasks - (Optional) - (Video) 2.25.1 Re-compile Invalid Objects - (Video) 2.25.2 Enabling Archive Logs and Flashback in a RAC Environment - (Video) 2.25.3 Create Shared Oracle Password Files - (Video) 2.26 Verify TNS Networking Files - (Video) 2.27 Create / Alter Tablespaces - () 2.28 Verify the RAC Cluster & Database Configuration - (Video) 2.29 Configuring the Initialization Parameters - (Video) 2.30 Startup / Shutdown the Oracle RAC 10gR2 - ()
Views: 168 Yongcheng Lai
01.21_Oracle_10gR2_RACDG_1.21 Install Oracle Database 10g Companion CD Software(2012_01_12).flv
 
04:18
Oracle 10g/11g RAC, DataGuard, GoldenGate,Streams Hands-on Practices Training. Please feel free to contact me: E-mail/Skype: [email protected] 1. Building an Oracle RAC 10gR2 for RAC Primary 1.1 Install Linux OS(CentOS 5.3) - () 1.2 Install Required Linux Packages for Oracle RAC- (Video) 1.3 Network Configuration - (Video) 1.4 Create "oracle" User and Directories - (Video) 1.5 Configure the Linux Servers for Oracle - (Video) 1.6 Configure the "hangcheck-timer" Kernel Module - (Video) 1.7 Configure RAC Nodes for Remote Access using SSH - (Video) 1.8 IP SAN Configuration - Openfiler - () 1.9 Install Openfiler - SAN - () 1.10 Configure iSCSI Volumes using openfiler - (Video) 1.11 Configure iSCSI Volumes on Oracle RAC Nodes - (Video) 1.12 Install and configure Oracle Cluster File System(OCFS2)- (Video) 1.13 Install and Configure ASM (ASMLib2.0) - (Video) 1.14 Download Oracle RAC 10g Software - (Video) 1.15 Pre-Installation Tasks for Oracle 10g Release 2- (Video) 1.16 Install Oracle Clusterware 10g - 10.2.0.1.0 - (Video) 1.17 Upgrade Oracle Clusterware from 10.2.0.1.0 to 10.2.0.3.0 - (Video) 1.18 Install and configure Automatic Storage Management (ASM) - (Video) 1.19 Apply the Patch Set 10.2.0.3.0 to the ASM Home - (Video) 1.20 Install Oracle Database 10gR2 Software - 10.2.0.1.0 - (Video) 1.21 Install Oracle Database 10g Companion CD Software - (Video) 1.22 Apply the Patch set 10.2.0.3.0 to Oracle Home - (Video) 1.23 Create TNS Listener Process - (Video) 1.24 Create ASM Instance - (Video) 1.25 Install the EM agent on each cluster node - (Video) 1.25.1 Pre-Installation Requirements - (Video) 1.25.2 Download Oracle Management Agent (10.2.0.5) - (Video) 1.25.3 Install Management Agent (10.2.0.5) in RAC Environment - (Video) 1.25.4 Verify Agent Status - (Video) 1.25.5 Secure the Management Agent if necessary - (Video) 1.26 Create a Cluster Database - (Video) 1.27 Post-Installation Tasks - (Optional) - (Video) 1.27.1 Re-compile Invalid Objects - (Video) 1.27.2 Enabling Archive Logs and Flashback in a RAC Environment - (Video) 1.27.3 Create Shared Oracle Password Files - (Video) 1.28 Verify TNS Networking Files - (Video) 1.29 Create / Alter Tablespaces - () 1.30 Verify the RAC Cluster & Database Configuration - (Video) 1.31 Configuring the Initialization Parameters - (Video) 1.32 Startup / Shutdown the Oracle RAC 10gR2 - (Video) 1.32.1 Stopping the Oracle RAC 10g Environment - (Video) 1.32.2 Start Monitor the alert.log - () 1.32.3 Start the Oracle RAC 10g - () 2. Building an Oracle RAC 10gR2 for RAC Standby 2.1 Install Linux OS(CentOS 5.3) - () 2.2 Install Required Linux Packages for Oracle RAC - (Video) 2.3 Network Configuration - (Video) 2.4 Create "oracle" User and Directories - (Video) 2.5 Configure the Linux Servers for Oracle - (Video) 2.6 Configure the "hangcheck-timer" Kernel Module - (Video) 2.7 Configure RAC Nodes for Remote Access using SSH - (Video) 2.8 Configure iSCSI Volumes using openfiler - (Video) 2.9 Configure iSCSI Volumes on Oracle RAC Nodes - (Video) 2.10 Install and configure Oracle Cluster File System(OCFS2) - (Video) 2.11 Install and Configure ASM (ASMLib2.0) - (Video) 2.12 Download Oracle RAC 10g Software - (Video) 2.13 Pre-Installation Tasks for Oracle 10g Release 2 - (Video) 2.14 Install Oracle Clusterware 10g - 10.2.0.1.0 - (Video) 2.15 Upgrade Oracle Clusterware from 10.2.0.1.0 to 10.2.0.3.0 - (Video) 2.16 Install and configure Automatic Storage Management (ASM) - (Video) 2.17 Apply the Patch Set 10.2.0.3.0 to the ASM Home - (Video) 2.18 Install Oracle Database 10gR2 Software - 10.2.0.1.0 - (Video) 2.19 Install Oracle Database 10g Companion CD Software - (Video) 2.20 Apply the Patch set 10.2.0.3.0 to Oracle Home - (Video) 2.21 Create TNS Listener Process - (Video) 2.22 Create ASM Instance - (Video) 2.23 Install the EM agent on each cluster node - (Video) 2.23.1 Pre-Installation Requirements - (Video) 2.23.2 Download Oracle Management Agent (10.2.0.5) - (Video) 2.23.3 Install Management Agent (10.2.0.5) in RAC Environment - (Video) 2.23.4 Verify Agent Status - () 2.23.5 Secure the Management Agent if necessary - () 2.24 Create a Cluster Database - (Video) 2.25 Post-Installation Tasks - (Optional) - (Video) 2.25.1 Re-compile Invalid Objects - (Video) 2.25.2 Enabling Archive Logs and Flashback in a RAC Environment - (Video) 2.25.3 Create Shared Oracle Password Files - (Video) 2.26 Verify TNS Networking Files - (Video) 2.27 Create / Alter Tablespaces - () 2.28 Verify the RAC Cluster & Database Configuration - (Video) 2.29 Configuring the Initialization Parameters - (Video) 2.30 Startup / Shutdown the Oracle RAC 10gR2 - ()
Views: 169 Yongcheng Lai
01.22_Oracle_10gR2_RACDG_1.22 Apply the Patch set 10.2.0.3.0 to Oracle Home(2012_01_12).flv
 
11:32
Oracle 10g/11g RAC, DataGuard, GoldenGate,Streams Hands-on Practices Training. Please feel free to contact me: E-mail/Skype: [email protected] 1. Building an Oracle RAC 10gR2 for RAC Primary 1.1 Install Linux OS(CentOS 5.3) - () 1.2 Install Required Linux Packages for Oracle RAC- (Video) 1.3 Network Configuration - (Video) 1.4 Create "oracle" User and Directories - (Video) 1.5 Configure the Linux Servers for Oracle - (Video) 1.6 Configure the "hangcheck-timer" Kernel Module - (Video) 1.7 Configure RAC Nodes for Remote Access using SSH - (Video) 1.8 IP SAN Configuration - Openfiler - () 1.9 Install Openfiler - SAN - () 1.10 Configure iSCSI Volumes using openfiler - (Video) 1.11 Configure iSCSI Volumes on Oracle RAC Nodes - (Video) 1.12 Install and configure Oracle Cluster File System(OCFS2)- (Video) 1.13 Install and Configure ASM (ASMLib2.0) - (Video) 1.14 Download Oracle RAC 10g Software - (Video) 1.15 Pre-Installation Tasks for Oracle 10g Release 2- (Video) 1.16 Install Oracle Clusterware 10g - 10.2.0.1.0 - (Video) 1.17 Upgrade Oracle Clusterware from 10.2.0.1.0 to 10.2.0.3.0 - (Video) 1.18 Install and configure Automatic Storage Management (ASM) - (Video) 1.19 Apply the Patch Set 10.2.0.3.0 to the ASM Home - (Video) 1.20 Install Oracle Database 10gR2 Software - 10.2.0.1.0 - (Video) 1.21 Install Oracle Database 10g Companion CD Software - (Video) 1.22 Apply the Patch set 10.2.0.3.0 to Oracle Home - (Video) 1.23 Create TNS Listener Process - (Video) 1.24 Create ASM Instance - (Video) 1.25 Install the EM agent on each cluster node - (Video) 1.25.1 Pre-Installation Requirements - (Video) 1.25.2 Download Oracle Management Agent (10.2.0.5) - (Video) 1.25.3 Install Management Agent (10.2.0.5) in RAC Environment - (Video) 1.25.4 Verify Agent Status - (Video) 1.25.5 Secure the Management Agent if necessary - (Video) 1.26 Create a Cluster Database - (Video) 1.27 Post-Installation Tasks - (Optional) - (Video) 1.27.1 Re-compile Invalid Objects - (Video) 1.27.2 Enabling Archive Logs and Flashback in a RAC Environment - (Video) 1.27.3 Create Shared Oracle Password Files - (Video) 1.28 Verify TNS Networking Files - (Video) 1.29 Create / Alter Tablespaces - () 1.30 Verify the RAC Cluster & Database Configuration - (Video) 1.31 Configuring the Initialization Parameters - (Video) 1.32 Startup / Shutdown the Oracle RAC 10gR2 - (Video) 1.32.1 Stopping the Oracle RAC 10g Environment - (Video) 1.32.2 Start Monitor the alert.log - () 1.32.3 Start the Oracle RAC 10g - () 2. Building an Oracle RAC 10gR2 for RAC Standby 2.1 Install Linux OS(CentOS 5.3) - () 2.2 Install Required Linux Packages for Oracle RAC - (Video) 2.3 Network Configuration - (Video) 2.4 Create "oracle" User and Directories - (Video) 2.5 Configure the Linux Servers for Oracle - (Video) 2.6 Configure the "hangcheck-timer" Kernel Module - (Video) 2.7 Configure RAC Nodes for Remote Access using SSH - (Video) 2.8 Configure iSCSI Volumes using openfiler - (Video) 2.9 Configure iSCSI Volumes on Oracle RAC Nodes - (Video) 2.10 Install and configure Oracle Cluster File System(OCFS2) - (Video) 2.11 Install and Configure ASM (ASMLib2.0) - (Video) 2.12 Download Oracle RAC 10g Software - (Video) 2.13 Pre-Installation Tasks for Oracle 10g Release 2 - (Video) 2.14 Install Oracle Clusterware 10g - 10.2.0.1.0 - (Video) 2.15 Upgrade Oracle Clusterware from 10.2.0.1.0 to 10.2.0.3.0 - (Video) 2.16 Install and configure Automatic Storage Management (ASM) - (Video) 2.17 Apply the Patch Set 10.2.0.3.0 to the ASM Home - (Video) 2.18 Install Oracle Database 10gR2 Software - 10.2.0.1.0 - (Video) 2.19 Install Oracle Database 10g Companion CD Software - (Video) 2.20 Apply the Patch set 10.2.0.3.0 to Oracle Home - (Video) 2.21 Create TNS Listener Process - (Video) 2.22 Create ASM Instance - (Video) 2.23 Install the EM agent on each cluster node - (Video) 2.23.1 Pre-Installation Requirements - (Video) 2.23.2 Download Oracle Management Agent (10.2.0.5) - (Video) 2.23.3 Install Management Agent (10.2.0.5) in RAC Environment - (Video) 2.23.4 Verify Agent Status - () 2.23.5 Secure the Management Agent if necessary - () 2.24 Create a Cluster Database - (Video) 2.25 Post-Installation Tasks - (Optional) - (Video) 2.25.1 Re-compile Invalid Objects - (Video) 2.25.2 Enabling Archive Logs and Flashback in a RAC Environment - (Video) 2.25.3 Create Shared Oracle Password Files - (Video) 2.26 Verify TNS Networking Files - (Video) 2.27 Create / Alter Tablespaces - () 2.28 Verify the RAC Cluster & Database Configuration - (Video) 2.29 Configuring the Initialization Parameters - (Video) 2.30 Startup / Shutdown the Oracle RAC 10gR2 - ()
Views: 623 Yongcheng Lai
01.04_Oracle_10gR2_RACDG_1.4 Create oracle User and Directories(2012_01_12).flv
 
05:18
Oracle 10g/11g RAC, DataGuard, GoldenGate,Streams Hands-on Practices Training. Please feel free to contact me: E-mail/Skype: [email protected] 1. Building an Oracle RAC 10gR2 for RAC Primary 1.1 Install Linux OS(CentOS 5.3) - () 1.2 Install Required Linux Packages for Oracle RAC- (Video) 1.3 Network Configuration - (Video) 1.4 Create "oracle" User and Directories - (Video) 1.5 Configure the Linux Servers for Oracle - (Video) 1.6 Configure the "hangcheck-timer" Kernel Module - (Video) 1.7 Configure RAC Nodes for Remote Access using SSH - (Video) 1.8 IP SAN Configuration - Openfiler - () 1.9 Install Openfiler - SAN - () 1.10 Configure iSCSI Volumes using openfiler - (Video) 1.11 Configure iSCSI Volumes on Oracle RAC Nodes - (Video) 1.12 Install and configure Oracle Cluster File System(OCFS2)- (Video) 1.13 Install and Configure ASM (ASMLib2.0) - (Video) 1.14 Download Oracle RAC 10g Software - (Video) 1.15 Pre-Installation Tasks for Oracle 10g Release 2- (Video) 1.16 Install Oracle Clusterware 10g - 10.2.0.1.0 - (Video) 1.17 Upgrade Oracle Clusterware from 10.2.0.1.0 to 10.2.0.3.0 - (Video) 1.18 Install and configure Automatic Storage Management (ASM) - (Video) 1.19 Apply the Patch Set 10.2.0.3.0 to the ASM Home - (Video) 1.20 Install Oracle Database 10gR2 Software - 10.2.0.1.0 - (Video) 1.21 Install Oracle Database 10g Companion CD Software - (Video) 1.22 Apply the Patch set 10.2.0.3.0 to Oracle Home - (Video) 1.23 Create TNS Listener Process - (Video) 1.24 Create ASM Instance - (Video) 1.25 Install the EM agent on each cluster node - (Video) 1.25.1 Pre-Installation Requirements - (Video) 1.25.2 Download Oracle Management Agent (10.2.0.5) - (Video) 1.25.3 Install Management Agent (10.2.0.5) in RAC Environment - (Video) 1.25.4 Verify Agent Status - (Video) 1.25.5 Secure the Management Agent if necessary - (Video) 1.26 Create a Cluster Database - (Video) 1.27 Post-Installation Tasks - (Optional) - (Video) 1.27.1 Re-compile Invalid Objects - (Video) 1.27.2 Enabling Archive Logs and Flashback in a RAC Environment - (Video) 1.27.3 Create Shared Oracle Password Files - (Video) 1.28 Verify TNS Networking Files - (Video) 1.29 Create / Alter Tablespaces - () 1.30 Verify the RAC Cluster & Database Configuration - (Video) 1.31 Configuring the Initialization Parameters - (Video) 1.32 Startup / Shutdown the Oracle RAC 10gR2 - (Video) 1.32.1 Stopping the Oracle RAC 10g Environment - (Video) 1.32.2 Start Monitor the alert.log - () 1.32.3 Start the Oracle RAC 10g - () 2. Building an Oracle RAC 10gR2 for RAC Standby 2.1 Install Linux OS(CentOS 5.3) - () 2.2 Install Required Linux Packages for Oracle RAC - (Video) 2.3 Network Configuration - (Video) 2.4 Create "oracle" User and Directories - (Video) 2.5 Configure the Linux Servers for Oracle - (Video) 2.6 Configure the "hangcheck-timer" Kernel Module - (Video) 2.7 Configure RAC Nodes for Remote Access using SSH - (Video) 2.8 Configure iSCSI Volumes using openfiler - (Video) 2.9 Configure iSCSI Volumes on Oracle RAC Nodes - (Video) 2.10 Install and configure Oracle Cluster File System(OCFS2) - (Video) 2.11 Install and Configure ASM (ASMLib2.0) - (Video) 2.12 Download Oracle RAC 10g Software - (Video) 2.13 Pre-Installation Tasks for Oracle 10g Release 2 - (Video) 2.14 Install Oracle Clusterware 10g - 10.2.0.1.0 - (Video) 2.15 Upgrade Oracle Clusterware from 10.2.0.1.0 to 10.2.0.3.0 - (Video) 2.16 Install and configure Automatic Storage Management (ASM) - (Video) 2.17 Apply the Patch Set 10.2.0.3.0 to the ASM Home - (Video) 2.18 Install Oracle Database 10gR2 Software - 10.2.0.1.0 - (Video) 2.19 Install Oracle Database 10g Companion CD Software - (Video) 2.20 Apply the Patch set 10.2.0.3.0 to Oracle Home - (Video) 2.21 Create TNS Listener Process - (Video) 2.22 Create ASM Instance - (Video) 2.23 Install the EM agent on each cluster node - (Video) 2.23.1 Pre-Installation Requirements - (Video) 2.23.2 Download Oracle Management Agent (10.2.0.5) - (Video) 2.23.3 Install Management Agent (10.2.0.5) in RAC Environment - (Video) 2.23.4 Verify Agent Status - () 2.23.5 Secure the Management Agent if necessary - () 2.24 Create a Cluster Database - (Video) 2.25 Post-Installation Tasks - (Optional) - (Video) 2.25.1 Re-compile Invalid Objects - (Video) 2.25.2 Enabling Archive Logs and Flashback in a RAC Environment - (Video) 2.25.3 Create Shared Oracle Password Files - (Video) 2.26 Verify TNS Networking Files - (Video) 2.27 Create / Alter Tablespaces - () 2.28 Verify the RAC Cluster & Database Configuration - (Video) 2.29 Configuring the Initialization Parameters - (Video) 2.30 Startup / Shutdown the Oracle RAC 10gR2 - ()
Views: 142 Yongcheng Lai
01.18_Oracle_10gR2_RACDG_1.18 Install and configure  ASM
 
12:31
Oracle 10g/11g RAC, DataGuard, GoldenGate,Streams Hands-on Practices Training. Please feel free to contact me: E-mail/Skype: [email protected] 1. Building an Oracle RAC 10gR2 for RAC Primary 1.1 Install Linux OS(CentOS 5.3) - () 1.2 Install Required Linux Packages for Oracle RAC- (Video) 1.3 Network Configuration - (Video) 1.4 Create "oracle" User and Directories - (Video) 1.5 Configure the Linux Servers for Oracle - (Video) 1.6 Configure the "hangcheck-timer" Kernel Module - (Video) 1.7 Configure RAC Nodes for Remote Access using SSH - (Video) 1.8 IP SAN Configuration - Openfiler - () 1.9 Install Openfiler - SAN - () 1.10 Configure iSCSI Volumes using openfiler - (Video) 1.11 Configure iSCSI Volumes on Oracle RAC Nodes - (Video) 1.12 Install and configure Oracle Cluster File System(OCFS2)- (Video) 1.13 Install and Configure ASM (ASMLib2.0) - (Video) 1.14 Download Oracle RAC 10g Software - (Video) 1.15 Pre-Installation Tasks for Oracle 10g Release 2- (Video) 1.16 Install Oracle Clusterware 10g - 10.2.0.1.0 - (Video) 1.17 Upgrade Oracle Clusterware from 10.2.0.1.0 to 10.2.0.3.0 - (Video) 1.18 Install and configure Automatic Storage Management (ASM) - (Video) 1.19 Apply the Patch Set 10.2.0.3.0 to the ASM Home - (Video) 1.20 Install Oracle Database 10gR2 Software - 10.2.0.1.0 - (Video) 1.21 Install Oracle Database 10g Companion CD Software - (Video) 1.22 Apply the Patch set 10.2.0.3.0 to Oracle Home - (Video) 1.23 Create TNS Listener Process - (Video) 1.24 Create ASM Instance - (Video) 1.25 Install the EM agent on each cluster node - (Video) 1.25.1 Pre-Installation Requirements - (Video) 1.25.2 Download Oracle Management Agent (10.2.0.5) - (Video) 1.25.3 Install Management Agent (10.2.0.5) in RAC Environment - (Video) 1.25.4 Verify Agent Status - (Video) 1.25.5 Secure the Management Agent if necessary - (Video) 1.26 Create a Cluster Database - (Video) 1.27 Post-Installation Tasks - (Optional) - (Video) 1.27.1 Re-compile Invalid Objects - (Video) 1.27.2 Enabling Archive Logs and Flashback in a RAC Environment - (Video) 1.27.3 Create Shared Oracle Password Files - (Video) 1.28 Verify TNS Networking Files - (Video) 1.29 Create / Alter Tablespaces - () 1.30 Verify the RAC Cluster & Database Configuration - (Video) 1.31 Configuring the Initialization Parameters - (Video) 1.32 Startup / Shutdown the Oracle RAC 10gR2 - (Video) 1.32.1 Stopping the Oracle RAC 10g Environment - (Video) 1.32.2 Start Monitor the alert.log - () 1.32.3 Start the Oracle RAC 10g - () 2. Building an Oracle RAC 10gR2 for RAC Standby 2.1 Install Linux OS(CentOS 5.3) - () 2.2 Install Required Linux Packages for Oracle RAC - (Video) 2.3 Network Configuration - (Video) 2.4 Create "oracle" User and Directories - (Video) 2.5 Configure the Linux Servers for Oracle - (Video) 2.6 Configure the "hangcheck-timer" Kernel Module - (Video) 2.7 Configure RAC Nodes for Remote Access using SSH - (Video) 2.8 Configure iSCSI Volumes using openfiler - (Video) 2.9 Configure iSCSI Volumes on Oracle RAC Nodes - (Video) 2.10 Install and configure Oracle Cluster File System(OCFS2) - (Video) 2.11 Install and Configure ASM (ASMLib2.0) - (Video) 2.12 Download Oracle RAC 10g Software - (Video) 2.13 Pre-Installation Tasks for Oracle 10g Release 2 - (Video) 2.14 Install Oracle Clusterware 10g - 10.2.0.1.0 - (Video) 2.15 Upgrade Oracle Clusterware from 10.2.0.1.0 to 10.2.0.3.0 - (Video) 2.16 Install and configure Automatic Storage Management (ASM) - (Video) 2.17 Apply the Patch Set 10.2.0.3.0 to the ASM Home - (Video) 2.18 Install Oracle Database 10gR2 Software - 10.2.0.1.0 - (Video) 2.19 Install Oracle Database 10g Companion CD Software - (Video) 2.20 Apply the Patch set 10.2.0.3.0 to Oracle Home - (Video) 2.21 Create TNS Listener Process - (Video) 2.22 Create ASM Instance - (Video) 2.23 Install the EM agent on each cluster node - (Video) 2.23.1 Pre-Installation Requirements - (Video) 2.23.2 Download Oracle Management Agent (10.2.0.5) - (Video) 2.23.3 Install Management Agent (10.2.0.5) in RAC Environment - (Video) 2.23.4 Verify Agent Status - () 2.23.5 Secure the Management Agent if necessary - () 2.24 Create a Cluster Database - (Video) 2.25 Post-Installation Tasks - (Optional) - (Video) 2.25.1 Re-compile Invalid Objects - (Video) 2.25.2 Enabling Archive Logs and Flashback in a RAC Environment - (Video) 2.25.3 Create Shared Oracle Password Files - (Video) 2.26 Verify TNS Networking Files - (Video) 2.27 Create / Alter Tablespaces - () 2.28 Verify the RAC Cluster & Database Configuration - (Video) 2.29 Configuring the Initialization Parameters - (Video) 2.30 Startup / Shutdown the Oracle RAC 10gR2 - ()
Views: 216 Yongcheng Lai