Why Set TNS_ADMIN in Oracle!

Find out how you can keep #tnsnames.ora and #listener.ora files in a central location which can be accessed by multiple #Oracle Homes!
Website: www.dbagenesis...
Facebook: / dbagenesis
Instagram: / dbagenesis
Twitter: / dbagenesis

[@AMANYadav-gq6wi]

Sir the way you explain was fantastic I am not an professional but just a beginner but still got each and every words said by you Thanks for sharing this session with us

[@rajatsanwal9919]

yet again a quality tutorial from Arun. 🙏

[@dbagenesis]

Glad you think so!

[@thegoodthinker8520]

Nice to see you after so long

[@ashadahiya5208]

Thank You so much, Sir! I must say no one can explain better than you. You did a great job. Thanks for sharing your knowledge with us.

[@dbagenesis]

You are most welcome

[@okaily7263]

Really thank you for sharing your experience with us , that's so generous from you . Wish you the best in your work

[@dbagenesis]

My pleasure!

[@kanhaiyasharma1632]

Big Fan Arun...you are great. Thanks for creating amazing courses..

[@yatheeshkumar294]

awsome am really become a fan arun... thanks a lot

[@dbagenesis]

Welcome! Keep watching

[@ManojYadav-lw8tu]

Good explanation Arun .about Listener and Tns file , this is very helpful .

[@dbagenesis]

Glad you liked it

[@The_purple_life]

Sir your videos are so impressive😊

[@padmajarani9392]

Valuable information thnk u Arun

[@dbagenesis]

Welcome! Keep Watching!

[@intakhabalam8252]

Awesome hair style 👍

[@Silverdragon517]

The problem with this is when in future if old oracle home is uninstalled, the listener and tnsnames files will be gone. It would make more sense to user a 3rd location for this outside oracle homes if we plan to use a common listener and tns file

[@yuabr]

Thanks Arun!

[@ngsekhar52]

Really this is Awesome sos 😍😍.. thanks for the knowledge sharing we will apply next time this in real-time upgrades.

[@noushadahamad293]

Hii sir, without wasting your valuable time to praise you i directly come to the topic. Sir i want a complete lecture on tkprof utility with lab activities means complete explanation with queries on real time environment. I have lack of words to praise you.

[@dbagenesis]

Noted, will publish video on tkprof

[@nagababutalasila5023]

Hi sir....i hope you are having a great week If possible can you please make a video on streams and queues......

[@sohith7955]

Thank you!

[@shayansarkar7570]

Hi Arun- Can you please make a video on migration of Oracle to PostgreSQL ? Well a broader topic but would be helpful to DBA's.

[@lavanyathiurvengadam5818]

thank you so much Arun..this video really helped me to understand much better. May I request you to please put a video regarding why oracle DBMS stat used and also please put a video difference between oracle 19c and oracle 12 c.and also why we have to upgrade to 19c db from 12c db..if you make this video for above questions,it would really helpful for me..thanks in advance

[@phanikumaradventures7576]

Sir, how to import unknown dump file .Without log file.? Sir plz explain i faced this question in 2 interviews.

[@yassersayed5009]

Hi, Can you please explain how we can restore the control files that has been taken by hot-backup. "alter database backup controlfiles to 'path' "

[@dbagenesis]

Please post it on forum.dbagenesis.com

[@bharathkumar-ds8cd]

good session.

[@mohdumair7539]

Hi , In RAC can we setup 1 Node with Auto Undo and on other node without Auto Undo? Is it possible and any impact by doing this or it is good option to do or not? Please answer this it is asked to me in one interview

[@AltafHussain-hy6fo]

Hello please make video on oracle instance tuning

[@dbagenesis]

Noted

[@zahidmemon8937]

Sir i have just started my career in Oracle DBA hoping for good future it has only been a month..Any suggestions for me.??

[@ramur226]

Hairstyle super

[@jasminnadaf6747]

@arun, Hello sir, please suggest me Is HP z400 workstation (Intel Xeon w3565 processor and 16gb ddr3 RAM) good for practicing environment (dataguard, RAC, Golden gate)??? As I am looking for a budget desktop for practicing dataguard and RAC at home.

[@dbagenesis]

More than enough, infact any processor above i7 is good! Try to go with more RAM, like 32 GB and it will be cakewalk for you to practice even OEM!

[@jasminnadaf6747]

@@dbagenesis thanks a lot 😊. You are a savior 👍👍

[@jasminnadaf6747]

@@dbagenesis if I go with i7 which generation should I take, please tell me

[@MDShahid-uo8ne]

1) Listener is running fine ,DB is up and running fine, user have all the privileges to connect, but he is not able to connect to the db, he is getting tnsora error 2)Prod to non prod refresh, a copy of prod dump backup need to be send to non prod db to import the data..but here the scenario is file system has no space available

[@itzmaaz6609]

One video make on virtual machine how to connect wifi plz..

[@dbagenesis]

Its already covered in our free course LINUX ADMINISTRATION FOR BEGINNERS on our website dbagenesis.com