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.
Practice questions
What is the default name of an Oracle Net listener when none is specified?
- ORACLE
- TNSLSNR
- LISTENER
- 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.
Which items does the lsnrctl STATUS output include?
- Listener version
- Start date and uptime
- Password hashes of database users
- A services summary with instance states
- 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: 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.
