Shulou(Shulou.com)05/31 Report--

This article mainly explains "how to create a database password file". Interested friends may wish to have a look. The method introduced in this paper is simple, fast and practical. Let's let the editor take you to learn how to create a database password file.

You can use ORAPWD to create database password files. To create a database password file:

Run the ORAPWD command.

Example:

Example 1: create a database password file located in an Oracle ASM disk group

The following command creates a 12.2 format database password file named orapworcl, which is located in the Oracle ASM disk group. The DBUNIQUENAME parameter is required because the database password file is in the Oracle ASM disk group.

Orapwd FILE='+DATA/orcl/orapworcl' DBUNIQUENAME='orcl' FORMAT=12.2

Example 2: create a database password file using a SYSBACKUP entry

The following example is similar to example 1-20, except that it creates a SYSBACKUP entry in the database password file. The password file defaults to 12.2 format.

Orapwd FILE='+DATA/orcl/orapworcl' DBUNIQUENAME='orcl' SYSBACKUP=password FORMAT=12.2

Example 3: create a database password file with external authentication for SYS and SYSKM

The following example is similar to example 1-20, except that it specifies an external name for SYS and SYSKM administrative users.

Orapwd FILE='+DATA/orcl/orapworcl' DBUNIQUENAME='orcl' FORMAT=12.2 sys=external ('KerberosUserSYS@example.com') syskm=external (' KerberosUserSYSKM@example.com')

Example 4: create a database password file located in the file system

The following command creates a 12.2 format database password file named orapworcl, which is located in the default location of the operating system file system.

Orapwd FILE='/u01/oracle/dbs/orapworcl' FORMAT=12.2

Example 5: migrate legacy database password files to Oracle database 12c format

The following command migrates the legacy database password file formatted as 12.2. The password file is called orapworcl and is located in the operating system file system. The new database password file replaces the existing database password file. Therefore, FORCE must be set to y.

Orapwd FILE='/u01/oracle/dbs/orapworcl' FORMAT=12.2 INPUT_FILE='/u01/oracle/dbs/orapworcl' FORCE=y

Example 6: reset the password of the system administrative user

The following command resets the password for the SYS administrative user. The new database password file replaces the existing database password file. Therefore, FORCE must be set to y.

Orapwd FILE='/u01/oracle/dbs/orapworcl' SYS=Y INPUT_FILE='/u01/oracle/dbs/orapworcl' FORCE=y

You are prompted to enter a new password for the SYS administrative user.

Example 7: describe a password file

The following command describes the orapworcl password file.

Orapwd DESCRIBE FILE='orapworcl' Password file Description: format=12.2 so far, I believe you have a deeper understanding of "how to create a database password file". You might as well do it in practice. Here is the website, more related content can enter the relevant channels to inquire, follow us, continue to learn!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.