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 -> Problem creating database in svrmgrl (ORA-01504)

Problem creating database in svrmgrl (ORA-01504)

From: <schatzy_at_my-deja.com>
Date: Wed, 25 Oct 2000 18:14:20 GMT
Message-ID: <8t77tj$ndo$1@nnrp1.deja.com>

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

Original text of this message

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