Re: ORA-01503: CREATE CONTROLFILE failed

As others have said, any time you see an Ora-600 error, call support.

However, before you do so, since nothing is obviously wrong with your script, I would just check that the locations of the controlfiles as specified in the init.ora are legitimate, that Oracle has write permissions to those directories, and that the controlfiles to be created don't already exist.

Regards
HJR "james" <kdhakal_at_eline.com> wrote in message news:fn5w6.3087$Up.138324_at_sea-read.news.verio.net...
> hi! I got this error when I tried to create control file in order to
 change
> database name during
> the the process of database cloning. below is the script I use for
 creating
> controfile:
> CREATE CONTROLFILE SET DATABASE "newname" RESETLOGS ARCHIVELOG
> MAXLOGFILES 16
> MAXLOGMEMBERS 2
> MAXDATAFILES 30
> MAXINSTANCES 1
> MAXLOGHISTORY 226
> LOGFILE
> GROUP 1 (
> '/U03/path1/redo01.log',
> '/U03/path1/redo01A.log'
> ) SIZE 5M,
> GROUP 2 (
> '/U03/path1/redo02.log',
> '/U03/path1/redo02A.log'
> ) SIZE 5M,
> GROUP 3 (
> '/U03/path1/redo03.log',
> '/U03/path1/redo03A.log'
> ) SIZE 5M
> DATAFILE
> '/U03/path1/system01.dbf',
> '/U03/path1/rbs01.dbf',
> '/U03/path1/indx01.dbf',
> '/U03/path1/users01.dbf',
> '/U03/path1/temp01.dbf',
> '/U03/path1/drsys01.dbf',
> '/U03/path1/data.dbf'
> CHARACTER SET US7ASCII;
>
> CREATE CONTROLFILE SET DATABASE "newname" RESETLOGS ARCHIVELOG
> *
> ORA-01503: CREATE CONTROLFILE failed
> ORA-00600: internal error code, arguments: [kzsrsdn: 1], [32], [], [], [],
> [], [], []
>
> has anyone had this experience before during database cloning(in the same
> machine)? if yes, I
> would like to know the cause and solution of this.
> I am running oracle 8.1.5 on Sun solaris 8.
> Thanks in advance.
>
>
>
Received on Wed Mar 28 2001 - 02:24:21 CST