Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Re: ORA-12560 TNS: protocol adapter error

Re: ORA-12560 TNS: protocol adapter error

From: Muthaiah <cvmuthaiah_at_yahoo.com>
Date: Mon, 23 Apr 2001 19:08:57 -0700
Message-ID: <F001.002EFD1A.20010423190022@fatcity.com>

Hi,

You have to set the oracle_sid in the path and the sid_name in the value in the environment tab of my computer. Once you set this you won't get the error. Alternatively you can set the same in the registry as well.

Hope this helps,

Muthaiah

At 03:30 PM 4/23/01 -0800, you wrote:
>Hi there!
>
>I am on a brandnew box with a brandnew Win2k Server installed on it. Then I
>run the Oracle 8.1.6 installer and then try to create a database (i.e. use
>my batch and SQL files).
>
>When I log into SQLPLUS as internal/oracle, I get an
>
>ORA-12560 TNS: protocol adapter error.
>
>Any idea why? The listener is up and running.
>
>Thanks,
>Helmut
>
>
>
>--
>Please see the official ORACLE-L FAQ: http://www.orafaq.com
>--
>Author: Helmut Daiminger
> INET: hdaiminger_at_vivonet.com
>
>Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
>San Diego, California -- Public Internet access / Mailing Lists
>--------------------------------------------------------------------
>To REMOVE yourself from this mailing list, send an E-Mail message
>to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
>the message BODY, include a line containing: UNSUB ORACLE-L
>(or the name of mailing list you want to be removed from). You may
>also send the HELP command for other information (like subscribing).



Do You Yahoo!?
Get your free @yahoo.com address at http://mail.yahoo.com
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Muthaiah
  INET: cvmuthaiah_at_yahoo.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
Received on Mon Apr 23 2001 - 21:08:57 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US