OraFAQ Forum: Forms » Forms Cannot Connect

Home » Developer & Programmer » Forms » Forms Cannot Connect (Developer Suite 10G, database 10g, windows server 2008 64 bit)

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

Forms Cannot Connect [message #510406]

Sun, 05 June 2011 06:17

deepakmannazhi
Messages: 137
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

Report message to a moderator

Re: Forms Cannot Connect [message #510423 is a reply to message #510406]

Sun, 05 June 2011 15:20

Littlefoot
Messages: 21808
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?

Report message to a moderator

Re: Forms Cannot Connect [message #510424 is a reply to message #510423]

Sun, 05 June 2011 16:18

deepakmannazhi
Messages: 137
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

Report message to a moderator

Re: Forms Cannot Connect [message #510431 is a reply to message #510424]

Mon, 06 June 2011 00:10

Littlefoot
Messages: 21808
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

Certification matrices are on My Oracle Support so - take a look.

Report message to a moderator

Re: Forms Cannot Connect [message #510508 is a reply to message #510431]

Mon, 06 June 2011 04:57

deepakmannazhi
Messages: 137
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

Report message to a moderator

Re: Forms Cannot Connect [message #604384 is a reply to message #510508]

Mon, 30 December 2013 01:09

chat2raj.s
Messages: 161
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

Report message to a moderator

Re: Forms Cannot Connect [message #604391 is a reply to message #604384]

Mon, 30 December 2013 02:01

Littlefoot
Messages: 21808
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.

Report message to a moderator

Re: Forms Cannot Connect [message #604413 is a reply to message #604391]

Mon, 30 December 2013 06:40

chat2raj.s
Messages: 161
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.

Report message to a moderator

Re: Forms Cannot Connect [message #604444 is a reply to message #604413]

Mon, 30 December 2013 12:16

Littlefoot
Messages: 21808
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.

Report message to a moderator

Previous Topic:	can we create horizontal/vertical canvas on tab canvas page
Next Topic:	query multiple rows from one

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Apr 25 08:58:41 CDT 2024