oracle的ora01504,在xe下手工建立数据库，报ORA-01504，如何解决？

CREATE DATABASE error on oracle-express

Posted: Dec 22, 2005 12:09 AM      Reply

Hi,

I use SQLPLUS to try to "CREATE DATABASE" with the commands below. Any

idea about the error?

SQL> CONNECT / AS sysdba

Connected.

SQL> shutdown

ORA-01507: database not mounted

ORACLE instance shut down.

SQL> STARTUP NOMOUNT

ORACLE instance started.

Total System Global Area 146800640 bytes

Fixed Size 1218208 bytes

Variable Size 62916960 bytes

Database Buffers 79691776 bytes

Redo Buffers 2973696 bytes

SQL> CREATE DATABASE test;

CREATE DATABASE test

*

ERROR at line 1:

ORA-01501: CREATE DATABASE failed

ORA-01504: database name 'TEST' does not match parameter db_name 'XE'

TIA

Roberto Colmegna

Jacco Landlust

P