Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: sql.bsq is missing
sql.bsq contains definitions for your dictionary, dynamic views, etc. I would
not advice mixing versions.
In article <6s1a7o$e6e$1_at_nnrp1.dejanews.com>,
james_at_valhall.esrin.esa.it wrote:
> When I attempted to create a new 7.3.4.2.0 database I got the error:
>
> ORA-01501: CREATE DATABASE failed
> ORA-01526: error in opening file '?/dbs/sql.bsq'
>
> I went hunting for sql.bsq and found, for the four versions of Oracle
> installed on this unix server:
>
> 7.2.2: $ORACLE_HOME/dbs/sql.bsq
> 7.3.2: $ORACLE_HOME/dbs/sql.bsq
> 7.3.4: ** completely missing **
> 8.0.4: $ORACLE_HOME/rdbms/admin/sql.bsq
>
> So it looks like in v8 the file has moved (no big problem) but
> for v7.3.4 I don't have the file at all... the problem is that I
> already have an instance running happily under 7.3.4 which was
> upgraded from 7.2.2 so I can't simply reinstall the product or
> I would blow that db away. What if I cp the sql.bsq file into
> $ORACLE_HOME/dbs from the installation CD? Has anybody seen this
> problem before?
>
> Thanks in advance,
> James
>
> -----== Posted via Deja News, The Leader in Internet Discussion ==-----
> http://www.dejanews.com/rg_mkgrp.xp Create Your Own Free Member Forum
>
-----== Posted via Deja News, The Leader in Internet Discussion ==----- http://www.dejanews.com/rg_mkgrp.xp Create Your Own Free Member Forum Received on Wed Sep 09 1998 - 17:05:58 CDT