Q

"Connection reset by peer" error

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.

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.
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 last published in November 2005

Dig Deeper on Oracle database installation, upgrades and patches

PRO+

Content

Find more PRO+ content and other member only offers, here.

Have a question for an expert?

Please add a title for your question

Get answers from a TechTarget expert on whatever's puzzling you.

You will be able to add details on the next page.

Start the conversation

Send me notifications when other members comment.

By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Please create a username to comment.

-ADS BY GOOGLE

SearchDataManagement

SearchBusinessAnalytics

SearchSAP

SearchSQLServer

TheServerSide

SearchDataCenter

SearchContentManagement

SearchFinancialApplications

Close