?
Solved

Ora-12560 TNS: protocol adapter error...

Posted on 2003-03-11
8
Medium Priority
?
875 Views
Last Modified: 2007-12-19
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
Comment
Question by:janede
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 5
  • 2
8 Comments
 
LVL 5

Accepted Solution

by:
DrJekyll earned 500 total points
ID: 8111267
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
 

Author Comment

by:janede
ID: 8111673
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
 
LVL 5

Expert Comment

by:DrJekyll
ID: 8111868
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
Get your Conversational Ransomware Defense e‑book

This e-book gives you an insight into the ransomware threat and reviews the fundamentals of top-notch ransomware preparedness and recovery. To help you protect yourself and your organization. The initial infection may be inevitable, so the best protection is to be fully prepared.

 

Author Comment

by:janede
ID: 8111929
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
 

Author Comment

by:janede
ID: 8111936
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
 

Expert Comment

by:agonen
ID: 8128193
hi , do u have sevral oracle home on the machine ?
0
 

Author Comment

by:janede
ID: 8128349
Definitely not. Why asked?
0
 

Author Comment

by:janede
ID: 8129162
Definitely not. Why asked?
0

Featured Post

Get your Disaster Recovery as a Service basics

Disaster Recovery as a Service is one go-to solution that revolutionizes DR planning. Implementing DRaaS could be an efficient process, easily accessible to non-DR experts. Learn about monitoring, testing, executing failovers and failbacks to ensure a "healthy" DR environment.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Working with Network Access Control Lists in Oracle 11g (part 2) Part 1: http://www.e-e.com/A_8429.html Previously, I introduced the basics of network ACL's including how to create, delete and modify entries to allow and deny access.  For many…
Shell script to create broker configuration file using current broker Configuration, solely for purpose of backup on Linux. Script may need to be modified depending on OS-installation. Please deploy and verify the script in a test environment.
This video shows, step by step, how to configure Oracle Heterogeneous Services via the Generic Gateway Agent in order to make a connection from an Oracle session and access a remote SQL Server database table.
This video shows how to copy a database user from one database to another user DBMS_METADATA.  It also shows how to copy a user's permissions and discusses password hash differences between Oracle 10g and 11g.
Suggested Courses

771 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question