[sri_b6]

I am not able to connect to Oracle 9i from myeclipse database browser.
I am getting error network adapter could not establish connection

I used jar oraclehome\jdbc\lib\ojdbc14.jar

connection url is jdbc:oracle:thin:@localhost:sid where sid is SID.

error log

!ENTRY com.genuitec.eclipse.sqlexplorer 4 4 2006-06-15 09:49:20.718
!MESSAGE Error while trying to login to database
!STACK 0
java.sql.SQLException: Io exception: The Network Adapter could not establish the connection
at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:134)
at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:179)
at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:333)
at oracle.jdbc.driver.OracleConnection.<init>(OracleConnection.java:404)
at oracle.jdbc.driver.OracleDriver.getConnectionInstance(OracleDriver.java:468)
at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:314)
at net.sourceforge.squirrel_sql.fw.sql.SQLDriverManager.getConnection(SQLDriverManager.java:99)
at com.genuitec.eclipse.sqlexplorer.actions.LoginProgress$Login.run(LoginProgress.java:43)
at java.lang.Thread.run(Unknown Source)

configuration summary

*** Date: Thu Jun 15 10:19:08 EDT 2006

*** System properties:
OS=WindowsXP
OS version=5.1
Java version=1.5.0_07

*** MyEclipse details:
MyEclipse Enterprise Workbench

Version: 4.1.1 GA
Build id: 20060309-4.1.1-GA

*** Eclipse details:
Eclipse SDK

Version: 3.1.2
Build id: M20060118-1600

Eclipse Platform

Version: 3.1.2
Build id: M20060118-1600

Eclipse RCP

Version: 3.1.2
Build id: M20060118-1600

Eclipse Java Development Tools

Version: 3.1.2
Build id: M20060118-1600

Eclipse Plug-in Development Environment

Version: 3.1.2
Build id: M20060118-1600

Eclipse Project SDK

Version: 3.1.2
Build id: M20060118-1600

Eclipse startup command=-os
win32
-ws
win32
-arch
x86
-launcher
C:\eclip\eclipse-SDK-3.1.2-win32\eclipse\eclipse.exe
-name
Eclipse
-showsplash
600
-exitdata
c84_38
-vm
C:\jdk1.5\bin\javaw.exe

[Haris Peco]

sri_b6 ,

The Network Adapter could not establish the connection

This error mean obvious that your database or network listener isn’t started – it can be error in url (bad IP address or SID/port/database name)

Check double url and ask your DBA if database/listener are started

Best regards

[Author]

Posts