Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: ORA-12560: TNS: Protocol Adapter Error
Did you start sid service?
Jack
"dbuckingham" <member8912_at_dbforums.com> wrote in message
news:3023190.1056064272_at_dbforums.com...
>
> Firstly thanks for those trying to help!
>
> Ok, as everyone has guessed this is a windows environment, sorry meant
> to put that in. It is windows 2000 running SP2 and Oracle 8.1.7 v3 and
> Oracle 9iAS rel1.
>
> I have been looking at other documentation (including metalink) and
> talking to Oracle them selves on this one. Still no break through on
> it however:
>
> 1. I have checked the registry settings on the machine to make sure that
> the homes have the correct Oracle_sids specified. Comparing the
> affected machine to two other severs that are working, all apears
> correct in this part of the set up (Metalink Note: 119003.1).
>
> 2. COmpared linstener.ora against other servers that are working and all
> appears ok there as well.
>
> SID_LIST_LISTENER =
> (SID_LIST =
> (SID_DESC =
> (SID_NAME = PLSExtProc)
> (ORACLE_HOME = c:\oracle81)
> (PROGRAM = extproc)
> )
> )
>
> 3. TNSPING DB_NAME - work without any problem, both database instances
> can be pinged.
>
>
> 4. Recreated listner.ora. this was restarted by Oracle net8 assistant.
> Still cannot connect to DB via SQL.
>
> OK there is the latest, I am going to run a trace on it later today and
> see if that returns anything. Should I be providing any further
> information?
>
> Thanks.
>
> --
> Posted via http://dbforums.com
Received on Thu Jun 19 2003 - 19:01:13 CDT