Re: ORA-12560:TNS:protocol adapter error

Emily wrote:

> Hello fellows/oracle experts:
>
> I'm a sort newbie or born again in this field. I am describing here
> what Idid:
> I downloaded disk1, disk2, disk3 from the Oracle.com site; I installed
> oracle 9i with few products, but i didn't find or could not download
> anythingfrom disk2 and disk3 downloads files.
>
> ALthough it appears that I've now oracle application development with
> sql plus, but i couldn't access any of the sample data in the oracle, i
> triedwith sys / change-on-install it gives me an error:
> sql: host echo %Oracle_home%; on Windows; ORA-12560:TNS:protocol
> adapter error;
>
> Could u help me to solving this problem
>
> With Best Regards,
>
> Ely
>
> PS:
> disk2 and disk3 however gives me bunch of
> files but none of them seems like executable files or installable files.
> Yes, my operating system is Windows XP.
>
> I don't have code which works now for <metalink>, i wonder if you folks
> could help me in that regards too.
>
> Regards,
>
> Emily Cantwell
Did you build an instance? DId you configure your network communication stack?
And: did you reboot? It looks like your environment settings are not yet known by XP. %oracle_home% would be very basic, and I'm somewhat surprised to see that.

If all of the above is Yes, how did you start sqlplus?  From a command prompt? If so, did you type: set oracle_sid=XXXX
first? XXXX is to be replaced with the SID you gave your instance, a common one would be ORCL - don't know for sure if that's the "standard demo" one in your case.

-- 
Regards, Frank van Bortel