Home
Search results “Alter pluggable database oracle”
How to Start,Stop Pluggable database-Oracle 12C administration
 
09:32
How to Start,Stop Pluggable database-Oracle 12C administration =================================================== Important Command SQL= show con_name; CON_NAME ------------------------------ CDB$ROOT SQL-- sho pdbs; CON_ID CON_NAME OPEN MODE RESTRICTED ---------- ------------------------------ ---------- ---------- 3 PDB MOUNTED SQL alter session set container=PDB;
Views: 4581 ANKUSH THAVALI
How to Rename/Change PDB database name-Oracle 12C Administration
 
09:15
How to Rename/Change PDB database name-Oracle 12C Administration ============================================ 1. Shutdown the pluggable database (PDB). sqlplus '/ as sysdba' SQL- shutdown pluggable database myplugdb3 close immediate; 2. Startup the PDB in restricted mode sqlplus '/ as sysdba' SQL- alter pluggable database myplugdb3 open restricted; 3. Rename the PDBs sqlplus '/ as sysdba' SQL- connect myplugdb3 as sysdba SQL- alter pluggable database myplugdb3 rename global_name to myplugdb3_new; 4. Restart the PDB sqlplus '/ as sysbda' SQL- alter pluggable database close immediate; SQL- alter pluggable database open; =============================================== 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]
Views: 386 ANKUSH THAVALI
Oracle Database 12c: Introduction to a Multitenant Environment with Tom Kyte
 
10:47
Tom Kyte introduces Oracle Multitenant in Oracle Database 12c followed by a demo showing: multitenant architecture, moving a pluggable database (PDB) from one multitenant container database (CDB) to another, cloning a PDB, and creating a new PDB. For more information: "Multitenant Architecture" in Oracle® Database Concepts http://www.oracle.com/pls/topic/lookup?ctx=db121&id=CNCPT89233 "Managing a Multitenant Environment" in Oracle® Database Administrator's Guide http://www.oracle.com/pls/topic/lookup?ctx=db121&id=ADMIN13506 "About Common Users and Local Users" in Oracle® Database Security Guide http://www.oracle.com/pls/topic/lookup?ctx=db121&id=DBSEG573
Views: 79171 OracleDBVision
Migration of  Non-Container Database to Pluggable-PART II- Oracle 12C Administration
 
37:16
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; ==================================== 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]
Views: 630 ANKUSH THAVALI
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
Multitenant : Manage Tablespaces in a Container Database (CDB) and Pluggable Database (PDB)
 
02:39
This video demonstrates how to manage tablespace in a Container Database (CDB) and Pluggable Database (PDB) in Oracle Database 12c. For more information see: https://oracle-base.com/articles/12c/multitenant-manage-tablespaces-in-a-cdb-and-pdb-12cr1 Website: https://oracle-base.com Blog: https://oracle-base.com/blog Twitter: https://twitter.com/oraclebase Cameo by the Dbvisit gang : Website: http://www.dbvisit.com/ Twitter: https://twitter.com/dbvisit Cameo appearances are for fun, not an endorsement of the content of this video. All trademarks, product names and logos are the property of their respective owners.
Views: 2646 ORACLE-BASE.com
HOW TO INCREASE DECREASE MEMORY TARGET IN ORACLE 11G
 
04:55
How to increase/decrease memory_target in 11g ====================================================== oracle 10g --sga_target (parameter new in 10g) oracle 11g --memory_target (parameter new in 11g) How to check whether the parameter is static or dynamic? ========================================================= select name, value, issys_modifiable from v$parameter where name like '%&parameter%' ; if issys_modifiable=false --- parameter is static (database bounce required) if issys_modifiable=immediate --- parameter is dynamic (database bounce not required) (note: consider using spfile) sql commands ================ show parameter memory; alter system set memory_target=350m scope=spfile; alter system set memory_max_target=350m scope=spfile;
Views: 4536 Praveen Biyyapu
Oracle DB 12c - Instance Parameter Change Impact
 
09:41
Oracle DB 12c - Instance Parameter Change Impact Watch more videos at https://www.tutorialspoint.com/videotutorials/index.htm Lecture By: Mr. Parth Panjabi, Tutorials Point India Private Limited
Connect to Oracle 12c DB in the same machine with Oracle express and E business suit
 
08:06
in this video you will see how to connect to Oracle 12c users like sys and hr ... in the same machine with oracle express (Oracle apex) and oracle e business suite (Oracle Apps) ... by sql plus , sql developer and toad ..... and you can use this way to add any other database you need and this is what I did in the video =================================== 1- The go to the file tnsnames in the path (D:\app\gaid2\product\12.1.0\dbhome_1\NETWORK\ADMIN) And this part (D:\app\gaid2) different from your one this is which you put you database in while installation 2- Open this file you will find this code ORCL = (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1522)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = orcl) ) ) 3- Copy this and past it blew but make a little change like this PDBORCL = (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1522)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = pdborcl) ) ) 4- Then save and take this 2 blocks of code copy and go to this file tnsnames in the path in the partition where you installed your oracle express DB Which in my case (C:\oraclexe\app\oracle\product\11.2.0\server\network\ADMIN) 5- Open this file and past the 2 blocks of code 6- Then save 7- Then Open sql plus from start menu 8- Write username : sys as sysdba 9- The write the password which you entered while installation of Oracle 12c DB 10- The write ALTER SESSION SET CONTAINER = PDBORCL; Then enter 11- Then write SHOW CON_NAME; Then enter You will find that the con_name became pdborcl 12- Then run this statement to see if the status of pdborcl open or not SELECT NAME , OPEN_MODE FROM V$PDBS; If it in MOUNTED status then we need to open it by this statement ALTER PLUGGABLE DATABASE OPEN 13- Then we need to unlock user hr by one of this statements ALTER USER HR INDENTIFIED BY HR ACCOUNT UNLOCK; ALTER USER HR ACCOUNT UNLOCK; 14- Then go to toad and sql developer to check like I do. Thanks Ahmed Gaid Please subscribe :)
Views: 13 ahmed gaid
how to configure and connect oracle 12c database for the first time
 
06:31
how to configure and connect oracle 12c database for the first time, add pluggable database services in tnsname.ora file, connect sys as sysdba, alter session set container = pdborcl, startup open; alter user name_of_user identified by password account unlock;
Views: 3256 Data Science Center
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: 40717 Abbasi Asif
Alert log file in Oracle
 
07:34
Check Alert File Location in Oracle ================================================= DB is upp & Running ================== show parameter dump; select value from v$parameter where name='background_dump_dest'; DB is Down ===================================== find / -name alert_newdb.log 2 )/dev/null
Views: 2535 ANKUSH THAVALI
how to start and stop oracle database
 
05:17
startup and shutdown modes of oracle database startup - it will startup database to read write mode. shutdown - normal shutdown. startup mount; -- maintenace mode. startup nomount; - it reads the pfile. alter database mount; - maintenance mode. alter database open; - it opens the database to read write mode. shutdown ========== alter database close; alter database dismount; shutdown; startup force; - it will shutdown and restart database (note: not recommende :)) it is like restart option in windows o/s select name,open_mode from v$database;
Views: 3734 Praveen Biyyapu
Oracle DB 12c - Flashback CDB
 
04:38
Oracle DB 12c - Flashback CDB Watch more videos at https://www.tutorialspoint.com/videotutorials/index.htm Lecture By: Mr. Parth Panjabi, Tutorials Point India Private Limited
Solving ORA-01033 oracle initialization or shutdown in progress 12c
 
01:26
Solving ORA-01033 oracle initialization or shutdown in progress 12c select name, open_mode from v$pdbs; Solution 1 Alter pluggable database pdborcl open Solution 2 create or replace TRIGGER pdb_startup AFTER STARTUP ON DATABASE BEGIN EXECUTE IMMEDIATE 'alter pluggable database pdborcl open'; END;
Views: 9489 khaled alkhudari
Oracle Database 12c: Partitioning Improvements with Tom Kyte
 
08:08
Tom Kyte introduces the new partitioning improvements in Oracle Database 12c, followed by a demo of global index maintenance. For more information: "Asynchronous Global Index Maintenance for Dropping and Truncating Partitions" http://www.oracle.com/pls/topic/lookup?ctx=db121&id=VLDBG14107 "Changes for Very Large Databases and Partitioning in Oracle Database 12c Release 1" http://www.oracle.com/pls/topic/lookup?ctx=db121&id=VLDBG14100 "ALTER INDEX COALESCE Clause" http://www.oracle.com/pls/topic/lookup?ctx=db121&id=SQLRF52782 "DBMS_PART.CLEANUP_GIDX Procedure" http://www.oracle.com/pls/topic/lookup?ctx=db121&id=ARPLS74409
Views: 12732 OracleDBVision
Oracle Database 12c: Recovering a Pluggable Database
 
06:38
How to recover a pluggable database in an Oracle 12c multitenant environment.
Views: 5638 OracleDBVision
How to create an user and to grant all privileges to them in Oracle database
 
03:52
This video shows you how to create a new user and to grant privileges to them. Syntax to create a new user: create user username identified by password
Views: 33727 Thamizh arasaN
Instalacion Oracle 12C OLTP
 
42:03
Comandos a usar: sys / as sysdba select name, open_mode from v$pdbs; shutdown immediate; startup; alter session set container=pdborcl; alter pluggable database all open read write force; shutdown immediate; startup; select name, open_mode from v$pdbs; exec dbms_xdb_config.sethttpsport(5501);
Views: 145 ElectivaBI UTEC
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: 36414 OracleDBVision
Error  01033 Oracle Ora-01033 Base de Datos 12c Solucionado
 
04:07
Abrir SQL plus, instrodocir como usuario: /as sysdba despues de estar conectado introducir el siguiente comando " alter pluggable database pdborcl open; " Donde "pdborcl" es el Nombre de Base de Datos de Conexión: pdborcl esto si lo has cambiado, lo tienes que ver en la configuracion usando la herramienta Asistente de configuración de Base de Datos gracias, espero que les haya servido Un saludo
Views: 5289 vaquerito25
How To Connect PDB/CDB to Enterprise Manager Express 12c and SQL Developer.
 
11:35
Step By Step Guide On how to do the following: * How to connect Pluggable Database To Oracle Database 12c and unlock sample schemas * How to connect Pluggable and Container Database to Enterprise Manager Express 12c (OEM) *How to connect Container and Pluggable Database to SQL Developer Article to this video can be found on my blog https://reginankemchor.blogspot.com/2016/08/pluggable-database-and-enterprise.html
Views: 6583 regina nkemchor
How to change SYS/SYSTEM password in 12C-Oracle 12C Administration
 
05:13
How to change SYS/SYSTEM password in 12C-Oracle 12C Administration =================================================== [email protected]= alter session set container=CDB$ROOT; Session altered. [email protected]=show con_id CON_ID ------------------------------ 1 [email protected]= alter user SYSTEM identified by oracle container=all; User altered. [email protected]= alter session set container=pdb1; Session altered. [email protected]= show con_id CON_ID ------------------------------ 3 ============================================= 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]
Views: 2980 ANKUSH THAVALI
Oracle Database Profiles
 
02:09
Senior instructor Darryl Balaski shows you how to set up and use Oracle Database profiles to grant and limit access to database usage and instance resources for various users.
Tablespaces in oracle database
 
08:27
This video will give you basic idea about tablespace issue. Plese find the following important query . Query to check tablespace usage ============================================== select a.TABLESPACE_NAME, a.BYTES bytes_used, b.BYTES bytes_free, b.largest, round(((a.BYTES-b.BYTES)/a.BYTES)*100,2) percent_used from ( select TABLESPACE_NAME, sum(BYTES) BYTES from dba_data_files group by TABLESPACE_NAME ) a, ( select TABLESPACE_NAME, sum(BYTES) BYTES , max(BYTES) largest from dba_free_space group by TABLESPACE_NAME ) b where a.TABLESPACE_NAME=b.TABLESPACE_NAME order by ((a.BYTES-b.BYTES)/a.BYTES) desc; To check datafiles respective to tablespace_name. ======================================================== col tablespace_name format a30; col file_name format a40; SELECT TABLESPACE_NAME, FILE_NAME, BYTES/1024/1024 FROM DBA_DATA_FILES where TABLESPACE_NAME='&tablespace_name'; To check ASM disk group usage ======================================== select name, group_number, name, type, state, total_mb, free_mb from v$asm_diskgroup; Please comment , like, subscribe and reach me if you have any query. EmailId: [email protected] ================================================ 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]
Views: 664 ANKUSH THAVALI
Oracle Database 12c: Improved Defaults
 
05:59
Tom Kyte and Chuck Murray describe several improvements to default behavior in Oracle Database 12c: defaults based on sequences, default on NULL, Identity type columns, and metadata-only defaults. For more information: "CREATE TABLE" statement in Oracle® Database SQL Language Reference http://www.oracle.com/pls/topic/lookup?ctx=db121&id=SQLRF01402 "ALTER TABLE" statement in Oracle® Database SQL Language Reference http://www.oracle.com/pls/topic/lookup?ctx=db121&id=SQLRF01001 "Identity Columns" in Oracle® Database Migration Guide http://www.oracle.com/pls/topic/lookup?ctx=db121&id=DRDAA109
Views: 2071 OracleDBVision
Oracle Database 12c: Unplugging an existing PDB and plugging it into another container
 
11:42
This video is about How to create a pluggable database by unplugging an existing PDB and plugging it into another container
Views: 577 mvige
Oracle Database 12c Tutorial 3:Connect HR/SYS user with SQL Developer in Oracle12c Using TNS Service
 
05:24
Learn how to connect HR and Sys User of Oracle database 12c With SQL Developer using TNS service. Connect HR user which is in pluggable database to SQL Developer ------------------------------------------------------------------------ ►►►LINKS◄◄◄ Blog : 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: 50974 Manish Sharma
Oracle Tutorial || Oracle|Sql commands DDL Commands Part - 1 by basha
 
33:30
DURGASOFT is INDIA's No.1 Software Training Center offers online training on various technologies like JAVA, .NET , ANDROID,HADOOP,TESTING TOOLS ,ADF,INFORMATICA,TABLEAU,IPHONE,OBIEE,ANJULAR JS, SAP... courses from Hyderabad & Bangalore -India with Real Time Experts. Mail us your requirements to [email protected] so that our Supporting Team will arrange Demo Sessions. Ph:Call +91-8885252627,+91-7207212428,+91-7207212427,+91-8096969696. http://durgasoft.com http://durgasoftonlinetraining.com https://www.facebook.com/durgasoftware http://durgajobs.com https://www.facebook.com/durgajobsinfo......
How to change Archive Destination in Oracle
 
05:40
How to change Archive Destination in Oracle ======================================== Syantax ============= alter system set log_archive_dest_1='LOCATION=/home/Archive/' scope=both; =============================================== 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]
Views: 805 ANKUSH THAVALI
How to create profile and alter profile in oracle database in 11g,12c.DBA Tutorials.
 
11:59
I want to show in this tutorial, What is Oracle Profile,Benefits of Profile,CREATE PROFILE,Alter Profile and how to assign users on Profile.
Views: 1490 Sayif Uddin
TABLESPACE MANAGEMENT CREATE TABLESPACE ALTER DATAFILE
 
03:34
How to check existing tablespace information in database ========================================================= select tablespace_name from dba_tablespaces; How to create a tablespace =============================== create tablespace king datafile 'E:\DATABASE\DATABASE\ORADATA\ORCL\KING01.DBF' size 10m; How to Resize the datafile ========================== alter database datafile 'E:\DATABASE\DATABASE\ORADATA\ORCL\KING01.DBF' resize 20m; Adding a datafile to a tablespace ================================= alter tablespace king add datafile 'E:\DATABASE\DATABASE\ORADATA\ORCL\KING02.DBF' size 10m; How to get the defintion of tablespace ====================================== set head off echo off select 'select dbms_metadata.get_ddl(''TABLESPACE'',''' || tablespace_name || ''') from dual;' from dba_tablespaces;
Views: 794 Praveen Biyyapu
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: 51486 Manish Sharma
Oracle Database 12c R2 - SQL*Plus History Command
 
03:41
Oracle Database 12c Release 2 New Features for DBAs and Developers
Views: 421 Mahir M. Quluzade
Oracle 12c Release 2 - How to move a heap table online
 
01:43
Need to reorganize a table ? Want to do it whenever you want without impacting any users ? Easy in 12.2 ========================================­­­­============== 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.
Views: 410 Connor McDonald
How to unlock HR sample user in Oracle Database 18c by Manish Sharma
 
14:03
RebellionRider.com presents how to unlock sample schema/user in Oracle Database 18c by Manish Sharma. Timestamps ( 01:12 ) Step 1: Find out the container ID ( 02:10 ) How do we get to know whether we are connected to a CDB or PDB ( 04:41 ) Step 2: Find out the service name ( 05:49 ) Step 3: Create an entry in TNSNAMES.ORA ( 09:13 ) Step 4: Switch from Container DB to Pluggable DB ( 11:04 ) Step 5: Unlock the HR user ------------------------------------------------------------------------ ►►►LINKS◄◄◄ Blog: http://bit.ly/unlock-schema-in-18c Previous Tutorial ► How to Install Oracle 18c on Windows https://youtu.be/kptbJ22kfqA ►TNSNAMES.Ora file at GIT https://github.com/RebellionRider/Oracl18c/blob/master/tnsnames.ora ------------------------------------------------------------------------- ►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
Views: 1196 Manish Sharma
oracle user management | User creation and privilege management | password management in oracle
 
01:04:13
This video is part of "Oracle Database Administration Made Simple" series. The following topics are covered -- user creation -- Default tablespace for user -- Granting and revoking privileges -- understanding sysdba privilege
Views: 15117 Wysheid Wysheid
How to change Database name using control file backup
 
16:31
Hello guys today i am going to explaining to you how to change your database name using Trace control file backup. #changeDatabasename #usingcontrolfilebackup Oracle database Unbeatable,Unbreakable Platform..
Views: 2198 Oracle World
How to Move a Datafile in Oracle Database - Part 1
 
01:32
Dozens of free Oracle tutorials at http://skillbuilders.com/free-oracle-tutorials. See Part 2 (the demonstration) of this tutorial at http://skillbuilders.com/How-to-Move-Datafiles-Oracle-12c. How do you move a datafile in an Oracle Database? Well, it just got a lot easier in 12c! Watch this free video tutorial - OCM John Watson of SkillBuilders will demonstrate both techniques, 11g and 12c. There are many reasons to move a datafile in an Oracle database. Here are just a few: Renaming datafiles to a standard Moving from one file system to another Converting from file system storage to ASM Changing from SAN to NFS storage In 11g, we need to take the tablespace offline, meaning downtime. Argh! In 12c, all that is required is ALTER DATABASE MOVE DATAFILE; this is an online operation with zero downtime. Even "critical" files such as the files associated with the SYSTEM tablespace can be moved online. Consider the ease of migrating to ASM this provides! This also functions in an Active Data Guard standby environment. And, there are syntax options that allow you to keep or delete the original file. Very cool stuff.
Views: 2426 SkillBuilders
How to Add & Drop Datafile in Tablespace. ( Tablespace Management #2 )
 
06:46
Hello Friend In this video I am showing you 1. How to add datafile. 2. How to drop Datafile. 3. How to alter Tablespace. 4. How to check Datafile Location. 5. How to check free space in tablespace.
Views: 164 Parag Mahalle
Change Oracle Parameters   SPFILE
 
02:33
TADM51 - SAP Netweaver as DB Operations - Change Oracle Parameter - Create the SPFILE
Views: 1080 Mohamed Iliyas
Managing Database Structure -Tablespaces and Datafiles part 2nd
 
13:18
Hi friends in this video i am going to explain you how to create alter tablespace and datafile in oracle. Oracle database Unbeatable,Unbreakable Platform..
Views: 1661 Oracle World
Ask Tom Office Hours: Database Security - Key Features
 
46:06
Held on March 8 2018 The database is at the heart of every application; it is critical to every enterprise that their data be secure. In this session, Russ Lowenthal , Director of Product Management for Oracle Security Products, reviews critical features in Oracle Database 12c (12.2 = 18c) and answers questions about Audit Vault, Key Vault, Row Level Security, Security Assessment Tool, Wallets and Native Network Encryption. AskTOM Office Hours offers free, monthly training and tips on how to make the most of Oracle Database, from Oracle product managers, developers and evangelists. https://asktom.oracle.com/ Oracle Developers portal: https://developer.oracle.com/ Sign up for an Oracle Cloud trial: https://cloud.oracle.com/en_US/tryit music: bensound.com
Views: 182 Oracle Developers
How to convert Physical  Standby database to Snapshot Standby Database-DataGuard
 
07:05
Check DB Status =========================================== select status,instance_name,database_role,open_mode from v$database,v$Instance; Check Flashback status =================================== select flashback_on from v$database; Status of MRP Process ----------------------------- set lines 1234 pages 1234; select process,status,client_process,thread#,sequence#,block#,blocks,delay_mins from v$managed_standby; Cancel the MRP ================================ alter database recover managed standby database cancel; Convert to Snapshot Standby ========================================== alter database convert to snapshot standby; Open the database =========================== alter database open; ============================================== 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]
Views: 268 ANKUSH THAVALI
Oracle SQL PLSQL 12C Tutorial 15   ALTER Statement
 
08:54
This Video Tutorial Will Describe how to change the structure of an existing table. This command will also work on other versions of database like Oracle 11g Database, Oracle 10g Database, Oracle 9i Database, Oracle 8i Database, Oracle 8 Database and so on. This command is used to add, modify or delete the columns from the table. You can add, modify or delete a single column or multiple columns at a time. Full Syntax will be given in this video tutorial about how to use the ALTER table command. Along with the live example to add, modify or delete the columns from the table. All the keywords, format, mandatory clauses etc are described in this video.
Views: 39 game hounds
Security of Users in Oracle to assign Profiles
 
23:18
Hello friends today i will explain to you a brief #SecurityofUsers #OracleProfiles introduction of Users and Profile monitoring to get more security. Oracle database Unbeatable,Unbreakable Platform..
Views: 6464 Oracle World
How to Detect Soft Corruption in Oracle 12c Database
 
18:19
Detection of Soft Corruption in 12c: To use the scripts below replace : , ",# and $ by proper bracket Lets Create a tablespace and small table. SQL: create tablespace DEMO1 datafile '/u02/tstdb1/TSTDB1/datafile/demo01.dbf' size 50M SQL: create table objects tablespace DEMO1 as select * from dba_objects; SQL: alter table objects add constraint pk_obj primary key #object_id$; SQL: create index idx_obj_name on objects#object_name$ tablespace demo1; Backup tablespace. RMAN: backup tablespace DEMO1; We need to put the DB in archivelog first Rebuild index with NOLOGGING option to simulate soft corruption later. RMAN: alter index idx_obj_name rebuild nologging; Confirm that we have datafiles that require backup because they have been affected with NOLOGGING operation. RMAN: report unrecoverable; Simulate corruption. RMAN: alter database datafile 5 offline; RMAN: restore datafile 5; RMAN: recover datafile 5; RMAN: alter database datafile 5 online; Query table with corrupted index and notice error. SQL: select count#*$ from objects where object_name like 'A%'; Let’s perform validation of datafile to check block corruption. RMAN: backup validate check logical datafile 5; Notice that we have 457 blocks marked corrupt but v$database_block_corruption view is empty. SQL: select count#*$ from v$database_block_corruption; Let’s query v$nonlogged_block view. set lines 200 set pages 999 select file#, block#, blocks,object#,reason from v$nonlogged_block; Will RMAN detect that we have corrupted blocks? RMAN: backup datafile 5; RMAN backup won’t fail due to NOLOGGING corrupt blocks and our backup will contain soft corrupted blocks. Let’s Identify corrupt segments using v$nonlogged_block view. set lines 2000 set pages 9999 col owner for a20 col partition_name for a10 col segment_name for a20 SELECT e.owner, e.segment_type, e.segment_name, e.partition_name, c.file# , greatest#e.block_id, c.block#$ corr_start_block# , least#e.block_id+e.blocks-1, c.block#+c.blocks-1$ corr_end_block# , least#e.block_id+e.blocks-1, c.block#+c.blocks-1$ - greatest#e.block_id, c.block#$ + 1 blocks_corrupted FROM dba_extents e, V$NONLOGGED_BLOCK c WHERE e.file_id = c.file# AND e.block_id "= c.block# + c.blocks - 1 AND e.block_id + e.blocks - 1 := c.block# UNION SELECT s.owner, s.segment_type, s.segment_name, s.partition_name, c.file# , header_block corr_start_block# , header_block corr_end_block# , 1 blocks_corrupted FROM dba_segments s, V$NONLOGGED_BLOCK c WHERE s.header_file = c.file# AND s.header_block between c.block# and c.block# + c.blocks - 1 UNION SELECT null owner, null segment_type, null segment_name, null partition_name, c.file# , greatest#f.block_id, c.block#$ corr_start_block# , least#f.block_id+f.blocks-1, c.block#+c.blocks-1$ corr_end_block# , least#f.block_id+f.blocks-1, c.block#+c.blocks-1$ - greatest#f.block_id, c.block#$ + 1 blocks_corrupted FROM dba_free_space f, V$NONLOGGED_BLOCK c WHERE f.file_id = c.file# AND f.block_id "= c.block# + c.blocks - 1 AND f.block_id + f.blocks - 1 := c.block# order by file#, corr_start_block# / This is the best outcome to get if you notice corruption errors. All errors are related to index corruption so we could fix this problem rebuilding index. alter index idx_obj_name rebuild; Simply issuing "alter index rebuild" command won't work. We should mark index unusable to drop segment before rebuilding it or just rebuild index with online option. It is better choice to mark index unusable because you don't need additional space then, but I will simply rebuild index with online option and see what will happen. SQL: alter index idx_obj_name rebuild online; Index altered. SQL: select count#*$ from objects where object_name like 'A%'; No errors... but, let's validate datafile for corruption. RMAN: backup validate check logical datafile 5; Notice "Marked Corrupt" column. Hm... 457 like before. Don't worry, this is not new corruption. These are FREE blocks which will be reused and Oracle will automatically re-format those blocks. Query the v$nonlogged_block view again as given above. We could force re-formatting creating dummy table and inserting data to dummy table. Check Doc ID 336133.1. create table s # n number, c varchar2#4000$ $ nologging tablespace DEMO1; SQL: BEGIN FOR i IN 1..1000000 LOOP INSERT /*+ APPEND */ INTO sys.s select i, lpad#'REFORMAT',3092, 'R'$ from dual; commit ; END LOOP; END; / SQL: drop table sys.s purge; Notice that we don't have corrupted blocks any more. RMAN: backup validate check logical datafile 5;
Views: 130 OracleDBA
Oracle Row Level Triggers follows clause Session 8
 
05:13
Oracle SQL PLSQL and Unix Shell Scripting
Views: 342 Sridhar Raghavan
Learn Oracle | What is Oracle | Why do we need Oracle
 
03:16
Pebbles present, Learn Oracle 10g with Step By Step Video Tutorials. Learn Oracle 10g Tutorial series contains the following videos : Learn Oracle - History of Oracle Learn Oracle - What is Oracle - Why do we need Oracle Learn Oracle - What is a Database Learn Oracle - What is Grid Computing Learn Oracle - What is Normalization Learn Oracle - What is ORDBMS Learn Oracle - What is RDBMS Learn Oracle - Alias Names, Concatenation, Distinct Keyword Learn Oracle - Controlling and Managing User Access (Data Control Language) Learn Oracle - Introduction to SQL Learn Oracle - Oracle 10g New Data Types Learn Oracle - How to Alter a Table using SQL Learn Oracle - How to Create a Package in PL SQL Learn Oracle - How to Create a Report in SQL Plus Learn Oracle - How to Create a Table using SQL - Not Null, Unique Key, Primary Key Learn Oracle - How to Create a Table using SQL Learn Oracle - How to Create a Trigger in PL SQL Learn Oracle - How to Delete Data from a Table using SQL Learn Oracle - How to Drop and Truncate a Table using SQL Learn Oracle - How to Insert Data in a Table using SQL Learn Oracle - How to open ISQL Plus for the first time Learn Oracle - How to Open SQL Plus for the First Time Learn Oracle - How to Update a Table using SQL Learn Oracle - How to use Aggregate Functions in SQL Learn Oracle - How to use Functions in PL SQL Learn Oracle - How to use Group By, Having Clause in SQL Learn Oracle - How to Use Joins, Cross Join, Cartesian Product in SQL Learn Oracle - How to use Outer Joins (Left, Right, Full) in SQL Learn Oracle - How to use the Character Functions, Date Functions in SQL Learn Oracle - How to use the Merge Statement in SQL Learn Oracle - How to use the ORDER BY Clause with the Select Statement Learn Oracle - How to use the SELECT Statement Learn Oracle - How to use the Transactional Control Statements in SQL Learn Oracle - How to use PL SQL Learn Oracle - Data Types in PL SQL Learn Oracle - Exception Handling in PL SQL Learn Oracle - PL SQL Conditional Logics Learn Oracle - PL SQL Cursor Types - Explicit Cursor, Implicit Cursor Learn Oracle - PL SQL Loops Learn Oracle - Procedure Creation in PL SQL Learn Oracle - Select Statement with WHERE Cause Learn Oracle - SQL Operators and their Precedence Learn Oracle - Using Case Function, Decode Function in SQL Learn Oracle - Using Logical Operators in the WHERE Clause of the Select Statement Learn Oracle - Using Rollup Function, Cube Function Learn Oracle - Using Set Operators in SQL Learn Oracle - What are the Different SQL Data Types Learn Oracle - What are the different types of Databases Visit Pebbles Official Website - http://www.pebbles.in Subscribe to our Channel – https://www.youtube.com/channel/UCNNjWVsQqaMYccY044vtHJw?sub_confirmation=1 Engage with us on Facebook at https://www.facebook.com/PebblesChennai Please Like, Share, Comment & Subscribe
Views: 8096 Pebbles Tutorials

What is a cover letter supposed to say
Custom papers writing service
Creating a cover letter for a resume
Cover letter for demotion
Free downloadable cover letter template