Re: Pb creating database

In article <3fb1217b.0207300726.5d36c17e_at_posting.google.com>, ccosette_at_hotmail.com says...
>
>I have this error while creating a database:
>
>sqlplus /nolog
>SVRMGR> connect / as sysdba
>SVRMGR> startup nomount
>ORACLE instance started.
>Total System Global Area 139685872 bytes
>Fixed Size 69616 bytes
>Variable Size 88752128 bytes
>Database Buffers 50331648 bytes
>Redo Buffers 532480 bytes
>SVRMGR> _at_crebas.sql
>CREATE DATABASE test
>*
>ORA-01501: CREATE DATABASE failed
>ORA-01519: error while processing file '?/rdbms/admin/sql.bsq' near line 4068
>ORA-01527: error while reading file
>ORA-07243: sftget: supplied buffer not big enough to hold entire line.
>Additional information: 8190
>
>
>where crebas.sql contains:
>-------------------------
>CREATE DATABASE test
> MAXINSTANCES 1
> MAXLOGFILES 5
> CHARACTER SET US7ASCII
>
> DATAFILE '/opt/oracle/OraHome1/oradata/test/system01.dbf' SIZE 80M
>
> DEFAULT TEMPORARY TABLESPACE temp
> TEMPFILE '/opt/oracle/OraHome1/oradata/test/temp.dbf' SIZE 5M REUSE
> EXTENT MANAGEMENT LOCAL UNIFORM SIZE 64K
>
> LOGFILE '/opt/oracle/OraHome1/oradata/test/redo01.log' SIZE 512k,
> '/opt/oracle/OraHome1/oradata/test/redo02.log' SIZE 512k,
> '/opt/oracle/OraHome1/oradata/test/redo03.log' SIZE 512k;
>--------------------------
Interesting. This error indicates that a line in sql.bsq is longer than the size of the buffer (8190) that was provided for it by the Oracle process creating the database.

I'm guessing, but it may be because the file has been corrupted somehow.

I suggest contacting Oracle Support. This might be a known problem.

                                     Rick

P.S. In the future, please provide version and platform information - Thanks.

                                Rick Wessman
                                Oracle Corporation

     The opinions expressed above are mine and do not necessarily reflect
                         those of Oracle Corporation.