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

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 - Production on 09-NOV-2005 21:41:21

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

Used parameter files:

Used TNSNAMES adapter to resolve the alias
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 - Production on 09-NOV-2005 21:43:04

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

Alias                     LISTENER
Version                   TNSLSNR for 32-bit Windows: Version - 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...
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

There are Comments. Add yours.

TIP: Want to include a code block in your comment? Use <pre> or <code> tags around the desired text. Ex: <code>insert code</code>

REGISTER or login:

Forgot Password?
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
Sort by: OldestNewest

Forgot Password?

No problem! Submit your e-mail address below. We'll send you an email containing your password.

Your password has been sent to: