My Oracle Support Banner

LAST_LOGIN field remains blank for sys in V$PWFILE_USERS view (Doc ID 2972130.1)

Last updated on OCTOBER 10, 2023

Applies to:

Oracle Database - Enterprise Edition - Version 19.10.0.0.0 and later
Information in this document applies to any platform.

Symptoms

LAST_LOGIN is not populated for SYS user in V$PWFILE_USERS.

Changes

 

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Changes
Cause
Solution
 1.Check current password file info
  2. Migrate earlier password file formats to the 12.2 format by using the ORAPWD utility file
 3. Login as SYS user and check if LAST_LOGIN populated successfully
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.