I have installed Oracle 8i Enterprise on my Windows XP system. I was able to start up the database from svrmgrl and made a new database. Now when I try to connect to it with jsp using jdbc and Oracle thin drivers, I am getting an error, "connection reset by peer." When I type tnsping [sid name] from the dos prompt I get a "packet writer failure" error. Please help me. I am new to Oracle. Thanks in advance.

    Requires Free Membership to View

    Login

This type of error is usually indicative of either a bad network component or a firewall that is not allowing the connection. If you have a firewall, disable it and try connecting again. If this does not resolve the problem, there are a couple of other things to try.

Check that you have a tnsnames.ora file with your service name properly defined.

Try to tnsping the service name. If successful, it should look something like this: 

C:>tnsping oratst01

TNS Ping Utility for 32-bit Windows: Version 10.1.0.2.0 - Production on 09-NOV-2005 21:41:21

Copyright (c) 1997, 2003, Oracle.  All rights reserved.

Used parameter files:
C:oracleproduct10.1.0db_1networkadminsqlnet.ora

Used TNSNAMES adapter to resolve the alias
Attempting to contact (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)
(HOST = C373)(PORT = 1521))) (CONNECT_DATA = (SERVICE_NAME = ORATST01)))
OK (30 msec)
Also, check that the listener is up and that your database has registered with the listener. At the command prompt, type: 
lsnrctl status
You should see output similar to this and your instance registered with the listener: 
C:>lsnrctl status

LSNRCTL for 32-bit Windows: Version 10.1.0.2.0 - Production on 09-NOV-2005 21:43:04

Copyright (c) 1991, 2004, Oracle.  All rights reserved.

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=c373)(PORT=1521)))
STATUS of the LISTENER
------------------------
Alias                     LISTENER
Version                   TNSLSNR for 32-bit Windows: Version 10.1.0.2.0 - Production
Start Date                09-NOV-2005 21:14:43
Uptime                    0 days 0 hr. 28 min. 20 sec
Trace Level               off
Security                  ON: Local OS Authentication
SNMP                      OFF
Listener Parameter File   C:oracleproduct10.1.0db_1networkadminlistener.ora
Listener Log File         C:oracleproduct10.1.0db_1networkloglistener.log

Listening Endpoints Summary...
  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=127.0.0.1)(PORT=1521)))
  (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(PIPENAME=\.pipeEXTPROCipc)))
  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=c373)(PORT=8080))(Presentation=HTTP)(Session=RAW))
  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=c373)(PORT=2100))(Presentation=FTP)(Session=RAW))
Services Summary...
Service "ORATST01XDB" has 1 instance(s).
  Instance "oratst01", status READY, has 1 handler(s) for this service...
Service "PLSExtProc" has 1 instance(s).
  Instance "PLSExtProc", status UNKNOWN, has 1 handler(s) for this service...
Service "oratst01" has 1 instance(s).
  Instance "oratst01", status READY, has 1 handler(s) for this service...
The command completed successfully

This was first published in November 2005

Join the conversationComment

Share
Comments

    Results

    Contribute to the conversation

    All fields are required. Comments will appear at the bottom of the article.
    Back to top