OraFAQ Forum: Forms » Oracle9i with Developer6i issue

Home » Developer & Programmer » Forms » Oracle9i with Developer6i issue

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

Oracle9i with Developer6i issue [message #267371]

Thu, 13 September 2007 02:12

mnajam
Messages: 5
Registered: September 2007
Location: Pakistan

Junior Member

I use WindowsXP professional Edition Version 2002 Service Pack 2 and Oracle 9i Enterprise Edition Server machine (Windows2003)

I installed oracle 9.2.0.1 client then installed oracle forms 6i version 6.0.8.11.3. I need to be able to start up forms and then be able to connect to the instance created in oracle 9i. I cannot recall how to do this. I just want forms to be able to connect to this 9i database.i installed them into different homes

When i connect oracle 9.2.0.1 client (sqlplus) no error.but when i connect from oracle forms 6i version 6.0.8.11.3 Error IS ORA-12154: TNS:could not resolve service name

after that I copy file client Home =oracle\ora92\network\admin\tnsnames.ora and sqlnet.ora and paste to oracleForm\ora92\Net80\Admin\tnsnames.ora and sqlnet.ora

error is OBE-15387: Login failed and ORA-03106: fatal two-task communication protocol error

Attachment: tnsnames and sqlnet.txt
(Size: 0.58KB, Downloaded 1081 times)

Report message to a moderator

Re: Oracle9i with Developer6i issue [message #267611 is a reply to message #267371]

Thu, 13 September 2007 20:15

djmartin
Messages: 10181
Registered: March 2005
Location: Surges Bay TAS Australia

Senior Member
Account Moderator

Why did you call the Forms 6i home "oracleForm\ora92"?

Okay. Put the Forms 6i files back. (You did keep a copy didn't you?) Add the extra information from the 6i copy to the 9i database copy and either use the 'ifile' construct (search this forum for 'ifile') to associate the two, or use the 'tns_admin' environment variable to point to the database copy of tnsnames.ora

David

Report message to a moderator

Re: Oracle9i with Developer6i issue [message #268568 is a reply to message #267371]

Wed, 19 September 2007 02:09

mnajam
Messages: 5
Registered: September 2007
Location: Pakistan

Junior Member

I use WindowsXP professional Edition Version 2002 Service Pack 2 and Oracle 9i Enterprise Edition Server machine(windows2003)
I installed oracle 9.2.0.1 client then installed oracle forms 6i version 6.0.8.11.3. I need to be able to start up forms and then be able to connect to the instance created in oracle 9i. I cannot recall how to do this. I just want forms to be able to connect to this 9i database.i installed them into different homes

When i connect oracle 9.2.0.1 client (sqlplus) no error.but when i connect from oracle forms 6i version 6.0.8.11.3 Error IS ORA-12154: TNS:could not resolve service name

after that I copy file client Home =oracle\ora92\network\admin\tnsnames.ora and sqlnet.ora and paste to oracleForm\ora92\Net80\Admin\tnsnames.ora and sqlnet.ora

error is OBE-15387: Login failed and ORA-03106: fatal two-task communication protocol error

when server is turn off same error generate on sqlplus (Oracle 9i) and developer 6i connecting from database server
Error is ORA-12545: Connect failed because target host or object does not exist.

Report message to a moderator

Re: Oracle9i with Developer6i issue [message #268576 is a reply to message #268568]

Wed, 19 September 2007 02:18

djmartin
Messages: 10181
Registered: March 2005
Location: Surges Bay TAS Australia

Senior Member
Account Moderator

Copying the 9i database files to the 9i client files doesn't help Forms 6i to run. You need to change the Forms 6i copy of the files to know what is currently in the 9i database fiels.

STOP COPYING and just READ the files and update them OR use 'ifiles' OR use 'tns_admin'.

David

Upd: Change 'ifles' to 'ifiles'.

[Updated on: Sun, 23 September 2007 23:35]

Report message to a moderator

Re: Oracle9i with Developer6i issue [message #268577 is a reply to message #268568]

Wed, 19 September 2007 02:18

mnajam
Messages: 5
Registered: September 2007
Location: Pakistan

Junior Member

not call when i create new form and enter UserID/Password@ServiceName error occur ora-03106

[Updated on: Wed, 19 September 2007 02:21]

Report message to a moderator

Re: Oracle9i with Developer6i issue [message #268585 is a reply to message #268577]

Wed, 19 September 2007 02:26

djmartin
Messages: 10181
Registered: March 2005
Location: Surges Bay TAS Australia

Senior Member
Account Moderator

Give us the whole message - ora-03106 just isn't good enough.

By the way, did you use 'ifile' or 'tns_admin'?

David

Upd: Change "ins't" to "isn't".

[Updated on: Sun, 23 September 2007 23:36]

Report message to a moderator

Re: Oracle9i with Developer6i issue [message #269413 is a reply to message #268585]

Sat, 22 September 2007 02:32

mnajam
Messages: 5
Registered: September 2007
Location: Pakistan

Junior Member

i use 'tns_admin'.

Report message to a moderator

Re: Oracle9i with Developer6i issue [message #269642 is a reply to message #269413]

Sun, 23 September 2007 23:37

djmartin
Messages: 10181
Registered: March 2005
Location: Surges Bay TAS Australia

Senior Member
Account Moderator

So, is it working now?

David

Report message to a moderator

Re: Oracle9i with Developer6i issue [message #269881 is a reply to message #269642]

Tue, 25 September 2007 00:13

mnajam
Messages: 5
Registered: September 2007
Location: Pakistan

Junior Member

in developer side error could not resolve

OBE-15387: Login failed and ORA-03106: fatal two-task communication protocol error

Report message to a moderator

Re: Oracle9i with Developer6i issue [message #269894 is a reply to message #269881]

Tue, 25 September 2007 01:24

djmartin
Messages: 10181
Registered: March 2005
Location: Surges Bay TAS Australia

Senior Member
Account Moderator

At which tnsnames.ora did you point the 'tns_admin' environment variable?

Did you search this forum for 'two task'? Have a look at http://www.orafaq.com/forum/m/225892/67467/?srch=two+task+david#msg_225892

David

Report message to a moderator

Previous Topic:	Disadvantages of Oracle Forms?!
Next Topic:	Problem while retriveing the data of a check box

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Sep 27 04:22:33 CDT 2024