Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.tools -> Re: ORA-12570: TNS:packet reader failure
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