• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1219
  • Last Modified:

Oracle based program issue,

Running a program called Infinitime which uses an Oracle daabase.  Hard drive crashed and I had to use a backup and copy the files back to their original location But now i get the following error:

Computer is running Windows 2000 server.

Server Error in '/InfiniTimePunch' Application.
--------------------------------------------------------------------------------

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

Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

Exception Details: System.Data.OracleClient.OracleException: ORA-12514: TNS:listener does not currently know of service requested in connect descriptor


Source Error:

An unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be identified using the exception stack trace below.  

Stack Trace:


[OracleException (0x80131938): ORA-12514: TNS:listener does not currently know of service requested in connect descriptor
]
   System.Data.OracleClient.OracleException.Check(OciErrorHandle errorHandle, Int32 rc) +89
   System.Data.OracleClient.OracleInternalConnection.OpenOnLocalTransaction(String userName, String password, String serverName, Boolean integratedSecurity, Boolean unicode, Boolean omitOracleConnectionName) +688
   System.Data.OracleClient.OracleInternalConnection..ctor(OracleConnectionString connectionOptions) +136
   System.Data.OracleClient.OracleConnectionFactory.CreateConnection(DbConnectionOptions options, Object poolGroupProviderInfo, DbConnectionPool pool, DbConnection owningObject) +37
   System.Data.ProviderBase.DbConnectionFactory.CreatePooledConnection(DbConnection owningConnection, DbConnectionPool pool, DbConnectionOptions options) +28
   System.Data.ProviderBase.DbConnectionPool.CreateObject(DbConnection owningObject) +429
   System.Data.ProviderBase.DbConnectionPool.UserCreateRequest(DbConnection owningObject) +70
   System.Data.ProviderBase.DbConnectionPool.GetConnection(DbConnection owningObject) +510
   System.Data.ProviderBase.DbConnectionFactory.GetConnection(DbConnection owningConnection) +85
   System.Data.ProviderBase.DbConnectionClosed.OpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory) +102
   System.Data.OracleClient.OracleConnection.Open() +34
   winLoginWindow_Page.OkButton_Click(Object sender, ImageClickEventArgs e) +223
   System.Web.UI.WebControls.ImageButton.OnClick(ImageClickEventArgs e) +86
   System.Web.UI.WebControls.ImageButton.RaisePostBackEvent(String eventArgument) +115
   System.Web.UI.WebControls.ImageButton.System.Web.UI.IPostBackEventHandler.RaisePostBackEvent(String eventArgument) +7
   System.Web.UI.Page.RaisePostBackEvent(IPostBackEventHandler sourceControl, String eventArgument) +11
   System.Web.UI.Page.RaisePostBackEvent(NameValueCollection postData) +33
   System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +1746

 


--------------------------------------------------------------------------------
Version Information: Microsoft .NET Framework Version:2.0.50727.1433; ASP.NET Version:2.0.50727.1433  

Here is my Listener.ora  file:

# listener.ora Network Configuration File: F:\Inception\InfiniTime\Ora10\network\admin\listener.ora
# Generated by Oracle configuration tools.

SID_LIST_LISTENER =
  (SID_LIST =
    (SID_DESC =
      (SID_NAME = PLSExtProc)
      (ORACLE_HOME = F:\Inception\InfiniTime\Ora10)
      (PROGRAM = extproc)
    )
  )

LISTENER =
  (DESCRIPTION_LIST =
    (DESCRIPTION =
      (ADDRESS = (PROTOCOL = TCP)(HOST = SERVER3)(PORT = 1521))
      (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0))
    )
  )


Here is my tnsnames.ora:

# tnsnames.ora Network Configuration File: F:\Inception\InfiniTime\Ora10\network\admin\tnsnames.ora
# Generated by Oracle configuration tools.

TCDBS =
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = SERVER3)(PORT = 1521))
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = TCDBS)
    )
  )

EXTPROC_CONNECTION_DATA =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0))
    )
    (CONNECT_DATA =
      (SID = PLSExtProc)
      (PRESENTATION = RO)
    )
  )

I think it is somethink I need to change, but don't know what.




0
gtdidea
Asked:
gtdidea
  • 3
  • 3
  • 2
  • +1
1 Solution
 
Ivo StoykovCommented:
Hello gtdidea
Usually this is caused when      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.
Please try following: 

- 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.


HTH
I
0
 
OMC2000Commented:
Try to add SID description of TCDBS to listener.ora

SID_LIST_LISTENER =
  (SID_LIST =
    (SID_DESC =
      (SID_NAME = PLSExtProc)
      (ORACLE_HOME = F:\Inception\InfiniTime\Ora10)
      (PROGRAM = extproc)
    )
    (SID_DESC =
      (GLOBAL_DBNAME = TCDBS)
      (ORACLE_HOME =  F:\Inception\InfiniTime\Ora10\)
      (SID_NAME = TCDBS)
    )

  )

0
 
gtdideaAuthor Commented:
Here is the info for lsnrctl services:

LSNRTCL FOR 32-BIT Windows: Version 10.2.0.3.0 - Production on 07-NOV-2008 06:02:43

Copyright (c) 1991, 2006, Oracle.  All rights reserved.

Connecting to (Description=(ADDRESS=(PROTOCOL=TCP)(HOST=SERVER3)(PORT=1521)))
Services Summary:
Service "PLSExtProc" has 1 instance(s)
   Instance ""PLSExtProc", status unknown, has 1 handler(s) for this service...
       Handler(s):
           "DEDICATED" established:1 refused:0
                LOCAL SERVER
The command completed successfully

I tried to add SID description of TCDBS to listener.ora as stated above, but still comes up with the error.
0
Veeam Disaster Recovery in Microsoft Azure

Veeam PN for Microsoft Azure is a FREE solution designed to simplify and automate the setup of a DR site in Microsoft Azure using lightweight software-defined networking. It reduces the complexity of VPN deployments and is designed for businesses of ALL sizes.

 
OMC2000Commented:
have you tried to restart listener service? database instance?
0
 
gtdideaAuthor Commented:
Tried both to no avail.
0
 
OMC2000Commented:
well, then I would try to comment out all lines in sqlnet.ora file and remove and create listener again
0
 
Mark GeerlingsDatabase AdministratorCommented:
Your original listener.ora file did not have a manual entry for your database, so it depended on "dynamic" registration.  That can often work, but I liked OMC2000's suggestion to add an explicit entry for your database.  I'm surprised that that didn't work.  Did you add that exactly as he suggested?  Did you stop and restart the listener after doing that?  Did you try this from a DOS window so you could see the error message(s) if any?  The commands are:
lsnrctl stop

Then:
lsnrctl start

(Those both assume you have the default listener name of "LISTENER").

Or, in Windows you can do:
net stop [service_name]

Then:
net start [service_name]

But, I'm not sure if this will show you the errors or not.  To find the exact service name on your system you will have to look it up in the Services applet of the Control Panel.  It will be something like: "Oracle...Listen..".
0
 
Ivo StoykovCommented:
Did you try Net Configuration Assistent
There are test for database and listeners
backup your listener.ora and tnsnames.ora and create new one for listener and database.
HTH
I
0
 
gtdideaAuthor Commented:
Customer found solution on their own.
0

Featured Post

Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

  • 3
  • 3
  • 2
  • +1
Tackle projects and never again get stuck behind a technical roadblock.
Join Now