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.