ERROR during creating new Database
OS: Solaris 10 x86 (10/08)
Oracle: Release 10.2.0.2.0 - Production (Standard Edition)
I have just installed Oracle without basic/sample database. I was going to find out how to make it handy.
What I did:
---------------
# created initeric1.ora file
control_files = (/oradata/u01/controlfile/control1.ctl,/oradata/u01/controlfile/control2.ctl,/oracle/controlfile/control3.ctl)
undo_management = AUTO
undo_tablespace = UNDOTBS1
db_name = eric1
db_block_size = 8192
sga_max_size = 1073741824
sga_target = 1073741824
---------------
then "startup nomount" end here I stucked.
I have executed below (all paths exists)
---------------
SQL> create database eric1
logfile group 1 ('/oradata/u02/redo/redo1.log') size 100M,
group 2 ('/oradata/u02/redo/redo2.log') size 100M,
group 3 ('/oradata/u02/redo/redo3.log') size 100M
character set WE8ISO8859P1
national character set utf8
datafile '/oradata/u02/system/system.dbf' size 500M autoextend on next 10M maxsize unlimited extent management local
sysaux datafile '/oradata/u02/system/sysaux.dbf' size 100M autoextend on next 10M maxsize unlimited
undo tablespace undotbs1 datafile '/oradata/u02/system/undotbs1.dbf' size 100M
default temporary tablespace temp tempfile '/oradata/u02/system/temp01.dbf' size 100M;
---------------
...and this is an ERROR:
create database eric1
*
ERROR at line 1:
ORA-01092: ORACLE instance terminated. Disconnection forced
Now, I am not sure where I am and what to do next.
The above "CREATE" created redologs ONLY. Shouold I remove them ( by rm command ?? )and start it again OR somehow to fix it ?
Little help plz.
BTW. i was doing steps from this article and stopped in point 5:
http://www.dba-oracle.com/oracle_create_database.htm
Edited by: user639256 on 2009-10-24 09:47
Edited by: user639256 on 2009-10-24 09:48