HomeНаука и техникаRelated VideosMore From: Chris Ostrowski

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

424 ratings | 194341 views
Oracle - Understanding the tnsnames.ora and listener.ora files
Html code for embedding videos on your blog
Text Comments (36)
axyytube (1 month ago)
1521 def port
Manzoor (1 month ago)
Very nice explanation.. done thanks...
Abhishek Poudel (2 months ago)
Thanks man!!!
Dinh Ngoc Pham (3 months ago)
I connect oracle on local but i get error "ORA-12528: TNS:listener: all appropriate instances are blocking new connections" anyone can help me?
Good DeedsLeadTo (5 months ago)
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.
Ernest Ledo (5 months ago)
very helpful
Hi! Thank's for the video and explanation. But i didn't understand what is the main difference btw tnsnames.ora and listener.ora?
ziad fawzi (1 year ago)
Thank you.
JHId168 (1 year ago)
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?
Potkaniak (1 year ago)
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
Nadir Elyass (1 year ago)
Many thanks It really helped me alot
Syed Khurram (1 year ago)
Padmanaban Arumugam (2 years ago)
superb viedio ...
Juan Saldana (2 years ago)
Awesome followed your steps and got my Client Server communication working properly.
anil kumar (2 years ago)
Very helpful and informative, Thank you.
Daniel Harold Mateo (2 years ago)
this is so awesome.! got mine fixed!!
Best video ever! Awesome!
Brian O'Connor (3 years ago)
great video ! is there something called "ldap" replaces the tnsnames.ora file?
Ayoob manker (3 years ago)
thank you very much for your help ....if you have any method for trouble shooting...Oracle
Bloswood Ltd (3 years ago)
Thank you very much for the explanation
Mahendra Kothari (4 years ago)
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
Abhishek Poudel (2 months ago)
now it's up to u to make that video
Ergo Gray (5 years ago)
Please make a video about the SQLNET.ORA file, thanks.
Cathy Montowski (5 years ago)
Nice job Chris
Mrinal Joshi (5 years ago)
Oshada Samarasinghe (5 years ago)
This was helpful..thanks! :)
Ahmed Alhadedy (5 years ago)
That was helpful..thanks :).
Marin Petkov (5 years ago)
thank you man now i understand everything for tnsnames.ora saving hours in searching and reading
Martin TFREE (6 years ago)
I put TNSNAMES.ORA on a shared folder and use environment variable TNS_ADMIN to point to it. That way changes to TNSNAMES.ORA can be managed in one place.
syed mohib (6 years ago)
thanx for good & clear explanation :)
kavitha viswanathan (6 years ago)
Nicely explained. Thank u very much. Kindly, post more videos.
Aloysius1966 (6 years ago)
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.?
Birhan Nega (1 year ago)
Like it
Gajendra Choudhary (6 years ago)
Please post more videos like this for beginners as well. You have got a great skill of explaining complex things in a simple way
Gajendra Choudhary (6 years ago)
thanks, very nice explanation
faraz siddiqui (7 years ago)
Great! thanks sir :o)

Would you like to comment?

Join YouTube for a free account, or sign in if you are already a member.