Re: Help ...

Narendranath,

Check the syntax of your create database statement, The next thing to check are your env vars, i.e. ORACLE_HOME, ORACLE_SID etc. also check if the correct entry is in the '/etc/oratab' file.

Also the 'sql.bsq' file could be corrupted, browse the file near line 334, this file should be in $ORACLE_HOME/dbs. Oracle recommends three log files, I think the minimum size for them is 1M, check for your port.

Hope this helps.

--
Vikram Goel                                 Motorola email: vgoel_at_pts.mot.com
Sr. Oracle DBA - Consultant
Aerotek Inc.                                My email:  vgoel_at_emi.net

Motorola Info:
Mail Stop 39, Room S1014
1500 Gateway Blvd,
Boynton Beach, FL 33426 


In article <4kukkc$oq2_at_engnews2.Eng.Sun.COM>, NARENDRANATH KALLE <naren.kalle_at_Sun.COM> writes:


>Hi, 

>

>Can any one help me with this :


>

>OS : Solaris 2.5 

>

>Oracle 7.2.3

>

>>create database DELI                                                          

>  logfile 'delhi1' size 100K,

> 

>          'delhi2' size 100K

> 

>  datafile 'delhi_data' size 2M

> 

> ORA-01501: CREATE DATABASE failed

> 

> ORA-01519: error while processing file '?/dbs/sql.bsq' near line 334

> 

> ORA-00604: error occurred at recursive SQL level 1

> 

> ORA-01450: maximum key length (146) exceeded

>

>Thanx in advance ..

>

>Naren

>