Re: jdbc:oracle:thin:@

From: Oleg <oleg_at_vostok.net>
Date: Tue, 18 Jun 2002 10:22:33 +0200
Message-ID: <aemmno$gg1$1@uanet.vostok.net>

I have same problem with Oracle 8.1.7 under Linux(Mandarake 7.0) and I not may find solve.
Please help me...
Java applet write error message: "The Network Adapter could not establish the connection"
I do
lsnrctl status

                          Services Summary...
                          orcl          has 3 service handler(s)
                          PLSExtProc            has 1 service handler(s)
                          orcl          has 1 service handler(s)
                          orcl          has 3 service handler(s)

then
lsnrctl stop
lsnrctl start
lsnrctl status

                        Services Summary...
                          PLSExtProc            has 1 service handler(s)
                          orcl          has 1 service handler(s)

and applet connect to Oracle a 3 times and again error "The Network Adapter could not establish the connection"

As setup listener?

Thanks

"Sybrand Bakker" <postbus_at_sybrandb.demon.nl> wrote in message news:jr5sguk5in5shsou9s6mde8u0fohuq43rk_at_4ax.com...
> 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 Tue Jun 18 2002 - 03:22:33 CDT