Bitzu

CPSA ยท Database security

Finding Oracle version and patch level

Listener, TNS and ways of deriving version and patch level from an Oracle host.

Key points

  • Oracle Net listener: default name LISTENER, port 1521.
  • lsnrctl STATUS: listener version, start date, uptime, parameter and log files, endpoints, services summary with instance states.
  • Network view: listener and TNS replies give the listener version, hinting at the database release.
  • Exact patch level: needs host or database access (patch inventory, views).
  • Old versus current patch sets: missing security updates.

Source: https://docs.oracle.com/en/database/oracle/oracle-database/23/netag/determining-current-status-listener.html

Practice questions

Single choice

What is the default name of an Oracle Net listener when none is specified?

  1. ORACLE
  2. TNSLSNR
  3. LISTENER
  4. DEFAULT
Show answer

Answer: C. LISTENER

The default listener is named LISTENER, so lsnrctl commands can omit the name. The other names are not defaults.

Select all that apply

Which items does the lsnrctl STATUS output include?

  1. Listener version
  2. Start date and uptime
  3. Password hashes of database users
  4. A services summary with instance states
  5. Rows of application tables
Show answer

Answer: A. Listener version, B. Start date and uptime, D. A services summary with instance states

STATUS shows the listener version and start date, and a services summary. It does not list database user passwords or the contents of tables.

True or false

True or false: a listener version line from the network gives the exact patch level of the database.

Show answer

Answer: False

False. It identifies the listener build and hints at the release, but the exact patch level of the database home needs host or database access.

Practice 8 questions on this topic in Bitzu

Short lessons, instant explanations and spaced review of what you get wrong. Free on iOS and Android.

Download on the App StoreGet it on Google Play

More CPSA topics in this module