| ORA-00604 and ORA-00904 [URGENT] [message #55873] |
Fri, 21 February 2003 03:12  |
canibal dragon
Messages: 4
Registered: February 2003
|
Junior Member |
|
|
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 :
SVRMGR>connect internal
SVRMGR>select * from cat;
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)
i need help
thx
|
|
|
|
|
|
| Re: ORA-00604 and ORA-00904 [URGENT] [message #55876 is a reply to message #55873] |
Fri, 21 February 2003 08:03  |
ctg
Messages: 146
Registered: July 2002
|
Senior Member |
|
|
lets go back to the basics then:
the pfile you are specifying, does it match the pfile in your ORACLE_HOME/dbs directory?
SVRMGRL> startup
-- this uses the pfile in the default location
SVRMGRL> startup pfile=?
-- this uses the pfile you specify
|
|
|
|
|
|
| Re: ORA-00604 and ORA-00904 [URGENT] [message #55892 is a reply to message #55873] |
Fri, 21 February 2003 21:01 |
Vijaya Bhaskr
Messages: 2
Registered: February 2003
|
Junior Member |
|
|
Hi,
In ur question u r trying to select from the catalog.
If u r connected to sys schema using svrmgr cat fail coz the cat which is a view on user_tables wont find since he is a owner of dta dictionary.
If u want the list select the dat from user_tables or others (dba_ n all_) with where n if u want the list for particular users with where clause.
Hope this will olve the prole :)
Bye
|
|
|
|
|
|
| Re: ORA-00604 and ORA-00904 [URGENT] [message #55901 is a reply to message #55873] |
Sat, 22 February 2003 12:54 |
ctg
Messages: 146
Registered: July 2002
|
Senior Member |
|
|
try this:
svrmgrl> startup
svrmgrl> select name from v$controlfile
union
select name from v$datafile
union
select member from v$logfile;
-- Note the file names
svrmgrl> shutdown
svrmgrl> startup pfile=?
svrmgrl> select name from v$controlfile
union
select name from v$datafile
union
select member from v$logfile;
-- Note the file names
are the files the same? if they are NOT, then you have 2 databases on your machine.
|
|
|
|
|
|
| ORA-00604 Plz help [message #56157 is a reply to message #55873] |
Mon, 10 March 2003 02:26 |
sujit
Messages: 94
Registered: April 2002
|
Member |
|
|
Hi,
I am running a form which has several update & insert commands (form6i) in oracle 8i(8.1.7) on P4 machine RAM256KB. I am getting the message ORA-00604 un handelled exception every now & then with one insert or update command. What should i do to get rid of it. Same form is already tested and there is no bugs there.
Kind ly help.
Regards....
Sujit
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
