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.




gtdideaComputer consultantAsked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

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
gtdideaComputer consultantAuthor 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
Big Business Goals? Which KPIs Will Help You

The most successful MSPs rely on metrics – known as key performance indicators (KPIs) – for making informed decisions that help their businesses thrive, rather than just survive. This eBook provides an overview of the most important KPIs used by top MSPs.

OMC2000Commented:
have you tried to restart listener service? database instance?
0
gtdideaComputer consultantAuthor 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
gtdideaComputer consultantAuthor Commented:
Customer found solution on their own.
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Java App Servers

From novice to tech pro — start learning today.