Home
Search results “Delete export job oracle”
Oracle DBA Justin - How to drop/delete an Oracle database
 
09:03
How to delete/drop an Oracle database
Views: 15167 jbleistein11
Oracle Data Export and Import using DataPump expdp and impdp
 
09:38
Oracle Data Export and Import using DataPump expdp and impdp
Views: 183726 Abbasi Asif
Oracle Database 11g: Import schema objects
 
08:19
Import schema objects: The Export and Import utilities provide a simple way for you to transfer data objects between Oracle databases, even if they reside on platforms with different hardware and software configurations. When you run Export against an Oracle database, objects (such as tables) are extracted, followed by their related objects (such as indexes, comments, and grants), if any. The extracted data is written to an export dump file. The Import utility reads the object definitions and table data from the dump file. An export file is an Oracle binary-format dump file that is typically located on disk or tape. The dump files can be transferred using FTP or physically transported (in the case of tape) to a different site. The files can then be used with the Import utility to transfer data between databases that are on systems not connected through a network. The files can also be used as backups in addition to normal backup procedures. Export dump files can only be read by the Oracle Import utility. The version of the Import utility cannot be earlier than the version of the Export utility used to create the dump file. Follow me: https://www.facebook.com/Oracle-DB-592800217490198/ Oracle Database 11g: Export schema objects Oracle Database11g: How to uninstall oracle 11g from windows 7 | Uninstall 11g | Deinstall 11g How to install Oracle Database 11g on windows 7 easy and step by step
Views: 6359 Leen's Tech
Oracle Database 11g: Export schema objects
 
04:14
Export schema objects: The Export and Import utilities provide a simple way for you to transfer data objects between Oracle databases, even if they reside on platforms with different hardware and software configurations. When you run Export against an Oracle database, objects (such as tables) are extracted, followed by their related objects (such as indexes, comments, and grants), if any. The extracted data is written to an export dump file. The Import utility reads the object definitions and table data from the dump file. An export file is an Oracle binary-format dump file that is typically located on disk or tape. The dump files can be transferred using FTP or physically transported (in the case of tape) to a different site. The files can then be used with the Import utility to transfer data between databases that are on systems not connected through a network. The files can also be used as backups in addition to normal backup procedures. Export dump files can only be read by the Oracle Import utility. The version of the Import utility cannot be earlier than the version of the Export utility used to create the dump file. Follow me: https://www.facebook.com/Oracle-DB-592800217490198/ Oracle Database 11g: Import schema objects Oracle Database11g: How to uninstall oracle 11g from windows 7 | Uninstall 11g | Deinstall 11g How to install Oracle Database 11g on windows 7 easy and step by step
Views: 1081 Leen's Tech
5.How to Remap Tablespaces and Schema using Oracle Import/Export Tool
 
06:40
Hi guys in this video you learn How to Remap Tablespaces and Schema using Oracle Import/Export Tool. #RemapTablespaces #Remapschema #OracleImport/ExportTool Oracle database Unbeatable,Unbreakable Platform..
Views: 3027 Oracle World
Scheduling SQL Server Jobs with SQL Agent
 
09:48
Learn more about Logical Read: http://bit.ly/Logicalread_SQLAgent Discover how to take advantage of SQL Agent to automate many of your routine IT database infrastructure tasks. Connect with SolarWinds: THWACK: http://thwack.solarwinds.com/ Facebook: https://www.facebook.com/SolarWinds Twitter: https://twitter.com/solarwinds LinkedIn: http://www.linkedin.com/company/solarwinds
Views: 53718 solarwindsinc
What is Data Loader and How to use it to import/export data to/from Salesforce?
 
25:47
Here comes the quick demo of how to use Data Loader to import or export data to or from Salesforce. This video is divided into following points : - How to install Data Loader? - How to Insert records into Salesforce through Data Loader? - How to Export records from Salesforce through Data Loader? - How to Upsert records in Salesforce with Data Loader? - How to Update records in Salesforce with Data Loader? - How to Delete records in Salesforce with Data Loader? Completely understand Data Loader in Salesforce with Shrey Sharma (Salesforce Hulk). Link to upvote the idea: https://success.salesforce.com/ideaView?id=08730000000H7MAAA0 My Linkedin Profile: https://in.linkedin.com/in/shreyshrma Facebook Page: https://www.facebook.com/SalesforceHulk/ Tweet me at: https://twitter.com/shrey_shrma Salesforce Hulk Website: www.salesforcehulk.com
Views: 20591 Salesforce Hulk
Windows Task Scheduler Overview on Windows Server 2012
 
09:37
Task Scheduler Overview on Windows Server 2012. Task Scheduler helps to schedule automated tasks that perform actions at a specific time or when a certain event occurs. It provids an organized view for all the tasks and a convenient point of access to managing them.
Views: 85268 Sachin Samy
04. SQL Developer Tutorial -  How to Export Data
 
09:40
This video tutorial provides detailed information about various options available to export data using Sql Developer
Views: 3058 Sandip M
Oracle 11G Import-Export Ej:1
 
12:28
Creacion, exportacion, eliminacion e importacion de las tablas con Oracle 11G
Views: 2861 WilderK Diaz
Formatting your Oracle Query Results Directly to CSV
 
03:02
How to get Oracle SQL Developer to automatically format your query results to CSV, HTML, JSON, Insert statements, and more.
Views: 45871 Jeff Smith
Customizing Your Terminal: .bash_profile and .bashrc files
 
08:20
In the next few videos, we will be taking a look at how to customize our terminal with dotfiles. First, we need to understand the main dotfiles we will be working with, the .bashrc and .bash_profile files. What is the difference between these files and which one should you modify in order to customize your terminal? Let find out... Next Video on Customizing Your Prompt: https://youtu.be/LXgXV7YmSiU Next Video on Dotfiles: https://youtu.be/c5RZWDLqifA If you enjoy these videos and would like to support my channel, I would greatly appreciate any assistance through my Patreon account: https://www.patreon.com/coreyms Or a one-time contribution through PayPal: https://goo.gl/649HFY If you would like to see additional ways in which you can support the channel, you can check out my support page: http://coreyms.com/support/ Equipment I use and books I recommend: https://www.amazon.com/shop/coreyschafer You can find me on: My website - http://coreyms.com/ Facebook - https://www.facebook.com/CoreyMSchafer Twitter - https://twitter.com/CoreyMSchafer Google Plus - https://plus.google.com/+CoreySchafer44/posts Instagram - https://www.instagram.com/coreymschafer/
Views: 78418 Corey Schafer
Oracle DBA Justin - The delete command is a DML, and the truncate command is a DDL statement
 
09:00
The delete command is a DML, and the truncate command is a DDL statement
Views: 2099 jbleistein11
Load data into Dynamics CRM using SSIS - Insert, Update, Delete, Upsert
 
23:20
Learn how to load SQL Server data into Dynamics CRM using SSIS (Bulk Insert, Upsert, Delete, Update). Read below article for step by step tutorial. https://zappysys.com/blog/load-dynamics-crm-using-ssis-insert-upsert-delete-update/ Above article covers following topics. 1 Introduction 2 Requirements 3 Getting Started 3.1 Configure SSIS Dynamics CRM Connection 3.2 Bulk Insert – SQL Server data Import into Dynamics CRM using SSIS 3.3 Bulk Upsert – Update or Insert Dynamics CRM Records in SSIS 3.3.1 Create Alternate Key for CRM Upsert 3.3.2 Configure SSIS CRM Destination for Upsert 3.3.3 Handling Inserted / Updated Records Output 3.4 Bulk Update – Modify Dynamics CRM Records in SSIS 3.5 Bulk Delete – Delete Dynamics CRM Records in SSIS 4 Error Handling 5 Handling Special Data Types (PartyList, Lookup, PickList) 6 Conclusion 6.1 Share this: 6.2 Related ====================================== SSIS Dynamics CRM Destination Connector (Dynamics 365 / On-Premises CRM) ====================================== SSIS Dynamics CRM Destination Connector can be used to perform bulk insert, update, delete and upsert operation on Microsoft Dynamics CRM Service such as Dynamics 365 Online or On-Premises installation. Features ------------- Bulk Insert data to Microsoft Dynamics CRM service from any source such as SQL Server, JSON, Oracle Support for Bulk Upsert (Insert or Update) Support for Bulk Delete Support for New record Output (Useful to detect New vs Updated when you use Upsert) Support for Error Handling (Error output for failed records) Support for SQL Server 2017, 2016, 2014, 2012, 2008 (32/64 bit) and now Azure Data Factory =========================================== Here is another article which explains how to read data from Dynamics 365 or On Premises CRM Instance. https://zappysys.com/blog/ssis-dynamics-crm-read-import-crm-365-onpremises/ This article covers following topics. 1 Introduction 2 Requirements for SSIS Dynamics CRM read component 3 SSIS Dynamics CRM Source – Video Tutorial 4 Getting started with SSIS Dynamics CRM read component 4.1 Configure Dynamics CRM Connection 4.2 How to create a Dynamics CRM Source 4.3 Configure SQL Server Destination 4.4 Load Dynamics CRM Data to SQL Server 5 How to query Dynamics CRM 5.1 How to generate a FetchXML query using UI 5.2 SELECT All Columns (*) 5.3 SELECT Specified Columns and Alias with SSIS Dynamics CRM 5.4 WHERE (AND conditions) 5.5 WHERE (OR conditions) 5.6 WHERE (Mixing AND / OR conditions) 5.7 SELECT DISTINCT (Exclude duplicates) 5.8 SELECT TOP using SSIS Dynamics CRM read 5.9 GROUP BY / Aggregate functions 5.10 INNER JOIN (matching child records) 5.11 LEFT OUTER JOIN (‘not in’ type query) 5.12 ORDER BY 5.13 OPERATOR – Equal ( = ) 5.14 OPERATOR – Not Equal ( != ) 5.15 OPERATOR – Greater Than 5.16 OPERATOR – Less Than 5.17 OPERATOR – IN (Check for multiple matching values) 5.18 OPERATOR – NULL (Check for NULL values) 5.19 OPERATOR – NOT NULL (Check for NOT NULL values) 5.20 OPERATOR – LIKE (Pattern search) 5.21 OPERATOR – NOT LIKE (Pattern search) 5.22 OPERATOR – UNDER (Find all children for given hierarchy) with the SSIS Dynamics CRM read task 5.23 Using DateTime Operators with the SSIS Dynamics CRM read task 5.24 Query – All activities (sort, outer join, alias) with the SSIS Dynamics CRM read task 6 How to use SSIS variables with Fetch XML in SSIS for SSIS Dynamics 7 CRM read ===================================================== SSIS Dynamics CRM Source Connector (Dynamics 365 / On-Premises CRM) ===================================================== SSIS Dynamics CRM Source Connector can be used to read data from Microsoft Dynamics CRM Service such as Dynamics 365 Online or On-Premises installation. You can use simple Table mode or write custom Query to extract desired data. Features ------------- Multiple modes (i.e. Table or Query) to read data from Dynamics CRM Online or On-Premises version Support for FetchXML Query language Support for automatic conversion between UTC date/time and Local date/time Intuitive user interface with Dynamics CRM Object Browser Support for data preview, max rows, batch size Support for Dynamic query (using SSIS Variable placeholder e.g. {{User::MyVar}} ) Support for SQL Server 2017, 2016, 2014, 2012, 2008 (32/64 bit) and now Azure Data Factory
Views: 1857 ZappySys
How to schedule job using cron tab in Linux
 
08:00
This video illustrates how to Schedule job using cron tab in Linux. Cron tab allows Linux and Unix users to run commands or scripts at a given date and time. For more explanation on this video: https://www.linuxhelp.com/how-to-schedule-job-using-cron-tab-in-linux/
Views: 6762 Linux Help
Oracle using SQL Developer Data Pump for export and import
 
04:50
Using Oracle SQL Developer to export and import data via the data pump facilities.
Views: 68103 thehighway360
SQL Database Basics: Create Table, Insert, Update and Delete
 
25:08
This video is an introduction to SQL. In the video, you will learn how to create a table, add data to the table, update the data in a table, and delete data from a table. Web Development Courses: https://prettyprinted.com Subscribe: http://www.youtube.com/channel/UC-QDfvrRIDB6F0bIO4I4HkQ?sub_confirmation= Twitter: https://twitter.com/pretty_printed Facebook: https://www.facebook.com/prettyprintedtutorials/ Github: https://github.com/prettyprinted Instagram: https://www.instagram.com/pretty_printed Google Plus: https://plus.google.com/+PrettyPrintedTutorials
Views: 460 Pretty Printed
Loading Supplier Data File Using FBDI - Oracle Fusion
 
04:51
This file explains how to load supplier data file in Fusion for migrating suppliers data. For more details leave your queries
How to load job v2 0
 
04:32
How to Load job in HCM Cloud
DELETE SQL QUERY
 
01:44
DELETE SQL QUERY A Job Portal http://www.InterviewDot.com http://www.InterviewDot.com http://www.InterviewDot.com One Click Dream Job - http://www.interviewdot.com/upload-resume/uploadresume.htm Are you looking for a new Job ? InterviewDot.com - A Job Portal http://www.InterviewDot.com http://www.InterviewDot.com http://www.InterviewDot.com One Click Dream Job - http://www.interviewdot.com/upload-resume/uploadresume.htm JAVA/SPRING/SQL/JUNIT INTERVIEW QUESTION AND ANSWER DELETE SQL QUERY
Views: 56 Interview DOT
SQL Tutorial - 13: Inserting Data Into a Table From Another Table
 
07:00
In this tutorial we'll learn to use the INSERT Query to copy data from one table into another.
Views: 258258 The Bad Tutorials
HOW TO DELETE A ROW FROM TABLE SQL
 
02:28
HOW TO DELETE A ROW FROM TABLE SQL A Job Portal http://www.InterviewDot.com http://www.InterviewDot.com http://www.InterviewDot.com One Click Dream Job - http://www.interviewdot.com/upload-resume/uploadresume.htm Are you looking for a new Job ? InterviewDot.com - A Job Portal http://www.InterviewDot.com http://www.InterviewDot.com http://www.InterviewDot.com One Click Dream Job - http://www.interviewdot.com/upload-resume/uploadresume.htm JAVA/SPRING/SQL/JUNIT INTERVIEW QUESTION AND ANSWER HOW TO DELETE A ROW FROM TABLE SQL
Views: 121 Interview DOT
How to Use AWS Import/Export Service from Amazon
 
15:55
Get more great tips at Online Tech Tips http://www.online-tech-tips.com This step-by-step tutorial will guide you through the process for sending an external hard drive to Amazon for uploading large amounts of data to Amazon S3 or Glacier using the AWS Import/Export service. In this video, you'll learn the following: 1. How to sign up for Amazon Web Services 2. Download the AWS Import/Export tool 3. How to edit the AWSCredentials.properties file 4. How to view your Access Key and Secret Key for AWS 5. How to create and fill out the manifest file 6. How to create a job and get a job ID 7. How to fill out the packing slip 8. How to pack your external hard drive and ship it to Amazon If you liked the video, please subscribe to my channel: https://www.youtube.com/user/onlinetechtips https://plus.google.com/116817773084272661914/ http://www.facebook.com/pages/Online-Tech-Tips/94959006140 http://twitter.com/onlinetechtips
Views: 23341 Online Tech Tips
Importing Data from Excel into Oracle Database using SQL Developer 4.1
 
02:23
One of SQL Developer’s most popular features has undergone a significant upgrade. Users can quickly define and recall delimited or Excel files to be imported to a new or existing Oracle table. Data preview and validation is provided for each column, as well as ‘best guess’ data type and date format mask mapping. This process can now be automated via the SQL Developer command line interface (SDCLI) ‘Import’ command. NOTE: This is a video only. There is no audio. Copyright © 2015 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.
cpanel cron job to take mysql database backup
 
10:22
How to take mysql database backup using db backup cron job in cpanel/whm. Find step by step tutorial at http://edurab.com/how-to-take-mysql-database-backup-using-cron-job-in-cpanel-35
Views: 755 fundum99
Oracle DBA Justin - How to set the Oracle environment on a Unix or Linux system
 
28:22
How to set the Oracle environment on a Unix or Linux system
Views: 49216 jbleistein11
Get Table Names with Column Names and Data Types in SQL Server - SQL Server Tutorial
 
05:47
In this video ,we will generate the script that will return us all the table names with column names and data type of those columns. We often need this information. Let's say we are going to prepare mapping document for load the data from Source Database to Destination database. We can get the list of all tables with column names and data types from Source Database and Destination Database and then paste in Excel and map the required input columns to output columns for ETL Process. Blog link with scripts used in video http://sqlage.blogspot.com/2015/02/get-all-tables-with-column-names-and.html
Views: 49497 TechBrothersIT
AWS RDS SQL Server Database Restore using S3
 
21:51
In this video we will restore a Microsoft SQL Server Backup to our AWS RDS SQL Server Instance.
Views: 13558 Jon Jensen
[Archived][1.0 SPS 07] SAP HANA Database Backup and Recovery, Backup Catalog - SAP HANA Academy
 
08:41
For the latest videos, see the playlist: https://www.youtube.com/playlist?list=PLkzo92owKnVyhAGmDP4OsoPIj15-FEHtH This video is part of a tutorial series on SAP HANA backup and recovery. In this video we discuss the backup catalog and the tools hdbbackupdiag and hdbbackupcheck. For more videos, please visit us at academy.saphana.com
Views: 8128 SAP HANA Academy
Unix tutorial : Unix Shell Script to connect Oracle database
 
05:00
Unix tutorial : Unix Shell Script to connect Oracle database This tutorial will show you how to connect oracle database using the command line in Unix. Here Unix shell scripting is used to connect the database using the sqlplus command. And you can see how to retrieve data from database using the shell script 1)Oracle tutorial : How to connect oracle database using sqlplus command line https://www.youtube.com/watch?v=N2DAK2ty8Gc 2)Job In Oracle : pl sql create job in Oracle Scheduler https://www.youtube.com/watch?v=Nwmt5S4Mod8&t=248s You can learn useful shell scripts for oracle dba oracle scripts for dba in unix oracle dba scripts Subscribe on youtube: https://www.youtube.com/channel/UCpiyAesWNYOXSz5GPq8lbkA For more tutorial please visit #techquerypond https://techquerypond.com https://techquerypond.wordpress.com https://twitter.com/techquerypond sqlplus connect to databaseoracle database monitoring shell scripts
Views: 24572 Tech Query Pond
#FREE Remove #Watermark in Filmora for #Lifetime ||All Version of #Filmora
 
23:08
Wondershare Filmora से video export करें वो भी Watermark के बिना जिनदगी भर के लिए दोस्तों मै इस विडियो मे वो सारी बातें बताया हूँ जिससे की आपको बहुत हेल्प करेगा जब आप Wondershare Filmmora से विडियो edit करने के बाद जब आप विडियो एक्सपोर्ट करते हैं तो वहाँ पे आपसे registered emial id और registration कोड़े मांगता है तो आप वहाँ पे फिर एक्सपोर्ट नहीं कर पाते है नहीं तो export कर भी लेते हैं तो आपके video मे Watermark आ जाता होगा तो मै इसका समाधान लेकर आया हूँ । आप ये विडियो पूरा पूरा देखे और जैसे हमने इस विडियो सारा steps बताया है आप बस उसी तरह करेंगे तो आप अपना विडियो एक्सपोर्ट कर लेंगे वो भी बिना Water Mark के हमेशा lifetime । ये Trick आपको Lifetime के लिए इस्तेमाल होगा । आप इसे theoritical पढ़ भी सकते हैं इस लिंक पे जाएँ और पढ़ें :https://www.aashiquetechsolutions.com/2018/10/how-to-export-video-without-watermark.html About Technical Aashique अगर आप हिन्दी मे कम्प्युटर पढ्न चाहते हैं तो आप मेरे वैबसाइट पे visit कर सकते हैं। http://www.aashiquetechsolutions.com/ मै हमेशा Job,software ,Oracle Forms,Oracle Reports ,SQL/PLSQL Queries,Application और Tips Related Ideas और Videos Upload करता हूँ। आप मेरे चैनल को VISIT करें और आपको अगर मेरी VIDEO पसंद आती है तो PLEASE SUBSCRIBE करना न भूले । Dosto AAP sabhi ka swagat h mere Youtube Channel “Technical Aashique” me, Mai daily Tips and Software ,Hardware,oracle database,oracle forms & Reports ,sql,plsql,online earning,work form home ,how to earning online,online job search and apply Related Videos Post Karta hu....Plzz Support.. Like , Comment visit my youtube channel: https://www.youtube.com/channel/UC-eKUzwr_0NgFKS8oyeQWOw follow on Instagram : https://www.instagram.com/aashiquetechsolutions/ आपका दोस्त : आशिक राज़ (Aashique Raaz)
Views: 34 Technical Aashique
Exporting and Importing Data in Oracle Planning and Budgeting Cloud
 
06:25
This tutorial demonstrates how to export and import data in Oracle Planning and Budgeting Cloud.
Views: 4819 Oracle EPM Tutorials
JasperReports Server - Master Scheduler and Tenant Replication Features
 
06:06
Scheduler Master View - centralized scheduler allowing administrators to see, edit or delete all scheduled jobs according to their permissions. Organization Export and Import - To simplify administration of JasperReports Server, organization administrators can export and import entire organizations or sub-organizations, making it possible to quickly move or duplicate organization structures and the reports and dashboards they contain, including their dependencies. The new operations are available through the Manage menu and through new options for the import-export scripts. See doc for more detail: http://community.jaspersoft.com/documentation/tibco-jasperreports-server-administration-guide/v62/import-and-export
SQL and PlSQL INTERVIEW 5-HOW TO GET BACK DELETED ROWS AFTER COMMIT
 
03:39
In this video we can Get Deleted rows After Commit.If you have any Queries let me Know...Comment me in Comment Box. MY WHATSUP Number is 8508598428..
Views: 652 Manikandan R
Ayat Al Kursi... 100 times (wish, job, health, protection etc etc)
 
01:30:04
Lots of benefit from Ayat Al Kursi.... Read or listen this 100 times daily.... protection from evil eye, shayateens, health benefits, fulfills wishes and many more.... Dont forget to Like & Subscribe for more videos https://www.youtube.com/watch?v=yPcMUxg_r5Q listen to this Insha ALLAH will motivate you guys alot
Views: 15112699 Ismail Mohamed
05- Export Import and Unlock.
 
11:13
TrainerBD.com Offers the most affordable (BDT. 15,000/-) Oracle Training in Mirpur, Dhaka, Bangladesh. Learn Oracle, Be an Oracle Developer and/or Database Administrator. Click http://www.trainerbd.com/training/product/oracle-training-in-bangladesh/ to learn Oracle. Oracle Tutorial Group (Facebook):- https://www.facebook.com/groups/Oracletutorialvideos https://www.facebook.com/groups/oracletutorialtechtunes Search Terms:- oracle video tutorial free download oracle applications tutorial oracle 11g tutorial free download oracle sql tutorial oracle 10g tutorial oracle form builder tutorial oracle forms 10g tutorial oracle 10g tutorial for beginners oracle database 10g tutorial sql oracle oracle for beginners oracle 10g tutorial oracle tutorials for beginners oracle dba tutorial for beginners pdf oracle forms developer tutorial toad for oracle tutorial oracle fusion middleware tutorial oracle forms 6i tutorial oracle sql tutorial oracle 11g tutorial oracle tutorial pdf free download oracle dba tutorial for beginners oracle application express tutorial oracle tutorial for beginners oracle database tutorial oracle apex tutorial oracle sql tutorial sql tutorial oracle 11g tutorial oracle 10g tutorial oracle dba tutorial oracle tutorial for beginners
Views: 512 Oracle Tutorialbd
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: 137824 TechLair
Tugas 1 - Create dan Delete DB Oracle dengan DBCA
 
13:56
Tugas Administrator Database Achmad Rizki Hidayatullah D4 LJPJJ 2016 2110167042
SQL REMOVE COLUMN FROM A TABLE
 
01:15
SQL REMOVE COLUMN FROM A TABLE A Job Portal http://www.InterviewDot.com http://www.InterviewDot.com http://www.InterviewDot.com One Click Dream Job - http://www.interviewdot.com/upload-resume/uploadresume.htm Are you looking for a new Job ? InterviewDot.com - A Job Portal http://www.InterviewDot.com http://www.InterviewDot.com http://www.InterviewDot.com One Click Dream Job - http://www.interviewdot.com/upload-resume/uploadresume.htm FRESHERS core JAVA INTERVIEW QUESTION AND ANSWER EXPERIENCED core JAVA INTERVIEW QUESTION AND ANSWER SPRING FRAMEWORK INTERVIEW QUESTION AND ANSWER HIBERNATE INTERVIEW QUESTION AND ANSWER DESIGN PATTERNS INTERVIEW QUESTION AND ANSWER JQUERY INTERVIEW QUESTION AND ANSWER AJAX INTERVIEW QUESTION AND ANSWER SQL INTERVIEW QUESTION AND ANSWER JUNIT INTERVIEW QUESTION AND ANSWER SOFTWARE ARCHITECTURE INTERVIEW QUESTION AND ANSWER CODE REFACTORING INTERVIEW QUESTION AND ANSWER PERFORMANCE TUNING INTERVIEW QUESTION AND ANSWER JAVA VIRTUAL MACHINE INTERVIEW QUESTION AND ANSWER SQL REMOVE COLUMN FROM A TABLE
Views: 43 Interview DOT
How to use EPM Automate in Oracle Planning and Budgeting Cloud
 
05:00
This tutorial demonstrates how to execute tasks with EPM Automate in Oracle Planning and Budgeting Cloud. You learn how to remotely execute predefined commands to load members from a file, run Data Management load rules to import data into Data Management and load that data into a Planning application, run business rules, export data, and perform application backups. To support your automated task routines, you see how to remotely execute commands to upload and download needed files to the Inbox/Outbox, and list and delete files.
Views: 5452 Oracle EPM Tutorials
Datastage tutorial - Dataset Management Utility - Learn at KnowStar
 
03:01
This is a training video on the use of Dataset Management Utility in Datastage. For corporate training enquiries, please send an email to [email protected]
Views: 260 Learn at Knowstar
Listing Control-M Active Jobs on the Command Line using ctmpsm.
 
03:24
Listing Control-M Active Jobs on the Command Line using ctmpsm.
How to export the encryption keys in Backup Exec 15
 
01:23
Author, teacher, and talk show host Robert McMillen shows you how to export the encryption keys in Backup Exec 15
Views: 3074 Robert McMillen
How to create dmp file in oracle by preetam
 
09:45
How to create dmp file in oracle and how to import & export dmp file
Views: 1749 preetam kumar
Backup databases using cron jobs
 
07:49
In this video, we're going to show you 2 methods on how to backup your MySQL databases automatically using cron jobs.
Views: 12178 A2 Hosting
Import CSV file to SQL Server Database
 
04:04
Learn how to import CSV file into MS SQL Server Database.
Views: 65537 Helpfolder