Re: ORA 12509/12539/12533

From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: Thu, 27 Jun 2002 19:17:28 +0200
Message-ID: <60imhu8jfsf7l8lrknja0nlevgs5ga3rvi@4ax.com>

On 27 Jun 2002 05:56:55 -0700, enivaldo_at_cptec.inpe.br (Enivaldo Freire) wrote:

>We have an Oracle 7.1.6.2 instance, with Sqlnet 2.1.6.1 listener.
>Local connections are OK, but remote connections get the message
>ORA-12509 (listener failed to redirect client to server handler).
>
>When trace was set to admin, the first remote connection was OK
>(for example with Sqlplus, we can query the database normally),
>but the subsequent ones got the same error. The messages were:
>
>TNS-12509: TNS:listener failed to redirect client to service handler
> TNS-12539: TNS:buffer over- or under-flow
> TNS-12533: TNS:illegal ADDRESS parameters
>
>When trace was set to user, the first TWO remote connections
>were OK, but again the subsequent ones got those error.
>This pattern seems to repeat!
>
>Apparently the configuration files are OK (tnsnames.ora,
>sqlnet.ora)
>
>Any information welcome.
>
>Enivaldo

You are using 8 year old software, which has been desupported in the previous century.
Oracle in the meantime has removed *all* traces of Oracle 7 from it's support site.
I very much doubt whether there is any other alternative than to try to leave the Stone Age, by upgrading to something supported.

Regards

Sybrand Bakker, Senior Oracle DBA

To reply remove -verwijderdit from my e-mail address Received on Thu Jun 27 2002 - 12:17:28 CDT