Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Problem creating database in svrmgrl (ORA-01504)

Re: Problem creating database in svrmgrl (ORA-01504)

From: <schatzy_at_my-deja.com>
Date: Wed, 25 Oct 2000 23:04:40 GMT
Message-ID: <8t7ou3$73m$1@nnrp1.deja.com>

Thanks!
That was it.

In article <8t79ot$p85$1_at_nnrp1.deja.com>,   tlondon_at_my-deja.com wrote:
> In article <8t77tj$ndo$1_at_nnrp1.deja.com>,
> schatzy_at_my-deja.com wrote:
 

> > Hi all,
> >
> > I am trying to manually create my Oracle database and am getting the
> > following error:
> > SVRMGR> @createdb.sql
> > CREATE DATABASE ora816
> > *
> > ORA-01501: CREATE DATABASE failed
> > ORA-01504: database name 'ORA816' does not match parameter db_name
> > 'DEFAULT'
> >
> > bash$ oerr ora 01504
> > 01504, 00000, "database name '%s' does not match parameter db_name
 '%
 s'"
> > // *Cause: The name in a database create or mount does not match
 the
> > name
> > // given in the INIT.ORA parameter db_name.
> > // *Action: correct or omit one of the two names.
> >
> > I have created the "initora816.ora" file in my "dbs" directory,
 where
 my
> > default init ora files were. I did reference the following lines in
 the
> > file:
> > # replace DEFAULT with your database name
> > db_name=ora816
> > instance_name=ora816
> > I'm not sure where the file is supposed to go, according to the
> > documentation, the default file goes there, but where does 'svrmgrl'
> > look for the file when you are creating databases?
> >
> > I have also copied this to my $ORACLE_BASE/admin/ora816/pfile
 directory,
> > and still no success.
> >
> > I would use the DAtabase Configuration ASsistant, but I can't get
 that
> > to run. I'm running on a Solaris 2.7 box. All I have in my
> > "assistants/dbca" directory is "doc images install jlib" and there
 is
> > only a jar file under the jlib directory. How to execute this
 program.
> >
> > Sorry for the novice questions.
> >
> > Thanks for any help you can provide.
> >
> > Sent via Deja.com http://www.deja.com/
> > Before you buy.
> >

>

> have you shutdown the instance and restarted it since
> editing the parameter file.
>

> the default location is $ORACLE_HOME/dbs for the file
>

> Sent via Deja.com http://www.deja.com/
> Before you buy.

>

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Wed Oct 25 2000 - 18:04:40 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US