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

"Closed connection" error with 9i and Developer 2000

I have installed Oracle 9i Personal Edition on my Win2K machine. It works fine. However, when I install Developer 2000 (Forms 5) neither of them work. In Oracle I get the error "closed connection" and in Developer 2000 while connecting to my Oracle database I get the error "ORA-12154:TNS: could not resolve service name."

I have installed Oracle 9i Personal Edition on my Win2K machine. It works fine. However, when I install Developer 2000 (Forms 5) neither of them work. In Oracle I get the error "closed connection" and in Developer 2000 while connecting to my Oracle database I get the error "ORA-12154:TNS: could not resolve service name." I have installed them in different directories. I read that the tnsnames.ora and listner.ora file have to be modified and changes have to be made in the Windows registry. Since I am new to Oracle I don't know how to go about it. Kindly help me out with this problem.
My suggestion would be to use the Net Configuration Assistant to do this. You can configure a listener by using the Net Configuration Assistant (available from the Start menu on your Windows server). The assistant will create a listener.ora for you and also start the listener. You can also test connectivity to your database via this interface.

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