Re: Strange problem with sqlplus on Win2K and Oracle 9i

From: jacob nikom <jacob_nikom_at_ieee.org>
Date: 6 Nov 2001 08:42:33 -0800
Message-ID: <6eebd424.0111060842.1e854060@posting.google.com>

Hi Sybrand,

Thank you for your response. As I mentioned the log file sqlnet.log was created by Oracle, when sqlplus crushed. Here it is:

---

Fatal NI connect error 12560, connecting to:  (DESCRIPTION=(ADDRESS=(PROTOCOL=BEQ)(PROGRAM=oracle)(ARGV0=oracleORCL)(ARGS='(DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))'))(CONNECT_DATA=(SID=ORCL)(CID=(PROGRAM=C:\Jacob\Work\Java\Databases\Oracle\9i\bin\sqlplusw.exe)(HOST=JNIKOM_WS)(USER=JNikom))))

  VERSION INFORMATION:

	TNS for 32-bit Windows: Version 9.0.1.1.0 - Production
	Oracle Bequeath NT Protocol Adapter for 32-bit Windows: Version

9.0.1.1.0 - Production
  Time: 01-NOV-2001 18:31:21
  Tracing not turned on.
  Tns error struct:
    nr err code: 0
    ns main err code: 12560
    TNS-12560: TNS:protocol adapter error     ns secondary err code: 0
    nt main err code: 530
    TNS-00530: Protocol adapter error
    nt secondary err code: 126
    nt OS err code: 0

---

Oracle manual characterises the error as following:

ORA-12560: TNS:protocol adapter error

Cause: A generic protocol adapter error occurred.

Action: Check addresses used for proper protocol specification. Before reporting this error, look at the error stack and check for lower
level transport errors.For further details, turn on tracing and reexecute
the operation. Turn off tracing when the operation is complete.

How I can see the error stack?
How to turn on tracing?

One thing which amazes me is that the program actually worked pretty well
for quite a while. Nothing changed on my machine, when it stopped.

Regards,

Jacob Nikom

"Sybrand Bakker" <postbus_at_sybrandb.demon.nl> wrote in message news:<tue95mqkl7ucb6_at_corp.supernews.com>...
> "jacob nikom" <jacob_nikom_at_ieee.org> wrote in message
> news:6eebd424.0111051521.7ccae6af_at_posting.google.com...
> > Hi,
> >
> > I have strange problem with sqlpus on Win2K and Oracle 9i.
> > My database is on Solaris and I use Oracle client software
> > to connect to the database and run sqlplus.
> >
> > I used to run sqlplus very well for quite a while, but
> > suddently without any changes in my computer it started
> > to produce error message:
> > "sqlplus.exe generated errors and will be closed by Windows.
> > You will need to restart the program.
> >
> > The error log is being created."
> >
> > Interestingly, I am still able to run sqlplus on my server
> > computer (Solaris 5.7) and it works fine. I reinstalled the
> > Oracle client. The Oracle installation went successfully
> > (at least according to the message on the installer), but
> > the sqlplus still produces the same message.
> >
> > Do you know what could be the problem?
> >
> > Any help will be greatly appreciated,
> >
> > Regards,
> >
> > Jacob Nikom
>
> Looks like a problem between Oracle and Win2k and has nothing to do with the
> database per se. Most likely a memory leak.
> If an error log is being created, it is being created by Win2k, by the
> mechanism called drWatson (or anything succeeding drWatson)
> At that point you need to track down that file (in the past it was called
> drwatson..log)
> From there I am afraid it is going to be a Support issue.
>
> Hth
Received on Tue Nov 06 2001 - 10:42:33 CST