Oracle Database - Listener Process - DBArch Video 6

You will learn about the Oracle Listener, The purpose of Listener and what is the impact if its down...
Our Upcoming Online Course Schedule is available in the url below
docs.google.com/spreadsheets/...
Reach us at [e-mail]

[@DhaSrma]

You're really awesome but remove background music.

[@badiehamidoukonare]

You're amazing Sir. Your explanation is so clear, simple and understandable. With this course, i'm really understanding the architecture of oracle database 😀😀😀.

[@syedyasirali3340]

Sir, thankyou so much for sharing everything by making it super easy.
May Allah bless you, Aameen.

[@nilanjandas7416]

Sir, you are awsome. The way use explain with examples, is really fantastic. God bless you 😃

[@zeio-nara]

Thank you for explanations! It is much better than explanations made by teachers in my university.

[@RamkumarSwaminathan]

Thanks... Enjoy learning

[@legkoszkur]

thx men such great and clear presentation, i'm sure that you will made huge success as teacher

[@balakotireddy7006]

Very neatly explained Thank you so much...

[@masruralam6199]

amazing explanation Sir, thanks from my heart . It's difficult to concentrate due to backgound music.

[@ayseak_]

Thanks for your step by step explanation) But please, don't put this background music, it distracts attention...

[@dinodixit_traveller]

very good explanation...thank you sir.

[@sivaveeramallu3645]

Excellent Sir..Please upload more videos

[@Junnuu3159]

Great teaching

[@keshavasubramanyam9712]

Excellent Explanation RamKumar Sir

[@RamkumarSwaminathan]

Enjoy learning

[@rajwardhan100]

you are pretty awesome sir..thank you for this information

[@RamkumarSwaminathan]

Thanks... Enjoy Learning

[@ziadfawzi]

Thanks a lot.

[@manzoor5554]

Good Explanation..done...

[@elmokhliss4852]

Thank you

[@tirupatiraoyegireddi2575]

Nice Sir..

[@DaniloSouzaMoraes]

Very nice series! The music though...

[@RamkumarSwaminathan]

Enjoy Learning...

[@DauntlessRony85]

If possible please remove the background music from All videos.

[@RamkumarSwaminathan]

Noted...not having bg music in new videos uploaded

[@murtazarasool6395]

Amazing learning, but Background noise (music) is a real distraction.

[@FG-nu9oc]

Please add the translation file

[@MsFrry]

Hi, Great video, I really like it. One question about listener and network connections: lets assume that listener is running on default port 1521 and application tries to connect using source port 11000 (for example). TCP connection for db connection request is: 11000 (source) 1521 (dst). Now, when db connection is established, and listener doesn't take part in communication between application and server process - this is still the same TCP connection (on the same ports)? If i understand well - there is no new TCP connection established here?

[@dalipkhurana7348]

Such a good question, i hope sir answer this , so that this doubt may be cleared.

[@dalipkhurana7348]

Sir is it LREG or PMON who registers an instance with the listener??

[@emilton0548]

Genius

[@sivakumarayachitula6469]

Can you tell me what is the use of another local listener though we have one default listener which handles the connection request?

[@RamkumarSwaminathan]

Local listener is that one that is used locally... it may be configured as the default listener or any other listener.

[@chanakyapati7057]

Sir, is this possible if two or more listeners is setup in Oracle home

[@latharupert389]

suppose a connection is already established, after that the listener stopped will that connection still works?

[@RamkumarSwaminathan]

Yes, a connection once established continues to exist irrespective of the status of the listener

[@SaurabhRelia]

Respects

[@syedanoorumar1419]

Authentication is done by listener or server process?what about password file authentication, who does this in case of sysdba connection and database instance is not started?The server process for a client connection request gets started before it's authentication or after aunthentication.? Please clear it

[@dalipkhurana7348]

Servers process is responsible to authenticate user, listener has no role in it, it is just like an auto driver he dropped u to your destination but don care if the work for which you went there was successful or not. Now Suppose user authentication failed(due to bad pwd or anything) user ll be prompted abt this and connection will be dropped and resources occupied by server process 'll be freed.

[@mohammedrahilshaikh2945]

Remove background music please

[@rahidzeynal]

Hi Sir, I have a question: Let's assume we connected DB instance by listener and after that we say that listener is out of the way. But what wil happen if our listener "goes down"? Would we be able to do our processes ? Thanks beforehand.

[@dalipkhurana7348]

Once we r connected to the database, our connection to the database is created successfully. Listener goes up , it goes down we don care, coz our connection will not be impacted just no new users will be able to connect to instance till listener is brought up again.

[@rahidzeynal]

@@dalipkhurana7348 thanks for reply

[@tarunbhardwaj7967]

who will spawn server process for application connection request ? Is it Listener or PMON process, as I somewhere study that listener with help of PMON will authenticate the request and create server process, means there is PMON after listener in hierarchy ...Please confirm.

[@syedanoorumar1419]

Even I have the same doubt

[@devwratkumar2808]

Yes Right listener once receive connection transfer it to pmon.

[@latharupert389]

could you please explain what is local and remote listener?

[@RamkumarSwaminathan]

It's used in RAC to take care of load balancing between instances on different nodes by redirecting requests to another node

[@RamkumarSwaminathan]

I have given a brief reply already

[@harishap2772]

Please stop the background music Sir. contents are not clear and technical details are not clearly heared.

[@RamkumarSwaminathan]

Thanks for the feedback.. shall take care in future videos...

[@shakthi3331]

Music is irrigating

[@bharathk1348]

explanation is good but background music not suggestible

[@Bruh-jw2ze]

Background music 😭😭😭

[@hrithikjain7326]

please remove tha background music

[@rkcgadgetstech8396]

Please remove background music...

[@yashpatil8334]

Why this irritating bg music

[@heenagarg1632]

kindly remove this background music

[@ArshadKhan-xb3sz]

Please remove the background music as it is so irritating 😢

[@srajanjain2541]

HATE BACKGROUD MUSIC.

[@nisrinalsaddy9073]

You're really awesome but remove background music.