0

I'm getting this error when I connect to oracleXe 11.2 from squirrel

java.util.concurrent.ExecutionException: java.lang.RuntimeException: java.sql.SQLException: Io exception: Connection refused(DESCRIPTION=(TMP=)(VSNNUM=186647040)(ERR=12505)(ERROR_STACK=(ERROR=(CODE=12505)(EMFI=4))))

mmmmmm
  • 32,227
  • 27
  • 88
  • 117
user2328677
  • 3
  • 2
  • 1
    Try searching for ora-12505 and get your connection details fixed. The SID for an XE Database is mostly xe. – mistapink Apr 28 '13 at 08:50

1 Answers1

0

If you look for ORA-12505 you will find that the message behind this number is that you SID in the connection descriptor is incorrect. This can have several reasons. The standard SID for an XE database is XE unless you did not change any of the listener.ora or tnsnames.ora. If you are able to connect to the database with SQL Developer or SQLPlus properly you should probably check the connection details you provided to Squirrel and edit them accordingly.

mistapink
  • 1,926
  • 1
  • 26
  • 37
  • but i want to know how to fix this ,so please post the details if you have? – user2328677 Apr 28 '13 at 10:05
  • Sorry, I don't know Squirrel. Somewhere you have to configure as which user you want to connect to which database. You can find some information here http://www.rgagnon.com/javadetails/java-0112.html (Connect to Oracle via JDBC) and here http://sourceforge.net/apps/trac/squirrel-sql/wiki/GettingStarted (Connect with Squirrel to a database). – mistapink Apr 28 '13 at 13:43
  • i resolved this issue by taking the help from this site:---- http://sourceforge.net/apps/trac/squirrel-sql/wiki/GettingStarted ,so might be this site will helpfull to others who face the same issue .i deeply thanks to you for your quick reply. – user2328677 Apr 28 '13 at 16:30