error connecting to database from forms 6i

Hi friends,

I keep getting a TNS packet writer failure error when trying to connect to the database with any Forms apps.

I followed the supplied installation instructions exactly but cannot resolve this problem. Oracle 8.1.7 is the database used and it resides on another machine in the network. I created an entry in TNSNAMES.ORA with easy config. But I cannot get any of the builders, nor the SQL*Plus that came with the package, to connect to my database. I have no problem starting the SQL*Plus that was included in the 8.1.7 package, however.

I read a few possible solutions on the newsgroups, and on here. Such as copying the TNSNAMES.ORA into both oracle home admin directories, renaming sqlnet.ora to .old. All with reboot, of course. Nothing is working. Listener is started, as well as other required services.

I am running Windows 2000. All 8i components are v 8.1.7.

Someone please help! Why do I keep getting this error?

Thanks

Quote:

---

Originally posted by star
Such as copying the TNSNAMES.ORA into both oracle home admin directories, renaming sqlnet.ora to .old. All with reboot, of course.

---

That would be OH\network\admin, yes? You meant that path, not OH\admin.

Forms 6i on which platform?

Nice dig against Windows.

Hi,
Thanks for the response.
Forms 6i is also on windows 2000.
I am stuck , please help me
We are able to connect the same database from another machine thro an ODBC connection.

regards

Post your tnsnames.ora and sqlnet.ora files that forms is using.

sqlnet.ora
# SQLNET.ORA Network Configuration File: D:\oracle\ora81\network\admin\sqlnet.ora
# Generated by Oracle configuration tools.

#NAMES.DEFAULT_DOMAIN = db1.local

#SQLNET.AUTHENTICATION_SERVICES= (NTS)

NAMES.DIRECTORY_PATH= (TNSNAMES, ONAMES, HOSTNAME)

sqlnet.expiretime=0

tnsnames.ora

# TNSNAMES.ORA Network Configuration File: D:\oracle\ora81\network\admin\tnsnames.ora
# Generated by Oracle configuration tools.

TEST.WORLD =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = sori)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = db1.local)
)
)



Please help.thanks

sqlnet.ora
# SQLNET.ORA Network Configuration File: D:\oracle\ora81\network\admin\sqlnet.ora
# Generated by Oracle configuration tools.

#NAMES.DEFAULT_DOMAIN = db1.local

#SQLNET.AUTHENTICATION_SERVICES= (NTS)

NAMES.DIRECTORY_PATH= (TNSNAMES, ONAMES, HOSTNAME)

sqlnet.expire_time=0

tnsnames.ora

# TNSNAMES.ORA Network Configuration File: D:\oracle\ora81\network\admin\tnsnames.ora
# Generated by Oracle configuration tools.

TEST =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = sori)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = test)
)
)

oops.it didn't work.says service name could not be resolved

What is the name of the database in the init.ora file?

Try to see that you don’t have two tnsname.ora file in two different oracle home.

db_name="db1"
db_domain=local
service_name=db1.local
instancename=db1

minesh, there are no duplicate ora homes.

Please help me out.

DB1 =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = sori)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = db1)
)
)


How did you come up with TEST?

Again this gives me packet writer failure error.

db_name="db1"
db_domain=local
service_name=db1.local
instancename=db1


No such thing as instancename. Is that a typo on your part, or is that inside your init.ora file? instance_name, not instancename.

Forget local and world. Those are so unnecessary. Don't even need domain name (more than likely, in your case). One name/word is all it takes. db_name of db1. tnsnames.ora entry of DB1 = (like the last post). It's easy, really.

Can you connect with SQL*Plus in the RDBMS version of it? What are you using for Oracle Net/Net 8 configuration files there? If they work there, they work everywhere. Simply copy them to the corresponding place for Forms. Or, set TNS_ADMIN environment variable, pointing it to the version that works.

hi stecal,

Thanks for your concern.

I installed oracle forms 6i in another machine(which has 9i lite installed in it) and copied the tnsnames.ora of lite into net80/admin.I am able to connect from forms without any problem.But when I login via sqlplus, the sreen appears and closes immediately without any error messages.

But packet writer failure error occurs when I try to login thro forms or sqlplus in the other machine.

Forms 6i is having 8.0.6version of sqlplus/net8 and has it got anything to do with this connection problem.

please clarify.
thanks and regards