Re: Invalid password file when creating new db in Linux

Daniel,

This is not a Linux thing it's an Oracle one! You have two choices: 1 - Use the Oracle utility orapwd to create a password file with the same password as sys in it.
2 - Edit your init.ora file and set "parameter remote_login_password=NONE" If you want to understand this I'd suggest you read about passwords in chapter 1 of the Oracle8i Administrator's Guide, which you can find @ documentation.oracle.com.

Kind Regards,

Fraser McCallum
MVP Oracle Administration
www.brainbench.com

"dbuckingham" <member_at_dbforums.com> wrote in message news:3d40f7fc$1_at_news.usenetgateway.com...
> I am trying to create a new database in Linux. I have successfully
> installed oracle 8.1.7 and can access the oracle starter database
> without any problems.
>
> In order to create the new database I have done the following:
>
> 1. Make a copy of the init.ora file as initTESTDB.ora and edit the new
> file by fixing the database name and paths in the file to point to
> the correct location.
> 2. Start up the database in server manager as no mount using new
> initTESTDB.ora file.
> 3. Created a build script that issues a CREATE DATABASE statement and
> creates the redo logs and system.dbf file.
> 4. run the Build script created in step 3.
>
> Running this creates the Control files, the Redo logs and the System.dbf
> file, however it falls over with an invalid password file error.
> ORA-01991 invalid password file
> '/opt/oracle/product/oracle/dbs/orapwora'
>
> I am pointing the amended parameter file to a new location to that of
> the old one for I want thsi database to reside in a different area.
>
> Can some explain why I am getting this error with the password file?
>
> How do I bypass this?
>
> I am new to Linux, so still getting the hang of things.
>
>
> Thanks.
>
>
>
> --
> Daniel Buckingham
> Technical Consultant
> Mercia Software
>
> Posted via dBforums
> http://dbforums.com
Received on Fri Jul 26 2002 - 03:33:45 CDT