Home » Infrastructure » Windows » oracle 10g ERROR: 12560 (Oracle 10g r2, Windows XP Professional)
oracle 10g ERROR: 12560 [message #445427] Mon, 01 March 2010 16:28 Go to next message
techy1
Messages: 5
Registered: March 2010
Location: USA
Junior Member
Hello everyone,
I am a new to learning Oracle 10g and I recently installed Oracle 10g on XP Professional. When I went to log in to SQL Plus from the command prompt after I enter sys for the user and after I tried to enter in my password I received and error:

ORA-12560: TNS:protocol adapter error

Can anyone explain in detail how I can fix this error? I am still learning and trying to get more familiar with Oracle.


thanks,
techy1
Re: oracle 10g ERROR: 12560 [message #445431 is a reply to message #445427] Mon, 01 March 2010 18:13 Go to previous messageGo to next message
Barbara Boehmer
Messages: 9077
Registered: November 2002
Location: California, USA
Senior Member
Did you download and install the correct version for your operating system?

Did you install the database, not just the client?

Did you get any errors during installation?

Windows sometimes has problems starting all the services. Go to your control panel, then select administrative tools, then select services. Look for any services that start with the word Oracle and start them, if they are not already started.
Re: oracle 10g ERROR: 12560 [message #445435 is a reply to message #445427] Mon, 01 March 2010 20:49 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
>ORA-12560: TNS:protocol adapter error

SQL*Net is NOT required to connect to DB while logged onto DB server system directly.

Be logged onto DB server as same OS user who own Oracle software
open command window

CUT lines below then PASTE into open command window

set
sqlplus
/ as sysdba


CUT commands & results from command window then PASTE all back here
Re: oracle 10g ERROR: 12560 [message #446237 is a reply to message #445431] Sat, 06 March 2010 17:38 Go to previous messageGo to next message
techy1
Messages: 5
Registered: March 2010
Location: USA
Junior Member
Hello Barbara and thanks for your reply,
yes I installed the correct version,
yes I installed the database first then the client,
no I did not receive any errors during installation,
and yes I made sure that all of the services were started and I am still receiving the error. Any more ideas?

[Updated on: Sat, 06 March 2010 17:39]

Report message to a moderator

Re: oracle 10g ERROR: 12560 [message #446238 is a reply to message #445435] Sat, 06 March 2010 17:42 Go to previous messageGo to next message
techy1
Messages: 5
Registered: March 2010
Location: USA
Junior Member
Thanks Blackswan the tns error is preventing me from signing into sqlplus from the command prompt so I am unable to log in and enter the command. Any more ideas please?
Re: oracle 10g ERROR: 12560 [message #446239 is a reply to message #446237] Sat, 06 March 2010 17:44 Go to previous messageGo to next message
ThomasG
Messages: 3211
Registered: April 2005
Location: Heilbronn, Germany
Senior Member
Copy and paste EXACTLY what happened when you ran these commands (At the command prompt, not in the SQL prompt)

set
sqlplus "/ as sysdba"

[Updated on: Sat, 06 March 2010 17:46]

Report message to a moderator

Re: oracle 10g ERROR: 12560 [message #447151 is a reply to message #446239] Fri, 12 March 2010 00:52 Go to previous messageGo to next message
techy1
Messages: 5
Registered: March 2010
Location: USA
Junior Member
WHEN I TRIED TO LOG INTO SQL PLUS FROM THE COMMAND PROMPT I RECIEVED THIS ERROR MESSAGE:


Microsoft Windows XP [Version 5.1.2600]
(C) Copyright 1985-2001 Microsoft Corp.

C:\Documents and Settings\>sqlplus/nolog

SQL*Plus: Release 10.2.0.1.0 - Production on Fri Mar 12 00:13:18 2010

Copyright (c) 1982, 2005, Oracle. All rights reserved.

SQL> connect as sysdba
Enter user-name: sys
Enter password:
ERROR:
ORA-12560: TNS:protocol adapter error


I VERIFIED THAT ALL THE ORACLE SERVICES WAS RUNNING, I VERIFIED THAT THE ORACLE SID VARIABLE WAS SET TO THE CORRECT DATABASE, THEN I PINGED THE TNS NAMES(the database named oraclass) AND THIS IS WHAT I GOT NOT SURE WHAT TO DO NEXT CAN YOU HELP? ANY MORE IDEAS ON HOW TO FIX THE TNS ORA-12560 error?

C:\Documents and Settings>tnsping oraclass

TNS Ping Utility for 32-bit Windows: Version 10.2.0.1.0 - Production on 12-MAR-2
010 01:43:07

Copyright (c) 1997, 2005, Oracle. All rights reserved.

Used parameter files:
C:\oracle\product\10.2.0\client_1\network\admin\sqlnet.ora


Used TNSNAMES adapter to resolve the alias
Attempting to contact (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)
(HOST = home-a57a16f3fa)(PORT = 1521))) (CONNECT_DATA = (SERVICE_NAME = oraclass
)))
OK (30 msec)
Re: oracle 10g ERROR: 12560 [message #447155 is a reply to message #447151] Fri, 12 March 2010 01:04 Go to previous messageGo to next message
Michel Cadot
Messages: 68624
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Why don't you post what is asked?
BlackSwan asked for "SET" not "tnsping oraclass" which is irrelevant for a local connection.

AND DO NOT POST IN UPPER CASE, THIS IS SHOUTING ABOVE ALL WHEN YOU POST IT IN BOLD.

We don't care what you verified, we want to see it.

Regards
Michel
Re: oracle 10g ERROR: 12560 [message #447281 is a reply to message #447151] Fri, 12 March 2010 20:11 Go to previous messageGo to next message
techy1
Messages: 5
Registered: March 2010
Location: USA
Junior Member
For anyone who read my last post please excuse the all bold caps I am new to this forum and Oracle and I was not meaning to shout or be disrespectful. I was just trying to make my message more clear and easy to read between my comments and the message results so please dont be offended or take my message out of context. Sorry again and it will not happen anymore.
Re: oracle 10g ERROR: 12560 [message #447285 is a reply to message #447281] Sat, 13 March 2010 00:14 Go to previous messageGo to next message
Michel Cadot
Messages: 68624
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
OK but we still have not the result of SET command.

Regards
Michel
Re: oracle 10g ERROR: 12560 [message #447286 is a reply to message #447281] Sat, 13 March 2010 00:30 Go to previous message
Michel Cadot
Messages: 68624
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Received the following message from techy1
techy1 wrote on Sat, 13 March 2010 03:06
The reason I wrote in all caps and bold was to make my message easier to read and to try to distinguish my comments from the error messages. Like I said before I am new to Oracle and this forum I was just trying to get some help not get into an argument or start some drama which is why I dont understand why you would start with me I dont even remember corresponding with you in the first place. If you had a problem with my post then all you should have done was ignore it or you could have private messaged me like a mature adult as I did you. I am just here trying to learn and brainstorm not get caught up in mature drama and get disrespected by you Michel. I am an adult trying to do something and I dont have time for games. So from now on do not post on my topics or respond to anything concerning me. Just leave me alone and keeps your rude negative comments to yourself since you do not know how to talk to me nicely or with respect.


1/ As moderator I have to point out poster to forum guide when it is violated.
2/ You should read this OraFAQ Forum Guide before posting.
3/ Posting in upper case meaning is true in ANY forum since newsgroup existed more than 20 years ago.
4/ I don't think my post is rude or negative, but I think your behaviour is:
4b/ When someone asks you to post something to help you it is showing respect to answer her, and disrespectful to ignore this, despite what you say.
5/ You have not to say to anyone if he can post or not and when.

As he know ignore me, please quote my post to let him know how disrespectful, rude and childish it is to send a mail and don't allow the addresee to answer.

Regards
Michel
Previous Topic: Command extract File .zip
Next Topic: ora-00604 and ora-01009
Goto Forum:
  


Current Time: Thu Mar 28 07:27:07 CDT 2024