Check information about the password file in Oracle

Check location, format or ASM placed about password file in Oracle

Check location and format of password file in Oracle:

SQL> select file_name, format, is_asm, con_id from v$passwordfile_info;

FILE_NAME                              FORMAT IS_AS     CON_ID   
-------------------------------------- ------ ----- ----------
C:\ORACLE\DBHOMEXE\DATABASE\PWDXE.ORA  12.2   FALSE          0

SQL> desc v$passwordfile_info;
 Name                                      Null?    Type
 ----------------------------------------- -------- ----------------------------
 FILE_NAME                                          VARCHAR2(513)
 FORMAT                                             VARCHAR2(6)
 IS_ASM                                             VARCHAR2(5)
 CON_ID                                             NUMBER

Check other information about the user from the password file:

col account_Status for a14
col last_login for a40

col username for a8
select username,sysdba,last_login,account_status,common from v$pwfile_users;

USERNAME SYSDB LAST_LOGIN                             ACCOUNT_STATUS COM
-------- ----- -------------------------------------- --------------
 ---
SYS      TRUE  11-MAY-22 06.37.43.000000000 PM +05:30 OPEN           YES


SQL> desc  V$PWFILE_USERS
 Name                                      Null?    Type
 ----------------------------------------- -------- ----------------------------
 USERNAME                                           VARCHAR2(128)
 SYSDBA                                             VARCHAR2(5)
 SYSOPER                                            VARCHAR2(5)
 SYSASM                                             VARCHAR2(5)
 SYSBACKUP                                          VARCHAR2(5)
 SYSDG                                              VARCHAR2(5)
 SYSKM                                              VARCHAR2(5)
 ACCOUNT_STATUS                                     VARCHAR2(30)
 PASSWORD_PROFILE                                   VARCHAR2(128)
 LAST_LOGIN                                         TIMESTAMP(9) WITH TIME ZONE
 LOCK_DATE                                          DATE
 EXPIRY_DATE                                        DATE
 EXTERNAL_NAME                                      VARCHAR2(1024)
 AUTHENTICATION_TYPE                                VARCHAR2(8)
 COMMON                                             VARCHAR2(3)
 CON_ID                                             NUMBER

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

This site uses Akismet to reduce spam. Learn how your comment data is processed.