Home
Search results “Specify oracle home user”
Oracle 12c Database - How to install Oracle 12c Database in Windows 7
 
13:09
This video is a step-by-step guide for installing Oracle 12c Database in a Windows 7 desktop. Oracle Database 12c software can be downloaded from Oracle's website.
Views: 177435 Sam Dhanasekaran
Oracle - Understanding the tnsnames.ora and listener.ora files
 
12:46
Oracle - Understanding the tnsnames.ora and listener.ora files
Views: 181634 Chris Ostrowski
How to Set Environment Variables in Windows
 
01:27
Follow this step by step tutorial to learn how to set environment variables from system settings in the windows operating system. Don't forget to check out our site http://howtech.tv/ for more free how-to videos! http://youtube.com/ithowtovids - our feed http://www.facebook.com/howtechtv - join us on facebook https://plus.google.com/103440382717658277879 - our group in Google+ In this tutorial, you will learn how to set environment variables in windows. Operating systems require environment variables as settings and configurations for several processes. Although these variables are automatically defined or initialized during the installation of the system or specific software, in windows, to set environment variables manually is not a difficult task. That's because windows allows us to manually add, remove or edit environment variables through system settings according to our requirements. Step # 1 -- Opening environment variables In windows, to set environmental variables, you can take two paths. Either we can go to control panel, then access the system security option, and then the system option. Or we can simply right click on My Computer and select its properties. Once we are in the system window, select the advanced system settings from the list on the left side. A new window will pop up. Over here, click on the environment variables button near the bottom of this window and you can now access the Windows environment variables. Step # 2 -- Adding a variable In this window there are two sets of environment variables, one is the "user variables", and the other is the "system variables". Choose the new button in the user variables section to open the "define a new variable" dialog window. Over here, you will be required to define the variable name as anything you wish to set, such as temporary and then define its value as the path to the directory. With that done, let's complete this process by pressing OK. Your new environment variable has been created now. Step # 3 -- Editing and removing a variable To edit an environment variable, click on it, and then click on the edit button to open a dialog window. Here we can edit the name and value of the variable. Likewise to remove an environment variable, simply click on the variable and then click on the delete button. Once all the definitions are complete, close the window and restart your computer to allow the operating system to load these settings on boot. And that's basically all you need to know for how to set environment variables in windows.
How to add Python Path to Environment Variables in Windows 10
 
02:31
This video will show you how to set Windows 10 environment variables for Python. You can use this method to set Environment variables not just for Python but for any other programs and directories that you want to have a quick access to. See how to set Environment variables for Java JDK: https://www.youtube.com/watch?v=I-XrW1h8txc
Views: 132491 Artur Spirin
Oracle username and password and Account unlocking
 
08:37
all education purpose videos
Views: 264729 Chandra Shekhar Reddy
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: 127444 TechLair
How to know your oracle SID name
 
07:15
...................................................Finish.................................................. To get my others videos just go to the link which is given below.. https://www.youtube.com/channel/UCFcOAx6xy6aQgKzJFaJ_8zQ Stay connected with information... Stay Connected with my tutorial.. Stay connected with updated reports tutorial... Keep learning about Oracle Databese ....... Thanks for watching... Subscribe my Channel : Mahfujur Rahman Subscribe my channel : Mahfujur Rahman Thanks For Watching MdMahfujur Rahman Database Design and Development IDB-BISEW IT Scholarship Project. 01673472384
Views: 20038 Mahfujur Rahman
What is Oracle Base?
 
07:39
When you install Oracle Software for the first time in a machine, you would need to specify a folder that would act as a base for all the Oracle related softwares and folders. And every subsequent folders will be organized and referred using this base folder. This folder is called ORACLE_BASE For example, if you configure C:\app\oracle as your ORACLE BASE, then every folders will be created beneath it in an uniform structure. If you install, Oracle 12c software in Windows, it will by default, be installed in, C:\app\oracle\product\12.1.0\dbhome_1 Because Oracle_BASE is C:\app\oracle And, if you install, SQL Developer software, it will be installed in C:\app\oracle\product\sqldeveloper So, it is very important to setup the ORACLE_BASE environment variable before installing the Oracle software. To do that, first create the folder that you would want to designate as ORACLE_BASE. Then set the environment variable ORACLE_BASE What if ORACLE_BASE wasn’t set before invoking the Oracle Universal Installer? In Linux/UNIX: It will search for the first writable directory from /u01 to /u09 Let us say, it finds /u02 as the first writable directory and you have logged in as the OS user ‘oracle’ Then it will create a folder called /u02/app/oracle and will make it as the ORACLE_BASE If it cannot find any writable area from /u01 to /u09, then it will create the app/oracle directory under the user’s home directory. In Windows: It will search for the disk drive that has the most amount of free space Let us say, it finds D drive as the one and you are logged in as the OS user Oracle Then it will create a folder called D:\app\oracle and will make it as the ORACLE_BASE
Views: 4124 Sam Dhanasekaran
SQL tutorial 39: How to create user in oracle using Enterprise Manager
 
07:44
3rd and the last tutorial on how to create user in oracle database 11g or 10g. Enterprise manager is a web-based tool for managing databases created on the system. _____Links____ Website: http://www.RebellionRider.com Amazon Wishlist: http://bit.ly/wishlist-amazon Tutorial 37 create user using SQL Create User statement http://youtu.be/4QbK2Y-1LZw Tutorial 38 create user using SQL Developer too http://youtu.be/GS4udgR44Ls Copy Cloud referral link || Use this link to join copy cloud and get 20GB of free storage https://copy.com?r=kb4rc1 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: 25323 Manish Sharma
Install and configure Sql Developer on Windows | Oracle Tutorial
 
05:12
How to Install SQL Developer on Windows 1) Download for the below link http://www.oracle.com/technetwork/developer-tools/sql-developer/downloads/index.html 2) Make sure you have Java Development Kit installed with latest version. http://www.oracle.com/technetwork/java/javase/downloads/index.html 3) Install SQL developer as rpm -ihv sqldeveloper-xxx.noarch.rpm (replace xxx with exact version of your SQL developer) Run SQL developer on linux command prompt as $ sqldeveloper 4) Create a new connection to connect to user 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: 319291 TechLair
how to install Oracle 12c and setting up new user accounts , a perfect solution
 
13:53
you can download oracle 12c from the website here.. http://www.oracle.com/technetwork/database/enterprise-edition/downloads/index.html
Views: 101664 how to get installed?
How to install oracle client on windows
 
08:37
This Video describes the different types of Oracle Database Client installations that you can perform. Here is how to instal Oracle Client 12.1.0.1 on Windows 8 and connect remote oracle database. Oracle : Client 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: 79057 TechLair
How to Install Oracle Database 11g on Windows 10 By Manish Sharma
 
08:24
Detail tutorial on How to install Oracle database 11g enterprise edition on Windows 10 Professional 64 bit. Full installation under 9 mins. You can follow the steps for installing Oracle 11g on Windows 10 32 bit home or any other version. ------------------------------------------------------------------------ ►►►LINKS◄◄◄ Previous Tutorial ► Download Link http://www.oracle.com/technetwork/database/enterprise-edition/downloads/index.html ►Create Database using DBCA https://youtu.be/enFFezPYhCg ►How To Unlock User using ALTER USER https://youtu.be/sMqq9MSVmQo ------------------------------------------------------------------------- ►Make sure you SUBSCRIBE and be the 1st one to see my videos! ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ ►►►Find me on Social Media◄◄◄ Follow What I am up to as it happens on https://twitter.com/rebellionrider https://www.facebook.com/TheRebellionRider http://instagram.com/rebellionrider https://plus.google.com/+Rebellionrider http://in.linkedin.com/in/mannbhardwaj/ You can also Email me at for E-mail address please check About section 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: 308286 Manish Sharma
How to Install & Setup Oracle 11g R2 on Windows 7 / 8 / 10
 
14:18
Hello Everyone, How to Install & Setup Oracle 11g R2 on Windows 7 & 8 & Vista. In this tutorial, Let us Install Oracle Database 11g R1 on Windows 7 Download Oracle 11g Database from Oracle Website for Windows :- http://www.oracle.com/technetwork/database/enterprise-edition/downloads/index-092322.html NOTE :- For Any Clarification Please Comment Below Thanking You Hope U Like it........
Views: 51255 Cloud Network
Oracle Database 12c Tutorials 1: How to install Oracle Database 12c on windows 7 By Manish Sharma
 
08:45
Learn how to install oracle database 12c on windows 7/8. Proper step by step installation of oracle database 12c. Full Installation in a single video Follow Me on Twitter @RebellionRider and Instagram "RebellionRider" ------------------------------------------------------------------------ ►►►LINKS◄◄◄ Oracle Database Download http://www.oracle.com/technetwork/database/enterprise-edition/downloads/index.html JDK Download :http://www.oracle.com/technetwork/java/javase/downloads/index.html Related Tutorial ►Tut 1 How to install 11g on windows 7: http://youtu.be/0NLsJQCvKXY ►Tut 25 How to install Oracle 11g XE Express Edition: http://youtu.be/-13SbeDavwk ►Tut 16 How to Un-Install Database : http://youtu.be/pk-E-QxWe38 ------------------------------------------------------------------------- ►►►Help Me In Getting A Job◄◄◄ ►Help Me In Getting A Good Job By Connecting With Me on My LinkedIn and Endorsing My Skills. All My Contact Info is Down Below. You Can Also Refer Me To Your Company Thanks ------------------------------------------------------------------------- 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: 85428 Manish Sharma
Oracle Database 12c Tutorial 4: How to install sample schemas / users in Oracle Database 12c
 
08:33
Learn how to install sample schemas or users in oracle database 12c, In this tutorial you will also learn how to create a pluggable database in oracle database 12c by manish sharma RebellionRider ------------------------------------------------------------------------ ►►►LINKS◄◄◄ Blog : http://bit.ly/how-to-install-sample-schema-users-hr-sh-in-oracle-12c Previous Tutorial ► Tut 61: How To Unlock HR schema in Oracle Database 12c http://youtu.be/F81gfUnznZY ------------------------------------------------------------------------- ►►►Help Me In Getting A Job◄◄◄ ►Help Me In Getting A Good Job By Connecting With Me on My LinkedIn and Endorsing My Skills. All My Contact Info is Down Below. You Can Also Refer Me To Your Company Thanks ------------------------------------------------------------------------- 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: 51324 Manish Sharma
How to install and configure Oracle 12c Release 1 in Windows 8 64 bit.
 
32:57
How to install and configure Oracle 12c Release 1 in Windows 8 64 bit. This an Online Training video to demonstrate step by step methods to install Oracle 12c in Windows machine.
Views: 107176 Subhroneel Ganguly
Oracle Database 12c: Creating a User using Oracle Enterprise Manager Database Express
 
07:02
Demo of how to create a user with EM Express.
Views: 36375 OracleDBVision
How to Install Oracle Database 18c on Windows 10 by Manish Sharma
 
17:19
A detailed video on how to install Oracle Database 18c on Windows 10 by Manish Sharma from RebellionRider.com Video timestamps 00:26 - Minimum Hardware & Software Requirements 02:04 - How to Download Oracle 18c 04:14 - Pre-Installation Setup 06:28 - Installing Oracle 18c 16:35 - Enterprise Manager Link ------------------------------------------------------------------------ ►►►LINKS◄◄◄ Blog:http://bit.ly/oracle-18c-installation Important Links ►Download Oracle 18c from here https://www.oracle.com/technetwork/database/enterprise-edition/downloads/index.html ►List of Oracle 18c Compatible Windows Operating System https://www.facebook.com/notes/manish-sharma/oracle-18c-compatible-windows-operating-system/558692304534144/ ------------------------------------------------------------------------- ►Make sure you SUBSCRIBE and be the 1st one to see my videos! ------------------------------------------------------------------------- ►►►Find me on Social Media◄◄◄ Follow What I am up to as it happens on https://twitter.com/rebellionrider http://instagram.com/rebellionrider https://plus.google.com/+Rebellionrider http://in.linkedin.com/in/mannbhardwaj/ ___Facebook Official Page of Manish Sharma___ https://www.facebook.com/TheRebellionRider/ ___Facebook Official Page of RebellionRider.com___ https://www.facebook.com/RebellionRider.official/ You can also Email me at for E-mail address please check the About section 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 #Oracle18c #18c #OracleDatabase18c
Views: 4614 Manish Sharma
Migration from Non-Container to PDB database-PART I- Oracle 12C Administration
 
09:30
Non-Container Name =NCDB convert to PDB-NCDB Container DB Name=CDB =========================== Steps for Conversion. Step 1. Cleanly Shutdown the Non-CDB Database Instance. ==- set environment to NCDB ==- sqlplus / as sysdba ==- Shutdown immediate Step 2. Once You Have Cleanly Shutdown the Database, Start Up the database in Mount Exclusive Mode and Open the Database in Read-Only Mode. ==- set environment to NCDB ==- sqlplus / as sysdba ==- startup mount exclusive ==- alter database open read only; Step 3. Generate a Pluggable Database Manifest File from the Non-Container Database. ==- set environment to NCDB ==- sqlplus / as sysdba ==- exec dbms_pdb.describe (pdb_descr_file=-'E:\app\oracle\manifest\NCDB_manifest_file.xml'); Step 4. Shutdown the NON-CDB file Once Step 3 Completes Successfully. ==- Set environment to NCDB ==- sqlplus / as sysdba ==- shutdown immediate Step 5. Start the CDB (CDB) if it’s Not Already Up and Check the Compatibility with CDB. ==- set environment to CDB ==- sqlplus / as sysdba ==- startup (If not up) ==- Run below at SQL prompt. SET SERVEROUTPUT ON; DECLARE Compatible CONSTANT VARCHAR2(3) :=CASE DBMS_PDB.CHECK_PLUG_COMPATIBILITY (pdb_descr_file =- 'E:\app\oracle\manifest\NCDB_manifest_file.xml') WHEN TRUE THEN 'YES' ELSE 'NO' END; BEGIN DBMS_OUTPUT.PUT_LINE(compatible); END; / Step 6. Once it Completes Successfully, Query PDB_PLUG_IN_VIOLATIONS View from CDB Database for Any Errors. ==- set environment to CDB ==- sqlplus / as sysdba ==- select name, cause, type, message, status from PDB_PLUG_IN_VIOLATIONS where name='NCDB'; Note: "There should be no violations reported. If there are any, you need to fix it before proceeding". Step 7. Connect to the CDB Where Database has to be Plugged in Using the Noncdb Manifest File and Plug the PDDB12C Database. ==- set environment to CDB ==- sqlplus / as sysdba ==- CREATE PLUGGABLE DATABASE NCDB USING 'E:\app\oracle\manifest\NCDB_manifest_file.xml' COPY FILE_NAME_CONVERT = ('E:\APP\ORACLE\ORADATA\NCDB\', 'E:\app\oracle\oradata\CDB1\'); Note: "Below options are supported and you can chose one based on the env" 1) COPY: The datafiles of noncdb remains intact and it is copied to create PDBs at new locations and keep original datafiles intact at the original location. (This would mean that a noncdb database would still be operational after the creation of a PDB). 2) MOVE: The datafiles of noncdb are moved to a new location to create a PDB. In this case, noncdb database would not be available after a PDB is created. NOCOPY: The datafiles of noncdb are used to create a PDB2 and it uses same existing location. In this case, a noncdb database would not be available after a PDB is created. You can use FILE_NAME_CONVERT parameter to specify the new location of the datafiles while using COPY or MOVE option. Step 8. Once Step 7 Completes Successfully, Switch to the PDB Container and Run the "$ORACLE_HOME/rdbms/admin/noncdb_to_pdb.sql". ==- set environment to CDB ==- sqlplus / as sysdba ==- alter session set container=NCDB ==- @$ORACLE_HOME/rdbms/admin/noncdb_to_pdb.sql Step 9. Startup the PDB and Check the Open Mode. ==- set environment to CDB ==- sqlplus / as sysdba ==- ALTER PLUGGABLE DATABASE OPEN; ==-SELECT name, open_mode FROM v$pdbs;
Views: 642 ANKUSH THAVALI
How to Install SQL Developer on Windows | Oracle Tutorials for Beginners
 
06:32
How to install sql developer on windows How to Install sql developer on Windows? How to Install sql developer on Windows 10? How to Install sql developer on Windows 7? How to Install sql developer on Windows 8.1? Oracle tutorials for Beginners Install SQL Developer install and configure Sql Developer on Windows how to install sql developer,Windows 10 pro 64 bit how to download sql developer on Windows access oracle database from sql developer, oracle sql developer sql tutorials for beginners install sql developer on windows 10 64 bit SQL tutorials,PL\/SQL tutorials,PL\/SQL,ORACLE DBA tutorials Install SQL Developer install and configure Sql Developer on Windows how to install sql developer,Windows 10 pro 64 bi how to download sql developer on Windows access oracle database from sql developer, oracle sql developer sql tutorials for beginners install sql developer on windows 10 64 bit SQL tutorials,PL\/SQL tutorials,PL\/SQL,ORACLE DBA tutorials how to install sql developer youtube sql developer jdk path Oracle tutorials for Beginners how to install oracle sql developer on windows 8 please specify the path to the java jdk home sql developer install sql developer ubuntu jdk for sql developer how to install sql developer on mac uninstall sql developer how to install oracle sql developer on windows 8 sql developer jdk path sql developer free download for windows 10 64 bit please specify the path to the java jdk home sql developer sql developer ubuntu sql developer linux sql developer free download for windows 7 64 bit sql developer 17.2 download
Views: 1027 Oracle PL/SQL World
Oracle Database 12c Tutorial  2: How To Unlock HR schema in Oracle Database 12c
 
07:18
Learn how to unlock HR user / Schema in Oracle Database 12c. Step by step procedure of unlocking the HR Schema in Oracle 12c By Manish Sharma a.k.a RebellionRider ------------------------------------------------------------------------ ►►►LINKS◄◄◄ Blog : http://bit.ly/how-to-unlock-hr-user-in-oracle-database-12c Previous Tutorial ► Tut 60: How To Install 12c On Windows 7: http://youtu.be/T-rCbe1MMG4 ------------------------------------------------------------------------- ►►►Help Me In Getting A Job◄◄◄ ►Help Me In Getting A Good Job By Connecting With Me on My LinkedIn and Endorsing My Skills. All My Contact Info is Down Below. You Can Also Refer Me To Your Company Thanks ------------------------------------------------------------------------- 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: 78966 Manish Sharma
Oracle Database tutorials 1: How to install Oracle Database 11g on windows 7
 
08:54
How To install Oracle Database 11g enterprise edition On windows 7 64 bit. Full installation in Single video. Enjoy SQL and Oracle Database Download Oracle Database 11g from here http://www.oracle.com/technetwork/database/enterprise-edition/downloads/112010-win64soft-094461.html ------------------------------------------------------------------------ ►►►LINKS◄◄◄ Related Tutorial ► Tut 16 How To Uninstall Oracle 11g http://youtu.be/pk-E-QxWe38 ► Tut 25 How To Install Oracle 11g XE r2 http://youtu.be/-13SbeDavwk ► Oracle 12c Tut 1 How To Install Oracle 12c http://youtu.be/T-rCbe1MMG4 ►Oracle 12c Tut 5 How To Uninstall Oracle 12c http://youtu.be/lyN9aJfMlzQ ------------------------------------------------------------------------- ►►►Help Me In Getting A Job◄◄◄ ►Help Me In Getting A Good Job By Connecting With Me on My LinkedIn and Endorsing My Skills. All My Contact Info is Down Below. You Can Also Refer Me To Your Company Thanks -------------------------------------------------------------------------- ►Make sure you SUBSCRIBE and be the 1st one to see my videos! -------------------------------------------------------------------------- ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ ►►►Find me on Social Media◄◄◄ Follow What I am up to as it happens on https://twitter.com/rebellionrider https://www.facebook.com/TheRebellionRider http://instagram.com/rebellionrider https://plus.google.com/+Rebellionrider http://in.linkedin.com/in/mannbhardwaj/ You can also Email me at [email protected] You can help me in getting a good job by connecting with me on my LinkedIn and Endorsing my Skills. Please please LIKE and SHARE my videos it makes me happy. Thanks for liking, commenting, sharing and watching more of our videos This is Manish from RebellionRider.com ♥ I LOVE ALL MY VIEWERS AND SUBSCRIBERS
Views: 1378368 Manish Sharma
Oracle instant client set up for Toad developer.
 
08:28
How to set up Oracle client 10.2 for Toad. watch Amazing Video!!!!
Views: 19188 Singh VICKY
Linux : Fixed Oracle install System identifier '' already exists, specify another SID on Linux
 
01:40
The Oracle system identifier '' already exists, specify another SID , Fixed Oracle install System identifier on Linux
Views: 2023 No Name 0053
How to Install Java's JRE and JDK with PATH Environment Variables
 
04:01
A tutorial on how to install Java's JRE and JDK, and how to input the PATH variables properly to use them. JRE: http://www.oracle.com/technetwork/java/javase/downloads/jre8-downloads-2133155.html JDK: http://www.oracle.com/technetwork/java/javase/downloads/jdk8-downloads-2133151.html
Views: 93899 DaAwesomePwner
Set Path to JDK 8 on Windows 10
 
02:56
How to set Path to installed JDK on Windows 10 http://java-buddy.blogspot.com/2015/08/install-jdk-8-on-windows-10-and-set-path.html
Views: 177325 Java-Buddy+
How to reset java exe path on sql developer
 
08:12
In this tutorial you will learn how to reset the java.exe path in sql developer.
Views: 32356 DBA Pro
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: 58067 Manish Sharma
Server 2003 - How to configure Home drives and Folder Redirection in Windows Server 2003
 
14:51
Plz watch and subscribe : [email protected] Server 2003 - How to configure Home drives and Folder Redirection in Windows Server 2003 In this tutorial, I have shown creating and configuring Home drives and Folder redirection, normally My documents, my music, my videos and so on for files and folders sharing between User accounts in Windows server 2003. Server 2003 - How to configure Home drives and Folder Redirection in Windows Server 2003 Plz share : https://youtu.be/-NMwXLMPqIk
Views: 472 ITbird143
APACHE SPARK Installation on WIndows:Spark Setup part1
 
09:33
See also-SCALA IDE Set up for Spark and running Firsts Spark Program using Eclipse:Spark Setup part2 https://youtu.be/xLSMEDyetm0 This video steps 1. Install a JDK (Java Development Kit) from http://www.oracle.com/technetwork/java/javase/downloads/index.html. Keep track of where you installed the JDK; you’ll need that later. 2. Download a pre-built version of Apache Spark from https://spark.apache.org/downloads.html 3. If necessary, download and install WinRAR so you can extract the .tgz file you downloaded. http://www.rarlab.com/download.htm 4. Extract the Spark archive, and copy its contents into C:\spark after creating that directory. You should end up with directories like c:\spark\bin, c:\spark\conf, etc. 5. Download winutils.exe from https://sundog-spark.s3.amazonaws.com/winutils.exe and move it into a C:\winutils\bin folder that you’ve created. (note, this is a 64-bit application. If you are on a 32-bit version of Windows, you’ll need to search for a 32-bit build of winutils.exe for Hadoop.) Right-click your Windows menu, select Control Panel, System and Security, and then System. Click on “Advanced System Settings” and then the “Environment Variables” button. 6. Add the following new USER variables: a. SPARK_HOME c:\spark b. JAVA_HOME (the path you installed the JDK to in step 1, for example C:\Program Files\Java\jdk1.8.0_101) c. HADDOP HOME c:\winutils 7. Add the following paths to your PATH user variable: %SPARK_HOME%\bin %JAVA_HOME%\bin 8. Close the environment variable screen and the control panels.
Views: 623 Deepak Kaushik
How to Install Java JDK on Windows 10 ( with JAVA_HOME )
 
08:56
In this video I am going to show you How to install Java JDK on Windows 10 ( with JAVA_HOME ). Java installer .msi file comes with JRE and JDK. Java JDK Installation for Microsoft Windows (64-bit). JDK stands for Java SE Development Kit. JRE stands for Java Runtime Environment. 1. Download Java Open your web browser Type URL: http://www.oracle.com/technetwork/java/javase/downloads/index.html to go to Oracle download page Click on button “ JDK download ” for Java SE update 4. This will lead you JDK download page http://www.oracle.com/technetwork/java/javase/downloads/jdk-7u4-downloads-1591156.html Accept oracle license agreement Find and click on the correct jdk download link right for your operating system to download Save the file to disk 2. Install Java Double click to run the download file Just follow the prompt in Installer window #Javatutorialforbeginners #Javatutorial #Javaprogramming #Javaprogrammingtutorial #Javabasicsforbeginners ----------------------Follow--------------------------------------------- My Website - http://www.codebind.com My Blog - https://goo.gl/Nd2pFn My Facebook Page - https://goo.gl/eLp2cQ Google+ - https://goo.gl/lvC5FX Twitter - https://twitter.com/ProgrammingKnow Pinterest - https://goo.gl/kCInUp Text Case Converter - https://goo.gl/pVpcwL -------------------------Stuff I use to make videos ------------------- Stuff I use to make videos Windows notebook – http://amzn.to/2zcXPyF Apple MacBook Pro – http://amzn.to/2BTJBZ7 Ubuntu notebook - https://amzn.to/2GE4giY Desktop - http://amzn.to/2zct252 Microphone – http://amzn.to/2zcYbW1 notebook mouse – http://amzn.to/2BVs4Q3 ------------------Facebook Links ---------------------------------------- http://fb.me/ProgrammingKnowledgeLearning/ http://fb.me/AndroidTutorialsForBeginners http://fb.me/Programmingknowledge http://fb.me/CppProgrammingLanguage http://fb.me/JavaTutorialsAndCode http://fb.me/SQLiteTutorial http://fb.me/UbuntuLinuxTutorials http://fb.me/EasyOnlineConverter -------------------Online Courses to learn---------------------------- Java - https://bit.ly/2H6wqXk C++ - https://bit.ly/2q8VWl1 AngularJS - https://bit.ly/2qebsLu Python - https://bit.ly/2Eq0VSt C- https://bit.ly/2HfZ6L8 Android - https://bit.ly/2qaRSAS Linux - https://bit.ly/2IwOuqz AWS Certified Solutions Architect - https://bit.ly/2JrGoAF Modern React with Redux - https://bit.ly/2H6wDtA MySQL - https://bit.ly/2qcF63Z
Views: 1088528 ProgrammingKnowledge
Error in writing to directory temp oracle universal installer needs you to have permission
 
01:45
error in writing to directory temp oracle universal installer needs you to have permission in this area to install. installation cannot continue . please make sure temp is set to a valid writable directory.
SQL Developer
 
01:45
I am a new beginner on Using Oracle Database and today i have faced the problem when i was busy try to Run Oracle SQL Developer!! The Massage pop up before the Oracle opened and saying: ENTER THE FULL PATHNAME FOR THE JAVA.EXE I just know your facing the same problem thats why you have take your time to read this Post. What i fail to detect the time you use to solve the problem, you may direct the pathname to your Java.exe in your Pc but It did not Work. Follow the Following Few Step: The Java we need to deal with is automatic installed on your installation folder of the Oracle. a)Open SQL Developer as Admistrator b)Click Browser to view the files c)Find your Oracle Installation Folder. Mine is installed on Local Disk D of my Computer "ShadowNet": d) Follow the path to reach the destination Example: My Installation Path "D:\app\rAY\product\11.1.0\db_1\jdk\jre\bin" NOTE: D:\-Is my Local Disk Letter app-Oracle Installation Folder rAY-My PC name
Views: 4767 RayAspiring
2017 Latest Oracle 1Z0-060 Exam Practice Questions And Answers
 
01:21
http://www.passitdump.com/1Z0-060.html Updated and latest Oracle 1Z0-060 exam practice questions and answers, pass Oracle 1Z0-060 exam test quickly and easily at first attempt. Exams: QUESTION 1 What are two benefits of installing Grid Infrastructure software for a stand-alone server before installing and creating an Oracle database? A. Effectively implements role separation B. Enables you to take advantage of Oracle Managed Files. C. Automatically registers the database with Oracle Restart. D. Helps you to easily upgrade the database from a prior release. E. Enables the Installation of Grid Infrastructure files on block or raw devices. Correct Answer: CE Explanation: C: To use Oracle ASM or Oracle Restart, you must first install Oracle Grid Infrastructure for a standalone server before you install and create the database. Otherwise, you must manually register the database with Oracle Restart. E: * Oracle ASM is Oracle's recommended storage management solution that provides an alterna- tive to conventional volume managers, file systems, and raw devices. * The Oracle Grid Infrastructure for a standalone server provides the infrastructure to include your single-instance database in an enterprise grid architecture. Oracle Database 12c combines these infrastructure products into one software installation called the Oracle Grid Infrastructure home. On a single-instance database, the Oracle Grid Infrastructure home includes Oracle Restart and Oracle Automatic Storage Management (Oracle ASM) software. Reference: Oracle Grid Infrastructure for a Standalone Server, Oracle Database, Installation Guide, 12c QUESTION 2 Identify two correct statements about multitenant architectures. A. Multitenant architecture can be deployed only in a Real Application Clusters (RAC) configuration. B. Multiple pluggable databases (PDBs) share certain multitenant container database (CDB) resources. C. Multiple CDBs share certain PDB resources. D. Multiple non-RAC CDB instances can mount the same PDB as long as they are on the same server. E. Patches are always applied at the CDB level. F. A PDB can have a private undo tablespace. Correct Answer: BE Explanation: B: Using 12c Resource manager you will be able control CPU, Exadata I/O, sessions and parallel servers. A new 12c CDB Resource Manager Plan will use socalled "Shares" (resource allocations) to specify how CPU is distributed between PDBs. A CDB Resource Manager Plan also can use "utilization limits" to limit the CPU usage for a PDB. With a default directive, you do not need to modify the resource plan for each PDB plug and unplug. E: New paradigms for rapid patching and upgrades. The investment of time and effort to patch one multitenant container database results in patching all of its many pluggable databases. To patch a single pluggable database, you simply unplug/plug to a multitenant container database at a different Oracle Database software version. Reference: http://www.certkings.com/latest-emc-e20-690-pdf/ Incorrect: Not A: * The Oracle RAC documentation describes special considerations for a CDB in an Oracle RAC environment. * Oracle Multitenant is a new option for Oracle Database 12c Enterprise Edition that helps customers reduce IT costs by simplifying consolidation, provisioning, upgrades, and more. It is supported by a new architecture that allows a container database to hold many pluggable databases. And it fully complements other options, including Oracle Real Application Clusters and Oracle Active Data Guard. An existing database can be simply adopted, with no change, as a pluggable database; and no changes are needed in the other tiers of the application. Not D: You can unplug a PDB from one CDB and plug it into a different CDB without altering your schemas or applications. A PDB can be plugged into only one CDB at a time. not F: * UNDO tablespace can NOT be local and stays on the CDB level. * Redo and undo go hand in hand, and so the CDB as a whole has a single undo tablespace per RAC instance. Read more: https://youtu.be/uB_QdT6NeLM
Views: 106 lucy steve
Arch Linux UEFI step-by-step installation guide
 
28:54
This is the most up-to-date Arch Linux UEFI installation tutorial. I still recommend the legacy mode installation https://youtu.be/GKdPSGb9f5s To write ISO to USB, watch this video https://youtu.be/rpGgTTFKwiU But if you need or have to use UEFI - Unified Extensible Firmware Interface - then proceed with this tutorial. Advantages of UEFI: • UEFI replaces the BIOS firmware interface • UEFI is compatible with GPT tables • It is more configurable → boots faster Advantages of GPT - GUID Partition Table (GPT): • Supports larger than 2 TB volumes • Supports up to 128 partitions rather than the 4 primary partitions limited to MBR These are the command to install Audio and graphical interface I mentioned in the video: pacman -S pulseaudio pulseaudio-alsa xorg xorg-xinit xorg-server xfce4 lightdm lightdm-gtk-greeter If you want to install Arch Linux with other than XFCE, use the corresponding command to include in your ~/.xinitrc file and install the corresponding GUI: xfce: "exec startxfce4" sudo pacman -S xfce4 gnome: "exec gnome-session" sudo pacman -S gnome cinnamon: "exec cinnamon-session" sudo pacman -S cinnamon mate: "exec mate-session" sudo pacman -S mate unity: "exec unity" Unity installation is tricky - see Arch Linux Wiki Budgie: "export XDG_CURRENT_DESKTOP=Budgie:GNOME" "exec budgie-desktop" sudo pacman -S budgie-desktop openbox: "exec openbox-session" sudo pacman -S openbox i3: "exec i3" sudo pacman -S i3 awesome: "exec awesome" sudo pacman -S awesome deepin "exec startdde" sudo pacman -S deepin LXDE "exec startlxde" sudo pacman -S lxde Tags: #ArchLinux #ArchUEFI #ArchInstallation ################################################ Support on Patreon: https://www.patreon.com/averagelinuxuser Donate through PayPal: https://www.paypal.me/Kryvokhyzha ################################################ More cool Linux stuff at other social media: Google+ - Best Linux Stuff: https://plus.google.com/+AverageLinuxUser Facebook - Top Linux Tips: https://www.facebook.com/AverageLinuxUser Twitter - Daily Linux News: http://twitter.com/AVGLinuxUser Website: http://averagelinuxuser.com/
Views: 14370 Average Linux User
How to Install ParrotSec OS in Virtualbox #Ethical Hacking
 
11:40
How to Install ParrotSec OS in Virtualbox #Ethical Hacking Visit Our Website:https://www.dmznetworks.tech Download Parrot OS ISO: https://bit.ly/2GLZILy Download VirtualBox: https://bit.ly/1mQkaJC How to Install ParrotSec OS in Virtualbox step by step Step 1: Downloading and installing VirtualBox Head over to the Oracle VirtualBox Website and download the newest version of VirtualBox. Install it after you downloaded it, leaving everything on default. Step 2: Downloading ParrotSec OS Download the Parrot Security Distribution. Choose either 32 or 64 bit according to your System Architecture. Once you have VirtualBox installed and downloaded the ParrotSec ISO file, we can go ahead and create our Virtual Machine. Step 3: Creating the ParrotSec VM Alright, open VirtualBox and click on New to create a new VM. Enter a Name, as System choose Linux and Other Linux 64bit or 32bit according to your architecture. Creating a new VM Next, we are going to allocate memory. I have plenty so I give it 4096 MB. Adjust according to your system memory. Allocating around 25-50% is fine. Allocating Memory Now we create our Virtual Hard Drive. Choose to Create a virtual hard disk now. Creating a Virtual Hard Disk Leave the format on VDI for VirtualBox Disk Image. Choose VDI Next, choose Dynamically allocated. This means, that if you choose let’s say a Hard Disk Size of 20GB, it will only take up space it’s actually using, not the full 20 GB. It fills up space over time to a maximum of 20 GB. Choose Dynamically Allocated Next, we are going to choose a location where to save our .VDI file. Choose a location that suits you best. Preferably an SSD drive. Click on the little folder on the right side to choose a location, then adjust the Disk Size. I’ll give it 25GB so it has some room to grow (Wordlists etc.) Adjusting the VDI location and size Now go ahead and start your VM. You will get asked to provide the path to the ParrotSec.ISO file you downloaded earlier. Click on the folder and specify the file location, most likely C:\Users\YourUserName\Downloads. Hit Start. Starting the V Step 4: Installing ParrotSec Alright, time to run through the installation process. In the first Window that comes up choose Install. Installing ParrotSec Next, choose the Standard Installer. Optional you can choose the GTK GUI installer. I like old school, so I don’t. Choose the Standard Installer Now we are going through the tedious process of choosing Languages, Locales and Keyboard layouts. I said step-by-step, so we do step-by-step If you are familiar with those settings, just skip through, same same but different. Select your System Language Select your Location next. Select your Location …And select your Locales. If you don’t know what to choose here, just leave it at U S A. Choosing a Locale Trust me, we are almost there. Choose a Keymap to use for the installation. It doesn’t really matter, you have to choose it again once the System boots up anyway, don’t know why but it is what it is. Choosing a Keyboard Layout Now set your ROOT password. This is your most important Password, if you are a Windows guy, this is your Administrator Password. Choose wisely. Choosing a Root Password Next, we are creating a User Account for non-Administrative activities. It’s great that this is automatically done in Parrot, in Kali you would need to do this manually. Choose a Username. Don’t use my Username. Creating a Non-root User Did I already say we are almost there? It was a lie. Now we are almost there. For Partitioning Method choose: Guided – Use Entire Disk. Choosing a Partitioning Method Select your Virtual Hard Disk. Choosing your VBOX Hard Disk Now we are choosing a Partitioning File. Leave it on All Files in one partition, except you know what you are doing. Choosing a Partitioning Scheme Select Finish partitioning and write changes to disk and confirm the following Warning with yes. Writing changes to Disk Writing changes to Disk Confirm that you want to install the Grub Bootloader on the Master boot Record. Installing Grub Now choose your VBOX Hard Disk. Choosing the Hard Disk Now wait for the installation to finish, it takes around 10 Minutes. Confirm with Continue to reboot the system. Congratulations! Initial Installation done! Support Us: Twitter:https://twitter.com/dmznetworks Tumblr:https://dmznetworks.tumblr.com/ Skyrock:http://dmz-network.skyrock.com/ Blogger:http://www.dmznetworks.tech/ Google+:https://plus.google.com/u/0/110125716327435602216 Reddit:https://www.reddit.com/user/dmz-networks/ Stumble:https://www.stumbleupon.com/stumbler/dnetwork00 Linkedin:https://www.linkedin.com/in/dmz-networks-449b9514a Pinterest:https://www.pinterest.com/dmznetworks/ Facebook:https://www.facebook.com/DMZ-Networks
Views: 783 Armitage Sudo
How to Set Environment Variables in Linux
 
00:56
Follow this tutorial to learn how to set shell environment variables in a Linux operating system like Ubuntu. Don't forget to check out our site http://howtech.tv/ for more free how-to videos! http://youtube.com/ithowtovids - our feed http://www.facebook.com/howtechtv - join us on facebook https://plus.google.com/103440382717658277879 - our group in Google+ In this tutorial, you will learn how to set environment variables in linux. Linux based operating systems use bash shell. The shell environment variables are used for several purposes, from storing data, storing software configurations, set terminal settings, and changing shell environment. The environment variables are normally created by the operating system during installation, or by different software as per the required need. Apart from that, in linux, to set environment variables, we first need to access the terminal application. That's because the user has the privilege to add, edit, and remove different variables at will. Step # 1 -- All variables on terminal In linux, to set environment variables we first need to access shell environment variables. For that, we will need to open the terminal by searching for it in the applications menu, or selecting it from the dock on the left. Once the terminal is opened up, to check for all environment variables, type the set command and press enter. This will list all the environment variables stored in the shell. Step # 2 -- One variable at a time The amount of these variables can become a very long list and locating one specific variable can become a tough task. Fortunately Linux allows us to display the value of one shell variable by using the echo command along with the name of the variable. This makes the task very easy. Step # 3 -- Changing a variable Now, to add or modify an environment variable, we can use the export command followed by the name of the variable and the values that go with it. Multiple values for a variable need to be separated by a colon. The colon indicates to the operating system that one value has ended and another has begun. The variables can be created and removed from the shell easily, and can be done whenever required. But changing important variables may mess with the operating system's functionalities so it's important to be careful. And that's basically all you need to know for how to set environment variables in Linux.
Dynamic SQL in SQL Server
 
12:12
Text version of the video http://csharp-video-tutorials.blogspot.com/2017/03/dynamic-sql-in-sql-server.html Slides http://csharp-video-tutorials.blogspot.com/2017/03/dynamic-sql-in-sql-server_27.html All SQL Server Text Articles http://csharp-video-tutorials.blogspot.com/p/free-sql-server-video-tutorials-for.html All SQL Server Slides http://csharp-video-tutorials.blogspot.com/p/sql-server.html All SQL Server Tutorial Videos https://www.youtube.com/playlist?list=PL08903FB7ACA1C2FB All Dot Net and SQL Server Tutorials in English https://www.youtube.com/user/kudvenkat/playlists?view=1&sort=dd All Dot Net and SQL Server Tutorials in Arabic https://www.youtube.com/c/KudvenkatArabic/playlists In this video we will discuss 1. What is Dynamic SQL 2. Simple example of using Dynamic SQL What is Dynamic SQL Dynamic SQL is a SQL built from strings at runtime. Simple example of using Dynamic SQL Here is the SQL Script to create Employees table and populate it with data Create table Employees ( ID int primary key identity, FirstName nvarchar(50), LastName nvarchar(50), Gender nvarchar(50), Salary int ) Go Insert into Employees values ('Mark', 'Hastings', 'Male', 60000) Insert into Employees values ('Steve', 'Pound', 'Male', 45000) Insert into Employees values ('Ben', 'Hoskins', 'Male', 70000) Insert into Employees values ('Philip', 'Hastings', 'Male', 45000) Insert into Employees values ('Mary', 'Lambeth', 'Female', 30000) Insert into Employees values ('Valarie', 'Vikings', 'Female', 35000) Insert into Employees values ('John', 'Stanmore', 'Male', 80000) Go One way to achieve this is by implementing a stored procedure as shown below that this page would call. Create Procedure spSearchEmployees @FirstName nvarchar(100), @LastName nvarchar(100), @Gender nvarchar(50), @Salary int As Begin Select * from Employees where (FirstName = @FirstName OR @FirstName IS NULL) AND (LastName = @LastName OR @LastName IS NULL) AND (Gender = @Gender OR @Gender IS NULL) AND (Salary = @Salary OR @Salary IS NULL) End Go The stored procedure in this case is not very complicated as we have only 4 search filters. What if there are 20 or more such filters. This stored procedure can get complex. To make things worse what if we want to specify conditions like AND, OR etc between these search filters. The stored procedure can get extremely large, complicated and difficult to maintain. One way to reduce the complexity is by using dynamic SQL as show below. Depending on for which search filters the user has provided the values on the "Search Page", we build the WHERE clause dynamically at runtime, which can reduce complexity. However, you might hear arguments that dynamic sql is bad both in-terms of security and performance. This is true if the dynamic sql is not properly implemented. From a security standpoint, it may open doors for SQL injection attack and from a performance standpoint, the cached query plans may not be reused. If properly implemented, we will not have these problems with dynamic sql. In our upcoming videos, we will discuss good and bad dynamic sql implementations. For now let's implement a simple example that makes use of dynamic sql. In the example below we are assuming the user has supplied values only for FirstName and LastName search fields. To execute the dynamicl sql we are using system stored procedure sp_executesql. sp_executesql takes two pre-defined parameters and any number of user-defined parameters. @statement - The is the first parameter which is mandatory, and contains the SQL statements to execute @params - This is the second parameter and is optional. This is used to declare parameters specified in @statement The rest of the parameters are the parameters that you declared in @params, and you pass them as you pass parameters to a stored procedure Declare @sql nvarchar(1000) Declare @params nvarchar(1000) Set @sql = 'Select * from Employees where [email protected] and [email protected]' Set @params = '@FirstName nvarchar(100), @LastName nvarchar(100)' Execute sp_executesql @sql, @params, @FirstName='Ben',@LastName='Hoskins' This is just the introduction to dynamic SQL. If a few things are unclear at the moment, don't worry. In our upcoming videos we will discuss the following 1. Implementing a real world "Search Web Page" with and without dynamic SQL 2. Performance and Security implications of dynamic sql. Along the way we will also discuss good and bad dynamic sql implementations. 3. Different options available for executing dynamic sql and their implications 4. Using dynamic sql in stored procedures and it's implications Once we discuss all the above, you will understand 1. The flexibility dynamic sql provides 2. Advantages and disadvantages of dynamic sql 3. When and when not to use dynamic sql
Views: 35485 kudvenkat
How to drop user Oracle || Ra soft
 
03:06
How to drop user Oracle #tags Graphics Design,logo design,Ra soft,Technology,Adobe photoshop,How to design Logo,Logo design,adobe illustrator tutorial,Create logo,How to design,Design logo,create,How to design logo,illustrator,water drops,Drop shadow,Create a logo,RA Soft Technology,Ra Technology,Robi logo,How to Create LOV,Create LOV,How to oracle 10g Uninstall,Oracle 10g Unistall,How to add hyper link oracle forms,oracle forms add website link,how to add hyper link oracle 10g,oracle forms add hyper link.
Views: 453 RA Soft
Oracle 12c dba Tutorial : How to create multitenat container Database  | Oracle Pluggable Database
 
05:32
creating pluggable database enabled container Database using DBCA
Views: 2685 Wysheid Wysheid
Install Elastic (XEL) Node on Raspberry Pi
 
15:24
12 easy steps to get Elastic (XEL) Node up and running on a raspberry pi. Donations :) XEL: XEL-A4NE-SM4U-G5NK-4R53G BTC: 1DmCQ4U8DMiUEE1n6b7DCcnXgHVR3FJ368 SD Formatter for 0-16GB https://www.sdcard.org/downloads/form... Format SD (greater than) 16GB manual: https://www.raspberrypi.org/documenta... Raspbian NOOBS: https://www.raspberrypi.org/downloads/ Putty (ssh client) : https://www.chiark.greenend.org.uk/~s... #change a user password $ passwd #update upgrade your system $ sudo apt update && sudo apt upgrade && sudo apt dist-upgrade #Basic packages: $ sudo apt install mc ntp fail2ban htop screen nano -y #download java 8 sdk (javafx fix files) $ wget http://download.gluonhq.com/javafxports/embedded/armv6hf-sdk-8.60.9.zip #Unzip zip file $ unzip armv6hf-sdk-8.60.9.zip #copy javafx files to default installation $ sudo cp armv6hf-sdk/rt/lib/ext/jfxrt.jar /usr/lib/jvm/jdk-8-oracle-arm32-vfp-hflt/jre/lib/ext/ $ sudo cp armv6hf-sdk/rt/lib/arm/* /usr/lib/jvm/jdk-8-oracle-arm32-vfp-hflt/jre/lib/arm/ $ sudo cp armv6hf-sdk/rt/lib/javafx.platform.properties /usr/lib/jvm/jdk-8-oracle-arm32-vfp-hflt/jre/lib/ $ sudo cp armv6hf-sdk/rt/lib/javafx.properties /usr/lib/jvm/jdk-8-oracle-arm32-vfp-hflt/jre/lib/ $ sudo cp armv6hf-sdk/rt/lib/jfxswt.jar /usr/lib/jvm/jdk-8-oracle-arm32-vfp-hflt/jre/lib/ #Choose default java $ sudo update-alternatives --config javac $ sudo update-alternatives --config java #verify java version: $ java -version #Install the uncomplicated firewall package: $ sudo apt get install ufw #Allow ssh (tcp/22) $ sudo ufw allow ssh #Allow elastic port 17876 $ sudo ufw allow 17876 #Enable the firewall $ sudo ufw enable #add a user named elastic sudo adduser elastic #random passwords: https://www.random.org/passwords/?num... #exit putty / logout $ exit #Download the litewallet: $ git clone https://github.com/unvo1d/Elastic-XEL... #Compile the wallet $ ./compile.sh #start a screen session $ screen #resume a detached screen session $ screen -r #Detach screen within the session ctrl+a+d #update Elastic litewallet (make sure you are in the elastic folder) $ git pull $ ./compile #Generate a SSL Certificate $ keytool -genkeypair -keyalg RSA -keysize 2048 -validity 3650 -keystore keystore #Create or edit a file with nano text editor $ nano nxt.properties #content for the Elastic nxt.properties file: #-------------------------------------------------------------------------- # Hosts from which to allow http/json API requests, if enabled. Set to * to # allow all. Can also specify networks in CIDR notation, e.g. 192.168.1.0/24. nxt.allowedBotHosts=* # Host interface on which to listen for http/json API request, default localhost # only. Set to 0.0.0.0 to allow the API server to accept requests from all # network interfaces, including IPv6. nxt.apiServerHost=0.0.0.0 # Password that should be provided when executing protected (administrative) API # requests. # Please choose a decent password here. Preferably, use a password generator. # Password protection is disabled and password is not needed when the API server # only listens on the localhost interface, i.e. when # nxt.apiServerHost=127.0.0.1. nxt.adminPassword=generateSomeAdminAPIPasswordAndPasteHere # Enable SSL for the API server (also need to set nxt.keyStorePath and # nxt.keyStorePassword). # Non-SSL connections will be disabled if nxt.apiServerSSLPort is equal to # nxt.apiServerPort. # Otherwise, both SSL and non-SSL connections will be accepted. nxt.apiSSL=true # keystore file and password, required if uiSSL or apiSSL are enabled. nxt.keyStorePath=keystore nxt.keyStorePassword=passwordYouProvidedDuringSSLCertGeneration #-------------------------------------------------------------------- #Save a file within nano ctrl+o #Exit a file within nano ctrl+x #java version $ javac -version #start raspbian config $ sudo raspi-config #start crontab scheduler as Elastic user $ sudo crontab -u elastic -e @reboot sleep 30 && cd /home/elastic/Elastic-XEL-Litewallet && ./run.sh #reboot server $ sudo reboot now
Views: 334 Creamers
Managing Funds
 
02:29
Configure funds from multiple sources, such as endowments, bonds, and grants; control and monitor how funds are distributed to workspaces and projects; specify when funds are available and distribute them at predetermined intervals; track how funds are consumed to complete project work. ================================= 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 set Android SDK path in Ubuntu?
 
06:44
How to set Android SDK path in Ubuntu? PATH of any Android tool can be set using export command in ~/.bashrc file. 1. Open ~/.bashrc file 2. Type the following line of command at the end of the ~/.bashrc file : export PATH=$PATH:"~/android-sdk/platform-tools":"~/android-sdk/tools" 3. Save the file 4. Restart the Terminal
Views: 19137 Technology And Product
#14 SAP ASE 16 Learning-Using Bulk Copy Utility
 
16:50
SAP ASE 16 Learning Part 14 Using Bulk Copy Utility. To Learn or Teach Linux visit www.theskillpedia.com, A Marketplace for Learners and Trainers. Session 14 Using BCP Utility Ram N Sangwan The BCP Utility When performing database maintenance you will occasionally find the need to export data out of your database tables to an operating system for storage, or conversely import data to a table from a file. You may find yourself needing to do these tasks for data backup or for inserting data that comes from a 3rd party export. Sybase makes this process simple by the Bulk Copy Utility (BCP). It work directly at OS Level by-passing ASE Server. Therefore, triggers are not fired, indexes are not created automatically The BCP Utility bcp_r is a threaded version of bcp. You must use bcp_r if a security service, such as Kerberos, or a directory service, such as LDAP, is used. You cannot use named pipes to copy files in or out. Using --hide-vcc improves performance, as Adaptive Server does not transfer and calculate data from virtual computed columns. Although you can use any Transact-SQL command with --initstring as an initialization string for bcp, you must reset possible permanent changes to the server configuration after running bcp. You can, for example, reset changes in a separate isql session. You can specify multiple partitions and data files. Separate each partition name or data file with commas. The BCP Utility bcp does not insert any row that contains an entry exceeding the character length of the corresponding target table column. bcp does not insert truncated data into the table Important Parameters -c : performs the copy operation with char datatype as the default storage type of all columns in the data file. -t field_terminator : default field terminator. -r row_terminator : row terminator. -U username : specifies an Adaptive Server login name. -P password : specifies an Adaptive Server password. If you do not specify -Ppassword, bcp prompts for a password. You can leave out the -P flag if your password is NULL. -I interfaces_file : specifies the name and location of the interfaces file to search when connecting to Adaptive Server. Important Parameters Contd.. -S server : specifies the name of the Adaptive Server. -v : displays the version number of bcp and a copyright message and returns to the operating system. -A packet_size : specifies the network packet size to use for this bcp session. -W : specifies that if the server to which bcp is attempting to connect supports neither normal password encryption nor extended password encryption, plain text Important Parameters Contd.. -E : explicitly specifies the value of a table’s IDENTITY column. You cannot use the -g and -E flags together. -N : skips the IDENTITY column. -R remote_server_principal : specifies the principal name for the server as defined to the security mechanism. Use the -R parameter when the server’s principal name and network name are not the same. -i input_file : specifies the name of the input file. The Standard Input is used as the default. -o output_file : specifies the name of the output file. The Standard Output is used as the default. Important Parameters Contd.. y sybase_directory : sets an alternate Sybase home directory. -x trusted.txt_file : specifies an alternate trusted.txt file. --hide-vcc : instructs bcp not to copy virtual computed columns either to or from a datafile. When you use this option in bcp OUT, the data file contains no data for virtual computed columns. When you use it in bcp IN, the data file may contain no data for a virtual computed column. BCP Example 1 Copies data from the publishers table to a file named pub_out with char datatype as the default storage type of all columns in the data file, specifying the default field terminator and row terminator. The first backslash before the final “r” escapes the second so that only one backslash is printed: bcp pubs2..publishers out pub_out -c -t , -r \\r BCP Example 2 Copies data back into Adaptive Server using the saved format file, pub_form: bcp pubs2..publishers in pub_out -f pub_form BCP Example 3 Copies a data file created with a character set used on a VT200 terminal into the pubs2..publishers table. The -z flag displays bcp messages in French: bcp pubs2..publishers in vt200_data -J iso_1 -z french BCP Example 4 Copies partition p1, p2, and p3 to files a, b, and c respectively, into the \work2\data directory. bcp t1 partition p1, p2, p3 out \work2\data\1,\work2\data\b, \work2\data\c BCP Example 5 Disables replication for the bcp connection during the transfer of data from titles.txt data into pubs2..titles: bcp pubs2..titles in titles.txt –initstring 'set replication off' Thank You
Views: 1380 TheSkillPedia
How Do I Change Directories In Linux Terminal?
 
00:46
Change directory in terminal? Linux forums. Feb 28, 2014 how to use cd, pwd, and ls explore the file system on a linux server this will create virtual terminal session directly in your web may 24, 2011 you can tab key after pressing first few characters (this then 'fill in' rest of folder for e. Basic linux commands for terminal beginners raspberry pi documentation. Cd go few directories up in linux stack overflow. How do i change directories in the terminal, and command line how can terminal? Ask usingtheterminal community help wikihow to directory ubuntu linux via or manage files from terminal 11 commands you cd unix learning shell lesson 2 navigation linuxcommand. Linux command line to change directory lifewire. If you have navigated to another folder such as the var logs or mnt etc then typing cd returns back your user's home directory apr 26, 2017 linux command help and information with examples, syntax, related note by default, when open a terminal begin using how heck do i change in terminal? I dont know if it is just different than fc rh but that those two ch we create sudo mkdir, won't be able will last access time current on raspberry pi (running raspbian), default application order navigate other directories command,, can further root user found page ls f list files indicate file type keyboard shortcut switch terminals ctrl alt f1 thru f7, f7 normal aug 30, 2012 b now wanna go. [email protected] me]$ cd usr bin bin]$ pwd may 25, 2006 the command is used to change current directory (i. Unlike in windows, cd must always be followed by a space; Commands like and will not work, but sep 6, 2014 to easily another directory, simply open terminal window, type because it lets you know the name of directory under linux examples navigate into root use 'cd ' your home 'cd' or up one level, previous (or back). What does cd do when entered into a terminal window lifewire. Linux cd command help and examples computer hope. Oct 3, 2015 to use the linux terminal like a pro, you'll need know basics of you can also specify full path directory, such as cd usr share is command change directory terminal's shell when first log on system, working set your home. Googleusercontent search. Linux terminal command reference linux mint community. How to use cd, pwd, and ls explore the file system on a linux terminal how cd directory with name containing spaces in. Type cd l tab fills in. Use cd to change directory elsewhere. Your computer will have at least one drive which is jul 19, 2017 within linux the tilde ( ) symbol what known as a metacharacter and confines of terminal's shell it has special meaning. That will upd or make more powerfull variant, cd to dir name in current path. How to use the cd command, by linux information project (linfo). How do i change directories in the terminal, and command line how askubuntu terminal know which directory im url? Q webcache. Changing directories is easy as long you know where are (your current it tells linux to start at the
PacketShaper Demo: Full Video
 
12:31
PacketShaper gives you content-aware control of today's web-integrated WAN. Prioritize important applications like Oracle, SAP, Salesforce.com and Office365. Assure quality for VoIP and videoconferencing. Contain recreational traffic to any level you specify.
Views: 10407 Symantec + Blue Coat
How to Fix Port Conflicts in Apache (Xampp)
 
04:48
Note: If port 80 is not the problem, it could be another port. Such as 443 because apache also uses port 443. If you need to change port 443, go to httpd-ssl.conf and look for the appropriate "listen 443" and change it to something such as 444. More content! - http://CalebCurry.com Tech/Business Facebook - http://www.facebook.com/CalebTheVideoMaker Personal Twitter - http://Twitter.com/calebCurry Subscribe for more - http://bit.ly/PqPyvH Amazing Web Hosting - http://bit.ly/ccbluehost (The best web hosting for a cheap price!)
Views: 97481 Caleb Curry

Purpose of a cover letter in a business plan
Pipefitter cover letter
Skyscanner application letters
Annotated bibliography mla example 2014 jeep
Graphic design cover letter examples aiga chicago