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

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_at_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"