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.

    Requires Free Membership to View

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

Join the conversationComment

Share
Comments

    Results

    Contribute to the conversation

    All fields are required. Comments will appear at the bottom of the article.