problem in logging sql oracle 8i

[shivi4]

hi i am using oracle 8i version
i have problem to login sql plus with scott/tiger

as user name and password

i have also tried system/manager please help

ERROR:
ORA-12560: TNSrotocol adapter error

ERROR:
ORA-12154: TNS:could not resolve service name

[DukeNukem]

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

eg scott/tiger@live or system/manager@live

[shivi4]

how to chewck service is running or not
i am running oracle in hone computer only

[DukeNukem]

what os are you runnin Bro.

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.

[shivi4]

i am runnning win xp
__________
OracleOraHome81Agent
OracleOraHome81ClientCache
OracleOraHome81DataGatherer
OracleWebAssistant0
i have turn them on but still it is giving same error

how to tun tns

[abhijit_reddevil]

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.

[DukeNukem]

Originally Posted by shivi4

i am runnning win xp
__________
OracleOraHome81Agent
OracleOraHome81ClientCache
OracleOraHome81DataGatherer
OracleWebAssistant0
i have turn them on but still it is giving same error

how to tun tns

The Main Services needed is not mentioned here which goes like this
OracleServiceORCL 'Here ORCL is the SID NAME

and a tnslistner service which look like this
OracleOraHome81TNSListener

if these are the only service related to oracle u are havin. then you have not installed oracle properly.

reinstall it again (just in case)

[shivi4]

OracleOraHome81TNSListener
i am not getting the above even after re installation

[DukeNukem]

do one thing

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 http://www.softpedia.com/get/System/...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