- 140
- 600 322
Database Guy
India
Приєднався 24 лют 2007
Learn Oracle and Db2 Database Administration for Beginners
ReRecorded - Oracle 19c TDE (Transparent Data Encryption) using ADMINISTER KEY MANAGEMENT
Oracle 19c TDE (Transparent Data Encryption) using ADMINISTER KEY MANAGEMENT
00:00 Overview
01:36 Theory - Steps in Detail
08:26 LAB - Create Wallet
14:35 LAB - Create Encrypted Tables/Columns
16:20 LAB - Create Encrypted Tablespace
18:14 LAB - Perform RMAN Encrypted Backups
21:57 LAB - Wallet is LOST
25:13 Summary & Ending
00:00 Overview
01:36 Theory - Steps in Detail
08:26 LAB - Create Wallet
14:35 LAB - Create Encrypted Tables/Columns
16:20 LAB - Create Encrypted Tablespace
18:14 LAB - Perform RMAN Encrypted Backups
21:57 LAB - Wallet is LOST
25:13 Summary & Ending
Переглядів: 47
Відео
Oracle Database TDE (Transparent Data Encryption)
Переглядів 29121 день тому
Oracle Database Transparent Data Encryption (TDE) using ADMINISTER KEY MANAGEMENT
Oracle Database Recover from Old Control File Error ORA-01207
Переглядів 3323 місяці тому
Oracle Database Recover from Old Control File Error Error Received while Startup ORA-01122: database file 1 failed verification check ORA-01207: file is more recent than control file - old control file
Oracle Database System File Needs Media Recovery (Missing Archive Logs)
Переглядів 3713 місяці тому
Oracle Database System File Needs Media Recovery (Missing Archive Logs)
Oracle Database System File Needs Media Recovery (All Archive Logs Present)
Переглядів 2403 місяці тому
Oracle Database System File Needs Media Recovery (All Archive Logs Present)
SQL Server Point in Time Restore
Переглядів 2057 місяців тому
Restore SQL Server Database to specific point in time.
Oracle OEM 13.5 On Windows Manage Data Guard
Переглядів 2438 місяців тому
Oracle OEM 13.5 On Windows Manage Data Guard
Oracle OEM 13.5 on Windows Add Target
Переглядів 8968 місяців тому
Oracle OEM 13.5 on Windows Add Target
Oracle OEM 13.5 Installation on Windows Setup
Переглядів 2,8 тис.8 місяців тому
Timeline 00:00 Overview 03:15 Install Visual C Redistributable 06:40 Download Oracle 19c Database home & OEM 13.5 10:10 Pre-requisites for Oracle 19c Database Home 15:40 Set Environment Variables 17:40 Install Oracle 19c Database Home 19:27 Create Listener 21:30 Create Database for OEM Repository 26:48 Listener Static Registration 28:15 Database Configuration for OEM 30:00 Install OEM 42:20 Log...
Oracle 19c Data Guard on Windows Broker Setup
Переглядів 4228 місяців тому
Link to Script www.dropbox.com/scl/fi/g18i0tnglf3z5qr3lo80o/Oracle-19c-Data-Guard-Broker-Setup-on-Windows.sql?rlkey=ahjc0fe0o725g2e194y1prg9v&dl=0
Oracle 19c Data Guard Configure Client/App Failover
Переглядів 7038 місяців тому
Script Used www.dropbox.com/scl/fi/ph93ixpyhh8mz72vebn51/Oracle-19c-Data-Guard-Client-Failover.sql?rlkey=ky48lnh9v5rpxaeblcly7vhwj&dl=0
Oracle 19c Data Guard on Windows Step By Step Setup
Переглядів 2,8 тис.8 місяців тому
Oracle 19c Data Guard on Windows Step By Step Setup
Oracle FULL vs INCREMENTAL LEVEL Backup
Переглядів 4799 місяців тому
Oracle FULL vs INCREMENTAL LEVEL Backup
Oracle Backup Misconception No Archivelog Mode & Incremental Backup
Переглядів 3189 місяців тому
Oracle Backup Misconception No Archivelog Mode & Incremental Backup
SQL Backup & Restore (Restore .bak file)
Переглядів 1659 місяців тому
SQL Backup & Restore (Restore .bak file)
Oracle RAC Administration Basic Commands
Переглядів 3,8 тис.9 місяців тому
Oracle RAC Administration Basic Commands
Oracle RAC Concepts & Theory - Prepare for Interview
Переглядів 9 тис.9 місяців тому
Oracle RAC Concepts & Theory - Prepare for Interview
How to connect to Oracle RAC Database
Переглядів 8149 місяців тому
How to connect to Oracle RAC Database
Oracle Database How to connect - Listener Configuration in Detail
Переглядів 1,4 тис.9 місяців тому
Oracle Database How to connect - Listener Configuration in Detail
Oracle Database How to connect - Listener & TNSNAMES
Переглядів 2,1 тис.9 місяців тому
Oracle Database How to connect - Listener & TNSNAMES
Oracle Database How to connect - Basic Troubleshooting
Переглядів 91610 місяців тому
Oracle Database How to connect - Basic Troubleshooting
Oracle RMAN Restore Database Like a Champion
Переглядів 49510 місяців тому
Oracle RMAN Restore Database Like a Champion
How to take Oracle Database Backup Learn under 30 mins
Переглядів 49310 місяців тому
How to take Oracle Database Backup Learn under 30 mins
Learn Oracle Data Pump In Detail - Logical Backup
Переглядів 1,6 тис.10 місяців тому
Learn Oracle Data Pump In Detail - Logical Backup
Learn Oracle Data Pump in 10 Mins - Logical Backup
Переглядів 57810 місяців тому
Learn Oracle Data Pump in 10 Mins - Logical Backup
Oracle Restore Database on Windows Different Server on a Different Location
Переглядів 1,1 тис.10 місяців тому
Oracle Restore Database on Windows Different Server on a Different Location
gracias amigo, voy a aprobar yeray por tí <3
Sir please demonstrate the node eviction scenario....it's really needed
Thank you sir fabulous 😍
Hi its there a way to contact you?
Hi Roberto, you can post your question here. I do not provide my contact details. Really sorry.
Do we need to add file share witness in the failover clustering?
Its not mandatory to add file share witness.
@@DB2_Oracle thank you. does it help to improve failover if we add file share witness? Reason being is in our current setup, we do not configure file share witness, and it simply does not failover when the active node went down. thank you for advice.
@WahanaJitu This calls for Microsoft Support Case. In Failover Cluster, Quorum plays the role. Are you sure that the surviving node is taking the ownership of Quroum.
Hi Sir,will you help how to check db2 group sharing CPU usage
Pls can u share the scripts u used. Then at first u said there's no running database on the target. I don't think u can have an Oracle home without a database in it. I got confused at the point i saw u did cd Oracle home on the target server. U can help clarify. Because the scenario i am looking at is a case where u just server ans an OS running then u copy the init.ora, orapw file and backups then create directories. Thank you
You can have ORACLE_HOME without any database in it. In most production servers, we first install Oracle Software which creates Oracle Home. Then we create the database. In this lab, the Oracle is installed on both of the servers before. And on the target server, there is no Database created.
Thanks again boss. You are the best. If it pleases you can u share the script u used for this demo with me for my enhancement.
I'm not able to add the disk in the storage, I'm getting the error as no disks suitable for cluster disks were found. Would you kindly let me know to resolve this error
Have you verified that disks are visible on both of the nodes
@DB2_Oracle yes it's visible on both the nodes
Can you share the document?
Excellent and Awesome info and explanation . Thanks for your great efforts and sharing with us 😍🤩🥰🙏🙏🙏🙌👍👏👏
Thank You for nice comment. Glad you liked it.
This video helped me a lot. Thanks for the tutorial!
Thank You for nice comment. Glad it helped you.
Nice,Thank you
Thank You.
hi i am so thankful you for this video , but i have something i dont know why it doesnt work when i did some transactions in primary machine i went to standby machine but nothing appear untill i run alter system switch logging command in primary machine at every time i did change and i want to see it in real time , can you tell me why it doesnt run in real time and i have to run it manually
Check your configuration of Standby Redo Logs (SRLs).
Excellent tutorial 🎉
Thank You for nice comment. Glad you liked it.
Great Explanation
Thank You for nice comment. Glad you liked it.
Legend. Sorted me out
Thank You for nice comment. Glad you liked it.
I am getting ORA-12505, TNS:listener does not currently know of SID given in connect descriptor during test connectivity after database upgrade sir. How to fix this? ty.
Please watch my videos on Listener configuration
Sir too fast
Sorry. Natural speed. I try to reduce it but naturally I am fast.
Is there a script to automate the installation on multiple clients via SCCM?
Yes, you can do this deployment using SCCM. You have to use silent command line installation and put commands in .bat file
Hi i need clear documents on this
Documents are already shared with script in Video Description.
I'm getting [Error] Execution (3: 2): ORA-29273: HTTP request failed ORA-28860: Fatal SSL error ORA-06512: at "SYS.UTL_HTTP", line 1491 ORA-06512: at line 1
Thank you a lot
You are welcome.
Thanks brother. Great video. It was a great help for my assignments
I am happy to see that Videos are helping people. Glad your liked it.
one confusion is , for creating the wallet we use db location or application server location , how you get (home/oracle/ ora19D), is this mandatory create wallet in db location or it can be application server location too , please reply
Certificate has to be in Database Server. Location/Directory/folder of your choice. You can create directory with your name and that is fine.
good explanation
Thanks for liking
amazing
Thank you! Cheers!
We can ping the private IP but not VIP and scan IP
It should be other way around. You should not be able to connect to Private IP. Watch below video. You will come to know. ua-cam.com/video/Rg7XjTOUbZk/v-deo.html
Thanks so much,,very useful
Please upload performance tuning And how to find d Database working slow W and how to resolve
Nice explanation
outstanding video.. thank you for sharing
Can you share link of earlier video? I an not able to find the video.
Part 1 - ua-cam.com/video/rnRz92veJhA/v-deo.html Part 2 - ua-cam.com/video/BIOJjnHw50w/v-deo.html Part 3 - ua-cam.com/video/USK7V0Fi63s/v-deo.html
Cant thank you enough brother. NEVER stop making such videos. Video was one hour. But i spent 4 hours by rewind/forward. God bless you.
Thank you for the nice comment. It feels good to hear that Video is helping people. And will definitely upload the videos.
Thanks Sir for this best explained video. But where is your pdf link ?
Is it possible to upgrade a DB2 instance from version 10.5 directly to 11.5?
Yes, it is possible
can you share the scripts ?
I follow Your steps but it raise some errors ORA-29273: HTTP request failed ORA-29024: Certificate validation failure
Where can I download Oracle to practice?
Official Oracle Website Please watch other video on how to install Oracle available on my channel. It has been explained there
Thanks anyway but I have several problems I have applied all these steps exactly in Oracle 11g but I have many problems In the recovery step, no .dbf files on oradata directory appeared. I only have files named numbers.
I can record this on Oracle 11g if needed
Which WINDOWS OS version you are using so I will match that as well
@@DB2_Oracle On the main server machine Windows 10 46 bit and on the target machine server Windows 11 46 bit
How to make a full backup in case of a Windows crash with Oracle installed in it and how to restore it, knowing that I am working with Oracle 11g. Thank you.
hi! can I do the same for oracle 11g I mean is the same possible? its urgent please answer it faster!
Yes... But you might want to use windows 2012 for 11g
Thank you very much for this video it was very very helpful I have been struggling with db2 Community version for days now and your video helped me to be able to get it up and running. I am still not able to connect from vs code or from the Mainframe but at least I have db2 up and running. There is no clear explanation anywhere online on something as simple as how to find your IP address and port number. The only problem I am having now is connecting from the mainframe but I think that is because of the CLI driver situation, but you even mentioned that when installing the driver to turn off the antivirus. Little things like that make this the best video on the internet for getting started with db2 on Windows. Thank you very much
Thank you for such a nice and detailed comment. And I am really glad that it helped you. Let me know the difficulties you face and if it worth recording the solution, i will record video on that topic.
@@DB2_Oracle I created a complete mess because I did not realize that you were installing the DB2 server and the DB 2 client on two different machines I installed the client on the same machine as the server so now it's a complete mess so I uninstalled everything and started over but I still cannot get vs code IBM DB2 extension to connect to the server. do I have to install a special driver To be able to make vs code connect to DB2 server? they are both on the same machine. I'm stuck and I cannot figure it out. Thanks so much
I found the solution as to why I could not connect I was using the DB2 developer extension in Vs code but I saw someone say to try the DB2 connect extension. The DB2 connect extension worked. now I can connect to DB2 community version on windows 11 using vs code. I plan to write and execute cobol programs using vs code and DB2 community. thanks So much for your video I had to refer back to it several times
excellent teaching
Thank You for the nice comment.
best
Thank You
this is super useful and detailed thank you!
Thank You for the nice comment. I hope it helped.
I am not getting any options like it sill show 19c oracle and no configurations options it doesnt show what to do inthis case
Can you please describe the proper error
@@DB2_Oracle when I install the setup as run as admin a pop up will come it shows nothing
@6:22 post this nothing loads it doesn't show anything
Good presentation .. congrats
Thank You for the nice comment.
nice explanation sir
Thank You for the nice comment.
Awesome. Also, please paste the commands in the description section. For some reason export DISPLAY x.x.x.x: 7.0 did not worked so I searched and changed it to 0.0 and it worked. Thanks again. More power to you.
Thank You for the nice comment. And thanks for pointing it the error and getting it fixed.
@@DB2_Oracle I shut down the vm and next day I was not able to connct the DB😄. I don’t know if it was installed as service, I don’t know how to start. Reinstalling again.
very very informative ,thx bro
Thank You for the nice comment.
excellent