OraFAQ Forum: Linux » create database error

Home » Infrastructure » Linux » create database error (oracle10g)

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

create database error [message #277918]

Thu, 01 November 2007 03:57

DUSTU JANU
Messages: 1
Registered: October 2007

Junior Member

hi whene i run the following sql script

CREATE DATABASE mydb
USER SYS IDENTIFIED BY oracle
USER SYSTEM IDENTIFIED BY oracle
LOGFILE GROUP 1 ('/u01/app/oracle/oradata/mydb/redo01.log') SIZE 50M,
GROUP 2 ('/u01/app/oracle/oradata/mydb/redo02.log') SIZE 50M,
GROUP 3 ('/u01/app/oracle/oradata/mydb/redo03.log') SIZE 50M
MAXLOGFILES 5
MAXLOGMEMBERS 5
MAXLOGHISTORY 1
MAXDATAFILES 100
MAXINSTANCES 1
CHARACTER SET AL32UTF8
NATIONAL CHARACTER SET UTF8
DATAFILE '/u01/app/oracle/oradata/mydb/system01.dbf' SIZE 250M REUSE
EXTENT MANAGEMENT LOCAL
SYSAUX DATAFILE '/u01/app/oracle/oradata/mydb/sysaux01.dbf' SIZE 250M REUSE
DEFAULT TABLESPACE user_default
DATAFILE '/u01/app/oracle/oradata/mydb/default_tab01.dbf' SIZE 250M
EXTENT MANAGEMENT LOCAL UNIFORM SIZE 1M
DEFAULT TEMPORARY TABLESPACE tempts1
TEMPFILE '/u01/app/oracle/oradata/mydb/temp01.dbf'
SIZE 50M REUSE
UNDO TABLESPACE undotbs
DATAFILE '/u01/oracle/oradata/mydb/undotbs01.dbf'
SIZE 100M REUSE AUTOEXTEND ON MAXSIZE UNLIMITED;
/

the following error message is being shown

CREATE DATABASE mydb
*
ERROR at line 1:
ORA-01092: ORACLE instance terminated. Disconnection forced

ERROR:
ORA-03114: not connected to ORACLE

but out of 8 , 7 files are created in the given path instead SYSAUX file.

can pls sen me the remedy as soon as possible

thanx

Report message to a moderator

Re: create database error [message #277923 is a reply to message #277918]

Thu, 01 November 2007 04:05

Michel Cadot
Messages: 68641
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

Read and follow OraFAQ Forum Guide, especially "How to format your post?" section.
Make sure that lines of code do not exceed 80 characters when you format. Use the "Preview Message" button.
Always post your Oracle version (4 decimals).

Check the alert.log file and any other trace one.

Regards
Michel

Report message to a moderator

Re: create database error [message #278078 is a reply to message #277923]

Thu, 01 November 2007 14:07

DreamzZ
Messages: 1666
Registered: May 2007
Location: Dreamzland

Senior Member

 UNDO TABLESPACE undotbs
DATAFILE '/u01/oracle/oradata/mydb/undotbs01.dbf'
SIZE 100M REUSE AUTOEXTEND ON MAXSIZE UNLIMITED;

Also verify the UNDO tablespace name in PFILE.

Report message to a moderator

Previous Topic:	Oracle Host CPU was a bottleneck - Server shutdown
Next Topic:	rpm

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Apr 18 03:09:58 CDT 2024