OraFAQ Forum: Server Administration » manual creation of database

Home » RDBMS Server » Server Administration » manual creation of database

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

manual creation of database [message #654318]

Sat, 30 July 2016 05:15

askraju
Messages: 1
Registered: July 2016

Junior Member

Hi All,

I am gettining following error message , whille create instance , pls. let me know , what will the reason

CREATE  DATABASE "BA5D"
*
ERROR at line 1:
ORA-01092: ORACLE instance terminated. Disconnection forced
ORA-01501: CREATE DATABASE failed
ORA-01519: error while processing file '?/rdbms/admin/dcore.bsq' near line 88
ORA-00604: error occurred at recursive SQL level 1
ORA-01276: Cannot add file +DATA_BA5D/ba5d/datafile/system.260.541956497.  File
has an Oracle Managed Files file name.
Process ID: 21260
Session ID: 1887 Serial number: 33930

my create db statement

CREATE  DATABASE "BA5D"
    MAXLOGFILES 32
    MAXLOGMEMBERS 4
    MAXDATAFILES 1022
    MAXINSTANCES 1
    MAXLOGHISTORY 4090
LOGFILE
  GROUP 1 (
    '+REDO_BA5D/ba5d/onlinelog/redo_ba5d01.log',
    '+REDO_BA5D/ba5d/onlinelog/redo_ba5d02.log'
  ) SIZE 1024M BLOCKSIZE 512   ,
  GROUP 2 (
    '+REDO_BA5D/ba5d/onlinelog/redo_ba5d11.log',
    '+REDO_BA5D/ba5d/onlinelog/redo_ba5d12.log'
  ) SIZE 1024M  BLOCKSIZE 512 ,
  GROUP 3 (
    '+REDO_BA5D/ba5d/onlinelog/redo_ba5d21.log',
    '+REDO_BA5D/ba5d/onlinelog/redo_ba5d22.log'
  ) SIZE 1024M  BLOCKSIZE 512
  DATAFILE
        '+DATA_BA5D/ba5d/datafile/system.260.541956497' size 36000M AUTOEXTEND ON
   SYSAUX
         DATAFILE '+DATA_BA5D/ba5d/datafile/sysaux.259.541956511' size 2024M AUTOEXTEND ON
   DEFAULT TABLESPACE users
        DATAFILE '+DATA_BA5D/ba5d/datafile/users' SIZE 4800M   AUTOEXTEND ON
   DEFAULT TEMPORARY TABLESPACE tempts1
      TEMPFILE  '+DATA_BA5D/ba5d/datafile/temp01.dbf'  size 4800M AUTOEXTEND ON
   UNDO TABLESPACE undotbs
      DATAFILE '+DATA_BA5D/ba5d/datafile/undotbs01' size  10240M AUTOEXTEND ON
CHARACTER SET US7ASCII
NATIONAL CHARACTER SET AL16UTF16
;

--moderator edit: this was a posted as a reply to five year old topic in the Linux forum. I've split it off into it's own topic in a more appropriate location.
--I've also added [code] tags, please use them in future. jw.

[Updated on: Sat, 30 July 2016 06:40] by Moderator

Report message to a moderator

Re: manual creation of database [message #654323 is a reply to message #654318]

Sat, 30 July 2016 06:44

John Watson
Messages: 8960
Registered: January 2010
Location: Global Village

Senior Member

Welcome to the forum. Please read our OraFAQ Forum Guide and How to use [code] tags and make your code easier to read

You can't specify file names such as system.260.541956497, you need to get rid of that numeric suffix.

Apart from that, do you really want a system tablespace datafile of 36GB? That seems somewhat excessive, and will not be possible if you are using the default 8KB block size.

Report message to a moderator

Re: manual creation of database [message #654324 is a reply to message #654318]

Sat, 30 July 2016 06:58

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

Senior Member
Account Moderator

In addition:
+DATA_BA5D/ba5d/datafile/system.260.541956497
+DATA_BA5D/ba5d/datafile/users
+DATA_BA5D/ba5d/datafile/temp01.dbf
1/ Either you use OMF either you don't
2/ If you don't, be consistent in your data file naming either there is ".dbf" either there is not.

Report message to a moderator

Previous Topic:	Multiple DB Instances on single DB server/host
Next Topic:	Query runtime predictiction simulator in test like prod

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Nov 28 18:39:13 CST 2024