Oracle Database Discussions

Again me...

I would like to create new instance.

On the beginning I have created parameter file using that command:

-- create the server parameter file
CREATE SPFILE='/u01/oracle/dbs/spfilemynewdb.ora' FROM
PFILE='/u01/oracle/admin/initmynewdb/scripts/init.ora';
SHUTDOWN
-- the next startup will use the server parameter file
EXIT

But righ now, when I`m creating instance I have that error

ERROR at line 1:
ORA-01501: CREATE DATABASE failed
ORA-01504: database name 'KBTEST' does not match parameter db_name 'kbdevel'

To create my new instance I`m using that script:

CREATE DATABASE kbtest
USER SYS IDENTIFIED BY dh711214
USER SYSTEM IDENTIFIED BY dh711214
LOGFILE GROUP 1 ('/opt/oracle10g/10.2.0/oradata/kbtest/redo01.log') SIZE 100M,
GROUP 2 ('/opt/oracle10g/10.2.0/oradata/kbtest/redo02.log') SIZE 100M,
GROUP 3 ('/opt/oracle10g/10.2.0/oradata/kbtest/redo03.log') SIZE 100M
MAXLOGFILES 5
MAXLOGMEMBERS 5
MAXLOGHISTORY 1
MAXDATAFILES 100
MAXINSTANCES 1
CHARACTER SET WE8ISO8859P1
NATIONAL CHARACTER SET AL16UTF16
DATAFILE '/opt/oracle10g/10.2.0/oradata/kbtest/system01.dbf' SIZE 325M REUSE
EXTENT MANAGEMENT LOCAL
SYSAUX DATAFILE '/opt/oracle10g/10.2.0/oradata/kbtest/sysaux01.dbf' SIZE 325M REUSE
DEFAULT TABLESPACE tbs_1
DEFAULT TEMPORARY TABLESPACE tempts1
TEMPFILE '/opt/oracle10g/10.2.0/oradata/kbtest/temp01.dbf'
SIZE 20M REUSE
UNDO TABLESPACE undotbs
DATAFILE '/opt/oracle10g/10.2.0/oradata/kbtest/undotbs01.dbf'
SIZE 200M REUSE AUTOEXTEND ON MAXSIZE UNLIMITED;

How can I specify a parameter file in that script. It seems to be, that this script using diffrent parameter file (from other instance 'kbdevel')


help