Q
Manage Learn to apply best practices and optimize your operations.

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.

Dig Deeper on Oracle database design and architecture

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.

Start the conversation

Send me notifications when other members comment.

Please create a username to comment.

-ADS BY GOOGLE

SearchDataManagement

SearchBusinessAnalytics

SearchSAP

SearchSQLServer

TheServerSide.com

SearchDataCenter

SearchContentManagement

SearchHRSoftware

Close