I reinstalled Oracle 10g at another location and removed all traces of the earlier installation. But I could not find the tnsnames.ora and listener.ora files at ORACLE_HOMEnetworkadmin. So I created the service name and listener from the tool available in 10g. No listener service got created in the service list, but there is a listener service corresponding to the earlier installation. Since there in no listener service I'm not able to connect 6i Forms to the database. But the database is working from SQL*Plus in 10g.
Delete the existing listener service and re-create it using the Net Configuration Assistant. After the service is created successfully, you must create a tnsnames.ora file on the machine where you will be connecting from. This can also be done via the Assistant. I'm assuming that you are running Forms on the same machine as the database, so in this case a copy of tnsnames.ora must exist on that machine. You should be able to create this file and add service names to it via the Assistant. These files can also be created using a text editor but it's safer to use the Assistant.
Dig Deeper on Oracle database installation, upgrades and patches
I have been trying to install Oracle 8.1.7 on SUSE Linux 9.0 and got the error:
"Error in invoking target install of makefile /opt/oracle/...../*.mk."
I'm getting errors while installing the Database Configuration Assistant.
Can I use /var/opt/oracle/oratab to specify listener information?