Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 879
  • Last Modified:

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
0
janede
Asked:
janede
  • 5
  • 2
1 Solution
 
DrJekyllCommented:
I assume listener is started
At the command prompt

set oracle_sid=<sid>
svrmgrl
If you get the tns error at this point. I would recreate instance using oradim.  Delete the password file in
oracle_home\database before recreating instance.

To delete instance
oradim -delete -sid <sid>
ex.oradim -delete -sid test    

Recreate instance using oradim

ORADIMxx  -NEW  -SID  <SID>  -INTPWD  <password>  
-STARTMODE <mode>  -PFILE  <pfile>            
where:  sid      is the database SID
        password is the password for INTERNAL
        mode is the startup mode for the services,
        either AUTO or MANUAL
        pfile is the full path and name of
        the INIT<sid>.ORA file
ex.
oradim -new -sid test -intpwd testpwd
  -startmode auto -pfile c:\oracle8i\admin\inittest.ora

Recreating instance at command prompt does not destroy
and database objects,etc.

Always review oradim.log after each oradim command.
It is by default in oracle_home\database
0
 
janedeAuthor Commented:
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../../software/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?
0
 
DrJekyllCommented:
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.
0
Concerto's Cloud Advisory Services

Want to avoid the missteps to gaining all the benefits of the cloud? Learn more about the different assessment options from our Cloud Advisory team.

 
janedeAuthor Commented:
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../../software/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?
0
 
janedeAuthor Commented:
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../../software/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?
0
 
agonenCommented:
hi , do u have sevral oracle home on the machine ?
0
 
janedeAuthor Commented:
Definitely not. Why asked?
0
 
janedeAuthor Commented:
Definitely not. Why asked?
0

Featured Post

Get expert help—faster!

Need expert help—fast? Use the Help Bell for personalized assistance getting answers to your important questions.

  • 5
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now