Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.tools -> Re: ORA-12570: TNS:packet reader failure

Re: ORA-12570: TNS:packet reader failure

From: TurkBear <noone_at_nowhere.com>
Date: Fri, 18 May 2001 09:35:37 -0500
Message-ID: <ilcagts30v9c11u5k4m9r66uic3vf21app@4ax.com>

If all you entered on the command line was oracle_sid=orcl, you need to use the SET oracle_sid = orcl ( or set an environment variable if that is the only Oracle database instance on the box)

You can also, if that is a local database, connect without a connect string from tnsnames.ora...

cprank_at_yahoo.com wrote:

>I've tried installing 8.1.5 several times on a WIN2000 server and have
>continued to run into a TNS packet reader failure ERROR. This happens
>when the database config assistant is starting the instance for the
>typical install database.
>
>I have verified service name, sid, listener settings via .ora files
>and net8 assistant. I have set via command line oracle_sid=orcl.
>
>The services for 'orcl' and the default listener start with no
>problem, but when I try a db connection test via net8 assistant will
>not work and connection attempts via SQL*Plus yield the same 12570
>error.
>
>Any help would be appreciated.
>
>Charlie_db_down_trodden
Received on Fri May 18 2001 - 09:35:37 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US