If you determine that you no longer require a password file to authenticate users, you can delete the password file and then optionally reset the REMOTE_LOGIN_PASSWORDFILE initialization parameter to NONE. After you remove this file, only those users who can be authenticated by the operating system can perform SYSDBA or SYSOPER database administration operations.
Sunday, September 21, 2008
Removing a Password File
Subscribe to:
Post Comments (Atom)
Blog Archive
-
▼
2008
(48)
-
▼
September
(48)
- How an Oracle Instance Is Started
- Overview of Instance and Database Startup
- How Initialization Parameter Values Are Changed
- Initialization Parameter Files and Server Paramete...
- The Instance and the Database
- Database and Instance Startup and Shutdown
- Managing PFILE and SPFILE
- The Oracle SPFILE
- Oracle Startup and Parameter File
- Oracle's PFILE
- Removing a Password File
- Replacing a Password File
- Expanding the number of password file users if the...
- Viewing Password File Members
- Granting and Revoking SYSDBA and SYSOPER Privilege...
- Creating a Password File and Adding New Users to It
- Setting REMOTE_LOGIN_ PASSWORDFILE
- Setting REMOTE_LOGIN_ PASSWORDFILE
- Using ORAPWD
- Oracle Password File
- Dropping Control Files
- Control File V$ Views
- Recovering a Control File
- Recovering a Control File
- Backing Up Control Files
- Troubleshooting After Creating Control Files
- Steps for Creating New Control Files
- CREATE CONTROLFILE Statement
- When to Create New Control Files
- Creating Additional Copies of Control Files
- Creating Control Files
- Size of Control Files
- Multiplexed control files
- Control Files Init.ora parameter
- Oracle Control file
- Datafile Backups
- Oracle Datafile backup - part1
- v$datafile_header view
- v$datafile view
- Renaming and Relocating Datafiles for Multiple Tab...
- Relocating and Renaming Datafiles in a Single Tabl...
- Renaming and Relocating Datafiles for a Single Tab...
- Determine the Number of Datafiles
- Oracle datafiles
- Oracle Startup - Third Stage - Open Database
- Oracle Startup - Second Stage
- Oracle Startup - First Stage
- Oracle Startup
-
▼
September
(48)
No comments:
Post a Comment