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

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. Received on Wed Oct 25 2000 - 13:45:52 CDT