Introduction to Oracle Listener

The #Oracle #listener is a service that runs on the #database host and receives requests from Oracle clients. Sometimes the listener forwards requests to the database #server, and sometimes it redirects the client somewhere else where the database server listens for dedicated connections. In either case, it is the first point of contact for the client.
The Oracle listener is the front door to your database. Lock the door by configuring it to require a password. Before 10 g it was unlocked by default, so be sure to check your older database servers.
0:00 Introduction to Oracle Listener
1:31 How Database Connection Happen in a normal oracle Database?
6:16 Working with Oracle Listener
8:27 Oracle Listener Configuration
Website: www.dbagenesis...
Facebook: / dbagenesis
Instagram: / dbagenesis
Twitter: / dbagenesis

[@dbelcher]

Another excellent explanation. Thanks for all of your videos - they are very helpful!

[@dbagenesis]

Thanks! we will keep uploading new videos

[@syedauzma1686]

Very much helpful. Configuration was explained clearly.

[@dbagenesis]

Thank you!

[@zohazaidi2532]

very helpful and easy to understand

[@dbagenesis]

Glad it was helpful!

[@koushikbadhri743]

This is a great video even a layman can understand easily. Great. If it's possible to post such a video for scan, vip and listeners in a RAC, should be even more helpful.

[@channel777ism]

Thanks, well explained especially the config of listener.ora

[@dbagenesis]

Thank you! keep watching

[@socksumi]

I have an Oracle turntable which I listen to all the time.

[@sivakumarm8033]

very informative and well explained.

[@dbagenesis]

Keep Watching

[@latharupert389]

could you please explain about local and remote listener?

[@venkateshpitta4898]

I have a question,If the subnetmask address is provided to router is 255.255.255.0 then it can only share the connections of 254.So if we make our laptop as shared router,Then could we get the connections of again 255 or not.

[@matthewespindola3694]

Excellent explanation, thank you.

[@dbagenesis]

Thank you!

[@user-jh6bt1ve5v]

Where does he tipe commands

[@harshrajput5099]

Perfect (Y).

[@chanakyapati7057]

Is this possible if two or more listeners can be setup in Oracle home

[@dbagenesis]

www.support.dbagenesis.com/post/listener-and-tnsnames#viewer-3l3ad

[@vishnuk5092]

Sir,
Suppose, there are 200 users connected to the database and if suddenly listener goes down. What will Happen? Please Explain Sir!

[@AlphaLegionXX]

He said there would be no problem to already established connections. The only problem would be new ones. 1:50 - 2:11

[@akankshakaul744]

can u plz explain established refused parameters in lsnrctl status command

[@Devendrasingh-ct8jn]

Woww thanks

[@dbagenesis]

Glad you like it!

[@ziadfawzi]

Thank you.

[@dbagenesis]

Welcome!

[@sirajalshami6425]

'lsnrctl' is not recognized as an internal or external command, operable program or batch file.

[@abdifatahkhalif431]

you must be in oracle user to execute lsnrctl command.

[@mohdsaqib2796]

Display sentence is hiding to document content... It is irritated... Remove please it.... DBA Genesis is great... But today your subtitle is very disturbance on document content... What exact is written... Please remove this.
Thanks