ORA-12154: TNS:could not resolve service name

[hdamis]

Dear,
I publish web site on IIS 6, OS windows server 2003+sp1, and it works perfectlly but after period of time the web gave me this massage ORA-12154: TNS:could not resolve service name
I looked at event viwer and found this :
"
Event Type: Warning
Event Source: ASP.NET 2.0.50727.0
Event Category: Web Event
Event ID: 1309
Date: 26/06/2006
Time: 09:04:34 ?
User: N/A
Computer: WEBSMS
Description:
Event code: 3005
Event message: An unhandled exception has occurred.
Event time: 6/26/2006 9:04:34 AM
Event time (UTC): 6/26/2006 7:04:34 AM
Event ID: 08b5d066a4a44124a3c488150cc8edae
Event sequence: 8032
Event occurrence: 1267
Event detail code: 0

Application information:
Application domain: /LM/W3SVC/392241321/ROOT/asusms-1-127957089436406250
Trust level: Full
Application Virtual Path: /asusms
Application Path: D:\asusms8080\asusms\
Machine name: WEBSMS

Process information:
Process ID: 2600
Process name: w3wp.exe
Account name: NT AUTHORITY\NETWORK SERVICE

Exception information:
Exception type: OleDbException
Exception message: ORA-12154: TNS:could not resolve service name

Request information:
Request URL:

http://localhost:8080/asusms/asusms.aspx

Request path: /asusms/asusms.aspx
User host address: 127.0.0.1
User:
Is authenticated: False
Authentication Type:
Thread account name: NT AUTHORITY\NETWORK SERVICE

Thread information:
Thread ID: 5
Thread account name: NT AUTHORITY\NETWORK SERVICE
Is impersonating: False
Stack trace: at System.Data.OleDb.OleDbConnectionInternal..ctor(OleDbConnectionString constr, OleDbConnection connection)
at System.Data.OleDb.OleDbConnectionFactory.CreateConnection(DbConnectionOptions options, Object poolGroupProviderInfo, DbConnectionPool pool, DbConnection owningObject)
at System.Data.ProviderBase.DbConnectionFactory.CreateNonPooledConnection(DbConnection owningConnection, DbConnectionPoolGroup poolGroup)
at System.Data.ProviderBase.DbConnectionFactory.GetConnection(DbConnection owningConnection)
at System.Data.ProviderBase.DbConnectionClosed.OpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory)
at System.Data.OleDb.OleDbConnection.Open()
at ASUsmsps.asusms.yyt() in d:\asusms8080\asusms\asusms.aspx.cs:line 357
at ASUsmsps.asusms.Page_Load(Object sender, EventArgs e) in d:\asusms8080\asusms\asusms.aspx.cs:line 30
at System.Web.Util.CalliHelper.EventArgFunctionCaller(IntPtr fp, Object o, Object t, EventArgs e)
at System.Web.Util.CalliEventHandlerDelegateProxy.Callback(Object sender, EventArgs e)
at System.Web.UI.Control.OnLoad(EventArgs e)
at System.Web.UI.Control.LoadRecursive()
at System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)


Custom event details:

For more information, see Help and Support Center at

http://go.microsoft.com/fwlink/events.asp.

"
even I could ping to the server and could tnsping80
Please if any one know any thing about this please help.

 

[Turkbear]

Hi,
( What version of Oracle?)

Tnsping only shows that the listener is up and running - it does not indicate anything about the database instance ( the service name) itself..

First, be sure you can do the tnsping on the web server.

If you can, try using SqlPlus to connect to that instance..

If you have a DBA ( or you are one) check the status of the instance by connecting as sysdba ( if you are using tnsping80 , you must be on an older version of Oracle - so you may need to use the connect as dba instead)





To Paraphrase:"The Help you get is proportional to the Help you give.."

 

[hdamis]

thanks,
but the DB is up,the connection is up, and the web server is works good for a period of time and after that the connection lost but when I restart the server or when I run w3wp.exe (it is IIS file located in system32)and end it via windows task manager. the web server again works.

 

[Turkbear]

Hi,
Look in the Event Log for any error messages regarding the w3wp.exe or OracleHTTP processes..

Do you have both IIS and OracleHTTP running on the same server..that sometimes can cause issues..




To Paraphrase:"The Help you get is proportional to the Help you give.."