Determine the Oracle Database Uptime

You can check the Oracle DB uptime by run one of the following commands :

SELECT host_name, instance_name,
       TO_CHAR(startup_time, 'DD-MM-YYYY HH24:MI:SS') startup_time,
       FLOOR(sysdate-startup_time) days
FROM   sys.v_$instance;

SELECT TO_CHAR(logon_time, 'DD-MM-YYYY HH24:MI:SS')
FROM v$session 
WHERE program LIKE '%PMON%'

Categories: Oracle

ORA-28001 the password has expired Check if Archivelog mode is enabled