Thank you for this ORA 03113 video! It was exactly what I needed and solved my issue perfectly. Now my database is in READ WRITE mode. Keep up the great work!
@bobsukki6 ай бұрын
Glad it helped!
@sheltonbwondara76307 ай бұрын
Can you paste the sql statements on here somewhere
@bobsukki6 ай бұрын
Since these are simple statements, would you be able to just follow and copy onto your SQL prompt? Unfortunately, I did not include these in the transcript
@badscrew40238 ай бұрын
Good stuff!
@bobsukki6 ай бұрын
Thanks!
@arindamsinha19299 ай бұрын
It's really great learning. It's my request can you please share upgrade 12c to 19c database. And also patching the RAC & standalone database.
@bobsukki6 ай бұрын
Please follow this video for 12c to 19c upgrade using autoupgrade kzbin.info/www/bejne/eamti4OFjdlshrc
@suryaardi84009 ай бұрын
Is role automatically created on target or will be created manually?
@Best_Stocks10 ай бұрын
Is this method feeasible for 7TB db?
@bobsukki10 ай бұрын
I would not recommend this method for large databases as this will require alot of time for the exp and imp processes. If you choose to, it will require alot of resources and parallelism
@PavanKumar-ec4ct11 ай бұрын
Got clarity about nofilename check command in this video thanks a lot
@bobsukki11 ай бұрын
Glad it helped 👍🏽
@mohammadfarhan657611 ай бұрын
Can u help me?
@bobsukki11 ай бұрын
Yes I hope I can. Send me a message on LinkedIn
@bobsukki11 ай бұрын
Follow me on LinkedIn (pinned comment ) and send me a message
@howtojump0217 Жыл бұрын
YOU RESOLVE MY PROBLEM TYSM !!!
@Adilkhan-f3x4u Жыл бұрын
Could you please paste those sql statements here sir
@sheltonbwondara76307 ай бұрын
Did he paste those SQL statements on here?
@abhijitlande1028 Жыл бұрын
Great Very good explanation.
@huynhtruong5072 Жыл бұрын
Your video helps me a lot. Thank you so much. Respected Sir
@SpeedTex Жыл бұрын
where are you? hope you are doing well, you have a great channel! please drop more contents!
@bobsukki Жыл бұрын
I appreciate! 👍
@claudensuhfor1466 Жыл бұрын
How can I get this documentation you use?
@krishnakatikuti1 Жыл бұрын
Thnq
@SureshKumar-no3eo Жыл бұрын
very informative, Hi Sir Your vedios are very good and helpful for us.
@neworacle-eo7hr Жыл бұрын
Great
@hallkbrdz Жыл бұрын
Hands-down the most straightforward and simplest guide to setting up DG and the DB Broker I have seen. Thanks for taking the time to make this video! Oracle of course provides no step-by-step guide, so you are on your own to piece together a script to make this all work. There are many things I've been including based on various other guides that appear to not be necessary, possibly because they are based on older db versions items that are no longer required (such as a separate listener entry for the broker).
@blessed3401 Жыл бұрын
Hi, from the demo, does it mean decreasing the SGA to factor of .5 will have better performance as the estimate db time is 20?
@asifomer4349 Жыл бұрын
plz share the video of stand by db
@bobsukki6 ай бұрын
Here you go... kzbin.info/www/bejne/m2TVamqYaqhld5Y
@parasharampakhari1583 Жыл бұрын
Great video bro keep on uploading new videos on Oracle DB
@bobsukki6 ай бұрын
Thank you!
@swat2222 жыл бұрын
Can you also make a video on rman refresh when source and target is container database consisting of single pdb ?
@swat2222 жыл бұрын
Thank you very much for this video...Can you also make one on setting PGA using advisor
@anandkanawade98952 жыл бұрын
Excellent videos.m please make a course on 19c multenant on udemy or youtube
@bobsukki6 ай бұрын
I appreciate your suggestion, it will be an absolutely great idea! Thank you
@शिवमआर्य-व4य2 жыл бұрын
THANKS🙂
@paradizecracked2 жыл бұрын
i thought we should also create logfile thread 2 and undotbs2 on primary...
@abukanu16142 жыл бұрын
You're absolutely one of the best I've ever watched.
@bobsukki6 ай бұрын
Thank you! I appreciate
@SpeedTex2 жыл бұрын
Fantastic! Could you please do an extensive video on "Performance Tuning?" maybe with OEM 13.5 cloud or alternatives. Thank you so much.
@ihanyariole29352 жыл бұрын
Simple and straigthforward .. great info
@SpeedTex2 жыл бұрын
wow this was awesome, I couldn't believe you provided these 5 videos for free I see lots charging $5k for series like these. Thanks
@bobsukki2 жыл бұрын
You're very welcome!
@SpeedTex2 жыл бұрын
I did everything step by step but I couldn't connect to auxiliary database in RMAN, ,(Instance "primtstDB", status BLOCKED, has 1 handler(s) for this service. ) . RMAN> connect auxiliary sys@primtst; auxiliary database Password: RMAN-00571: =========================================================== RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS =============== RMAN-00571: =========================================================== RMAN-04006: error from auxiliary database: ORA-12537: TNS:connection closed
@SpeedTex2 жыл бұрын
Thanks I resolve this error by adding additional entry into my tnsnames.ora file, in the last line entry after service_name, I added this " (UR = A) ". For anyone having this error try this, it should work. :)
@veransobrian86972 жыл бұрын
Amazing. love it. Why dont you source those parameters from the bash_profile?
@bobsukki2 жыл бұрын
I could, but i usually don't prefer using the bash_profile when I plan on having multiple databases running on thesame server
@veransobrian86972 жыл бұрын
Very well presented. You are a great content creator and instructor. The steps are clear easy to follow but I wish you could include some other pre-requisite steps like hosts file edit, distinction between manual and automatic install parameters, maybe mention solutions to some commonly experienced installation processes. Thank you.
@bobsukki2 жыл бұрын
Noted
@SilvermanWKWK2 жыл бұрын
Can you help me i already following ur step but when i try to connect to rman auxiliary "dbstby" my tns couldnt connect the server and i see listener status on standby its blocked
@bobsukki2 жыл бұрын
Sorry I am getting to you late... Do you still have this issue going on?
@jeevankuntla2 жыл бұрын
I have 2 questions 1)Do we need to install Clusterware on node 2 before converting to RAC or rconfig will take care of it. 2)What if the second node has configuration issues, and how rconfig will take care of it ?
@bobsukki2 жыл бұрын
Ans 1: YES YES and YES... RAC is clustered nodes... so Clusterware must be installed. Ans2: rconfig is only a tool to help convert SI to RAC... if there are underlying issues, rconfig more than likely will fail. That is why you run rconfig with ONLY option to check first before executing
@nsar0062 жыл бұрын
very nicely explained and very much informative
@bobsukki2 жыл бұрын
Glad it was helpful!
@fabianalbertoloerasalas6592 жыл бұрын
is it just enough if I exclude just SYS and SYSTEM schemas?
@bobsukki2 жыл бұрын
Yes you can! 👌🏽
@akinsmedia772 жыл бұрын
I enjoyed this video. valued added, you made my day
@bobsukki2 жыл бұрын
Glad you enjoyed it!
@MA-lo4xk2 жыл бұрын
Should we be doing export and import as sysdba? I thought oracle does not recommend this?
@bobsukki2 жыл бұрын
Yes we can, it depends, especially when I am doing a Full=Y. Otherwise, use the SYSTEM user
@MA-lo4xk2 жыл бұрын
As you are excluding most of the schemas , do we need full=y export? Why not just export(include) the application schema only (must smaller list) and thats it, instead of having a long list of excluded shemas? Your thoughts much appreciated. Thank you
@bobsukki2 жыл бұрын
You could do that too.
@MA-lo4xk2 жыл бұрын
Great video thank you for sharing sir. Out of interest what about roles and privaleges or anything , will they be included the export/import? Secondly instead of creating a new dump directory can we not use the one already there? thank you
@bobsukki2 жыл бұрын
Yes, absolutely
@ChetanVithlani2 жыл бұрын
Great insights, thanks for sharing!
@bobsukki2 жыл бұрын
Thank you always Chetan!
@thuynghiem86022 жыл бұрын
I don't show out the information of sensitive data in Discoverer, can you help me with this section?
@bobsukki2 жыл бұрын
Send me an email so we can find some time to connect and walk through
@thuynghiem86022 жыл бұрын
@@bobsukki I send
@SANDATA7642 жыл бұрын
Sir The steps was very clear Much respect Please more videos on performance tuning , read awr, reading execution plan and sql tuning
@bobsukki2 жыл бұрын
Sure I will. Thank you
@aniketbanerjee63772 жыл бұрын
Does it requires downtime while going conversion .If no will it impact any new connection or existing connection ?
@bobsukki2 жыл бұрын
Great question... Yes, the single instance is shutdown and restarted multiple times and a new rac instance is created. Therefore, existing connections will be dropped as that single instance goes down
@SANDATA7642 жыл бұрын
Respected Sir Your steps are very clear Thanks
@bobsukki2 жыл бұрын
Thank you Salad, I am glad you found it helpful!
@SANDATA7642 жыл бұрын
@@bobsukki respected sir I can't wait your upcoming videos
@SANDATA7642 жыл бұрын
Man you are doing great job A big thanks to sir
@bobsukki2 жыл бұрын
Thanks and welcome
@SANDATA7642 жыл бұрын
Man you are doing great job Please do more videos on oracle performance tuning Please and please
@bobsukki2 жыл бұрын
Certainly, I will be making short performance tuning videos as requested!