Home » Developer & Programmer » Forms » Forms Cannot Connect (Developer Suite 10G, database 10g, windows server 2008 64 bit)
Forms Cannot Connect [message #510406] Sun, 05 June 2011 06:17 Go to next message
deepakmannazhi
Messages: 134
Registered: February 2010
Location: Dubai, UAE
Senior Member

Dear All,
How are you..?
I'm not sure, this is the rite place or not. Excuse me If m wrong.

We have installed Quote:
Forms Version 9.0.4.0.19 [32 Bit]in windows server 2008 64 bit.


Our sources are in this versionQuote:
(Forms Version 9.0.4.0.19 [32 Bit])
, and we cannot do a sudden change to latest version.

The database we installed is
Quote:

Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Prod
PL/SQL Release 10.2.0.1.0 - Production
CORE 10.2.0.1.0 Production
TNS for 32-bit Windows: Version 10.2.0.1.0 - Production
NLSRTL Version 10.2.0.1.0 - Production



We installed it in compatibility mode. Now the database is connecting properly. When we try to connect forms, it is showing the following message

Quote:
ORA-00604:error occurred at recursive SQL level 1
ORA-01009:missing mandatory parameter


Which one I have to update..? Forms or Database..?
Could you please suggest me a solution for this...

Thanks in advance

With love and Regards
Deepak

Re: Forms Cannot Connect [message #510423 is a reply to message #510406] Sun, 05 June 2011 15:20 Go to previous messageGo to next message
Littlefoot
Messages: 21420
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Most probably bad news.
Oracle

ORA-00604: error occurred at recursive SQL level string

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.


Oracle

ORA-01009: missing mandatory parameter

Cause: A host language program call did not pass all required parameters.

Action: Check the syntax for the call and enter all required parameters.


Did you check whether your Forms version is certified with operating system you use? You mentioned "compatibility mode" - compatible to what, exactly?
Re: Forms Cannot Connect [message #510424 is a reply to message #510423] Sun, 05 June 2011 16:18 Go to previous messageGo to next message
deepakmannazhi
Messages: 134
Registered: February 2010
Location: Dubai, UAE
Senior Member

Dear Littlefoot,

Thanks for your valuable information... Smile

We are installing Developer suite Quote:
Version 9.0.4.0.19 [32 Bit]
in Quote:
windows server 2008 64 bit
. I have searched before whether it is possible to install and from one forum I got the following information:
Quote:
i was able to install it by setting the compatibility mode to windows server 2003 SP1 and executing the setup as administrator.
i've received 2 errors during the installation but it is possible to continue (in the first case) and retry (in the second, the second attempt went fine)


I did the same.
Now we cannot connect Forms.

Could you please tel us which version of Developer suite is certified to Windows server 2008 64 bit.


Thanks and Regards
Deepak
Re: Forms Cannot Connect [message #510431 is a reply to message #510424] Mon, 06 June 2011 00:10 Go to previous messageGo to next message
Littlefoot
Messages: 21420
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Certification matrices are on My Oracle Support so - take a look.
Re: Forms Cannot Connect [message #510508 is a reply to message #510431] Mon, 06 June 2011 04:57 Go to previous messageGo to next message
deepakmannazhi
Messages: 134
Registered: February 2010
Location: Dubai, UAE
Senior Member

Dear Littlefoot,
Thanks..
From Certification matrices I didn't found any Certification for Oracle Developer suite 10g on windows server 2008.
I have installed Quote:
Oracle Developer Suite 10.1.2.0.2
in compatibility mode Quote:
Windows Server 2003 SP1
and the forms is connected now Smile. I will update the other things after finishing everything

Thanks and Regards
Deepak
Re: Forms Cannot Connect [message #604384 is a reply to message #510508] Mon, 30 December 2013 01:09 Go to previous messageGo to next message
chat2raj.s
Messages: 108
Registered: October 2010
Location: Chennai, India
Senior Member
Hi Deepak,

I have the same problem as u explained here. I have installed Forms/Reports 10g in my Windows 7 machine and iam getting the same error as you have mentioned.

Can you let me know if you found any solution for the same.

Thanks
RajS
Re: Forms Cannot Connect [message #604391 is a reply to message #604384] Mon, 30 December 2013 02:01 Go to previous messageGo to next message
Littlefoot
Messages: 21420
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
He said that he installed Developer Suite in compatibility mode for Windows Server 2003 SP1.
Re: Forms Cannot Connect [message #604413 is a reply to message #604391] Mon, 30 December 2013 06:40 Go to previous messageGo to next message
chat2raj.s
Messages: 108
Registered: October 2010
Location: Chennai, India
Senior Member
I too installed Forms 10g using compatablity and after which even Forms builder 6i version / sql tools were not connecting to the database. Then finally after resetting the PATH variable to point back to 6i installation home, the problem got resolved now (After 10g installation, the PATH was referring to the new home). Hope the 10g version didn't install properly. Need to work on it again.

Thanks for your support.
Re: Forms Cannot Connect [message #604444 is a reply to message #604413] Mon, 30 December 2013 12:16 Go to previous message
Littlefoot
Messages: 21420
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Right; that's how it goes when you run unsupported & not certified combination of Oracle software and operating system. There are chances to make it work, but the process is time consuming and rather painful.
Previous Topic: can we create horizontal/vertical canvas on tab canvas page
Next Topic: query multiple rows from one
Goto Forum:
  


Current Time: Sat Jul 21 12:14:17 CDT 2018