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: William Dong <William_Dong_at_nylim.com>
Date: Wed, 09 May 2001 12:37:01 -0700
Message-ID: <F001.002FE59F.20010509123638@fatcity.com>

Did you check the control panel/services? Is the OracleServiceSID stared?

|--------+----------------------->

| | "Michael |
| | Netrusov" |
| | <mn_at_g-fax.com|
| | > |
| | |
| | 05/09/01 |
| | 03:56 PM |
| | Please |
| | respond to |
| | ORACLE-L |
| | |
|--------+-----------------------> >-----------------------------------------------------| | | | To: Multiple recipients of list ORACLE-L | | <ORACLE-L_at_fatcity.com> | | cc: (bcc: William Dong/New York Life Asset| | Management) | | Subject: Re: ORA-12560: TNS Protocol | | Adapter error | >-----------------------------------------------------|

Helmut,

check: Doc ID: Note:124140.1
Type: BULLETIN
Status: PUBLISHED

on Metalink.

HTH,
Michael Netrusov
www.atelo.com

> Hi there!
>
> I'm getting the weird ORA-12560: TNS Protocol Adapter error on 8.1.6 on
> Win2k (fresh install).
>
> I created the database creation scripts and now want to run them. I can
> create the Oracle service with ORADIM, but when I try to connect to the
> database in NOMOUNT stage (as internal) through svrmgrl or sqlplus, I get
> the ORA-12560.
>
> I checked the messages concerning that topic that have been posted on this
> list some time ago and I followed all the recommendations, but it is still
> not working...
>
> I set oracle_sid=sid in my shell. I set the oracle_sid in the environment
> tab of "my computer".
> Then I added tns_admin to the registry.
>
> Any other idea what could be wrong?
>
> FYI: I had trouble installing the listener, so I added a second listener.
> But I can't start up the listener through lsnrctl... It says "starting
> listener" and then it hangs... But I can start the listener through the
> services control panel.
>
> Weird...
>
> This is 8.1.6 on Win2k.
>
> 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).

--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Michael Netrusov
  INET: mn_at_g-fax.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).




-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: William Dong
  INET: William_Dong_at_nylim.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 Wed May 09 2001 - 14:37:01 CDT

Original text of this message

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