Monday, July 16, 2012

ORA-01127, ORA-01163 during database creation


In my earlier post i mentioned how to create/add another database in an existing server (http://www.chandu208.blogspot.com/2012/07/add-another-database-on-existing-server.html). Again today i'm creating new instance on an existing server and hit an error

ERROR: ORA-01127: database name 'RCDEV' exceeds size limit of 8 characters
CAUSE: The database name mentioned above exceeds the limit set
SOLUTION: change the database name to 8 or less characters

Then changed the name to 8 characters
Then error resolved

Now, running the control file script to create controlfiles for new database
SQL > @con.ctl
CREATE CONTROLFILE REUSE DATABASE "RCDEV" NORESETLOGS ARCHIVELOG
*
ERROR at line 1:
ORA-01503: CREATE CONTROLFILE failed
ORA-01163: SIZE clause indicates 12800 (blocks), but should match header 640
ORA-01110: data file 4: '/OPT/ORACLE/ORADATA/RCDEV/USERS01.DBF'

Vi con.ctl

CREATE CONTROLFILE SET DATABASE "RCDEV" RESETLOGS  NOARCHIVELOG
    MAXLOGFILES 16
    MAXLOGMEMBERS 3
    MAXDATAFILES 100
    MAXINSTANCES 8
    MAXLOGHISTORY 292
LOGFILE
  GROUP 1 '/opt/oracle/oradata/ RCDEV/redo01.log'  SIZE 1024M BLOCKSIZE 512,
  GROUP 2 '/opt/oracle/oradata/ RCDEV/redo02.log'  SIZE 1024M BLOCKSIZE 512,
  GROUP 3 '/opt/oracle/oradata/ RCDEV/redo03.log'  SIZE 1024M BLOCKSIZE 512,
  GROUP 4 '/opt/oracle/app/fast_recovery_area/ RCDEV/onlinelog/o1_mf_4_7zscnkom_.log'  SIZE 100M BLOCKSIZE 512
-- STANDBY LOGFILE
DATAFILE
  '/opt/oracle/oradata/ RCDEV/system01.dbf',
  '/opt/oracle/oradata/ RCDEV/sysaux01.dbf',
  '/opt/oracle/oradata/ RCDEV/undotbs01.dbf',
  '/opt/oracle/oradata/ RCDEV/users01.dbf',                 ß Comma leads to an error
CHARACTER SET WE8MSWIN1252
;


Then deleted that ‘comma’ and reran the con.ctl script then controlfiles have been created.

1 comments:

Unknown said...

This worked..Thanks a lot Dude

Post a Comment

Auto Scroll Stop Scroll