Re: ORA-12560: TNS:protocol adapter error on Win NT w/8i and 9i Databases

Giganews Newsgroups
Subject: Re: ORA-12560: TNS:protocol adapter error on Win NT w/8i and 9i Databases
Posted by:  Brian Peasland (dba@remove_spam.peasland.com)
Date: Wed, 28 Jan 2004

In your DOS window, type the following:

set ORACLE_SID=sid
set ORACLE_HOME=C:\directory_where_Oracle_was_installed

Then try your SQL*Plus stuff.

HTH,
Brian

Brett Baloun wrote:
>
> Hello,
>
> I receive an ORA-12560: TNS:protocol adapter error when I try the
> following:
> sqlplus /nolog
> conn / as sysdba
>
> I currently have 8i installed and working properly on the same
> machine.  I used DBCA to install the new 9i software.  I am now trying
> to connect to sqlplus so I can create the Database.  I am using Remote
> Administrator to work on the machine.  I think I set all of the
> correct parameters on the machine, but is there a document somewhere
> to determine the specific parameters that are necessary?
>
> Any assistance that you can give me would be greatly appreciated.
>
> Thank you - Brett

--
===================================================================

Brian Peasland
dba@remove_spam.peasland.com

Remove the "remove_spam." from the email address to email me.

"I can give it to you cheap, quick, and good. Now pick two out of
the three"

Replies

In response to

ORA-12560: TNS:protocol adapter error on Win NT w/8i and 9i Databases posted by blbalo…@yahoo.com on 28 Jan 2004