| Creating DataBase Manually (merged) [message #410424] |
Fri, 26 June 2009 20:41  |
tanvier
Messages: 3
Registered: June 2009 |
Junior Member |
|
|
My Ques - I am trying to create DB manually by executing the CREATE DATABASE Script, but DB_name is conflicting with the -db_name specified in the init.ora file, existing DB_name is 'ORCL'; I logged with Sys Account & Startup with nomount option.
SQL>CREATE DATABASE MyDb3
CONTROLFILE REUSE
Maxinstances 1
Maxloghistory 1
Maxlogfiles 10
Maxdatafiles 100
Datafile 'E:\oracle\product\10.1.0\oradata\MyDb3\DB3.dbf'
size 300M reuse autoextend on next 15M maxsize unlimited
character set WE8ISO8859P1
logfile
group 1 ('E:\oracle\product\10.1.0\oradata\MyDb3\DB3A.dbf') size 75M,
group 2 ('E:\oracle\product\10.1.0\oradata\MyDb3\DB3B.dbf') size 75M,
group 3 ('E:\oracle\product\10.1.0\oradata\MyDb3\DB3C.dbf') size 75M
default temporary tablespace TEMP
tempfile 'E:\DB3T.dbf'
extent management local uniform size 1M
sysaux datafile 'D:\oracle\databases\ora10\sysaux.dbf' size 10M autoextend on next 10M maxsize
undo tablespace MYUNDO_TS datafile 'E:\DB3U.dbf'
size 125M reuse autoextend on next 15M maxsize unlimited
SQL> /
CREATE DATABASE MyDb3
*
ERROR at line 1:
ORA-01501: CREATE DATABASE failed
ORA-01504: database name 'MYDB3' does not match parameter db_name 'orcl'.
|
|
|
| Re: Creating DataBase Manually [message #410425 is a reply to message #410424] |
Fri, 26 June 2009 20:45  |
|
ORA-01504:
database name 'string' does not match parameter db_name 'string'
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.
Thanks
|
|
|
| Re: Creating DataBase Manually [message #410428 is a reply to message #410424] |
Fri, 26 June 2009 22:16 |
selvakumarmvs
Messages: 12
Registered: February 2009 |
Junior Member |
|
|
you should start the database like this
>sqlplus
>/ as sysdba
>startup pfile=' ' nomount
>create database
note: db_name specified name should same as database creation db_name
specify correct pfile during startup
Best Regards
selva..
|
|
|
|
|
| Create DataBase Manualy [message #410539 is a reply to message #410424] |
Sun, 28 June 2009 05:09 |
tanvier
Messages: 3
Registered: June 2009 |
Junior Member |
|
|
SQL>create database MyDb001
controlfile reuse
logfile group 1 ('E:\oracle\product\10.1.0\oradata\MyDb001\redo1a.log') size 10M,
group 2 ('E:\oracle\product\10.1.0\oradata\MyDb001\redo2b.log') size 10M,
group 3 ('E:\oracle\product\10.1.0\oradata\MyDb001\redo3c.log') size 10M
character set WE8ISO8859P1
national character set utf8
datafile 'E:\oracle\product\10.1.0\oradata\MyDb001\system1.dbf'
size 10m
autoextend on
next 10M maxsize unlimited
sysaux datafile 'E:\oracle\product\10.1.0\oradata\MyDb001\sysaux1.dbf'
size 10M
autoextend on
next 10M
maxsize unlimited
undo tablespace undo
datafile 'E:\oracle\product\10.1.0\oradata\MyDb001\undo1.dbf'
size 10M
default temporary tablespace temp
tempfile 'E:\oracle\product\10.1.0\MyDb001\oradatatemp1.dbf'
size 10M;
create database MyDb001
*
ERROR at line 1:
ORA-01092: ORACLE instance terminated. Disconnection forced
SQL>
How to fix this error
|
|
|
|
|
] 
Members
Search
Help
Register
Login
Home
