Home » RDBMS Server » Server Administration » manual creation of database
manual creation of database [message #654318] Sat, 30 July 2016 05:15 Go to next message
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 Go to previous messageGo to next message
John Watson
Messages: 8922
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.
Re: manual creation of database [message #654324 is a reply to message #654318] Sat, 30 July 2016 06:58 Go to previous message
Michel Cadot
Messages: 68624
Registered: March 2007
Location: Nanterre, France, http://...
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.

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


Current Time: Thu Mar 28 03:39:37 CDT 2024