且构网

分享程序员开发的那些事...
且构网 - 分享程序员编程开发的那些事

oracle 创建PWD文件

更新时间:2021-10-01 08:40:47

1. 在创建pwd文件时,不能在结尾加分号否则会出现如下错误

[oracle@localhost pfile]$ orapwd file=$ORACLE_HOME/dbs/orapwtest.ora password=jume123456 entries =30;
Usage: orapwd file=<fname> entries=<users> force=<y/n> ignorecase=<y/n> nosysdba=<y/n>

  where
    file - name of password file (required),
    password - password for SYS will be prompted if not specified at command line,
    entries - maximum number of distinct DBA (optional),
    force - whether to overwrite existing file (optional),
    ignorecase - passwords are case-insensitive (optional),
    nosysdba - whether to shut out the SYSDBA logon (optional Database Vault only).
   
  There must be no spaces around the equal-to (=) character.