Re: [Squirrel-sql-users] Unable to connect to Oracle DB using Squirrel

[Robert M. <rob...@gm...>]

To echo Stefan's comments, the SID is usually 8 characters or less.  A
service name is typically specified in tnsnames.ora and allows Oracle apps
(such as SQL*Plus) to connect to a remote database.  If you use SQL*Plus to
login to the database as the sys user (or any privileged user 'as sysdba')
and execute the following command:

show parameter DB_NAME;

You should get the correct value to use for the SID.

Rob

On Mon, Mar 5, 2012 at 1:36 PM, Stefan Willinger <ste...@ao...> wrote:

> **
> Hi,
>
> The IOException indicates, that you can't reach the DB-Host.
>
> Try one of the following on a command line:
> * ping hostname
> * telnet hostname portNumber
>
> The telnet must be successfully.
>
> But please, check if you have the right host and SID
>
> *PFNGFD01.ukroi.tesco.org* looks a little bit strange for a SID. Looks
> more like a DB-Hostname as a SID.
>
> Stefan
>
>
>
> Am 2012-03-05 15:55, schrieb hechesspee:
>
> Hi,
> I'm using Squirrel 3.3.0 and Oracle 9i client.
> I configured the Oracle Thin driver by using the ojdbc14.jar in the Extra
> Class Path
>
> Then I configured the alias as below (apart from login details)
>
> jdbc:oracle:thin:UKIRP251:1521:PFNGFD01.ukroi.tesco.org
>
> where  HOST = UKIRP251 and SERVICE_NAME = PFNGFD01.ukroi.tesco.org
>
> However I'm unable to connect and I'm getting the error as -
>
> IO exception. The network adapter could not establish the connection.
>
> Can anyone help me resolve this?
>
> Regards
> Harsha
>
>
>
> ------------------------------------------------------------------------------
> Try before you buy = See our experts in action!
> The most comprehensive online learning library for Microsoft developers
> is just $99.99! Visual Studio, SharePoint, SQL - plus HTML5, CSS3, MVC3,
> Metro Style Apps, more. Free future releases when you subscribe now!
> http://p.sf.net/sfu/learndevnow-dev2
> _______________________________________________
> Squirrel-sql-users mailing list
> Squ...@li...
> https://lists.sourceforge.net/lists/listinfo/squirrel-sql-users
>
>