Re: Invalid Password File when creating a new database

June MacLeod wrote:

> Hello, I am new to Oracle and need to create a test database as the backend
> for a vb frontend.
>
> I am trying to set up a new database using Oracle 8i on an NT4 Server. We
> already have a database running so we know the system works.
>
> I have set up the ORACLE_SID to be CMAXDEV in the registry. I have created
> and started an NT Service named OracleServiceCMAXDEV. I then adapted the
> init.ora file and renamed it initCMAXDEV.ora
>
> I have then started the svrmgrl utility and connected as SYSDBA. I issued
> the command to STARTUP NOMOUNT and then CREATE DATABASE CMAXDEV;
>
> At this point it comes back with the message:
> ORA-01501 Create Database Failed
> ORA-01991 invalid password file 'e:\oracle\ora81\DATABASES\PWDcmaxdev.ora'
>
> I am unsure of where this file comes from and what should be in it.
>
> Could someone offer some help as to what I am doing wrong.
>
> Thanks
>
> June Macleod

Delete the password file and recreate the Oracle services using ORADIM.

How do you have password file set in your init.ora? Exclusive or shared?

Daniel Morgan Received on Fri Nov 01 2002 - 10:33:12 CST