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 NUMBERCheck 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