Home
Search results “Export all packages in oracle”
Setup | Exporting Setup Data to Configuration Packages
 
03:43
This tutorial applies to Rel 13. It shows you how to export setup data to a configuration package.
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: 63446 thehighway360
How to Debug Oracle Procedure | Package step by step with Toad For Oracle
 
09:05
In this Video I show you the simple and efficient way to Debugging your PL/SQL Procedure | Package with Toad For Oracle.
Views: 7980 Oracle PL/SQL World
65/125 Oracle PLSQL: Supplied  Packages / UTL_MAIL  1
 
13:49
learn oracle plsql EXAM 1Z0-144
Views: 1328 khaled alkhudari
Setup | Importing Setup Data from Configuration Packages
 
04:08
This tutorial applies to Rel 13. It shows you how to import setup data from a configuration package.
IO8: Sending mail from PL/SQL with UTL_MAIL
 
05:00
Learn how to use the UTL_MAIL package to send mail from within your PL/SQL program. Download my demo.zip from v.gd/sfdemo to access and run all referenced scripts. This video was taken from PLSQLChannel.com, originally recorded before Steven Feuerstein re-joined Oracle in March 2014. ======================================== Practically Perfect PL/SQL with Steven Feuerstein 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.
Export Oracle data to Excel file from Oracle Forms.
 
16:02
This is Oracle forms tutorial exporting data using for cursor loop to excel file invoking excel application with OLE2 forms built in package. OLE2 package contains all the stuff to invoke the property, procedures and function within an excel application. It creates the file, add workbook, add worksheet, put data to cells of worksheet and set properties like font size ,font color and font size of the cells. It saves the file as well. Source Code Link : https://drive.google.com/file/d/0BznrW3lgX0ozRktCMUlTaHZ0MzQ/view?usp=sharing
Views: 14503 Subhroneel Ganguly
Use Packages with Oracle Integration Cloud
 
01:52
Group integrations so that they can be conveniently imported into and exported from Oracle Integration Cloud. ================================= 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 © 2017 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.
How to edit a package in Oracle database
 
02:20
This tutorial show the process to edit a package in Oracle database using DreamCoder for Oracle.
Views: 6259 sqldeveloper
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: 9203 yrrhelp
Oracle Data Integrator 12c: Export and Import Options Detailed
 
36:38
Oracle Data Integrator 12c delivers unique next-generation, Extract Load and Transform (E-LT) technology that improves performance and reduces data integration costs – even across heterogeneous systems. Watch the webinar and learn the business benefits of ODI, including streamlining daily business operations and reducing time-to-market for new products and services. Our speaker, Jayjay Gutierrez also reviews the pros and cons of three different ways to complete exports and imports: - Individual Export/Import of Objects: Export each object individually into an xml file and import an object from an xml file - Smart Export: Export all of the dependencies for a selected object into an xml file; allows users to merge, overwrite, create copy, reuse or ignore items - ODI Package: Custom that allows users to loop through models, projects, interfaces, variables and almost any ODI objects and export them
Views: 3605 KeyPerformanceIdeas
HOW TO WRAP PLSQL CODE IN ORACLE DATABASE
 
05:55
HOW TO WRAP A PL/SQL CODE IN ORACLE DATABASE ============================================ wrap iname=testproc.sql oname=testproc.plb HOW TO CREATE A PROCEDURE ========================== create or replace procedure test as begin dbms_output.put_line('Welcome to ORACLE DBA'); end; / HOW TO CHECK THE CONTENT OF PROCEDURE ======================================== select owner,object_name from dba_objects where object_name like '&object_name'; select text from dba_source where name='&name'; HOW TO EXECUTE A PROCEDURE ========================== set serveroutput on; exec test HOW TO READ A FILE FROM COMMAND PROMPT ====================================== type testproc.sql type testproc.plb PL/SQL files extension ======================= .pls - PL/SQL source .plb - PL/SQL binary .pks - Package source or package specification .pkb - Package binary or package body .pck - Combined package specification plus body
Views: 1726 Praveen Biyyapu
How to export all the tables to Flat files dynamically from SQL Server Database in SSIS Package-P178
 
20:53
SSIS Tutorial Scenario: How to export all the tables to Flat files dynamically from SQL Server Database in SSIS Package You are working as SQL Server Integration Services(SSIS) developer. You need to create an SSIS Package that should create flat files for all the tables from a database dynamically. There should be one file for each table and it should be created with date-time. Link to script used in the video http://www.techbrothersit.com/2016/04/how-to-export-all-tables-to-flat-files.html check out http://www.techbrothersit.com/ for free Technology Tutorials /Interview Questions SQL Server Integration Services(SSIS) Tutorial SQL Server Reporting Services (SSRS) Tutorial SQL Server / TSQL Tutorial SQL Server DBA Tutorial Team Foundation Server Microsoft Dynamics AX
Views: 3652 TechBrothersIT
Setup | Exporting Setup Data Using CSV
 
02:44
This tutorial applies to Rel 13. It shows you how to export setup data using CSV.
Adding a User to Oracle - Full Schema Access, But Read only
 
17:04
Hi friends this video will help you in live environment when you need read only access of other schema object procedure ,function packages etc.Oracle database Unbeatable,Unbreakable Platform..
Views: 1391 Oracle World
Oracle Database Tutorial 57: IMPDP (REMAP_SCHEMA) how to import table in different user/schema
 
04:09
In this oracle database tutorial you will learn How to import table in different schema using Remap_Schema parameter of impdp data pump import utility By Manish Sharma RebellionRider ------------------------------------------------------------------------ ►►►LINKS◄◄◄ Blog: http://bit.ly/how-to-import-tables-in-different-schema-remap-schema Previous Tutorial Tut 56 How to import table in same schema : http://youtu.be/oEnmEUlicY0 ------------------------------------------------------------------------- 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 1st 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: 23392 Manish Sharma
Exporting Metadata in Oracle Planning and Budgeting Cloud
 
03:20
This tutorial demonstrates how to export metadata from Oracle Planning and Budgeting Cloud. Administrators can use the exported metadata to migrate an application, manipulate metadata structure, or as a backup.
Export With Toad for oracle
 
07:17
Views: 21911 Goldroger
Create Excel File Dynamically for Stored Procedure Results in SSIS Package by using Script Task-P165
 
17:09
SSIS Tutorial Scenario How to create Excel File Dynamically for Stored Procedure Results in SSIS Package by using Script Task You are working as ETL Developer / SSIS Developer and you need to create an SSIS Package that should execute Stored Procedure from SQL Server database and create an excel file for data returned by Stored Procedure. Let's assume that in in scenario, the Stored Procedure does not accept any parameters. Often Stored Procedures are created to run bunch of queries to generate final results and load that to Excel file. Your Stored Procedure might be using pivot and it can return different columns on each execution. Our SSIS Package should be able to handle this situation. It should always create an Excel file whatever columns are returned by Stored Procedure. The excel file should be generate with Datetime on each execution. Link to Script used in the video http://www.techbrothersit.com/2016/03/how-to-create-excel-file-dynamically_21.html Checkout other videos from TechBrothersIT for Dynamic Excel Source and Destination in SSIS Video playlist How to Load Data from Excel Files when Number of Columns can decrease or order is changed in Excel Sheet How to Load Only Matching Column Data to SQL Server Table from Multiple Excel Files (Single Sheet per file) Dynamically in SSIS Package How to Load Excel File Names with Sheet Names ,Row Count,Last Modified Date, File Size in SQL Server Table How to Load Multiple Excel Files with Multiple Sheets to Single SQL Server Table by using SSIS Package How to Load Matching Sheets from Excel to Table and Log Not Matching Sheets Information in SQL Server Table How to create Table for each sheet in Excel Files and load data to it dynamically in SSIS Package How to Create Table per Excel File and Load all Sheets Data Dynamically in SSIS Package by using Script Task How to create CSV file per Excel File and Load All Sheets from Excel File to it in SSIS Package How to Create CSV File for Each Excel Sheet from Excel Files in SSIS Package How to Load Excel File Name and Sheet Name with Data to SQL Server in SSIS Package How to Import data from Multiple Excel Sheets with a pattern of sheet names from Multiple Excel File in SSIS Package How to import Data from Excel Files for specific Sheet Name to SQL Server Table in SSIS Package Load Data To Tables according to Excel Sheet Names from Excel Files dynamically in SSIS Package How to Load Excel Files with Single/ Multiple Sheets to SQL Server Tables according to Excel File Name Dynamically How to Read Excel Sheet Data after Skipping Rows in SSIS Package by using Script Task How to read data from Excel Sheet and Load to Multiple Tables by using Script Task in SSIS Package How to create Excel File Dynamically from SQL server Table/View by using Script Task in SSIS Package How to create Excel File Dynamically for Stored Procedure Results in SSIS Package by using Script Task How to Export SQL Server Tables from Database to Excel File Dynamically in SSIS Package by using Script Task How to Convert CSV/Text Files to Excel Files in SSIS Package by using Script Task How to Load All CSV Files to Excel Sheets ( Sheet Per CSV) in single Excel File in SSIS Package How to Load All CSV Files to Single Excel Sheet with File Names in an Excel File Dynamically in SSIS Package How to Create Sample Excel file with Sheet from each table with Top 1000 Rows per sheet in SSIS Package How to Export Data to Multiple Excel Sheets from Single SQL Server Table in SSIS Package
Views: 5209 TechBrothersIT
Install Oracle 11gr2 in Linux 7 x Step by step by Le Anh
 
42:51
Install Oracle 11g in Linux 7.x Step by step by Le Anh Step 1: download oracle 11g in oracle website http://www.oracle.com/technetwork/database/enterprise-edition/downloads/112010-linx8664soft-100572.html p10404530_112030_Linux-x86-64_1of7.zip p10404530_112030_Linux-x86-64_2of7.zip Step 2: configuring hostname hostnamectl set-hostname cdrraw Step 3: add in hosts file #vi /etc/hosts add the following lines 192.168.40.197 cdrraw cdrraw is hostname and 192.168.40.197 is ip address Verify your network settings #ping -c 1 cdrraw Step 4: disable secure linux by editing the "/etc/selinux/config" file #vi /etc/selinux/config SELINUX=permissive Note: Reboot Step 5: create group and user install oracle #/usr/sbin/groupadd -g 501 oinstall #/usr/sbin/groupadd -g 502 dba #/usr/sbin/groupadd -g 503 oper #/usr/sbin/useradd -u 502 -g oinstall -G dba,oper oracle #passwd oracle Step 6: create folder install oracle #mkdir -p /u01/app/oracle/product/11.2.0/db_1 #mkdir -p /u01/setup #chown -R oracle:oinstall /u01 #chmod -R 775 /u01 Step 7: Set parameter #vi /etc/sysctl.conf add the following lines kernel.shmmni = 4096 kernel.shmmax = 4398046511104 kernel.shmall = 1073741824 kernel.sem = 250 32000 100 128 fs.aio-max-nr = 1048576 fs.file-max = 6815744 net.ipv4.ip_local_port_range = 9000 65500 net.core.rmem_default = 262144 net.core.rmem_max = 4194304 net.core.wmem_default = 262144 net.core.wmem_max = 1048586 #/sbin/sysctl -p #vi /etc/security/limits.conf add the following lines oracle soft nofile 1024 oracle hard nofile 65536 oracle soft nproc 16384 oracle hard nproc 16384 oracle soft stack 10240 oracle hard stack 32768 #vi /etc/pam.d/login session required pam_limits.so Step 8: Install the following packages if they are not already present. Check which packages are installed and which are missing rpm -q --qf '%{NAME}-%{VERSION}-%{RELEASE}(%{ARCH})\n' binutils \ elfutils-libelf \ elfutils-libelf-devel \ gcc \ gcc-c++ \ glibc \ glibc-common \ glibc-devel \ glibc-headers \ ksh \ libaio \ libaio-devel \ libgcc \ libstdc++ \ libstdc++-devel \ make \ sysstat \ unixODBC \ unixODBC-devel 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 now, i installed all packages Step 9: Set environmental variable for user ORACLE #su - oracle $ cd ~ $ vi .bash_profile add the following lines # Oracle Settings TMP=/tmp; export TMP TMPDIR=$TMP; export TMPDIR export ORACLE_HOSTNAME=cdrraw export ORACLE_UNQNAME=cdrraw ORACLE_BASE=/u01/app/oracle; export ORACLE_BASE ORACLE_HOME=$ORACLE_BASE/product/11.2.0/db_1; export ORACLE_HOME ORACLE_SID=cdrraw; export ORACLE_SID PATH=/usr/sbin:$PATH; export PATH PATH=$ORACLE_HOME/bin:$PATH; export PATH LD_LIBRARY_PATH=$ORACLE_HOME/lib:/lib:/usr/lib; export LD_LIBRARY_PATH CLASSPATH=$ORACLE_HOME/JRE:$ORACLE_HOME/jlib:$ORACLE_HOME/rdbms/jlib; export CLASSPATH if [ $USER = "oracle" ]; then if [ $SHELL = "/bin/ksh" ]; then ulimit -p 16384 ulimit -n 65536 else ulimit -u 16384 -n 65536 fi fi Step 10: Upload files to server using user Oracle /u01/setup/ Step 11: Unzip files $unzip p10404530_112030_Linux-x86-64_1of7.zip $unzip p10404530_112030_Linux-x86-64_2of7.zip Step 12: Install oracle DB $xhost + $cd /u01/setup/database $./runInstaller To fix this error edit $ORACLE_HOME/sysman/lib/ins_emagent.mk, search for the line $(MK_EMAGENT_NMECTL) and replace the line with $(MK_EMAGENT_NMECTL) -lnnz11 then click “Retry” button Execute Configurtation Scripts /u01/app/oraInventory/orainstRoot.sh /u01/app/oracle/product/11.2.0/db_1/root.sh Create listener and file tnsname $netca $vi /u01/app/oracle/product/11.2.0/db_1/network/admin/tnsnames.ora CDRRAW = (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = cdrraw)(PORT = 1521)) (CONNECT_DATA = (SERVER = SHARED) // DEDICATED (SERVICE_NAME = cdrraw) ) ) now, install ORACLE DATABSE using DBCA $dbca Thanks
Views: 3866 Anh Lê Ngọc
Install Oracle 12c in Linux 7.x Step by Step
 
30:40
Step 1: download oracle 12c in oracle website http://www.oracle.com/technetwork/database/enterprise-edition/downloads/database12c-linux-download-2240591.html Step 2: create group and user install oracle #groupadd oinstall #groupadd dba #groupadd oper #useradd -G dba,oper -g oinstall oracle #passwd oracle Step 3: create folder install oracle #mkdir -p /u01/app/oracle/product/12.1/db_1 #mkdir -p /u01/setup #chown -R oracle:oinstall /u01 #chmod -R 775 /u01 Step 4: Set parameter #vi /etc/sysctl.conf add the following lines 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 #/sbin/sysctl -p #vi /etc/security/limits.conf add the following lines oracle soft nofile 1024 oracle hard nofile 65536 oracle soft nproc 16384 oracle hard nproc 16384 oracle soft stack 10240 oracle hard stack 32768 Step 5: Install the following packages if they are not already present. 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 now, i installed all packages Step 6: add in hosts file #vi /etc/hosts add the following lines 192.168.10.100 oracle.test.com oracle.test oracle.test is hostname and 192.168.10.100 is ip address Step 7: Set environmental variable for user ORACLE #su - oracle $ cd ~ $ vi .bash_profile add the following lines # Oracle Settings export TMP=/tmp export TMPDIR=$TMP export ORACLE_HOSTNAME=oracle.test export ORACLE_UNQNAME=dbtest export ORACLE_BASE=/u01/app/oracle export ORACLE_HOME=$ORACLE_BASE/product/12.1/db_1 export ORACLE_SID=dbtest 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 8: Upload files to server using user Oracle Step 9: Unzip files $unzip linuxamd64_12c_database_1of2.zip.zip $unzip linuxamd64_12c_database_2of2.zip.zip Step 10: Install oracle DB $xhost + $cd /u01/setup/database $./runInstaller now, install ORACLE DATABSE using DBCA $dbca
Views: 52470 Mr_Chicken
How to create Text or CSV File Dynamically from a Stored Procedure in SSIS Package-P180
 
30:34
SSIS Tutorial Scenario: How to create Text or CSV File Dynamically from a Stored Procedure in SSIS Package You are working as SQL Server Integration Services developer. You need to create an SSIS Package that should execute Stored Procedure and write the results to flat file. Every time the SSIS Package will run, it should create new flat file with date-time. This is simple requirement. You might think to use OLE DB Source and then use Flat file destination. But there is small problem. The definition of Stored Procedure can change anytime, that means the number of columns returned by Stored Procedure can change. You need to develop an SSIS Package in such a way that you don't have to reopen and remap the columns every-time the definition of Stored Procedure change. link to script used in the video http://www.techbrothersit.com/2016/04/how-to-create-text-or-csv-file_7.html Check out http://www.techbrothersit.com/ for free Technology Tutorials /Interview Questions SQL Server Integration Services(SSIS) Tutorial SQL Server Reporting Services (SSRS) Tutorial SQL Server / TSQL Tutorial SQL Server DBA Tutorial Team Foundation Server Microsoft Dynamics AX
Views: 7587 TechBrothersIT
Exporting Data From A Table in SQL Developer
 
02:51
This tutorial shows how to export the data from a table using SQL Developer tool.
Views: 32220 WingsOfTechnology
Oracle pl sql tutorial - %TYPE and %ROWTYPE attributes #26
 
05:16
Lesson 26 END tutorial Subscrise for my thx !! all
Views: 6626 Dol1nitary
How to Transferring Tables from One sql Database to Another
 
05:25
Learn how to transfer tables from one SQL database to another with just a click of a button. With the help of SQL server data tools: business intelligence in visual studio, you'll be able to transfer tables, views, functions and much more with a click of a button. You can save the project and just change the source database and tables to transfer new tables. Thanks for watching. Subscribe for more video tutorials. You should install "SQL Server Data Tools in Visual Studio 2015" [https://msdn.microsoft.com/en-us/mt186501] it's a complete set.
Views: 22246 Bhupinder Programming
Oracle Database 12c on Oracle Linux 7.4 installation port 2
 
21:15
Step-01: Unzip the files. Step-02: Edit Hosts File Edit /etc/hosts 127.0.0.1 localhost localhost.localdomain localhost4 localhost4.localdomain4 10.179.100.230 Oracle_12C.localdomain Oracle_12C change name /etc/hostname Oracle_12C.localdomain Step-03: upddate yum update -y Step-04: Manual Setup Edit /etc/sysctl.conf fs.file-max = 6815744 kernel.sem = 250 32000 100 128 kernel.shmmni = 4096 kernel.shmall = 1073741824 kernel.shmmax = 4398046511104 kernel.panic_on_oops = 1 net.core.rmem_default = 262144 net.core.rmem_max = 4194304 net.core.wmem_default = 262144 net.core.wmem_max = 1048576 net.ipv4.conf.all.rp_filter = 2 net.ipv4.conf.default.rp_filter = 2 fs.aio-max-nr = 1048576 net.ipv4.ip_local_port_range = 9000 65500 Edit etc/security/limits.d/oracle-rdbms-server-12cR1-preinstall.conf oracle soft nofile 1024 oracle hard nofile 65536 oracle soft nproc 16384 oracle hard nproc 16384 oracle soft stack 10240 oracle hard stack 32768 oracle hard memlock 134217728 oracle soft memlock 134217728 Step-06: The following packages are listed as required yum install binutils -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 yum install zlib-devel -y yum install zlib-devel.i686 -y Step-07: Create the new groups and users groupadd -g 54321 oinstall groupadd -g 54322 dba groupadd -g 54323 oper #groupadd -g 54324 backupdba #groupadd -g 54325 dgdba #groupadd -g 54326 kmdba #groupadd -g 54327 asmdba #groupadd -g 54328 asmoper #groupadd -g 54329 asmadmin useradd -u 54321 -g oinstall -G dba,oper oracle Step-11: Create the directories in which the Oracle software will be installed mkdir -p /u01/app/oracle/product/12.1.0.2/db_1 chown -R oracle:oinstall /u01 chmod -R 775 /u01 Step-12: Unless you are working from the console # Oracle Settings export TMP=/tmp export TMPDIR=$TMP export ORACLE_HOSTNAME=Oracle_12C.localdomain export ORACLE_UNQNAME=cdb1 export ORACLE_BASE=/u01/app/oracle export ORACLE_HOME=$ORACLE_BASE/product/12.1.0.2/db_1 export ORACLE_SID=cdb1 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-14: Installation
Views: 238 Need Only Network
Import Metadata in to Oracle Data Integrator
 
04:26
Import Metadata(Tables and columns definition) in to Oracle Data Integrator
Python Tutorial: CSV Module - How to Read, Parse, and Write CSV Files
 
16:12
In this Python Programming Tutorial, we will be learning how to work with csv files using the csv module. We will learn how to read, parse, and write to csv files. CSV stands for "Comma-Separated Values". It is a common format for storing information. Knowing how to read, parse, and write this information to files will open the door to working with a lot of data throughout the world. Let's get started. The code from this video can be found at: https://github.com/CoreyMSchafer/code_snippets/tree/master/Python-CSV 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/ #Python
Views: 169146 Corey Schafer
Send Email From Oracle Forms Builder
 
53:09
This tutorial demonstrates how to send Email messages directly from PL/SQL or Oracle Forms Builder 11g with UTL_SMTP package. This Tutorial includes: 1 - Signing Up for a New SMTP2GO Account 2 - Creating A New Table and Adding Some Email Addresses 3 - Creating a New Form 4 - Building a Control Block 5 - Adding Non Base Table Items to a Control Block 6 - Creating a LOV for displaying and selecting recipient(s) from the table’s email column 7 - Adding Functionality with PL/SQL Code 8 - Creating an Access Control List (ACL) 9 - Assigning an ACL to a Network 10 - Sending Email Related Files: https://www.facebook.com/groups/oracle.tutorials/permalink/338301526564384/ Please subscribe to my channel. Keywords: how to send email attachments from pl/sql procedure how to send email from pl sql code how to send email from pl sql procedure how to send email from pl sql procedure in oracle ora-20000 unable to send email message from pl/sql send an email from pl sql in html format send email from forms builder 10g send email from forms builder 11g send email from forms builder 12c send email from forms builder 6i send email from forms builder free send email from forms builder oracle send email from forms builder software send email from forms builder tutorial send email from pl sql send email from pl sql 11g send email from pl sql 64 send email from pl sql code send email from pl sql developer send email from pl sql procedure send email from pl sql query send email from pl sql with attachment send email from pl/sql to multiple recipients send email from sql send email in pl/sql send email pl sql oracle send email pl sql oracle 11g send email using pl sql oracle send email via pl sql procedure send email with attachments from pl/sql using java stored procedures send html email from oracle pl sql send html email from pl sql
Views: 7192 Muhammad Abid
C# Tutorial 89: How to Publish an Application in C# and Make the Installation Setup
 
10:55
How to Create Installation Setup for Your C# Application Project Howto make setup file from project in VS2012 C# How to Create an Installer For a WinForm Application How to make an installer for my C# application? How can I deploy a C# application Deploying a C# application Visual Studio Create Setup project How to make setup file using VS 2010 in C# window forms How do I create setup in c# Create a simple installer from Visual Studio How make Setup installation file of my Completed C# project Make an Installation program for C# applications C# publish application properties
Views: 166022 ProgrammingKnowledge
Copying data from Oracle to Microsoft SQL Server (Part 1)
 
12:10
This video tutorial is designed to show you how to copy data from an Oracle database to Microsoft SQL Server 2008r2 using Microsoft SQL Server Business Intelligence studio
Views: 15312 De Jeneral
The Psychology Behind Hard-Coding in PL/SQL
 
03:39
The Psychology Behind Hard-Coding Since we write software using our brains, it is hard to avoid the impact of psychology and physiology of our brains on our code. This manifests quite clearly when it comes to hard-coding. See the Practically Perfect PL/SQL YouTube channel for related videos. https://www.youtube.com/channel/UCpJpLMRm452kVcie3RpINPw ================================================== 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.
R tutorial: connecting to a database
 
03:38
Learn more about connecting to databases with R: https://www.datacamp.com/courses/importing-data-in-r-part-2 Welcome to part two of importing data in R! The previous course dealt with accessing data stored in flat files or excel files. In a professional setting, you'll also encounter data stored in relational databases. In this video, I'll briefly talk about what a relational database is and then I'll explain how you can connect to it. In the next video, I'll explain how you can import data from it! So, what's a relational database? There's no better way to show this than with an example. Take this database, called company. It contains three tables, employees, products and sales. Like a flat file, information is displayed in a table format. The employees table has 5 records and three fields, namely id, name and started_at. The id here serves as a unique key for each row or record. Next, the products table contains the details on four products. We're dealing with data from a telecom company that's selling both with and without a contract. Also here, each product has an identifier. Finally, there's the sales table. It lists what products were sold by who, when and for what price. Notice here that the ids in employee_id and product_id correspond to the ids that you can find in the employees and products table respectively. The third sale for example, was done by the employee with id 6, so Julie. She sold the product with id 9, so the Biz Unlimited contract. These relations make this database very powerful. You only store all necessary information once in nicely separated tables, but can connect the dots between different records to model what's happening. How the data in a relational database is stored and shuffled around when you make adaptations, depends on the so-called database management system, or DBMS you're using. Open-source implementations such as MySQL, postgreSQL and SQLite are very popular, but there are also proprietary implementations such as Oracle Database and Microsoft SQL server. Practically all of these implementations use SQL, or sequel, as the language for querying and maintaining the database. SQL stands for Structured Query Language. Depending on the type of database you want to connect to, you'll have to use different packages. Suppose the company database I introduced before is a MySQL database. This means you'll need the RMySQL package. For postgreSQL you'll need RpostgreSQL, for Oracle, you'll use ROracle and so on. How you interact with the database, so which R functions you use to access and manipulate the database, is specified in another R package called DBI. In more technical terms, DBI is an interface, and RMySQL is the implementation. Let's install the RMySQL package, which automatically installs the DBI package as well. Loading only the DBI package will be enough to get started. The first step is creating a connection to the remote MySQL database. You do this with dbConnect(), as follows. The first argument specifies the driver that you will use to connect to the MySQL database. It sure looks a bit strange, but the MySQL() function from the RMySQL package simply constructs a driver for us that dbConnect can use. Next, you have to specify the database name, where the database is hosted, through which port you want to connect, and finally the credentials to authenticate yourself. This is an actual database that we're hosting, so you can try these commands yourself! The result of the dbConnect call, con, is a DBI connection object. You'll need to pass this object to whatever function you're using to interact with the database. Before we do that, let's get familiar with this connection object in the exercises!
Views: 34873 DataCamp
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: 127614 TechLair
Toad for Oracle Schema browser how you will get the detail of database object ,log on schema
 
06:35
Toad for Oracle Schema browser how you will get the detail of database object ,log on schema,others schema,user
Views: 6597 Abinash Sahoo
How to Create Flat File from SQL server Table by using Import Export Wizard - SSIS Tutorial
 
09:38
In this video you will learn how to generate flat file from sql server table by using Import Export Wizard. Import export wizard in SQL Server can be used to import the data to SQL Server table or export the data from SQL Server tables to different destinations such as flat file, excel or database such as oracle, db2 etc. In this video you will also learn How to Start Import Export Wizard from SQL Server Management Studio How to configure Source in Import Export Wizard in SQL Server How to configure destination in Import Export Wizard in SQL Server How to create comma delimited file from sql server table by using import export Wizard how to create SSIS Package by using Import Export Wizard in SQL server To Follow Step by Step this SSIS video tutorial By Tech Brothers http://sqlage.blogspot.com/search/label/SSIS%20Video%20Tutorial
Views: 9585 TechBrothersIT
Oracle DV Workshop - Basics of Training & Applying Predictive Models With Oracle DV
 
21:58
The workshop can be run by anyone using Oracle DV (OAC or Desktop) on a regular laptop, with DVML option installed. Oracle DV Desktop can be downloaded from : bit.ly/OracleDVDownload Datasets used in this workshop is available from https://www.oracle.com/solutions/business-analytics/data-visualization/library.html?search=donat Only some features of Oracle Datavisualization are covered in this workshop, it does not adress all the analysis capabilities of Oracle Datavisualization.
Views: 1244 Oracle Analytics
Export data from SQL to CSV File - SSIS
 
04:07
Register for our FREE Live webinars - https://dataplatformlabs.com/free-events In this video (Export data from SQL to CSV File - SSIS) we are going to learn how to Write\Export data from SQL Server database table to CSV File using SSIS. In this video we have used Data Flow Task to Export data. We have used the OLE DB Source that is used to read data from a SQL Server database table and we have used Flat File destination to write data to a CSV file. This is our another tutorial video on SSIS topic. You will be going to see a lot more videos from our end on the SSIS in coming days. Keep tuning. Happy Learning. If you have any questions or suggestions do write to me on "[email protected]"
Views: 7945 Learn SSIS
032-Oracle SQL Arabic Course  - Sequence اوراكل ديفلوبر
 
04:42
Oracle SEQUENCES - Beginner .......................................­.................... تواصل معانا علي الفيس بوك من هنا : https://www.facebook.com/askgad .......................................­.................... تواصل معانا علي موقعنا من هنا : https://www.askgad.com/
Views: 1179 Ask Gad
Dynamically retrieve Oracle Schemas and Tables using AngularJS
 
14:17
In this Oracle AngularJS tutorial I have tried to perform some basic DBA tasks, like populating all schemas within database and all tables within a selected schemas and display data of tables dynamically with dynamic column name display. I am also providing you the code for the angularjs and oracle data retrieving jsp file, download it from googledrive. https://drive.google.com/file/d/0BznrW3lgX0ozcElkeTVzREdFeUU/view?usp=sharing
Views: 623 Subhroneel Ganguly
How to Export SQL Server Data to Excel
 
08:14
This video demonstrates how to use the SQL Server Import and Export Wizard to create a package that exports data from a SQL Server database to a Microsoft Excel spreadsheet.
Views: 176533 DBATAG
SQLPLUS: LineSize & PageSize
 
03:49
In this tutorial, you'll learn how to set linesize and pagesize . PL/SQL (Procedural Language/Structured Query Language) is Oracle Corporation's procedural extension for SQL and the Oracle relational database. PL/SQL is available in Oracle Database (since version 7), TimesTen in-memory database (since version 11.2.1), and IBM DB2 (since version 9.7).[1] Oracle Corporation usually extends PL/SQL functionality with each successive release of the Oracle Database. PL/SQL includes procedural language elements such as conditions and loops. It allows declaration of constants and variables, procedures and functions, types and variables of those types, and triggers. It can handle exceptions (runtime errors). Arrays are supported involving the use of PL/SQL collections. Implementations from version 8 of Oracle Database onwards have included features associated with object-orientation. One can create PL/SQL units such as procedures, functions, packages, types, and triggers, which are stored in the database for reuse by applications that use any of the Oracle Database programmatic interfaces. PL/SQL works analogously to the embedded procedural languages associated with other relational databases. For example, Sybase ASE and Microsoft SQL Server have Transact-SQL, PostgreSQL has PL/pgSQL (which emulates PL/SQL to an extent), and IBM DB2 includes SQL Procedural Language,[2] which conforms to the ISO SQL’s SQL/PSM standard. The designers of PL/SQL modeled its syntax on that of Ada. Both Ada and PL/SQL have Pascal as a common ancestor, and so PL/SQL also resembles Pascal in several aspects. However, the structure of a PL/SQL package does not resemble the basic Object Pascal program structure as implemented by a Borland Delphi or Free Pascal unit. Programmers can define public and private global data-types, constants and static variables in a PL/SQL package.[3] PL/SQL also allows for the definition of classes and instantiating these as objects in PL/SQL code. This resembles usage in object-oriented programming languages like Object Pascal, C++ and Java. PL/SQL refers to a class as an "Abstract Data Type" (ADT) or "User Defined Type" (UDT), and defines it as an Oracle SQL data-type as opposed to a PL/SQL user-defined type, allowing its use in both the Oracle SQL Engine and the Oracle PL/SQL engine. The constructor and methods of an Abstract Data Type are written in PL/SQL. The resulting Abstract Data Type can operate as an object class in PL/SQL. Such objects can also persist as column values in Oracle database tables. PL/SQL is fundamentally distinct from Transact-SQL, despite superficial similarities. Porting code from one to the other usually involves non-trivial work, not only due to the differences in the feature sets of the two languages,[4] but also due to the very significant differences in the way Oracle and SQL Server deal with concurrency and locking. There are software tools available that claim to facilitate porting including Oracle Translation Scratch Editor,[5] CEITON MSSQL/Oracle Compiler [6] and SwisSQL.[7] The StepSqlite product is a PL/SQL compiler for the popular small database SQLite. PL/SQL Program Unit A PL/SQL program unit is one of the following: PL/SQL anonymous block, procedure, function, package specification, package body, trigger, type specification, type body, library. Program units are the PL/SQL source code that is compiled, developed and ultimately executed on the database. The basic unit of a PL/SQL source program is the block, which groups together related declarations and statements. A PL/SQL block is defined by the keywords DECLARE, BEGIN, EXCEPTION, and END. These keywords divide the block into a declarative part, an executable part, and an exception-handling part. The declaration section is optional and may be used to define and initialize constants and variables. If a variable is not initialized then it defaults to NULL value. The optional exception-handling part is used to handle run time errors. Only the executable part is required. A block can have a label. Package Packages are groups of conceptually linked functions, procedures, variables, PL/SQL table and record TYPE statements, constants, cursors etc. The use of packages promotes re-use of code. Packages are composed of the package specification and an optional package body. The specification is the interface to the application; it declares the types, variables, constants, exceptions, cursors, and subprograms available. The body fully defines cursors and subprograms, and so implements the specification. Two advantages of packages are: Modular approach, encapsulation/hiding of business logic, security, performance improvement, re-usability. They support object-oriented programming features like function overloading and encapsulation. Using package variables one can declare session level (scoped) variables, since variables declared in the package specification have a session scope.
Views: 15367 radhikaravikumar
Extending Oracle Database DevOps with Automated PL/SQL Unit Testing
 
10:12
Integrating utPLSQL for test automation of PL/SQL and SQL into Oracle Developer Cloud Service for complete DevOps - blog with more info - https://blogs.oracle.com/shay/extending-oracle-database-devops-with-automated-plsql-unit-testing
Views: 4038 ShayJDev
pl sql developer - connect to oracle 12c database using pl sql developer with tnsnames.ora
 
06:22
pl sql developer - connect to oracle 12c database using pl sql developer with tnsnames.ora Connect to oracle database - how to connect to oracle database using sqlplus in windows: https://youtu.be/8GK4RQuCx_8 In this tutorial "pl sql developer - connect to oracle database using pl sql developer with tnsnames.ora" will show you how to configure tnsname.ora in pl sql developer for oracle database connection, create table in pl sql developer, insert data in pl sql developer, and select result in pl sql developer. You can find me: Facebook: https://www.facebook.com/HingTipi Instagram: https://www.instagram.com/pi_sapphire/?hl=en Linkedin: https://www.linkedin.com/in/tipi-hing-93080261/ Google plus: https://plus.google.com/u/0/115396916707479934437 Twitter: https://twitter.com/TiPiHing photo credit: CREDIT PHOTO https://www.flickr.com/photos/[email protected]/10614978976/in/photolist-hb1xqU-4A4jrh-fPduyd-rcmbAc-fPcRfU-r8Jbhv-5gAYFx-bqrToM-dRFrZg-fNVyov-62Yv2h-nQug-9h8PzA-5aZeqx-9h5FM4-7H6iUU-9h8PrQ-9h5FAc-b78rj-9h5Fv8-fJt9Ex-kqoVuF-jcK5w5-hEoyms-9h5FJ8-Ro3Xc9-9h5FGK-8b8puq-9h5FBR-dfUthv-agLG6c-9h5Fz8-pSbCPg-5A8zDb-jC4vYX-RT31DE-9h8Pqm-4VMqsw-SCqtuw-4VMpCo-bofeWo-fPrqnP-aznTRJ-8vh3ny-7heoWE-jC5rn8-bTzxkx-gYu6fR-9GywxF-fNUJjF Subscribe. Like. Share. Comment. Thanks, pl sql developer connect to oracle 12c database using pl sql developer
Views: 17196 Junior Geek
Oracle Database 12c on Oracle Linux 7.4 installation port 1
 
29:41
Step-01: Unzip the files. Step-02: Edit Hosts File Edit /etc/hosts 127.0.0.1 localhost localhost.localdomain localhost4 localhost4.localdomain4 10.179.100.230 Oracle_12C.localdomain Oracle_12C change name /etc/hostname Oracle_12C.localdomain Step-03: upddate yum update -y Step-04: Manual Setup Edit /etc/sysctl.conf fs.file-max = 6815744 kernel.sem = 250 32000 100 128 kernel.shmmni = 4096 kernel.shmall = 1073741824 kernel.shmmax = 4398046511104 kernel.panic_on_oops = 1 net.core.rmem_default = 262144 net.core.rmem_max = 4194304 net.core.wmem_default = 262144 net.core.wmem_max = 1048576 net.ipv4.conf.all.rp_filter = 2 net.ipv4.conf.default.rp_filter = 2 fs.aio-max-nr = 1048576 net.ipv4.ip_local_port_range = 9000 65500 Edit etc/security/limits.d/oracle-rdbms-server-12cR1-preinstall.conf oracle soft nofile 1024 oracle hard nofile 65536 oracle soft nproc 16384 oracle hard nproc 16384 oracle soft stack 10240 oracle hard stack 32768 oracle hard memlock 134217728 oracle soft memlock 134217728 Step-06: The following packages are listed as required yum install binutils -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 yum install zlib-devel -y yum install zlib-devel.i686 -y Step-07: Create the new groups and users groupadd -g 54321 oinstall groupadd -g 54322 dba groupadd -g 54323 oper #groupadd -g 54324 backupdba #groupadd -g 54325 dgdba #groupadd -g 54326 kmdba #groupadd -g 54327 asmdba #groupadd -g 54328 asmoper #groupadd -g 54329 asmadmin useradd -u 54321 -g oinstall -G dba,oper oracle Step-11: Create the directories in which the Oracle software will be installed mkdir -p /u01/app/oracle/product/12.1.0.2/db_1 chown -R oracle:oinstall /u01 chmod -R 775 /u01 Step-12: Unless you are working from the console # Oracle Settings export TMP=/tmp export TMPDIR=$TMP export ORACLE_HOSTNAME=Oracle_12C.localdomain export ORACLE_UNQNAME=cdb1 export ORACLE_BASE=/u01/app/oracle export ORACLE_HOME=$ORACLE_BASE/product/12.1.0.2/db_1 export ORACLE_SID=cdb1 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-14: Installation
Views: 460 Need Only Network
Introduction to Firebird 3.0 packages
 
04:00
Firebird 3.0 packages are a new database object type, which allows the logical grouping of stored procedures and functions, similar to Oracle. Firebird 3.0 packages offer you possibilities to make your business logic more modular, offer security features, and facilitate permission management and dependency tracking. ... and yes, before you all comment, we know that pi is actually 3.1415926 and not as displayed in the vid! Sorry, that was the typo that nearly got away ;-)
Views: 6836 IBExpertise
All About Passing Parameters SQL Task - SSIS
 
17:53
https://www.youtube.com/user/masterkeshav This explains SQL Task in SSIS and draws a comparison between how to pass parameter for an ADO.Net Vs OLEDB Connection.
Views: 34499 Keshav Singh
Oracle 11g Installation on RHEL6.4
 
01:36
Hello Friend, I am going to install the Oracle at RHEL6.4. I have mention below all Steps. If you want to ask question Please mail me at [email protected]gmail.com I will send the installation code. I have mention below details Please follow all step one by one. Oracle 11g Installation on RHEL6.4 Step-1 1. Install the following packages :- # rpm –ivh mpfr-2.4.1-6.el6.x86_64.rpm # rpm –ivh ppl-0.10.2-11.el6.x86_64.rpm # rpm –ivh binutils-2.20.51.0.2-5.11.el6 (x86_64) # rpm –ivh compat-libcap1-1.10-1 (x86_64) # rpm –ivh compat-libstdc++-33-3.2.3-69.el6 (x86_64) # rpm –ivh compat-libstdc++-33-3.2.3-69.el6.i686 # rpm –ivh kernel-headers-2.6.32-220.el6.x86_64.rpm # rpm –ivh glibc-headers-2.12-1.47.el6.x86_64.rpm # rpm –ivh glibc-devel-2.12-1.47.el6.x86_64.rpm # rpm –ivh cpp-4.4.6-3.el6.x86_64.rpm # rpm –ivh cloog-ppl-0.15.7-1.2.el6.x86_64.rpm # rpm –ivh gcc-4.4.4-13.el6 (x86_64) # rpm –ivh libstdc++-devel-4.4.6-3.el6.x86_64.rpm # rpm –ivh gcc-c++-4.4.4-13.el6 (x86_64) # rpm –ivh glibc-2.12-1.7.el6 (i686) # rpm –ivh glibc-2.12-1.7.el6 (x86_64) # rpm –ivh ksh after that press the tab button # rpm –ivh libgcc-4.4.4-13.el6 (i686) # rpm –ivh libgcc-4.4.4-13.el6 (x86_64) # rpm –ivh libstdc++-4.4.4-13.el6 (x86_64) # rpm –ivh libstdc++-4.4.4-13.el6.i686 # rpm –ivh libstdc++-devel-4.4.4-13.el6 (x86_64) # rpm –ivh libstdc++-devel-4.4.4-13.el6.i686 # rpm –ivh libaio-0.3.107-10.el6 (x86_64) # rpm –ivh libaio-0.3.107-10.el6.i686 # rpm –ivh libaio-devel-0.3.107-10.el6 (x86_64) # rpm –ivh libaio-devel-0.3.107-10.el6.i686 # rpm –ivh make-3.81-19.el6 # rpm –ivh sysstat-9.0.4-11.el6 (x86_64) # rpm –ivh unixODBC-2.2.14-11.el6.x86_64.rpm # rpm –ivh unixODBC-devel-2.2.14-11.el6.x86_64.rpm # rpm –ivh elfutils-libelf-devel-0.152-1.el6.x86_64.rpm Step-2 2. [[email protected] ~]# groupadd dba [[email protected] ~]# groupadd oper [[email protected] ~]# groupadd oinstall [[email protected] ~]# useradd -g oinstall -G dba,oper oracle [[email protected] ~]# passwd oracle Step-3 3. gedit /etc/sysctl.conf After this command one file will open. Then we need to copy below code in the file after that save this file fs.aio-max-nr = 1048576 fs.file-max = 6815744 kernel.shmall = 2097152 kernel.shmmax = 536870912 kernel.shmmni = 4096 kernel.sem = 250 32000 100 128 net.ipv4.ip_local_port_range = 9000 65500 net.core.rmem_default = 262144 net.core.rmem_max = 4194304 net.core.wmem_default = 262144 net.core.wmem_max = 1048576 Step-4 4. gedit /etc/security/limits.conf After this command one file will open. Then we need to copy below code in the file after that save this file oracle soft nproc 2047 oracle hard nproc 16384 oracle soft nofile 1024 oracle hard nofile 65536 oracle soft stack 10240 Step-5 5. [[email protected] ~]# mkdir -p /u01/app [[email protected] ~]# chmod -R 775 /u01/ [[email protected] ~]# chown -R oracle:oinstall /u01/ Step-6 6. vi /home/oracle/.bash_profile TMP=/tmp; export TMP TMPDIR=/tmp; export TMPDIR ORACLE_BASE=/u01/app/oracle; export ORACLE_BASE ORACLE_SID=orcl; export ORACLE_SID ORACLE_HOME=/u01/app/oracle/product/11.2.0/dbhome_1; export ORACLE_HOME PATH=$ORACLE_HOME/bin:$PATH; export PATH PATH=/usr/sbin:$PATH; export PATH ORACLE_TERM=xterm; export ORACLE_TERM LD_LIBRARY_PATH=$ORACLE_HOME/lib:/lib:/usr/lib; export LD_LIBRARY_PATH CLASSPATH=$ORACLE_HOME/JRE:$ORACLE_HOME/jlib:$ORACLE_HOME/rdbms/jlib; export CLASSPATH 7. Logout from root user and login as oracle user. 8. Login the Oracle user 9. # ./RunInstaller 10. After this command Oracle will install
Views: 70 Anurudh Pathak

Indian rail mobile ticketing application letters
Diversity officer cover letter
Cover letter references ppt
Internships cover letter samples
Looking for a new career cover letter