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

This article mainly introduces orapwd how to establish a password and authentication, has a certain reference value, interested friends can refer to, I hope you can learn a lot after reading this article, the following let Xiaobian take you to understand.

Orapwd file=$ORACLE_HOME/dbs/orapwSID password=xx

The format of the file name must be orapw+ORACLE_SID, otherwise it will not be normal

[oracle@GI_Softwareonly_64 dbs] $orapwd

Usage: orapwd file= entries= force= ignorecase= nosysdba=

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.

CREATE DATABASE TDB

USER SYS IDENTIFIED BY sys_password

....

Although there will be sys users, and the user status OPNE, but

There will be no password file under $ORACLE_HOME/dbs

SQL > select * from v$pwfile_users has no result

Insufficient permission for sqlplus sys/XX@PROD1 as sysdba to report an error

Sqlplus sys/XX@PROD1 cannot log in, sysdba or sysopen is required

SQL > grant sysdba to sys error ORA-01994: GRANT failed: password file missing or disabled

Once there is a password file under $ORACLE_HOME/dbs, when alter user sys identified and ls-tl, the time of the password file becomes the execution time of alter user sys identified

The experiment proves that 1: first use orapwd to establish password A, then use create database user sys to establish password B, the real password is A, sqlplus sys/B@prod_s as sysdba will report an error ORA-01017: invalid username/password; logon denied when logging in with password B, and sqlplus sys/A@prod_s as sysdba is normal when logging in with password A.

The experiment proves that 2:CREATE DATABASE TDB USER SYSTEM found that system users automatically have DBA privileges.

For example, ORACLE_SID=PROD1, the corresponding tns is also PROD1.

1 、

Sqlplus sys/XX@PROD1 as sysdba

The error ORA-01017: invalid username/password; logon denied indicates normal configuration, but the password XX after sys is incorrect.

Error ORA-01031: insufficient privileges, indicating that the configuration is not successful

2 、

SQL > select * from v$pwfile_users

The result indicates that the configuration is normal

No result, indicating that the configuration is not successful

Thank you for reading this article carefully. I hope the article "how to set up a password and verify orapwd" shared by the editor will be helpful to everyone. At the same time, I also hope that you will support and pay attention to the industry information channel. More related knowledge is waiting for you 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.