1.) Operating System authentication
There are three value for remote_login_passwordfile parameters :
We can use password file for authentication and connect to remote machine with sys user.Only an EXCLUSIVE file can contain the names of users other than SYS. Using an "exclusive" password file lets us allow to grant sysdba and sysoper system privileges to individual users and have them connect as themselves.
If we ever receive the file full error i.e, ORA-1996 while granting "sysdba" or "sysoper" system privileges to a user, we must create a larger password file and regrant the privileges to the users. The below steps will replace the current passwordfile with new larger password file .
1.) Identify the users who have sysdba or sysoper privileges by querying the v$pwfile_users views .
2.) Delete the existing password file.
3.) Creating a new password file using the ORAPWD utility and ensure that the ENTRIES parameter is set to a number larger then the previous password file .
4.) Connect with "sys" and grant the priveleges to user as quired from v$pwfile_users view .