Improve company productivity with a Business Account.Sign Up


ORA-12560:TNS Protocol adapter error.

Posted on 2004-03-27
Medium Priority
Last Modified: 2012-06-27
I tried to connect to the database ( Two sid's ) using
SQL*Plus I got the error messages :

ORA-01034 : Oracle Not Available
ORA-27101 : Shared memory realm does not exit.

and by  Manager SVRMGRL,  I got the following error message:
ORA-12560:TNS Protocol adapter error.

I created a new databese service by using ORADIM utilities. I got the
same error message. I checked listener and tnsnames and looks fine
but by changing the GLOBAL_DBNAME on SID_DESC  from GLOBAL_DBNAME
= PROD( The name of the sid) to GLOBAL_DBNAME = Oracle8.) and the error message changed to ORA
- 12514 :TNS:Listener couldn't resolve SERVICE_NAME given in connect

Question by:hadimdh
LVL 48

Expert Comment

ID: 10694095
You have to use the Net tools (NETCA, NETCONFIG, EASYCONFIG) to create and to TEST the entry in tnsnames.ora file.
c:>tnsping 10 orawin

where 'orawin' stands for the alias names in tnsnames.ora to check if using this alias you can connect the listener.

Expert Comment

ID: 10694170
change the value of

Change the user that starts the OracleService to the Oracle DBA user who is
defined to the Windows domain.
1. Go to Control Panel, Services,
2.  right click the OracleService<SID>
3.  select properties, select the Log On tab
4.  Click on the Account radio button
5. fill in the domain qualified dba user and password (e.g. oradba\dbapwd)
6. Click OK
7. Restart the service

Accepted Solution

baonguyen1 earned 200 total points
ID: 10695319
The first two errors (ORA-01034, ORA-27101) show that your oracle has not been started or shutdown abnormal. Try to start from command prompt on the server

C:\sqlplus /nolog
SQL>connect  / as sysdba
SQL>connect sys/pass@<SID> as sysdba
SQL>startup pfile=..../init<SID>.ora

Then connect from sqlplus or svrmgrl should work.

Hope this helps.
Free Tool: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.


Author Comment

ID: 10697223
Thanks for your comments, I used tnsping 10 orawin, but I got the following error message :
Failed to resolve names.


Author Comment

ID: 10697289
Thanks Baonguyen1,
All the sid's are up and running, Thaks for every body

Author Comment

ID: 10723026
When I restarted the server I got the same problem, It looks that the problem exist still, If I run a backup scripts also I should restart all services manually with the scripts which you have provided.

Featured Post

Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

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.

Join & Write a Comment

Working with Network Access Control Lists in Oracle 11g (part 1) Part 2: So, you upgraded to a shiny new 11g database and all of a sudden every program that used UTL_MAIL, UTL_SMTP, UTL_TCP, UTL_HTTP or any oth…
Background In several of the companies I have worked for, I noticed that corporate reporting is off loaded from the production database and done mainly on a clone database which needs to be kept up to date daily by various means, be it a logical…
Video by: Steve
Using examples as well as descriptions, step through each of the common simple join types, explaining differences in syntax, differences in expected outputs and showing how the queries run along with the actual outputs based upon a simple set of dem…
This video shows how to copy an entire tablespace from one database to another database using Transportable Tablespace functionality.

584 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