Oracle - Understanding the tnsnames.ora and listener.ora files

[@gajendra1987]

Please post more videos like this for beginners as well. You have got a great skill of explaining complex things in a simple way

[@ricardogomez4073]

It's a shame I need this video in 2022. Oracle is literally the worst.

[@rafiksmith1483]

Oracle is a shame

[@satrinakelley-jordan6418]

Great video extremely easy to understand and follow along. Thanks for sharing!

[@jsaldana1976]

Awesome followed your steps and got my Client Server communication working properly.

[@yesseniacollazo7729]

Great video, very helpful. You make the information easy to understand!

[@ergogray3143]

Please make a video about the SQLNET.ORA file, thanks.

[@manojkumarporandla7707]

Thank you bro... I never found these much stuff.. I searched lot

[@abhinavshilwant9040]

where do I get this 'Oracle Net Configuration assistant' Option??

[@mrgenius166]

Gud. You solve my problem. Thanks bro alway be happy...😊

[@dehorian_stories]

Best video ever! Awesome!

[@beovp91]

great video !
is there something called "ldap" replaces the tnsnames.ora file?

[@bloswoodltd7917]

Thank you very much for the explanation

[@gooddeedsleadto7499]

Lsnr.ora or listener is on the server then why does it exist in the c drive on the client? Thanks
Just like tnsnames.ora is also supposed to exist on client & it is there under c: drive.
Kindly clarify.

[@albertsamigullin4916]

Hi!
Thank's for the video and explanation. But i didn't understand what is the main difference btw tnsnames.ora and listener.ora?

[@shivanigupta6027]

Can TNS alias names have dot (.) in them , like in your example it shows SANDBOX .. can it be SANDOX.1 ? and will that work

[@kaviviswa]

Nicely explained. Thank u very much. Kindly, post more videos.

[@manzoor5554]

Very nice explanation.. done thanks...

[@danielharoldmateo3926]

this is so awesome.! got mine fixed!!

[@ayoob999]

thank you very much for your help ....if you have any method for trouble shooting...Oracle

[@lifechamp007]

Very helpful and informative, Thank you.

[@harshithdarla875]

Excellent help 🙏

[@shrutigupta7281]

Which option in database shows .odp extention

[@shrutigupta7281]

Menu bar
Title bar
Tool bar
??

[@Aloysius1966]

Ah, so that's how it works :-)
Requested video: I am trying to configure a client server connection without installing the Oracle client software on the PC. I currently have Oracle SQL Developer working but cannot get SQL*Plus to work. I've tried setting up the Oracle InstantClient with the base + SQL*Plus module but still get various errors when trying to connect via SQL*Plus.
Do I even need a tnsnames.ora in this scenario, etc.?

[@BirhanNega]

Like it

[@shubhamsinghrawat283]

Thanks alot sir it was helpful for me..

[@nadirelyass1954]

Many thanks
It really helped me alot

[@cathymontowski1263]

Nice job Chris

[@MKMK-jb4hq]

you could have shared real underlying action
from clinet application reading tnsnames.ora and sending request to server where listener get the request and routes it to the oracle server process. Without this kind of info, I can not even configure. Anybody can put the entry in wizard, what is needed is full understanding. Thanks

[@abhishekpoudel500]

now it's up to u to make that video

[@gajendra1987]

thanks, very nice explanation

[@syedmohib7726]

thanx for good & clear explanation :)

[@lbonillaluna76]

Hola gringo, soy de peru me puedes ayudar..Speked Spanish?

[@JHId168]

Hi I just installed Oracle 12.1.0, but i dont have the tnsname.ora, listener.ora in the NETWORK/ADMIN folder. Any ideas as to what i can do?

[@BlackAssasin]

you can just create empty text files and fill them with info based on this video, or perhaps you can find some example files on the oracle web or so. But they must have correct names. Or you can create listener and tnsnames entries via oracle tools if you have graphic interphace available

[@nandiniagarwal8561]

Same issue have u done this

[@JHId168]

@@nandiniagarwal8561 I followed Potkaniak advise and created empty text files.. try that and see if that helps

[@nandiniagarwal8561]

@@JHId168 having tnsnames file having sid if still is throwing the error

[@padmanabanarumugam774]

superb viedio ...

[@dinhngocpham6177]

I connect oracle on local but i get error "ORA-12528: TNS:listener: all appropriate instances are blocking new connections" anyone can help me?

[@ahmedalhadedy1]

That was helpful..thanks :).

[@abhishekpoudel500]

Thanks man!!!

[@ziadfawzi]

Thank you.

[@oshadac]

This was helpful..thanks! :)

[@farazahmed82]

Great! thanks sir :o)

[@ernestledo341]

very helpful

[@syedkhurram8410]

Nice

[@jessicasnowden9126]

This part!

[@jithinshaji3252]

Thanks

[@jeanrodrigues6249]

Kernel

[@68MRINAL]

thanks...

[@axyytube]

1521 def port