OraFAQ Forum: Server Administration » Creating DataBase Manually (merged)

Home » RDBMS Server » Server Administration » Creating DataBase Manually (merged)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

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'.

Report message to a moderator

Re: Creating DataBase Manually [message #410425 is a reply to message #410424]

Fri, 26 June 2009 20:45

babuknb
Messages: 1736
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

Report message to a moderator

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..

Report message to a moderator

Re: Creating DataBase Manually [message #410429 is a reply to message #410428]

Fri, 26 June 2009 22:31

babuknb
Messages: 1736
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

Report message to a moderator

Re: Creating DataBase Manually [message #410535 is a reply to message #410428]

Sun, 28 June 2009 03:19

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.

Report message to a moderator

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

Report message to a moderator

Re: Create DataBase Manualy [message #410541 is a reply to message #410539]

Sun, 28 June 2009 06:02

Michel Cadot
Messages: 68718
Registered: March 2007
Location: Saint-Maur, France, https...

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

Re: Create DataBase Manualy [message #410552 is a reply to message #410539]

Sun, 28 June 2009 09:40

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:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Nov 29 13:52:09 CST 2024