Home » Developer & Programmer » Forms » Developer 6i Installation Problem (Oracle 9i and Developer 6i)
Developer 6i Installation Problem [message #427840] Mon, 26 October 2009 02:55 Go to next message
atifzaman3310
Messages: 4
Registered: October 2009
Location: PAKISTAN
Junior Member
hi. I have have first installed oracle 9i and then forms 6i on window XP. all installation is fine. But when i try to connect to database from forms. It give me error ORA-12571: TNS:packet writer failure. I don't know why it is so. few days ago i installed and it installed well. why it is creating problem now.
Please help me i have to develop an application for my business.
i have attached tnsnames.ora and sqlnet.ora of oracle 9i and sqlnet.ora of form 6i. Please make changes to these files what you think and tell me solution. I shall be very thankful to you.

Please do it at your as soon as possible. i am too much worried about it...
Best Regards
  • Attachment: sqlnet.ora
    (Size: 0.22KB, Downloaded 1065 times)

Report message to a moderator

Re: Developer 6i Installation Problem [message #427843 is a reply to message #427840] Mon, 26 October 2009 03:05 Go to previous messageGo to next message
atifzaman3310
Messages: 4
Registered: October 2009
Location: PAKISTAN
Junior Member
The above attached file is of oracle 9i and attached file with this message is of Developer 6i. Please take view and edit them.
  • Attachment: SQLNET.ORA
    (Size: 27.70KB, Downloaded 1125 times)

Report message to a moderator

Re: Developer 6i Installation Problem [message #427846 is a reply to message #427843] Mon, 26 October 2009 03:19 Go to previous messageGo to next message
Littlefoot
Messages: 21818
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Check whether use of TNS_ADMIN environment variable helps in solving the problem (search the board; it's already been discussed).

Report message to a moderator

Re: Developer 6i Installation Problem [message #427853 is a reply to message #427840] Mon, 26 October 2009 03:50 Go to previous messageGo to next message
atifzaman3310
Messages: 4
Registered: October 2009
Location: PAKISTAN
Junior Member
ya i know it is already discussed but i can't get valid response from that. And would you please tell me what is TNS_ADMIN......

Report message to a moderator

Re: Developer 6i Installation Problem [message #427898 is a reply to message #427853] Mon, 26 October 2009 05:52 Go to previous messageGo to next message
Littlefoot
Messages: 21818
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Improve your searching skills.

Report message to a moderator

Re: Developer 6i Installation Problem [message #427911 is a reply to message #427898] Mon, 26 October 2009 06:31 Go to previous messageGo to next message
atifzaman3310
Messages: 4
Registered: October 2009
Location: PAKISTAN
Junior Member
Dear i read this thread. I don't have tns_admin problem. I have same tnsnames.ora both in oracle home and developer home. I connects fine but while fetching data it give this error "ORA-12571: TNS:packet writer failure". I search this problem on Google.com it shows me this is error of SQLNET.ora. I don't know how to solve them. I have attached both sqlnet of databse and developer. please look at them and then guide me about that problem. If you need i am going to attache tnsnames.ora file here. Also take view of that.

I just coppied tnsname.ora file of database to developer admin folder and replace the existing with new. which i attached here.

And one more point to notes may database is working fine. Because i check it with SQL*Plus prompt. It works fine but problem come when i try to get data via developer from...

Best Regards
  • Attachment: tnsnames.ora
    (Size: 0.77KB, Downloaded 1114 times)

Report message to a moderator

Re: Developer 6i Installation Problem [message #431164 is a reply to message #427911] Sun, 15 November 2009 23:34 Go to previous messageGo to next message
djmartin
Messages: 10181
Registered: March 2005
Location: Surges Bay TAS Australia
Senior Member
Account Moderator
The 'tns_admin' threads will solve your 'tnsnames.ora' problem by telling you to specify which copy of the 'tnsnames.ora' to use and to NOT waste your time maintaining two OR MORE copies of the 'tnsnames.ora' file.

David

Report message to a moderator

Re: Developer 6i Installation Problem [message #432469 is a reply to message #427840] Tue, 24 November 2009 06:19 Go to previous messageGo to next message
coolbunny111
Messages: 12
Registered: June 2009
Junior Member
Do one thing copy all .ora files from oracle 9i directory to developer 6i directory
and connect your form to DB this will work fine.

Report message to a moderator

Re: Developer 6i Installation Problem [message #433373 is a reply to message #432469] Wed, 02 December 2009 00:08 Go to previous message
djmartin
Messages: 10181
Registered: March 2005
Location: Surges Bay TAS Australia
Senior Member
Account Moderator
Yea, right! NOT!!

Just use 'tns_admin' and save yourself a world of pain.

David

Report message to a moderator

Previous Topic: Forms multi-row validation
Next Topic: HOW TO RESTRICT TEXT ITEM INPUT
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Fri Sep 20 09:52:36 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.