Oracle Database Security Assessment
41:34
Пікірлер
@austinimegwu932
@austinimegwu932 3 ай бұрын
Very Good presentation.
@bobsukki
@bobsukki 3 ай бұрын
I appreciate your feedback!
@rowlandjones3872
@rowlandjones3872 3 ай бұрын
really good material, thanks
@al-imrandoha883
@al-imrandoha883 6 ай бұрын
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!
@bobsukki
@bobsukki 6 ай бұрын
Glad it helped!
@sheltonbwondara7630
@sheltonbwondara7630 7 ай бұрын
Can you paste the sql statements on here somewhere
@bobsukki
@bobsukki 6 ай бұрын
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
@badscrew4023
@badscrew4023 8 ай бұрын
Good stuff!
@bobsukki
@bobsukki 6 ай бұрын
Thanks!
@arindamsinha1929
@arindamsinha1929 9 ай бұрын
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.
@bobsukki
@bobsukki 6 ай бұрын
Please follow this video for 12c to 19c upgrade using autoupgrade kzbin.info/www/bejne/eamti4OFjdlshrc
@suryaardi8400
@suryaardi8400 9 ай бұрын
Is role automatically created on target or will be created manually?
@Best_Stocks
@Best_Stocks 10 ай бұрын
Is this method feeasible for 7TB db?
@bobsukki
@bobsukki 10 ай бұрын
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-ec4ct
@PavanKumar-ec4ct 11 ай бұрын
Got clarity about nofilename check command in this video thanks a lot
@bobsukki
@bobsukki 11 ай бұрын
Glad it helped 👍🏽
@mohammadfarhan6576
@mohammadfarhan6576 11 ай бұрын
Can u help me?
@bobsukki
@bobsukki 11 ай бұрын
Yes I hope I can. Send me a message on LinkedIn
@bobsukki
@bobsukki 11 ай бұрын
Follow me on LinkedIn (pinned comment ) and send me a message
@howtojump0217
@howtojump0217 Жыл бұрын
YOU RESOLVE MY PROBLEM TYSM !!!
@Adilkhan-f3x4u
@Adilkhan-f3x4u Жыл бұрын
Could you please paste those sql statements here sir
@sheltonbwondara7630
@sheltonbwondara7630 7 ай бұрын
Did he paste those SQL statements on here?
@abhijitlande1028
@abhijitlande1028 Жыл бұрын
Great Very good explanation.
@huynhtruong5072
@huynhtruong5072 Жыл бұрын
Your video helps me a lot. Thank you so much. Respected Sir
@SpeedTex
@SpeedTex Жыл бұрын
where are you? hope you are doing well, you have a great channel! please drop more contents!
@bobsukki
@bobsukki Жыл бұрын
I appreciate! 👍
@claudensuhfor1466
@claudensuhfor1466 Жыл бұрын
How can I get this documentation you use?
@krishnakatikuti1
@krishnakatikuti1 Жыл бұрын
Thnq
@SureshKumar-no3eo
@SureshKumar-no3eo Жыл бұрын
very informative, Hi Sir Your vedios are very good and helpful for us.
@neworacle-eo7hr
@neworacle-eo7hr Жыл бұрын
Great
@hallkbrdz
@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
@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
@asifomer4349 Жыл бұрын
plz share the video of stand by db
@bobsukki
@bobsukki 6 ай бұрын
Here you go... kzbin.info/www/bejne/m2TVamqYaqhld5Y
@parasharampakhari1583
@parasharampakhari1583 Жыл бұрын
Great video bro keep on uploading new videos on Oracle DB
@bobsukki
@bobsukki 6 ай бұрын
Thank you!
@swat222
@swat222 2 жыл бұрын
Can you also make a video on rman refresh when source and target is container database consisting of single pdb ?
@swat222
@swat222 2 жыл бұрын
Thank you very much for this video...Can you also make one on setting PGA using advisor
@anandkanawade9895
@anandkanawade9895 2 жыл бұрын
Excellent videos.m please make a course on 19c multenant on udemy or youtube
@bobsukki
@bobsukki 6 ай бұрын
I appreciate your suggestion, it will be an absolutely great idea! Thank you
@शिवमआर्य-व4य
@शिवमआर्य-व4य 2 жыл бұрын
THANKS🙂
@paradizecracked
@paradizecracked 2 жыл бұрын
i thought we should also create logfile thread 2 and undotbs2 on primary...
@abukanu1614
@abukanu1614 2 жыл бұрын
You're absolutely one of the best I've ever watched.
@bobsukki
@bobsukki 6 ай бұрын
Thank you! I appreciate
@SpeedTex
@SpeedTex 2 жыл бұрын
Fantastic! Could you please do an extensive video on "Performance Tuning?" maybe with OEM 13.5 cloud or alternatives. Thank you so much.
@ihanyariole2935
@ihanyariole2935 2 жыл бұрын
Simple and straigthforward .. great info
@SpeedTex
@SpeedTex 2 жыл бұрын
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
@bobsukki
@bobsukki 2 жыл бұрын
You're very welcome!
@SpeedTex
@SpeedTex 2 жыл бұрын
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
@SpeedTex
@SpeedTex 2 жыл бұрын
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. :)
@veransobrian8697
@veransobrian8697 2 жыл бұрын
Amazing. love it. Why dont you source those parameters from the bash_profile?
@bobsukki
@bobsukki 2 жыл бұрын
I could, but i usually don't prefer using the bash_profile when I plan on having multiple databases running on thesame server
@veransobrian8697
@veransobrian8697 2 жыл бұрын
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.
@bobsukki
@bobsukki 2 жыл бұрын
Noted
@SilvermanWKWK
@SilvermanWKWK 2 жыл бұрын
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
@bobsukki
@bobsukki 2 жыл бұрын
Sorry I am getting to you late... Do you still have this issue going on?
@jeevankuntla
@jeevankuntla 2 жыл бұрын
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 ?
@bobsukki
@bobsukki 2 жыл бұрын
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
@nsar006
@nsar006 2 жыл бұрын
very nicely explained and very much informative
@bobsukki
@bobsukki 2 жыл бұрын
Glad it was helpful!
@fabianalbertoloerasalas659
@fabianalbertoloerasalas659 2 жыл бұрын
is it just enough if I exclude just SYS and SYSTEM schemas?
@bobsukki
@bobsukki 2 жыл бұрын
Yes you can! 👌🏽
@akinsmedia77
@akinsmedia77 2 жыл бұрын
I enjoyed this video. valued added, you made my day
@bobsukki
@bobsukki 2 жыл бұрын
Glad you enjoyed it!
@MA-lo4xk
@MA-lo4xk 2 жыл бұрын
Should we be doing export and import as sysdba? I thought oracle does not recommend this?
@bobsukki
@bobsukki 2 жыл бұрын
Yes we can, it depends, especially when I am doing a Full=Y. Otherwise, use the SYSTEM user
@MA-lo4xk
@MA-lo4xk 2 жыл бұрын
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
@bobsukki
@bobsukki 2 жыл бұрын
You could do that too.
@MA-lo4xk
@MA-lo4xk 2 жыл бұрын
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
@bobsukki
@bobsukki 2 жыл бұрын
Yes, absolutely
@ChetanVithlani
@ChetanVithlani 2 жыл бұрын
Great insights, thanks for sharing!
@bobsukki
@bobsukki 2 жыл бұрын
Thank you always Chetan!
@thuynghiem8602
@thuynghiem8602 2 жыл бұрын
I don't show out the information of sensitive data in Discoverer, can you help me with this section?
@bobsukki
@bobsukki 2 жыл бұрын
Send me an email so we can find some time to connect and walk through
@thuynghiem8602
@thuynghiem8602 2 жыл бұрын
@@bobsukki I send
@SANDATA764
@SANDATA764 2 жыл бұрын
Sir The steps was very clear Much respect Please more videos on performance tuning , read awr, reading execution plan and sql tuning
@bobsukki
@bobsukki 2 жыл бұрын
Sure I will. Thank you
@aniketbanerjee6377
@aniketbanerjee6377 2 жыл бұрын
Does it requires downtime while going conversion .If no will it impact any new connection or existing connection ?
@bobsukki
@bobsukki 2 жыл бұрын
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
@SANDATA764
@SANDATA764 2 жыл бұрын
Respected Sir Your steps are very clear Thanks
@bobsukki
@bobsukki 2 жыл бұрын
Thank you Salad, I am glad you found it helpful!
@SANDATA764
@SANDATA764 2 жыл бұрын
@@bobsukki respected sir I can't wait your upcoming videos
@SANDATA764
@SANDATA764 2 жыл бұрын
Man you are doing great job A big thanks to sir
@bobsukki
@bobsukki 2 жыл бұрын
Thanks and welcome
@SANDATA764
@SANDATA764 2 жыл бұрын
Man you are doing great job Please do more videos on oracle performance tuning Please and please
@bobsukki
@bobsukki 2 жыл бұрын
Certainly, I will be making short performance tuning videos as requested!