OraFAQ Forum: RAC & Failsafe

Home » Server Options » RAC & Failsafe » ora-00604,1461

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

ora-00604,1461 [message #250727]

Wed, 11 July 2007 01:49

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

Report message to a moderator

Re: ora-00604,1461 [message #250728 is a reply to message #250727]

Wed, 11 July 2007 01:53

Frank Naude
Messages: 4581
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:

Report message to a moderator

Re: ora-00604,1461 [message #250730 is a reply to message #250728]

Wed, 11 July 2007 01:57

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

Report message to a moderator

Re: ora-00604,1461 [message #259313 is a reply to message #250727]

Wed, 15 August 2007 00:26

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

Report message to a moderator

Re: ora-00604,1461 [message #259316 is a reply to message #250727]

Wed, 15 August 2007 00:36

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.

Report message to a moderator

Re: ora-00604,1461 [message #259338 is a reply to message #250730]

Wed, 15 August 2007 01:42

Michel Cadot
Messages: 68716
Registered: March 2007
Location: Saint-Maur, France, https...

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

Report message to a moderator

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:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Nov 21 17:03:08 CST 2024