Home » RDBMS Server » Server Administration » Error While Creating The Database (Oracle,10.2.0,Redhat 5)
Error While Creating The Database [message #526955] Thu, 13 October 2011 22:58 Go to next message
kailas
Messages: 21
Registered: September 2011
Location: pune
Junior Member
CREATE DATABASE college
datafile '/disk2/oradata/college/system.dbf' size 150m autoextend on

sysaux datafile '/disk2/oradata/college/sysaux.dbf' size 100m autoextend on

default temporary tablespace temp tempfile '/disk2/oradata/college/temp.dbf' size 10m

default tablespace userdata datafile '/disk2/oradata/college/userdata.dbf' size 10m

undo tablespace undotbs datafile '/disk2/oradata/college/undotbs.dbf' size 10m

logfile
group 1 ('/disk2/oradata/college/redolog1a.log','/disk2/oradata/college/redolog1b.log') size 5000k,
group 2 ('/disk2/oradata/college/redolog2a.log','/disk2/oradata/college/redolog2b.log') size 5000k

controlfile reuse;



I have saved this script in createdb.sql.and it saved in $ORACLE_HOME/notes folder.I used the following steps to run this
script but it's give me error
[oracle@localhost dbs]$ export ORACLE_SID=college
[oracle@localhost dbs]$ sqlplus '/as sysdba'

SQL*Plus: Release 10.2.0.1.0 - Production on Fri Oct 14 09:21:45 2011

Copyright (c) 1982, 2005, Oracle.  All rights reserved.

Connected to an idle instance.

SQL> startup nomount
ORA-32004: obsolete and/or deprecated parameter(s) specified
ORACLE instance started.

Total System Global Area  100663296 bytes
Fixed Size                  1217884 bytes
Variable Size              88083108 bytes
Database Buffers            8388608 bytes
Redo Buffers                2973696 bytes
SQL> @$ORACLE_HOME/notes/createdb.sql
SP2-0734: unknown command beginning "sysaux dat..." - rest of line ignored.
SP2-0734: unknown command beginning "default te..." - rest of line ignored.
SP2-0734: unknown command beginning "default ta..." - rest of line ignored.
SP2-0734: unknown command beginning "undo table..." - rest of line ignored.
SP2-0044: For a list of known commands enter HELP
and to leave enter EXIT.
SP2-0042: unknown command "logfile" - rest of line ignored.
SP2-0734: unknown command beginning "group 1 ('..." - rest of line ignored.
SP2-0734: unknown command beginning "group 2 ('..." - rest of line ignored.
SP2-0734: unknown command beginning "controlfil..." - rest of line ignored.
SP2-0044: For a list of known commands enter HELP
and to leave enter EXIT.




i am not able to understand what went wrong in this script or steps.
Re: Error While Creating The Database [message #526956 is a reply to message #526955] Thu, 13 October 2011 23:02 Go to previous messageGo to next message
BlackSwan
Messages: 22803
Registered: January 2009
Senior Member
I suggest you use dbca to create new DB or at least to create the scripts that would CREATE DATABASE successfully.

http://www.orafaq.com/wiki/Oracle_database_FAQ

[Updated on: Thu, 13 October 2011 23:04]

Report message to a moderator

Re: Error While Creating The Database [message #526957 is a reply to message #526956] Thu, 13 October 2011 23:04 Go to previous messageGo to next message
kailas
Messages: 21
Registered: September 2011
Location: pune
Junior Member
That's Ok

But why this script is not able to execute
Re: Error While Creating The Database [message #526958 is a reply to message #526957] Thu, 13 October 2011 23:06 Go to previous messageGo to next message
BlackSwan
Messages: 22803
Registered: January 2009
Senior Member
>But why this script is not able to execute
it has syntax error that I am unwilling to Read The Fine Manual to specifically determine.

http://download.oracle.com/docs/cd/E11882_01/server.112/e26088/statements_5004.htm#i2061233
Re: Error While Creating The Database [message #526960 is a reply to message #526958] Thu, 13 October 2011 23:28 Go to previous messageGo to next message
kailas
Messages: 21
Registered: September 2011
Location: pune
Junior Member
Thanks,
I used the dbca to create the scripts and the run that scripts it runs sucessfully. but i have one issue on system tablespace whether it should be set to dictionery or locally managed.
Re: Error While Creating The Database [message #526961 is a reply to message #526960] Thu, 13 October 2011 23:31 Go to previous messageGo to next message
BlackSwan
Messages: 22803
Registered: January 2009
Senior Member
>I used the dbca to create the scripts and the run that scripts it runs sucessfully. but i have one issue on system tablespace whether it should be set to dictionery or locally managed.

current releases only use LMT; so you make the call.
It is your DB.
Re: Error While Creating The Database [message #526964 is a reply to message #526955] Fri, 14 October 2011 01:01 Go to previous message
Michel Cadot
Messages: 59194
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
By default SQL*Plus interprets a blank line as an abort of the query you are writing and the next line as a beginnng of a new statement.

Either remove blank lines or execute:
Set SQLBLANKLINES ON


Regards
Michel
Previous Topic: how to split a default subpartition
Next Topic: TNS-03505: Failed to resolve name
Goto Forum:
  


Current Time: Tue Sep 23 08:19:29 CDT 2014

Total time taken to generate the page: 0.26616 seconds