Home
Search results “List archive oracle”
HOW TO ENABLE DISABLE ARCHIVE LOG MODE IN ORACLE 11G DATABASE
 
03:20
HOW TO ENABLE DISABLE ARCHIVE LOG MODE IN ORACLE 11G ==================================================== archive log list; show parameter log_archive_dest_1; show parameter recovery; Enable archive log mode: ======================== shutdown immediate; startup mount; alter database archivelog; alter database open; Disable archive log mode: ========================= shutdown immediate; startup mount; alter database noarchivelog; alter database open;
Views: 1032 Praveen Biyyapu
Create EXCEL/PDF/html/etc Report from Oracle | Ten Minute Code
 
10:54
BELOW CODE cerate report server below commands windows key+R run paste -- rwserver server=showjobs status=on Declare repid REPORT_OBJECT; v_rep VARCHAR2(1000); rep_status VARCHAR2(20); PL_ID PARAMLIST; pr_nm varchar2(20):='PNM'; --rwserver server=SHOWJOBS EXCECUTE IT ON RUN v_rptserver varchar2(10):='SHOWJOBS'; ---- Change 1 v_host varchar2(20):='localhost'; ---- Change 2 -- v_rptserver varchar2(10):=:global.RWS1; -- v_host varchar2(20):=:global.IP1; BEGIN PL_ID := GET_PARAMETER_LIST(pr_nm); IF ID_NULL(PL_ID) = FALSE THEN DESTROY_PARAMETER_LIST(PL_ID); PL_ID := CREATE_PARAMETER_LIST(pr_nm); IF ID_NULL(PL_ID) THEN MESSAGE('ERROR CREATING PARAMETER LIST '||pr_nm); RAISE FORM_TRIGGER_FAILURE; END IF; ELSE PL_ID := CREATE_PARAMETER_LIST(pr_nm); END IF; --add parameter with separate statement for each parameter Add_Parameter(pl_id,'P_ECode',TEXT_PARAMETER,:P_ECode); ---change 3 your report have parameters Add_Parameter(pl_id,'P_ECode',TEXT_PARAMETER,:P_ECode); repid := find_report_object('DESG'); --- change 4 report name SET_REPORT_OBJECT_PROPERTY(repid,REPORT_EXECUTION_MODE,BATCH); SET_REPORT_OBJECT_PROPERTY(repid,REPORT_COMM_MODE,SYNCHRONOUS); SET_REPORT_OBJECT_PROPERTY(repid,REPORT_DESTYPE,CACHE); SET_REPORT_OBJECT_PROPERTY(repid,REPORT_DESFORMAT,'PDF'); -- change 5 pdf/html -- SET_report_object_property(repid,REPORT_DESFORMAT,:BLOCK3.REP_FORMAT); ------ need all format SET_REPORT_OBJECT_PROPERTY(repid,REPORT_SERVER,v_rptserver); v_rep := RUN_REPORT_OBJECT(repid,PL_ID); rep_status := REPORT_OBJECT_STATUS(v_rep); IF rep_status = 'FINISHED' THEN WEB.SHOW_DOCUMENT('http://'||v_host||':8889/reports/rwservlet/getjobid' ||substr(v_rep,instr(v_rep,'_',-1)+1)||'?'||'server='||v_rptserver,'_blank'); ELSE message('Error when running report'); END IF; END;
Views: 6404 Together Oracle
2MTT: Oracle MAF List Views | Luc Bors
 
01:30
Oracle ACE Luc Bors, author of the "Oracle Mobile Application Framework Developer Guide," (Oracle Press), easily beats the 2 minute countdown clock with this handy tip.
Views: 259 ArchBeat Archive
SPArchive Installation
 
02:13
Installation of SP Archive, a kalmstrom.com Solution for customized archiving of SharePoint list items to a Microsoft Access or SQL Server database. Also refer to http://www.kalmstrom.com/products/SPArchive/
Views: 142 kalmstrom.com
Riva - How to archive Oracle CRM on Demand emails to existing opportunities, cases and quotes
 
03:50
Are you looking to get the best ROI from your Oracle CRM on Demand? Riva can help. In this short training video with Riva CEO Aldo Zanoni, he details how to archive Oracle CRM on Demand emails to existing opportunities, cases, and quotes. - - - Struggling with CRM user adoption and need to provide your customer-facing teams with more relevant customer data? Think Riva. Riva unleashes a river of valuable Customer Intelligence currently trapped inside your CRM platform. It gives your customer-facing teams a real-time, 360-degree view of your customers. And the best part? This invaluable customer data is delivered directly to your users’ email systems – where they live. What Riva does: •Brings customer interaction visibility to your entire organization by breaking down the siloed data that exists between your CRM and email systems. Riva delivers the best CRM data automation available to sync your CRM and email data. Riva goes far beyond the capabilities of free plugins with hundreds of advanced configuration options including custom fields and objects. It’s CRM and email integration done your way. •Reveals powerful market and sales intelligence, relationship mapping and analytics, cognitive insights, AI, and related public data directly in Outlook and IBM Notes. •Provides the most advanced and flexible CRM and email integration available directly to your teams’ fingertips. Riva delivers advanced, server-side integrations between the world’s best CRM systems and all leading corporate email collaboration systems. See our full list of integrations http://www.rivacrmintegration.com/integrations/. Riva is trusted by more than 1,200+ companies, including 50 Fortune 500 companies, 15 of the world’s largest banks, numerous Global 1000 companies and small and medium size companies. Get the full ROI you expect from your CRM. Learn more at http://www.rivacrmintegration.com.
Views: 157 crmintegration
How to Zip and Unzip Directories on Linux
 
05:39
Basic usage for the 'zip' and 'unzip' commands on Linux. zip -r zipdir_you_are_creating.zip Directory_to_Zip/ unzip zipfile.zip 1:08 File/Directory Setup 1:33 Short explanation of what a 'tarbomb' is -- don't do this! 2:12 Archiving vs. Compression 2:37 Overhead in FTP and other protocols can be a great reason for creating archives 2:58 Zip command for archiving/compression 4:31 Unzip command for the inverse operation Full Linux Sysadmin Basics Playlist: https://www.youtube.com/playlist?list=PLtK75qxsQaMLZSo7KL-PmiRarU7hrpnwK Check out my project-based Linux System Administration course (free sample videos): https://www.udemy.com/hands-on-linux-self-hosted-wordpress-for-linux-beginners/?couponCode=tl35 Patreon: https://www.patreon.com/tutorialinux Official Site: https://tutorialinux.com/ Twitter: https://twitter.com/tutorialinux Facebook: https://www.facebook.com/tutorialinux
Views: 34433 tutoriaLinux
Record Management System project with source code in VB.NET
 
28:37
it is a small project in Visual Basic .Net with ADD REMOVE SAVE and exit functionality.. my website www.coderbaba.in ............................. Thanks for watching these videos , hit like , subscribe our channel n yes don't forget to share with you friends Follow Us Socially ?? Facebook : https://www.facebook.com/coderbaba Instagram : https://www.instagram.com/coderbaba Twitter : https://www.twitter.com/thecoderbaba ............................ ............................ LIKE ? SHARE ? SUBSCRIBE ............................ See you in next video, have a nice day. GOOD LUCK
Views: 50848 Coder Baba
[VG-V-EB05 Proxy test 160219] Bermuda Triangle VS Oracle Think Tank
 
16:54
VG-V-TD08 http://blog.livedoor.jp/freedomduo/archives/54365181.html ++++ VG-V-EB05 http://blog.livedoor.jp/freedomduo/archives/54450962.html ++++ Deck list http://blog.livedoor.jp/freedomduo/archives/54862949.html
Views: 1905 Freedom duo
John Fowler, Oracle - Oracle OpenWorld 2015 - #OOW15 - #theCUBE
 
21:27
Enhanced video at http://vinja.tv/Kz2XYcqx 01. John Fowler, Oracle, Visits #theCUBE. (00:18) 02. Cloud Hasn't Changed Which Technical Problems Must Be Solved. (00:50) 03. The Next Decade Is About Putting Functions in Silicon. (02:19) 04. A Fully Encrypted Data Center. (03:43) 05. The Data Analytics Accelerator. (05:20) 06. Partnering While Continuing to Compete. (06:10) 07. SPARC with a K: In Memory Analytics on Hadoop. (08:11) 08. The Data Center of the Future. (09:23) 09. Benefiting Other Workloads. (10:29) 10. Integrating On-Prem Tools with the Cloud. (11:16) 11. Still Many Problems to Solve at the Operating System Level. (12:45) 12. The Fully Encrypted Data Center. (14:30) 13. What Open Means to Oracle. (17:09) 14. Oracle Remains Steady in It's Strategy. (18:19) Track List created with http://www.vinjavideo.com. --- --- Oracle envisions fully encrypted data center | #oow15 by Gabriel Pesek | Oct 25, 2015 On the first day of Oracle OpenWorld 2015 in San Francisco, things got off to a strong start with clear and sunny California skies complementing the confident strides being made by Oracle in addressing customer needs for security and efficiency. John Fowler, executive VP of systems for Oracle, joined John Furrier and Stu Miniman, cohosts of theCUBE, from the SiliconANGLE Media team, to talk about handling cloud integration, hardware-software synergy, improving security and accelerating data analytics. Same problems, new environments On the topic of integrating cloud utilities and using them for storage, Fowler said, “It’s kind of a twist on the same technical problems we’ve been trying to solve for years and years.” Citing the need to provide clean programming interfaces allowing for rapid application testing, and referring to Oracle’s move toward providing functionality from the silicon level up, Fowler mentioned the company’s efforts to unite hardware and software engineers to address and improve these aspects. Software in silicon “It’s not just about cores and threads anymore; it’s about putting functions in silicon,” Fowler stated, touching on the goal to provide tools so easily accessible to the consumer that it meets a “built-in, go use it” template. Emphasizing an open interface, with matching libraries and usability, Fowler also envisioned an all-in-memory encrypted data-center as the way of the future. Interconnected ecosystems While Fowler acknowledged that Oracle was committed to improving its services, both for itself and its customers, he also noted that “many of the things we do actually benefit other workloads.” He went on to state that there was “no Oracle monoculture in the world, including at Oracle,” but while the applications of other companies could be useful, there were opportunities open to Oracle that no other vendor could provide. @theCUBE #oow15
Views: 1305 SiliconANGLE theCUBE
Oracle DBA | Startup Mode | Bangla | DBA1-11
 
12:00
Oracle DBA | Startup Mode | Bangla | DBA1-11 To See More DBA part-01 Tutorial Click here https://www.youtube.com/playlist?list=PLXXvCMuixAJUO3yQq7-LLdfQb5HpsQKNg To See More DBA part-02 Tutorial Click here https://www.youtube.com/playlist?list=PLXXvCMuixAJUviefN3-ZzKDVgbIH0RoaS To See More Reports Tutorial Click here https://www.youtube.com/watch?v=y_0f_iILlmY&list=PLXXvCMuixAJUfU4ZISmPtHrmKe5qRvyVY To See More Forms Tutorial Click here https://www.youtube.com/watch?v=Zsu4CWo_vwk&list=PLXXvCMuixAJU3Ap_FE2zSEBicv8IC5kDU Task Of Different Mode: Shutdown Mode: -Create Server parameter file (SPFILE) Nomount Mode: -Rename orcl -restore controlfile from autobackup Mount Mode: -Backup dtabase -Restore Database -Recover Database -Create control file -Enable Archive mode: -Flashback On -Controlfile Autobackup: Open Mode: -Do anything Option for Startup: sql= startup -Instance is created, Database mount and Database opened sql= startup force -Current Instance is aborted, Instance created, Database mount and Database opened sql= startup restrict - Database opened only for users with a restricted session system privilege sql= startup nomount -Only Instance is created sql= startup mount -Instance is created and Database mount Command for Going Different Mode: Shutdown sql=shutdown immediate Nomount/Mount sql=startup nomount/startup mount Mount sql=alter database mount; Open sql=alter database open; To Get more Tutorial Subscribe The Channel click here https://www.youtube.com/channel/UCQ3ea4zVCfnKBx1_7h8raGQ?sub_confirmation=1 To Get All Post Like The Facebook Page Click here https://www.facebook.com/oracledbsolutions Follow us: Facebook: https://www.facebook.com/oracledbsolutions Youtube link: https://www.youtube.com/channel/UCQ3ea4zVCfnKBx1_7h8raGQ?view_as=subscriber Facebook Group: https://www.facebook.com/groups/465557066961548 Contact us: email: [email protected] Skype: oracle26solutions Mob: 01734557080, 01627422780
Views: 84 OracleDB Solutions
ORADCReport(Oracle Database Configuration Report)
 
01:35
ORADCReport (Oracle Database Configuration Report) Version 1 -Providing Database information -Providing Segments Status information -Providing Session information. -Finding the Top SQL List -Finding the Invalid Objects -Table/Index summary -Tablespace size/usage statistics Supported os : windows Supported JRE : Java Runtime Environment 1.8.x on more Installation Windows : Extract the Archive using zip utility.
Views: 29 optimistic lab
Google Map with AngularJS and JSON data from Oracle database.
 
28:03
Google Map created with Javascript and AngularJS. Here we have a Oracle database table of data consisting of list of Countries, their respective cities and state and latitude and longitude. JSON data is retrieved from Oracle database 12c using a JSP module, get_oracle_Data.jsp. Data has been imported from a lat_long.csv file into Oracle database. In this program you select one country, you get the list of cities and you select one city and the map will be generated of that country with the city at the center point of the map. I am giving you the link of a zipped archive which contains three files. gmap2.html, get_oracle_Data.jsp and lat_long.csv. Link : https://drive.google.com/file/d/0BznrW3lgX0ozMnd1U200RWxoNDA/view?usp=sharing
Views: 9766 Subhroneel Ganguly
Oracle Database11g tutorials 9    What is archive log mode and how to enable archive Computer tips a
 
05:43
https://www.youtube.com/playlist?list=PL53Bcp3uVnUwhCtKhfJ93L7WLA0ad3rD8 https://www.youtube.com/watch?v=JLCwcxZG-rs https://www.youtube.com/watch?v=OraHS1xFuLY https://www.youtube.com/watch?v=PurycyztP3Y https://www.youtube.com/watch?v=luN3fDwc4kM https://www.youtube.com/watch?v=ToFwADDUQNI
Install Oracle Java 8 in Linux Part 1
 
05:25
In this video we going to install JAVA-ORACLE-JDK-8 in Linux Step 1: Add Oracle’s PPA(Personal Package Archive) to your list of sources so that Ubuntu knows where to check for the updates. Use add- apt-repository command for that. sudo add-apt-repository ppa:webupd8team/java Step 2: Then update your package repository by issuing the following command. apt-get is a command-line tool for handling packages. sudo apt-get update Steps 3: Then install Oracle JDK 8 using the following. sudo apt-get install oracle-java8-installer Step 4: Once it is installed successfully, check for the Java version. javac -version Step 5: If you have multiple Java packages installed on your machine, to check which version to use as the default type use the following command. sudo update-alternatives --config java Sample output of the above command With the “auto mode”, highest priority alternative will always be selected as the default alternative even when a new or an upgraded package is installed whereas with the “manual mode”, regardless of the priority, your choice will always be considered as the default alternative until you choose another package. Set JAVA_HOME environment variable 1. First, nd out where Java is installed. You can use the same command as the one we use in step 5 for that. 2. Next open /etc/environment le in any of your favorite editor sudo nano /etc/environment 3. Add the following line at the end of the le and save it. (Replace the value for JAVA_HOME with the path of your java installation directory) JAVA_HOME="/usr/lib/jvm/java-8-oracle" 4. Finally reload it and check whether the environment variable has been properly set. source /etc/environment echo $JAVA_HOME
Views: 9 TechDao
Recover Database upto Recent Backup in No Archive mode when  missed all redo groups and any datafile
 
09:40
By Vivek Saxena Shabad Coachings Recover Database upto Recent Backup in No Archive mode when missed all redo groups and any datafile show parameter db_name; startup archive log list alter system switch logfile create table vishu(rn number(10)) tablespace vivek; insert into vishu values(1) commit shut immediate startup ERROR ORA-01257: cannot identify/lock data file ORA-01110: data file shut immediate startup ERROR ORA-00313 open failed for member of log group ORA-00312: online log recover database until cancel //media recovery complete alter database open resetlogs;
Install Oracle Java 8 in Linux Part 2
 
04:22
In this video we going to install JAVA-ORACLE-JDK-8 in Linux Step 1: Add Oracle’s PPA(Personal Package Archive) to your list of sources so that Ubuntu knows where to check for the updates. Use add- apt-repository command for that. sudo add-apt-repository ppa:webupd8team/java Step 2: Then update your package repository by issuing the following command. apt-get is a command-line tool for handling packages. sudo apt-get update Steps 3: Then install Oracle JDK 8 using the following. sudo apt-get install oracle-java8-installer Step 4: Once it is installed successfully, check for the Java version. javac -version Step 5: If you have multiple Java packages installed on your machine, to check which version to use as the default type use the following command. sudo update-alternatives --config java Sample output of the above command With the “auto mode”, highest priority alternative will always be selected as the default alternative even when a new or an upgraded package is installed whereas with the “manual mode”, regardless of the priority, your choice will always be considered as the default alternative until you choose another package. Set JAVA_HOME environment variable 1. First, nd out where Java is installed. You can use the same command as the one we use in step 5 for that. 2. Next open /etc/environment le in any of your favorite editor sudo nano /etc/environment 3. Add the following line at the end of the le and save it. (Replace the value for JAVA_HOME with the path of your java installation directory) JAVA_HOME="/usr/lib/jvm/java-8-oracle" 4. Finally reload it and check whether the environment variable has been properly set. source /etc/environment echo $JAVA_HOME
Views: 8 TechDao
Sentencias Backup Oracle 11g - Open SUSE
 
06:20
Sentencias Utilizadas lsnrctl start sqlplus '/ as sysdeba' startup backup spfile; copiado del archivo de configuración de la instancia. backup current controlfile; copiado del archivo de control. backup archivelog all; copiado de los archivos de archive. list backup; listar copias almacenadas. delete backup; borrar copias de respaldo. delete archivelog all; borrado de archivos. restore database; restaurar la bd. recover database; recuperar la bd a su punto optimo. -------------------------------------------------------------------------- Angelica Dominguez Estefania Gallo Milena Castañeda Sandra Silva Leonardo Mendoza Sebastián Lozano
ORADPReport(Oracle Database Performance Report)
 
01:54
ORADPReport (Oracle Database Performance Report) Version 1 -Providing Top SQL information -Providing RAC Status information -Providing File I/O information. -Finding the Top SQL List -Table/Index I/O summary Supported os : windows Supported JRE : Java Runtime Environment 1.8.x on more Installation Windows : Extract the Archive using zip utility.
Views: 15 optimistic lab
Introduction to Oracle Cloud Infrastructure Block Volume Part2
 
09:04
Duplicating the block storage for development, test or production environments has always been a complex and time-consuming process. Oracle has introduced Clones that enables you to quickly and easily create an identical copy of a block volume without having to first create a backup. This video gives a brief outline on the features of Block Volume and a demonstration of the steps to Create, Attach and Clone volumes. Watch the video to learn more. ================================= 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 and http://docs.oracle.com Copyright © 2018 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.
Archive emails from Exchange and Office 365 to Oracle Sales Cloud
 
05:08
Did you know Riva can customize how your archive emails for Oracle? Watch this short video with Riva CEO Aldo Zanoni to find out how to archive email from Exchange and Office 365 to Oracle Sales Cloud. - - - Struggling with CRM user adoption and need to provide your customer-facing teams with more relevant customer data? Think Riva. Riva unleashes a river of valuable Customer Intelligence currently trapped inside your CRM platform. It gives your customer-facing teams a real-time, 360-degree view of your customers. And the best part? This invaluable customer data is delivered directly to your users’ email systems – where they live. What Riva does: •Brings customer interaction visibility to your entire organization by breaking down the siloed data that exists between your CRM and email systems. Riva delivers the best CRM data automation available to sync your CRM and email data. Riva goes far beyond the capabilities of free plugins with hundreds of advanced configuration options including custom fields and objects. It’s CRM and email integration done your way. •Reveals powerful market and sales intelligence, relationship mapping and analytics, cognitive insights, AI, and related public data directly in Outlook and IBM Notes. •Provides the most advanced and flexible CRM and email integration available directly to your teams’ fingertips. Riva delivers advanced, server-side integrations between the world’s best CRM systems and all leading corporate email collaboration systems. See our full list of integrations http://www.rivacrmintegration.com/integrations/. Riva is trusted by more than 1,200+ companies, including 50 Fortune 500 companies, 15 of the world’s largest banks, numerous Global 1000 companies and small and medium size companies. Get the full ROI you expect from your CRM. Learn more at http://www.rivacrmintegration.com.
Views: 200 crmintegration
What Is A Requisition List?
 
00:47
Hints tips requisitions represent a very large body of data in sap. How to run open po requisition reports in sap it answers. Purchase requisition list toolbox for it groups sap ittoolboxdefine at dictionary. To avoid time out errors me5a display purchase requisitions. Requisition creating purchase orders (single screen transaction) further processinginvolves generating lists of assigned flagged requisitions t code to view list pending archive sap. Saving a requisition as template aug 29, 2007 hi all, can anyone please give me the transaction to display list of purchase in plant based on certain criteria (vendor, definition, act requiring or demanding. They can also add an item from the requisition list to their current order, or entire order use this widget in a catalog entry page layout button that buyers click (sku) they are viewing window displays of planned purchase requisitions issued by last be sorted number, code due diligence template download now. Departments in some small businesses need to order supplies through the financial arm of business rather than buying on their own feb 24, 2011 you can also export purchase requisition list microsoft excel or view documents that are attached a selected sap requisitionschange click icon get. Use this procedure to display a filtered list of purchase requisitions. Customers can add or remove items from the list, and change quantity of. Trigger jan 16, 2010 how can i run a report of open, released po requisitions in sap that and after executing this you will find the list purchase requests with. This means all pending prs. See more purchase requisition creating orders (single screen transaction) further processinginvolves generating lists of assigned flagged requisitions jan 8, 2010 hi,what is the transaction code to see all open requests (no po yet). Material group descriptions a purchase requisition is used by department to instruct the purchasing office list current dateconfirmation order if you or. Simply fill in the blanks and print minutes! instant access to 1800 business legal forms requisitions list displays requisition information into different columns provides tools filter customize may 3, 2012 candidate lists exceeding 1000 candidates. T code to view list of pending purchase requisitions archive sap. Googleusercontent search. Requisition lists ibmaurora starter store requisition list details page (b2b) ibm. Biztree requisition management oracle help center. Due diligence requisition list template & sample form. Requisition list and requisition file. You can use this iview to display purchase requisitions as a list. Taleo enterprise taleo recruiting user guide oracle. A requisition list is a of items that used to create orders at later date. 7 27 20119 07 pmpurpose. A transaction in the erp system is called when you access this iview dec 16, 2013 y_drp_63000033 purchase requisition listing. The difference between a requisition & purchase order. Chron release approved purchase requisition
Views: 70 Your Question I
Enable Archivelog Step by step by Le Anh
 
05:19
Enable Archivelog Step by step by Le Anh with user Oracle step 01: shutdown database shut immediate; step 02: startup nomount; startup nomount; step 02: config prameter: mkdir -p /u01/archivelog alter system set log_archive_start=TRUE SCOPE=SPFILE; System altered. alter system set log_archive_dest_1='LOCATION=/u01/archivelog' scope=spfile; System altered. step 04: Now we mount the database instance: alter database mount; Database altered. Step 05: And finally, we set the database to archive log mode: alter database archivelog; Database altered. Step 06: open database; alter database open; step 07: check archivelog archive log list; switch log ALTER SYSTEM SWITCH LOGFILE; Thanks;
Views: 30 Anh Lê Ngọc
Start and Access P6 EPPM 17.7 on Windows 10 @P-8
 
13:07
In This video I Will Show :- How to Start and Aceess Dashboard of P6 EPPM 17.7 (Enterprise Project Portfolio Management) on Windows 10, Also I Will Show You How To Login :-- - WebLogic Admin Console - Primavera P6 - Primavera P6 Administrator - Web Services - Team Member - P6 Professional Cloud Connect By P6EPPMConfiguration.html (Browser) Also I Will Show You How To Configure P6EPPM Configuration.html (Browser) ====================================================== https://www.youtube.com/watch?v=DCafeAz9aJ0&list=PLQfBfu7k8exCH2rKXihmx0p11y162hVbV https://www.youtube.com/watch?v=L1i9v_6BTuE&list=PLQfBfu7k8exBxJU0G17KajKcBBhJnB8Rf ======================================================== Download Link for (Firefox Setup 52.3.0esr.exe) :- https://ftp.mozilla.org/pub/firefox/releases/52.3.0esr/win32/en-US/ ========================================================Download link for Java SE Runtime Environment 8u151 (jre8):- http://www.oracle.com/technetwork/java/javase/downloads/java-archive-javase8-2177648.html You First Click Upon Link Then You Will Go to Oracle Website, There you will get Many Version of java (jre8) There you only click on under like this link. (Windows x86 Offline 60.72 MB jre-8u151-windows-i586.exe) ======================================================== How to Active Add-on:- Click to Mozilla Browser Right Corner Open Menu @ Come List Click Add-on @ Will Come Add-on Page @ Click Pugins @ Click click Drop Down List of (Java(TM) Platform SE 8) and Select (Always Activate) Then Finish. ====================================================== Complete Primavera P6 Professional Project Management Tutorials :========================== https://www.youtube.com/watch?v=L1i9v_6BTuE&list=PLQfBfu7k8exBxJU0G17KajKcBBhJnB8Rf https://www.youtube.com/watch?v=xSZnViKi-nI&index=2&list=PLQfBfu7k8exBxJU0G17KajKcBBhJnB8Rf https://www.youtube.com/watch?v=DCafeAz9aJ0&list=PLQfBfu7k8exBxJU0G17KajKcBBhJnB8Rf&index=3 https://www.youtube.com/watch?v=jXfo9CcSMj0&index=4&list=PLQfBfu7k8exBxJU0G17KajKcBBhJnB8Rf https://www.youtube.com/watch?v=EkpjQGxNy8Y&list=PLQfBfu7k8exBxJU0G17KajKcBBhJnB8Rf&index=5 https://www.youtube.com/watch?v=90a73liCiKc&list=PLQfBfu7k8exBxJU0G17KajKcBBhJnB8Rf&index=6 https://www.youtube.com/watch?v=9b5VJn6kfFc&index=7&list=PLQfBfu7k8exBxJU0G17KajKcBBhJnB8Rf https://www.youtube.com/watch?v=gH8p-qA3Nj4&index=8&list=PLQfBfu7k8exBxJU0G17KajKcBBhJnB8Rf https://www.youtube.com/watch?v=iv8ECfnOkhU&list=PLQfBfu7k8exBxJU0G17KajKcBBhJnB8Rf&index=9 ===================================================== Help US By Like,Share,Comment and Subscribe This Video for Make More Tutorials for You.Thanks ! ======================================================
Views: 5308 IT TECH BD
SQL tutorial 46: What are System Privileges & How To Grant them using Data Control Language
 
06:26
In this SQL Tutorial you will learn How To Grant System Privilege using Grant Data Control Language (DCL) along with ADMIN OPTION flag. First SQL Tutorial in the series of user privileges in oracle database ------------------------------------------------------------------------ ►►►Timeline◄◄◄ 1:50- Query 1- How To grant Basic System Privilege (i.e.Create Table system privilege) to a user 2:40- Query 2 - How to Grant Multiple System Privilege To a user in Single Grant (Data Control Language) Statement 3:52- Query 3 - How To grant System Privilege To Multiple Users in Single Grant (Data Control Language) Statement 4:50- Query 4- How To Grant System Privilege WITH ADMIN OPTION flag 5:26- WITH ADMIN OPTION demonstration ------------------------------------------------------------------------ Celebrating 1000 subscribers. Thanks a lot guys for all your love and support. ------------------------------------------------------------------------ ►►►LINKS◄◄◄ Blog (Link for SQL Script is at the end of this article) : http://bit.ly/system_privilege_admin_option Link for How To create user ●SQL Tutorial 37 - Using Create User Statement http://youtu.be/4QbK2Y-1LZw ●SQL Tutorial 38- Using SQL Developer http://youtu.be/GS4udgR44Ls ●SQL Tutorial 39- Using Oracle Enterprise Manager http://youtu.be/zGjh-Bb3HrI List of few System Privileges Available in Oracle Database http://wp.me/p3r6sw-7M Previous Tutorial: Introduction To User Privileges http://youtu.be/iQFb86lM1gs ------------------------------------------------------------------------- Copy Cloud referral link || Use this link to join copy cloud and get 20GB of free storage https://copy.com?r=kb4rc1 -------------------------------------------------------------------------- ►Make sure you SUBSCRIBE and be the first one to see my videos! -------------------------------------------------------------------------- Amazon Wishlist: http://bit.ly/wishlist-amazon ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ ►►►Find me on Social Media◄◄◄ Follow What I am up to as it happens on https://twitter.com/rebellionrider https://www.facebook.com/imthebhardwaj http://instagram.com/rebellionrider https://plus.google.com/+Rebellionrider http://in.linkedin.com/in/mannbhardwaj/ http://rebellionrider.tumblr.com/ http://www.pinterest.com/rebellionrider/ You can also Email me at [email protected] 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: 25203 Manish Sharma
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: 346 Praveen Biyyapu
PL/SQL and APEX Applications
 
01:56
Do you work with PL/SQL and Oracle APEX? Then take 86 seconds out of your busy day for some useful technical insight from Oracle ACE Director Roel Hartman.
Views: 835 ArchBeat Archive
2. What is Database Table?
 
01:38
In this video you will learn about Database tables, what are those tables and how they are structured actually. For Support =========== Email: [email protected] Contact Form: http://www.learninhindi.com/home/contact Our Social Media ================ Facebook: https://www.facebook.com/LearnInHindi Twitter: https://twitter.com/LearnInHindi For Training & Videos ===================== For more videos and articles visit: http://www.learninhindi.com Free Java Programming In Hindi Course ===================================== https://www.youtube.com/playlist?list=PLOZ3jentlCDAwwhMyoLISrxkXTADGp7PH Free Oracle PL/SQL Programming In Hindi Course ============================================== https://www.youtube.com/playlist?list=PLB5DA82419C2D99B6 Free C Programming In Hindi Course ================================== https://www.youtube.com/playlist?list=PLOZ3jentlCDAxKpBLMWogxSdy6BZcsAJq Trips & Tricks Channel ====================== https://www.youtube.com/channel/UCGmLfkuCo-3lHHJXRJ9HUMw Programming in Hindi Channel ============================ https://www.youtube.com/channel/UCudElIDgwNrybeAvXIy1HZQ
Views: 110655 ITORIAN
Building Queries with PastPerfect 5.0's Contact List Manager
 
30:09
The most useful contact lists are built by understanding the database and the query process that places contacts onto a list. In this webinar, we use real-world examples to show how a few simple steps can maximize results.
Views: 3845 PastPerfectSoftware
Efficient Task Management with JDeveloper and Developer Cloud Service
 
01:59
Throw your to-do list out the window! Shay Shmeltzer shares a tip on how JDeveloper and Oracle's Developer Cloud Service can do a better job of managing your development tasks. For more information: Agile Development with Oracle Developer Cloud Service and JDeveloper 12.2.1: https://blogs.oracle.com/shay/entry/agile_development_with_oracle_developer JDeveloper 12c (12.2.1) Integration with Oracle Developer Cloud Service: https://www.youtube.com/watch?v=XPoaceZiuaE Get a DevCS trial as part of Java Cloud Service: https://myaccount.cloud.oracle.com/mycloud/faces/trialsignup.jspx
Views: 463 ArchBeat Archive
[Archived][1.0 SPS 09] SAP HANA Administration: System Replication, Concepts - SAP HANA Academy
 
07:45
For the latest videos, see the playlist: https://www.youtube.com/playlist?list=PLkzo92owKnVxBAv4lAEcXqP7FWpXwoUfe In this video tutorial series we will show you how to setup and manage SAP HANA System Replication. In this video, Denys van Kempen briefly discusses some of the concepts. If you like our video tutorials, please subscribe to our channel: http://youtube.com/saphanaacademy MORE INFORMATION You can read more about system replication in my blog: https://blogs.sap.com/2015/05/19/sap-hana-system-replication/ BLOGS Stay up to date with our latest blogs on SAP.com: https://people.sap.com/denys.kempen https://people.sap.com/philip.muggles... Do you speak a different language to English? Did you know you can submit Subtitles on all of our videos on YouTube? For instructions how to do this click here: https://goo.gl/M1Ca4J SOCIAL MEDIA Feel free to connect with us at the links below: LinkedIn: https://linkedin.com/saphanaacademy Twitter: https://twitter.com/saphanaacademy Facebook: https://www.facebook.com/saphanaacademy/ Google+: https://plus.google.com/+saphanaacademy Github: https://github.com/saphanaacademy
Views: 13532 SAP HANA Academy
Using the Declarative Features in Oracle APEX | Joel Kallman
 
02:56
Joel Kallman, Director of Software Development for Oracle and the man to see if you have questions about working with Oracle Application Express, goes into overtime with his tip about using APEX's declarative features.
Views: 1324 ArchBeat Archive
The Zombies | NPR MUSIC FRONT ROW
 
10:19
Imagine creating the best work of your life, some of the best music of its day, and no one cares. Now imagine playing those songs 47 years later to a screaming and loving bunch of fans and getting what seems like a hero's welcome. That's part of the story of The Zombies, who played the classic 1968 album Odessey and Oracle, along with a set of other hits and brand new songs, live in Washington, D.C. last month. Now we have their nearly note-for-note live reproduction of Odessey and Oracle for you here. Odessey and Oracle is now thought of as a masterpiece of pop, in the same vein as The Beatles' Sgt. Peppers Lonely Hearts Club Band and The Beach Boys' Pet Sounds. But shortly after the album's release, The Zombies broke up. Rod Argent went on to form the popular band Argent, Colin Blunstone received some love as a solo artist and over time Odessey and Oracle found an audience and critical acclaim. You can listen to the full audio of The Zombies' two-set D.C. concert here, including a set of new songs and favorites and then Odessey and Oracle in full. We also have video of two songs, one the classic tune "Time of the Season" and the tune "Chasing the Past" from the group's brand new album Still Got That Hunger. We also have an interview with Rod Argent and Colin Blunstone about how it differs to write songs at twenty as opposed to being seventy years and a bit about the making of Odessey and Oracle. -- BOB BOILEN Link to interviews and full audio from concert: http://www.npr.org/event/music/453961... SET LIST Time of the Season - 0:38 Chasing the Past - 5:38 Featuring: Rod Argent, Colin Bluntstone, Viv Boucherat, Hugh Grundy, Tom Toomey, Jim Rodford, Darian Sahanaja and Chris White Director: Mito Habe-Evans; Producer: Saidah Blount, Mito Habe-Evans, Bob Boilen; Videographers: Mito Habe-Evans, Morgan McCloy, Julia Reihs, Cameron Robert; Editor: Cameron Robert; Audio Engineers: Dale Hanson, Josh Rogosin; Special Thanks: Lincoln Theatre; Executive Producer: Anya Grundmann
Views: 17957 NPR Music
[Archived][1.0 SPS 10] SAP HANA What's New? Database Backup and Recovery - SAP HANA Academy
 
06:04
For the latest videos, see the playlist: https://www.youtube.com/playlist?list=PLkzo92owKnVyhAGmDP4OsoPIj15-FEHtH In this video tutorial, Denys van Kempen demonstrates the new features for database backup and recovery for SAP HANA SPS 10. Thank you for watching. Video by the SAP HANA Academy.
Views: 5690 SAP HANA Academy
Working with tar and archived files in Linux/AIX | Extracting/listing single file from a tar archive
 
13:20
In this tutorial, I will show you how to work with archived files, tar balls, and zipped files in Linux. We can see how to list files for a tar ball or a archived files. We shall learn how to extract a single from a tar archive. We can loop inside , grep for a pattern in a archived file without actually decompressing it. Please subscribe to my youtube channel for such tutorials Please watch the split a file by line number here: https://youtu.be/ADRmbu3puCg Split utility in Linux/Unix : to break huge file into small pieces https://www.youtube.com/watch?v=ADRmbu3puCg How to keep sessions alive in terminal/putty infinitely in linux/unix : Useful tips https://www.youtube.com/watch?v=ARIgHdpxaU8 Random value generator and shuffling in python https://www.youtube.com/watch?v=AKwnQQ8TBBM Intro to class in python https://www.youtube.com/watch?v=E6kKZXHS5hM Lists, tuples, dictionary in python https://www.youtube.com/watch?v=Axea1CSewzc Python basic tutorial for beginners https://www.youtube.com/watch?v=_JyjbZc0euY Python basics tutorial for beginners part 2 -variables in python https://www.youtube.com/watch?v=ZlsptvP69NU Vi editor basic to advance part 1 https://www.youtube.com/watch?v=vqxQx-NNyFM Vi editor basic to advance part 2 https://www.youtube.com/watch?v=OWKp2DLaFyY Keyboard remapping in linux, switching keys as per your own choice https://www.youtube.com/watch?v=kJz7uKDyZjs How to install/open an on sceen keyboard in Linux/Unix system https://www.youtube.com/watch?v=d71i9SZX6ck Python IDE for windows , linux and mac OS https://www.youtube.com/watch?v=-tG54yoDs68 How to record screen or sessions in Linux/Unix https://www.youtube.com/watch?v=cx59c15-c8s How to download and install PAGE GUI builder for python https://www.youtube.com/watch?v=dim725Px2hM Create a basic Login page in python using GUI builder PAGE https://www.youtube.com/watch?v=oCAWWUhwEUQ Working with RadioButton in python in PAGE builder https://www.youtube.com/watch?v=YJbQvpzJDr4 Basic program on Multithreading in python using thread module https://www.youtube.com/watch?v=RGm3989ekAc
Views: 90 LinuxUnixAix
Enable/Disable Archive Log Mode 10g/11g
 
04:48
Note: It is recommended to perform a backup of the database (after a shutdown normal or immediate) prior to changing the archive status of a database.
Views: 302 nvtrong1984
How does PostgreSQL work with disks: a DBA’s checklist in detail
 
47:46
Check out http://www.pgconf.us/2015/event/82/ for the full talk details. PostgreSQL like any other classical database interacts with disks heavily and has dozens of disk-related settings. In order to keep an instance up and running under even moderate workloads, an average DBA needs to dig through PostgreSQL documentation, operating system documentation, hardware vendor manuals, a few books, plenty of blog posts, [HACKERS] and [PERFORM] mail lists archive and finally gain a couple years of experience. This talk will guide DBAs through a checklist, that allows to maximize the disk performance of a PostgreSQL installations. I will concisely summarize typical DBA tasks on four levels: choosing and setting up hardware, operating system configuration, file system mounting with proper options, and PostgreSQL tuning itself. The talk will include but is not limited to such important topics as monitoring I/O-related metrics, checkpoint tuning, autovacuum tuning. About the Speaker Ilya is a co-founder and DBA at PostgreSQL-Consulting.com. His previous experience encompasses such commercial databases as Oracle and DB2. Currently, Ilya works primarily with PostgreSQL with a focus on its performance and effective use in production. He sees the mission of PostgreSQL in substituting the commercial databases in high-performance mission-critical applications.
Views: 4505 Postgres Conference
[Archived][1.0 SPS 09] SAP HANA Administration, Creating Multi-tenant Connections - SAP HANA Academy
 
02:53
For the latest videos, see the playlist: https://www.youtube.com/playlist?list=PLkzo92owKnVxBAv4lAEcXqP7FWpXwoUfe Thank you for watching. Video by the SAP HANA Academy.
Views: 11287 SAP HANA Academy
[VG-V-BT04 Proxy test 080119] Link Joker vs Murakumo (Shirayuki)
 
12:19
BT04 Card list http://blog.livedoor.jp/freedomduo/archives/54297399.html ++++++++++ TD07 card list http://blog.livedoor.jp/freedomduo/archives/54297403.html ++++++++++ Deck list http://blog.livedoor.jp/freedomduo/archives/54620810.html
Views: 4189 Freedom duo
[Archived][1.0 SPS 11] SAP HANA Administration: SDA, ODBC on Windows - SAP HANA Academy
 
09:36
For the latest videos, see the playlist: https://www.youtube.com/playlist?list=PLkzo92owKnVxBAv4lAEcXqP7FWpXwoUfe In this video tutorial, Denys van Kempen discusses basic ODBC concepts using the Windows platform. Thank you for watching. Video by the SAP HANA Academy.
Views: 4975 SAP HANA Academy
04.03-01 Oracle_10gR2_DataGuard_4.3 Step 1 Enable Archivelog Mode and Flashback Database.avi
 
01:49
Oracle 10g/11g RAC, DataGuard, GoldenGate,Streams Hands-on Practices Training. Please feel free to contact me: E-mail/Skype: [email protected] Oracle Database 10gR2 High Availability with Data Guard on Linux http://www.youtube.com/playlist?list=PLCEC4947864F3B571 4. Configure Primary and two Physical Standby Databases 4.1 Configure the Primary Database - (Video) Step 1: Enable Archivelog Mode and Flashback Database - (Video) Step 2: Create a Password file - (Video) Step 3 Enable Force Logging - (Video) Step 4: Create Standby Redo Logs - (Video) Step 5: Configure Oracle Net Components on Primary Database - (Video) Step 6: Configure the Primary Database Initialization Parameters - (Video) Step 7: Create a Backup of the Primary Database - (Video) Step 8: Update /etc/hosts file on all nodes and Verify Network - (Video) 4.2 Configure the First Physical Standby Database(xiamen) - (Video) Step1: Enable Archivelog Mode and Flashback Database - (Video) Step2: Create a Password file - (Video) Step3 Enable Force Logging - (Video) Step4: Create Standby Redo Logs - (Video) Step5: Create Directories on the Standby Host - (Video) Step6: Transfer the files to the standby host - (Video) Step7: Create a spfile for the Standby Instance - (Video) Step8: Configure Oracle Net Components on Primary Database - (Video) Step9: Start the standby database nomount - (Video) Step10: Create the Physical Standby Database - (Video) Step11: Start mount the Physical Standby Database - (Video) Step12: Start Redo Apply on the Standby Database - (Video) Step13: Enable Flashback Database - (Video) Step14: Add Standby Redo Logs for the Physical Standby Database if necessary - (Video) 4.3 Configure the Second Physical Standby Database - (Video) Step1: Enable Archivelog Mode and Flashback Database - (Video) Step2: Create a Password file - (Video) Step3 Enable Force Logging - (Video) Step4: Create Standby Redo Logs - (Video) Step5: Create Directories on the Standby Host - (Video) Step6: Transfer the files to the standby host - (Video) Step7: Create a spfile for the Standby Instance - (Video) Step8: Configure Oracle Net Components on Primary Database - (Video) Step9: Start the standby database nomount - (Video) Step10: Create the Physical Standby Database - (Video) Step11: Start mount the Physical Standby Database - (Video) Step12: Add Standby Redo Logs for the Physical Standby Database if necessary - (Video) Step13: Start Redo Apply on the Standby Database - (Video) Step14: Enable Flashback Database and Add Standby Redo Logs if necessary - (Video) 4.4 Verifying the Physical Standby Database - (Video) 4.5 Startup and Verify Physical Standby Database - ()
Views: 255 Yongcheng Lai
Oracle Data Guard in Ten Minutes, Part 2, Demonstration
 
04:02
Watch all 3 parts of this tutorial, free, at http://skillbuilders.com/how-to-setup-data-guard-in-10-minutes. Learn how to configure Oracle 12c Data Guard in this free tutorial from Certified Master John Watson and Dave Anderson of SkillBuilders. John demonstrates setting up a physical standby database - in ten minutes! In this lesson John provides an overview of the steps involved in setting up a 12c physical standby database.
Views: 2019 SkillBuilders
SQL tutorial 36: how to create database using database configuration assistant DBCA
 
12:11
Step by step process of creating oracle database using DBCA database configuration assistant, how to unlock user account of sample schema WATCH FULL VIDEO TO KNOW HOW TO UNLOCK HR SCHEMA Tutorial Consist: How to create general purpose transaction database using DBCA database configuration assistant in Oracle 11g, Links How to create database detail blog: http://bit.ly/how-to-create-database-using-dbca What is archiving and archivelog mode: http://bit.ly/what-is-archiving-in-oracle-database Video Tutorial 1 How to install oracle 11g database http://youtu.be/0NLsJQCvKXY Video tutorial http://youtu.be/-13SbeDavwk Copy Cloud referral link || Use this link to join copy cloud and get 20GB of free storage https://copy.com?r=kb4rc1 Amazon Wishlist: http://bit.ly/wishlist-amazon Contacts E-Mail [email protected] Twitter https://twitter.com/rebellionrider Instagram http://instagram.com/rebellionrider Facebook. https://www.facebook.com/imthebhardwaj Linkedin. http://in.linkedin.com/in/mannbhardwaj/ Thanks for liking, commenting, sharing and watching more of our videos This is Manish from RebellionRider.com
Views: 63054 Manish Sharma
[Archived][1.0 SPS 09] SAP HANA Administration: System Replication, Setup - SAP HANA Academy
 
12:35
For the latest videos, see the playlist: https://www.youtube.com/playlist?list=PLkzo92owKnVxBAv4lAEcXqP7FWpXwoUfe In this video tutorial series we will show you how to setup and manage SAP HANA System Replication. In this video, Denys van Kempen demonstrates how to enable replication using SAP HANA studio and using the hdbnsutil tool on the command line. Thank you for watching. Video by the SAP HANA Academy.
Views: 15125 SAP HANA Academy
Using Oracle ADF Libraries  | Sten Vesterli
 
02:44
Oracle ACE Director Sten Vesterli, author of "Oracle ADF Enterprise Application Development – Made Simple: Second Edition" (Packt Publishing) shares a quick tip on using ADF libraries and building a solid foundation for ADF applications.
Views: 619 ArchBeat Archive
Oracle RMAN - Backup Recovery Overview
 
02:46
http://oracledbazerotopro.com This video provides an overview of backup and recovery concept.
Views: 16271 HandsonERP
MAF: 10. Feature Reuse (FARs) in Oracle MAF
 
06:08
Each feature defined in an Oracle MAF application can be reused and shared between applications. In this video you will see how to package up a feature into a feature archive, and import and then reuse that feature in a different application.
SCPT 42: What is redo and undo in Oracle
 
21:56
Oracle DBA Tutorials For Full Course Experience Please Go To http://mentorsnet.org/course_preview?course_id=6 Full Course Experience Includes 1. Access to course videos and exercises 2. View & manage your progress/pace 3. In-class projects and code reviews 4. Personal guidance from your Mentors
Views: 26742 Oresoft LWC
[Archived][1.0 SPS 09] SAP HANA Administration: Configuring System Properties - SAP HANA Academy
 
09:19
Administration For the latest videos, see the playlist: https://www.youtube.com/playlist?list=PLkzo92owKnVxBAv4lAEcXqP7FWpXwoUfe In this video tutorial, Denys van Kempen demonstrates how to configure SAP HANA system properties (INI files). This video has been updated for SPS 09. Thank you for watching. Video by the SAP HANA Academy.
Views: 4811 SAP HANA Academy
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)