Re: Newbie Question

From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: Mon, 21 Aug 2000 18:55:22 +0200
Message-ID: <966877603.20067.0.pluto.d4ee154e@news.demon.nl>

dbsnmp_status is not the correct command, that is used for the Intelligent Agent only.
You need to use either the status command or the services command. The error tells there is a mismatch between your tnsnames.ora and your listener.ora, or your listener.ora is wrong. Every database has a SID. You seem to have specified in SID in your configuration files that is not available on your server. Post your listener.ora, tnsnames.ora and sqlnet.ora and I will have a look at it.

This is sqlnet error message (all 12xxx numbers are). You can find them in the network troubleshooting guide.
All docs are online at http://technet.oracle.com

Hth,

Sybrand Bakker, Oracle DBA

"Mike Sangray" <msangray_at_glacierbank.com> wrote in message news:RWco5.393$UX6.165659_at_news.uswest.net...
> I am a NEWBIE to Oracle, and am having problems. I have a NetWare 5
server
> and have the 5 user Oracle8 product installed. I am trying to use Kemma
> Software's BridgeTrak help desk software with Oracle and it has not been
> fun. My problem right now is this error message:
>
> ORA-12505: TNS:listener could not resolve SID given in connect descriptor.
>
> I have run lsnctl80 and verified started status with DBSNMP_STATUS. Can
> anyone help??? I am also wondering where I can get some good
documentation
> on error codes like this. All suggestions are welcome, and I greatly
> appreciate your help.
>
> Mike
>
>
Received on Mon Aug 21 2000 - 11:55:22 CDT