Re: jdbc:oracle:thin:@

On Mon, 17 Jun 2002 12:31:18 +0200, "Cel" <cefernan_at_capgemini.fr> wrote:

>When trying to run the program below to test the connexion with my database
>(Oracle 9i with W2K),
>i get this error message:
>
>I don't know where the problem is.
>Database is started, and listener too.
>Help needed !
>
>
>
>E:\>java -cp .;E:\oracle\ora90\jdbc\lib\classes111.zip dbAccess
>Exception in thread "main" java.sql.SQLException: Exception d'E/S: The
>Network A
>dapter could not establish the connection
> at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java)
> at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java)
> at oracle.jdbc.driver.OracleConnection.<init>(OracleConnection.java)
> at
>oracle.jdbc.driver.OracleDriver.getConnectionInstance(OracleDriver.java)
> at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java)
> at java.sql.DriverManager.getConnection(DriverManager.java:517)
> at java.sql.DriverManager.getConnection(DriverManager.java:177)
> at dbAccess.main(dbAccess.java:9)
>
>
>Here is the program
>---------------------------------
>import java.sql.*;
>class dbAccess {
> public static void main (String args []) throws SQLException
> {
>
>
> DriverManager.registerDriver (new
>oracle.jdbc.driver.OracleDriver());
>
> Connection conn = DriverManager.getConnection
> ("jdbc:oracle:thin:@bobbyt:1521:basestar", "scott", "tiger");
> // @machineName:port:SID, userid, password
>
> Statement stmt = conn.createStatement();
> ResultSet rset = stmt.executeQuery("select ename from scott.emp");
> while (rset.next())
> System.out.println (rset.getString(1)); // Print col 1
> stmt.close();
>
> }
>}
>
>
>And my TNSNAMES.ORA file :
>-------------------------------------------------------
># TNSNAMES.ORA Network Configuration File:
>E:\oracle\ora90\network\admin\tnsnames.ora
>
># Generated by Oracle configuration tools.
>
>EXTPROC_CONNECTION_DATA =
>
>(DESCRIPTION =
>
>(ADDRESS_LIST =
>
>(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0))
>
>)
>
>(CONNECT_DATA =
>
>(SID = PLSExtProc)
>
>(PRESENTATION = RO)
>
>)
>
>)
>
>
>
>BASESTAR =
>
>(DESCRIPTION =
>
>(ADDRESS_LIST =
>
>(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0))
>
>)
>
>(CONNECT_DATA =
>
>(SID = BASESTAR)
>
>(PRESENTATION = RO)
>
>)
>
>)
>
>
>
>
>
>

Your listener has not been setup to support the tcp protocol on any port.

Hth

Sybrand Bakker, Senior Oracle DBA

To reply remove -verwijderdit from my e-mail address Received on Mon Jun 17 2002 - 12:25:53 CDT