Q
Problem solve Get help with specific problems with your technologies, process and projects.

Can't find tnsnames.ora and listener.ora files after reinstallation

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.

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

Have a question for an expert?

Please add a title for your question

Get answers from a TechTarget expert on whatever's puzzling you.

You will be able to add details on the next page.

Start the conversation

Send me notifications when other members comment.

Please create a username to comment.

-ADS BY GOOGLE

SearchDataManagement

SearchBusinessAnalytics

SearchSAP

SearchSQLServer

TheServerSide.com

SearchDataCenter

SearchContentManagement

SearchHRSoftware

Close