Home » Other » Training & Certification » ORA-12514: TNS:listener does not currently know of service requested in connect descriptor (10g release 10.2.0)
icon7.gif  ORA-12514: TNS:listener does not currently know of service requested in connect descriptor [message #276572] Thu, 25 October 2007 09:22 Go to next message
smsm-kw
Messages: 9
Registered: October 2007
Junior Member
hi all , iam trying to be oracle certified professional ( OCP )
and i setup oracle 10g on my computer,in the login form (iSQLplus) when i enter user name hr and password hr and leave connect identifier empty , the login process success and this phrase show
" HR@orcl ".
the problem is : when i enter in the connect identifier " orcl "
which is my service name , i have this error
ORA-12514: TNS:listener does not currently know of service requested in connect descriptor

I WANT SOME HELP PLEASE , AND I WANT TO KNOW WHAT IS PLSEXTPROC
ALTHOUGH MY SERVICE NAME IS ORCL
Re: ORA-12514: TNS:listener does not currently know of service requested in connect descriptor [message #276604 is a reply to message #276572] Thu, 25 October 2007 10:41 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
I DONT WANT TO REPLY TO PEOPLE YELLING TO GET AN ANSWER.

Regards
Michel
Re: ORA-12514: TNS:listener does not currently know of service requested in connect descriptor [message #276627 is a reply to message #276604] Thu, 25 October 2007 11:40 Go to previous messageGo to next message
smsm-kw
Messages: 9
Registered: October 2007
Junior Member
>>I DONT WANT TO REPLY TO PEOPLE YELLING TO GET AN ANSWER.
>>Michel

first thank you michel for your answer , and iam not yelling to get
an answer and there is no need for your reply Mad
by the way i know the answer of my question
smsm-kw


Re: ORA-12514: TNS:listener does not currently know of service requested in connect descriptor [message #276631 is a reply to message #276627] Thu, 25 October 2007 11:50 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Quote:

by the way i know the answer of my question

And of course it does not come to your mind that you can share it with the community you asked to help you.

Regards
Michel
Re: ORA-12514: TNS:listener does not currently know of service requested in connect descriptor [message #276662 is a reply to message #276631] Thu, 25 October 2007 21:41 Go to previous messageGo to next message
smsm-kw
Messages: 9
Registered: October 2007
Junior Member

i do this because your reaction when i asked my question and its not politeness to answer me by this way "I DONT WANT TO REPLY TO PEOPLE YELLING TO GET AN ANSWER. " Mad

and i will reply the answer if any one interested or have the same problem except you Smile

regards
smsm-kw
Re: ORA-12514: TNS:listener does not currently know of service requested in connect descriptor [message #276664 is a reply to message #276572] Thu, 25 October 2007 22:11 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
Have you noticed the "ignore all messages by this user" link in the upper right corner of of every post?
You'll never know how many folks who regularly answer questions will NEVER see future questions/posts by you.
Re: ORA-12514: TNS:listener does not currently know of service requested in connect descriptor [message #276691 is a reply to message #276627] Fri, 26 October 2007 00:33 Go to previous messageGo to next message
Frank
Messages: 7901
Registered: March 2000
Senior Member
smsm-kw wrote on Thu, 25 October 2007 18:40

>>I DONT WANT TO REPLY TO PEOPLE YELLING TO GET AN ANSWER.
>>Michel

first thank you michel for your answer , and iam not yelling to get
an answer and there is no need for your reply Mad
by the way i know the answer of my question
smsm-kw




Do you know even the basics of net-iquette?
Do you know that posting in all-caps (using only capital letters) is considered yelling/shouting and it is considered to be very rude?

Now reread your initial post.
Re: ORA-12514: TNS:listener does not currently know of service requested in connect descriptor [message #276875 is a reply to message #276572] Fri, 26 October 2007 10:21 Go to previous messageGo to next message
smsm-kw
Messages: 9
Registered: October 2007
Junior Member
iam very sorry a bout what i did , really iam very very sorry
because i did not read the guide and thank you for understanding

and the answer of my question is :
you must use static IP not dynamic IP(DHCP) Razz
Re: ORA-12514: TNS:listener does not currently know of service requested in connect descriptor [message #277039 is a reply to message #276572] Sun, 28 October 2007 03:18 Go to previous message
Arju
Messages: 1554
Registered: June 2007
Location: Dhaka,Bangladesh. Mobile:...
Senior Member

Very silly
Previous Topic: Oracle DBA Training info
Next Topic: Please help me
Goto Forum:
  


Current Time: Fri Mar 29 03:59:35 CDT 2024