Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: help please with create database error
"Howard J. Rogers" <dba_at_hjrdba.com> wrote in message news:<3c06f59b$0$10229$afc38c87_at_news.optusnet.com.au>...
> The file has to be in that location, I'm afraid -unless you start using
> symbolic links to the actual location, leaving a link behind in the default
> one.
>
> Regards
> HJR
> --
> Resources for Oracle: http://www.hjrdba.com
> ===============================
>
This is not entirely correct as ORAPWD will accept a fully 'qualified' file name, including path, so the password file can be located wherever one might wish. With Oracle9i:
c:\ora9i\ora9011\bin\orapwd
file=c:\ora9i\ora9011\database\pwddbtech.ora password=******
This also holds true for Oracle8i:
c:\oracle\ora816\bin\orapwd
file=c:\oracle\ora816\database\pwdtechdb.ora password=++++++
>
> "stevek" <stefano1_at_att.net> wrote in message
> news:3C06E1C0.DAB5FA22_at_att.net...
> >
> > Trying to create a new database and continue to get the below error.
> >
> > ORA-01501: CREATE DATABASE failed
> > ORA-01990: error opening password file '/u01/oracle/OraHome1/dbs/orapw'
> >
> > looked up in Oracle manual which states
> >
> > ORA-01990 error opening password file 'string'
> > Cause: An attempt to open the specified password file failed because of
> > one of
> > the following errors:
> > n An operating system error occurred.
> > n ORAPWD is already running, so the password file is locked.
> > The environment variables ORA_sid_PWFILE and ORA_PWFILE are not set.
> >
> > Set both variables without any success. How do I tell oracle that I
> > would like
> > orapw or oradev1pw placed someplace other than Oracle_Home/dbs/?
> >
> > Thanks in advance
Received on Fri Nov 30 2001 - 12:59:36 CST