Home
Search results “Oracle set process parameter”
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: 5223 Praveen Biyyapu
Why are Kernel parameters critical for Oracle Database
 
16:53
Learn more about Kernel parameters with a case study. It's awesome to see how SHMMAX parameter effects a process on UNIX. Liked it? Subscribe to our channel now !!! Look at the complete blog at www.orskl.com Need training on Oracle DBA? WhatsApp to +919951696808 Training content is at www.orskl.com
Views: 5107 OrSkl Academy
Oracle Apps Picking and Shipping end to end scenario
 
47:09
Welcome to Oracle EBS Supply Chain Management Training Channel -------------------------------------------------------------- This channel is dedicated to Oracle EBS R12 Supply Chain Management Training through real life case study. There are over 100 cases of supply chain is discussed and demonstrated through EBS setups and transactions. This is one channel that a beginer and intermediate level person can always like to have as a ready recknor. I have over 4000 subscriber in two of my channel What you will learn ------------------- You get access to following modules of Oracle EBS Supply Chain family. ---------------------------------------------------------------------- Oracle EBS WMS and MSCA Oracle EBS Order Management (R12) Oracle EBS Advance Pricing Oracle EBS Shipping Oracle EBS Inventory Oracle EBS Purchasing Learn To: ------------ Describe and process inbound logistics tasks. Describe warehousing features. Describe and process outbound logistics tasks. Set up and define rules using the rules engine framework. Set up Oracle Order Management Manage exceptions and holds Use key Sales order flows (Quote to Order, Blanket agreement to Order and other 10 such flows) Set up Shipping Execution and basic Pricing functionality Setup configure to order (BOM,Routing, WIP etc.) end to end flow (Model BOM,Option class and options, Option specific routing) Setup basic pricing and integrate with order management. Setting up Shipping Setting up Advance Pricing Setting up Purchasing application and many more...(There are 700 plus videos are available in this channel Benefits to You ---------------- This will allow you to explore all the ares of supply chain management (list of modules listed above). There are playlist so that you can see the grouping of sessions. Excuse me if some of the videos are not captured but you will always find similar videos. This channel has over 700 videos to cover the breadth of the subjects. Most of the sessions are recorded during the live training session. Required Pre-requisite ---------------------- Basic knowledge of Supply chain management concepts and inventory management What is the target audience? ----------------------------- End User of Oracle EBS Supply Chain Management Implementer of Oracle EBS Supply Chain Management Support Staff of Oracle EBS Supply Chain Management Anyone who is enthusiasts to explore career in Oracle WMS Apology as some of the video will require you to increase the computer volume as the sound is little low
Views: 22860 Oracle Apps
Oracle Database11g tutorials 9 || What is archive log mode and how to enable archive log mode
 
07:23
weblink: www.rebellionrider.com What is archive log mode What is noarchive log mode How to enable archivelog mode in oracle 11g How to enable archivelog mode in oracle 10g This SQL tutorial and Oracle database 11g tutorial for beginners will show what are ARCHIVELOG mode and noarchive log mode and how to enable archivelog mode in oracle database 11g or 10g Tool used in this tutorial is command prompt. This tutorial series is part of SQL expert exam certification training. if you are preparing for SQL certification you can use my tutorials. This SQL Tutorial is a part of free training. Copy Cloud referral link || Use this link to join copy cloud and get 20GB of free storage https://copy.com?r=j7eYO7 Contacts E-Mail [email protected] Twitter https://twitter.com/rebellionrider Instagram http://instagram.com/rebellionrider Facebook. https://www.facebook.com/imthebhardwaj Linkedin. in.linkedin.com/in/mannbhardwaj/ Thanks for linking, commenting, sharing and watching more of our videos This is Manish from The Code makers
Views: 97938 Manish Sharma
Oracle - Understanding the tnsnames.ora and listener.ora files
 
12:46
Oracle - Understanding the tnsnames.ora and listener.ora files
Views: 191765 Chris Ostrowski
How to Parse XML in Oracle
 
13:54
This Video Shows 1. How to Read and parse XML in Oracle using EXTRACTVALUE and XMLTABLE. 2. When to use extractvalue and XMLTable. 3. Brief Introduction to XMLPATH
Views: 13308 yrrhelp
Oracle GoldenGate Processes Overview - GG Video 6
 
04:13
This video gives you an overview of the processes ( Extract, Pump and Replicat) used by GoldenGate to replicate data between databases. 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: 9833 Ramkumar Swaminathan
Installation and Prerequisites to Setup Oracle Goldengate
 
01:10:09
The session guides you to install Oracle Goldengate and what are the prerequisites at the Database level to setup oracle Goldengate in your environment. The Goldengate version is 12c and database on source and target is Oracle DB 12c. For demonstration purpose platform used is linux on VM.
Views: 12364 Ashish Agarwal
How to find block sizes of all Oracle Database files
 
14:02
Block size of control files and redo log files are not same as default block size of your oracle database. Understand the level of control we got to alter these block sizes from one of my real time activity. Many more interesting blogs at : www.orskl.com/blog Looking for Oracle DBA training: www.orskl.com/training WhatsApp: +919951696808
Views: 3339 OrSkl Academy
قواعد البيانات 7 (Oracle Parameter Files (Oracle DBA 11g Tutorial
 
20:19
Oracle DBA 11g Tutorial parameter files (pfile) (init.ora) server parameter file (spfile) Parameter Values difference between spfile and pfile
Views: 290 Ahmed Ybat
Step by Step guide to build data guard in Oracle 11g |Physical standby database Data guard |
 
01:18:25
Step by Step guide to build data guard in Oracle 11g
Views: 112951 Wysheid Wysheid
Oracle Apps Training Value Sets 1
 
16:12
For more videos and documents check us at www.erpwebtutor.com
Views: 26426 ERPWebTutor
Oracle Database Users / User Management (Simple)
 
09:33
Create, Alter, Drop, Grant Rights, Default Tablespace, Temporary Tablespace, Quota Setup, View Users Information, Lock / Unlock user account select username,account_status,default_tablespace, temporary_tablespace,created from dba_users; create user myuser identified by myuser; alter user myuser quota unlimited on mytbs; alter user myuser quota 100m on mytbs; alter user temporary tablespace temp; alter user myuser default tablespace mytbs; alter user myuser accout unlock; alter user myuser account lock; alter user myuser password expire; alter user myuser identified by youuser; create user myuser identified by myuser default tablespace users temporary tablespace temp quota unlimited on users; grant create session, resource to myuser; grant create session, resource to myuser with grant option; drop user asif; drop user asif cascade;
Views: 41709 Abbasi Asif
Payables | Setting Up and Making Check Payments
 
07:09
This video tutorial applies to Rel 11 through Rel 13. It shows you how to set up and make check payments.
How To Find and Create ESS Job Definitions
 
04:51
How To Find and Create Enterprise Scheduling Service Job Definitions in Fusion Applications
Oracle username and password and Account unlocking
 
08:37
all education purpose videos
Views: 282603 Chandra Shekhar Reddy
Cross-Product Features | Submitting a Scheduled Process
 
02:00
This video tutorial applies to Rel 11 through Rel 13. It shows you how to submit a scheduled process and view the output.
Auditing in Oracle 11g
 
10:43
Auditing in Oracle database will help you to what a user doing??
Views: 4903 Athar Fahad
Oracle 11gR2 Core DBA n Linux
 
20:39
Demonstration on Oracle DBA training which covers SQL, Linux and Administration-I courses
Views: 1275 OrSkl Academy
Stored procedures in sql server   Part 18
 
20:11
In this video we will learn 1. What is a stored procedure 2. Stored Procedure example 3. Creating a stored procedure with parameters 4. Altering SP 5. Viewing the text of the SP 6. Dropping the SP 7. Encrypting stored procedure Text version of the video http://csharp-video-tutorials.blogspot.com/2012/08/stored-procedures-part-18.html Slides http://csharp-video-tutorials.blogspot.com/2013/08/part-18-stored-procedures.html All SQL Server Text Articles http://csharp-video-tutorials.blogspot.com/p/free-sql-server-video-tutorials-for.html All SQL Server Slides http://csharp-video-tutorials.blogspot.com/p/sql-server.html All Dot Net and SQL Server Tutorials in English https://www.youtube.com/user/kudvenkat/playlists?view=1&sort=dd All Dot Net and SQL Server Tutorials in Arabic https://www.youtube.com/c/KudvenkatArabic/playlists
Views: 756744 kudvenkat
Power BI and Microsoft Flow - Monitoring your data
 
10:59
In this video, Patrick shows how you can use Microsoft Flow, combined with Power BI, to monitor data and alert you when something is available. This takes advantage of a streaming dataset and using the schedule recurrence in Microsoft Flow to trigger an action as Patrick wasn't using anything else to trigger it. You have a ton of options though. LET'S CONNECT! Guy in a Cube -- https://guyinacube.com -- http://twitter.com/guyinacube -- http://www.facebook.com/guyinacube -- Snapchat - guyinacube -- https://www.instagram.com/guyinacube/ ***Gear*** Check out my Tools page - https://guyinacube.com/tools/
Views: 42191 Guy in a Cube
Oracle Applications Fusion Cloud - Order Management: Back To Back Order Setup
 
45:02
You can view the entire series @ https://oracleug.thinkific.com/courses/oracle-applications-fusion-cloud-order-management Oracle Cloud/Fusion Order Management training will help you develop the fundamental skills required to set up and use the OM module. This training covers all the tasks, setups, forms and reports used in OM and related modules Order to Cash End to End Process Create Sales Order Submit Sales Order Fulfillment View Fulfillment Lines Orchestration Plan Pick Sales Order Confirm Pick Wave Ship Confirm Manage Shipment Interface Sales Order Status Review Orchestration Plan Status Review Inventory Transaction Review Cost Accounting Create Cost Accounting for SO Shipment Review Cost Accounting for SO Shipment Billing AutoInvoice View Balance Create Accounting Review Journal Managing Order Lines Updating Multiple Order Lines Line Type Available Quantity Edit Line Prices Configured Items - ATO Configured Items - PTO Editing Tax on Order Lines Shipment and Billing Details Estimating Availability Override Order Line Shipment Sets Partial Shipments of Lines Supply Details Billing Details Recurring Billing Order Fulfillment Submit Order Order Status Fulfillment View Fulfillment Line Analytics Fulfillment Line Status Orchestration Plan Jeopardy Score Apply Holds Release Holds Manual Scheduling Edit Fulfillment Lines Splitting Fulfillment Lines Outbound Shipments Pick Wave Create Pick Wave Pick Release From Manage Shipment Lines Schedule Pick Wave Confirm Pick Slip Review Order Status & Shipment Lines Ship Confirm Shipment Lines Manage Shipments Shipping Exception Create Shipping Exception Close Shipping Exception Manage Shipment Interface Pricing Strategy & Segment Dropship Order DropShip Business DropShip Setup Drop Ship Process Flow Item Validation Organization Setup: Item Setup: BPA Setup: Add Item To Price List Setup : ATP Rule Collect Planning Data Setup: Sourcing Rule Setup: Default Assignment Sets Setup: Assignment Sets Drop Ship Process Flow Create Sales Order Orchestration Process Review PO Create ASN Review Order Details Invoice Back To Back Order Back To Back Business Setup: Item Setup: BPA Setup: Add Item To Price List Setup : ATP Rule Collect Planning Data Setup: Sourcing Rule Setup: Default Assignment Sets Setup: Assignment Sets Create Sales Order Orchestration Process Review PO Receive PO Review Order Details Pick Order Ship Sales Order Review Order Details Invoice Transfer Order Transfer Order Process Flow Transfer Order Type Transfer Order Status Generic Transfer Order Process Flow Supply Chain Orchestration Create Supply Request In Inventory Manage Supply Lines In Supply Chain Orchestration Supply Order Details Supply Order Orchestration Plan Review Transfer Order Manage Transfer Order Pick Release Transfer Order Ship Confirm Transfer Order Receive Transfer Order Review Completed Transaction - Source Review Completed Transaction - Destination Transfer Order Request In Supply Orchestration Transfer Order Status Report Canceling Quantities on Transfer Orders Process Supply Chain Orchestration Interface Order Management Setups Supply Chain Financial Orchestration System Options Drop Ship Financial Flow Approval Rules for Sales Orders Scheduled Processes OM Parameters Credit Check – Enable Credit Check For Account Credit Check – Site Profile Credit Check – Example Order Type Order Lookups Coverage and Subscription Orchestration Process Orchestration Process Definitions Predefined Orchestration Process Ship Confirm Rule Shipping Parameters Jeopardy Jeopardy Threshold Definition Jeopardy Priority Jeopardy Lead Time Business Rules Pretransformation Defaulting Rules Product Transformation Rules
Views: 17 ND Sng
How to enable idle_time parameter for user profiles on Oracle
 
03:01
Typically, malicious users target the inactive sessions to gain access into the database. By reducing the period of time an inactive session stays connected, the probability of that session being a victim of abuse is reduced. Also, setting up idle_time helps to reduce problems of having too many INACTIVE sessions.
Views: 1089 checklist20
Should I set CPU_COUNT?
 
02:44
blog: https://connor-mcdonald.com Should I be setting the CPU_COUNT parameter for my database? A summary from the recent AskTOM Office Hours session. Subscribe for regular videos on Oracle technology! CPU, Cores, Sockets: https://www.youtube.com/watch?v=5nRheRXTMEc whitepaper: http://www.oracle.com/technetwork/database/performance/instance-caging-wp-166854.pdf music: kevin mcleod (incomptech.com)
Views: 403 Connor McDonald
Walkthrough: SQL Server DirectQuery with Power BI
 
07:52
I walk through using a DirectQuery connection with SQL Server and the Power BI service. I start with Power BI Desktop, show how to configure the enterprise gateway, and then show how it looks in the Power BI service. SUBSCRIBE! https://www.youtube.com/channel/UCFp1vaKzpfvoGai0vE5VJ0w?sub_confirmation=1 LET'S CONNECT! Guy in a Cube -- http://twitter.com/guyinacube -- http://www.facebook.com/guyinacube -- http://aka.ms/guyinacube (YouTube) -- https://beme.com/guyinacube -- Snapchat - guyinacube -- https://www.instagram.com/guyinacube/ Adam Saxton (Microsoft Employee) -- http://twitter.com/awsaxton -- https://www.facebook.com/asaxton
Views: 50622 Guy in a Cube
02.03.09_Oracle_10gR2_RAC_2.3.9 Configuring the Initialization Parameter Files in RAC.flv
 
07:10
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 10g R2 (10.2.0.1) on Linux 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 - () 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 Oracle10g Release 2 - (Video) 1.16 Install Oracle Clusterware 10g - 10.2.0.1.0 - (Video) 1.17 Install and configure Automatic Storage Management (ASM) - (Video) 1.18 Install Oracle Database 10gR2 Software - (Video) 1.19 Install Oracle Database 10g Companion CD Software - (Video) 1.20 Create TNS Listener Process - (Video) 1.21 Create ASM Instance - (Video) 1.22 Create a Cluster Database - (Video) 1.23 Post-Installation Tasks - (Optional) - (Video) 1.23.1 Re-compile Invalid Objects - (Video) 1.23.2 Enabling Archive Logs and Flashback in a RAC Environment - (Video) 1.23.3 Create Shared Oracle Password Files - (Video) 1.24 Verify TNS Networking Files - (Video) 1.25 Create / Alter Tablespaces - () 1.26 Verify the RAC Cluster & Database Configuration - (Video) 1.27 Verify Cluster Network Configuration - (Video) 2. RAC Database Administration and Workload Management 2.1 Starting / Stopping the Cluster - (Video) 2.2 Transparent Application Failover - (TAF) - () 2.3 Configuring the Server Parameter File(SPFILE) in RAC - (Video) 3. Upgrading Oracle CRS, ASM, RDBMS and Database 10.2.0.3 3.1 Download and Extract the Installation Software - (Video) 3.2 Pre-installation Tasks for Patch set and Release Upgrades - (Video) 3.3 Oracle Clusterware Rolling Upgrade - (Video) 3.4 Apply the patch 10.2.0.3.0 to the ASM Home - (Video) 3.5 Applying Patch set to Oracle RAC - (Video) 3.6 Upgrading Oracle Database 10.2.0.x to 10.2.0.3.0 Using DBUA - (Video)
Views: 277 Yongcheng Lai
Embed Oracle Process Cloud Service UI Components into Other Applications
 
01:16
Let users initiate and work on tasks within the context of their primary focus using Oracle Process Cloud Service UI components. 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.
General Ledger | Creating Journal Approval Rules
 
09:37
This video tutorial applies to Rel 9 through Rel 13. It shows you how to create journal approval rules that either automatically approve a journal batch or that route the batch for supervisory approvals based on the ledger and journal amounts.
INV Shipping Networks, Oracle Applications Training
 
06:24
This video discribes the process for setting up Shipping Networks in Oracle Applicaitons.
Views: 3877 Larry Sherrod
03.05_Oracle_10gR2_RAC_3.5 Applying Patch set to Oracle RAC.flv
 
23:04
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 10g R2 (10.2.0.1) on Linux 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 - () 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 Oracle10g Release 2 - (Video) 1.16 Install Oracle Clusterware 10g - 10.2.0.1.0 - (Video) 1.17 Install and configure Automatic Storage Management (ASM) - (Video) 1.18 Install Oracle Database 10gR2 Software - (Video) 1.19 Install Oracle Database 10g Companion CD Software - (Video) 1.20 Create TNS Listener Process - (Video) 1.21 Create ASM Instance - (Video) 1.22 Create a Cluster Database - (Video) 1.23 Post-Installation Tasks - (Optional) - (Video) 1.23.1 Re-compile Invalid Objects - (Video) 1.23.2 Enabling Archive Logs and Flashback in a RAC Environment - (Video) 1.23.3 Create Shared Oracle Password Files - (Video) 1.24 Verify TNS Networking Files - (Video) 1.25 Create / Alter Tablespaces - () 1.26 Verify the RAC Cluster & Database Configuration - (Video) 1.27 Verify Cluster Network Configuration - (Video) 2. RAC Database Administration and Workload Management 2.1 Starting / Stopping the Cluster - (Video) 2.2 Transparent Application Failover - (TAF) - () 2.3 Configuring the Server Parameter File(SPFILE) in RAC - (Video) 3. Upgrading Oracle CRS, ASM, RDBMS and Database 10.2.0.3 3.1 Download and Extract the Installation Software - (Video) 3.2 Pre-installation Tasks for Patch set and Release Upgrades - (Video) 3.3 Oracle Clusterware Rolling Upgrade - (Video) 3.4 Apply the patch 10.2.0.3.0 to the ASM Home - (Video) 3.5 Applying Patch set to Oracle RAC - (Video) 3.6 Upgrading Oracle Database 10.2.0.x to 10.2.0.3.0 Using DBUA - (Video)
Views: 3286 Yongcheng Lai
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: 20024 Ramkumar Swaminathan
How to Install Oracle! !! Database Training
 
01:50
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)
Oracle Database tutorials 1: How to install Oracle Database 11g on windows 7
 
08:54
How To install Oracle Database 11g enterprise edition On windows 7 64 bit. Full installation in Single video. Enjoy SQL and Oracle Database Download Oracle Database 11g from here http://www.oracle.com/technetwork/database/enterprise-edition/downloads/112010-win64soft-094461.html ------------------------------------------------------------------------ ►►►LINKS◄◄◄ Related Tutorial ► Tut 16 How To Uninstall Oracle 11g http://youtu.be/pk-E-QxWe38 ► Tut 25 How To Install Oracle 11g XE r2 http://youtu.be/-13SbeDavwk ► Oracle 12c Tut 1 How To Install Oracle 12c http://youtu.be/T-rCbe1MMG4 ►Oracle 12c Tut 5 How To Uninstall Oracle 12c http://youtu.be/lyN9aJfMlzQ ------------------------------------------------------------------------- ►►►Help Me In Getting A Job◄◄◄ ►Help Me In Getting A Good Job By Connecting With Me on My LinkedIn and Endorsing My Skills. All My Contact Info is Down Below. You Can Also Refer Me To Your Company Thanks -------------------------------------------------------------------------- ►Make sure you SUBSCRIBE and be the 1st one to see my videos! -------------------------------------------------------------------------- ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ ►►►Find me on Social Media◄◄◄ Follow What I am up to as it happens on https://twitter.com/rebellionrider https://www.facebook.com/TheRebellionRider http://instagram.com/rebellionrider https://plus.google.com/+Rebellionrider http://in.linkedin.com/in/mannbhardwaj/ You can also Email me at [email protected] You can help me in getting a good job by connecting with me on my LinkedIn and Endorsing my Skills. Please please LIKE and SHARE my videos it makes me happy. Thanks for liking, commenting, sharing and watching more of our videos This is Manish from RebellionRider.com ♥ I LOVE ALL MY VIEWERS AND SUBSCRIBERS
Views: 1439147 Manish Sharma
Supply Chain training | Supply Chain - oracle online trainings
 
00:51
Supply Chain training retailer's ability to fulfill its brand promise depends on effective store and direct.Register today for supply chain online training. Reach us: Email : [email protected] Contact : +91 8121 020 111 Supply Chain Training Course Content Introduction to the Supply Chain Overview of the Course Course Objectives Course Agenda Overview of the demand Define the demand forecasting Describe the role of demand forecasting in the retail planning process List the challenges to successful demand forecasting Explain how the RDF overcomes forecasting challenges Describe how the RDF may be integrated with the other applications Business Process Flow Describe the steps in the RDF primary workflow List the various methods of the forecast approval Name the two additional tools provided for analysing demand forecasts for accuracy Navigate through the RDF steps using the RDF workflow Login & Task flow Start the RDF Client Describe process of the RDF login process Select the RDF Domain Explain the RDF Task flow Pane Pre-processing Data for Forecasting Define data pre-processing Describe at least 3 pre-processing methods Explain why pre-processing data may be necessary to create accurate the demand forecasts Explain the impact of the Clear & No Filtering pre-processing Method Forecasting Methods Smoothing Exponential Regression Analysis Bayesian Analysis Prediction Intervals Automatic Method Selection The Source-level Forecasting Promotional Forecasting Setting the Forecast Parameters Identify the functions of an Forecast Administration Task List the Forecast Administration Identify the functions of the Forecast Maintenance Task List the Forecast Maintenance Explain the functions of the key View Parameters Like Item, Sister Store & the Product Cloning Describe the function of the Like-Item, Sister Store Task List the views found in the Like-Item, Sister Store Task Describe the key parameters found in the Like-Item, Sister-Store Views Describe the Product/Location Cloning Task List the views found in the Product/Location Cloning Task Describe the key parameters found in the Product/Location Cloning Views Generating the Forecasts Explain the steps in manually generating a demand forecast Explain the process of the generating a demand forecast through the nightly batch run Approving & Deleting Forecasts Differentiate between the different methods of approving the forecast List the possible Views in the Forecast Explain the purpose of the key parameters in the Forecast Approval Views Describe the tools used for the deleting a forecast Promote Describe the features & functionality of the (Optional) Promote solution Explain the difference between promotional & the statistical forecasting Use the Promotional Forecasting tools within RDF Curve Describe the business function of the Curve module Set the Curve parameters Explain the process of creating a custom Spread Profile using the Curve Tasks & Views Grade Describe the features & functionality of the Grade solution Identify the methods for creating the clusters Describe the each method in the detail Forecast Analysis Tools Explain the function & purpose of the Forecast Analysis tools Explain the function of the Views found in an Interactive Forecasting Task Explain the function of the Views found in an Forecast Scorecard Task Exporting Forecasts & RDF Integration Describe the process of the exporting demand forecasts Explain how to demand forecasts are used by other planning applications Explain how to demand forecasts are used by execution applications Review of the course Recap the RDF course content Create, run, & review a sample Demand Forecast
Views: 11 Oracle Trainings
Steps to take the backup of database using RMAN | oracle database backup and recovery |
 
06:52
Steps to take the backup of database using RMAN
Views: 31954 Wysheid Wysheid
Create Dynamic Query Parameters in Power BI Desktop  - Power BI Tips & Tricks #47
 
09:11
Create Dynamic Query Parameters, filter your reports with them and create a template using Power BI. Links mentioned in the video: Chris Webb blog: https://blog.crossjoin.co.uk/2016/08/30/data-driven-power-bi-desktop-parameters-using-list-queries/ Rio Summer Olympics Report: https://www.youtube.com/watch?v=tZXY9RZwd3U Download the sample report, #47 here: https://curbal.com/donwload-center SUBSCRIBE to learn more about Power and Excel BI! https://www.youtube.com/channel/UCJ7UhloHSA4wAqPzyi6TOkw?sub_confirmation=1 Our PLAYLISTS: - Join our DAX Fridays! Series: https://goo.gl/FtUWUX - Power BI dashboards for beginners: https://goo.gl/9YzyDP - Power BI Tips & Tricks: https://goo.gl/H6kUbP - Power Bi and Google Analytics: https://goo.gl/ZNsY8l ABOUT CURBAL: Website: http://www.curbal.com Contact us: http://www.curbal.com/contact ▼▼▼▼▼▼▼▼▼▼ If you feel that any of the videos, downloads, blog posts that I have created have been useful to you and you want to help me keep on going, here you can do a small donation to support my work and keep the channel running: https://curbal.com/product/sponsor-me Many thanks in advance! ▲▲▲▲▲▲▲▲▲▲ QUESTIONS? COMMENTS? SUGGESTIONS? You’ll find me here: ► Twitter: @curbalen, @ruthpozuelo ► Google +: https://goo.gl/rvIBDP ► Facebook: https://goo.gl/bME2sB #POWERBITIPS #CURBAL #POWERBI #MVP ► Linkedin: https://goo.gl/3VW6Ky
Views: 42571 Curbal
How to configure Microsoft Excel to connect to an Oracle Database
 
11:52
Mike van der Velden, Product Manager at Simba Technologies, provides a step-by-step guide for configuring Microsoft Excel to connect with Oracle Database OLAP Option. Mike walks through the one-time set-up of Oracle's Transparent Networking Substrate (TNS), followed by the Data Source Name (DSN) and Office Data Connection (.odc). Once configured, Microsoft Excel connects easily to Oracle Database OLAP Option for ad hoc data query, data analysis and BI reporting.
How to install Oracle 11g on Linux
 
18:20
Note : for each and every detail please also refer the below url http://technologylair8423.blogspot.in/2012/06/oracle-11g-installation-on-linux.html Buy Expert Oracle Database 11g Administration Amazon.com http://bit.ly/1blaPlY Amazon.in http://amzn.to/184V0xn Flipkart : http://goo.gl/D4RCs Note : if you get any error as below sqlplus: error while loading shared libraries: /oracle/product/11.2.0/db_1/lib/libclntsh.so.11.1: cannot restore segment prot after reloc: Permission denied use the below command : chcon -t textrel_shlib_t '/oracle/product/11.2.0/db_1/lib/libclntsh.so.11.1' Technology Lair : www.technologylair.net Subscribe : http://www.youtube.com/subscription_center?add_user=technologylair For More Videos : http://www.youtube.com/user/technologylair/videos For Video Tutorials :http://www.youtube.com/playlist?list=PLC71CFFF7A916DCAA For Android : http://www.youtube.com/playlist?list=PLUXK1VpPWQKHI1l-NvM5jvNKKnmNy9eHp Kalam e Iqbal : http://www.youtube.com/playlist?list=PLF057785BD260F061 Like us on Facebook : https://www.facebook.com/techlair Tweet us : @technologylair Follow us : https://plus.google.com/u/0/118196883367288585963/posts Pin us : http://www.pinterest.com/technologylair/
Views: 154037 TechLair
How to install oracle 12c on Linux
 
20:53
Learn ow to install the latest release for oracle database i.e 12C. watch the step by step installation in the above video. Click the below link for all the commands and steps http://techlair.info/2015/11/08/oracle12cinstall/ Step 1 - Edit Host Files - /etc/hosts 127.0.0.1 localhost.localdomain localhost 192.168.0.210 oracle_12C.localdomain oracle_12C Step 2 - Edit Kernel Parameters /etc/sysctl.conf fs.file-max = 6815744 kernel.sem = 250 32000 100 128 kernel.shmmni = 4096 kernel.shmall = 1073741824 kernel.shmmax = 4398046511104 net.core.rmem_default = 262144 net.core.rmem_max = 4194304 net.core.wmem_default = 262144 net.core.wmem_max = 1048576 fs.aio-max-nr = 1048576 net.ipv4.ip_local_port_range = 9000 65500 sysctl -p - apply changes Step 3 - Edit Limits file - etc/security/limits.conf oracle soft nofile 1024 oracle hard nofile 65536 oracle soft nproc 2047 oracle hard nproc 16384 oracle soft stack 10240 oracle hard stack 32768 Step 4 - Install dependencies yum install binutils -y yum install compat-libcap1 -y yum install compat-libstdc++-33 -y yum install compat-libstdc++-33.i686 -y yum install gcc -y yum install gcc-c++ -y yum install glibc -y yum install glibc.i686 -y yum install glibc-devel -y yum install glibc-devel.i686 -y yum install ksh -y yum install libgcc -y yum install libgcc.i686 -y yum install libstdc++ -y yum install libstdc++.i686 -y yum install libstdc++-devel -y yum install libstdc++-devel.i686 -y yum install libaio -y yum install libaio.i686 -y yum install libaio-devel -y yum install libaio-devel.i686 -y yum install libXext -y yum install libXext.i686 -y yum install libXtst -y yum install libXtst.i686 -y yum install libX11 -y yum install libX11.i686 -y yum install libXau -y yum install libXau.i686 -y yum install libxcb -y yum install libxcb.i686 -y yum install libXi -y yum install libXi.i686 -y yum install make -y yum install sysstat -y yum install unixODBC -y yum install unixODBC-devel -y Step 5 - Add Groups and Users groupadd -g 54321 oinstall groupadd -g 54322 dba groupadd -g 54323 oper useradd -u 54321 -g oinstall -G dba,oper oracle passwd oracle Step 6 - /etc/security/limits.d/90-nproc.conf # Change this * soft nproc 1024 # To this * - nproc 16384 Step 7 - Set SELINUX SELINUX=permissive run the command after edit setenforce Permissive Step 8 - Stop Firewall # service iptables stop # chkconfig iptables off Step 9 - Create directories for oracle Installation mkdir -p /oracle/product/12.1.0/db_1 chown -R oracle:oinstall /oracle chmod -R 775 /oracle Step 10 - xhost + Step 11 - Edit bash profile for oracle user /home/oracle/.bash_profile # Oracle Settings export TMP=/tmp export TMPDIR=$TMP export ORACLE_HOSTNAME=oracle_12C.localdomain export ORACLE_UNQNAME=db1 export ORACLE_BASE=/oracle export ORACLE_HOME=$ORACLE_BASE/product/12.1.0/db_1 export ORACLE_SID=db1 export PATH=/usr/sbin:$PATH export PATH=$ORACLE_HOME/bin:$PATH export LD_LIBRARY_PATH=$ORACLE_HOME/lib:/lib:/usr/lib export CLASSPATH=$ORACLE_HOME/jlib:$ORACLE_HOME/rdbms/jlib Step - 12 Extract Installation Files unzip linuxamd64_12c_database_1of2.zip unzip linuxamd64_12c_database_2of2.zip Step - 13 Start the Oracle Universal Installer ./runInstaller Post Installation dit the "/etc/oratab" file setting the restart flag for each instance to 'Y' cdb1:/u01/app/oracle/product/12.1.0/db_1:Y Technology Lair : www.technologylair.org Subscribe : http://www.youtube.com/subscription_center?add_user=technologylair For More Videos : http://www.youtube.com/user/technologylair/videos For Video Tutorials :http://www.youtube.com/playlist?list=PLC71CFFF7A916DCAA For Android : http://www.youtube.com/playlist?list=PLUXK1VpPWQKHI1l-NvM5jvNKKnmNy9eHp For Linux : https://www.youtube.com/playlist?list=PLUXK1VpPWQKHV2xOmjQgUNj3Hrmcslj-H Kalam e Iqbal : http://www.youtube.com/playlist?list=PLF057785BD260F061 Like us on Facebook : https://www.facebook.com/technologylair Tweet us : http://twitter.com/technologylair Follow us : https://plus.google.com/u/0/118196883367288585963/posts Pin us : http://www.pinterest.com/technologylair/
Views: 137708 TechLair
02.20_Oracle_10gR2_RACDG_2.20 Apply the Patch set 10.2.0.3.0 to Oracle Home(2012_01_13).flv
 
10:46
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: 1219 Yongcheng Lai
02.29_Oracle_10gR2_RACDG_2.29 Configuring the Initialization Parameters(2012_01_13).flv
 
04:45
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: 212 Yongcheng Lai
Video Session #8 Cashing Out & Process Improvement
 
09:15
Effective Business Processes will increase the value of any company - immediately through increased profits, and potentially by securing higher earnings multiples than industry average. A company with effective processes will be more desirable in the market. This session discusses an approach to prioritizing & improving the processes themselves.
Views: 38 CFO Insight LLC
Setup Shipping Parameters
 
03:34
Oracle EBS (R12) WMS and MSCA training course What you will learn This R12 Oracle Warehouse Management Fundamentals training teaches you how to set up and use Oracle Warehouse Management. Explore how Oracle Warehouse Management supports both paper-based and highly automated environments with material handling systems and radio frequency hand-held computers. Learn To: Describe and process inbound logistics tasks. Describe warehousing features. Describe and process outbound logistics tasks. Set up and define rules using the rules engine framework. Benefits to You By taking this course, you'll get a chance to participate in hands-on practices. You'll perform many of the processing and inquiry transactions necessary to a warehouse environment. These transactions include storage and facility management, inbound logistics, outbound logistics and wave planning. Learn how this solution optimizes material handling business processes for warehouses, manufacturing facilities and distribution centers. Required Pre-requisite Through knowledge of Inventory Management What are the requirements? Basics of Supply Chain Management Basics of Oracle Inventory (Not mandatory) What am I going to get from this course? Over 53 lectures and 5.5 hours of content! Setting up Oracle WMS and MSCA Demonstrate Receiving, Replenishments, Picking and Shipping based on WMS Rules Integrate Employee with Advance Task Framework Generate label from Oracle WMS Configure different Putaway and Picking Rules in Oracle WMS Map the N-Step receiving process using Operation Plan Perform Quick Ship Perform LPN Ship Planned Cross Docking Opportunistic Cross Docking ABC Classification Cycle Counting using MSCA Label Printing Integration Kit Direct Ship What is the target audience? End User of Oracle WMS Implementer of Oracle WMS Support Staff of Oracle WMS Anyone who is enthusiasts to explore career in Oracle WMS To buy the course use the direct link below https://www.udemy.com/oracle-apps-wms-and-msca-training/?couponCode=YOUTUBEFIRST500 Course fee is 45 USD for lifetime access with 30 days moneyback from Udemy
Oracle DBA Lite: an introduction to Oracle administration, part 2
 
14:36
CAPTIONS AVAILABLE - Second installment in a series of videos to turn Oracle DBA wannabes into (with a little practice) decent junior DBAs. It's based on the (free) Oracle Express edition but everything that is shown applies to other Oracle editions as well.
Views: 13352 roughsealtd
04.22_Oracle_10gR2_RAC_4.22 Apply the Patch set 10.2.0.3.0 to Oracle Home.avi
 
12:03
Oracle 10g/11g RAC, DataGuard, GoldenGate,Streams Hands-on Practices Training. ONLY $199 Please feel free to contact me: E-mail/Skype: [email protected] 4. Building an Oracle RAC 10gR2 (10.2.0.3) on Linux 4.1 Install Linux OS(CentOS 5.3) - () 4.2 Install Required Linux Packages for Oracle RAC - (Video) 4.3 Network Configuration - (Video) 4.4 Create "oracle" User and Directories - (Video) 4.5 Configure the Linux Servers for Oracle - (Video) 4.6 Configure the "hangcheck-timer" Kernel Module - (Video) 4.7 Configure RAC Nodes for Remote Access using SSH - (Video) 4.8 IP SAN Configuration - Openfiler - () 4.9 Install Openfiler - SAN - () 4.10 Configure iSCSI Volumes using openfiler - (Video) 4.11 Configure iSCSI Volumes on Oracle RAC Nodes - (Video) 4.12 Install and configure Oracle Cluster File System(OCFS2) - (Video) 4.13 Install and Configure ASM (ASMLib2.0) - (Video) 4.14 Download Oracle RAC 10g Software - (Video) 4.15 Pre-Installation Tasks for Oracle 10g Release 2 - (Video) 4.16 Install Oracle Clusterware 10g - 10.2.0.1.0 - (Video) 4.17 Upgrade Oracle Clusterware from 10.2.0.1.0 to 10.2.0.3.0 - (Video) 4.18 Install and configure Automatic Storage Management (ASM) - (Video) 4.19 Apply the Patch Set 10.2.0.3.0 to the ASM Home - (Video) 4.20 Install Oracle Database 10gR2 Software - 10.2.0.1.0 - (Video) 4.21 Install Oracle Database 10g Companion CD Software - (Video) 4.22 Apply the Patch set 10.2.0.3.0 to Oracle Home - (Video) 4.23 Create TNS Listener Process - (Video) 4.24 Create ASM Instance - (Video) 4.25 Create a Cluster Database - (Video) 4.26 Post-Installation Tasks - (Optional) - (Video) 4.26.1 Re-compile Invalid Objects - (Video) 4.26.2 Enabling Archive Logs and Flashback in a RAC Environment - (Video) 4.26.3 Create Shared Oracle Password Files - (Video) 4.27 Verify TNS Networking Files - (Video) 4.28 Create / Alter Tablespaces - () 4.29 Verify the RAC Cluster & Database Configuration - (Video) 4.30 Configuring the Initialization Parameters - (Video) 4.31 Startup / Shutdown the Oracle RAC 10gR2 - ()
Views: 819 Yongcheng Lai
How to Oracle 11gR2 Installation On RHEL-5
 
04:47
ORACLE INSTALLATION FOR RHEL 5:- Set KERNAL PARAMETER:- vi /etc/sysctl.conf kernel.shmmni = 4096 semaphores: semmsl, semmns, semopm, semmni kernel.sem = 250 32000 100 128 net.ipv4.ip_local_port_range = 9000 65500 net.core.rmem_default=4194304 net.core.wmem_default=262144 net.core.rmem_max = 16777216 net.core.wmem_max = 16777216 net.ipv4.ipfrag_high_thresh=524288 net.ipv4.ipfrag_low_thresh=393216 net.ipv4.tcp_rmem=4096 524288 16777216 net.ipv4.tcp_wmem=4096 524288 16777216 net.ipv4.tcp_timestamps=0 net.ipv4.tcp_sack=0 net.ipv4.tcp_window_scaling=1 net.core.optmem_max=524287 net.core.netdev_max_backlog=2500 sunrpc.tcp_slot_table_entries=128 sunrpc.udp_slot_table_entries=128 net.ipv4.tcp_mem=16384 16384 16384 fs.aio-max-nr =1048576 fs.file-max=6815744 fs.suid_dumpable =1 kernel.shmmax =536870912 Refreshing Kernal Parameter:- /sbin/sysctl -p SECURITY LIMITS SETTING:- vi /etc/security/limits.conf * soft nproc 2047 * hard nproc 16384 * soft nofile 4096 * hard nofile 65536 * soft stack 10240 PACKAGE INSTALLATION:- rpm -Uvih binutils-2*`uname -p`* rpm -Uvih compat-libstdc++-33*`uname -p`* rpm -Uvih compat-libstdc++-33*i386* rpm -Uvih elfutils-libelf-0*`uname -p`* rpm -Uvih elfutils-libelf-devel-0*`uname -p`* rpm -Uvih gcc-4*`uname -p`* rpm -Uvih gcc-c++-4*`uname -p`* rpm -Uvih glibc-2*`uname -p`* rpm -Uvih glibc-2*i686* rpm -Uvih glibc-common-2*`uname -p`* rpm -Uvih glibc-devel-2*`uname -p`* rpm -Uvih glibc-devel-2*i386* rpm -Uvih glibc-headers-2*`uname -p`* rpm -Uvih ksh-20*`uname -p`* rpm -Uvih libaio-0*`uname -p`* rpm -Uvih libaio-0*i386* rpm -Uvih libaio-devel-0*`uname -p`* rpm -Uvih libaio-devel-0*i386* rpm -Uvih libgcc-4*`uname -p`* rpm -Uvih libgcc-4*i386* rpm -Uvih libstdc++-4*`uname -p`* rpm -Uvih libstdc++-4*i386* rpm -Uvih libstdc++-devel-4*`uname -p`* rpm -Uvih make-3*`uname -p`* rpm -Uvih numactl-devel-0*`uname -p`* rpm -Uvih sysstat-7*`uname -p`* rpm -Uvih unixODBC-2*`uname -p`* rpm -Uvih unixODBC-2*i386* rpm -Uvih unixODBC-devel-2*`uname -p`* rpm -Uvih unixODBC-devel-2*i386* rpm -Uvh binutils-2.* rpm -Uvh elfutils-libelf-0.* rpm -Uvh glibc-2.* rpm -Uvh glibc-common-2.* rpm -Uvh libaio-0.* rpm -Uvh libgcc-4.* rpm -Uvh libstdc++-4.* rpm -Uvh make-3.* rpm -Uvh compat-libstdc++-33* rpm -Uvh elfutils-libelf-devel-* rpm -Uvh glibc-headers* rpm -Uvh glibc-devel-2.* rpm -Uvh libgomp* rpm -Uvh gcc-4.* rpm -Uvh gcc-c++-4.* rpm -Uvh libaio-devel-0.* rpm -Uvh libstdc++-devel-4.* rpm -Uvh unixODBC-2.* rpm -Uvh unixODBC-devel-2.* rpm -Uvh sysstat-7.* Users Set up:- groupadd oinstall groupadd dba groupadd oper groupadd asmadmin useradd -g oinstall -G dba,oper,asmadmin oracle passwd oracle Directories Set Up:- mkdir -p /u01/app/oracle/product/11.2.0.4/db_1/-------------oracle home mkdir -p /u01/app/oracle---------------------------------------------oracle base mkdir -p /u01/app/oraInventory---------------global inventory chown -R oracle:oinstall /u01 chmod -R 775 /u01 For Copying Oracle DB software In Oracle User:- mkdir /u01/software cp -r /run/media/root /* /u01/software/ [[email protected] software]$ ./runInstaller
Views: 230 ALOK SRIVASTAVA
ORACLE DBA Training | 80% Discount | 5000Rs Only | OrclData
 
02:04
Index for training https://www.orcldata.com/training My channel is mainly helpful for those who are looking to start their career in Oracle DBA | oracle databases administration technology. Channel will provide you in depth understanding for all oracle database concept.You will find the YouTube channel helpful for cracking oracle database administration interview. The explanation is clear and practically represented. Please reach me vie email [email protected] if you are looking for online training. https://www.orcldata.com Email: [email protected] Mob No: +91 9960262955 Please use the following link to get unlimited videos. https://www.skillshare.com/r/profile/Ankush-Thavali/5208062 Below is the coupon code for skillshares. https://www.udemy.com/draft/1412310/?couponCode=DBSHOT Please donate on below link if you think I am helping you with your career. https://www.paypal.me/ankushthavali OR Google Pay : 9960262955 OR Account No : 31347845762 IFSC: SBIN0012311 #oracledba #oracle #training
Views: 75 ANKUSH THAVALI