Home » RDBMS Server » Networking and Gateways » Oracle Database question
icon5.gif  Oracle Database question [message #598691] Wed, 16 October 2013 16:01 Go to next message
mrfixit
Messages: 3
Registered: October 2013
Junior Member
I have an issue that needs to get resolved. I am currently trying to login to a database that uses the newest version of Oracle Database but for some reason I keep on getting the following error message when logging in:

"ORA-12514:TNS: Listener does not currently know of service requested in connect descriptor

Could not login to Oracle"

Here are my questions:

1. What does this error even mean?

2. How would I go about bypassing this error or even fixing it?

I have searched Google for solutions but I have found none.

What would you suggest I do next?

Re: Oracle Database question [message #598693 is a reply to message #598691] Wed, 16 October 2013 16:16 Go to previous messageGo to next message
Lalit Kumar B
Messages: 3174
Registered: May 2013
Location: World Wide on the Web
Senior Member
mrfixit wrote on Thu, 17 October 2013 02:31

"ORA-12514:TNS: Listener does not currently know of service requested in connect descriptor


The error is self explanatory,

ORA-12514:
TNS:listener does not currently know of service requested in connect descriptor

Cause:	 The listener received a request to establish a connection to a database or other service. The connect descriptor received by the listener specified a service name for a service (usually a database service) that either has not yet dynamically registered with the listener or has not been statically configured for the listener. This may be a temporary condition such as after the listener has started, but before the database instance has registered with the listener.

Action:	
- Wait a moment and try to connect a second time.

- Check which services are currently known by the listener by executing: lsnrctl services <listener name>

- Check that the SERVICE_NAME parameter in the connect descriptor of the net service name used specifies a service known by the listener.

- If an easy connect naming connect identifier was used, check that the service name specified is a service known by the listener.

- Check for an event in the listener.log file.


It might be a temporary issue, have a look at this ORA-12514: TNS:listener does not currently know of service
Re: Oracle Database question [message #598694 is a reply to message #598693] Wed, 16 October 2013 16:29 Go to previous messageGo to next message
mrfixit
Messages: 3
Registered: October 2013
Junior Member
Where would the listener.log file be located?
Re: Oracle Database question [message #598695 is a reply to message #598694] Wed, 16 October 2013 16:30 Go to previous messageGo to next message
mrfixit
Messages: 3
Registered: October 2013
Junior Member
How would I even run the lsnrctl services <listener name> command?
Re: Oracle Database question [message #598696 is a reply to message #598691] Wed, 16 October 2013 16:33 Go to previous messageGo to next message
John Watson
Messages: 8922
Registered: January 2010
Location: Global Village
Senior Member
Welcome to the forum. Please read our OraFAQ Forum Guide and please read How to use [code] tags and make your code easier to read

I'm surprised that Googling didn't give suggestions. However, a likely reason is that you haven't started the database instance.
Re: Oracle Database question [message #598698 is a reply to message #598696] Wed, 16 October 2013 16:42 Go to previous messageGo to next message
Lalit Kumar B
Messages: 3174
Registered: May 2013
Location: World Wide on the Web
Senior Member
John Watson wrote on Thu, 17 October 2013 03:03
a likely reason is that you haven't started the database instance.


John,

OP has not provided any details about the OS and DB version. Isn't it a situation that depends on OS? I mean, for example, Windows might work differently than UNIX/Linux. I am sorry if it's a stupid comment, however, I firmly believe it depends on OS.

I am absolutely open for any correction on this.

Regards,
Lalit
icon5.gif  Re: Oracle Database question [message #598716 is a reply to message #598691] Thu, 17 October 2013 00:21 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

You must show what you did when you got the error.
If you did not use SQL*Plus then first try to connect with it with the same connection string, and copy and paste your session here.

Re: Oracle Database question [message #598971 is a reply to message #598691] Mon, 21 October 2013 03:23 Go to previous messageGo to next message
gazzag
Messages: 1118
Registered: November 2010
Location: Bedwas, UK
Senior Member
http://lmgtfy.com/?q=ORA-12514#
Re: Oracle Database question [message #599013 is a reply to message #598695] Mon, 21 October 2013 07:40 Go to previous messageGo to next message
EdStevens
Messages: 1376
Registered: September 2013
Senior Member
mrfixit wrote on Wed, 16 October 2013 16:30
How would I even run the lsnrctl services <listener name> command?


go to the command line prompt of your un-named OS and enter the following

lsnrctl services

After you have typed the above, press the 'enter' key.
Re: Oracle Database question [message #599019 is a reply to message #598694] Mon, 21 October 2013 07:44 Go to previous message
EdStevens
Messages: 1376
Registered: September 2013
Senior Member
mrfixit wrote on Wed, 16 October 2013 16:29
Where would the listener.log file be located?


This would depend on your un-named OS and your un-named version ("the latest version" is meaningless) of Oracle.

However, all operating systems have the capability to search for a file by file name.
Previous Topic: TNS-12537 TNS:connection closed
Next Topic: opiino : Attach Failed due to ORA-12560
Goto Forum:
  


Current Time: Thu Mar 28 21:22:46 CDT 2024