Home
Videos uploaded by user “ANKUSH THAVALI”
How to Start,Stop Pluggable database-Oracle 12C administration
 
09:32
anagmeHow 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: 7213 ANKUSH THAVALI
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: 4134 ANKUSH THAVALI
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: 1273 ANKUSH THAVALI
Calling Sqlplus using shell script and saving the sqlplus output in Logfile
 
07:25
My channel is mainly helpful for those who are looking to start their career in Oracle DBA | oracle databases administration technology. Channel will provide you in depth understanding for all oracle database concept.You will find the YouTube channel helpful for cracking oracle database administration interview. The explanation is clear and practically represented. Please reach me vie email [email protected] if you are looking for online training. https://www.orcldata.com Email: [email protected] Mob No: +91 9960262955 Please use the following link to get unlimited videos. https://www.skillshare.com/r/profile/Ankush-Thavali/5208062 Below is the coupon code for skillshares. https://www.udemy.com/draft/1412310/?couponCode=DBSHOT 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 run sql file in unix prompt how to run sql script from a unix shell calling sql file from shell script with parameters calling sqlplus from unix shell script shell script to run multiple .sql files spool sql query output to file in unix how to execute mysql query in shell script how to run sql file in putty Calling Sqlplus and saving the sqlplus output in Logfile
Views: 1765 ANKUSH THAVALI
How to Start Physical Standby database & Check if Database is in Sync
 
06:32
How to Start Physical Standby database & Check if Database is in Sync Dataguard Status ==================================================== Start Standby Database =============================== startup nomount alter database mount standby database; alter database recover managed standby database disconnect from session; DB STATUS ======================= select status,instance_name,database_role,protection_mode from v$database,v$instance; TO check if dataguard in synchronizing with standby. ============================================================================= select thread#,max(sequence#) from v$archived_log where applied='YES' group by thread#; Status of MRP Process --------------------------- select process,status,client_process,thread#,sequence#,block#,blocks,delay_mins from v$managed_standby; To get the diffrence between Recived and applied logs. ------------------------------------------------------- select MAX_RECEIVED,MAX_APPLIED,(MAX_RECEIVED - MAX_APPLIED) as "Difference" from (SELECT ARCHIVED_THREAD#, MAX(ARCHIVED_SEQ#) as MAX_RECEIVED, APPLIED_THREAD#, MAX(APPLIED_SEQ#) as MAX_APPLIED FROM V$ARCHIVE_DEST_STATUS) ARCH ; ================================================= 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 check data guard status oracle how to check lag in data guard how to sync primary and standby database in oracle how to check archive log gap standby database how to check if archive logs are applied to standby database query to check archive log gap how to check if database has standby how to check standby database name from primary
Views: 1701 ANKUSH THAVALI
Basic Unix Commmand for Oracle DBA
 
11:11
I have mentioned some basic unix command which are very useful in daily DBA life. Please go through it and let me know if you have any queries. Kindly like,subscribe to my channel. you can contact me if you are interested in training. Emal: [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: 7390 ANKUSH THAVALI
Career switch from Oracle  DBA to Hadoop
 
11:07
oracle dba to data engineer Oracle DBA to Hadoop Developer If you think I am helping you guys for career growth then you can help me by donating from following URL. https://www.orcldata.com/blog (Donate button available)
Views: 1206 ANKUSH THAVALI
Recover Missing Control file
 
10:01
Recover Missing Control file ========================================= 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: 1639 ANKUSH THAVALI
Connect SqlDeveloper with Oracle 18C
 
08:36
My channel is mainly helpful for those who are looking to start their career in Oracle DBA | oracle databases administration technology. Channel will provide you in depth understanding for all oracle database concept.You will find the YouTube channel helpful for cracking oracle database administration interview. The explanation is clear and practically represented. Please reach me vie email [email protected] if you are looking for online training. https://www.orcldata.com Email: [email protected] Mob No: +91 9960262955 Please use the following link to get unlimited videos. https://www.skillshare.com/r/profile/Ankush-Thavali/5208062 Below is the coupon code for skillshares. https://www.udemy.com/draft/1412310/?couponCode=DBSHOT 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 connect to oracle database using sql developer how to create a new connection in oracle sql developer how to create a new database in oracle sql developer oracle sql developer ssl connection network adapter could not establish the connection in sql developer oracle sql developer connection file oracle sql developer jdbc connection url how to create table in oracle sql developer #oracle #sqldeveloper #oracle18c
Views: 2362 ANKUSH THAVALI
Import XSLX/CSV File To PostgreSQL database
 
11:29
important Command COPY PUBLIC.DEPARTMENT FROM 'CSV FILE PATH' WITH CSV HEADER; ========================= 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: 2163 ANKUSH THAVALI
Shell Scripting for Oracle DBA
 
04:58
Oracle DBA Blog URL ================== https://www.orcldata.com/blog/shell-scripting-for-oracle-dba My channel is mainly helpful for those who are looking to start their career in Oracle DBA | oracle databases administration technology. Channel will provide you in depth understanding for all oracle database concept.You will find the YouTube channel helpful for cracking oracle database administration interview. The explanation is clear and practically represented. Please reach me vie email [email protected] if you are looking for online training. https://www.orcldata.com Email: [email protected] Mob No: +91 9960262955 Please use the following link to get unlimited videos. https://www.skillshare.com/r/profile/Ankush-Thavali/5208062 Below is the coupon code for skillshares. https://www.udemy.com/draft/1412310/?couponCode=DBSHOT 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 useful shell scripts for oracle dba shell scripting for oracle dba pdf oracle shell scripting tutorial shell script to connect to oracle database and run query oracle database monitoring shell scripts shell script for oracle database health check shell script to check oracle database status shell script to connect to oracle database in linux
Views: 1155 ANKUSH THAVALI
Difference between Internal and External table in Hive - Interview question
 
15:00
Hive ============== 1)Managed Tables/Internal table 2)External tables 1)Managed Tables/Internal table Syntax hive= CREATE TABLE IF NOT EXISTS table_type.Internal_Table ( eid int, name String, designation String) COMMENT 'Employee details' ROW FORMAT DELIMITED FIELDS TERMINATED BY ',' LINES TERMINATED BY '\n' STORED AS TEXTFILE; 2)External tables Syntax Create External table ============================== Hive=CREATE EXTERNAL TABLE table_type.External_table(eid int, name String, designation String) Row format delimited Fields terminated by ',' LOCATION '/test'; #hadoop #hive #hivetables
Views: 491 ANKUSH THAVALI
How to Start,Stop, Reload Oracle Listener
 
08:16
How to Start,Stop,Reload Listener ========================================== lsnrctl start lsnrctl stop lsnrctl reload
Views: 2531 ANKUSH THAVALI
Parameter files in Oracle- Pfile & SPFile
 
07:50
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 parameter file in oracle 11g what is parameter file in oracle parameter file definition pfile parameters in oracle 11g list of initialization parameters in oracle 11g static and dynamic parameters in oracle init.ora file location in oracle 12c spfile in oracle
Views: 1444 ANKUSH THAVALI
How to Create Pluggable database Manually-Oracle 12C administration
 
08:04
How to Create Pluggable database Manually-Oracle 12C administration
Views: 2177 ANKUSH THAVALI
Create pluggable database using DBCA-Oracle 12C Administration
 
08:17
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 create container database oracle 12c create pluggable database file_name_convert example create pluggable database file_name_convert asm create container database oracle 12c manually oracle 12c pluggable database tutorial how to create pluggable database in oracle 12c step by step drop container database oracle 12c drop pluggable database
Views: 1775 ANKUSH THAVALI
How to become good Oracle dba | Skills Needed
 
06:01
My channel is mainly helpful for those who are looking to start their career in Oracle DBA | oracle databases administration technology. Channel will provide you in depth understanding for all oracle database concept.You will find the YouTube channel helpful for cracking oracle database administration interview. The explanation is clear and practically represented. Please reach me vie email [email protected] if you are looking for online training. https://www.orcldata.com Email: [email protected] Mob No: +91 9960262955 Please use the following link to get unlimited videos. https://www.skillshare.com/r/profile/Ankush-Thavali/5208062 Below is the coupon code for skillshares. https://www.udemy.com/draft/1412310/?couponCode=DBSHOT 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 #Oracle #database #oracledba
Views: 456 ANKUSH THAVALI
How to convert Snapshot  Standby Database to Physical Standby Database-Oracle Dataguard
 
09:07
Database should be in mount Stage select name, guarantee_flashback_database from v$restore_point; ALTER DATABASE CONVERT TO PHYSICAL STANDBY; shutdown database startup database in mount stage Start the MRP process #dataguard #snapshotdb #oracledba
Views: 365 ANKUSH THAVALI
Parameter files in oracle dba | spfile and pfile
 
06:39
contact me for training. e-mail: [email protected] mob no: +91 9960262955 course content: www.orcldata.com/training
Views: 220 ANKUSH THAVALI
Oracle 12C User Management | Common User & Local User
 
07:51
My channel is mainly helpful for those who are looking to start their career in Oracle DBA | oracle databases administration technology. Channel will provide you in depth understanding for all oracle database concept.You will find the YouTube channel helpful for cracking oracle database administration interview. The explanation is clear and practically represented. Please reach me vie email ankush.thaval[email protected] if you are looking for online training. https://www.orcldata.com Email: [email protected] Mob No: +91 9960262955 Please use the following link to get unlimited videos. https://www.skillshare.com/r/profile/Ankush-Thavali/5208062 Below is the coupon code for skillshares. https://www.udemy.com/draft/1412310/?couponCode=DBSHOT 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
Views: 328 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: 971 ANKUSH THAVALI
Listener related Oracle DBA interview questions | Oracle Listener
 
04:20
contact me for Oracle DBA training www.oracldata.com/training fees: 5000rs(oracle 11g and 12c combo) email: [email protected] mob no: +91 9960262955 Topics covered in video ------------------------------------------------ oracle interview questions oracle interview questions for experienced professionals oracle sql interview questions oracle index interview questions oracle interview questions 2018 oracle hints interview questions oracle 11g interview questions interview questions on constraints in oracle Listener interview question
Views: 210 ANKUSH THAVALI
How to connect to pluggable database - Interview question for oracle DBA
 
07:34
Interview question for oracle DBA | Oracle database administration ==================================== Listner should be up and running DB up and running tnsnames.ora User privilages 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: 396 ANKUSH THAVALI
Startup/Shutdown/Oratab/Export Oracle Database
 
09:27
Topic Covered Introduction of oratab file How to start and shutdown database How to set Oracle environment
Views: 761 ANKUSH THAVALI
How to take RMAN backup of datafiles in oracle 12c #oracledba
 
03:43
LIST BACKUP OF DATAFILE path BACKUP DATAFILE 1; #oracle dba #oracle database administration #database management
Views: 563 ANKUSH THAVALI
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: 453 ANKUSH THAVALI
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: 783 ANKUSH THAVALI
How to drop pluggable database manually-Oracle 12C Administration
 
06:31
How to drop pluggable database manually-Oracle 12C Administration drop pluggable database including datafiles close pluggable database unplug pluggable database create container database oracle 12c manually how to drop cdb database in oracle 12c create pluggable database create pluggable database file_name_convert asm drop pluggable database pdb
Views: 400 ANKUSH THAVALI
How to take backup of container & Pluggable database-Oracle 12C Administration
 
21:24
How to take backup of container & Pluggable database-Oracle 12C Administration ===================================================== RMAN= BACKUP DATABASE PLUS ARCHIVELOG; RMAN= BACKUP DATABASE ROOT; Pluggable Database (PDB) Backup ====================================== $ rman target=/ RMAN= BACKUP PLUGGABLE DATABASE pdb1, pdb2; $ rman [email protected] RMAN= BACKUP DATABASE; ================================================ 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: 2237 ANKUSH THAVALI
How to Set ORACLE_HOME & ORACLE_SID on Windows Server
 
07:19
How to Set ORACLE_HOME & ORACLE_SID on Windows Server ==================================================== C: Set ORACLE_HOME=C:\Oracle\product\11.2.0 Set ORACLE_HOME=DBNAME Set PATH=C:\Oracle\product\11.2.0\bin ================================================= 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: 8597 ANKUSH THAVALI
How to create pfile to spfile and Vice-Versa
 
08:59
How to create pfile to spfile and Vice-Versa ======================================== Important command ======================== create pfile from spfile create spfile from pfile show parameter spfile ============================================== 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: 340 ANKUSH THAVALI
How to check oracle database status- Interview question
 
06:09
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: 454 ANKUSH THAVALI
Datapump Export Import Table
 
16:27
This video will give you better idea of how to take the backup of table and import the same in case of missing .
Views: 205 ANKUSH THAVALI
Oracle 12C Datapump New Feature - LOGTIME Paramater
 
05:49
Please find following link to get datapump command. https://www.orcldata.com/blog/oracle-datapump-utility-export-import My channel is mainly helpful for those who are looking to start their career in Oracle DBA | oracle databases administration technology. Channel will provide you in depth understanding for all oracle database concept.You will find the YouTube channel helpful for cracking oracle database administration interview. The explanation is clear and practically represented. Please reach me vie email [email protected] if you are looking for online training. https://www.orcldata.com Email: [email protected] Mob No: +91 9960262955 Please use the following link to get unlimited videos. https://www.skillshare.com/r/profile/Ankush-Thavali/5208062 Below is the coupon code for skillshares. https://www.udemy.com/draft/1412310/?couponCode=DBSHOT 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 oracle 12c new features interview questions oracle 12c new features ppt oracle 12c new features tutorial oracle 11g new features oracle 12.2 new features oracle 12c new features vs 11g oracle database 12c release 2 new features oracle 12c rac new features oracle datapump new feature in 12c #oracledba #orcldata #datapump
Views: 262 ANKUSH THAVALI
How to put database in Archive/No-Archive log mode ?- Oracle Interview question
 
07:19
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: 249 ANKUSH THAVALI
Oracle User account is Locked/Expired & Backup of user account password
 
15:00
This video will cover the trobleshooting steps for follwoing three topics 1) User account in Locked 2) User account is Locked and expired 3) Backup of user account/Reset password 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 change expiry date of user in oracle alter user account lock oracle alter user password never expire alter user password expire how to change expired password in oracle sql developer how to unlock oracle user account in 11g oracle system password expired oracle expired(grace)
Views: 577 ANKUSH THAVALI
Hive partition with example - Interview Question
 
16:27
PARTITIONINING ===================== 1)Dynamic 2)Static 1)Creation of Table all states ============================================== create table student_nonpartition(Name string, District string,Year string) row format delimited fields terminated by '|'; 2)Loading data into created table all states Load data local inpath '/home/cloudera/Desktop/partition_data.txt' into table student_nonpartition; 3)Creation of partition table create table student_partition(Name string,District string) PARTITIONED BY(Year string); 4)For partition we have to set this property set hive.exec.dynamic.partition.mode=nonstrict 5)Loading data into partition table INSERT OVERWRITE TABLE student_partition PARTITION(Year) SELECT name,district,Year from student_nonpartition;
Views: 608 ANKUSH THAVALI
When archive log generates in Oracle?
 
02:57
Get more details on below . https://www.orcldata.com/blog/when-archive-log-generates-in-oracle In this video I have explain about different reason for archive generation. archive can be generated because of DML operation which are happening on the data bases and because of that only our database can go in hung state we will not be able to connect to the database by sys user as well as rman user. please visit to my website for more details. www.orcldata.com/training
Views: 163 ANKUSH THAVALI
Roles and Responsibilities of Oracle DBA
 
09:06
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] #oracledba #orcldata #oracletraining
Views: 460 ANKUSH THAVALI
How to Rename datafile in Oracle database
 
08:05
How to Rename datafile in Oracle ====================================== How to Rename datafile ====================================== select FILE_NAME,TABLESPACE_NAME,ONLINE_STATUS from dba_data_files; select status,instance_name,database_role,protection_mode from v$database,v$instance; alter database datafile '/opt/oracle/oradata/prim/users_test_after_rename.dbf' offline; server: mv old_data_file new_data_files alter tablespace USERS rename datafile '/opt/oracle/oradata/prim/users_test' to '/opt/oracle/oradata/prim/users_test_after_rename.dbf'; alter database datafile '/opt/oracle/oradata/prim/users_test_after_rename.dbf' online; how to move datafile from one location to another in oracle 11g alter database rename datafile file_id alter database rename datafile script how to move datafile in oracle standby database oracle move system datafile how to move datafile from one location to another in oracle 12c alter database rename file 1 to alter database move datafile 12c asm
Views: 322 ANKUSH THAVALI
PARFILE in Datapump
 
10:25
Parameter file is just a simple text file which is read and opened by expdp client unlike Dumpfiles and Logfiles which are created and written by the server. SYNTAX ========= [[email protected] ~]$ cat u1.par tables=u1.t1 directory=DATA_PUMP_DIR parallel=4 dumpfile=U1_%U.dmp logfile=expdp_u1.log =============================================== [[email protected] ~]$ expdp parfile=u1.par Export: Release 11.2.0.1.0 - Production on Thu Aug 10 04:02:43 2017 Copyright (c) 1982, 2009, Oracle and/or its affiliates. All rights reserved. Username: / as sysdba Please like ,subscribe and ask me any queries if you have any doubt. Email: [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: 440 ANKUSH THAVALI
How to get Job as Oracle DBA to Fresher ? | Oracle DBA Jobs
 
07:50
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 oracle dba jobs for freshers in mumbai oracle core dba fresher walkins oracle dba jobs for freshers in bangalore oracle dba jobs in pune for freshers oracle dba walkins in pune database administrator jobs in pune for freshers how to get oracle dba job as fresher database jobs in pune for freshers
Views: 300 ANKUSH THAVALI
RECOVER LOST  DataFile in oracle database
 
15:33
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 DATAFILE file Lost ================================ Archive log mode-Enabled create tablespace test_ts datafile '/u01/app/oracle/oradata/testdb/ts_test02.dbf' size 10M; create table testtable (id number(5))tablespace test_ts; insert into testtable (id) select * from testtable; SQL>select count(*) from testtable; COUNT(*) ---------- - before deleting datafile 524288 SQL>select count(*) from testtable; COUNT(*) ---------- - After recovery 524288 select tablespace_name, segment_name from dba_segments where segment_name = 'TESTTABLE'; alter system flush buffer_cache; alter database create datafile '/u01/app/oracle/oradata/testdb/ts_test02.dbf' as '/u01/app/oracle/oradata/testdb/ts_test02.dbf' alter database datafile '/u01/app/oracle/oradata/testdb/ts_test02.dbf' offline drop; alter database create datafile '/u01/app/oracle/oradata/testdb/ts_test02.dbf' as '/u01/app/oracle/oradata/testdb/ts_test02.dbf' recover datafile '/u01/app/oracle/oradata/testdb/ts_test02.dbf'; alter database datafile '/u01/app/oracle/oradata/testdb/ts_test02.dbf' online; select count(*) from TESTTABLE; =================================================== Please like,subscribe my channel. Kindly contact for online training on below contacts. Emai: [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] how to recover lost datafile in oracle how to recover a datafile in oracle without backup how to recover a deleted datafile in oracle 11g how to recover datafile in oracle rman restore datafile oracle missing datafile after clone how to recover system datafile in oracle without backup oracle datafile deleted accidentally
Views: 1943 ANKUSH THAVALI
Monitoring tools for Oracle DBA | OEM Introduction
 
03:35
Oracle enterprise manager is monitoring tool for Oracle database server. Oracle enterprise manager monitor to Oracle database Oracle database server agent listener and all the targets which are registered with the Oracle enterprise manager. Oracle enterprise manager tool is provided by the Oracle itself and having more demand for the Oracle database administration. In this video I have given you the overall understanding of Oracle enterprise manager tool along with the features. Please do like subscribe and comment if you have any queries. Get more details on following URL. https://www.orcldata.com/blog/monitoring-tools-for-oracle-dba-oem-introduction
Views: 139 ANKUSH THAVALI
How to delete hive external table data | Hadoop Interview question
 
03:07
In this video, how to delete the data from External hive tables. 1)You can easily delete the files from his location. dfs -rmr /user/hive/warehouse/database_name.db/table_name;*** 2) You have to change the external to internal table before drop it: example beeline ALTER TABLE $tablename SET TBLPROPERTIES('EXTERNAL'='False'); // make the table as internal and then: drop table $tablename; //
Views: 160 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] 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 oracle 12c rename container database oracle 12c rename cdb alter pluggable database rename shutdown pluggable database oracle 12c pluggable database commands connect to pluggable database oracle 12c pluggable database tutorial ora-65149: pdb name conflicts with existing service name in the cdb or the pdb
Views: 625 ANKUSH THAVALI
How to Create,delete,Start,Stop Oracle  Services-ORADIM Utility
 
13:01
ORADIM Utility in Oracle ==================================== Stopping database instance and Services =============================================================== C:\ oradim -SHUTDOWN -SID CDB -SHUTTYPE srvc,inst Start the database instance and Services =============================================== C:\ oradim -STARTUP -SID CDB -STARTTYPE inst -PFILE E:\app\oracle\product\12.1.0\dbhome_1\database\INITcdb.ORA C:\ oradim -STARTUP -SID CDB -STARTTYPE srvc -PFILE E:\app\oracle\product\12.1.0\dbhome_1\database\INITcdb.ORA OR net start oracleservice sid Delete an Instance ============================= oradim -DELETE -SID CDB Creating an Database Instance ============================= C:\ oradim -NEW -SID CDB -STARTMODE auto -PFILE E:\app\oracle\product\12.1.0\dbhome_1\database\INITcdb.ORA Creating an Database Services ==================================== C:\ oradim -NEW -SRVC OracleServiceCDB -STARTMODE auto -PFILE E:\app\oracle\product\12.1.0\dbhome_1\database\INITcdb.ORA ============================================ 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: 1533 ANKUSH THAVALI
Default no of mapper and reducer in SQOOP- Hadoop Interview question
 
02:43
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 For Oracle database training and Mock interview preparation =============================== Ankush Thavali Email: [email protected] Mob No: +91 9960262955(WhatsApp No) Web Site: www.orcldata.com YouTube : https://www.youtube.com/c/ANKUSHTHAVAL I #spark #hadoop #orcldata
Views: 131 ANKUSH THAVALI
SPOOL in oracle
 
07:33
SYNTAX ============================ -- Turn on the spool spool spool_file.txt -- Run your Query select * from dba_tables; -- Turn of spooling spool off;
Views: 2155 ANKUSH THAVALI