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
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:
This worked..Thanks a lot Dude
Post a Comment