Home
Search results “Checkpoint oracle alter”
when checkpoint will occur in oracle database
 
14:13
How to check current_scn number of database? ============================================= select CURRENT_SCN from v$database; select dbms_flashback.get_system_change_number from dual; select timestamp_to_scn(sysdate) from dual; how to check datafile header scn number? ========================================= select name,CHECKPOINT_CHANGE# from v$datafile_header; when checkpoint will occur? ============================ alter system switch logfile; alter database begin backup; alter database end backup; alter system checkpoint;(manual checkpoint) shutdown immediate;(when the database is down) what will happen when checkpoint occurs? ========================================= scn of datafile header will update;
Views: 3713 Praveen Biyyapu
how to take  hot backup of database manually
 
07:37
can we take hot backup when the database is in noarchive log mode? =================================================================== no archive log list; alter database begin backup; can we shutdown a database when it is in backup mode? ===================================================== alter database begin backup; shutdown immediate; ==no shutdown normal;==no shutdown transcational;==no shutdown abort;==yes database is in hot backup mode,db crashes now how to recover and open the database? =================================================================================== alter databse begin backup; shutdown abort; ORA-10873: file 1 needs to be either taken out of backup mode or media recovered ORA-01110: data file 1: 'E:\DATABASE\DATABASE\ORADATA\ORCL\SYSTEM01.DBF' solution: startup mount; alter database end backup; alter database open; how to check whether the database is in backup mode or not? =========================================================== select * from v$backup; how to take hot backup of database manually? ============================================ alter database begin backup; copy datafiles manually from original location to backup location alter database end backup; alter system switch logfile; alter system switch logfile; alter system switch logfile; copy archives from archive location to backup location. alter database backup controlfile to trace; (or) alter database backup controlfile to location; copy controlfile to backup location. How to check current_scn number of database? ============================================= select CURRENT_SCN from v$database; select dbms_flashback.get_system_change_number from dual; select timestamp_to_scn(sysdate) from dual; how to check datafile header scn number? ========================================= select name,CHECKPOINT_CHANGE# from v$datafile_header; when checkpoint will occur? ============================ alter system switch logfile; alter database begin backup; alter database end backup; alter system checkpoint;(manual checkpoint) shutdown immediate;(when the database is down) what will happen when checkpoint occurs? ========================================= scn of datafile header will update;
Views: 2064 Praveen Biyyapu
System Change Number in Oracle Database - SCN - DBArch Video 26
 
02:45
In this video you will understand what is System Change Number in an Oracle Database, and get to know about some of the uses of it. . 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: 5409 Ramkumar Swaminathan
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: 5215 Praveen Biyyapu
Backup Full - Oracle
 
27:16
Esse vídeo tem com objetivo mostrar como fazer um backup full do banco de dados oracle usando o Oracle Recovery Manager-RMAN. run{ allocate channel c1 device type disk; allocate channel c2 device type disk; allocate channel c3 device type disk; sql 'alter system switch logfile'; sql 'alter system switch logfile'; sql 'alter system switch logfile'; sql 'alter system checkpoint'; backup as compressed backupset full database tag 'Full_Banco' format '/home/oracle/backup/Full_banco-%T-%I-%d-%s.bkp'; backup current controlfile tag 'CTF_FULL' format '/home/oracle/backup/CTF_FULL-%T-%I-%d-%s.bkp'; backup as compressed backupset spfile tag 'SPF_FULL' format '/home/oracle/backup/SPF_FULL-%T-%I-%d-%s.bkp'; backup as compressed backupset archivelog all delete all input tag 'ARCH_FULL' format '/home/oracle/backup/ARCH_FULL-%T-%I-%d-%s.bkp'; }
Views: 1443 Target Database
how to start and stop oracle database
 
05:17
startup and shutdown modes of oracle database startup - it will startup database to read write mode. shutdown - normal shutdown. startup mount; -- maintenace mode. startup nomount; - it reads the pfile. alter database mount; - maintenance mode. alter database open; - it opens the database to read write mode. shutdown ========== alter database close; alter database dismount; shutdown; startup force; - it will shutdown and restart database (note: not recommende :)) it is like restart option in windows o/s select name,open_mode from v$database;
Views: 4193 Praveen Biyyapu
Recreating Datafile when no backup but all archives available in Oracle (Media Recovery)
 
19:01
By Vivek Saxena Shabad Coachings Recreating Datafile when having no backup but having all archives since its creation
can we take hot backup when the database is in noarchive log mode
 
03:42
can we take hot backup when the database is in noarchive log mode? =================================================================== no archive log list; alter database begin backup; can we shutdown a database when it is in backup mode? ===================================================== alter database begin backup; shutdown immediate; ==no shutdown normal;==no shutdown transcational;==no shutdown abort;==yes database is in hot backup mode,db crashes now how to recover and open the database? =================================================================================== alter databse begin backup; shutdown abort; ORA-10873: file 1 needs to be either taken out of backup mode or media recovered ORA-01110: data file 1: 'E:\DATABASE\DATABASE\ORADATA\ORCL\SYSTEM01.DBF' solution: startup mount; alter database end backup; alter database open; how to check whether the database is in backup mode or not? =========================================================== select * from v$backup; how to take hot backup of database manually? ============================================ alter database begin backup; copy datafiles manually from original location to backup location alter database end backup; alter system switch logfile; alter system switch logfile; alter system switch logfile; copy archives from archive location to backup location. alter database backup controlfile to trace; (or) alter database backup controlfile to location; copy controlfile to backup location. How to check current_scn number of database? ============================================= select CURRENT_SCN from v$database; select dbms_flashback.get_system_change_number from dual; select timestamp_to_scn(sysdate) from dual; how to check datafile header scn number? ========================================= select name,CHECKPOINT_CHANGE# from v$datafile_header; when checkpoint will occur? ============================ alter system switch logfile; alter database begin backup; alter database end backup; alter system checkpoint;(manual checkpoint) shutdown immediate;(when the database is down) what will happen when checkpoint occurs? ========================================= scn of datafile header will update;
Views: 345 Praveen Biyyapu
Oracle Profile Creations and Users
 
18:27
Oracle Profile Creations and users creating with examples
Views: 84 lalitha tpt
Checkpoint Revalidate
 
02:28
The REVALIDATE option regenerates the table headers for a partitioned table or uncompressed join index and optionally verifies and corrects the row partitioning for a table (but not for a join index) if you specify the WITH DELETE or WITH INSERT null partition handling options. You can specify the REVALIDATE option for unpartitioned tables and join indexes without also specifying PRIMARY INDEX. This makes revalidation applicable whether or not the table or join index has a primary index. You must specify the REVALIDATE option without also specifying PRIMARY INDEX for NoPI tables and column‑partitioned tables and join indexes. Otherwise, Teradata Database aborts the request and returns an error to the requestor. The REVALIDATE option also provides the ability to revalidate some data dictionary columns. REVALIDATE requests do not verify the column partitioning of a column‑partitioned table or join index. If partitioning errors are detected for a table (but not a join index), an ALTER TABLE REVALIDATE request corrects them. REVALIDATE also revalidates the following Data Dictionary table columns. wave web technology was established in 2012, and has a dynamic team of professional web developers, web designers, SEO experts and customer support . website : www.wavewebtech.com https://www.facebook.com/wavewebtechnologies https://twitter.com/wavewebtechnolo https://plus.google.com/collections/
Views: 6 vikas verma
Transacciones y Checkpoint
 
10:16
Se ejecutan varias transacciones y se comprueba si estas han sido guardadas o no, dependiendo del Checkpoint. Comandos usados: - sqlplus user/pass - alter system checkpoint - execute insertar - sudo killall -s 9 oracle - sudo service oracle-xe force-reload Diagrama: https://dl.dropboxusercontent.com/u/66451173/Bases%202/Tarea%202/Trans.png Database: https://dl.dropboxusercontent.com/u/66451173/Bases%202/Tarea%202/database.sql Procedure: https://dl.dropboxusercontent.com/u/66451173/Bases%202/Tarea%202/procedure.sql Julio César Osorio Boror 201020177
Views: 177 Julio Osorio
ORACLE SQL 33: Rollback & Commit
 
05:15
http://studyandshare.wordpress.com/ http://www.facebook.com/groups/studyandsharevn/
Views: 942 studyandsharevn
How to run VBScript programs !! Database Training Training ! Infotek-SolutionInc
 
02:26
For Complete Database Training Details Visit: http://www.qaonlinetraining.com http://infotek-solutions.com/ Delivery Method: Instructor led classroom and Online Training supported by world class Learning management system which automate all flow of lectures, videos, assignments, forums, quizzes and interview process. Class Schedule: Week-ends and Weekdays Contact Us: 571-437-0652, Mail Us: [email protected] Training Locations at : Ashburn / Fairfax / Maryland Office Address: 12801 Worldgate Dr #500, Herndon, VA 20170 Overview of Oracle DBA Training Oracle as a flexible, complex & robust RDBMS The evolution of hardware and the relation to Oracle Different DBA job roles (VP of DBA, developer DBA, production DBA, database babysitter) The changing job role of the Oracle DBA Environment management (network, CPU, disk and RAM) Instance management (managing SGA regions) Oracle table and index management Instance Architecture Instance vs. database Components of an instance Creating the OFA file structure ($DBA, bdump, udump, pfile) Oracle Instance Internals SGA vs. PGA Background processes Interfaces with server and disk I/O subsystem Using SQL*Plus for DBA management Connecting and executing SQL Using the “as sysdba” syntax Overview of SQL*Plus DBA commands (startup, etc.) Control file, UNDO and REDO management Explaining the use of control files Listing the Contents of the control File File locations for control Files Obtaining Control File Information Listing control file contents Displaying and Creating Undo segments Altering Undo Segments Determining the Number and Size of Undo segments Understanding flashback technology Troubleshooting Undo – snapshot too old Redo log concepts for recovery Online redo log (log_buffer) online redo logs and archived redo logs Oracle ARCH and LGWR background processes Redo log dictionary queries Redo log switch frequency and performance Multiplexing the Online Redo Log Files Archiving the Oracle Redo Logs Recovery using the redo log files User and privilege management The three security methods (VPD, Grant security/role-based security, grant execute) Creating New Database Users Using pre-spawned Oracle connections Auditing User activity Identifying System and Object Privileges Granting and Revoking Privileges Creating and Modifying Roles Displaying user security Information from the Data Dictionary Overview of instance management Parameter files (init.ora, listener.ora, tnsnames.ora) Rules for sizing SGA components Automated Oracle memory management (AMM) Initialization file management Creating the init.ora file Using spfile Displaying init.ora values with v$parameter Oracle*Net configuration Creating the listener.ora file Creating the tnsnames.ora file Data buffer configuration & sizing Inside the Oracle data buffers Using the KEEP pool Monitoring buffer effectiveness Using multiple blocksizes (multiple buffer pools) Shared pool and PGA configuration & Sizing Shared pool concepts and components Understanding the library cache Relieving shared pool contention Overview of PGA for sorting and hash joins Using sort_area_size, hash_area_size and pga_aggregate_target Troubleshooting network connectivity Verifying network connectivity with ping and tnsping Testing database links Oracle tables, views and materialized views Types of Oracle tables (regular, IOT, sorted hash clusters, nested tables) Oracle Views Oracle materialized views Oracle indexes Types of Oracle indexes (b-tree, bitmap, bitmap join index) Creating B*-Tree, bitmap and function-based Indexes Function-based indexes Finding indexing opportunities Index maintenance Oracle constraints Costs & benefits of constraints Types of Oracle indexes constraints (check, not null, unique, PK, FK) Cascading constraints Schema, File & tablespace management Describing the relationship between data files, tablespaces and table Understanding Oracle segments Creating Tablespaces – using the autoextend option Changing the Size of Tablespaces – alter database datafile command Defining a TEMP tablespace Changing the default storage Settings for a tablespace Review of the storage parameters in DBA views (ASM, ASSM, pctfree, pctused and freelists). Monitoring Chained rows (fetch continued rows) Monitoring Insert and Update performance (pctused, APPEND) Database Maintenance Reason for reorgs – chained rows, imbalanced freelists Reorganizing Tables using Export and Import Using CTAS to reorganize data Index rebuilding Backup & Recovery overview (hot & cold Backups, RMAN, block change tracking) Oracle DBA Utilities Data pump (Imp and exp utilities) SQL*Loader LogMiner Flashback DataGuard Oracle DBA utilities – Oracle dbms packages (dbms_redefinition)
Team NZ's use of cyclists was 'significant'   Todd Niall: RNZ Checkpoint
 
04:17
RNZ reporter Todd Niall has been in Bermuda since the America's Cup competition began. He told John Campbell what it was like to be there when Team New Zealand won.
Views: 3527 RNZ
database is in hot backup mode,db crashes now how to recover and open the database
 
04:06
can we take hot backup when the database is in noarchive log mode? =================================================================== no archive log list; alter database begin backup; can we shutdown a database when it is in backup mode? ===================================================== alter database begin backup; shutdown immediate; ==no shutdown normal;==no shutdown transcational;==no shutdown abort;==yes database is in hot backup mode,db crashes now how to recover and open the database? =================================================================================== alter databse begin backup; shutdown abort; ORA-10873: file 1 needs to be either taken out of backup mode or media recovered ORA-01110: data file 1: 'E:\DATABASE\DATABASE\ORADATA\ORCL\SYSTEM01.DBF' solution: startup mount; alter database end backup; alter database open; how to check whether the database is in backup mode or not? =========================================================== select * from v$backup; how to take hot backup of database manually? ============================================ alter database begin backup; copy datafiles manually from original location to backup location alter database end backup; alter system switch logfile; alter system switch logfile; alter system switch logfile; copy archives from archive location to backup location. alter database backup controlfile to trace; (or) alter database backup controlfile to location; copy controlfile to backup location. How to check current_scn number of database? ============================================= select CURRENT_SCN from v$database; select dbms_flashback.get_system_change_number from dual; select timestamp_to_scn(sysdate) from dual; how to check datafile header scn number? ========================================= select name,CHECKPOINT_CHANGE# from v$datafile_header; when checkpoint will occur? ============================ alter system switch logfile; alter database begin backup; alter database end backup; alter system checkpoint;(manual checkpoint) shutdown immediate;(when the database is down) what will happen when checkpoint occurs? ========================================= scn of datafile header will update;
Views: 834 Praveen Biyyapu
Oracle DBA Queries   Database status, uptime , SIZE OF DATABASE
 
02:50
oracle dba queries Startup time How large is the database Distribution of objects and data Which sachems are taking up all of the space Show the ten largest objects in the database
Views: 1723 Praveen Biyyapu
Oracle Database tablespace,  Datafile and control files
 
22:43
Oracle tablespace are logical containers of datafiles. Datafiles are physical files which contains data stored in binary format. Control file contains information about the database and the datafile location as well as checkpoint information
Views: 190 joey de jesus
HOW TO DISABLE USER PASSWORD SENSITIVITY IN ORACLE 11G
 
04:55
HOW TO DISABLE USER PASSWORD SENSITIVITY IN ORACLE 11G ======================================================= show parameter sec_case_sensitive_logon alter system set sec_case_sensitive_logon=false; create user pavan identified by pavan; grant connect,resource to pavan;
Views: 305 Praveen Biyyapu
reset log on oracle server
 
06:41
reset log on oracle server
Views: 310 Jamaal Khan
Validate the database using Database checkpoint and using ADODB object in VBScript and UFT
 
01:12:31
This video explains about how to validate the database using Database Checkpoint of UFT and using ADODB object of VBScript/UFT. For detail information and usage of ADODB object, watch my next video related to ADODB object.
Views: 928 nanda.D Reddy
QTP Test Cases / Check point / QTP Online Tutorial
 
23:24
=========================== WELCOME TO H2K INFOSYS IT Staff Augmentation, Job placement assistance, Tech Support IT Training for corporate & Individuals, Fast track IT Training & Job placement assistance for OPT / MS graduates in USA Software Design, Development, QA Testing, Performance Testing & Support H2K Infosys is a one stop global online software training institution that offers a huge portfolio of software online training and onsite training in technological areas such as Software QA Testing (QA), Business Analysis (BA), HP QTP, HP LoadRunner, WebServices, Java, J2EE, Microsoft C# and ASP .NET, Oracle DBA to name a few. These online software training courses are designed for Individuals, and employees of forward thinking companies and other organizations to acquire, maintain, optimize and validate their IT skills. "With the changing trends in the market, innovation is the key to stay ahead" - H2Kinfosys provides software training with latest technologies to meet the current job market. H2Kinfosys is developing software projects for the current and future generations in Education, Healthcare, Finance, Supply chain, CRM, Hospitality, Cloud and Telecom domains. Why H2K..? 100% Job Oriented Instructor Led Face2Face True Live online Software Training with Cloud Test Lab to practice on Software Tools and Live Project work. Resume Prep & Review, Mock Interviews and Job Placement assistance. More interaction with student to faculty and student to student. Detailed presentations. Soft copy of Materiel to refer any time. Practical oriented / Job oriented Training. Practice on Software Tools & Real Time project scenarios. Weekly mock interviews / group discussions / interview related questions. Test Lab is in Cloud Technology - to practice on software tools. Pay onetime fee & repeat / re attending classes multiple times until student is comfortable with every topic. This feature is helpful to students who are new to I.T. Field. Depends on the batch schedule and student convenient, Student can repeat Weekend or Weekday batches and review the topic multiple times. QA Testing training is 80+ hours. We discuss about the real time project domains in Banking/Financial, Telecom, Supply Chain Management, CRM, Health care and other domains. We provide Recorded Videos for every class to review before and after the live class. The teaching methods / tools / topics we chosen are based on the current competitive job market. Visit http://www.h2kinfosys.com/advantages. QA Testing Training Course Highlights Module 1:Manual Testing Software Testing Life Cycle,SDLC,Waterfall vs. Agile QA Tester Role,Test Metrics,Types of Testing Software Testing Life Cycle,STLC,Defect Life Cycle Testing Methodologies,Software Testing process Test case,Test plan,RTM,Defect tracking Home works,Telecom,Banking,HealthCare,Supply chain domains. Role of QA,BA,Developer,Technical Architects etc. Module 2:HP Quality Center - ALM for Test management/ Defect Tracking Module 3:SQL (Database/Back End Testing) Module 4:UNIX / Linux Operating System/Backend Testing Module 5:HP QTP (Quick Test Professional) for Automation Testing Module 6:HP Loadrunner for Performance Testing Module 7:Review & questions on all topics,Configuration Management,CMMI,Six Sigma principles,Requirement (e.g. Sarbanes Oxley,HIPPA-Medical related),Interview Questions. How to prepare professional resume? Module 8: IBM Mainframe Testing Module 9: SAP Testing (Sales & Distribution (SD),Production Planning or CRM Or any one of the SAP) Module 10: WebServices (SOA) Testing using SoapUI tool Module 11: ETL and Data warehouse Testing Module 12: IBM Rational Quality Manager (RQM) Tool (It was Rational Test Manager)
Views: 210 Rao HTwoKInfosys
can we shutdown a database when it is in backup mode
 
02:28
can we take hot backup when the database is in noarchive log mode? =================================================================== no archive log list; alter database begin backup; can we shutdown a database when it is in backup mode? ===================================================== alter database begin backup; shutdown immediate; ==no shutdown normal;==no shutdown transcational;==no shutdown abort;==yes database is in hot backup mode,db crashes now how to recover and open the database? =================================================================================== alter databse begin backup; shutdown abort; ORA-10873: file 1 needs to be either taken out of backup mode or media recovered ORA-01110: data file 1: 'E:\DATABASE\DATABASE\ORADATA\ORCL\SYSTEM01.DBF' solution: startup mount; alter database end backup; alter database open; how to check whether the database is in backup mode or not? =========================================================== select * from v$backup; how to take hot backup of database manually? ============================================ alter database begin backup; copy datafiles manually from original location to backup location alter database end backup; alter system switch logfile; alter system switch logfile; alter system switch logfile; copy archives from archive location to backup location. alter database backup controlfile to trace; (or) alter database backup controlfile to location; copy controlfile to backup location. How to check current_scn number of database? ============================================= select CURRENT_SCN from v$database; select dbms_flashback.get_system_change_number from dual; select timestamp_to_scn(sysdate) from dual; how to check datafile header scn number? ========================================= select name,CHECKPOINT_CHANGE# from v$datafile_header; when checkpoint will occur? ============================ alter system switch logfile; alter database begin backup; alter database end backup; alter system checkpoint;(manual checkpoint) shutdown immediate;(when the database is down) what will happen when checkpoint occurs? ========================================= scn of datafile header will update;
Views: 331 Praveen Biyyapu
Catalog rman Parte 2
 
15:13
Conectar no Catálogo do rman [[email protected] ~]$ rman target / catalog rcat/[email protected] Listar os scripts LIST ALL SCRIPT NAMES; Criando um script local: CREATE script COMANDO_SQL{sql 'alter system switch logfile'; } Criando um script global: CREATE global script BACKUP_DO_BANCO{ allocate channel c1 device type disk; allocate channel c2 device type disk; allocate channel c3 device type disk; sql 'alter system switch logfile'; sql 'alter system switch logfile'; sql 'alter system switch logfile'; sql 'alter system checkpoint'; backup as compressed backupset full database tag 'Full_Banco' format '/home/oracle/backup/Full_banco-%T-%I-%d-%s.bkp'; backup current controlfile tag 'CTF_FULL' format '/home/oracle/backup/CTF_FULL-%T-%I-%d-%s.bkp'; backup as compressed backupset spfile tag 'SPF_FULL' format '/home/oracle/backup/SPF_FULL-%T-%I-%d-%s.bkp'; backup as compressed backupset archivelog all delete all input tag 'ARCH_FULL' format '/home/oracle/backup/ARCH_FULL-%T-%I-%d-%s.bkp'; } Executando o script criado com a sintaxe run {execute script BACKUP_DO_BANCO;} Visualizar um script no Catalog Rman: print script BACKUP_DO_BANCO; Deletar script do Catálogo delete script BACKUP_DO_BANCO; delete script COMANDO_SQL; Executando os script do Catálogo rman target / catalog rcat/[email protected] script 'BACKUP_DO_BANCO' rman target / catalog rcat/[email protected] script 'BACKUP_DO_BANCO' msglog /home/oracle/backup/rman_bkp_diario-$dthora.log
Views: 263 Target Database
Oracle GoldenGate data replication
 
22:09
#goldengate #oracle #replication #12c ==========хэрэгтэй коммандууд================= select log_mode from v$database; alter database add supplemental log data; add extract ext1, tranlog, begin now add exttrail /gg/dirdat/tr, extract ext1 edit params ext1 extract ext1 userid ggate, password oracle TRANLOGOPTIONS DBLOGREADER exttrail /dirdat/tr table ub.*; add extract pump1, exttrailub /gg/dirdat/tr , begin now add rmttrail /gg/dirdat/tr, extract pump1 edit params pump1 EXTRACT pump1 USERID ggate, PASSWORD oracle RMTHOST db2, MGRPORT 15002 RMTTRAIL /gg/dirdat/tr PASSTHRU table ub.*; ================darkhan=================== EDIT PARAMS ./GLOBALS CHECKPOINTTABLE darkhan.checkpoint add checkpointtable darkhan.checkpoint add replicat rep1, exttrail /gg/dirdat/tr, begin now, checkpointtable darkhan.checkpoint edit params rep1 REPLICAT rep1 ASSUMETARGETDEFS USERID darkhan, PASSWORD oracle map ub.*, target darkhan.*; Mongolian Oracle Database Administrators Community - www.batmunkh.net
Views: 551 ORACLOUD
Error Handling In Informatica
 
22:02
This Video Helps you to understand the ERROR handling in informatica. Its Very Important to every Developer to know this. Watch it and let me know your comments.
Views: 44685 VolentQue Technologies
How to Resolve Oracle SQL Parent Key Not Found (ORA-02291)
 
05:49
In this video, we’ll explain what the ORA-02291 “parent key not found” error is, see an example, and look at how to resolve it. This error usually happens when we try to insert data into a table. It looks like this: Error is: ORA-02291: integrity constraint (constraint_name) violated - parent key not found So what does this error mean? It means we’re trying to insert data into a child table, and there is no related record in the parent table. If a foreign key has been set up to enforce this relationship, there needs to be a parent to insert a child that refers to it. Watch the video to see an example of this error as well as how to resolve it. For more information on Oracle SQL, refer to the Database Star website here: https://www.databasestar.com/
Views: 3446 Database Star
Creating Basic Ad Hoc Reports in Smart View
 
05:08
In this tutorial you learn how to use ad-hoc analysis to create reports and analyze data in Smart View for Oracle Enterprise Performance Reporting Cloud Service.
Views: 56622 Oracle EPM Tutorials
Team NZ cycled their way to victory: RNZ Checkpoint
 
04:35
Four cycle grinders peddled so hard to secure the America's Cup, that Simon Van Velthooven had a pulse rate of 190. His father Paul joins Checkpoint.
Views: 2144 RNZ
#15 SAP ASE 16 Learning-Overview of Automatic Recovery
 
28:18
SAP ASE 16 Learning Part 15 Overview of Automatic Recovery. To Learn or Teach Linux visit www.theskillpedia.com, A Marketplace for Learners and Trainers. Session 15 Overview of Automatic Recovery Ram N Sangwan Tracking Database Changes SAP ASE uses transactions to keep track of all database changes. A transaction consists of one or more Transact-SQL statements that succeed—or fail—as a unit. Each SQL statement that modifies data is considered a transaction. Users can also define transactions by enclosing a series of statements within a begin transaction...end transaction block. Each database has its own transaction log, the system table syslogs. You cannot turn off transaction logging. Tracking Database Changes Contd Automatic Recovery The checkpoint Command Example Writes all dirty pages in the current database to the database device: checkpoint Setting the Recovery Interval Automatic Checkpoint Procedure To see the checkpoint task, execute sp_who. The checkpoint task usually appears as “CHECKPOINT SLEEP” in the “cmd” column. Truncating the Log After Automatic Checkpoints Fast Recovery SAP ASE Start-up Sequence Bringing Engines Back Online Engines are brought online after system databases are recovered, and before user databases, allowing user databases to be recovered in parallel, and makes the engines available for online activities. Engines are brought online in this fashion only during start-up. In all other circumstances, such as failover, engines are already online on the secondary server. Parallel Recovery Databases are recovered in parallel by multiple recovery tasks during start-up and failover. Database recovery is an I/O-intensive process. The time to recover SAP ASE with parallel recovery depends on the bandwidth of the underlying I/O subsystem. The I/O subsystem should be able to handle SAP ASE concurrent I/O requests. With parallel recovery, multiple tasks recover user databases concurrently. The number of recovery tasks is dependent on the configuration parameter max concurrently recovered db. The default value of 0 indicates that SAP ASE adopts a self-tuning approach. During parallel recovery, the system administrator can force serial recovery by setting max concurrently recovered db to 1 Database Recovery When recovery completes, the original configuration values are restored. Specifying the Recovery Order Specifying the Recovery Order Contd.. sp_dbrecovery_order pubs2, 2, force Changing or Deleting the Recovery Position sp_dbrecovery_order pubs2, -1 sp_dbrecovery_order pubs2, 1, "force" Listing the User-Assigned Recovery Order Parallel Checkpoints Recovery State Tuning for Fast Recovery Thank You
Views: 4299 TheSkillPedia
How to Recover (Reset) the Linux Root Password:  Linux Server Training 101
 
05:58
http://www.soundtraining.net/linux-server-training-101 If you've ever lost or forgotten the password to your Linux computer, this Linux tutorial video will show you exactly how to reset it. Using common password recovery procedures, you will learn how to boot your Linux system into single-user mode by modifying GRUB, then reset your root password. This video is based on CentOS version 6, but applies to most RedHat-based systems.
Views: 105031 soundtraining.net
HP QTP Tutorial 2| HP UFT Tutorial 2 | QTP UFT DataBase connection| QTP Tutorials for Beginners
 
19:05
HP QTP Tutorial 2| HP UFT Tutorial 2 | QTP UFT DataBase connection| QTP Tutorials for Beginners | H2kinfosys HP Unified Functional Testing,HP ServiceTest,VB Script QTP 11.5 is named now as UFT UFT = Unified Functional Testing = HP QTP + HP Service Test (ST) HP Unified Functional Testing 11.5 =========================== WELCOME TO H2K INFOSYS IT Staff Augmentation, Job placement assistance, Tech Support IT Training for corporate & Individuals, Fast track IT Training & Job placement assistance for OPT / MS graduates in USA Software Design, Development, QA Testing, Performance Testing & Support H2K Infosys is a one stop global online software training institution that offers a huge portfolio of software online training and onsite training in technological areas such as Software QA Testing (QA), Business Analysis (BA), HP QTP, HP LoadRunner, WebServices, Java, J2EE, Microsoft C# and ASP .NET, Oracle DBA to name a few. These online software training courses are designed for Individuals, and employees of forward thinking companies and other organizations to acquire, maintain, optimize and validate their IT skills. "With the changing trends in the market, innovation is the key to stay ahead" - H2Kinfosys provides software training with latest technologies to meet the current job market. H2Kinfosys is developing software projects for the current and future generations in Education, Healthcare, Finance, Supply chain, CRM, Hospitality, Cloud and Telecom domains. Why H2K..? 100% Job Oriented Instructor Led Face2Face True Live online Software Training with Cloud Test Lab to practice on Software Tools and Live Project work. Resume Prep & Review, Mock Interviews and Job Placement assistance. More interaction with student to faculty and student to student. Detailed presentations. Soft copy of Materiel to refer any time. Practical oriented / Job oriented Training. Practice on Software Tools & Real Time project scenarios. Weekly mock interviews / group discussions / interview related questions. Test Lab is in Cloud Technology - to practice on software tools. Pay onetime fee & repeat / re attending classes multiple times until student is comfortable with every topic. This feature is helpful to students who are new to I.T. Field. Depends on the batch schedule and student convenient, Student can repeat Weekend or Weekday batches and review the topic multiple times. QA Testing training is 80+ hours. We discuss about the real time project domains in Banking/Financial, Telecom, Supply Chain Management, CRM, Health care and other domains. We provide Recorded Videos for every class to review before and after the live class. The teaching methods / tools / topics we chosen are based on the current competitive job market. Visit http://www.h2kinfosys.com/advantages. QA Testing Training Course Highlights Module 1:Manual Testing Software Testing Life Cycle,SDLC,Waterfall vs. Agile QA Tester Role,Test Metrics,Types of Testing Software Testing Life Cycle,STLC,Defect Life Cycle Testing Methodologies,Software Testing process Test case,Test plan,RTM,Defect tracking Home works,Telecom,Banking,HealthCare,Supply chain domains. Role of QA,BA,Developer,Technical Architects etc. Module 2:HP Quality Center - ALM for Test management/ Defect Tracking Module 3:SQL (Database/Back End Testing) Module 4:UNIX / Linux Operating System/Backend Testing Module 5:HP QTP (Quick Test Professional) for Automation Testing Module 6:HP Loadrunner for Performance Testing Module 7:Review & questions on all topics,Configuration Management,CMMI,Six Sigma principles,Requirement (e.g. Sarbanes Oxley,HIPPA-Medical related),Interview Questions. How to prepare professional resume? Module 8: IBM Mainframe Testing Module 9: SAP Testing (Sales & Distribution (SD),Production Planning or CRM Or any one of the SAP) Module 10: WebServices (SOA) Testing using SoapUI tool Module 11: ETL and Data warehouse Testing Module 12: IBM Rational Quality Manager (RQM) Tool (It was Rational Test Manager)
Views: 8225 Rao HTwoKInfosys
58 - Spring. Переключение локали
 
13:29
Лектор: Тимур Батыршинов (http://javabegin.ru). Ссылки из урока:  http://docs.oracle.com/javase/tutorial/i18n/locale/index.html  http://docs.oracle.com/javase/7/docs/api/java/util/Locale.html
Views: 2339 Roman Brovko
QTP Testing Case / Check point Example / QTP Online Training | QTP Tutorials
 
21:02
QTP Testing Case / Check point Example / QTP Online Training | QTP Tutorials for Beginners =========================== WELCOME TO H2K INFOSYS IT Staff Augmentation, Job placement assistance, Tech Support IT Training for corporate & Individuals, Fast track IT Training & Job placement assistance for OPT / MS graduates in USA Software Design, Development, QA Testing, Performance Testing & Support H2K Infosys is a one stop global online software training institution that offers a huge portfolio of software online training and onsite training in technological areas such as Software QA Testing (QA), Business Analysis (BA), HP QTP, HP LoadRunner, WebServices, Java, J2EE, Microsoft C# and ASP .NET, Oracle DBA to name a few. These online software training courses are designed for Individuals, and employees of forward thinking companies and other organizations to acquire, maintain, optimize and validate their IT skills. "With the changing trends in the market, innovation is the key to stay ahead" - H2Kinfosys provides software training with latest technologies to meet the current job market. H2Kinfosys is developing software projects for the current and future generations in Education, Healthcare, Finance, Supply chain, CRM, Hospitality, Cloud and Telecom domains. Why H2K..? 100% Job Oriented Instructor Led Face2Face True Live online Software Training with Cloud Test Lab to practice on Software Tools and Live Project work. Resume Prep & Review, Mock Interviews and Job Placement assistance. More interaction with student to faculty and student to student. Detailed presentations. Soft copy of Materiel to refer any time. Practical oriented / Job oriented Training. Practice on Software Tools & Real Time project scenarios. Weekly mock interviews / group discussions / interview related questions. Test Lab is in Cloud Technology - to practice on software tools. Pay onetime fee & repeat / re attending classes multiple times until student is comfortable with every topic. This feature is helpful to students who are new to I.T. Field. Depends on the batch schedule and student convenient, Student can repeat Weekend or Weekday batches and review the topic multiple times. QA Testing training is 80+ hours. We discuss about the real time project domains in Banking/Financial, Telecom, Supply Chain Management, CRM, Health care and other domains. We provide Recorded Videos for every class to review before and after the live class. The teaching methods / tools / topics we chosen are based on the current competitive job market. Visit http://www.h2kinfosys.com/advantages. QA Testing Training Course Highlights Module 1:Manual Testing Software Testing Life Cycle,SDLC,Waterfall vs. Agile QA Tester Role,Test Metrics,Types of Testing Software Testing Life Cycle,STLC,Defect Life Cycle Testing Methodologies,Software Testing process Test case,Test plan,RTM,Defect tracking Home works,Telecom,Banking,HealthCare,Supply chain domains. Role of QA,BA,Developer,Technical Architects etc. Module 2:HP Quality Center - ALM for Test management/ Defect Tracking Module 3:SQL (Database/Back End Testing) Module 4:UNIX / Linux Operating System/Backend Testing Module 5:HP QTP (Quick Test Professional) for Automation Testing Module 6:HP Loadrunner for Performance Testing Module 7:Review & questions on all topics,Configuration Management,CMMI,Six Sigma principles,Requirement (e.g. Sarbanes Oxley,HIPPA-Medical related),Interview Questions. How to prepare professional resume? Module 8: IBM Mainframe Testing Module 9: SAP Testing (Sales & Distribution (SD),Production Planning or CRM Or any one of the SAP) Module 10: WebServices (SOA) Testing using SoapUI tool Module 11: ETL and Data warehouse Testing Module 12: IBM Rational Quality Manager (RQM) Tool (It was Rational Test Manager)
Views: 1615 Rao HTwoKInfosys
Recruit great talent. Red Hat certifications
 
02:35
Learn how Red Hat certifications show employers that you've proven your skills with Red Hat products. Secure-24 looks for Red Hat Certified Professionals when hiring new talent. Want to earn your Red Hat certification? Learn more at http://red.ht/187fEA6 Connect with the Red Hat Training and Consulting experts: Facebook: http://on.fb.me/187gD3a LinkedIn: http://linkd.in/191NGFv
Views: 59139 Red Hat Videos
QTP Videos,Checkpoints | How To Modify Value in QTP | HP UFT | QTP Inerview questions | QuickTestPro
 
07:40
=========================== WELCOME TO H2K INFOSYS IT Staff Augmentation, Job placement assistance, Tech Support IT Training for corporate & Individuals, Fast track IT Training & Job placement assistance for OPT / MS graduates in USA Software Design, Development, QA Testing, Performance Testing & Support H2K Infosys is a one stop global online software training institution that offers a huge portfolio of software online training and onsite training in technological areas such as Software QA Testing (QA), Business Analysis (BA), HP QTP, HP LoadRunner, WebServices, Java, J2EE, Microsoft C# and ASP .NET, Oracle DBA to name a few. These online software training courses are designed for Individuals, and employees of forward thinking companies and other organizations to acquire, maintain, optimize and validate their IT skills. "With the changing trends in the market, innovation is the key to stay ahead" - H2Kinfosys provides software training with latest technologies to meet the current job market. H2Kinfosys is developing software projects for the current and future generations in Education, Healthcare, Finance, Supply chain, CRM, Hospitality, Cloud and Telecom domains. Why H2K..? 100% Job Oriented Instructor Led Face2Face True Live online Software Training with Cloud Test Lab to practice on Software Tools and Live Project work. Resume Prep & Review, Mock Interviews and Job Placement assistance. More interaction with student to faculty and student to student. Detailed presentations. Soft copy of Materiel to refer any time. Practical oriented / Job oriented Training. Practice on Software Tools & Real Time project scenarios. Weekly mock interviews / group discussions / interview related questions. Test Lab is in Cloud Technology - to practice on software tools. Pay onetime fee & repeat / re attending classes multiple times until student is comfortable with every topic. This feature is helpful to students who are new to I.T. Field. Depends on the batch schedule and student convenient, Student can repeat Weekend or Weekday batches and review the topic multiple times. QA Testing training is 80+ hours. We discuss about the real time project domains in Banking/Financial, Telecom, Supply Chain Management, CRM, Health care and other domains. We provide Recorded Videos for every class to review before and after the live class. The teaching methods / tools / topics we chosen are based on the current competitive job market. Visit http://www.h2kinfosys.com/advantages. QA Testing Training Course Highlights Module 1:Manual Testing Software Testing Life Cycle,SDLC,Waterfall vs. Agile QA Tester Role,Test Metrics,Types of Testing Software Testing Life Cycle,STLC,Defect Life Cycle Testing Methodologies,Software Testing process Test case,Test plan,RTM,Defect tracking Home works,Telecom,Banking,HealthCare,Supply chain domains. Role of QA,BA,Developer,Technical Architects etc. Module 2:HP Quality Center - ALM for Test management/ Defect Tracking Module 3:SQL (Database/Back End Testing) Module 4:UNIX / Linux Operating System/Backend Testing Module 5:HP QTP (Quick Test Professional) for Automation Testing Module 6:HP Loadrunner for Performance Testing Module 7:Review & questions on all topics,Configuration Management,CMMI,Six Sigma principles,Requirement (e.g. Sarbanes Oxley,HIPPA-Medical related),Interview Questions. How to prepare professional resume? Module 8: IBM Mainframe Testing Module 9: SAP Testing (Sales & Distribution (SD),Production Planning or CRM Or any one of the SAP) Module 10: WebServices (SOA) Testing using SoapUI tool Module 11: ETL and Data warehouse Testing Module 12: IBM Rational Quality Manager (RQM) Tool (It was Rational Test Manager)
Views: 722 Rao HTwoKInfosys
Adoring fans welcome America's Cup home
 
06:30
WEB: Thousands gathered in central Auckland to welcome Team New Zealand home after their triumph at the America's Cup in Bermuda. Checkpoint reporter Zac Fleming joined the crowd.
Views: 1475 RNZ
Oracle Data Guard Management
 
14:50
Oracle Data Guard Management
Views: 89 The Silent DBA
Manually Switching Active and Standby Namenodes
 
05:08
This video will explain how to switch the namenode status in HA enabled Name nodes By default zookeeper fail over controller will take care of this switching in case zookeeper goes down you can use manual steps hdfs haadmin -transitionToActive serviceId[--forceactive] hdfs haadmin -transitionToStandby serviceId hdfs haadmin -failover [--forcefence] [--forceactive] serviceId serviceId hdfs haadmin -getServiceState serviceId hdfs haadmin -getAllServiceState hdfs haadmin -checkHealth serviceId
Views: 531 Hadoop Engineering
Creating a Tablespace
 
18:09
Level: Basic/Intermediate Series: Database Tutorials Length of video: 18 minutes (use chapters noted below) Prerequisites: Installing Oracle Database 11g Express Edition tutorial Purpose of tutorial: This video is part of a series of tutorials that serve as an introduction to working with an Oracle database. This video explains the purpose of a tablespace. It explains how a tablespace (a logical object) is associated with a data file (a physical object). This is a form of "data independence," a feature of an RDBMS. Although this tutorial is presented in the context of Oracle Database, the principles generally apply to other relational systems. The general syntax used to create a tablespace is presented together with an example. Accessing meta data related to a tablespace and data file is also discussed. Chapter Markers: Create Tablespace Syntax 3:48 Create Tablespace Example 8:58 Examining Tablespace and Datafile Metadata 12:16
Apigee Up Close: Advanced API Monitoring for Connected Digital Experiences
 
49:06
Learn how to monitor APIs in real-time, precisely investigate issues, and fix them fast with minimum customer impact. We've also included a live demo of Apigee API Monitoring, and we answer these questions: Why whitebox monitoring over synthetic monitoring? How to reduce the mean-time-to-diagnosis of API issues? What are contextual alerts and how to use them?
Views: 565 apigee
WoW 35th Americas Cup Report #13 LVAC Day 3 May29 17 OutteridgevBurling disaster explained Much More
 
33:29
WoW AC Report featuring the controversial last mark rounding where leaders Artemis is penalised for Port-Starboard infringement (wrongly) the Chief Umpire is interviewed. Nathan Outteridge v Burling, Barker, Cammas, Minoprio, Ainslie, Cayard more Explaining: the races are copyright to thise who have either paid for or has been gifted to them by the ACRM. Therefore we cannot show them but will give you all the background and news so keep watching every day.
Views: 69491 Geoff Waller
America's Cup Sunday highlights
 
01:44
A two minute round up of races 3 and 4 of the America's Cup finals as Emirates Team New Zealand's speed dominates defenders Oracle Team USA
Views: 19630 Yachting World
Changing the Outgoing Rule in the Smoothwall Firewall | Firewall | Smoothwall
 
03:36
Changing the Outgoing rule in the firewall Inverness release onward
Views: 455 SmoothWallTV
ETNZ's Pedal Power Revolution
 
02:16
Bike on a boat? Here's the story behind the innovation. We're still pushing for the ultimate America's Cup performance, will you be following?
Views: 68474 EmiratesTeamNZ
Surface to Air Film
 
11:43
Join us as we go behind the scenes with Artemis Racing as they prepare to battle for the 35th America’s Cup and see how they’re using Altair’s simulation-driven design tools to develop incredible boats that will change the sport of sailing forever.
Views: 577972 Altair Engineering Inc
Man overboard in America's Cup - Nathan Outteridge
 
02:35
Artemis Racing skipper Nathan Outteridge explains his MOB in the America's Cup playoffs
Views: 66926 Yachting World
America's Cup: Vanquished Oracle crew join Team NZ celebrations 27 Jun, 2017
 
02:59
America's Cup: Vanquished Oracle crew join Team NZ celebrations 27 Jun, 2017 ---------------- A New Day is a compilation of the hottest trending articles on the web and re-reads into videos. If you like or support the channel or if you do not like it, do not hate it. thank you ! ▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬ I hope you enjoyed this A New Day ! Please Like, Share and Subscribe ! https://goo.gl/pz9gfF
Views: 420 意外的事實
Emirates Team New Zealand Feature - Cyclors
 
03:17
The cyclors at Emirates Team New Zealand, so- called because they are cycling sailors who provide the pedal power to generate the hydraulic pressure which drives the AC50 foiling cat.
Views: 5170 Toyota New Zealand
Hosts file (Hindi)
 
03:25
Following is the list of videos of Windows server 2016 administration course series 1 - What is virtualization and Oracle VM virtual box (Hindi) ? https://youtu.be/O4_lk05KJPk 2 - What is virtual machine (Hindi) ? https://youtu.be/PAxFY06JJ7E 3 - Installing oracle VM virtual box (Hindi) https://youtu.be/claYouOPiOY 4 - Downloading windows server 2016 iso (Hindi) https://youtu.be/LRyNnYWotI8 5 - Creating a virtual network with virtual box (Hindi) https://youtu.be/YXZnr-nZYWs 6 - Creating virtual machine with virtual box (Hindi) https://youtu.be/Z-1PDNNrG1I 7 - Configuring virtual machine to use ISO media (Hindi) https://youtu.be/ORoNBpMYR7Y 8 - Installing windows server 2016 (Hindi) https://youtu.be/QzKF4dhUmEI 9 - Basic configuration of windows server 2016 (Hindi) https://youtu.be/CXwJfU9zAQg 10 - How to use windows server 2016 (Hindi) https://youtu.be/K8bf8SmBVzA 11 - What is active directory (Hindi) ? https://youtu.be/cRlLdzm-43w 12 - Adding ADDS (Active Directory domain service) role in windows server 2016 (Hindi) https://youtu.be/aEhB3io5SqA 13 - Downloading windows 10 (Hindi) https://youtu.be/575MAdiY1Pw 14 - Installing windows 10 (Hindi) https://youtu.be/901SjqbwSPo 15 - Joining workstation to domain Hindi https://youtu.be/oQY2lzUaAPE 16 - What is DNS (Hindi) ? https://youtu.be/xb23w9n5quY 17 - what is DHCP (Hindi)? https://youtu.be/gU8U3-qpe0E 18 - Adding the DHCP (Dynamic Host Configuration Protocol) server role (Hindi) https://youtu.be/CEzYgu6bsI0 19 - DHCP Scope and exclusion (Hindi) https://youtu.be/LwSjwF6co_g 20 - DHCP Reservation (Hindi) https://youtu.be/ssx3AyMp8lI 21 - DNS in windows server 2016 (Hindi) https://youtu.be/a_SD9kMMcTs 22 - The hosts file in windows https://youtu.be/3RBMDS0BV2w 23 - Creating Zones and resource records (Hindi) https://youtu.be/_xMY-ySyQwQ 24 - Active directory users and computers (Hindi) https://youtu.be/UbFpDFmjnTM 25 - Understanding Organisational Unit and containers (Hindi) https://youtu.be/8h8xCk8e6aY 26 - Creating and managing users (Hindi) https://youtu.be/aW56GG3IGFU 27 - Groups and membership (Hindi) https://youtu.be/s833Mk-wsEM 28 - Saved queries in windows server 2016 (hindi) https://youtu.be/xpXRII2L3K4 29 - Group policy in windows server 2016 (hindi) https://youtu.be/FyyiXfXY0II
Views: 280 Compital
2015 Nissan Armada - Fluid Check Point
 
01:24
"These maintenance items should be checked periodically. A good time to do it is when you refuel or check the engine oil. ● Transmission Fluid – When checking or replacing your transmission fluid, we recommend seeing your Nissan dealer for servicing. Only use the fluid specified on the caution label in the engine compartment or see your Owner’s Manual for specific transmission fluid information. Use of any other fluid could damage the transmission. ● Battery Fluid – Check the fluid level in each cell, making sure it is between the MAXIMUM and MINIMUM lines. ● Brake Fluid – Make sure its level is between the fill lines. ● Engine Coolant – Check this level when the engine is off and the fluid is cold. ● Engine Oil – Check your engine oil while parked on a level surface after waiting ten minutes for the oil to return to the oil pan. ● Power Steering Fluid – Check this when the engine is off and the fluid is cold. ● Windshield Washer Fluid – Check from time to time to see that there is an ample supply of fluid in the reservoir. Please see your Owner’s Manual for important safety information, system limitations and additional operating information. "