Q

Password file generation

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

oracle 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

Dig deeper on Oracle database design and architecture

Pro+

Features

Enjoy the benefits of Pro+ membership, learn more and join.

Have a question for an expert?

Please add a title for your question

Get answers from a TechTarget expert on whatever's puzzling you.

You will be able to add details on the next page.

0 comments

Oldest 

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:

SearchDataManagement

SearchBusinessAnalytics

SearchSAP

SearchSQLServer

TheServerSide

SearchDataCenter

SearchContentManagement

SearchFinancialApplications

Close