Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: NT 4.0 TNS problem
Yeah it's a bug.
You have to manually edit listener.ora like this
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = ORCL)
)
(SID_DESC =
(SID_NAME = SID1)
)
(SID_DESC =
(SID_NAME = SID2)
)
(SID_DESC =
(SID_NAME = SID3)
)
(SID_DESC =
(SID_NAME = SID4)
)
)
the ISD's 1,2,3 have to be done manually.
Did you know that you have to buy "Bronze" supporu before they let you report this bug!
Signed,
"still annoyed with Oracle"
Mark Wagoner <mwagoner_at_iac.net> wrote in article
<5dfaku$hca_at_cheyenne.iac.net>...
> lally_at_mail.sep.bnl.gov wrote:
>
> >I downloaded the NT Workgroup server demo from www.oracle.com and got
> >the starter orcl database up and running. My problem is I can't
> >TNSPING the system from any other client. I can TNSPING remote
> >servers from the new NT server which indicates to me that the TNS
> >is working. The server manager shows the OracleTNS service is up
> >and running.
> >Anyone know the secret of getting the listener to work for the NT 4.0
> >workgroup server? The error returned by tnsping on the client is:
> >TNS-12451: TNS:no listener
> >Thanks in advance.
> >Keith Lally
> >lally_at_bnl.gov
>
> Keith,
>
> It sounds like you might be trying to ping using the wrong protocol. Use
> the Oracle Installer to check which protocol adapters are loaded. You
also
> might want to go into Control Panel/Services and make sure the
> OracleTNSListener service is running.
>
> --
> Mark Wagoner
> mwagoner_at_iac.net
>
>
Received on Fri Feb 07 1997 - 00:00:00 CST