Examine this security parameter and Its value: SEC_USER_ONAUTHORIZED_ACCESS_BANNER=/opt/oracla/admin/data/unauthwarnin q.txt In which file must you include this parameter?

Question

Options

• Ainit. era
• Blistener.ora
• Caqlnet.ora
• Dtnsnaroes.ora
• Enames.ora
• Fserver.xml

• A
  6% (2)
• B
  88% (30)
• C
  3% (1)
• E
  3% (1)

Explanation

SEC_USER_UNAUTHORIZED_ACCESS_BANNER belongs in listener.ora because the Oracle Listener is the first network component to intercept incoming connection requests - it acts as the gatekeeper before authentication, making it the correct place to display a warning to users who lack authorization. The listener reads this file path and presents the banner text at the earliest point of contact.

Why the distractors are wrong:

• init.ora (A): Stores instance-level initialization parameters (memory, processes) - has no role in network security banners.
• sqlnet.ora (C): Manages client/server protocol settings and does handle SEC_USER_AUTHORIZED_ACCESS_BANNER (for users who successfully authenticate), but not the unauthorized variant.
• tnsnames.ora (D): A client-side file for resolving connection aliases to addresses - purely for name resolution.
• names.ora (E): Used with the deprecated Oracle Names Server for centralized name resolution - irrelevant here.
• server.xml (F): An Apache/Java application server config file - completely outside Oracle Net Services.

Memory tip: Split the parameter name - "UN-authorized" means before login, and the Listener is what guards the door before any login occurs. Listener → listener.ora. The companion parameter for authorized users goes in sqlnet.ora because it fires after the listener hands off the connection.

No community discussion yet for this question.