Home » Server Options » RAC & Failsafe » ora-00604,1461
ora-00604,1461 [message #250727] Wed, 11 July 2007 01:49 Go to next message
ursg02
Messages: 10
Registered: July 2007
Location: Pune
Junior Member
Hi,
In morning i look up folowing errors
i hv serch these error but can't get answer
Errors in file /oracle/product/ora10g/dbR2/admin/mydb/bdump/mydb_smon_10450.trc:
ORA-00604: Message 604 not found; No message file for product=RDBMS, facility=ORA; arguments: [1]
ORA-01461: Message 1461 not found; No message file for product=RDBMS, facility=ORA
Re: ora-00604,1461 [message #250728 is a reply to message #250727] Wed, 11 July 2007 01:53 Go to previous messageGo to next message
Frank Naude
Messages: 4579
Registered: April 1998
Senior Member
Oracle cannot lookup the error message text as there is something wrong with your environment settings. Here is the messages:

00604, 00000, "error occurred at recursive SQL level %s"
// *Cause:  An error occurred while processing a recursive SQL statement
//         (a statement applying to internal dictionary tables).
// *Action: If the situation described in the next error on the stack
//         can be corrected, do so; otherwise contact Oracle Support.


01461, 00000, "can bind a LONG value only for insert into a LONG column"
// *Cause:
// *Action:

Re: ora-00604,1461 [message #250730 is a reply to message #250728] Wed, 11 July 2007 01:57 Go to previous messageGo to next message
ursg02
Messages: 10
Registered: July 2007
Location: Pune
Junior Member
Thanks,
but what is the meaning of No message file for product=RDBMS, facility=ORA, it's oracle internal error or database error.
pls send me detail
Re: ora-00604,1461 [message #259313 is a reply to message #250727] Wed, 15 August 2007 00:26 Go to previous messageGo to next message
ahmed123
Messages: 9
Registered: August 2007
Location: india
Junior Member

hiii everyone

iam getting the following error in my oracle client

for every query...

SQL> select username from dba_users;
select username from dba_users
*
ERROR at line 1:
ORA-00942: table or view does not exist

whts the problem ...
can anyone help

thanks in advance
Re: ora-00604,1461 [message #259316 is a reply to message #250727] Wed, 15 August 2007 00:36 Go to previous messageGo to next message
Arju
Messages: 1554
Registered: June 2007
Location: Dhaka,Bangladesh. Mobile:...
Senior Member

Hai ahmed you should create a new thread for this.

You are running the query that don't have privilege on dba_users table.May have this user is not in dba group.

So run the qury with the user that have access on the table.
Re: ora-00604,1461 [message #259338 is a reply to message #250730] Wed, 15 August 2007 01:42 Go to previous message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Quote:
what is the meaning of No message file for product=RDBMS, facility=ORA,

It means that Oracle can't find the files containing the error messages.
Check your ORACLE_HOME/rdbms/mesg directory if it contains *.msb files.

Regards
Michel
Previous Topic: Oracle RAC on VMware XP (host) CentOS (gues OS)
Next Topic: RAC Installation on Solaris 5.9 with Veritas Foundation 4.1MP2
Goto Forum:
  


Current Time: Thu Mar 28 16:25:55 CDT 2024