View Single Post

   
  #3 (permalink)  
Old 04-08-2008, 11:57 AM
Jim Smith
 
Posts: n/a
Default Re: Connection errors (ORA-12504) from .NET application

In message <45803eef$0$322$e4fe514c@news.xs4all.nl>, What's in a
namespace <xml@ns.com> writes
>
>"ajmastrean" <ajmastrean@gmail.com> schreef in bericht
>news:1166023687.571968.186760@j44g2000cwa.googleg roups.com...
>> Folks,
>>
>> I have the Enterprise Library 2.0 (January 2006), C# .NET, and an
>> Oracle database. I am trying to query the database using the Data
>> Access Application Block (DAAB), but I get an ORA-12504 error. My
>> connection string should be fine, as the
>> DatabaseFactory.CreateDatabase("[dbname]") command runs without error.
>>
>> The connection string is...
>> * * *
>> <add name="[dbname]" connectionString="data
>> source=[dbpath];Server=[serverpath];User
>> ID=[userid];Password=[password];"providerName="System.Data.OracleClient"
>> />

>Note that your SID should be XE and nothing but XE!
>
>

The OP is using the XE client, not necessarily the server.

Can you connect to the database using sqlplus? TNSPING only checks that
the listener knows about the database, not that it is actually
available. The message looks like a listener configuration error.

Can you provide some real values for [dbname], [serverpath]. If
possible, can you run "lsnrctl status" on the server and post the
output. [dbname] etc should match values in the listner configuration


--
Jim Smith
Ponder Stibbons Limited <http://oracleandting.blogspot.com/>
RSS <http://oracleandting.blogspot.com/atom.xml>
Reply With Quote