Re: can no longer connect

From: Steve . <syarbrou_at_nospam.enteract.com>
Date: 2000/07/12
Message-ID: <cqepms0qop03ugbcbdm6qf0147sfbmmc0e@4ax.com>#1/1

Says it's running:

$ ps -A | grep tns

256 ? 0:05 tnslsnr
$ lsnrctl status

LSNRCTL for Solaris: Version 8.1.5.0.0 - Production on 12-JUL-00 13:48:47

Connecting to (ADDRESS=(PROTOCOL=TCP)(Host=123.45.678.9)(Port=1521)) STATUS of the LISTENER

Alias                     LISTENER
Version                   TNSLSNR for Solaris: Version 8.1.5.0.0 -
Production
Start Date                11-JUL-00 18:39:15
Uptime                    0 days 19 hr. 9 min. 32 sec
Trace Level               admin
Security                  OFF
SNMP                      OFF

Listener Parameter File
/home/oracle8i/u01/app/oracle/product/8.1.5/network/admin/listener.ora Listener Log File
/home/oracle8i/u01/app/oracle/product/8.1.5/network/log/listener.log Listener Trace File
/home/oracle8i/u01/app/oracle/product/8.1.5/network/trace/listener.trc Services Summary...

  k5ent1                has 1 service handler(s)
  k5ent2                has 1 service handler(s)
  k5ent3                has 1 service handler(s)

The command completed successfully

On Wed, 12 Jul 2000 17:09:59 GMT, kal121_at_my-deja.com wrote:

>Is your listener up and running? You can start it from lsnrctl.
>
>In article <8o3pms04e46svjs5kipi25gksv3i6tafvu_at_4ax.com>,
> Steve . <syarbrou_at_nospam.enteract.com> wrote:
>> I have an Oracle 8i database running on a Sun box. I can currently
>> and always could get in using SQL*PLUS. We have a third part app that
>> connects behind the scenes to the database and allows clients to work
>> with the software thru Windows. All of a sudden yesterday they could
>> no longer connect. At the end of this message I have the output of
>> the sqlnet.log file. Not sure if it's relevant, Any idea what's
>> going on? The only difference between now and before is I needed most
>> of the drive space for a temporary backup, but there is still a few
>> megs free and the space left is not going down any. Thanks.
>>
>> STeve
>>
>> Newsgroup replies preferred. Remove nospam when replying thru email.
>>
>> ---- snip ----
>>
>> Fatal NI connect error 12545, connecting to:
>>
>> (DESCRIPTION=(ADDRESS=(PROTOCOL=beq)

(PROGRAM=/home/oracle8i/manager/bin/oracle)(ARGV0=o
>> raclek5ent1)(ARGS='(DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))')
(DETACH=NO))(CONNE
>> CT_DATA=(CID=(PROGRAM=)(HOST=joe.sam.com)(USER=oracle8i))))
>>
>> VERSION INFORMATION:
>> TNS for Solaris: Version 8.0.4.0.0 - Production
>> Oracle Bequeath NT Protocol Adapter for Solaris: Version
>> 8.0.4.0.0 - Production
>> Time: 11-JUL-00 18:39:46
>> Tracing not turned on.
>> Tns error struct:
>> nr err code: 12206
>> TNS-12206: TNS:received a TNS error during navigation
>> ns main err code: 12545
>> TNS-12545: Connect failed because target host or object does not
>> exist
>> ns secondary err code: 12560
>> nt main err code: 515
>> TNS-00515: Connect failed because target host or object does not
>> exist
>> nt secondary err code: 2
>> nt OS err code: 0
>>
>> ---- snip ----
>>
>
>
>Sent via Deja.com http://www.deja.com/
>Before you buy.
Received on Wed Jul 12 2000 - 00:00:00 CDT