error ora-12560 TNS protocol error

hi guys, i installed oracle 11gr2 on wondow 7, but am not able to login getting error error ora-12560 TNS protocol error
nirvairghumanAsked:
Who is Participating?

Improve company productivity with a Business Account.Sign Up

x
 
AnandConnect With a Mentor Commented:
open command prompt
tnsping ORACLE_SID ( replace the correct oracle_sid name here)
result ? ( will give u clue what is the cause ?)
.
another check
set ORACLE_SID=name of oracle_sid
sqlplus /nolog
conn / as sysdba

result ? ( if successful, then the problem is with your listner and it's setup,availability....)
(if not successful, problem is with your database avialability, setup...)
0
 
choukssaConnect With a Mentor Commented:

Some things to consider--

1. Do you have the proper client ?
2. Is listener running?
3. Is ORACLE_SID set properly?

--choukssa
0
 
nirvairghumanAuthor Commented:
Yeah, i have set ORACLE_SID and my listener is running, but i installed on my local pc.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.