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.
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.?
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
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
Please post more videos like this for beginners as well. You have got a great skill of explaining complex things in a simple way
It's a shame I need this video in 2022. Oracle is literally the worst.
Oracle is a shame
Great video extremely easy to understand and follow along. Thanks for sharing!
Awesome followed your steps and got my Client Server communication working properly.
Great video, very helpful. You make the information easy to understand!
Please make a video about the SQLNET.ORA file, thanks.
Thank you bro... I never found these much stuff.. I searched lot
where do I get this 'Oracle Net Configuration assistant' Option??
Gud. You solve my problem. Thanks bro alway be happy...😊
Best video ever! Awesome!
great video !
is there something called "ldap" replaces the tnsnames.ora file?
Thank you very much for the explanation
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.
Hi!
Thank's for the video and explanation. But i didn't understand what is the main difference btw tnsnames.ora and listener.ora?
Can TNS alias names have dot (.) in them , like in your example it shows SANDBOX .. can it be SANDOX.1 ? and will that work
Nicely explained. Thank u very much. Kindly, post more videos.
Very nice explanation.. done thanks...
this is so awesome.! got mine fixed!!
thank you very much for your help ....if you have any method for trouble shooting...Oracle
Very helpful and informative, Thank you.
Excellent help 🙏
Which option in database shows .odp extention
Menu bar
Title bar
Tool bar
??
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.?
Like it
Thanks alot sir it was helpful for me..
Many thanks
It really helped me alot
Nice job Chris
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
now it's up to u to make that video
thanks, very nice explanation
thanx for good & clear explanation :)
Hola gringo, soy de peru me puedes ayudar..Speked Spanish?
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?
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
Same issue have u done this
@@nandiniagarwal8561 I followed Potkaniak advise and created empty text files.. try that and see if that helps
@@JHId168 having tnsnames file having sid if still is throwing the error
superb viedio ...
I connect oracle on local but i get error "ORA-12528: TNS:listener: all appropriate instances are blocking new connections" anyone can help me?
That was helpful..thanks :).
Thanks man!!!
Thank you.
This was helpful..thanks! :)
Great! thanks sir :o)
very helpful
Nice
This part!
Thanks
Kernel
thanks...
1521 def port