Re: Recursive error in second instance

In article <806jen$ts4$1_at_nnrp1.deja.com>,   fiddler_dan_at_my-deja.com wrote:
> Would someone please help me whith creating
> second instance of Oracle 7.3.4.0.1 on Solaris.
> The first instance is already running without
> any problem.
> I changed SID and started up the new instance
> with the same parameters as the first one (except
> of db_name and control files). Then I created a
> new database. After executing first row of
> catalog.sql, the following error occurs:
>
> -----------------------------------------------
> create or replace view v_$controlfile as select *
> from v$controlfile
>
> ORA-00604: error occured at recursive SQL level 1
> ORA-00904: invalid column name
> -----------------------------------------------
> Executing only "select *..." goes OK.
> So what's wrong ?
> Thank you in advance.
> Daniel
>
> (sorry for my English)

  It's my second attempt to get answer on the question why I can't properly start up the second instance of Oracle database. Maybe my description of the problem in the first mail was bad.   Actually none of the "CREATE VIEW..." statements is processed, there is always "recursive error" and "invalid column name". In the result even the catalog script isn't executed properly.   Under the first instance everything goes OK. Does anyone have the same problem? Does anyone know the explanation? Thank you in advance.
Daniel

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Sun Nov 14 1999 - 11:59:24 CST