ORACLE ORAPWD

最新推荐文章于 2024-05-06 07:42:33 发布

彦祖的小号

最新推荐文章于 2024-05-06 07:42:33 发布

阅读量561

点赞数

分类专栏： Oracle 文章标签： oracle

本文链接：https://blog.csdn.net/linsuhangoracle/article/details/119107983

版权

Oracle 专栏收录该内容

193 篇文章 0 订阅

订阅专栏

$ orapwd --help

orapwd FILE=filename [FORCE={y|n}] [ASM={y|n}] [DBUNIQUENAME=dbname]

[FORMAT={12.2|12}] [SYS={Y|password|external('sys-external-name')}]

[SYSBACKUP={password|external('sysbackup-external-name')}]

[SYSDG={password|external('sysdg-external-name')}}]

[SYSKM={password|external('syskm-external-name')}}]

[DELETE={y|n}] [INPUT_FILE=input-fname]

orapwd DESCRIBE FILE=filename

FILE：

If the DESCRIBE argument is not included, then specify the name to assign to the new password file. You must supply a complete path. If you supply only a file name, the file is written to the current directory.If the DESCRIBE argument is included, then specify the name of an existing password file.

DESCRIBE

只能显示format值

Describes the properties of the specified password file, including the FORMAT value (12.2 or 12).

FORCE：

(Optional) If y, permits overwriting an existing password file.

ASM：

用于表示是在OS还是ASM上创建password file

(Optional) If y, create an Oracle ASM password file in an Oracle ASM disk group.

If n, the default, create a password file in the operating system file system.

When the DBUNIQUENAME argument is specified, the password file is a database password file.

When the DBUNIQUENAME argument is not specified, the password file can

be a database password file or an Oracle ASM password file

DBUNIQUENAME

用于表示在ASM上创建的是database password还是asm password file

Unique database name used to identify database password files residing in an ASM disk group only. This argument is required when the database password file is stored on an Oracle ASM disk group. This argument is ignored when an Oracle ASM password file is created by setting the ASM argument to y.

FORMAT

(Optional) Specify one of the following values:

12.2, the default, creates the password file in 12.2. format. This format supports

granting administrative privileges to external users and enables SSL and Kerberos

authentication for administrative users.

12 creates the password file in Oracle Database 12c format. This format supports the

SYSBACKUP, SYSDG, and SYSKM administrative privileges.

If this argument is set to legacy, then ORAPWD creates a database password file that is in the format before Oracle Database 12c. The password file supports SYSDBA and SYSOPER administrative privileges, but it does not support SYSBACKUP, SYSDG, and SYSKM administrative privileges.

SYS

(Optional) This argument can be set to either Y, password, or external('sys-external-name').

If SYS=Y and INPUT_FILE is specified to migrate password file entries, then you will be prompted to enter the new password for the SYS administrative user.

If password, then you will be prompted to enter the password for the SYS administrative user.

If external('sys-external-name'), then replace sys-external-name with the external name for SSL or Kerberos authentication for the SYS administrative user.

SYSBACKUP

(Optional) This argument can be set to either password, external('sysbackup-external-name'), y, or n.

If password, then you will be prompted to enter the password for the SYSBACKUP administrative user.

If external('sysbackup-external-name'), then replace sysbackup-external-name with the external name for SSL or Kerberos authentication for the SYSBACKUP administrative user.

SYSDG

(Optional) This argument can be set to either password, external('sysdg-external-name'), y, or n.

If password, then you will be prompted to enter the password for the SYSDG administrative user.

If external('sysdg-external-name'), then replace sysdg-external-name with the external name for SSL or Kerberos authentication for the SYSDG administrative user.

SYSKM

(Optional) This argument can be set to either password, external('syskm-external-name'), y, or n.

If password, then you will be prompted to enter the password for the SYSKM administrative user.

If external('syskm-external-name'), then replace syskm-external-name with the external name for SSL or Kerberos authentication for the SYSKM administrative user.

If y, creates a SYSKM entry in the password file. You are prompted for the password. The password is stored in the created password file.

If n, no SYSKM entry is created in the password file.

Note: The y and n values in the SYSKM argument are deprecated in Oracle Database 12c Release 2 (12.2.0.1) and may be desupported in a future release.

INPUT_FILE

(Optional) Name of the input password file. ORAPWD migrates the entries in the input file to a new password file.

This argument can be used to convert a password file from one format to another, for example from 12 format to 12.2 format.

This argument also can be used to reset the password for the SYS administrative user.

ORAPWD cannot migrate an input password that is stored in an Oracle ASM disk group.

When the INPUT_FILE argument is specified, ORAPWD does not create any new entries. Therefore, ORAPWD ignores the following arguments: SYSBACKUP/SYSDG/SYSKM

When an input file is specified and the new password file replaces the input file, FORCE must be set to y.

DELETE

If this argument is set to y, then ORAPWD deletes the specified password file. When y is specified, FILE, ASM, or DBUNIQUENAME must be specified. When FILE is specified, the file must be located on an ASM disk group.