Re: ORA-00604 and ORA-00904 error

julius99 wrote:
> Hi,
>
> I use Oracle 7.3.4.0.0 on UNIX SCO operating system
> When i made a normal startup of the base, the request "select * from
> cat;" work normally
> But when i make a startup with an init.ora file i have this error
> message :
> ORA-00604: error occured at recursive SQL level 1
> ORA-00904: invalid column name (it points on "cat")
>
> And then, the same problem appears when i want to export the data base
>
> anyone knows why i have this error messages ??
>
> The init.ora has this form :
>
> db_file_multiblock_read_count = 8 #
> SMALL
> db_block_buffers = 60 #
> SMALL
> shared_pool_size = 3500000 #
> SMALL
> log_checkpoint_interval = 10000
> processes = 50 #
> SMALL
> dml_locks = 100 #
> SMALL
> log_buffer = 8192 #
> SMALL
> sequence_cache_entries = 10 #
> SMALL
> sequence_cache_hash_buckets = 10 #
> SMALL
> max_dump_file_size = 10240 # limit trace file size to 5 Meg each
> transactions_per_rollback_segment
> connects to
> global_names = TRUE
> db_name.db_domain
>
> # define directories to store trace and alert files
> background_dump_dest = $REP_INST/trace
> user_dump_dest = $REP_INST/trace
>
> db_name = mybase
>
> control_files=$REP_INST/control/control1.ora
> $REP_INST/control/control2.ora
>
> # gestion des ROLLBACK SEGMENTS
> rollback_segments = (SYSTEM, ROLL_SEG1)
>
> thx
>
> --
> Posted via http://dbforums.com
>

check if you use the init.ora file you startup with. Looks like you have two different ones, check $ORACLE_HOME/dbs - there should be an entry, either a complete file, or a link to your admin diry

-- 
Regards, Frank van Bortel