Home » Infrastructure » Windows » ORA-00604 and ORA-01009 (oracle 10g and windows 2008 server)
ORA-00604 and ORA-01009 [message #403504] Sat, 16 May 2009 01:01 Go to next message
ejaz@cacts.com.bd
Messages: 1
Registered: May 2009
Location: Bangladesh
Junior Member

Hello,

I have had Oracle Database 10g Version 10.2.0.1.0 and Oracle Developer 10g version 9.0.4
installed on windows 2003 server std edition which was working well. I upgraded the O/S to windows 2008 server std edition. Now the sql is working but I received the follwoing error message when I try to connect the Database in Form Developer.

ORA-00604: error occured at recursive SQL Level 1
ORA-01009: missing mandatory parameter

and when try to run Report Bulder the error msg is

REP-0501 : unable to connect to the specified database.
ORA-00604: error occured at recursive SQL Level

can you please help me to solve this problem.

Regards
Ejaz
Re: ORA-00604 and ORA-01009 [message #403505 is a reply to message #403504] Sat, 16 May 2009 01:23 Go to previous messageGo to next message
Michel Cadot
Messages: 59499
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Without the code no way.
Check triggers.

Regards
Michel
Re: ORA-00604 and ORA-01009 [message #416652 is a reply to message #403504] Mon, 03 August 2009 14:04 Go to previous messageGo to next message
wbadmin
Messages: 2
Registered: January 2009
Location: USA
Junior Member
Error Message: ORA-00604 error occurred at recursive SQL level

Error 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

Error Message: ORA-01009 missing mandatory parameter[/url]
Error Cause:
A host language program call did not pass all required parameters.
Action:
Check the syntax for the call and enter all required parameters.



Error Message: REP-00501: Unable to connect to the specified database.
Cause:
Reports Builder tried to but could not connect to ORACLE. The possible causes of this error include the following: Case 1: ORACLE is temporarily unavailable. Case 2: Your connect information was not valid.

Action:
You can take the following actions to correct this error: If Case 1: Retry the operation. Contact your DBA if the problem persists. If Case 2: Check your connect information to make sure it is correct. If it is not, re-enter it and try to connect again.

[Updated on: Mon, 03 August 2009 14:28] by Moderator

Report message to a moderator

Re: ORA-00604 and ORA-01009 [message #416665 is a reply to message #403504] Mon, 03 August 2009 15:12 Go to previous message
BlackSwan
Messages: 22926
Registered: January 2009
Senior Member
>Reports Builder tried to but could not connect to ORACLE.
This is no a database problem but Reports Server problem.

Post Operating System (OS) name & version for DB server system.
Post results of SELECT * from v$version.
Post Operating System (OS) name & version for Reports Server system.
Post Oracle version to 4 decimal place of Reports Server s/w.
Previous Topic: How to read BLOB in .NET??
Next Topic: Oracle 11i on Win 2003 server
Goto Forum:
  


Current Time: Thu Oct 30 18:04:01 CDT 2014

Total time taken to generate the page: 0.10873 seconds