Ask the Expert

Password file generation

This is regarding the password file generation using ORAPWD utility under Windows. My sys login password is light007
oracle

    Requires Free Membership to View

Version : 9.0.1
OS : Windows 2000

I have generated the password file using the follwing command.

orapwd file=d:oracleora81dbsorapwdnets.pwd password=san123 entires=10;

I just went through OCP exam guides in which a question is shown below.

You execute the ORAPWD utility to generate your password file in Oracle, specifying password=fritz26. Which of the following users will have his or her password set to fritz26?

A. OUTLN
B. SYS
C. SYSTEM
D. None, the password parameter is used for authentication of the use running ORAPWS to create the password file.

Answer mentioned was B.

Accordingly the password of SYS should be changed to san123 & I should connect to Oracle as "connect sys/san123 as sysdba" but when trying this command to connect to Oracle getting ORA-01031:

Insufficient privileges error. Where I can connect with my old password such as connect sys/light007 as sysdba. Can you please clarify exactly how the password file is used?
The password file will not be used unless you also set the REMOTE_LOGIN_PASSWORDFILE parameter to EXCLUSIVE and bounce your database. The default is NONE, in which case, Oracle isn't using a password file at all.

This was first published in February 2004

There are Comments. Add yours.

 
TIP: Want to include a code block in your comment? Use <pre> or <code> tags around the desired text. Ex: <code>insert code</code>

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
Sort by: OldestNewest

Forgot Password?

No problem! Submit your e-mail address below. We'll send you an email containing your password.

Your password has been sent to: