Oracle Database Discussions

SQL> get C:\Oracle_Docs\ex\dbcreation_script\DBCREATIONSCRIPT
1 create database db_test
2 logfile group 1 ('C:\oracle\product\10.1.0\oradata\orcl\testdb\REDO01.rdo','C:\oracle\product\10.1.0\oradata\orcl\testdb\REDO02.rdo') size 100 m,
3 group 2 ('C:\oracle\product\10.1.0\oradata\orcl\testdb\REDO03.rdo','C:\oracle\product\10.1.0\oradata\orcl\testdb\REDO04.rdo') size 100 m
4 datafile 'C:\oracle\product\10.1.0\oradata\orcl\testdb\system01.dbf' size 32m
5 SYSAUX DATAFILE 'C:\oracle\product\10.1.0\oradata\orcl\testdb\SYSAUX.DBF' SIZE 325M
6 undo tablespace testundotbs
7 datafile 'C:\oracle\product\10.1.0\oradata\orcl\testdb\undo01.dbf' size 40 m
8 default temporary tablespace test_temptbls
9 tempfile 'C:\oracledb\testdb\tempo1.dbf' size 40 m
10 character set WE8MSWIN1252
11* national character set AL16UTF16
12 /
create database db_test
*
ERROR at line 1:
ORA-01501: CREATE DATABASE failed
ORA-01504: database name 'DB_TEST' does not match parameter db_name 'orcl'


create spfile = 'C:\oracle\product\10.1.0\db_1\database\spfiledb_test.ora' from pfile = 'C:\oracle\product\10.1.0\admin\orcl\pfile\init.ora'
*
ERROR at line 1:
ORA-01078: failure in processing system parameters
LRM-00109: could not open parameter file
'C:\ORACLE\PRODUCT\10.1.0\ADMIN\ORCL\PFILE\INIT.ORA'

Message was edited by:
user525645