Q

How to create a password file

I use Oracle9i (9.0.1). My OS is Windows 2000. I want to create a password file -- what is the procedure? I use orapwd80 utility but it gives an error.
The orapwd80 utility won't work because that utility is for Oracle 8.0. You'll need to use the utility in %ORACLE_HOME%/bin called 'orapwd', where %ORACLE_HOME% is your Oracle 9.0.1 home directory. So perform the following steps:

1. cd %ORACLE_HOME%/bin
2. orapwd file=%ORACLE_HOME%databasePWD%ORACLE_SID%.ora password=[SYS_password] entries=20

Make sure to make appropriate substitutions.

This was first published in March 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:

-ADS BY GOOGLE

SearchDataManagement

SearchBusinessAnalytics

SearchSAP

SearchSQLServer

TheServerSide

SearchDataCenter

SearchContentManagement

SearchFinancialApplications

Close