janede
asked on
Ora-12560 TNS: protocol adapter error...
Hi ALl:
I saw many raised questions about this Oracle error message. But I cannot find some suitable solutions.
Does anybody there know a fixed solution.
I have installed Oracle 8.1.7 EE and SE on 2 PCs seperately, and both get the error messages when I loged in Server Manager. ( I mean run the 'svrmgrl'). Then it is no problem to connect with internal/manager or so on.)
This error message does not appear on SQL*Plus, and I have the ORACLE_SID in my registry. And the databases seem work well.
Any idea for this case?
jane
I saw many raised questions about this Oracle error message. But I cannot find some suitable solutions.
Does anybody there know a fixed solution.
I have installed Oracle 8.1.7 EE and SE on 2 PCs seperately, and both get the error messages when I loged in Server Manager. ( I mean run the 'svrmgrl'). Then it is no problem to connect with internal/manager or so on.)
This error message does not appear on SQL*Plus, and I have the ORACLE_SID in my registry. And the databases seem work well.
Any idea for this case?
jane
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
I have never heard of that conflict arising because you have a registry setting. The reason I do it always is that I have multiple instances on same server and I want to set environment. NO this is not a serious issue...just explicitly set it and you will be Ok. I will look into
conflict between registry setting and setting at command prompt.
conflict between registry setting and setting at command prompt.
ASKER
I did the exactly what you wrote above to delete the old instance, and used oradim (Oracle 8i) to create a new one. But the error appears when I type svrmgrl in DOS window without doing the 'set oracle_sid=mysid'. Because I have set oracle_sid in registry LOCAL_MACHINE../../softwar e/oracle as you know.
Then i did what you told me, i.e. first
set oracle_sid=mysid
svrmgrl
Then I was told SET is illegal. Because I think I have one in registry. Then I deleted it. and run the two lines again. It works. But it is annoying, I should run them every time when I start server manager.
Is that serious?
Then i did what you told me, i.e. first
set oracle_sid=mysid
svrmgrl
Then I was told SET is illegal. Because I think I have one in registry. Then I deleted it. and run the two lines again. It works. But it is annoying, I should run them every time when I start server manager.
Is that serious?
ASKER
I did the exactly what you wrote above to delete the old instance, and used oradim (Oracle 8i) to create a new one. But the error appears when I type svrmgrl in DOS window without doing the 'set oracle_sid=mysid'. Because I have set oracle_sid in registry LOCAL_MACHINE../../softwar e/oracle as you know.
Then i did what you told me, i.e. first
set oracle_sid=mysid
svrmgrl
Then I was told SET is illegal. Because I think I have one in registry. Then I deleted it. and run the two lines again. It works. But it is annoying, I should run them every time when I start server manager.
Is that serious?
Then i did what you told me, i.e. first
set oracle_sid=mysid
svrmgrl
Then I was told SET is illegal. Because I think I have one in registry. Then I deleted it. and run the two lines again. It works. But it is annoying, I should run them every time when I start server manager.
Is that serious?
hi , do u have sevral oracle home on the machine ?
ASKER
Definitely not. Why asked?
ASKER
Definitely not. Why asked?
ASKER
Then i did what you told me, i.e. first
set oracle_sid=mysid
svrmgrl
Then I was told SET is illegal. Because I think I have one in registry. Then I deleted it. and run the two lines again. It works. But it is annoying, I should run them every time when I start server manager.
Is that serious?