Oracle Database - Listener Process - DBArch Video 6

[@DhaSrma]

You're really awesome but remove background music.

[@zeio-nara]

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

[@RamkumarSwaminathan]

Thanks... Enjoy learning

[@konarehb]

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 😃

[@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...

[@keshavasubramanyam9712]

Excellent Explanation RamKumar Sir

[@RamkumarSwaminathan]

Enjoy learning

[@FG-nu9oc]

Please add the translation file

[@ayseak_]

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

[@mohammedrahilshaikh2945]

Remove background music please

[@masruralam6199]

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

[@DauntlessRony85]

If possible please remove the background music from All videos.

[@RamkumarSwaminathan]

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

[@Junnuu3159]

Great teaching

[@chanakyapati7057]

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

[@dalipkhurana7348]

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

[@rajwardhan100]

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

[@RamkumarSwaminathan]

Thanks... Enjoy Learning

[@DaniloSouzaMoraes]

Very nice series! The music though...

[@RamkumarSwaminathan]

Enjoy Learning...

[@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.

[@jayakrishnachanumuru]

Thank you so much sir

[@sivaveeramallu3645]

Excellent Sir..Please upload more videos

[@dinodixit_traveller]

very good explanation...thank you sir.

[@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.

[@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.

[@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

[@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

[@manzoor5554]

Good Explanation..done...

[@ziadfawzi]

Thanks a lot.

[@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...

[@murtazarasool6395]

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

[@elmokhliss4852]

Thank you

[@tirupatiraoyegireddi2575]

Nice Sir..

[@bharathk1348]

explanation is good but background music not suggestible

[@SaurabhRelia]

Respects

[@Bruh-jw2ze]

Background music 😭😭😭

[@emilton0548]

Genius

[@hrithikjain7326]

please remove tha background music

[@shakthi3331]

Music is irrigating

[@rkcgadgetstech8396]

Please remove background music...

[@ArshadKhan-xb3sz]

Please remove the background music as it is so irritating 😢

[@heenagarg1632]

kindly remove this background music

[@yashpatil8334]

Why this irritating bg music

[@sa_vines01]

Background music lga ke video ka bawasir bna diya

[@srajanjain2541]

HATE BACKGROUD MUSIC.

[@nisrinalsaddy9073]

You're really awesome but remove background music.