Have you Cross checked whether the service is running or not.
if in case its stoped start it then give it a shot.
though tns service is not required in local enable it too.
if you r using multiple homes try to put the SID after login and password
if its windows 2000/XP
run services.msc from "run" option
here you'll see the current installed services and their status. check whether Oracle service is running or not.
i am runnning win xp
__________
OracleOraHome81Agent
OracleOraHome81ClientCache
OracleOraHome81DataGatherer
OracleWebAssistant0
i have turn them on but still it is giving same error
You should put the required details like username, password, oracle home IP/computer name in the domain in the tnsnames.ora file. This file can be found in \ora81\network\admin and an example in \ora81\network\admin\sample. This is assuming your TNS listener service is automatically started and running.
i am runnning win xp
__________
OracleOraHome81Agent
OracleOraHome81ClientCache
OracleOraHome81DataGatherer
OracleWebAssistant0
i have turn them on but still it is giving same error
First stop all the services running related to oracle.
Delete the folder where ORACLE is installed (if gettin error while deleting the folder (unable to delete) use the software unlocker to unlock the folder from here *www.softpedia.com/get/System/System-Miscellaneous/Unlocker.shtml Then delete it (oracle folder ofcourse)
), Using Regedit/regcleaner/similar softies remove all registeries entries related to oracle.
Now install the Oracle form the very begining.
DO NOT DO THE CUSTOM INSTALLATION BY YOUR OWN IF U DONT KNOW WHAT YOU ARE DOING.
MAKE THE INSTALLATION AS "ENTERPRISE" WITH ALL DEFAULTS
Hi Guest we just wanted to alert you to a major change in the forum. We will no longer be allowing the posting of outgoing links. Please use the attachment feature to attach media to your posts.