Which statement is true about Oracle Net Listener?

Which statement is true about Oracle Net Listener?

Which statement is true about Oracle Net Listener?

A.
It acts as the listening endpoint for the Oracle database instance for all local and non-local user
connections.

B.
A single listener can service only one database instance and multiple remote client
connections.

C.
Service registration with the listener is performed by the process monitor (PMON) process of
each database instance.

D.
The listener.ora configuration file must be configured with one or more listening protocol
addresses to allow remote users to connect to a database instance.

E.
The listener.ora configuration file must be located in the ORACLE_HOME/network/admin
directly.

Explanation:
Supported services, that is, the services to which the listener forwards client
requests, can be configured in the listener.ora file or this information can be dynamically registered
with the listener. This dynamic registration feature is called service registration. The registration is
performed by the PMON process—an instance background process—of each database instance
that has the necessary configuration in the database initialization parameter file. Dynamic service
registration does not require any configuration in the listener.ora file.
Incorrect:
Not B: Service registration reduces the need for the SID_LIST_listener_name parameter setting,
which specifies information about the databases served by the listener, in the listener.ora file.
Note:
*Oracle Net Listener is a separate process that runs on the database server computer. It receives
incoming client connection requests and manages the traffic of these requests to the database
server.
* A remote listener is a listener residing on one computer that redirects connections to a database
instance on another computer. Remote listeners are typically used in an Oracle Real Application
Clusters (Oracle RAC) environment. You can configure registration to remote listeners, such as in
the case of Oracle RAC, for dedicated server or shared server environments.



Leave a Reply 24

Your email address will not be published. Required fields are marked *


Shawn

Shawn

Definitely not C!

In Oracle 12c, the LREG (Listener REGistration) process will register services with the listener.

ruby

ruby

So, which is the correct answer??

Shawn

Shawn

As far as I’m concerned, all the answers are wrong for Oracle 12c!

A is wrong because you can make local connections without going through a listener.

B is wrong because many databases can register with a listener.

C would be right for versions prior to 12c. But for 12c, it’s wrong!

D is wrong because you don’t have to configure a listening protocol address(es) in listener.ora. If not specified, it will simply default to TCP port 1521.

E is wrong because Oracle will also look in $TNS_ADMIN directory or /etc.

praveen

praveen

Shawn,
I agree with you all of the are wrong.

pkg

pkg

I go with C presuming its a question from Key DBA Skills section.

Zaz

Zaz

In exam it shows LREG instead of PMON, so answer is C

-

-

yes, exam shows LREG, so it’s C

Ranjit

Ranjit

will go with C

Djuro

Djuro

Answer is C.
But option C is a little bit different:
C. Service registration with the listener is performed by the listener registration process monitor (LREG) process of each database instance.

Reference:
http://docs.oracle.com/database/121/NETAG/listenercfg.htm

Sylvain

Sylvain

Hi all,

anyone would have the “dump” of this test and could give me a link on how to use it ? I must go on it in 2 days and I discovered only yesterday evening this site…

Ravinder

Ravinder

I think Correct answer is D.

If the SECURE_REGISTER_listener_name parameter is configured with the list of transport names, only the connections arriving on the specified transports will be able to register the service with the listener. The connections arriving by other transport protocols are refused. For example:

SECURE_REGISTER_listener1 = (TCPS, IPC)

In the preceding example, registration requests are accepted only on TCPS and IPC transports.

If no values are entered for this parameter, the listener accepts registration requests from any transport.

xander

xander

The answer is C: The exam answer have changed from PMON to LREG

how to create an app

how to create an app

always a big fan of linking to bloggers that I enjoy but dont get a great deal of link appreciate from

smart repair

smart repair

that would be the end of this report. Here youll locate some web-sites that we think youll appreciate, just click the links over

Free Games download

Free Games download

Here is a good Weblog You may Find Fascinating that we Encourage You

how to make your own app

how to make your own app

we came across a cool web-site which you could take pleasure in. Take a appear when you want

how to make an app for free

how to make an app for free

Every when inside a while we decide on blogs that we read. Listed below would be the newest web-sites that we choose