I use Oracle9i (9.0.1). My OS is Windows 2000. I want to create a password file -- what is the procedure? I use...
By submitting your email address, you agree to receive emails regarding relevant topic offers from TechTarget and its partners. You can withdraw your consent at any time. Contact TechTarget at 275 Grove Street, Newton, MA.
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.