Very well explain. Thank you. But I have one concern please if you can help. I am enrolled in your performance tuning course, but the SwingBench can't connect to the ORADB. I can connect to the database using the command promt. Should it be that there is specific package I need to use SwingBench? Please advice. I am using the "Driver Type: Oracle oci Driver" as specified in the cource.
Hi Thanks for the video ! After installing Oracle Client, my date format was corrupted. I am getting "not a valid month" error in my SQL query in Excel. How can I change the date format of ocmt?
I am not sure what exactly you tried to do, but generally speaking I can advise you to set the NLS_DATE_FORMAT variable before starting your program (like Excel). For example, in Windows, you can open a terminal window and type SET NLS_DATE_FORMAT='DD/MM/YYYY' and then run the program from the same terminal window. You can also set this variable in the regedit under Oraclehome node.
dear sr. after performing your instructions when runing the sqlplus, I receive an error : ORA-12545: Connect failed because target host or object does not exist. Can you help identify the issue
@@AhmedBarakaDBA Thank you for you reply, but I can ping the dbserver from client and visesersa. I am using RedHat 8.6 Enterprice nd Oracle 18c XEas the db with oracle instantclient 18.6, are dose compatible?
Hi sir For Oracle 12c client installation same procedure follow right? Whether we needs to set any kernal parameters and disable selinux? For client installation in client server
Thank you very much, sir! I've purchased one of your courses and I'm really enjoying the learning process.
You are very good teacher... I was struggling to learn this thing from one week and you made me learn in 30 minutes thanks a lot God bless you.
Ahmed has set the bar high for all Tech instructors out there.
Dear sir i am regularly read and watch your blogs & video
There has never been a better tutorial
Clear, simple, to the point. Everything educational video should have to be useful. Thank you
Best guide so far, thank you Sir.
Please include a video to add tnsping testing utility in the instance client ????? Thank you...
Mr Baraka please let me know how to get in touch with you. I am hoping you still teach Oracle DBA classes. Thank you
Very good guide. Thanks a lot.
Very well explain. Thank you. But I have one concern please if you can help. I am enrolled in your performance tuning course, but the SwingBench can't connect to the ORADB. I can connect to the database using the command promt. Should it be that there is specific package I need to use SwingBench? Please advice. I am using the "Driver Type: Oracle oci Driver" as specified in the cource.
Please submit your question in the Q&A page of the course. Try connecting to the database using easy connect method: ///:1521
@@AhmedBarakaDBA Thank you for your prompt response
Great video. Thanks for sharing.
Can you please create a video for Adding Odbc Drivers for Windows
Hi Thanks for the video ! After installing Oracle Client, my date format was corrupted. I am getting "not a valid month" error in my SQL query in Excel. How can I change the date format of ocmt?
I am not sure what exactly you tried to do, but generally speaking I can advise you to set the NLS_DATE_FORMAT variable before starting your program (like Excel). For example, in Windows, you can open a terminal window and type SET NLS_DATE_FORMAT='DD/MM/YYYY' and then run the program from the same terminal window. You can also set this variable in the regedit under Oraclehome node.
dear sr. after performing your instructions when runing the sqlplus, I receive an error : ORA-12545: Connect failed because target host or object does not exist. Can you help identify the issue
Use tnsping to make sure the tnsnames.ora name that you use to connect to the database is working.
@@AhmedBarakaDBA No, it is not working on the client side
@@enriquebarbosa9580 then most likely you have a network issue. Try pinging the host name, if the ping fails, it is definitely a network issue.
@@AhmedBarakaDBA Thank you for you reply, but I can ping the dbserver from client and visesersa. I am using RedHat 8.6 Enterprice nd Oracle 18c XEas the db with oracle instantclient 18.6, are dose compatible?
through php how can connect to oracle in linux centos 7
plz create your playlist on database administrator I want to become database administrator help me
I am working on a course for beginners. Cheers!
Please share the document
Look at the video description pleaase.
@@AhmedBarakaDBA thank you very much
Best in the industry you are
Hi sir
For Oracle 12c client installation same procedure follow right?
Whether we needs to set any kernal parameters and disable selinux? For client installation in client server
Yes the same.
Remember, this is Oracle database INTANT Client.... Not Client software. As explained in the video.