| oracle 10g ERROR: 12560 [message #445427] |
Mon, 01 March 2010 16:28  |
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 #446237 is a reply to message #445431] |
Sat, 06 March 2010 17:38  |
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 |
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 #447151 is a reply to message #446239] |
Fri, 12 March 2010 00:52 |
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 #447281 is a reply to message #447151] |
Fri, 12 March 2010 20:11 |
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 #447286 is a reply to message #447281] |
Sat, 13 March 2010 00:30 |
 |
Michel Cadot
Messages: 68722
Registered: March 2007
Location: Saint-Maur, France, https...
|
Senior Member
Account Moderator |
|
|
Received the following message from techy1
techy1 wrote on Sat, 13 March 2010 03:06The 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
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
