Use the following procedure to replace a password file:
1.Identify the users who have SYSDBA or SYSOPER privileges by querying the V$PWFILE_USERS view.
2.Delete the existing password file.
3.Follow the instructions for creating a new password file using the ORAPWD utility in "Using ORAPWD". Ensure that the ENTRIES parameter is set to a number larger than you think you will ever need.
4.Follow the instructions in "Adding Users to a Password File".
skip to main |
skip to sidebar
Learn about Oracle datafiles, Oracle Control files, Oracle redo log files, Oracle archive redo log files, Oracle startups and shutdowns, Oracle Instance, Oracle Memory structures, Oracle password files, Oracle spfile, pfile and init.ora file, Oracle password files, Oracle database structure, Tablespaces and much more
No comments:
Post a Comment