Re: can no longer connect

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

One other thing. Wanted to put up my server config files if you don't mind to see if they are ok. I believe everything is ok, but didn't want to completely rule out my end till I was sure.

Basically I can connect using SQL*PLUS from my NT box to the Sun Oracle Server. I can also connect to the database telneted into the Sun box and using sqlplus user/pass_at_k5ent1 and it works. The clients usually connect using a string of user/pass_at_12.34.56.7:1521:k5ent1. At least that's what is placed in the connect string on the client's config.

Anyway, here's the info.

Listener.ora:

# LISTENER.ORA Configuration
File:/home/oracle8i/u01/app/oracle/product/8.1.5/network/ad min/listener.ora
# Generated by Oracle Net8 Assistant

LISTENER =

        (ADDRESS_LIST =
                (ADDRESS =
                        (PROTOCOL = TCP)
                        (Host = 12.34.56.7)
                        (Port = 1521)
                )
        )

STARTUP_WAIT_TIME_LISTENER = 0
CONNECT_TIMEOUT_LISTENER = 10
TRACE_LEVEL_LISTENER = ADMIN
SID_LIST_LISTENER =

        (SID_LIST =
                (SID_DESC =
                        (SID_NAME = k5ent1)
                )
                (SID_DESC =
                        (SID_NAME = k5ent2)
                )
                (SID_DESC =
                        (SID_NAME = k5ent3)
                )
        )

tnsnames.ora:

# TNSNAMES.ORA Configuration
File:/home/oracle8i/u01/app/oracle/product/8.1.5/network/admin/tnsnames.ora # Generated by Oracle Net8 Assistant

EXTPROC_CONNECTION_DATA.JOE.COM =
  (DESCRIPTION =
(ADDRESS_LIST =

      (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0))     )
(CONNECT_DATA =

      (SID = PLSExtProc)
      (PRESENTATION = RO)

    )
  )

K5ENT1.JOE.COM =
  (DESCRIPTION =
(ADDRESS_LIST =

      (ADDRESS = (PROTOCOL = TCP)(HOST = 12.34.56.7)(PORT = 1521)) )
(CONNECT_DATA =

      (SERVICE_NAME = k5ent1)
    )
  )

K5ENT2.JOE.COM =
  (DESCRIPTION =
(ADDRESS_LIST =

      (ADDRESS = (PROTOCOL = TCP)(HOST = 12.34.56.7)(PORT = 1521)) )
(CONNECT_DATA =

      (SERVICE_NAME = k5ent2)
    )
  )

K5ENT3.JOE.COM =
  (DESCRIPTION =
(ADDRESS_LIST =

      (ADDRESS = (PROTOCOL = TCP)(HOST = 12.34.56.7)(PORT = 1521)) )
(CONNECT_DATA =

      (SERVICE_NAME = k5ent3)
    )
  )

On Wed, 12 Jul 2000 14:50:02 -0400, Walter T Rejuney <BlueSax_at_Unforgetable.com> wrote:

>"Steve ." 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.
>
>Someone either changed the tnsnames.ora on the client or the
>listener.ora file on the server.
>
>Are you able to connect with sqlplus on the server? That means the
>database is up.
>
>Are you able to tnsping the service name? If so, it means that the
>listener is configured for that service name.
>
>Can you connect with sqlplus on the client using the service name? If so
>then the problem is in your client application.

Received on Wed Jul 12 2000 - 00:00:00 CDT