Home » Infrastructure » Windows » Plss Help me, ORA-12560 TNS :Protocol Adapter Error
Plss Help me, ORA-12560 TNS :Protocol Adapter Error [message #251578] Sun, 15 July 2007 01:07 Go to next message
salman4u
Messages: 12
Registered: July 2007
Junior Member
hi,
i m a newbiew to SQL.I installed Oracle 9i database version and personal edition it was installed perfectly without any problem but when it was installed i didnt get any screen where i have to enter sys username and password as well as system username and password.I installed it 4-5 times but still with no success and when i m trying to login with scott and tiger it says

ORA-12560 TNS :Protocol Adapter Error

Now,pls help me.I am a newbie and i dont know what to do.In my college lectures has started and so i need to practise but i m unable to enter the SQL *PLUS.
Re: Plss Help me, ORA-12560 TNS :Protocol Adapter Error [message #251581 is a reply to message #251578] Sun, 15 July 2007 01:53 Go to previous messageGo to next message
srinivasocp
Messages: 91
Registered: December 2005
Location: INDIA
Member
Salman,

Check this

This error will come if Listener is not up or problem in tnsnames or database is not up.

1.Check the listener status by executing lsnrctl status

To check the listener status
Quote:
Go to start>Run>cmd>lsnrctl status

2.check the tnsnames entry is proper t not by
tnsping INSTANCENAME

To check the tnsnames
Quote:
Go to start>Run>cmd> tnsping <SID>

3.Check the database is up r not by checking the service in windows
Quote:
Go to Control panel>Services and Devices
Check whether OracleServiceORCL is RUNNING or Not.



Regards
Srini...

[Updated on: Sun, 15 July 2007 01:54]

Report message to a moderator

Re: Plss Help me, ORA-12560 TNS :Protocol Adapter Error [message #251582 is a reply to message #251578] Sun, 15 July 2007 01:58 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Have a look at:
Database Installation Guide 10g Release 2 (10.2) for Microsoft Windows
Database Platform Guide 10g Release 2 (10.2) for Microsoft Windows
Documentation Library / Getting Started

Regards
Michel

[Updated on: Sun, 15 July 2007 01:58]

Report message to a moderator

Re: Plss Help me, ORA-12560 TNS :Protocol Adapter Error [message #251584 is a reply to message #251578] Sun, 15 July 2007 02:46 Go to previous messageGo to next message
salman4u
Messages: 12
Registered: July 2007
Junior Member
srinivas,

when i am executing lsnrctl status at dos prompt it says 'lsnrctl status' is not recognised as an internal or external command,operable program or batch file,Same with the commands that you have mentioned.

And in control panel there is nothing like "Services and Devices"
Pls srinivas i know i m doing something wrong but pls try to bear with me.I m not able to start still.
Re: Plss Help me, ORA-12560 TNS :Protocol Adapter Error [message #251589 is a reply to message #251584] Sun, 15 July 2007 03:42 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Good luck Srinivas! /forum/fa/940/0/

Regards
Michel
Re: Plss Help me, ORA-12560 TNS :Protocol Adapter Error [message #251598 is a reply to message #251584] Sun, 15 July 2007 06:44 Go to previous messageGo to next message
Frank
Messages: 7901
Registered: March 2000
Senior Member
Get a Windows for dummies book.
Re: Plss Help me, ORA-12560 TNS :Protocol Adapter Error [message #251607 is a reply to message #251578] Sun, 15 July 2007 08:30 Go to previous messageGo to next message
salman4u
Messages: 12
Registered: July 2007
Junior Member
hey srinivas,
now i understood what you meant to say actually i was directly executing those commands from c drive but i have installed it on d drive,anyways-
when i gave lsnrctl status i got the following message.

TNS-12541 : TNS :NO LISTENER
TNS-12560 : TNS :PROTOCOL ADAPTER ERROR
TNS-00511 : NO LISTENER
32-BIT WINDOWS ERROR :2 :NO SUCH FILE OR DIRECTORY
CONNECTING TO <DESCRIPTION=<ADDRESS=<PROTOCOL=TCP><HOST=TAPESHPC><PORT=1521>>>
TNS-12541 : TNS :NO LISTENER
TNS-12560 : TNS :PROTOCOL ADAPTER ERROR
TNS-00511 : NO LISTENER
32-BIT WINDOWS ERROR :2 :NO SUCH FILE OR DIRECTORY



and when i used tnsping tcm -
USED PARAMETER FILES :
D:\ORACLE\NETWORK\ADMIN\SQLNET.ORA

TNS-03505 :FAILED TO RESOLVE NAME

SRINAVAS,
now plss tell me what to do next.Plssssssss
Re: Plss Help me, ORA-12560 TNS :Protocol Adapter Error [message #251652 is a reply to message #251607] Sun, 15 July 2007 22:05 Go to previous messageGo to next message
srinivasocp
Messages: 91
Registered: December 2005
Location: INDIA
Member
Salman,

Don't be panic...where did you give the command lsnrctl status .You install oracle in c: drive or d: drive doesn't matter,lsnrctl status should work when you execute that command in the command propmt.Can you check whether in services, oracle is up or not.

Go to Controlpanel>Administrative Tools>services.
or
Type services.msc in run

Check whether OracleServiceORCL is Running or not.


Thanks
Srini...

[Updated on: Sun, 15 July 2007 23:00]

Report message to a moderator

Re: Plss Help me, ORA-12560 TNS :Protocol Adapter Error [message #251655 is a reply to message #251652] Sun, 15 July 2007 23:20 Go to previous messageGo to next message
Frank
Messages: 7901
Registered: March 2000
Senior Member
Did you actually create a database, or just install the software?
search your filesystem for a file called system.dbf
Re: Plss Help me, ORA-12560 TNS :Protocol Adapter Error [message #251736 is a reply to message #251578] Mon, 16 July 2007 07:04 Go to previous messageGo to next message
salman4u
Messages: 12
Registered: July 2007
Junior Member
hi srinivas,
ya i gave that command and got the same status

TNS-12541 : TNS :NO LISTENER
TNS-12560 : TNS :PROTOCOL ADAPTER ERROR
TNS-00511 : NO LISTENER
32-BIT WINDOWS ERROR :2 :NO SUCH FILE OR DIRECTORY
CONNECTING TO <DESCRIPTION=<ADDRESS=<PROTOCOL=TCP><HOST=TAPESHPC><PORT=1521>>>
TNS-12541 : TNS :NO LISTENER
TNS-12560 : TNS :PROTOCOL ADAPTER ERROR
TNS-00511 : NO LISTENER
32-BIT WINDOWS ERROR :2 :NO SUCH FILE OR DIRECTORY

now what should i do srinivas??

hi frank,
i searched for system.dbf but no file was found!what does that mean?
Re: Plss Help me, ORA-12560 TNS :Protocol Adapter Error [message #251760 is a reply to message #251736] Mon, 16 July 2007 10:16 Go to previous messageGo to next message
DreamzZ
Messages: 1666
Registered: May 2007
Location: Dreamzland
Senior Member
Quote:
i searched for system.dbf but no file was found!what does that mean?


It means go and 1st create database by using DBCA
type DBCA in run and create database.
Re: Plss Help me, ORA-12560 TNS :Protocol Adapter Error [message #251777 is a reply to message #251760] Mon, 16 July 2007 11:14 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
If you also ride this horse, I also wish you a good luck. /forum/fa/940/0/ again

Regards
Michel
Re: Plss Help me, ORA-12560 TNS :Protocol Adapter Error [message #251784 is a reply to message #251578] Mon, 16 July 2007 11:46 Go to previous messageGo to next message
MarcL
Messages: 455
Registered: November 2006
Location: Connecticut, USA
Senior Member
This could get entertaining
Re: Plss Help me, ORA-12560 TNS :Protocol Adapter Error [message #251833 is a reply to message #251777] Mon, 16 July 2007 17:53 Go to previous messageGo to next message
DreamzZ
Messages: 1666
Registered: May 2007
Location: Dreamzland
Senior Member
Michel Cadot wrote on Mon, 16 July 2007 10:14
If you also ride this horse, I also wish you a good luck. /forum/fa/940/0/ again

Regards
Michel


Razz
Re: Plss Help me, ORA-12560 TNS :Protocol Adapter Error [message #252017 is a reply to message #251777] Tue, 17 July 2007 12:31 Go to previous messageGo to next message
salman4u
Messages: 12
Registered: July 2007
Junior Member
Michel Cadot wrote on Mon, 16 July 2007 11:14
If you also ride this horse, I also wish you a good luck. /forum/fa/940/0/ again

Regards
Michel



what horse and pony are you talking about?pls i m a rookie and i m new to oracle pls dont make fun like this if you can't help then atleast dont create nuisance for me.The members who are co-operative with me atleast let them figure out my problem


srinivas what next have i got to do?
Re: Plss Help me, ORA-12560 TNS :Protocol Adapter Error [message #252019 is a reply to message #251578] Tue, 17 July 2007 12:34 Go to previous messageGo to next message
salman4u
Messages: 12
Registered: July 2007
Junior Member
I believe michel,at some point in your life you were also like this so please try to control your silly comments.
Re: Plss Help me, ORA-12560 TNS :Protocol Adapter Error [message #252021 is a reply to message #252019] Tue, 17 July 2007 12:38 Go to previous messageGo to next message
DreamzZ
Messages: 1666
Registered: May 2007
Location: Dreamzland
Senior Member
calm down guy .. be respectful.

When you installed oracle 9i did u create sample schema??

[Updated on: Tue, 17 July 2007 12:39]

Report message to a moderator

Re: Plss Help me, ORA-12560 TNS :Protocol Adapter Error [message #252025 is a reply to message #251578] Tue, 17 July 2007 12:41 Go to previous messageGo to next message
salman4u
Messages: 12
Registered: July 2007
Junior Member
no sample schema but when i install the database version aren't some of the database already created??
like dept,emp??
the only problem i am facing is that the oracle service is not running in my administrative tools/services and i am not able to find a solution to that.No other problem is there!

Can somebody just tell me how to start oracle service?
Re: Plss Help me, ORA-12560 TNS :Protocol Adapter Error [message #252029 is a reply to message #252025] Tue, 17 July 2007 12:46 Go to previous messageGo to next message
DreamzZ
Messages: 1666
Registered: May 2007
Location: Dreamzland
Senior Member
Quote:
no sample schema but when i install the database version aren't some of the database already created??


No you should check the sample schema option during installation.

Quote:
like dept,emp??


No

Quote:
he only problem i am facing is that the oracle service is not running in my administrative tools/services and i am not able to find a solution to that.No other problem is there!


Whats your Sid name?? right cilck and start it.

Quote:

Can somebody just tell me how to start oracle service?


If you dont have database its useless.


Create database before starting service.


Use DBCA For database creation.

In run dialog type DBCA and create database with sample schema then emp and dept would be there.
Re: Plss Help me, ORA-12560 TNS :Protocol Adapter Error [message #252032 is a reply to message #252019] Tue, 17 July 2007 12:56 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Did you read the documentation I posted?
Of course, no!

No, I never was like you.
I always follow the advice of my seniors.
When I was a kid, didn't know a word and ask my father what it means, you know what? My dad gave me the dictionary, that's all.
Now not only I know what the word means but I know how to find the meaning of ANY word.

If you read the doc I posted you will now know much more than you do when some try (and fail) to explain you something when you don't know the basics.

It took me just one post from you to know that this will be an endless topic.
Read the basics, understand the basics, learn the basics then you can go further.
Until you do that, it will be useless to try to explain you something.
Maybe today, tomorrow, in a week or a month, DreamzZ will come that you start your database (by the way do you have one?) but you will still not understand why and next time you will come back here with the same problem.

Regards
Michel
Re: Plss Help me, ORA-12560 TNS :Protocol Adapter Error [message #252034 is a reply to message #251578] Tue, 17 July 2007 12:56 Go to previous messageGo to next message
salman4u
Messages: 12
Registered: July 2007
Junior Member
wow DreamzZ what to say man!!!
you are just gr888 you solved my problem database was only missing silly me!!Mad

thank you sir,hats off to you..
i know it was a minor problem but i m new and i wasnt understanding what the members here are talking about!!
thank you again

best regards,
Salman
Re: Plss Help me, ORA-12560 TNS :Protocol Adapter Error [message #252036 is a reply to message #252032] Tue, 17 July 2007 12:58 Go to previous messageGo to next message
salman4u
Messages: 12
Registered: July 2007
Junior Member
Michel Cadot wrote on Tue, 17 July 2007 12:56
Did you read the documentation I posted?
Of course, no!

No, I never was like you.
I always follow the advice of my seniors.
When I was a kid, didn't know a word and ask my father what it means, you know what? My dad gave me the dictionary, that's all.
Now not only I know what the word means but I know how to find the meaning of ANY word.

If you read the doc I posted you will now know much more than you do when some try (and fail) to explain you something when you don't know the basics.

It took me just one post from you to know that this will be an endless topic.
Read the basics, understand the basics, learn the basics then you can go further.
Until you do that, it will be useless to try to explain you something.
Maybe today, tomorrow, in a week or a month, DreamzZ will come that you start your database (by the way do you have one?) but you will still not understand why and next time you will come back here with the same problem.

Regards
Michel



hey michel what weeks months years and light years r u talking abt??i did it just now within 5 mins becoz dreamz explained me nicely
Re: Plss Help me, ORA-12560 TNS :Protocol Adapter Error [message #252037 is a reply to message #251578] Tue, 17 July 2007 13:01 Go to previous messageGo to next message
salman4u
Messages: 12
Registered: July 2007
Junior Member
and michel another thing is that if i had to read the whole of the document why would i come to the experienced people here with big mind??
by the way my lectures are started in college and i dont have that much time to read these 150-200 pages just for the sake of starting oracle!
i have other subjects too to concentrate upon!
Re: Plss Help me, ORA-12560 TNS :Protocol Adapter Error [message #252048 is a reply to message #252037] Tue, 17 July 2007 13:18 Go to previous message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Well, it's up to you.
I prefer to be the one that knows or knows how to know by himself.
You prefer to be the one that asks.

Regards
Michel
Previous Topic: Unable to start the Oracle service in Windows
Next Topic: Pls help: Cannot create listener TNS-04415
Goto Forum:
  


Current Time: Thu Mar 28 14:56:38 CDT 2024