Re: help please with create database error

Thanks David,

Does this info go in the init file? What about directing other data files. I have directed control files in the init file but when I create the database the data files are going to the old (default?) location. I am trying to locate using OFA .... data and trace file in /u02. How can I do this?

Thanks

David Fitzjarrell wrote:
>
> "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 - 14:34:06 CST