Home » SQL & PL/SQL » SQL & PL/SQL » ORA-12514: TNS:listener does not currently know of service requested in connect descriptor
icon5.gif  ORA-12514: TNS:listener does not currently know of service requested in connect descriptor [message #238256] Thu, 17 May 2007 04:02 Go to next message
naimish_hit
Messages: 34
Registered: March 2007
Member
Hi,

I have installed Oracle Express Database 10G on linuz server.

I am facing one problem, Sometimes when I try to connect database, it returns following exception:

System.Web.Services.Protocols.SoapException: Server was unable to process request. ---> System.Data.OracleClient.OracleException: ORA-12514: TNS:listener does not currently know of service requested in connect descriptor

  at System.Data.ProviderBase.DbConnectionPool.GetConnection(DbConnection owningObject)
  at System.Data.ProviderBase.DbConnectionFactory.GetConnection(DbConnection owningConnection)
  at System.Data.ProviderBase.DbConnectionClosed.OpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory)
  at System.Data.OracleClient.OracleConnection.Open()
  at SARK.OracleDataAccess.PrepareCommand(OracleCommand command, OracleConnection connection, OracleTransaction transaction, CommandType commandType, String commandText, OracleParameter[] commandParameters) in C:\Temp\OracleLibrary\OracleLibrary\OracleDataAccess.cs:line 88
  at SARK.OracleDataAccess.ExecuteDataset(OracleConnection connection, CommandType commandType, String commandText, OracleParameter[] commandParameters) in C:\Temp\OracleLibrary\OracleLibrary\OracleDataAccess.cs:line 477
  at diabosData.daUserManagment.chkLogin(String strUserName, String strPassword, Boolean& boolStatus, String& strResponse) in C:\DIABOS\Source\diabosData\daUserManagment.cs:line 644
  at UserManagment.authentication(String strUserName, String strPassword, Boolean& boolStatus, String& strResponse) in c:\DIABOS\Source\diabosBusiness\App_Code\UserManagment.cs:line 52
  --- End of inner exception stack trace ---


Note: It automatically starts accepting connection after some delay! Without changing anything on server and in code !

Do you have any idea why its throughing this error ?

Regards,

Naimish R. Dave

[Updated on: Thu, 17 May 2007 04:04]

Report message to a moderator

Re: ORA-12514: TNS:listener does not currently know of service requested in connect descriptor [message #238259 is a reply to message #238256] Thu, 17 May 2007 04:17 Go to previous message
Michel Cadot
Messages: 64121
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
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.

oerr tool is your friend as well as search button and Google.

Regards
Michel
Previous Topic: Sequence in SQL
Next Topic: NOLOCK?
Goto Forum:
  


Current Time: Wed Dec 07 03:16:33 CST 2016

Total time taken to generate the page: 0.13656 seconds