Re: ORA-12560: TNS: Protocol Adapter Error

How are you ( or your script) trying to connect to Oracle...

Are you using a tnsnames alias , and if so, did you create it correctly ( with Net8 EasyCfg or Configuration assistant ) ?

The 12560 error most often is caused by Sqlnet not knowing how (or where ) to connect ( the protocol is specified in the tnsnames.ora entry )

Try setting an environment variable :
ORACLE_SID=<your tnsnames or service name entry from tnsnames.ora>

user_20017506_at_my-deja.com wrote:

>
>
>After spending several days on this I have come
>to this, a last cry for help...
>
>I am running Window2000 Professional with Oracle
>8i Personal Edition. All was going well in my
>efforts to do some testing on running a script to
>build a database; when all of a sudden I began to
>get this ORA-12560 error message when I (either
>manually or my script) tried to use SQL*Plus or
>Server Manager.
>
>I thought it may have been some of the tinkering
>around I had done, so I went as far as
>uninstalling Oracle, restarting the machine and
>then reinstalling it again; but immediately
>received the same error when trying to open
>svrmgrl or sqlplus in command line mode. I have
>checked all of the related files, listener.ora,
>tnsnames.ora, etc.; and all appear in order or at
>their default values.
>
>I've noticed that on several news groups and
>Oracle sites many people seem to be having this
>same problem - but I never see any answers to
>these posts on the issue....
>
>Any ideas? Or can anyone point to a good site
>which will explain how to read the trace files
>generated by the TNSListener?
Received on Fri Dec 29 2000 - 08:58:59 CST