Home » Developer & Programmer » Forms » Oracle9i with Developer6i issue
Oracle9i with Developer6i issue [message #267371] Thu, 13 September 2007 02:12 Go to next message
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
Re: Oracle9i with Developer6i issue [message #267611 is a reply to message #267371] Thu, 13 September 2007 20:15 Go to previous messageGo to next message
djmartin
Messages: 10180
Registered: March 2005
Location: Canberra ACT 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
Re: Oracle9i with Developer6i issue [message #268568 is a reply to message #267371] Wed, 19 September 2007 02:09 Go to previous messageGo to next message
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.
Re: Oracle9i with Developer6i issue [message #268576 is a reply to message #268568] Wed, 19 September 2007 02:18 Go to previous messageGo to next message
djmartin
Messages: 10180
Registered: March 2005
Location: Canberra ACT 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 Go to previous messageGo to next message
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 Go to previous messageGo to next message
djmartin
Messages: 10180
Registered: March 2005
Location: Canberra ACT 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 Go to previous messageGo to next message
mnajam
Messages: 5
Registered: September 2007
Location: Pakistan
Junior Member
i use 'tns_admin'.
Re: Oracle9i with Developer6i issue [message #269642 is a reply to message #269413] Sun, 23 September 2007 23:37 Go to previous messageGo to next message
djmartin
Messages: 10180
Registered: March 2005
Location: Canberra ACT Australia
Senior Member
Account Moderator
So, is it working now?

David
Re: Oracle9i with Developer6i issue [message #269881 is a reply to message #269642] Tue, 25 September 2007 00:13 Go to previous messageGo to next message
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

Re: Oracle9i with Developer6i issue [message #269894 is a reply to message #269881] Tue, 25 September 2007 01:24 Go to previous message
djmartin
Messages: 10180
Registered: March 2005
Location: Canberra ACT 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
Previous Topic: Disadvantages of Oracle Forms?!
Next Topic: Problem while retriveing the data of a check box
Goto Forum:
  


Current Time: Mon Dec 05 15:17:12 CST 2016

Total time taken to generate the page: 0.11368 seconds