Oracle ORAPWD

最新推荐文章于 2021-07-26 13:52:28 发布

原创最新推荐文章于 2021-07-26 13:52:28 发布 · 347 阅读

0 ·

CC 4.0 BY-SA版权

Oracle 专栏收录该内容

48 篇文章

订阅专栏

本文介绍如何使用ORAPWD命令创建和配置Oracle数据库的密码文件。文章详细解释了ORAPWD命令的语法及其参数，包括FILE、ENTRIES、FORCE和IGNORECASE等选项，并提供了在UNIX/Linux及Windows系统下的具体示例。

Preparing to Use Password File Authentication with ORAPWD:

The syntax of the ORAPWD command is as follows:
ORAPWD FILE=filename [ENTRIES= numusers ] [FORCE={Y|N}] [IGNORECASE={Y|N}]

PS：UNIX and Linux: orapwORACLE_SID ORACLE_HOME/dbs
Windows: PWDORACLE_SID .ora ORACLE_HOME\database

For example: 1. mv orapwda orapwda.bak

2.shutdown database

3.$ orapwd file=orapwda entries=100

4.restart database

FILE:Name to assign to the password file. You must supply a complete path. If you supply only a file name, the file is written to the current directory.
ENTRIES(Optional): Maximum number of entries (user accounts) to permit in the file.
FORCE (Optional):If y, permits overwriting an existing password file.
IGNORECASE (Optional):If y, passwords are treated as case-insensitive