Home » RDBMS Server » Server Administration » Creating DataBase Manually (merged)
Creating DataBase Manually (merged) [message #410424] Fri, 26 June 2009 20:41 Go to next message
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 Go to previous messageGo to next message
babuknb
Messages: 1734
Registered: December 2005
Location: NJ
Senior Member

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 Go to previous messageGo to next message
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..
Re: Creating DataBase Manually [message #410429 is a reply to message #410428] Fri, 26 June 2009 22:31 Go to previous messageGo to next message
babuknb
Messages: 1734
Registered: December 2005
Location: NJ
Senior Member


Hello,

Fix pfile issue; then try to create your database

Ref: http://download.oracle.com/docs/cd/B10501_01/server.920/a96521/create.htm

Thanks
Re: Creating DataBase Manually [message #410535 is a reply to message #410428] Sun, 28 June 2009 03:19 Go to previous messageGo to next message
tanvier
Messages: 3
Registered: June 2009
Junior Member
Could u send the steps for Creating a new Pfile & the required changes to be done in it.
Create DataBase Manualy [message #410539 is a reply to message #410424] Sun, 28 June 2009 05:09 Go to previous messageGo to next message
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
Re: Create DataBase Manualy [message #410541 is a reply to message #410539] Sun, 28 June 2009 06:02 Go to previous messageGo to next message
Michel Cadot
Messages: 64120
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Have a look at alert.log.
Before trying to do something manually you should read Database Concepts and Administrator's Guide.


Regards
Michel

[Updated on: Sun, 28 June 2009 06:03]

Report message to a moderator

icon8.gif  Re: Create DataBase Manualy [message #410552 is a reply to message #410539] Sun, 28 June 2009 09:40 Go to previous message
selvakumarmvs
Messages: 12
Registered: February 2009
Junior Member
before trying to create database manually ...you should follow this..

http://download.oracle.com/docs/cd/B19306_01/server.102/b14231/create.htm#i1017640

after that you get error again ...post all the steps you used with your pfile here...


[Updated on: Sun, 28 June 2009 09:41]

Report message to a moderator

Previous Topic: Trace procedure
Next Topic: oracle database migration
Goto Forum:
  


Current Time: Tue Dec 06 12:06:12 CST 2016

Total time taken to generate the page: 0.07926 seconds