- 59
- 16 127
TekXtract
Canada
Приєднався 10 сер 2020
This Channel is solely created to share Industry Level Database Administration Experience and Generic Information Technology related Tasks with Students and New Comers stepping into Industry for the First time and Struggling to get hold of Specific Topics . My Name is Abhinav Pandey . I Live in Toronto ,Canada . I have More than 10 Years of Database Administration Experience in Different Domain Such as Health Care , Telecom , Banking . I have Expertise on Supporting more than 1500 Databases ( Including Oracle Database Administration ( 10g ,11g , 12c , 19c ) , SQL Server 2012,2016 , MongoDB ) besides Windows Server and Linux Servers .My hobby is to Enjoy Learning and keeping myself updated to Latest Technologies . I think you all are in great Hand . Please comment and let me know if anything is a miss in these videos or anyone wants me to make specific videos . I will try to create those too if time permits . Hope to see all Tech Enthusiasts Here . Happy Learning
Linux Man Page | Details and Description
This Video will Clarify all Doubts relating to Man Pages .
#linuxmanpages #linux #oraclelinux #linuxcentos #centoslinux #manpages
#linuxmanpages #linux #oraclelinux #linuxcentos #centoslinux #manpages
Переглядів: 45
Відео
VMWARE WORKSTATION NETWORKING
Переглядів 212 роки тому
This Video is Part of "Topics of Confusion" . Below are some of the Points Discussed 1) Type of Networking in VMWARE Workstation 2) Details on the Network Adapters and use of those
Recovery Catalog - Part 2
Переглядів 683 роки тому
This Part Will Discuss on 1) Cataloging the Files into Recovery Catalog 2) RMAN Script #oraclerecovery #oracledatabaserecovery #oracledatabase #oraclerc #recovery #backupandrecovery #oraclebackupandrecoverytechniques #oracleworld #oraclebase #oraclelive #oracle12cdatabase #oracle11gdatabase #oraclenewversion #oraclelatest #ora #oracledisasterrecoveryplan #oracleplan #oraclequicktips #oraclechan...
Recovery Catalog - Part 1
Переглядів 1173 роки тому
This is Part 1 of Recovery Catalog . We will be Covering all the Details into Recovery Catalog #oraclerecovery #oracledatabaserecovery #oracledatabase #oraclerc #recovery #backupandrecovery #oraclebackupandrecoverytechniques #oracleworld #oraclebase #oraclelive #oracle12cdatabase #oracle11gdatabase #oraclenewversion #oraclelatest #ora #oracledisasterrecoveryplan #oracleplan #oraclequicktips #or...
PHYSICAL STANDBY POST CREATION STEPS (LAB) - PART 10
Переглядів 904 роки тому
Please use Below Link for Post Creation Step Doc : drive.google.com/file/d/1da1pIo2LVguwZtK14yMFpK3wKksTn3i4/view?usp=sharing
PHYSICAL STANDBY DATABASE SETUP (LAB) - PART 9
Переглядів 2274 роки тому
Please get the Document on How to Create Physical Standby from the Below Link : drive.google.com/file/d/1da1pIo2LVguwZtK14yMFpK3wKksTn3i4/view?usp=sharing
PHYSICAL STANDBY DATABASE CREATION (STEPS - THEORY) - PART 8
Переглядів 1684 роки тому
PHYSICAL STANDBY DATABASE CREATION (STEPS - THEORY) - PART 8
ORACLE DATAGUARD BASIC CONCEPTS - PART 3
Переглядів 1284 роки тому
ORACLE DATAGUARD BASIC CONCEPTS - PART 3
INTRODUCTION TO ORACLE DATA GUARD - PART 2
Переглядів 1264 роки тому
INTRODUCTION TO ORACLE DATA GUARD - PART 2
INSTALLING ORACLE SOFTWARE AND DATABASE FOR BASE SETUP (DATA GUARD) - PART 7
Переглядів 1544 роки тому
This Video will Go through Setup of Creating Base for Moving on to Creating Physical Standby Database in Future Lectures .
SETUP ORACLE ASM DISK AND DISKGROUPS FOR ORACLE DATAGUARD - PART 6
Переглядів 2214 роки тому
SETUP ORACLE ASM DISK AND DISKGROUPS FOR ORACLE DATAGUARD - PART 6
INSTALLING ORACLE LINUX 7.7 ON VMWARE(PREP FOR DATA GUARD SETUP) - PART 5
Переглядів 2004 роки тому
INSTALLING ORACLE LINUX 7.7 ON VMWARE(PREP FOR DATA GUARD SETUP) - PART 5
ORACLE DATAGUARD INSTALLATION ARCHITECTURE (MY PC) - PART 4
Переглядів 1514 роки тому
ORACLE DATAGUARD INSTALLATION ARCHITECTURE (MY PC) - PART 4
WHAT WILL BE COVERED IN ORACLE DATA GUARD COURSE ? - PART 1
Переглядів 3024 роки тому
WHAT WILL BE COVERED IN ORACLE DATA GUARD COURSE ? - PART 1
PART - 2 # ORACLE SINGLE INSTANCE NON CDB DATABASE 19c SILENT INSTALLATION (Using DBCA)
Переглядів 4094 роки тому
PART - 2 # ORACLE SINGLE INSTANCE NON CDB DATABASE 19c SILENT INSTALLATION (Using DBCA)
PART - 1 # ORACLE DATABASE SOFTWARE SILENT INSTALLATION 19c
Переглядів 3,3 тис.4 роки тому
PART - 1 # ORACLE DATABASE SOFTWARE SILENT INSTALLATION 19c
ORACLE CACHE FUSION 12c R2 (GLOBAL RESOURCE MANAGEMENT) - THEORY - PART 2
Переглядів 3164 роки тому
ORACLE CACHE FUSION 12c R2 (GLOBAL RESOURCE MANAGEMENT) - THEORY - PART 2
ORACLE CACHE FUSION 12c R2 ( USING FLOW DIAGRAM ) - THEORY
Переглядів 1 тис.4 роки тому
ORACLE CACHE FUSION 12c R2 ( USING FLOW DIAGRAM ) - THEORY
PART:4 - INSTALL ORACLE RAC DATABASE SOFTWARE AND MULTITENANT DATABASE (WITH 2 PLUGGABLE DATABASES)
Переглядів 574 роки тому
PART:4 - INSTALL ORACLE RAC DATABASE SOFTWARE AND MULTITENANT DATABASE (WITH 2 PLUGGABLE DATABASES)
PART: 3 - ORACLE CLUSTERWARE 19c INSTALLATION
Переглядів 744 роки тому
PART: 3 - ORACLE CLUSTERWARE 19c INSTALLATION
PART:1 - ORACLE PRE-REQUISITES (OS and Shared Disk)
Переглядів 1924 роки тому
PART:1 - ORACLE PRE-REQUISITES (OS and Shared Disk)
PART - 2 : ASM ADMINISTRATION 12c (BASICS)
Переглядів 864 роки тому
PART - 2 : ASM ADMINISTRATION 12c (BASICS)
PART: 1 - ASM ADMINISTRATION 12c ( BASICS )
Переглядів 4194 роки тому
PART: 1 - ASM ADMINISTRATION 12c ( BASICS )
PART-3 DATA-PUMP TABLESPACE LEVEL BACKUP
Переглядів 154 роки тому
PART-3 DATA-PUMP TABLESPACE LEVEL BACKUP
SINGLE INSTANCE TO RAC USING RCONFIG (ORACLE 12c R2)
Переглядів 3174 роки тому
SINGLE INSTANCE TO RAC USING RCONFIG (ORACLE 12c R2)
eating and drinking sound is annoying
Thank you so much. Can you share the documentation?
Thank you for this.....pls share the next video
Excellent tutorial! Thank you 🙏
Thanks u so much
Most welcome
Very good video, everything works correctly until the step When I validate communication between rac1 and rac2 I get the following error message, could you help me PRKN-1038 : The command "/usr/bin/ssh -o FallBackToRsh=no -o PasswordAuthentication=no -o StrictHostKeyChecking=yes -o NumberOfPasswordPrompts=0 rac2 -n /bin/true" run on node "rac1" gave an unexpected output: "oracle@rac2: Permission denied (publickey,gssapi-keyex,gssapi-with-mic,keyboard-interactive)."
Please paste the screenshot here
Hi , in the minute 10:06 how to configure if I have two or more disks ? example: oracleasm createdisk DATA /dev/sdc1 oracleasm createdisk DATA /dev/sdc2 or oracleasm createdisk DATA1 /dev/sdc1 oracleasm createdisk DATA2 /dev/sdc2 best regards
Hello . Just to clarify Disk in reference to this example above is /dev/ sdc and sdc1 and sdc2 are partitions . When you mention 'createdisk' you are creating ASM disk and using disk partitions already created using OS utility fdisk . under the example you have mentioned as oracleasm createdisk DATA1 /dev/sdc1 oracleasm createdisk DATA2 /dev/sdc2 you are creating ASM diskgroups DATA1 and DATA2
Please let me know if there are still some confusions
Beautiful presentation
Thanks a lot
presentation is very good, just avoid 'ok', 'ok' work
Noted and Thanks . I noticed too . 😁
Good Work...Appreciate your efforts
Thanks a lot
Hi, you can you please share link to the previous video you reference which is a prereq to this one (manually taking backup and moving the backup files to location)
Installation done thanks for your support
If you can please share configuration file here like you did for Oracle 12C.. I will appreciate that...it will be easy for me to install 19c then..Thank you
Very briefly explained .. Thank you
very informative
Can you please share text file of this video.
Great work Indeed.. I would like to ask one question here..You changed listener config two times. First time you set oracle home as oracle grid to start listener & later again it caused issues and you set it back to oracle home. With ASM it should not be set to Oracle grid? Can you please clarify that
Hello Imran , Let me clear your Doubt and you are 100% correct on Listener runs from GRID Home. .The issue you saw was 1) Creating File tnsnames and listener was mistake which i initially corrected 2) The SID_LIST_LISTENER you see and ORACLE_HOME i modified is just copy and paste from my LAB DOC which you saw . SID_LIST_LISTENER is to create Static Listener , which will never be case when you check the Default Listener configured using GRID Installation *********** THIS IS THE DOWNSIDE OF COPY AND PASTE . APOLOGY AND THANKS FOR POINTING *************
Please check your email , i have some doubt in this !!
My db is in Grid. does DBUA will take care the Grid too?
100%
What is the best practice? Should i upgrade my DR first before upgrading my primary db?
Upgrade the Primary Database First ( switchover to new primary ) and then do the old standby later
Pls put the link for manual upgrade 12c to 19c .
thanks
You're welcome!
great, very simply explained
Glad you liked it
Hi can you share me your documentation ufuomaodibo@hotmail.com
hi can you share me full documentation of this steps
with this video i successfully converted my single instance 11gR2 to RAC ..... through my environment was on virtual box so to attach virtual disk method is different in that first run running RCONFIG with ONLY option , so if it is successful then execute with YES option
it is very nice and informative video . i watch all this . my setup is on virtual box and 11gR2 .......i have many questions in mind ....... how i can reach you ?
Please email me @ abhinavpandey.1116@gmail.com
i could not understand at the end why you were giving sid=node1 or node2 , it should be orcl as per my thinking .... plz reply
Hi ; Could you please let me know which section you are referring to . Can you please provide the Timeline where i can specifically look and guide you accordingly . Thanks
@@tekxtract1117 from 1:50:00 onwards database sid is orcl but in oratab u r setting node1 as sid and then again in environment settingu r giving orcl it is bit confusing
Thanks for Asking . so ... node1 and node2 are instances and orcl is database . you need to set environment to specific instance to login to database. eventually both instances are pointing to same database orcl. note : Instance : contains memory structure and background process database : are just records sitting under data file under disk/storage.
if you are configuring a fresh RAC production environment 1.how many diskgroups do you configure for that ? 2. what is usually size of disks in these diskgroups ? 3. What is ASM redundancy level set for RAC production env ? plz reply
do u have any video to create yum respository u configured for above setup ..... plz share link if u have ..thanks
Good video. Easy to follow along. Thank you so much.
Thank you much. Good vid.
that was very nice video. I need an info that we are installing any software of 19c ? if not then how we can get bin folder and dbua in home folder of 19c
Hi Bhupati , could you please clarify your question so that i can provide you with relevant Answer . Thanks
Very good and self explanatory video for Multitenant . Could you also show us how to do data pump in these PDBS from schemas.
Now main question is do we have to configure DHCP in DNS server or there will be a separate machine for DHCP server ?
In Production Environment Best Practice is to Configure DHCP in Separate Server . It completely depends on the Organization and No of Servers :)
@@tekxtract1117 Okey thank you
this is something i was looking for. Thank you so much. appreciate your effort.
Glad it was helpful!
Simple and quick. I could get a node in real quick with your instructions on Windows 2019. Thank you
Glad you Liked
Good explanation 👍
Glad you liked it!
Very Useful!! Thank you Sir