DSXchange

chulett · Post by **chulett** » Fri Sep 11, 2009 9:21 am

All I see for the "below error message" is a big red x.

swades · Post by **swades** » Fri Sep 11, 2009 9:43 am

chulett wrote:All I see for the "below error message" is a big red x.

Now...

Check here...

http://i27.tinypic.com/nouhhu.jpg

Thanks

chulett · Post by **chulett** » Fri Sep 11, 2009 9:52 am

OK, never mind, I see the issue - the site you are using to host the image is blocked here. How about just posting the text of the error?

swades · Post by **swades** » Fri Sep 11, 2009 10:00 am

chulett wrote:OK, never mind, I see the issue - the site you are using to host the image is blocked here. How about just posting the text of the error?

Ok Sure ...

EServicesbackbone89531: Cannot connect to the database.

The following error occurred: java.sql.SQLException: [IBM][Oracle JDBC Driver][Oracle]ORA-12505 Connection refused was not recognized by the Oracle server.)

chulett · Post by **chulett** » Fri Sep 11, 2009 10:43 am

Not sure if you've already looked that one up, but...

Code: Select all

$ oerr ORA 12505
12505, 00000, "TNS:listener does not currently know of SID given 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 SID for an instance (usually a database instance) 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 instances are currently known by the listener by executing:
//    lsnrctl services <listener name>
//  - Check that the SID parameter in the connect descriptor specifies
//    an instance known by the listener.
//  - Check for an event in the listener.log file.

swades · Post by **swades** » Fri Sep 11, 2009 10:58 am

I gave SID instead of DB name it is working for me now. :D

Thanks Craig - for your help.

Btw, from where you got this notes.

chulett · Post by **chulett** » Fri Sep 11, 2009 12:31 pm

It's actually an 'Oracle Error' utility called oerr that you can run from your command line. That first line of the code box is me running it.