Oracle Forms

I've got an Oracle Form application to run with Oracle Form 6i (yes, too old, but that is also an old application written for Form 6i and now I have to run it). And the database server is 10.1.0. I run both in the same Windows XP pro box (in a virtualBox machine).

The encoding of the database server is UTF8.

I have already configured the listener for Oracle server; configured TNS name for Form 6i client. I can successfully connect to the server with sqlplus (PLUS80W.EXE) shipped in the Form 6i.

But I am unable to login with the Form application.

Here is the listener.ora (configured by Net Manager application)
ORAUTF8 =
+(DESCRIPTION_LIST =+
+(DESCRIPTION =+
+(ADDRESS = (PROTOCOL = TCP)(HOST = winxp-vm)(PORT = 1521))+
+)+
+(DESCRIPTION =+
+(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC))+
+)+
+)+

SID_LIST_ORAUTF8 =
+(SID_LIST =+
+(SID_DESC =+
+(SID_NAME = PLSExtProc)+
+(ORACLE_HOME = C:\data\oracle\product\10.1.0\db)+
+(PROGRAM = extproc)+
+)+
+)+

Here is the tnsnames.ora (C:\orant\NET80\ADMIN\tnsnames.ora)
TESTDB =
+(DESCRIPTION =+
+(ADDRESS = (PROTOCOL = TCP)(HOST = winxp-vm)(PORT = 1521))+
+(CONNECT_DATA =+
+(SERVER = DEDICATED)+
+(SERVICE_NAME = orautf8)+
+)+
+)+

I have already added winxp-vm to hosts file. I also tried to replace winxp-vm with localhost but no luck.

Looking at the sqlnet.log file, I noticed the following:
- If I keep HOST = winxp-vm, there are 4 times the following errors were written to the log file

***********************************************************************
Fatal NI connect error 12203, connecting to:
+(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=BEQ)(PROGRAM=oracle80)(ARGV0=oracle80ORCL)(ARGS='(DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))')))(CONNECT_DATA=(SID=ORCL)(CID=(PROGRAM=C:\orant\BIN\ifrun60.EXE)(HOST=WINXP-VM)(USER=htb))))+
VERSION INFORMATION:
TNS for 32-bit Windows: Version 8.0.6.3.0 - Production
Oracle Bequeath NT Protocol Adapter for 32-bit Windows: Version 8.0.6.3.0 - Production


- But in the tnsnames.ora, If I change *"winxp-vm" to "xyzwinxp-vm"* (a nonexistent host), there are *5 error entries in the log, 4 are same as above*, 1 is the following

***********************************************************************
Fatal NI connect error 12545, connecting to:
+(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=xyzwinxp-vm)(PORT=1521))(CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=orautf8)(CID=(PROGRAM=C:\orant\BIN\ifrun60.EXE)(HOST=WINXP-VM)(USER=htb))))+

VERSION INFORMATION:
TNS for 32-bit Windows: Version 8.0.6.3.0 - Production
Windows NT TCP/IP NT Protocol Adapter for 32-bit Windows: Version 8.0.6.3.0 - Production


That means the Form does use file C:\orant\NET80\ADMIN\tnsnames.ora

Could anybody tell me what could be wrong with my environment?

Thanks.
Bao.

Edited by: user6281962 on Mar 7, 2013 3:55 AM

Edited by: user6281962 on Mar 7, 2013 5:22 PM