Home
Search results “Oracle grants on db links”
How to Create Database Link in Oracle. /* Step By Step /*
 
17:21
Today I am showing you. How to create Database link (DB Link) in Oracle. What is Database Link ( DB Link ) ? A database link is a schema object in one database that enables you to access objects on another database. I have 2 databases 1. paragdb 2. orcl In Paragdb database 1. Create listener 2. Service Name 3. In Orcl Database 1. Create Listener 2. Service Name 3. Create new User 4.Grant connect,resource,create database link to username; 5. open user 6. create database link 1. create database link link1 connect to scott identified by tiger using 'connect_primary''; 7.select * from [email protected]; 8. select * from [email protected]; 9. views 1. select * from user_db_links; 2. select * from all_db_links; 10. conn sys as sysdba 11. grant public database link to username; 12. select * from dba_db_links; 13. conn username/pass 14. create public database link plink connect to scott identified by tiger using 'connect_primary'; 15. drop database link. drop database link link1; To follow this steps you will also create oracle database link. It is very easy to understand.
Views: 9250 Parag Mahalle
SQL Tutorial - How to grant System and Object Privileges in Oracle Database
 
18:08
In this session I Explaining the Theory of Granting and Revoking System and Object privileges.... #Oracletutorialforbeginners #rmanrecoverytutorial #SQLTutorial #SystemandObjectPrivilegesinOracle by Lalit saini
Views: 12595 Oracle World
SQL tutorial 48: How to create Roles in Oracle Database
 
07:16
4th SQL Tutorial in the series of user privileges in oracle database user Roles in Oracle Database. In this tutorial you will learn ● What user roles ● How to create simple roles (Role with Not Identified clause) ● How to create secure roles (Role with Identified clause) ● How to create external role. ● How To create global role. ● How to Grant System Privilege to a user Role ● How to Grant Object Privilege to a user Role In oracle database. ● How to grant a Role to another Role ● How To grant a role to database users (with Admin option) ● How To enable role using SET ROLE statement This video will teach you the concept of user role in oracle database which is an extension to the user privileges. In this video I did 10 SQL queries on user Roles which makes this tutorial fun. Celebrating 1000 subscribers. Thanks a lot guys for all your love and support. ------------------------------------------------------------------------ ►►►LINKS◄◄◄ Blog: http://bit.ly/create_role_in_oracle System Privilege: http://youtu.be/EQzdtKPiErU Object Privilege: http://youtu.be/DuDL7NTPdqQ ------------------------------------------------------------------------- Copy Cloud referral link || Use this link to join copy cloud and get 20GB of free storage https://copy.com?r=kb4rc1 -------------------------------------------------------------------------- ►Make sure you SUBSCRIBE and be the first one to see my videos! -------------------------------------------------------------------------- Amazon Wishlist: http://bit.ly/wishlist-amazon ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ ►►►Find me on Social Media◄◄◄ Follow What I am up to as it happens on https://twitter.com/rebellionrider https://www.facebook.com/imthebhardwaj http://instagram.com/rebellionrider https://plus.google.com/+Rebellionrider http://in.linkedin.com/in/mannbhardwaj/ http://rebellionrider.tumblr.com/ http://www.pinterest.com/rebellionrider/ You can also Email me at [email protected] Please please LIKE and SHARE my videos it makes me happy. Thanks for liking, commenting, sharing and watching more of our videos This is Manish from RebellionRider.com ♥ I LOVE ALL MY VIEWERS AND SUBSCRIBERS
Views: 24878 Manish Sharma
Oracle Database Tutorial 52 : Data Pump expdp - How to Export full database using expdp
 
07:26
Oracle Database tutorial/SQL Tutorial 52 On Data Pump expdp utility here in this tutorial you'll learn how to export full/complete Database using expdp data pump utility of oracle Database ------------------------------------------------------------------------ ►►►LINKS◄◄◄ Blog: http://bit.ly/database-full-export-using-expdp Tut 48 Roles: http://youtu.be/tyYxSrCXzCM ------------------------------------------------------------------------- ►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/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: 79343 Manish Sharma
SQL tutorial 45: Introduction to user Privileges in Oracle Database By Manish Sharma RebellionRider
 
04:30
First SQL Tutorial in the series of user privileges in oracle database an introduction to user privileges. In this tutorial you will learn ● What is user privileges ● Different types of user Privileges ● Data Control Language (DCL) Grant and Revoke ● Who Can Grant or Revoke System Privileges? ● Oracle grant flags such as "With Admin option, With Grant option and with hierarchy option " This is a quick video on Introduction of user privileges expaining the theoretical concepts for the better understanding of the concept and up coming videos in USER PRIVILEGE series. Celebrating 1000 subscribers. Thanks a lot guys for all your love and support. ------------------------------------------------------------------------ ►►►LINKS◄◄◄ Blog: http://bit.ly/introduction-to-user-privileges ------------------------------------------------------------------------- Copy Cloud referral link || Use this link to join copy cloud and get 20GB of free storage https://copy.com?r=kb4rc1 -------------------------------------------------------------------------- ►Make sure you SUBSCRIBE and be the first one to see my videos! -------------------------------------------------------------------------- Amazon Wishlist: http://bit.ly/wishlist-amazon ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ ►►►Find me on Social Media◄◄◄ Follow What I am up to as it happens on https://twitter.com/rebellionrider https://www.facebook.com/imthebhardwaj http://instagram.com/rebellionrider https://plus.google.com/+Rebellionrider http://in.linkedin.com/in/mannbhardwaj/ http://rebellionrider.tumblr.com/ http://www.pinterest.com/rebellionrider/ You can also Email me at [email protected] Please please LIKE and SHARE my videos it makes me happy. Thanks for liking, commenting, sharing and watching more of our videos This is Manish from RebellionRider.com ♥ I LOVE ALL MY VIEWERS AND SUBSCRIBERS
Views: 29093 Manish Sharma
DB Hacking - Oracle
 
14:30
Проверяем на прочность Oracle RDBMS ODAT (Oracle Database Attacking Tool) https://github.com/quentinhardy/odat
How to find out the SID and DB Home in Oracle Database by Manish Sharma
 
05:10
What is my SID, Where is my DB Home in Oracle Database? Are these questions haunting you? Here's How to find out the SID and DB Home in Oracle Database by Manish Sharma from RebellionRider ------------------------------------------------------------------------ ►►►LINKS◄◄◄ Blog: http://bit.ly/sid_dbHome Previous Tutorial ► How to connect to your Pluggable Database using SQL Developer https://youtu.be/1gvN1A6xnxU ------------------------------------------------------------------------- ►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 #Oracle18cByRebellionRider #RebellionRider
Views: 1581 Manish Sharma
3.Schema level Export and Import in oracle database
 
07:03
Hello friends in this video i explain how to export full schema(user) and performing a recovery after drop of user. #SchemalevelExportandImport Oracle database Unbeatable,Unbreakable Platform..
Views: 19318 Oracle World
Oracle Database11g tutorials 14 : How to CREATE TABLE using sql developer and command prompt
 
08:36
Oracle Database11g tutorials 14 How to Create table using command prompt and Create table using sql developer Blog Link http://bit.ly/1TkY4Oe Time Line 0:25 Introduction of Tables in Database 1:03 What is Create Table (Introduction of create table) 1:30 Syntax of Create Table 2:08 How to create table using Command Prompt 4:55 How to create table using SQL Developer Links for Oracle Database tutorials 4: database connectivity using SQL developer and command prompt http://youtu.be/wSqoXRlXDUU You can have indepth knowledge about SQL create table here http://www.rebellionrider.com/sql-create-table.html Tool used in this tutorial is command prompt. This tutorial series is part of SQL expert exam certification training. if you are preparing for SQL certification you can use my tutorials. This SQL Tutorial is a part of free training. Copy Cloud referral link || Use this link to join copy cloud and get 20GB of free storage https://copy.com?r=j7eYO7 Contacts E-Mail [email protected] Twitter https://twitter.com/rebellionrider Instagram http://instagram.com/rebellionrider Facebook. https://www.facebook.com/imthebhardwaj Linkedin. http://in.linkedin.com/in/mannbhardwaj/ Thanks for linking, commenting, sharing and watching more of our videos This is Manish from RebellionRider.com Today in this oracle database tutorial we will see How to CREATE A TABLE. if we have to define a table in layman language then we can say that Tables are just a collection of Rows and Columns but In RDBMS tables are database objects which help in organizing data into ROWS and COLUMNS. We can also say that SQL tables are kind of data structure which are used by database for efficient storage of data. To create a table in our database we use SQL CREATE TABLE command. SQL CREATE TABLE is a type of DATA DEFINITION LANGUAGE also known as DDL. To Create a table in your schema you will require CREATE TABLE system privilege. In our future videos we will see what are system and object privileges and how to grant them to a user. Today for this video we will be using Sample schema HR which already has all the necessary privileges. Ohk Let's see the syntax. CREATE TABLE table name ( column name1 Data-Type(size), column name2 Data-Type(size), ..... ); CREATE TABLE is an oracle reserved word or say an Oracle key word whereas There are 3 different ways of creating a table in Oracle database. Creating a table using Command Line Interface (CLI) in Oracle database For demonstrating how to create table in oracle database using CLI, I'll be using Command prompt. Thats how we create table using command prompt. you can check your table structure by DESCRIBE command for that just write DESC and your table name. Like this Another way of creating a table is by using Graphic user interface (GUI) in Oracle database To demonstrate how to create table using GUI we will use SQL developer. Lets open our SQL developer I am connected to HR schema if you do not know how to create a connection to database using SQL developer please watch my oracle database tutorial 4 that explains database connectivity using SQL developer and command prompt. Link for this video is in the description below. So lets create a table. Creating a table using SQL developer is very easy we do not have to fire any query here. Let's start First of all right click on your connection in which you want to create a table and choose schema browser. This will open a separate schema browser pane or you can expend your connection by clicking this + sign and then right click on table and choose New Table. However I prefer working with schema browser so let's skip to schema browser pane here from the first drop-down list you can choose connection name and in the second drop down list you can choose what database objects you want to work with we want to create a table thus I'll choose table and then click this arrow here and choose option for new table Ok we have created a table wizard first of all give a unique name to your table and add some column as well. For this, click the green plus button. Now we already have a column so give it some name. Also choose a datatype from the list and specify any size you can check this not null column if in case you want to make this a mandatory column you can also specify default value and constraint If you want to make this column a primary key you can click here In my future video i'll show you what are these constraints and different ways of applying them on a column in a table. for this video we will concentrate on create table only so when you are done with all your columns click ok Thats your table You can double click on your table here and can see its structure. Thats it
Views: 186820 Manish Sharma
create db links
 
02:21
Views: 536 sheleycsus
Create new connection with new user in Oracle SQL Developer
 
10:28
This video shows you how to create a new connection using a new user account (other than the system user account) in Oracle SQL Developer, so that you have a clean workspace without all the clutter of system tables. It is NOT a general introduction to using Oracle SQL Developer.
Views: 370550 Chitu Okoli
Oracle DBA Justin - How to set the Oracle environment on a Unix or Linux system
 
28:22
How to set the Oracle environment on a Unix or Linux system
Views: 49825 jbleistein11
How to create a database in Linux Redhat Oracle 11g
 
10:59
Here u can find hw to create a database using Linux Operating System Redhat in Oracle 11g edition.... Plz... Watch it ..
Views: 2712 Prashanth Gandhe
Tutorials#76  How to create  SYNONYM in Oracle SQL Database
 
07:11
Explaining How to create Synonym in Oracle SQL Database or what is a synonym in SQL or synonym in SQL Server A synonym is an alternative name for objects such as tables, views, sequences, stored procedures, and other database objects. Assignment: Assignment link will be available soon: In this series we cover the following topics: SQL basics, create table oracle, SQL functions, SQL queries, SQL server, SQL developer installation, Oracle database installation, SQL Statement, OCA, Data Types, Types of data types, SQL Logical Operator, SQL Function,Join- Inner Join, Outer join, right outer join, left outer join, full outer join, self-join, cross join, View, SubQuery, Set Operator. follow me on: Facebook Page: https://www.facebook.com/LrnWthr-319371861902642/?ref=bookmarks Contacts Email: Rak[email protected] Instagram: https://www.instagram.com/equalconnect/ Twitter: https://twitter.com/LrnWthR #equalConnectCoach #rakeshmalviya
Views: 204 EqualConnect Coach
Oracle DBA Justin - How to grant a system privilege to a user in an Oracle database
 
11:28
How to grant a system privilege to a user in an Oracle database
Views: 22836 jbleistein11
4BS:.Anjiprasad....oracle network database links
 
38:31
4BS:- Anjiprasad..........oracle database links connect one database to other
MySQL - CREATE USER with GRANT Privileges in Terminal
 
11:22
In this tutorial I explain how to insert a user into the mysql database, with all privileges required to become a "super user". I also show you how you can remove the user from the database with the DROP command.
Views: 64469 Davids Videos
Configuring Linked Server in SQL Server to connect to Oracle database
 
11:17
This tutorial is about creating database linked server in Microsoft SQL Server 2014 to connect to Oracle Database XE. You require to install Oracle instant client and configure net service name to use as data source. Example of executing dml script is mentioned in this video.
Views: 17962 Subhroneel Ganguly
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: 55979 Manish Sharma
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: 56538 Mr_Chicken
How to Create SCOTT Schema and default tables in Oracle Database 11g
 
04:31
Looking for a best Webhosting Company at low and Best Service click this link:https://www.ipage.com/join/index.bml?AffID=739220 From Last Few Months I Was Looking For Best Webshosting Company Where I Can Host My 100 Of Website At Low Price And With Best Quality Service , And Then I Came To Know About https://www.ipage.com/join/index.bml?AffID=739220 A Hosting Company Where I Get Hosting For Unlimited Domains At Just 1.6$ Per Month With Control Panel , 24hrs Support And All In All A Best Platform To Host Any Website( one-click install wordpress option) .Dont Be Late Offer Valid Till 25th October 2014 , Host Your WebSite With Best Service Provider Today By Clicking The Link Above Or Here: https://www.ipage.com/join/index.bml?AffID=739220 To get a responsive and Modern design contact http://www.variabletips.com and get at just 20$ Now !!! Check my Website: http://variabletips.com for more details. If there is no Oracle default scott schema is available after the installation of Oracle 11g database in windows, Then how to create the scott schema and the default tables like emp , dept, bonus, salgrade in database. Here is a easy step by step tutorial to create it in your database. Open the sql plus in your system. Login as username : sys as sysdba and the password which is given at the time of installation. After connected to Oracle database you need to create the scott schema. Run this script: CREATE USER scott IDENTIFIED BY tiger; scott is the user tiger is the password. Grant all access to user scott,run this script: GRANT ALL PRIVILEGES TO scott; Download the Oracle default tables file: https://www.dropbox.com/s/m9lr8cnc00vqy3i/oracle.zip https://drive.google.com/file/d/0BxJYa0O21A_udlZqQmNZaFBvNTA/edit?usp=sharing Extract the downloaded file in your system. Then Connect to Scott user as: CONNECT scott Password: tiger Then type this in your sql command prompt: @(extract file path)\oracle.sql; for example: @C:\Users\ABC\oracle\oracle.sql; Now you done all the steps completely and you can work with scott schema and all the default tables. Check This in your system to show all the tables in scott user: Select * from tab; After that you can see all the default table in scott user. Just run it to show the default data inside the tables. Select * from emp; If 14 row selected....Then You sucessfully Created the scott schema and the default Oracle tables in your system. Like and subscribe this video: http://www.youtube.com/watch?v=vHcAs7k93AQ
Views: 17632 variabletips
Oracle DBA- Realtime Activities
 
12:37
Get Oracle DBA online training on real time scenarios and issues. Take a step by step learning modules and become an expert Oracle DBA with our professional trainer.
Views: 175981 OrSkl Academy
Oracle DB 12c - Auditing
 
19:28
Oracle DB 12c - Auditing Watch more videos at https://www.tutorialspoint.com/videotutorials/index.htm Lecture By: Mr. Parth Panjabi, Tutorials Point India Private Limited
How to Create Oracle Database in Silent Mode /* Step By Step /*
 
10:25
We can create Oracle Database in Silent Mode. It is very easy to create. we can write some lines on $ prompt and then enter it is automatically create oracle database with proper location. It is very easy to understand. plz follow this steps to create Database in silent mode. Installation Script : dbca -silent -createDatabase -templateName General_Purpose.dbc -gdbname orcl -sid orcl -syspassword sys -systempassword sys -responseFile NO_VALUE -characterSet AL32UTF8 -memoryPercentage 50 -emConfiguration NONE
Views: 1493 Parag Mahalle
How to create user in Oracle
 
03:23
How to create new Account/User in Oracle? Example: ungtien_promotion / ungtien1q2w3e#$ Step1: login DB: 10.225.6.135: PUB with account DBA to create new account Step 2: execute these command as below --- create tablespace “arct” create tablespace ungtien_promotion datafile '+DATA' size 1g; --- create user on DB create user ungtien_promotion identified by ungtien1q2w3e#$ default tablespace ungtien_promotion ; grant unlimited tablespace to ungtien_promotion; grant create database link, CREATE ANY VIEW, CREATE SEQUENCE, CREATE JOB, CONNECT, RESOURCE, CREATE ANY JOB, CREATE ANY PROCEDURE, CREATE SESSION, CREATE ANY TABLE to ungtien_promotion;
Views: 1 thuand03cntt
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: 140690 TechLair
Oracle DB 12c - Privileges
 
15:40
Oracle DB 12c - Privileges Watch more videos at https://www.tutorialspoint.com/videotutorials/index.htm Lecture By: Mr. Parth Panjabi, Tutorials Point India Private Limited
How to implement VPD in Oracle Database (Part 1)
 
12:37
How to implement VPD (Virtual Private Database) in Oracle Database(9i,10g,11g,12c) Enterprise Edition. PART 1 Video links: Part 1 https://youtu.be/JVvtvh3cN1I Part 2 https://youtu.be/xLcin_Wgbvs Part 3 https://youtu.be/mE1cSbmEwnQ This is Part of Oracle Advance Security. Please view my earlier videos on how to create a database , if you are not having a database. 1)First we will create the users needed for our environment a)Owner of the schema which will have the objects or tables b)security admin user c)non owner user1 & user2 which will have limited access as per data in the rows (here user1 will have access to data with HR and user2 with FINANCE) Object owner creation: -------------- CREATE USER schemaowner IDENTIFIED BY schemaowner DEFAULT TABLESPACE users TEMPORARY TABLESPACE temp; GRANT connect, resource TO schemaowner; alter user schemaowner quota unlimited on users; security admin user creation: -------------- CREATE USER SEC_ADM IDENTIFIED BY sec_adm default tablespace users temporary tablespace TEMP; GRANT CONNECT, RESOURCE TO sec_adm; alter user sec_adm quota unlimited on users; garnts for the sec_adm user: ------------- GRANT CREATE SESSION,CREATE ANY CONTEXT,CREATE PROCEDURE,CREATE TRIGGER, ADMINISTER DATABASE TRIGGER TO SEC_ADM; GRANT EXECUTE ON DBMS_SESSION TO SEC_ADM; GRANT EXECUTE ON DBMS_RLS TO SEC_ADM; create user with restricted access on table: ----------------------- CREATE USER user1 IDENTIFIED BY user1 DEFAULT TABLESPACE users TEMPORARY TABLESPACE temp; GRANT connect, resource TO user1; CREATE USER user2 IDENTIFIED BY user2 DEFAULT TABLESPACE users TEMPORARY TABLESPACE temp; GRANT connect, resource TO user2; Now we will log in as schemaowner and create one tables : ------------------- CONN schemaowner/schemaowner This table is the table which contains the secure as well as un-restricted data CREATE TABLE user_data (column1 VARCHAR2(50) NOT NULL, user_id VARCHAR2(30) NOT NULL); Now to access this table from other schema we need to give the select and insert privs to: GRANT SELECT, INSERT ON user_data TO sec_adm,user1, user2;
Views: 1071 OracleDBA
Oracle Database 18c Express Edition Installation on Redhat Enterprise Linux 7.5
 
33:55
In this video we are going to demonstrate how to install Oracle Database 18c Express Edition in Redhat Enterprise Linux 7.5. Oracle Database 18c Express Edition installation in RHEL 7 Platform is very easy. This video guides step by step installation of oracle 18c includes kernel parameters configuration, dependencies installation, oracle database installation, oracle listener configuration after installation and finally access oracle enterprise manager 18c in browser. Hardware Requirements : Minimum 2 GB RAM, 2 CPU Cores and Enough Hard disk Space. Software Requirements : Redhat Enterprise Linux 7 with dependencies for oracle database 18c installed and Kernel Parameters configured. Important Note: To avoid Port already in use error I will be configuring hostname at the end of installation. Installation method : Offline, Oracle Database 18c XE RPM file for linux downloaded and installed. Oracle Database 18c XE Features ############################### Oracle Multitenant SQLJ Microsoft Distributed Transaction Coordinator support Native .NET Data Provider—ODP.NET .NET Stored Procedures Online index rebuild Online table organization Online table redefinition Trial recovery Fast-start fault recovery Flashback Table Flashback Database Cross-platform Backup and Recovery Sharded Queues Network Compression Client Side Query Cache Query Results Cache PL/SQL Function Result Cache Adaptive Execution Plans In-Memory Column Store In-Memory Aggregation Attribute Clustering Column-Level Encryption Tablespace Encryption Oracle Advanced Security Oracle Database Vault Oracle Label Security Centrally Managed Users Fine-grained auditing Privilege Analysis Real Application Security Redaction Transparent Sensitive Data Protection Virtual Private Database Oracle Spatial and Graph Property Graph and RDF Graph Technologies (RDF/OWL) Partitioned spatial indexes Oracle Partitioning Oracle Advanced Analytics Oracle Advanced Compression Advanced Index Compression Prefix Compression (also called Key Compression) Basic Table Compression Deferred Segment Creation Bitmapped index, bitmapped join index, and bitmap plan conversions Transportable tablespaces, including cross-platform and full transportable export and import Summary management—Materialized View Query Rewrite
Views: 145 java frm
New Oracle DBA Career: 4.Installation of Oracle 11g Database on Linux Server
 
47:15
Unix for Dummies: http://www.amazon.com/gp/offer-listing/0764541471/ref=sr_1_1_olp?ie=UTF8&qid=1362962504&sr=8-1&keywords=unix+for+dummies&condition=new VI Cheat Sheet: http://www.lagmonster.org/docs/vi.html Oracle Linux 5.2: https://edelivery.oracle.com/linux Guide: http://www.oracle-base.com/articles/11g/oracle-db-11gr2-installation-on-oracle-linux-5.php Putty: http://www.chiark.greenend.org.uk/~sgtatham/putty/download.html Xming: http://sourceforge.net/projects/xming/
Views: 9132 Online DBA Academy
Oracle Database 18c Express Edition Installation on Windows 10 | Oracle Database 18c XE
 
16:14
After long time, Oracle has released finally Oracle Database 18c Express Edition for Windows x64, Oracle Database Express Edition (XE) Release 18.4.0.0.0 In this video we are going to demonstrate how to install Oracle Database 18c Express Edition on Windows 10 Oracle Database 18c Express Edition installation in Windows is very easy. This video guides step by step installation. We are going to learn 1. Database Installation 2. Enterprise Manager Overview 3. SQL Plus tool 4. Oracle Instance Manager to start and shutdown database instance. Hardware Requirements : Minimum 2 GB RAM, 2 CPU Cores and Enough Hard disk Space. Software Requirements : OracleXE184_Win64 Zip file for Windows already downloaded from Oracle website. Important Note: Adobe Flash player must be installed in order to browse Enterpise Manager Console on Internet Explorer. Installation method : Offline, Oracle Database 18c Zip file for Windows downloaded and installed. download link: https://www.oracle.com/technetwork/database/database-technologies/express-edition/downloads/index-083047.html Oracle Database 18c XE Features ############################### Oracle Multitenant SQLJ Microsoft Distributed Transaction Coordinator support Native .NET Data Provider—ODP.NET .NET Stored Procedures Online index rebuild Online table organization Online table redefinition Trial recovery Fast-start fault recovery Flashback Table Flashback Database Cross-platform Backup and Recovery Sharded Queues Network Compression Client Side Query Cache Query Results Cache PL/SQL Function Result Cache Adaptive Execution Plans In-Memory Column Store In-Memory Aggregation Attribute Clustering Column-Level Encryption Tablespace Encryption Oracle Advanced Security Oracle Database Vault Oracle Label Security Centrally Managed Users Fine-grained auditing Privilege Analysis Real Application Security Redaction Transparent Sensitive Data Protection Virtual Private Database Oracle Spatial and Graph Property Graph and RDF Graph Technologies (RDF/OWL) Partitioned spatial indexes Oracle Partitioning Oracle Advanced Analytics Oracle Advanced Compression Advanced Index Compression Prefix Compression (also called Key Compression) Basic Table Compression Deferred Segment Creation Bitmapped index, bitmapped join index, and bitmap plan conversions Transportable tablespaces, including cross-platform and full transportable export and import Summary management—Materialized View Query Rewrite.
Views: 5441 java frm
Oracle username and password and Account unlocking
 
08:37
all education purpose videos
Views: 287090 Chandra Shekhar Reddy
Oracle Database Users / User Management (Simple)
 
09:33
Create, Alter, Drop, Grant Rights, Default Tablespace, Temporary Tablespace, Quota Setup, View Users Information, Lock / Unlock user account select username,account_status,default_tablespace, temporary_tablespace,created from dba_users; create user myuser identified by myuser; alter user myuser quota unlimited on mytbs; alter user myuser quota 100m on mytbs; alter user temporary tablespace temp; alter user myuser default tablespace mytbs; alter user myuser accout unlock; alter user myuser account lock; alter user myuser password expire; alter user myuser identified by youuser; create user myuser identified by myuser default tablespace users temporary tablespace temp quota unlimited on users; grant create session, resource to myuser; grant create session, resource to myuser with grant option; drop user asif; drop user asif cascade;
Views: 41953 Abbasi Asif
Oracle DBA Justin - How to drop/delete an Oracle database
 
09:03
How to delete/drop an Oracle database
Views: 15334 jbleistein11
Oracle DB 12c - Creation & Configure CDB & PDBs using DBCA
 
19:07
Oracle DB 12c - Creation & Configure CDB & PDBs using DBCA Watch more videos at https://www.tutorialspoint.com/videotutorials/index.htm Lecture By: Mr. Parth Panjabi, Tutorials Point India Private Limited
SQL tutorial 41: How to UNLOCK USER in oracle Database
 
04:13
SQL tutorial on How to unlock user or schema in oracle database or how to unlock hr account/user/schema in oracle database using alter user SQL command. you can use the steps to change the password of any user in oracle database explained in detail. Celebrating 1000 subscribers. Thanks a lot guys for all your love and support. ------------------------------------------------------------------------- Blog Link: http://bit.ly/unlock-user-in-oracle -------------------------------------------------------------------------- ►Make sure you SUBSCRIBE and be the first one to see my ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ 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/ 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: 40720 Manish Sharma
New Oracle DBA Career 9: Users, Grants Privileges and Roles Part 1
 
33:30
Scripts from Google Drive https://drive.google.com/folderview?id=0B4GkUqNu5wGeLTBrT1g0WEVfd3c&usp=sharing
Views: 1623 Online DBA Academy
How to Create SCOTT Schema and default tables in Oracle Database 11g
 
04:31
If there is no Oracle default scott schema is available after the installation of Oracle 11g database in windows, Then how to create the scott schema and the default tables like emp , dept, bonus, salgrade in database. Here is a easy step by step tutorial to create it in your database. Follow these Steps One By One. File Download Link: https://sites.google.com/site/gpabukcbyarshman/gpa-semester-wise/oracle.zip?attredirects=0&d=1 For More...!! Facebook.Com/MrArshman
Views: 2103 Arshman Saleem
Crear DBlink Oracle a otro motor de DB. KL
 
10:15
Crear un DBlink en Oracle a MariaDB por medio de ODBC. Konrad Lorenz
Views: 384 Fernando Mora
HOW TO CREATE DATABASE USER IN ORACLE  10G  SOFTWARE
 
05:40
THIS VIDEO WILL TECH YOU HOW TO CREATE DATABASE USER IN ORACLE 10G SOFTWARE . --------------------------------------------------------------------------------------------------------- create user and grant privileges in oracle oracle create user example oracle create user schema invalid common user or role name create user in oracle 12c oracle grant create session oracle delete user create user sql
Views: 338 Creative Things
Creating  Managing  Droping Oracle Database Tablespaces
 
12:10
Creating Managing Droping Oracle Database Tablespaces select tablespace_name,block_size,status,contents,logging from dba_tablespaces; create tablespace mytbs datafile 'd:\oradata\dbrdbms\mytbs01.dbf' size 10m; alter tablespace mytbs add datafile 'd:\oradata\dbrdbms\mytbs02.dbf' size 10m; alter tablespace mytbs drop datafile 'd:\oradata\dbrdbms\mytbs02.dbf'; desc v$datafile; desc ts#,name from v$datafile; select ts#,name from v$tablespace; select v$datafile.ts#,v$datafile.name,v$tablespace.name from v$datafile,v$tablespace where v$datafile.ts#=v$tablespace.ts# and v$tablespace.name='MYTBS'; alter database datafile 'd:\oradata\dbrdbms\mytbs01.dbf' resize 20m; ALTER DATABASE DEFAULT TABLESPACE mytbs; select ts#,name from v$tablespace; select ts#,name from v$datafile; select ts#,name from v$tablespace; drop tablespace mytbs; drop tablespace mytbs ialtncluding contents and datafiles; drop tablespace mytbs including contents and datafiles cascade; alter tablespace mytbs read only; alter tablespace mytbs read write; alter tablespace mytbs force logging; alter tablespace mytbs nologging; alter tablespace mytbs flashback on; alter tablespace mytbs flashback off; purge tablespace mytbs user myuser;
Views: 22216 Abbasi Asif
Oracle Database Tutorial 55: How to export tables using PARFILE in expdp Data Pump By Manish Sharma
 
05:31
In this Oracle Tutorial you will learn how to export tables of the database using Parameter File (PARFILE) in Data Pump expdp export utility. ------------------------------------------------------------------------ ►►►LINKS◄◄◄ Blog: http://bit.ly/expdp-parfile-table-mode-export Previous Tutorial Tut 52 Expdp Full Database http://youtu.be/K8_PjUksT54 Tut 53 Expdp Tablespace http://youtu.be/-hXBZd-FCjs Tut 54 Expdp Schema http://youtu.be/t8TSLDGN5gg ------------------------------------------------------------------------- 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: 27062 Manish Sharma
RMAN ORACLE database  Online Full Backup
 
11:03
ORACLE Online Full Backup ORACLE Online FULL DB Backup RMAN BAckup script ======================================== RUN { ALLOCATE CHANNEL MY_RMAN1 TYPE disk; ALLOCATE CHANNEL MY_RMAN2 TYPE disk; SETLIMIT CHANNEL MY_RMAN1 KBYTES 33554432; SETLIMIT CHANNEL MY_RMAN2 KBYTES 33554432; CONFIGURE RETENTION POLICY TO NONE; CONFIGURE CONTROLFILE AUTOBACKUP ON; BACKUP INCREMENTAL LEVEL 0 TAG weekly_testdb_full_tag_08272017 FORMAT '/home/oracle/backup/full_db_bkup_%d_%U_%t_%T' DATABASE; RELEASE CHANNEL MY_RMAN1; RELEASE CHANNEL MY_RMAN2; } To check RMAN Backup ============================ 1)list backup 2)list backup summary 3)list backup of database; RMAN Backuo Format specifier reference link ============================= https://docs.oracle.com/html/E10643_07/rcmsubcl010.htm Please like,subscribe my channel for next video. KIndly note my no or email ID for online training. Email: [email protected] Mob No: +91 9960262955 ========================================== Hi Folks, Greetings!! I am professional part time oracle dba trainer and having good experience in oracle database administration. This is the right place to enroll yourself for Oracle DBA real time course. Please use following email ID for more details. Don’t hesitate to WhatsApp me any time. I will give you the best training and will create path to get DBA job easily. Enjoy the free YouTube video and connect with me for deep Oracle DBA knowledge. Mobile No : + 91 9960262955 (WhatsApp Number) EmailID: [email protected] Please visit my official website for oracle database training and hadoop blog. https://www.orcldata.com/ Please donate on below link if you think I am helping you with your career. https://www.paypal.me/ankushthavali OR Google Pay : 9960262955 OR Account No : 31347845762 IFSC: SBIN0012311 how to restore incremental level 1 backup rman how to take rman backup in oracle 11g step by step rman backup commands rman incremental backup script rman backup types rman backup script how to take backup of oracle 11g database step by step backup incremental level 0 database plus archivelog
Views: 667 ANKUSH THAVALI
Oracle 12c sysbackup privilege
 
05:09
This video explains the new 'sysdba' privilege introduced in Oracle 12c
Views: 301 Wysheid Wysheid
Oracle Administraton 07 =  Managing Roles in Oracle (CONCEPT)
 
10:52
How to Create a User and Grant Permissions in Oracle CREATE USER books_admin IDENTIFIED BY MyPassword; GRANT CONNECT TO books_admin; GRANT CONNECT, RESOURCE, DBA TO books_admin; GRANT CREATE SESSION GRANT ANY PRIVILEGE TO books_admin; GRANT UNLIMITED TABLESPACE TO books_admin; GRANT SELECT, INSERT, UPDATE, DELETE ON schema.books TO books_admin; how to create user in oracle 10g create user in oracle 12c oracle create user schema oracle grant all privileges to user how to create user in oracle 10g express edition create user in oracle sql developer grant schema access to user in oracle grant create table to user
Oracle DB 12c - Managing Privileges in CDB & PDB
 
10:37
Oracle DB 12c - Managing Privileges in CDB & PDB Watch more videos at https://www.tutorialspoint.com/videotutorials/index.htm Lecture By: Mr. Parth Panjabi, Tutorials Point India Private Limited

Here!
What does amp mean on dating sites
Bombero atomico online dating
Here!
Best bay area online dating