Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Problem creating database in svrmgrl (ORA-01504)
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