Re: ORA-12560:TNS:protocol

On 14 Nov 2003 07:10:02 -0800, imelyi2_at_yahoo.com (Emily) wrote:

>Hello fellows/oracle experts:
>
>I'm a sort newbie or born again in this field. I am describing here
>what I did:
>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
>tried with 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
>
>
>At present, I don't have metalink id, i wonder, if someone would
>provide me the code for metalink so that I can download from
>metalink, if the didk2 and disk3 are i donloaded from oracle.com are
>corrupt. Thank you
>
>help help me
>
>Ely
>imelyi2_at_yahoo.com

The correct syntax to connect to an oracle database is <usrname>/<password>@servicename.
If you don't use the servicename syntax AND don't have ORACLE_SID set you'll get ORA-12560.
How to set it up correct is described in your Oracle Getting Started Manual, which you hopefully read before posting this, but probably didn't.

As to your request to 'borrow' someone's Metalink account: I don't see why anyone would give away access to something he pays for. Also, on Metalink you can only download patches and upgrades NOT the full products.
The zips on otn are NOT corrupt, you should download them using GetRight, or a different download manager when this occures.

--
Sybrand Bakker, Senior Oracle DBA