| Plss Help me, ORA-12560 TNS :Protocol Adapter Error [message #251578] |
Sun, 15 July 2007 01:07  |
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  |
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 #251584 is a reply to message #251578] |
Sun, 15 July 2007 02:46 |
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 #251607 is a reply to message #251578] |
Sun, 15 July 2007 08:30 |
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 |
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 #251736 is a reply to message #251578] |
Mon, 16 July 2007 07:04 |
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 #252025 is a reply to message #251578] |
Tue, 17 July 2007 12:41 |
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 |
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.
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 |
 |
Michel Cadot
Messages: 68732
Registered: March 2007
Location: Saint-Maur, France, https...
|
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 #252036 is a reply to message #252032] |
Tue, 17 July 2007 12:58 |
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 |
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!
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
